Boeing 747-400D
PMA parts · 105,720
Current parts manufacturer approvals (PMA): parts the FAA has approved companies to make as replacements or modifications. Each record lists its models as free text; OpenAirDocs matched them to this model on its data sheet, so check the FAA record before relying on it. Newest first.
Query with SQL
duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A20WE')
AND len(list_intersect(tcds_models, ['747-400D Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A20WE')
AND len(list_intersect(tcds_models, ['747-400D Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
S010178AerFilm LHRS4003AerFilm LHRS011985AerFilm LHRS010280AerFilm LHRS009694AerTrim LWS1070AerFilm LHRS7430AerFilm LHRS013351AerFilm LHRS013357AerFilm LHRS013658AerFilm LHRS2080AerFilm LHRS04192-001-P2AerFilm LHRS012037AerTrim LWS51903-001-P2AerFilm LHRS6566AerFilm LHRS8708AerTrim LWS011989AerFilm LHRS011865AerTrim LWS016297AerFilm LHRS011853AerFilm LHRS51431-014-P2AerFilm LHRS011306AerFilm LHRS14271-001-P2AerFilm LHRS8147AerFilm LHRS04016-024-P2AerFilm LHRS52259-002-P2AerFilm LHRS07292-001-P2AerFilm LHRS1576AerFilm LHRS013818AerFilm LHRS014511AerFilm LHRS1155AerTrim LWS04927-022-P2AerFilm LHRS8218AerFilm LHRS012128AerFilm LHRS013427AerFilm LHRS8239AerTrim LWS5570AerTrim LWS3730AerFilm LHRS10202-002-P2AerFilm LHRS7776AerFilm LHRS016183AerTrim LWS012395AerTrim LWS13259-001-P2AerTrim LWS011018AerTrim LWS8416AerFilm LHRS8527AerFilm LHRS7199AerFilm LHRS3799AerFilm LHRS5727AerFilm LHRS013711AerFilm LHR
Back to Boeing 747-400D