Are you looking for a database of airports and other airfields in Excel format for research or to make a website? Here is a database for you:
Download SAMPLE:
Airports-&-Airfields-Database-SAMPLE.xls
Buy FULL database:
This is one of the databases given by an Indian programmer using Python to scrap data from websites for his studies of data analysis and machine learning, in exchange of a database made by me, with permission to sell it via my website. You can open XLS file, save as CSV and import in SQL if needed.
I do not know from which website he sourced data from, but it looks a very comprehensive and accurate database. I transposed data on the below map to show its completeness.
Don’t forget to check other databases made by me (100+ databases).
Data fields included
ID 100%, Ident 100%, Type 100%, Name 100%, Latitude 100%, Longitude 100%, Elevation (ft) 87.33%, Continent 100%, ISO country 100%, Country 100%, ISO region 100%, Region 100%, Municipality 89.67%, Scheduled service 100%, GPS code 74.11%, IATA code 16.58%, Local code 52.24%, Home link 5.43%, Wikipedia link 17.86%, Keywords 17.22%.
Number of airports and airfields by country
Afghanistan (63), Albania (12), Algeria (61), American Samoa (4), Andorra (2), Angola (104), Anguilla (1), Antarctica (27), Antigua and Barbuda (3), Argentina (847), Armenia (13), Aruba (1), Australia (1945), Austria (145), Azerbaijan (35), Bahamas (65), Bahrain (5), Bangladesh (16), Barbados (2), Belarus (54), Belgium (145), Belize (27), Benin (10), Bermuda (3), Bhutan (5), Bolivia (197), Bosnia and Herzegovina (14), Botswana (127), Brazil (4479), British Indian Ocean Territory (1), British Virgin Islands (3), Brunei (2), Bulgaria (136), Burkina Faso (51), Burma (75), Burundi (7), Cambodia (14), Cameroon (35), Canada (2792), Cape Verde (10), Caribbean Netherlands (3), Cayman Islands (3), Central African Republic (46), Chad (37), Chile (474), China (406), Christmas Island (1), Cocos (Keeling) Islands (1), Colombia (706), Comoros (4), Congo (Brazzaville) (53), Congo (Kinshasa) (285), Cook Islands (10), Costa Rica (132), Côte d’Ivoire (26), Croatia (53), Cuba (134), Curaçao (1), Cyprus (12), Czechia (270), Denmark (120), Djibouti (9), Dominica (2), Dominican Republic (39), Ecuador (123), Egypt (69), El Salvador (27), Equatorial Guinea (7), Eritrea (6), Estonia (37), Ethiopia (58), Falkland Islands (39), Faroe Islands (8), Fiji (33), Finland (111), France (861), French Guiana (12), French Polynesia (55), French Southern Territories (4), Gabon (35), Gambia (1), Georgia (28), Germany (953), Ghana (10), Gibraltar (1), Greece (88), Greenland (84), Grenada (3), Guadeloupe (6), Guam (4), Guatemala (53), Guernsey (3), Guinea (16), Guinea-Bissau (7), Guyana (39), Haiti (8), Honduras (158), Hong Kong (9), Hungary (111), Iceland (85), India (342), Indonesia (472), Iran (136), Iraq (75), Ireland (99), Isle of Man (5), Israel (39), Italy (682), Jamaica (24), Japan (233), Jersey (1), Jordan (17), Kazakhstan (127), Kenya (371), Kiribati (22), Kosovo (6), Kuwait (8), Kyrgyzstan (54), Laos (20), Latvia (73), Lebanon (4), Lesotho (33), Liberia (16), Libya (62), Liechtenstein (1), Lithuania (58), Luxembourg (9), Macau (1), Macedonia (15), Madagascar (83), Malawi (29), Malaysia (105), Maldives (13), Mali (31), Malta (7), Marshall Islands (34), Martinique (1), Mauritania (24), Mauritius (4), Mayotte (1), Mexico (1275), Micronesia (6), Moldova (10), Monaco (2), Mongolia (29), Montenegro (7), Montserrat (2), Morocco (35), Mozambique (87), Namibia (247), Nauru (1), Nepal (48), Netherlands (88), New Caledonia (22), New Zealand (212), Nicaragua (32), Niger (23), Nigeria (46), Niue (1), Norfolk Island (1), North Korea (94), Northern Mariana Islands (11), Norway (233), Oman (27), Pakistan (136), Palau (3), Palestinian Territory (4), Panama (71), Papua New Guinea (594), Paraguay (69), Perú (173), Philippines (280), Pitcairn (0), Poland (277), Portugal (211), Puerto Rico (62), Qatar (6), Réunion (2), Romania (57), Russia (1069), Rwanda (8), Saint Barthélemy (1), Saint Helena (2), Saint Kitts and Nevis (2), Saint Lucia (2), Saint Martin (2), Saint Pierre and Miquelon (2), Saint Vincent and the Grenadines (6), Samoa (4), San Marino (2), São Tomé and Principe (4), Saudi Arabia (81), Senegal (17), Serbia (37), Seychelles (16), Sierra Leone (12), Singapore (9), Sint Maarten (1), Slovakia (110), Slovenia (41), Solomon Islands (38), Somalia (29), South Africa (491), South Georgia and the South Sandwich Islands (0), South Korea (1374), South Sudan (46), Spain (440), Sri Lanka (34), Sudan (37), Suriname (51), Swaziland (16), Sweden (226), Switzerland (87), Syria (28), Taiwan (65), Tajikistan (15), Tanzania (207), Thailand (68), Timor-Leste (14), Togo (7), Tokelau (0), Tonga (6), Trinidad and Tobago (3), Tunisia (15), Turkey (124), Turkmenistan (21), Turks and Caicos Islands (8), Tuvalu (3), U.S. Virgin Islands (9), Uganda (37), Ukraine (192), United Arab Emirates (51), United Kingdom (977), United States (22837), United States Minor Outlying Islands (6), Unknown or unassigned country (0), Uruguay (54), Uzbekistan (176), Vanuatu (32), Vatican City (1), Venezuela (592), Vietnam (50), Wallis and Futuna (2), Western Sahara (6), Yemen (25), Zambia (103), Zimbabwe (139).
This is one of the best articles I have read today. It provides me a lot of useful info. Thank you so much.