Thank you for shopping with us.
Pls. view cart if you have Coupon.

You have no items in your shopping cart.

You have no items to compare.


World Airport Database with IATA Code, ICAO Code, Latitude and Longitude

  • 15% OFF Everything, Hurry Up!

    Enjoy 15% discount on any purchase till 31 Dec '23. Coupon code: ENJOY

    Discounts, Coupons and Freebies

  • You have Stepped into a World of Data

    Download Quality Database for AI, Simulation and Prediction

    Data, Database, Information and Knowledge

World Airport Database with IATA Code, ICAO Code, Latitude and Longitude

Be the first to review this product


In stock

World Airport Database with IATA Code, ICAO Code, Latitude and Longitude contains records of more than 11,000 airports around the world. The database is available in both Microsoft Excel Spreadsheet and Microsoft Access Database format. A significant number of records also contain information about the elevation or altitude of the airport (above sea level) and length of the airport as well. Please find below more detail about this product.

+ -



World Airport Database with IATA Code, ICAO Code, Latitude and Longitude contains records of more than 11,000 airports around the world. The database is available in both Microsoft Excel Spreadsheet and Microsoft Access Database format. A significant number of records also contain information about the elevation or altitude of the airport (above sea level) and length of the airport as well. Latitude and longitude data is measured in degrees with up to eight decimal places. Elevation and length data is measured in feet. This database contains airports having an IATA (International Air Transport Association) code. Please note that having an IATA code does not necessarily means that it will also have an ICAO (International Civil Aviation Organisation) code.

Difference between IATA and ICAO: As a general rule, IATA has to do with the commercial aspect of Aviation such as timetables, reservations etc. ICAO, on the other hand, has to do with the regulatory, standards, and operational aspects of aviaiton. As a result IATA codes are used for passenger reservation systems, ticketing etc. and ICAO codes are used for operations, flight planing, navigation, etc. IATA is effectively a powerful lobbying body for international air carriers, while ICAO is an inter-governmental organisation which deals with regulatory aspects of national civil aviation. ICAO makes recommendations and sets standards but it has no enforcement powers. ICAO standards are generally followed by national civil aviation authorities.



The airport database has the following columns:

Column Name Description Data Type Column Length Percentage of Rows Populated
A2Z First letter of IATA Code Text 1 100%
IATACode 3 Character IATA Code Text 3 100%
ICAOCode 4 Character ICAO Code Text 4 61%
City City Text 50 99%
CountryISO2 Country ISO2 Code Text 2 97%
Country Country Text 50 97%
StateCode State (US/Canada) Text 2 33%
AirportName Airport Name Text 100 100%
Latitude_deg Latitude in degree (upto 8 decimal places) Number Double 78%
Longitude_deg Longitude in degree (upto 8 decimal places) Number Double 70%
Elevation_ft Elavation of Airport in ft Number Double 57%
Length_ft Length of Airport in ft Number Double 7%
LocationsServed Locations Served Number 100 63%


Additional Information

File Format MS Excel 2003 Spread Sheet, MS Access 2003 Database
Format Details Data is available in two formats - MS Excel 2003 spreadsheet and MS Access 2003 Database. You can of course easily convert the data to CSV or TAB delimited text file from the spreadsheet itself. If you want this data in any other format please send your request to us ([email protected]). Please note that a small fee for data conversion (10% to 30% of the purchase price depending on the data type) may be applicable.
Total Records There are more than 11,000 IATA Airport codes in the database.
File Size 1.5 MB zip file. Around 5 MB when unzipped.
Keywords world, airport, database, iata, icao, codes, code, latitude, longitude, altitude, elevation, length
Key Phrases airport codes, airport iata codes, airport latitude longitude, airport elevation length, world airport codes
Specific Terms and Condition


You must understand the following before you download and use this database. has compiled this database to be used as a repository of relevant information for those who are interested to know but is not responsible for the validity of the content. We can not guarantee our information is accurate or up to date or suitable for any particular purpose.

Terms of Use:

Unauthorized copying, distribution and use of this product is strictly prohibited. You can purchase and download this product only from You can use this product for your own purpose such as research, personal use, as read only content of your website and other similar usage. You are not entitled to resell or redistribute it in its original form and content.

By downloading and using this product it will be deemed confirmed that you have read this specific terms and conditions, understood and fully agreed to it.



