Frequencies – Flown (ADS-B based)
To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.
To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.
To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.
| Sample File Name | Sample Description |
|---|---|
| frequencies_flown_adsb_bizjets.csv | Subset for business jets |
| frequencies_flown_adsb_comav.csv | Subset for commercial aviation |
| frequencies_flown_adsb.csv | Sample data for commercial aviation and business jets |
| Column | Data Type | Data description | Key | Data Set | Join On |
|---|---|---|---|---|---|
| operator_name | varchar(255) | Operator name | |||
| operator_ch_code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Primary (combined)/Foreign | Operators | Operator ch-a Code |
| aircraft_variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Primary (combined)/Foreign | Aircraft Variants | variant_text |
| origin_airport_name | varchar(255) | Origin airport display name (combination of City Name and Airport Name) | |||
| origin_airport_icao | varchar(6) | Origin airport ICAO code | Primary (combined)/Foreign | Airports | Airport ICAO |
| origin_airport_iata | varchar(3) | Origin airport IATA code | Foreign | Airports | Airport IATA |
| origin_continent | varchar(255) | Origin airport continent name | |||
| origin_airport_country_name | varchar(255) | Origin airport country name | |||
| origin_airport_country_iso_code | char(2) | Origin airport ISO 3166-1 Alpha-2 country code | Primary (combined)/Foreign | Countries | Country ISO |
| origin_subdivision | varchar(255) | Origin airport state name | |||
| origin_subdivision_cha_code | char(2) | Origin airport ISO 3166-2 Alpha-2 subdivision code (used for states) | |||
| destination_airport_name | varchar(255) | Destination airport display name (combination of City Name and Airport Name) | |||
| destination_airport_icao | varchar(6) | Destination airport ICAO code | Primary (combined)/Foreign | Airports | Airport ICAO |
| destination_airport_iata | varchar(3) | Destination airport IATA code | Foreign | Airports | Airport IATA |
| destination_continent | varchar(255) | Destination airport continent name | |||
| destination_airport_country_name | varchar(255) | Destination airport country name | |||
| destination_airport_country_iso_code | char(2) | Destination airport ISO 3166-1 Alpha-2 country code | Primary (combined)/Foreign | Countries | Country ISO |
| destination_subdivision | varchar(255) | Destination airport state name | |||
| destination_subdivision_cha_code | char(2) | Destination airport ISO 3166-2 Alpha-2 subdivision code (used for states) | |||
| month | int(2) | Month of the flights (1-12). | Primary (combined) | ||
| year | int(4) | Year of flights | Primary (combined) | ||
| number_of_flights | int(8) | Total number of flights flown on the route in the month. | |||
| total_cargo_capacity_kg | int(8) | Total cargo capacity (kg) | |||
| total_cargo_capacity_lb | decimal(15,2) | Total cargo capacity (lb) |