Airframe MRO Events
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 |
|---|---|---|---|---|---|
| Airport | varchar(255) | Airport Display Name (combination of City Name and Airport Name) | |||
| Airport IATA | char(3) | Airport three character IATA code | Foreign | Airports | Airport IATA |
| Airport ICAO | char(4) | Airport four character ICAO code | Foreign | Airports | Airport ICAO |
| Continent | varchar(255) | Continent name | |||
| Subdivision | varchar(255) | State name | |||
| Subdivision ISO Code | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) | Foreign | States | State ISO |
| Metro Group | varchar(255) | Metro Group name | |||
| Metro Group IATA | char(3) | Metro Group three character IATA code | Foreign | Metro Groups | Metro_Group |
| Country | varchar(255) | Country name | |||
| Country ISO Code | char(2) | ISO 3166-1 Alpha-2 country code | Foreign | Countries | Country ISO |
| Airframe MRO Name | varchar(255) | Name of the MRO provider | |||
| Airframe MRO ch-a Code | varchar(5) | MRO provider ch-aviation code (2-5 characters) | Foreign | Entities | Entity ch-a Code |
| Airframe MRO Subsidiary Name | varchar(255) | Name of the MRO subsidiary (if applicable) | |||
| Airframe MRO Subsidiary Code | varchar(5) | MRO subsidary ch-aviation code (if applicable) (2-5 characters) | Foreign | Entities | Entity ch-a Code |
| Operator In | varchar(255) | Operator name upon arrival at the MRO facility | |||
| Operator In ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation) upon arrival at the MRO facility. Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
| Operator In IATA | varchar(2) | Operator IATA two-character code upon arrival at the MRO facility | |||
| Operator In ICAO | varchar(3) | Operator ICAO three-character code upon arrival at the MRO facility | |||
| Operator Out | varchar(255) | Operator name upon departure from the MRO facility | |||
| Operator Out ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation) upon departure from the MRO facility. Operator ch-aviation codes can be 2, 3, or 5 characters | Foreign | Operators | Operator ch-a Code |
| Operator Out IATA | varchar(2) | Operator IATA two-character code upon departure from the MRO facility | |||
| Operator Out ICAO | varchar(3) | Operator ICAO three-character code upon departure from the MRO facility | |||
| Flight ID In | varchar(255) | Spire internal unique flight ID in ADS-B data for inbound flight to the MRO facility. Random UUIDv4 sequence | Foreign | Flights | flight_id |
| Flight ID Out | varchar(255) | Spire internal unique flight ID in ADS-B data for outbound flight from the MRO facility. Random UUIDv4 sequence | Foreign | Flights | flight_id |
| Date In | date | Date the aircraft arrived at the MRO facility | |||
| Date Out | date | Date the aircraft departed from the MRO facility | |||
| Days | int(11) | Total number of days the aircraft spent at the MRO facility (calculated as date_out - date_in) | |||
| Airframe MRO Event Type | varchar(255) | Type of the MRO event (Base, Completion, Conversion, Delivery, Induction, Lease Return, Line + A, Modifications, Paint, Part-Out, Production, Repairs, Storage, Transition) | |||
| Aircraft ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation) | Foreign | Aircraft | Aircraft ID |
| Aircraft Variant In | varchar(255) | Aircraft Variant designation (i.e. A321-200N) upon arrival at the MRO facility | Foreign | Aircraft Variants | variant_text |
| Aircraft Variant Out | varchar(255) | Aircraft Variant designation (i.e. A321-200N) upon departure from the MRO facility | Foreign | Aircraft Variants | variant_text |
| C/N | varchar(16) | Construction/Line Number | |||
| MSN | varchar(16) | Manufacturer Serial Number | |||
| Registration In | varchar(16) | Aircraft registration number upon arrival at the MRO facility | |||
| Registration Out | varchar(16) | Aircraft registration number upon departure from the MRO facility | |||
| Engine Manufacturer | varchar(255) | Engine manufacturer name | |||
| Engine Manufacturer ch-a Code | varchar(4) | Engine manufacturer ch-aviation code (assigned by ch-aviation) | Foreign | Entities | Entity ch-a Code |
| Engine Family | varchar(16) | Engine family (i.e. JT9D) | |||
| Engine Master Series | varchar(32) | Engine master series designation (i.e. JT9D-7R4) | |||
| Engine Type | varchar(16) | Engine type designation (i.e. PW JT9D) | |||
| Engine Subtype | varchar(32) | Engine subtype designation (i.e. PW JT9D-7R4H1) |