Engine noise while accelerating then goes away once in overdrive? on 2004 Ford Explorer

Anybody have a fix for this yet

Get Your Car Fixed at a RepairPal Certified Shop.
We certify shops based on expertise, quality work, and verified customer reviews
2 answers
Sure it is the engine making this noise?
what kinda noise. lifters,lower end noise? how is oil level?