Flight Number Decoding
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 |
|---|---|
| flight_number_decoding.csv | Sample data for commercial aviation |
| Column | Data Type | Data description | Key | Data Set | Join On |
|---|---|---|---|---|---|
| ch_code_operator | 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 |
| icao | char(3) | Callsign operator ICAO three-character code | Primary (combined) | ||
| flight_number | varchar(4) | Callsign flight number | Primary (combined) | ||
| suffix | varchar(1) | Callsign suffix | Primary (combined) | ||
| flight_type | varchar(20) | Indicator of special flight types (ferry, technical, training) | |||
| ch_code_regional_partnership | varchar(5) | ch-aviation code for the carrier the regional partnership flights are operated for (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Primary (combined)/Foreign | Operators | Operator ch-a Code |
| regional_partnership | varchar(255) | Regional partnership name under which the flight is operated | Foreign | Regional Subsidiaries | Rel Subsidiary |
| ch_code_cargo_customer | varchar(5) | Cargo customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters. | Primary (combined)/Foreign | Entities | Entity ch-a Code |
| cargo_customer | varchar(255) | Name of cargo customer for whom the flight is operated | |||
| ch_code_wet_lease_customer | varchar(5) | Wet lease customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters. | Primary (combined)/Foreign | Entities | Entity ch-a Code |
| wet_lease_customer | varchar(255) | Wet lease customer name | |||
| notes | varchar(255) | Additional free text notes related to the flight | |||
| flight_number_decoding_id | varchar(32) | Generated row id: MD5 of ch_code_operator, icao, flight_number, suffix, ch_code_regional_partnership, ch_code_cargo_customer and ch_code_wet_lease_customer (empty values as empty text, separated by '|'). Stable as long as these values do not change. |