During a recent project I needed a database of IATA airport codes. Airports around the world are universally known by a unique three-letter code: the “International Air Transport Association (IATA) Location Identifier”. It is much easier for pilots, travel agents, frequent flyers, baggage handlers and anyone having anything to do with airlines to say and write LGA then the full “New York, NY – La Guardia Airport“.
A sample is shown below.
Airport Code Aalborg, Denmark AAL Aalesund, Norway AES Aasiaat, Greenland JEG Abadan, Iran ABD Abakan, Russia ABA . .
After scouting around for a while I stumbled upon a HTML list at orbitz. To make it usable in PHP I further converted the data to various formats (CSV, SQL, XML) for ease of use. The complete list of files is available below for download. The files contain codes for 3592 international airports sorted by name. This can be useful if your web application needs to convert airport names to their respective IATA codes.
Airport ABCs: An Explanation of Airport Identifier Codes