Database of 9,433 World Airports (Code, Area Code, Runway, Longitude, Latitude, Country)

Database Description:

This is simple one table database of 9,433 airports (unique, with 9,433 distinct airport codes) around the globe. Each airport record has a name, an airport code, a world area code, city name, country (both abbreviation and common name), length of runway, elevation of runway, longitude, latitude, GMT offset, telephone number, fax number, website URL and email address.

655 airports have a telephone number. 389 airports have a fax number. 816 airports have a website URL. 347 airports have an email address. All other fields are fully populated with usable data.

Database Meta:

• Size: 1.6 MB
• Last updated: May 7th, 2012
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 1

Buy Now & Download: $189.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• airport

  Records:9,433

  The one table in this database that contains all the airports data.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. airport_code: varchar(255)
  4. world_area_code: char(3)
  5. country_abbreviation: char(2)
  6. country_name: varchar(255)
  7. runway_length: varchar(255)
  8. runway_elevation: varchar(255)
  9. city: varchar(255)
  10. longitude: varchar(255)
  11. latitude: varchar(255)
  12. gmt_offset: varchar(255)
  13. telephone: varchar(255)
  14. fax: varchar(255)
  15. website: varchar(255)
  16. email: varchar(255)

Buy Now & Download: $189.00 (USD)

Potential Applications / Usage:

• Travel reference / aviation reference site
• Aviation community / website reference
• World airports reference

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database
• Single Table Format