Code p0171, hesitates and has a rough idle?

Yep, it sounds like you have a cylinder misfire which will cause the P0171 code. Let's remove the spark plugs and do a compression test. Remove all spark plugs and this guide will should you how:

https://www.2carpros.com/articles/how-to-test-engine-compression

Please run down this guide and report back.

Thanks, i will try this out.

But would a bad coil pack cause the system to run too lean? That is what the check engine code is saying for P0171.

Yes, it is for a lean system which a cylinder misfire will cause, 14-1 14 parts air to one part fuel, so 14 parts of air enter the system. Lean

I changed the coils it definitely drives better, but the check engine came back on after a drive and starting it up for a second time.

Still saying engine running too lean but drives good. I don't understand why when i fill up the gas tank the range usually says around 500. Now the system running lean the range is around 380.

After the repair did you clear the codes? and with the problem fixed you must drive a few tanks out so the computer can relearn the range estimate.

I took the negative terminal off before changing the coils which would have cleared it. After i drove it and started it, it came back on and alright i guess i will have to wait a few weeks for that though.

Under the hood even if i drive for 10 minutes it gets really hot, the coolant level keeps going to L. i filled it up the other day but back at L, i don't think its leaking.

We can only answer one subject per post. Please post your new question here, you must be logged in.

https://www.2carpros.com/questions/new

Cheers, Ken

Check engine code says p0171 and suggests reinstalling air duct. I'm getting poor fuel economy, RPMs are accelerating and decelerating poorly, and on short drives my car seems to get really hot quick. Do you think that could be the coolant sensor with code p0171?

P0171 System Too Lean to the overheating problem will not affect this. Have you tried to replace the thermostat?

Here is a generic guide so you can see what you are in for with instructions for your car in the images below:

https://www.2carpros.com/articles/replace-thermostat

And this can help as well:

https://www.2carpros.com/articles/engine-overheating-or-running-hot

Check out the diagrams (below). Please let us know what happens.

I have not changed my thermostat i was stuck between changing the thermostat or coolant sensor. So, do you think the symptoms i am having would be caused more from a faulty thermostat and not a coolant temperature sensor?

It could be either, which is why I wanted to do the thermostat test to see if it has failed.

I did not see what to do with a thermostat test. Do i have to flush out the coolant to replace it or can i just replace it? I know some will shoot out.

When you remove the thermostat, drop it into a pan of boiling water, it should open quickly. Yes, before you begin drain the coolant out of the system to minimize spillage.