I wouldn't think, that any of those codes would affect the tranny...
Unfortunately, you would need a good scan tool, like a Tech II, to read transmission data, while the tranny is acting up.....you would need the scan tool attached, and go on a road test, and watch if full line pressure is being applied during shifts...
As for the last three codes, if your air pump works(comes on, on iniitial start up when the coolant temp is low), then the usual problem is the solenoid(has the sensor built into it).....
As for P0171, that is not a good code to ignore.....because, if the O2 sensor reads lean, it causes the PCM to run the engine richer, which is bad for your fuel economy, and can potentially take out your cat......