Database structure
July 10, 2021 · View on GitHub
Database structure
Aircraft
This dataset includes the following files:
aircraft.csv
This file contains information on aircraft. Only aircraft of manufacturers for which there are very few aircraft are placed in this file. See the table below for the structure of this file.
aircraft/manufacturer.csv
These files contain information on aircraft, for a single manufacturer. The structure of these files is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| icao_24bit_address | string | The ICAO 24-bit address of the aircraft. | 38fcbb |
| registration | string | The registration of the aircraft. | F-GXLG |
| manufacturer | string | The manufacturer of the aircraft. | Airbus |
| model | string | The model of the aircraft. | A330-743L Beluga XL |
| aircraft_type | string | The type of the aircraft, as an ICAO code. | A337 |
| serial_number | string | The manufacturer serial number of the aircraft. | 1824 |
| description | string | The description of the aircraft, as defined in the ICAO Document 8643. | L2J |
| operator | string|null | The airline which operates the aircraft, as an ICAO code. | AIB |
| registered_at | date|null | The date the aircraft was registered. | 2020-01-01 |
| registered_until | date|null | The date the aircraft registration expires. | 2022-12-31 |
| manufactured_at | date|null | The date the aircraft was manufactured. | 2019-12-31 |
aircraft_pictures.csv
This file contains the list of photographs of aircraft as well as information on the author and the license issued by the latter. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| aircraft | string | The ICAO 24-bit address of the aircraft. | 38fcbb |
| picture | string | The relative path to the file. | aircraft_pictures/38fcbb.webp |
| source | string | The source of the picture. | https://www.flickr.com/photos/johndoe/1234567890/ |
| author_name | string | The name of the picture author. | John Doe |
| author_profile | string|null | The URL of the picture author's profile. | https://www.flickr.com/photos/johndoe/ |
| license | string | The license of the picture, as an SPDX license identifier ¹. | CC-BY-SA-2.0 |
¹ See https://spdx.org/licenses/ for a list of valid identifiers.
Aircraft types
This dataset includes the following files:
aircraft_types.csv
This file contains information on aircraft types. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| icao_code | string | The ICAO code of the aircraft type. | A35K |
| iata_code | string|null | The IATA code of the aircraft type. | 351 |
| manufacturer | string | The manufacturer of the aircraft ¹. | Airbus |
| name | string | The name of the aircraft type. | A350-1000 |
| description | string|null | The description of the aircraft, as defined in the ICAO Document 8643 ². | L2J |
| service_ceiling | integer|null | The service ceiling of the aircraft, in feet. | 35000 |
| absolute_ceiling | integer|null | The absolute ceiling of the aircraft, in feet. | 41450 |
| climb_rate | integer|null | The rate of climb of the aircraft, in feet per minute ⁹. | 6000 |
| wtc | string|null | The ICAO wake turbulence category of the aircraft, as defined in the ICAO Document 8643 ². | H |
| approach_speed | integer|null | The approach speed (VRef) of the aircraft, in knots IAS. | 142 |
| cruise_speed | integer|null | The cruise speed (Vno) of the aircraft, in knots IAS. | 500 |
| maximum_speed | integer|null | The maximum speed (Vmo) of the aircraft, in knots IAS. | 520 |
| never_exceed_speed | integer|null | The never exceed speed (Vne) of the aircraft, in knots IAS. | 610 |
| fuselage_height | float|null | The height of the aircraft fuselage, in metres. | 5.96 |
| fuselage_width | float|null | The width of the aircraft fuselage, in metres. | 5.96 |
| height | float|null | The overall height of the aircraft, in metres ³. | 16.90 |
| length | float|null | The overall length of the aircraft, in metres ⁴. | 73.78 |
| wingspan | float|null | The wingspan of the aircraft, in metres ⁵. | 64.75 |
| wing_area | float|null | The wing area of the aircraft, in square metres. | 464.30 |
| main_rotor_area | float|null | The area of the aircraft main rotor, in square metres ⁶. | |
| main_rotor_diameter | float|null | The diameter of the aircraft main rotor, in metres. | |
| fuel_capacity | integer|null | The fuel capacity of the aircraft, in litres. | 158791 |
| operating_range | integer|null | The operating range of the aircraft, in nautical miles ⁷. | 16100 |
| ferry_range | integer|null | The ferry range of the aircraft, in nautical miles ⁸. | 18500 |
| oew | integer|null | The operating empty weight of the aircraft, in kilograms. | 155000 |
| auw | integer|null | The all-up weight of the aircraft, in kilograms. | 305700 |
| mlw | integer|null | The maximum landing weight of the aircraft, in kilograms. | 236000 |
| mrw | integer|null | The maximum ramp weight of the aircraft, in kilograms. | 317500 |
| mtow | integer|null | The maximum takeoff weight of the aircraft, in kilograms. | 316000 |
| mzfw | integer|null | The maximum zero-fuel weight of the aircraft, in kilograms. | 220000 |
| type_certificate | string|null | The URL of the aircraft type certificate. |
¹ For generic aircraft types, this value is always Generic.
² This value is never null, except for generic aircraft types (BALL, GLID, GYRO, PARA, SHIP, UHEL, ULAC and ZZZZ).
³ For tiltrotors, the height is measured with nacelles in vertical position.
⁴ For helicopters, this doesn't include the main rotor blades.
⁵ For biplanes or triplanes, the widest plane width is used. For tiltrotors, this doesn't include the rotor blades.
⁶ For tiltrotors or multi-rotor helicopters, this is the sum of rotors areas.
⁷ With maximum internal fuel.
⁸ With maximum internal fuel, external fuel tanks if applicable, and no payload.
aircraft_types_pictures.csv
This file contains the list of photographs of aircraft types as well as information on the author, and the license issued by the latter. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| aircraft_type | string | The ICAO code of the aircraft type. | A359 |
| picture | string | The relative path to the file. | aircraft_types_pictures/A359.webp |
| source | string | The source of the picture. | https://www.flickr.com/photos/johndoe/1234567890/ |
| author_name | string | The name of the picture author. | John Doe |
| author_profile | string|null | The URL of the picture author's profile. | https://www.flickr.com/photos/johndoe/ |
| license | string | The license of the picture, as an SPDX license identifier ¹. | CC-BY-SA-2.0 |
¹ See https://spdx.org/licenses/ for a list of valid identifiers.
aircraft_models.csv
This file contains information on aircraft models. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| aircraft_type | string | The ICAO code of the aircraft type. | A359 |
| name | string | The name of the aircraft model. | A350-941 |
| engine_manufacturer | string | The manufacturer of the aircraft engines. | Rolls Royce |
| engine_model | string[] | The model of the aircraft engines. Multiple semicolon separated values are allowed. | Trent XWB-75;Trent XWB-84 |
| certified_at | date|null | The the date the aircraft model was certified. | 2014-09-30 |
Airlines
This dataset includes the following files:
airlines.csv
This file contains information on airlines. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| icao_code | string | The ICAO code of the airline. | AFR |
| iata_code | string|null | The IATA code of the airline. | AF |
| name | string | The name of the airline. | Air France |
| country | string | The country where the airline operates, as an ISO 3166-1 alpha-2 code. | FR |
| callsign | string|null | The callsign of the airline. | AIRFRANS |
| active | boolean | Whether the airline is active. | 1 |
| international | boolean | Whether the airline operates international flights. | 1 |
| iata_member | boolean | Whether the airline is member of the IATA. | 1 |
| iosa_certified | boolean | Whether the airline is IOSA certified. | 1 |
| average_fleet_age | float|null | The average age of the airline fleet. | 10.84 |
| aircraft_over_25_years | integer|null | The number of aircraft over 25 years old within the airline fleet. | 0 |
| accidents_last_5_years | integer|null | The number of accidents involving the airline during the last 5 years. | 7 |
| fatal_accidents_last_5_years | integer|null | The number of fatal accidents involving the airline during the last 5 years. | 0 |
| destinations | integer|null | The number of destinations serviced by the airline. | 178 |
| annual_domestic_flights | integer|null | The number of domestic flights operated annually by the airline. | 96789 |
| annual_international_flights | integer|null | The number of international flights operated annually by the airline. | 171510 |
airlines_logos.csv
This file contains the list of airlines logos. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| airline | string | The ICAO code of the airline. | AFR |
| logo | string | The relative path to the file. | airlines_logos/AFR.svg |
airlines_pictures.csv
This file contains the list of photographs of aircraft wearing the livery of airlines as well as information on the author, and the license issued by the latter. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| airline | string | The ICAO code of the airline. | AFR |
| picture | string | The relative path to the file. | airlines_pictures/AFR.webp |
| source | string | The source of the picture. | https://www.flickr.com/photos/johndoe/1234567890/ |
| author_name | string | The name of the picture author. | John Doe |
| author_profile | string|null | The URL of the picture author's profile. | https://www.flickr.com/photos/johndoe/ |
| license | string | The license of the picture, as an SPDX license identifier ¹. | CC-BY-SA-2.0 |
¹ See https://spdx.org/licenses/ for a list of valid identifiers.
Airports
This dataset includes the following files:
airports.csv
This file contains information on airports. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| icao_code | string | The ICAO code of the airport. | LFBO |
| iata_code | string|null | The IATA code of the airport. | TLS |
| name | string | The name of the airport. | Toulouse-Blagnac Airport |
| type | string | The type of the airport ¹. | large |
| latitude | float|null | The latitude of the airport, in degrees. | 43.635 |
| longitude | float|null | The longitude of the airport, in degrees. | 1.36778 |
| elevation | integer|null | The elevation of the airport, in feet AMSL. | 482 |
| fir | string | The flight information region to which the airport belongs. | LFBB |
| continent | string | The continent where the airport is located, as a 2 letter continent code. | EU |
| country | string | The country where the airport is located, as an ISO 3166-1 alpha-2 code. | FR |
| active | boolean | Whether the airport is active. | 1 |
| international | boolean | Whether the airport is international. | 1 |
¹ Currently relates to the size of the airport, but can be extended in the future. Can take one of the following values :
- small (Small airport or air base);
- medium (Medium airport or air base);
- large (Large airport or air base).
airports_datasets.csv
This file contains statistics about airports. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| airport | string | The ICAO code of the airport. | LFBO |
| year | integer | The year for which the dataset apply. | 2019 |
| domestic_departures | integer | The number of domestic flights that departed from the airport. | 20206 |
| international_departures | integer | The number of international flights that departed from the airport. | 18380 |
| domestic_destinations | integer | The number of domestic destinations serviced by the airport. | 48 |
| international_destinations | integer | The number of international destinations serviced by the airport. | 99 |
airports_frequencies.csv
This file contains information on radio frequencies used at airports. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| airport | string | The ICAO code of the airport. | LFBO |
| description | string | The description of the radio frequency. | TWR |
| frequency | integer | The actual frequency of the radio frequency, in kilohertz. | 118100 |
| type | string | The type of the radio frequency ¹. | TWR |
¹ Commonly used values includes AFIS, ATIS, APP (approach), DEP (departure), GND (ground), TWR (tower), PFLT (preflight),...
airports_runways.csv
This file contains information on airport runways. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| airport | string | The ICAO code of the airport. | LFBO |
| length | integer | The length of the runway, in feet. | 9843 |
| width | integer | The width of the runway, in feet. | 148 |
| le_name | string | The name of the runway lower end. | 14L |
| le_latitude | float | The latitude of the runway lower end, in degrees. | 43.6374 |
| le_longitude | float | The longitude of the runway lower end, in degrees. | 1.35762 |
| le_elevation | integer|null | The elevation of the runway lower end, in feet AMSL. | 490 |
| le_heading | float|null | The magnetic heading of the runway lower end, in degrees. | 143 |
| le_displaced_threshold | integer|null | The length of the runway higher end displaced threshold, in feet. | |
| he_name | string | The name of the runway higher end. | 32R |
| he_latitude | float | The latitude of the runway higher end, in degrees. | 43.6156 |
| he_longitude | float | The longitude of the runway higher end, in degrees. | 1.38022 |
| he_elevation | integer|null | The elevation of the runway higher end, in feet AMSL. | 497 |
| he_heading | float|null | The magnetic heading of the runway higher end, in degrees. | 323 |
| he_displaced_threshold | integer|null | The length of the runway higher end displaced threshold, in feet. | |
| surface | string|null | The runway surface type code ¹. | CON |
| lighted | boolean | Whether the runway is lighted. | 1 |
| active | boolean | Whether the runway is active. | 1 |
¹ Can take one of the following values:
- ASP (Asphalt);
- BIT (Bituminous asphalt);
- BRI (Bricks);
- CLA (Clay);
- COM (Composite);
- CON (Concrete);
- COP (Composite);
- COR (Coral);
- GRE (Grass or earth, graded/rolled);
- GRS (Grass or earth, non graded/rolled);
- GVL (Gravel);
- ICE (Ice);
- LAT (Laterite);
- MAC (Macadam);
- PEM (Partially asphalt, bituminous asphalt or concrete);
- PER (Permanent surface, details unknown);
- PSP (Pierced-steel planking);
- SAN (Sand);
- SMT (Sommerfeld tracking);
- SNO (Snow);
- WAT (Water).
Fixes
This dataset includes the following files:
fixes.csv
This file contains information on fixes / waypoints. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| slug | string | The slug used to identify the fix ¹. | 18vor-lf-lfbo |
| identifier | string | The identifier of the fix. | 18VOR |
| latitude | float | The latitude of the fix, in degrees. | 43.705230556 |
| longitude | float | The longitude of the fix, in degrees. | 1.285716667 |
| usage | string | The usage of the fix ². | TERMINAL |
| region | string | The ICAO region of the fix, as defined in the ICAO Document 7910. | LF |
| airport | string|null | The airport to which the fix is associated, as an ICAO code. | LFBO |
¹ A globally unique combination of the identifier, region and airport.
² Can take one of the following values:
- ENROUTE (En-route navigation);
- TERMINAL (Approach).
Flights
This dataset includes the following files:
flights.csv
This file contains information on flights. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| airline | string | The airline for which the flight is operated, as an ICAO code. | AFR |
| flight_number | string | The flight number. | AFR1032 |
| departure_airport | string | The departure airport of the flight, as an ICAO code. | LFPG |
| arrival_airport | string | The arrival airport of the flight, as an ICAO code. | LGAV |
| layover_airports | string[]|null | The layover airports of the flight, as a semicolon separated list of ICAO codes. | LFPB;LFIT |
Flight information regions
This dataset includes the following files:
firs.csv
This file contains information on flight information regions. The structure of this file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| icao_code | string | The ICAO code of the flight information region. | LFBB |
| name | string | The name of the flight information region. | BORDEAUX |
Navaids
This dataset includes the following files:
navaids/type.csv
This file contains information on navigational aids, for a single navaid type. The structure of these file is as follows:
| Column | Type | Description | Example |
|---|---|---|---|
| slug | string | The slug used to identify the navaid ¹. | tou-vor-dme-lf |
| identifier | string | The identifier of the navaid. | TOU |
| name | string | The name of the navaid. | TOULOUSE BLAGNAC VOR/DME |
| type | string | The type of the navaid ². | VOR-DME |
| usage | string | The usage of the navaid ³. | ENROUTE |
| frequency | integer | The frequency of the navaid, in kilohertz. | 117700 |
| dme_channel | string|null | The channel of the navaid DME part. | 124X |
| dme_rx_frequency | integer|null | The RX frequency of the navaid DME part, in kilohertz ⁴. | 1148000 |
| dme_tx_frequency | integer|null | The TX frequency of the navaid DME part, in kilohertz ⁴. | 1211000 |
| dme_bias | float|null | The bias of the navaid DME part, in nautical miles ⁵. | 0 |
| vor_slaved_variation | float|null | The slaved variation of the navaid VOR part, in degrees. | 0 |
| localizer_heading | float|null | The magnetic heading of the navaid localizer part, in degrees. | |
| glide_slope_angle | float|null | The angle of the navaid glide slope part, in degrees. | |
| reception_range | integer | The reception range of the navaid, in nautical miles. | 130 |
| latitude | float | The latitude of the navaid, in degrees. | 43.68083 |
| longitude | float | The longitude of the navaid, in degrees. | 1.30980 |
| elevation | integer|null | The elevation of the navaid, in feet AMSL. | 574 |
| region | string | The ICAO region of the navaid, as defined in the ICAO Document 7910. | LF |
| airport | string|null | The airport to which the navaid is associated, as an ICAO code. | |
| airport_runway | string|null | The airport runway to which the navaid is associated. | |
| country | string | The country where the navaid is located, as an ISO 3166-1 alpha-2 code. | FR |
¹ A globally unique combination of the identifier, type, region and associated airport (if applicable).
² Can take one of the following values:
- DME (Distance Measuring Equipment);
- DME-ILS (Distance Measuring Equipment, part of an ILS);
- DME-NDB (Distance Measuring Equipment, part of a NDB);
- GS (Glide Slope);
- IGS (Instrument Guidance System);
- ILS-I (Instrument Landing System - Categoty I);
- ILS-II (Instrument Landing System - Category II);
- ILS-III (Instrument Landing System - Category III);
- IM (Inner Marker of an Instrument Landing System);
- LDA (Localizer Directional Aid);
- LOC (Standalone localizer);
- MM (Middle Marker of an Instrument Landing System);
- NDB (Non-Directional Beacon);
- OM (Outer Marker of an Instrument Landing System);
- SDF (Simplified Directional Facility);
- TACAN (Tactical Air Navigation system);
- VOR (VHF Omnidirectional Range);
- VOR-DME (VHF Omnidirectional Range + Distance Measuring Equipment);
- VORTAC (VHF Omnidirectional Range + Tactical Air Navigation system);
³ Can take one of the following values:
- ENROUTE (En-route navigation);
- TERMINAL (Approach).
⁴ RX and TX frequencies are observed from the navaid perspective. It means the RX frequency is the interogation frequency and the TX frequency the reply frequency, from a pilot's perspective.
⁵ This value is always null for DMEs other than DME-ILS.