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.
S2968AerFilm LHRS012692AerFilm LHRRFO225AerFilm LHRS013379AerTrim LWS08935-005-P2AerFilm LHRS2682AerFilm LHRS04056-003-P2AerFilm LHRS8020AerFilm LHRS011017AerFilm LHRS010424AerFilm LHRS14200-004-P2AerTrim LWS2874AerTrim LWS014512AerFilm LHRS08228-001-P2AerFilm LHRS1519AerTrim LWS5764AerFilm LHRS12203-001-P2AerFilm LHRS013212AerFilm LHRS13205-002-P2AerFilm LHRS51903-002-P2AerFilm LHRS3832AerFilm LHRS1518AerTrim LWS013427AerFilm LHRS2057AerFilm LHRS009318AerTrim LWS015601AerTrim LWS08029-001-P2AerFilm LHRS011162AerFilm LHRS50533-003-P2AerFilm LHRS009331AerFilm LHRS05077-004-P2AerFilm LHRS015763AerFilm LHRS51970-001-P2AerFilm LHRS16205-004-P2AerTrim LWS013378AerTrim LWS07920-002-P2AerFilm LHRS04192-001-P2AerFilm LHRS1686AerFilm LHRS8416AerFilm LHRS5954AerFilm LHRS3832AerFilm LHRS1512AerTrim LWS3331AerFilm LHRS14200-006-P2AerTrim LWS2437AerTrim LWS010918AerFilm LHRS2978AerFilm LHRS012343AerTrim LWS7133AerFilm LHRS00000-077-P2AerTrim LW
Back to Boeing 747-400D