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.
BACJ40A21-8BONDING JUMPERBACC63BP22A19SNLCONNECTOR, ELECTRICALBACC47CP2ACONTACTBACC63CN1203PNCONNECTOR, RECEPTBAC1530-5MISCELLANEOUS, RUBBERBACJ40K5A6A11BONDING JUMPERBACC45FT14C7SCONNECTOR, ELECTRICABACG10AD32YCGASKET, SEALBACJ40A20-18BONDING JUMPERBACC45FM10C5SCONNECTOR, RECEPTACLBACC63BP12R3SNLCONNECTOR, CIRCULARBACJ40AD45-14BONDING JUMPERBACC14AD06DCAPBACC63BP24C43P8CONNECTOR, ELECTRICABACC45FN10-5S6CONNECTOR, ELECTRICABACJ40AB27-10BONDING JUMPERBACC45FT18-8SCONNECTOR, ELECTRICABACC47DE7CONTACTBACB42F4BAND, SHIELD TERMBAC1521-739SEALBACC10FY069SECLAMP, BANDBACP30F4PULLEYBACC15AJ1CLIP, LOCKINGBACC45FT10D5SCONNECTOR, ELECTRICABACJ40D10-20JUMPERBACC10DK5CLAMP, LOOPBACC47CN2APIN CONTACTBACC45FT12-3SCONNECTOR, ELECTRICABACP11K7PACKINGBACC10GE9CLAMP, LOOPBACP11K12PACKINGBACC45FT22-55P6CONNECTOR, ELECTRICABACC63CE24A22SCONNECTOR, CIRCULARBACJ40AD44-6BONDING JUMPERBACJ40A21-7BONDING JUMPERBACC14AD06CAPBACC45FT12-12SCONNECTOR, ELECTRICABACC45FN14-12PCONNECTOR, ELECTRICABACC45FT18A14SCONNECTOR, ELECTRICABACC10GT1-08CLAMP ASSEMBLYBACC45FT16A24SCONNECTOR, ELECTRICABACC63BP18A14SNLCONNECTOR, PLUGBACC45FN18-31S8CONNECTOR, ELECTRICABAC1521-681AERODYNAMIC SEALBACJ40A20-7BONDING JUMPERBAC1530-3Section -Rubber ExtrudedBAC1521-827MISCELLANEOUS, RUBBERBACC45FN20-41S9CONNECTOR, ELECTRICABACC45FN24-43PCONNECTOR, ELECTRICABACC10DK16CLAMP, LOOP
Back to Boeing 747-400D