Description
Details
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.
Structure
Details
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% |
Others
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 |
Disclaimer: You must understand the following before you download and use this database. eBuisnessGems.com 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 www.eBusinessGems.com. 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. |
Counts
Details
| 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... |
Sample
Details
| 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 |
Tags
Reviews
-
World City Names Database with Latitude and Longitude
$59.00 -
Europe Cities Database with Latitude and Longitude
$19.00 -
UK Cities Database with Latitude and Longitude
$9.00 -
Asia Cities Database with Latitude and Longitude
$19.00 -
Germany Cities and Places Database with Latitude and Longitude
$12.50 -
USA and Canada Cities Database with Latitude and Longitude
$19.00
Payment
