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.
BAW740-530-11ZZDOOR 1 INSTALLATION KITCAW7432-1GALLEY ASSY - NO. 4BSQW740-830-31ZZINSTALLATION KIT - DOOR 2BAW757-31GALLEY ASSY - G3ABAW740-1694-1ZZDOOR 4 INSTALLATION KITMHW742-1GALLEY ASSY - G2BAW740-830-11ZZDOOR 2 INSTALLATION KITMHW741-1GALLEY ASSY - G1AGW740-530-1ZZINSTALLATION KIT - DOOR 1SQW739-21STOWAGE CENTER - AAIW7411-11GALLEY UNIT - NO. 1AIW7432-11GALLEY UNIT - NO. 8CIW7404-1ZZINSTALLATION KIT - DOOR 4AIW7431-1GALLEY UNIT - NO. 7MHU744-21GALLEY ASSY - G4AIW7501-1STOWAGE UNIT - NO. 1KLW745-11GALLEY ASSY - G5KLW74U-1UNIT ASSY GALLEY - UPPER DECKKLW745-1GALLEY ASSY - G5SQW740-530-21ZZINSTALLATION KIT - DOOR 1AIW7502-11STOWAGE UNIT - NO. 2MHW748-91UNIT ASSY - U/STGW740-830-11ZZINSTALLATION KIT - DOOR 2SQW759-1UNIT ASSY - G5BKLW743-1GALLEY ASSY - G0/G3/G3AAGW745-1UNIT ASSY - G2DCAW7406-11GALLEY ASSY - G4CSQW744-21/-31UNIT ASSY - GALLEY G4CAW7408-1GALLEY ASSY - G4DCAW7456-1GALLEY ASSY - NO. 2CAGW742-1UNIT ASSY - G1BAGW747-1UNIT ASSY - G4BMHW740-630-21ZZINSTALLATION KIT - DOOR 1JAG745-1GALLEY ASSY - NO. 5CIW7412-1GALLEY ASSY - G2AGW747-11UNIT ASSY - G4BAIW7434-1GALLEY UNIT - NO. 10CAW7452-1GALLEY ASSY - NO. 1CAIW7410-11FWD BAR UNITKLW748-1GALLEY ASSY - G8KLW740-DR2-11ZZINSTALLATION KIT - DOOR 2AGW743-1UNIT ASSY - G2A/G2BCIW7431-1GALLEY ASSY - G5AGW740-1694-1ZZINSTALLATION KIT - DOOR 4KEC749-71UNIT ASSY - U/DKLW741-1GALLEY ASSY - G1/G2MHU749-31GALLEY ASSY - UPPER DECKSQW749-1UNIT ASSY - UPPER DECKAGW749-1UNIT ASSY - UPPER DECKSQW746-51UNIT ASSY - GALLEY G7
Back to Boeing 747-400D