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.
| Column | Data Type | Data description | Key | Data Set | Join On |
|---|---|---|---|---|---|
| ch_operator_code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Primary/Foreign | Operators | Operator ch-a Code |
| icao | varchar(3) | Callsign Operator ICAO three-character code | Primary | ||
| flight_number | varchar(4) | Callsign flight number | Primary | ||
| suffix | varchar(1) | Callsign suffix | Primary | ||
| 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. | 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. | Foreign | Entities | Entity ch-a Code |
| cargo_customer | varchar(255) | Name of cargo customer for whom the flights 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. | Foreign | Entities | Entity ch-a Code |
| wet_lease_customer | varchar(255) | Wet lease customer name | |||
| notes | varchar(255) | Additional flight description |