Spire-ch-aviation Mapping
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 |
|---|---|---|---|---|---|
| flight_id | varchar(255) | Spire internal unique flight ID. Random UUIDv4 sequence | Primary/foreign | Flights | flight_id |
| ch_code_operator | 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 |
| 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 free text notes related to the flight | |||
| aircraft_id | int4 | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation), the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data set | Foreign (Combined) | Aircraft Histories | Aircraft ID |
| date_from_full | date | From date with operator, registration and variant, the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data set | Foreign (Combined) | Aircraft Histories | Date From Full |