Airframe MRO Providers and Customers
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 | Package required | Key | Data Set | Join On |
---|---|---|---|---|---|---|
Airframe MRO Name | varchar(255) | Name of the MRO provider | Commercial Aviation Airframe MRO Data | |||
Airframe MRO ch-a Code | varchar(5) | MRO provider ch-aviation code (2-5 characters) | Commercial Aviation Airframe MRO Data | Foreign | Entities | Entity ch-a Code |
Legal Name | varchar(255) | MRO Provider legal name | Commercial Aviation Airframe MRO Data | |||
Base Location | varchar(255) | Airport Display Name (combination of City Name and Airport Name) | Commercial Aviation Airframe MRO Data | |||
Base Location ch-a Code | varchar(6) | Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code) | Commercial Aviation Airframe MRO Data | Foreign | Airports | Airport ch-a Code |
Base Location IATA | char(3) | Airport three character IATA code | Commercial Aviation Airframe MRO Data | |||
Base Location ICAO | char(4) | Airport four character ICAO code | Commercial Aviation Airframe MRO Data | |||
Base Continent | varchar(255) | Continent name | Commercial Aviation Airframe MRO Data | |||
Base Subdivision | varchar(255) | State name | Commercial Aviation Airframe MRO Data | |||
Base Subdivision ch-a Code | varchar(255) | ISO 3166-2 Alpha-2 subdivision code (used for states) | Commercial Aviation Airframe MRO Data | Foreign | States | State ISO |
Base Metro Group | varchar(255) | Metro Group name | Commercial Aviation Airframe MRO Data | |||
Base Metro Group IATA | char(3) | Metro Group three character IATA code | Commercial Aviation Airframe MRO Data | Foreign | Metro Groups | Metro_Group |
Base Country | varchar(255) | Country name | Commercial Aviation Airframe MRO Data | |||
Base Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Commercial Aviation Airframe MRO Data | Foreign | Countries | Country ISO |
Maintenance 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) | Commercial Aviation Airframe MRO Data | |||
Operator Customer | varchar(255) | Operator customer name | Commercial Aviation Airframe MRO Data | |||
Operator Customer ch-a Code | varchar(255) | Operator customer ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Commercial Aviation Airframe MRO Data | Foreign | Operators | Operator ch-a Code |
Status | varchar(255) | MRO provider status | Commercial Aviation Airframe MRO Data | |||
Website | varchar(255) | Website URL | Commercial Aviation Airframe MRO Data | |||
Stock Ticker | varchar(255) | Stock market ticker URL | Commercial Aviation Airframe MRO Data | |||
Launch Year | int(4) | Year the MRO provider was launched | Commercial Aviation Airframe MRO Data | |||
Termination Year | int(4) | Year the MRO provider stopped operations | Commercial Aviation Airframe MRO Data |