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.
S8922AerFilm LHRS2147AerFilm LHRS013183AerFilm LHRS8814AerFilm LHRS009606AerTrim LWS50466-001-P2AerFilm LHRS6345AerFilm LHRS8146AerFilm LHRS009693AerTrim LWS010389AerTrim LWS011443AerFilm LHRS04992-004-P2AerTrim LWS07018-001-P2AerFilm LHRS4384AerFilm LHRS013173AerFilm LHRS51431-002-P2AerFilm LHRS03935-010-P2AerTrim LWS7662AerFilm LHRS1316AerFilm LHRS7347AerFilm LHRS00000-044-P2AerFilm LHRS013811AerFilm LHRS3117AerFilm LHRS015873AerTrim LWS011184AerTrim LWS010914AerTrim LWS04927-021-P2AerFilm LHRS009959AerTrim LWS7753AerTrim LWS07293-006-P2AerFilm LHRS06076-001-P2AerFilm LHRS015331AerFilm LHRS3468AerTrim LWS012127AerFilm LHRS8218AerFilm LHRS013758AerFilm LHRS011223AerFilm LHRS011930AerFilm LHRS010421AerFilm LHRS08222-001-P2AerFilm LHRS010209AerFilm LHRS013212AerFilm LHRS011253AerFilm LHRS52267-002-P2AerFilm LHR1994575332AWDBearing, Ball, W/ Braycote LubeS04900-015-P2AerFilm LHRS015367AerFilm LHRS7549AerTrim LWS010555AerTrim LWS04900-011-P2AerFilm LHR
Back to Boeing 747-400D