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.
BACJ40AD44-12BONDING JUMPERBACJ40AC44-12JUMPERBACC63BP14H7S6CONNECTOR, ELECTRICALBACC45FT14A15SCONNECTOR, ELECTRICABACC45FT14A12SCONNECTOR, ELECTRICALBACC47DE1ACONTACTBACG10AD56BGASKET, SEALBACC47CN2CONTACT, PINBACC15AJ1ACLIPBACC10DK2CLAMP, LOOPBACP11K5APACKINGBAC1521-762MISCELLANEOUS RUBBERBACP11K4PACKINGBACJ40AB22-4BONDING JUMPERBACC45FN18-31P6CONNECTOR, ELECTRICABACC63BP10D5SNCONNECTOR, ELECTRICABACC45FN12-12P6CONNECTOR, ELECTRICABACJ40K5A5A5BONDING JUMPERBACC10GE26CLAMP, LOOPBACC45FT18A31S7CONNECTOR, ELECTRICABACC45FT20C25PCONNECTOR, ELECTRICABACC45FT22-55S6CONNECTOR, ELECTRICABACC63BP16A24P8LCONNECTOR, CIRCULARBACC45FN16-24P9CONNECTOR, ELECTRICABACS31H2BRINGPOST, WIRE HARNEBACC10GE8CLAMP, LOOPBACJ40AB27-7JUMPER ASSYBACT12AC62TERMINAL, LUGBACJ40AB22-5BONDING JUMPERBACJ40AB20-12BONDING JUMPERBACC10DK12CLAMP, LOOPBACT12M140TERMINALBACC63CE24-22SCONNECTOR, PLUGBACC10DK4CLAMP, LOOPBACC45FT16-24P8CONNECTOR, ELECTRICABACC45FT14C15PCONNECTOR, ELECTRICABACC65AJ141SCONNECTOR, ELECTRICABACC14AD06JLCAPBACC47EG2CONTACT, SOCKETBACC10GT2-04CLAMP ASSEMBLYBACS31H1ARINGPOST, WIRE HARNEBACJ40A21-6BONDING JUMPERBACC63CE14SA5SCONNECTOR, CIRCULARBACC45FT22-55P9CONNECTOR, ELECTRICABACC63BP22A19S6LCONNECTOR, PLUGBACC45FT20-25PCONNECTOR, ELECTRICABAC1530-223Micelleneous rubber, fabric covered or ReinforcedBAC1530-224Micelleneous rubber, fabric covered or ReinforcedBACC45FT22A55PCONNECTOR, ELECTRICABACC63CB12-12SNCONNECTOR, ELECTRICA
Back to Boeing 747-400D