Usage & Publication License: database price dollar sign85.00

Airports Database of 9,436 Airports in 230 Countries

Detailed geographical data and information of 9,436 worldwide airports in 230 countries

database structure screenshot of Airports Database of 9,436 Airports in 230 Countries

Description: This 9,436 airports database is the one you need if you want to quickly find the airport information of any city in 230 countries. Each airport record contains airport name, airport code, runway length and elevation, location city, country abbreviation, airport guide, longitude and latitude, world area code, GMT offset, telephone number, fax, email and their website.

Related DBs:

Database Statistics

  • Size: 2.60 MB
  • Tables: 2
  • Records: 9,436
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
airport 9,436
  1. id
  2. country_id
  3. airport_name
  4. airport_code
  5. runway_length
  6. runway_elevation
  7. city
  8. country_abbreviation
  9. airport_guide
  10. longitude
  11. latitude
  12. world_area_code
  13. gmt_offset
  14. telephone
  15. fax
  16. email
  17. website
country 230
  1. id
  2. title
  3. count
  4. slug

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

country

  • Afghanistan - 27
  • Albania - 1
  • Algeria - 39
  • American Samoa - 4
  • Andorra - 1
  • Angola - 39
  • Anguilla - 1
  • Antarctica - 1
  • Antigua and Barbuda - 2
  • Argentina - 105
  • Armenia - 2
  • Aruba - 1
  • Australia - 622
  • Austria - 14
  • Azerbaijan - 4
  • Bahamas - 42
  • Bahrain - 3
  • Bangladesh - 15
  • Barbados - 1
  • Belarus - 7
  • Belgium - 15
  • Belize - 19
  • Benin - 6
  • Bermuda - 1
  • Bhutan - 1
  • Bolivia - 39
  • Bosnia And Herzegovina - 4
  • Botswana - 16
  • Brazil - 295
  • Brunei Darussalam - 1
  • Bulgaria - 14
  • Burkina Faso - 27
  • Burundi - 3
  • Cambodia - 17
  • Cameroon - 21
  • Canada - 546
  • Cape Verde - 10
  • Cayman Islands - 3
  • Central African Republic - 24
  • Chad - 19
  • Chile - 45
  • China - 196
  • Cocos (Keeling) Islands - 1
  • Colombia - 168
  • Comoros - 5
  • Cook Islands - 9
  • Costa Rica - 28
  • Cote D'Ivoire (Ivory Coast) - 34
  • Croatia (Hrvatska) - 9
  • Cuba - 30
  • Cyprus - 7
  • Czech Republic - 11
  • Democratic People's Republic of Korea - 1
  • Democratic Republic of the Congo - 59
  • Denmark - 23
  • Djibouti - 5
  • Dominica - 2
  • Dominican Republic - 11
  • East Timor - 3
  • Ecuador - 26
  • Egypt - 27
  • El Salvador - 1
  • Equatorial Guinea - 2
  • Eritrea - 4
  • Estonia - 6
  • Ethiopia - 58
  • Falkland Islands (Malvinas) - 2
  • Faroe Islands - 1
  • Federated States of Micronesia - 5
  • Fiji - 32
  • Finland - 32
  • France - 149
  • French Guiana - 6
  • French Polynesia - 46
  • Gabon - 42
  • Gambia - 1
  • Georgia - 4
  • Germany - 118
  • Ghana - 5
  • Gibraltar - 1
  • Greece - 46
  • Greenland - 38
  • Grenada - 2
  • Guadeloupe - 10
  • Guam (USA) - 4
  • Guatemala - 21
  • Guinea - 11
  • Guinea-Bissau - 3
  • Guyana - 30
  • Haiti - 6
  • Honduras - 35
  • Hong Kong - 5
  • Hungary - 6
  • Iceland - 39
  • India - 132
  • Indonesia - 210
  • Iran - 71
  • Iraq - 14
  • Ireland - 20
  • Israel - 15
  • Italy - 83
  • Jamaica - 7
  • Japan - 102
  • Jordan - 5
  • Kazakhstan - 25
  • Kenya - 38
  • Kiribati - 21
  • Kosovo - 1
  • Kuwait - 1
  • Kyrgyzstan - 2
  • Laos - 24
  • Latvia - 4
  • Lebanon - 2
  • Lesotho - 17
  • Liberia - 17
  • Libya - 18
  • Lithuania - 5
  • Luxembourg - 1
  • Macau - 1
  • Macedonia - 2
  • Madagascar - 63
  • Malawi - 13
  • Malaysia - 70
  • Maldives - 5
  • Mali - 13
  • Malta - 3
  • Marshall Islands - 36
  • Martinique - 1
  • Mauritania - 22
  • Mauritius - 2
  • Mexico - 94
  • Moldova - 2
  • Monaco - 1
  • Mongolia - 22
  • Montenegro - 4
  • Montserrat - 1
  • Morocco - 26
  • Mozambique - 43
  • Myanmar - 41
  • Namibia - 32
  • Nauru - 1
  • Nepal - 44
  • Netherlands - 16
  • Netherlands Antilles - 6
  • New Caledonia - 16
  • New Zealand - 64
  • Nicaragua - 10
  • Niger - 7
  • Nigeria - 22
  • Niue - 1
  • Norfolk Island - 1
  • Northern Mariana Islands - 3
  • Norway - 60
  • Oman - 10
  • Pakistan - 62
  • Palau - 1
  • Palestine - 2
  • Panama - 40
  • Papua New Guinea - 395
  • Paraguay - 14
  • Peru - 40
  • Philippines - 73
  • Poland - 15
  • Portugal - 23
  • Puerto Rico - 13
  • Qatar - 3
  • Republic of Korea - 28
  • Republic of the Congo - 25
  • Reunion - 2
  • Romania - 19
  • Russian Federation - 148
  • Rwanda - 5
  • Saint Kitts And Nevis - 2
  • Saint Lucia - 2
  • Saint Vincent and the Grenadines - 6
  • Samoa - 5
  • Sao Tome and Principe - 3
  • Saudi Arabia - 35
  • Senegal - 13
  • Serbia - 4
  • Seychelles - 6
  • Sierra Leone - 11
  • Singapore - 3
  • Slovak Republic - 6
  • Slovakia - 1
  • Slovenia - 3
  • Solomon Islands - 42
  • Somalia - 21
  • South Africa - 92
  • Spain - 61
  • Sri Lanka - 22
  • St. Helena - 1
  • St. Pierre and Miquelon - 2
  • Sudan - 25
  • Suriname - 16
  • Swaziland - 1
  • Sweden - 75
  • Switzerland - 11
  • Syria - 7
  • Taiwan - 22
  • Tajikistan - 2
  • Tanzania - 29
  • Tasmania - 1
  • Thailand - 47
  • Tibet, China - 1
  • Togo - 2
  • Tonga - 3
  • Trinidad And Tobago - 2
  • Tunisia - 10
  • Turkey - 58
  • Turkmenistan - 5
  • Turks and Caicos Islands - 7
  • Tuvalu - 1
  • Uganda - 12
  • Ukraine - 36
  • United Arab Emirates - 10
  • United Kingdom - 154
  • United States - 2,342
  • Uruguay - 13
  • US Minor Outlying Islands - 3
  • Uzbekistan - 12
  • Vanuatu - 32
  • Venezuela - 64
  • Viet Nam - 34
  • Virgin Islands (British) - 6
  • Virgin Islands (U.S.) - 6
  • Wallis and Futuna Islands - 2
  • Yemen - 26
  • Zambia - 21
  • Zimbabwe - 13
  • - 0

Miscellaneous

Defects:

  • In table airport, 6,786 records have a runway length.
  • In table airport, 6,834 records have a runway elevation.
  • In table airport, 20 records have an airport guide.
  • In table airport, 9,241 records have a longitude.
  • In table airport, 9,241 records have a latitude.
  • In table airport, 389 records have a fax number.
  • In table airport, 346 records have an email address.
  • In table airport, 799 records have a website URL.

One Payment, Lifetime Updates

This database is being constantly updated with regards to the volume and structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out. You can download the updated version from the Download page by the same credentials we sent to you when you made the purchase, for a lifetime.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries.

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. Which cannot float on water, boat or stone?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.