FlightAware Discussions

IATA airport code and address list

Hi everyone,

I’m trying to compile as complete a list as I can of airports in the USA, and eventually for other parts of the world. I have been scouring the internet for a decent list that includes the IATA code along with city, state, and zip/postal code for each airport. Does anyone know where I can find a CSV/excel parseable file that contains these 4 elements?

Currently, I have a list of ~9,000 airports around the world with latitude and longitude and country codes. I’ve compiled and verified the accuracy of this list by doing a series of queries across several databases and manually updating all airport coordinates that I find are inaccurate. To complete this list I really need to find a list of postal codes and cities and states. Thanks for your help!