Do you also provide an API?

ch-aviation can provide the data feeds to you directly via a shared Amazon Web Services (AWS) S3 bucket.

Which delivery formats you support?

The data is provided as Comma-separated values (.csv) flat files, the news are provided in RSS format.

How often does data get updated?

The ch-aviation database is updated in batches to ensure all data flows through ch-aviation’s semi-automated quality assurance process built to maximise data integrity. As a result, the data set remains relatively static in the ch-aviation production database, for most data sets for a week or month at a time. Therefore, the most efficient integration option is the transfer of flat files provided for integration into your own applications in various formats.

Airframe MRO Capabilities - ch-aviation

Airframe MRO Capabilities

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
airframe_mro_capabilities.csv	Sample data for commercial aviation

Column	Data Type	Data description	Key	Data Set	Join On
mro_capabilities_id	varchar(32)	Unique identifier for each airframe mro capabilities, generated as an MD5 hash of the Airport, Airframe MRO Name, Aircraft Type, Engine Type. Stable as long as the combination of underlying data does not change (it changes as data is adjusted or improved by ch-aviation).	Primary
Airport Display Name	varchar(255)	Airport Display Name (combination of City Name and Airport Name)
Airport ch-a Code	varchar(6)	Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code)	Foreign	Airports	Airport ch-a Code
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
Country	varchar(255)	Country name
Country ISO Code	char(2)	ISO 3166-1 Alpha-2 country code	Foreign	Countries	Country ISO
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
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 / Airframe MRO Providers and Customers	Entity ch-a Code / Airframe MRO ch-a Code
MRO Subsidiary Name	varchar(255)	Name of the MRO subsidiary (if applicable)
MRO Subsidiary ch-a Code	varchar(5)	MRO subsidary ch-aviation code (if applicable) (2-5 characters)	Foreign	Entities / Airframe MRO Providers and Customers	Entity ch-a Code / MRO Subsidiary ch-a Code
approval_number	varchar(32)	The official certificate or approval number issued to the MRO by the relevant aviation authority.
Aircraft Type	varchar(32)	Aircraft type included in the approval. Used for standardizing across MROs that list types differently
check_level	varchar(8)	Highest maintenance level covered under the approval. Allowed values: NULL, Line, A, B, C, D
Engine Type	varchar(16)	NULL if MRO has approval for all engine types for a certain aircraft type. Otherwise, lists an engine type for that aircraft type it has approval for (i.e. PW JT9D)
Engine Type ch-a Code	varchar(4)	NULL if MRO has approval for all engine types for a certain aircraft type. Otherwise, lists engine type ch-aviation code (i.e. PWJ9)
Engine Family	varchar(16)	NULL if MRO has approval for all engine types for a certain aircraft type. Otherwise, lists engine family (i.e. JT9D)
Engine Manufacturer	varchar(255)	NULL if MRO has approval for all engine types for a certain aircraft type. Otherwise, lists engine manufacturer name
Engine Manufacturer ch-a Code	varchar(4)	NULL if MRO has approval for all engine types for a certain aircraft type. Otherwise, lists engine manufacturer ch-aviation code (assigned by ch-aviation)	Foreign	Entities	Entity ch-a Code
approval_per_fleet	smallint	1 = capability was assigned based on the operator's fleet rather than an identified approval document. Used when no approval number could be found, or documentation does not explicitly identify aircraft types. If the MRO is known to maintain its own fleet under its AOC, relevant types may be recorded on that assumption. Otherwise NULL
main_approval	smallint	Distinguishes multiple facilities operating under one approval (e.g. main facility in Zagreb, Croatia; additional facility in Split, Croatia). 1 = main facility under a single approval. 2 = other facilities under the same approval. NULL = the location has a separate approval.
approval_date	varchar(10)	Date of the approval's issuance or latest revision. Revisions may include added aircraft types or scope changes. (YYYY-MM-DD, YYYY-MM, or YYYY)
approval_date_full	date	Full date of the approval's issuance or latest revision. (Always YYYY-MM-DD)
type_activity_start_date	varchar(10)	Date when the MRO got approval for a new type, at the aircraft-type level. (YYYY-MM-DD, YYYY-MM, or YYYY)
type_activity_start_date_full	date	Full date when the MRO got approval for a new type. (Always YYYY-MM-DD)
type_activity_end_date	varchar(10)	Date when the MRO removed approval for type. Populated when evidence shows the aircraft type was removed from approval/capability. Applies to that type only. It does not necessarily mean the MRO's overall approval ended. (YYYY-MM-DD, YYYY-MM or YYYY format)
type_activity_end_date_full	date	Full Date when the MRO removed approval for type. Populated when evidence shows the aircraft type was removed from approval/capability. Applies to that type only. It does not necessarily mean the MRO's overall approval ended. (Always YYYY-MM-DD)