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.
702409DME-2017Exit Indicator Assembly702409DME-2013Exit Indicator Assembly702409DME-1068Exit Indicator Assembly702409DME-2018Exit Indicator Assembly702409DME-1058Exit Indicator Assembly702409DME-2022Exit Indicator Assembly702409DME-1116Exit Indicator Assembly702409DME-1114Exit Indicator AssemblyANZPD5K-PBEARINGSSLSTB539-PBEARINGANZMDSP8-PBEARINGSSMDSP8-PBEARINGSSLST33B-PBEARINGSSLST37B-PBEARINGANZGDW5-PBEARINGSSLST21B-PBEARINGANZGDW8-PBEARINGSSMDSP4-PBEARINGSSMDSP3-PBEARINGSSMDPP4-PBEARINGSSLSTB545-PBEARINGSSMDPP8-PBEARINGANZMDSP6-PBEARINGSSLST29B-PBEARINGANZGDW6-PBEARINGSSLSTB543-PBEARINGANZMDPP8-PBEARINGSSLST49B-PBEARINGANZMDPP3-PBEARINGANZMDSP4-PBEARINGSSPD5K-PBEARINGSSMDPP3-PBEARING83222B23542-402ATSARMCAP ASSEMBLY83222B23542-401ATSARMCAP ASSEMBLY417U3060-14520Oxy Box Assy417U3031-2004Shell417U3081-3263Oxy Box Assy417U3065-15434Oxy Box Assy417U3070-2011Gasper Panel Assy417U3081-3301Oxy Box Assy417U3065-13442Oxy Box Assy417U3081-3413Oxy Box Assy417U3081-3269Oxy Box Assy417U3065-14434Oxy Box Assy417U3020-8240BREADING LIGHT ASSY - 4 PERSON, M/D 60, W/LED SIGN60B50059-119Hose Assy417U3060-13420Oxy Box Assy417U3065-2435Oxy Box Assy417U3081-4221Oxy Box Assy417U3025-7221BReading Light -Outboard
Back to Boeing 747-400D