International Airport codes download


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.

Download IATA Airport Codes (sql, csv, xml)
Downloads : 7846 / File size : 120 kB

Further Reading:
Airport ABCs: An Explanation of Airport Identifier Codes

This site is a digital habitat of Sameer Borate, a freelance web developer working in PHP, MySQL and WordPress. I also provide web scraping services, website design and development and integration of various Open Source API's. Contact me at metapix[at]gmail.com for any new project requirements and price quotes.

8 Responses

1

Kari

August 29th, 2012 at 9:09 pm

You rock thanks for sharing!

2

Teresa

August 30th, 2012 at 8:52 pm

Thanks a lot for sharing this. Very helpful!

Btw do you have the list of all airline codes?

sameer

August 30th, 2012 at 8:57 pm

Not really, sorry!

4

Rami Kellesly

October 13th, 2012 at 6:12 am

do you have auto complete list for text field.

5

Matt

November 28th, 2012 at 1:13 pm

Thanks for the list. Was very useful!

Just FYI, for anyone who might have issues, I had to make the following quick-fix in the XML:

Dalat, Viet Nam – Lienkhang
DLI

The original entry had an error.

I also added this airport (the only airport that I have personally required, which wasn’t in the list):

Shanghai Hongqiao International
SHA

6

edpichler

January 25th, 2013 at 1:11 pm

Thanks for sharing.
Are you sure this is a complete list? Almost complete?
Where did you get it?

Thanks man!

7

edpichler

January 25th, 2013 at 1:13 pm

Just tested… it’s not complete.
BNU I can’t find.

8

Keith

January 30th, 2013 at 4:03 am

SQL script is very handy, thanks for putting this online.

Your thoughts