Frequencies – Flown (ADS-B based)
Column | Data Type | Data description | Key | Data Set | Join On |
operator_ch_code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
operator_name | varchar(255) | Operator name | | | |
aircraft_variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | | | |
origin_airport_icao | varchar(6) | Origin airport ICAO code | Foreign | Airports | Airport ICAO |
origin_airport_iata | varchar(6) | Origin airport IATA code | Foreign | Airports | Airport IATA |
origin_airport_name | varchar(255) | Origin airport display name (combination of City Name and Airport Name) | | | |
origin_airport_country_iso_code | char(2) | Origin airport ISO 3166-1 Alpha-2 country code | Foreign | Countries | Country ISO |
origin_airport_country_name | varchar(255) | Origin airport country name | | | |
origin_continent | varchar(255) | Origin airport continent name | | | |
destination_airport_icao | varchar(6) | Destination airport ICAO code | Foreign | Airports | Airport ICAO |
destination_airport_iata | varchar(6) | Destination airport IATA code | Foreign | Airports | Airport IATA |
destination_airport_name | varchar(255) | Destination airport display name (combination of City Name and Airport Name) | | | |
destination_airport_country_iso_code | char(2) | Destination airport ISO 3166-1 Alpha-2 country code | Foreign | Countries | Country ISO |
destination_airport_country_name | varchar(255) | Destination airport country name | | | |
destination_continent | varchar(255) | Destination airport continent name | | | |
month | int(2) | month of flights | | | |
year | int(4) | year of flights | | | |
number_of_flights | int(8) | total number of flights | | | |