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.
AIW74252005-15SB KITAI045-13001LNMODULE ASSYAIW74252005-3SB KITAIW74252005-6SB KITAFR74251767-22SB KITAIW74252005-11SB KITAFR74251767-24SB KIT521786-2SB KITB0045170-0522LNCLOSURE PANELAFR7433-1GALLEY ASSY-G7AFR7434-1GALLEY ASSY-G6AAFR74251767-3SB KITAI043-10041LNMODULE ASSYAFR7475-51GALLEY ASSY-U/D (CENTER)VGT4163000G03RH PARTITION, ZONE CAFR7474-51ZZINSTALLATION KIT-U/DAFR7404-1ZZINSTALLATION KIT-DOOR 4AFR7402-1ZZINSTALLATION KIT-DOOR 2AFR7477-1GALLEY ASSY-U/D (R/H)AIW74252005-1SB KITAIN04252352-1SB KITAFR7432-1GALLEY ASSY-G6AFR7401-11ZZINSTALLATION KIT-DOOR 1AFR74251767-2SB KITAFR7401-51ZZINSTALLATION KIT-DOOR 1AFR7421-1GALLEY ASSY-G3AI044-16001LNMODULE ASSYAI048-10001LNMODULE ASSYAFR7412-1GALLEY ASSY-G2AIW74252005-16SB KITAIW74252005-9SB KITAFR74251767-11SB KITAFR7401-1ZZINSTALLATION KIT-DOOR 1AFR74251767-4SB KITVGT4162000G01LH PARTITION, ZONE AAI043-10051LNMODULE ASSYAFR74251767-32SB KITAIW74252005-13SB KITAI042-10051LNMODULE ASSYAFR7431-1GALLEY ASSY-G5AIW74252005-8SB KITAFR74251767-1SB KITAFR74251767-12SB KITAIW74252005-7SB KITAIW74252005-18SB KITAI045-13011LNMODULE ASSYAFW748-101VIDEO STOWAGE ASSYB0045170-0501LNCLOSURE PANELVGT4163000G01LH PARTITION, ZONE CAFR7402-51ZZINSTALLATION KIT-DOOR 2
Back to Boeing 747-400D