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.
S012240AerTrim LWS009695AerTrim LWS2298AerFilm LHRS009468AerFilm LHRS8712AerFilm LHRS4156AerTrim LWS011933AerFilm LHRS1518AerTrim LWS50062-001-P2AerFilm LHRS2077AerFilm LHRS5630AerFilm LHRS3555AerFilm LHRS6164AerFilm LHRS2110AerFilm LHRS52267-016-P2AerFilm LHRS08017-001-P2AerFilm LHRS04927-016-P2AerTrim LWS04046-001-P2AerFilm LHRS09920-007-P2AerFilm LHRS04053-005-P2AerFilm LHRS011629AerFilm LHRS5190AerTrim LWS5314AerFilm LHRS2192AerTrim LWS3757AerTrim LWS5093AerTrim LWS011919AerFilm LHRS1055AerFilm LHRS3659AerTrim LWS5557AerFilm LHRS50494-002-P2AerFilm LHRS51973-001-P2AerFilm LHRS011654AerFilm LHRS011476AerFilm LHRS011932AerFilm LHRS5428AerFilm LHRS015353AerTrim LWS04037-045-P2AerFilm LHRS8317AerFilm LHRS52238-001-P2AerFilm LHRS4940AerFilm LHRS7557AerFilm LHRS012140AerFilm LHRS012140AerFilm LHRS013844AerFilm LHRS50689-001-P2AerFilm LHRS012012AerTrim LWS010100AerFilm LHRS51927-001-P2AerFilm LHRS04927-007-P2AerFilm LHR
Back to Boeing 747-400D