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.
EVW74252281-1SB KITCHI04252706-5SB KIT FOR DS1JD-24AD00-003TOP KIT COLLECTORBR045190-002LRSTUB WALLDAL1615M0-907TOP KIT COLLECTORTGW740252829-2SB KIT FOR G8 GALLEYBAC27WEL1430MarkerBAC27WEL1410MarkerBAC27WEL1424MarkerBAC27WEL1429MarkerBAC27WEL1427MarkerBAC27WEL1415MarkerBAC27WEL1425MarkerBAC27WEL1419MarkerBAC27WEL1426MarkerBAC27WEL1412MarkerBAC27WEL1417MarkerBAC27WEL1420MarkerBAC27WEL1428MarkerBAC27WEL1418MarkerBAC27WEL1421MarkerBAC27WEL1414MarkerBAC27WEL1416MarkerBAC27WEL1413MarkerBAC27WEL1411MarkerBAC27WEL1431Marker7333FT-160ATSElastomer150462-1WEFilter AssemblyAFR74251767-21SB KITB0045170-0511LNCLOSURE PANELAIW74252124-1SB KITAFR7474-1ZZINSTALLATION KIT-U/DAFR74251767-5SB KITAI042-10041LN DMODULE ASSYB0045170-0521LNCLOSURE PANELAI045-10011LNMODULE ASSYAFR74251767-33SB KITAFR74251974-1SB KITAFR74251767-13SB KITVGT4161000G01NOSE CLOSEOUTAFR7422-1GALLEY ASSY-G3A/G3BAFR74251767-34SB KITVGT4162000G02RH PARTITION, ZONE AAIW74252005-17SB KITAFR7476-1GALLEY ASSY-U/D (L/H)AIW74252005-14SB KITAFR74251767-23SB KITAI044-16011LNMODULE ASSYAFR7421-51GALLEY ASSY-G3AIW74252005-2SB KIT
Back to Boeing 747-400D