Country Airports Count
United States 4307
Australia 594
Canada 558
Papua New Guinea 362
Brazil 300
France 219
China 205
Indonesia 198
United Kingdom 163
Colombia 161
Germany 149
Russian Federation 139
India 127
Japan 106
Argentina 97
Mexico 97
Italy 90
South Africa 87
Philippines 71
Sweden 71
Malaysia 70
Iran 67
Norway 66
Pakistan 62
Madagascar 62
Venezuela 62
New Zealand 61
Spain 60
Democratic Republic Of The Congo 58
Ethiopia 55
Turkey 53
Chile 51
Thailand 48
French Polynesia 46
Solomon Islands 44
Greece 44
Algeria 42
Gabon 42
Mozambique 42
Bahamas 41
Myanmar 40
Iceland 40
Angola 40
Nepal 40
Peru 38
Saudi Arabia 37
Panama 36
Ukraine 36
Marshall Islands 35
Bolivia 35
Kenya 34
Viet Nam 32
Honduras 31
Finland 31
Fiji 31
Namibia 30
Guyana 29
Cuba 29
Vanuatu 29
Tanzania 29
Costa Rica 29
Afghanistan 28
Denmark 28
Egypt 28
Burkina Faso 27
Ecuador 27
Kazakhstan 26
Sudan 26
Greenland 26
Yemen 26
Portugal 25
Congo, Republic of 24
Laos 24
South Korea 24
Mauritania 23
Nigeria 22
Taiwan 22
Zambia 22
Cote D'Ivoire 22
Guatemala 22
Central African Republic 22
Morocco 21
Sri Lanka 21
Kiribati 21
Somalia 20
Cameroon 20
Chad 19
Switzerland 19
Mongolia 19
Poland 18
Belgium 18
Ireland 18
Romania 18
Belize 17
Lesotho 17
Dominican Republic 17
Libya 17
Cambodia 16
Botswana 16
Iraq 16
Bangladesh 16
Liberia 15
New Caledonia 15
Suriname 15
Netherlands 14
Austria 14
Bulgaria 14
Zimbabwe 13
Senegal 13
Uruguay 13
Uganda 13
Mali 13
Israel 13
Paraguay 12
Czech Republic 11
Sierra Leone 11
Uzbekistan 11
Cape Verde 10
Cote D'Ivoire (Ivory Coast) 10
United Arab Emirates 10
Oman 10
Greenland (Denmark) 10
Nicaragua 10
Guinea 10
Malawi 10
Croatia 9
Alaska (U.S.) 9
Serbia 8
Cook Islands 8
Tunisia 8
Cyprus 8
Lithuania 7
Turks And Caicos Islands 7
East Timor 7
Jamaica 7
Syria 7
Republic of Korea 7
Puerto Rico 6
Hungary 6
Estonia 6
Slovakia 6
Benin 6
Belarus 6
Tonga 6
Niger 6
Haiti 6
Guadeloupe 5
NB 5
Ghana 5
Seychelles 5
Jordan 5
Latvia 5
Netherlands Antilles 5
Djibouti 5
Netherlands, Kingdom of the 5
Many other countries Not shown here...



A2Z IATA Code ICAO Code City Country ISO2 Country State Code Airport Name Latitude deg Longitude deg Elevation ft Length ft Locations Served
Y YPM CYPM Pikangikum CA Canada ON Pikangikum Airport 51.81969833 -93.97444457 1114 Pikangikum, Ontario, Canada
Y YPO CYPO Peawanuck CA Canada ON Peawanuck Airport 54.98809814 -85.44512227 171 Peawanuck, Ontario, Canada
Y YPQ CYPQ Peterborough CA Canada ON Peterborough Airport 44.22999954 -78.3633332 628 Peterborough, Ontario, Canada
Y YPR CYPR Prince Rupert/Digby Island CA Canada BC Prince Rupert Airport 54.28609848 -130.4447222 116 Prince Rupert, British Columbia, Canada
9 9G0 Buffalo US United States NY Buffalo Airfield 42.86200306 -78.71658528
9 9G3 Akron US United States NY Akron Airport 43.02108667 -78.48296778
9 9G5 Gasport US United States NY Royalton Airport 43.18200222 -78.55780528
B BBS EGLK Yateley GB United Kingdom Blackbushe Airport 51.32389832 -0.847499818 325 4403 Yateley, Hampshire, England, United Kingdom
B BEB EGPL Benbecula GB United Kingdom Benbecula Airport 57.48109818 -7.36277774 19 5417 Benbecula, Scotland, United Kingdom
B BEQ EGXH Bury St Edmunds GB United Kingdom RAF Honington Airport 52.34260178 0.772939 174 Bury St. Edmunds, England, United Kingdom
B BEX EGUB Benson GB United Kingdom RAF Benson Airport 51.61640167 -1.09583348 226 Benson, Oxfordshire, England, United Kingdom
A ABX YMAY Albury AU Australia Albury Airport -36.06779861 146.9580553 539 Albury, New South Wales, Australia
A ADL YPAD Adelaide AU Australia Adelaide Airport -34.94499969 138.5305555 20 8294 Adelaide, South Australia, Australia
A ADO YAMK Andamooka AU Australia Andamooka Airport -30.43829918 Andamooka, South Australia, Australia
C CCU VECC Calcutta (Kolkata) IN India Netaji Subhas Chandra Bose International Airport 22.65469933 88.44658345 23 Dum Dum (near Kolkata), India
C CDP VOCP Cuddapah IN India Cuddapah Airport 14.51000023 78.7728332 430 Cuddapah, India
C CJB VOCB Coimbatore IN India Coimbatore International Airport 11.02999973 77.04188883 1324 Coimbatore, India
C COH VECO Cooch Behar IN India Cooch Behar Airport 26.33049965 89.4679445 138 Cooch Behar, India


Product Tags

Other people marked this product with these tags:

Use spaces to separate tags. Use single quotes (') for phrases.


  1. Be the first to review this product


Write Your Own Review

Only registered users can write reviews. Please, log in or register