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.
S05915-003-P2AerFilm LHRS09203-007-P2AerFilm LHRS012511AerFilm LHRS7261AerFilm LHRS3599AerTrim LWS04916-003-P2AerFilm LHRS51970-001-P2AerFilm LHRS08289-001-p2AerFilm LHRS016037AerFilm LHRS1596AerFilm LHRS03959-010-P2AerTrim LWS3315AerTrim LWS1782AerFilm LHRS14212-001-P2AerFilm LHRS6029AerFilm LHRS012393AerTrim LWS05013-004-P2AerFilm LHRS04037-007-P2AerFilm LHRS03588-001-P2AerTrim LWS012008AerFilm LHRS6410AerTrim LWS011176AerFilm LHRS07077-001-P2AerFilm LHRS7886AerFilm LHRS8134AerTrim LWS04952-001-P2AerFilm LHRS011850AerFilm LHRS15238-001-P2AerFilm LHRS07487-002-P2AerFilm LHRS011177AerFilm LHRS04016-007-P2AerFilm LHRS016055AerTrim LWS07457-001-P2AerTrim LWS014739AerFilm LHRS05078-005-P2AerFilm LHRS013173AerFilm LHRS011646AerTrim LWS009174AerFilm LHRS7798AerFilm LHRS51248-002-P2AerFilm LHRS7446AerFilm LHRS2587AerTrim LWS04031-001-P2AerFilm LHRS8285AerTrim LWS2110AerFilm LHRS6714AerFilm LHRS013179AerFilm LHRS012565AerTrim LWS3591AerTrim LWS8141AerFilm LHR
Back to Boeing 747-400D