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.
BACT12AC74TERMINAL, LUG, POLYABACC45FT12-12PCONNECTOR, ELECTRICABACS31H1BRINGPOST, WIRE HARNEBACC45FM16-24PCONNECTOR, ELECTRICABACC45FN20-28PCONNECTOR, ELECTRICABACC45FT12A12SCONNECTOR, ELECTRICABACC10GE3CLAMP, LOOPBACC10GE8CCLAMP, LOOPBACC45FT10-5SCONNECTOR, ELECTRICABACJ40A30-5BONDING JUMPERBACC63BP10A5S6LCONNECTOR, PLUGBACJ40AD44-7BONDING JUMPERBACC45FT10A5P6CONNECTOR, ELECTRICABACC63BP24C43P7CONNECTOR, ELECTRICABACC10DK10CLAMP, LOOP, TUBE ANBACC45FT20-25SCONNECTOR, ELECTRICABACJ40AB20-7BONDING JUMPERBACR12BU13SRINGBACC45FT14-7PCONNECTOR, ELECTRICABACJ40K5A5A6BONDING JUMPERBACT12AC16TERMINAL, LUGBAC1530-44Section -Rubber ExtrudedBACC45FT22-55P8CONNECTOR, ELECTRICABACJ40K5A7A8BONDING JUMPERBACC10DU350ABECLAMP, MISCELLANEOUSBACC47CP2SOCKETBACC45FT16-24SCONNECTOR, ELECTRICABACJ40AC44-6JUMPERBACP30M3CPULLEYBACC63CB18-8SNCONNECTOR, ELECTRICABACC45FN14A15PCONNECTOR, ELECTRICABACC10DK6CLAMP, LOOPBACC45FN16-24PCONNECTOR, ELECTRICABACC45FN14-7SCONNECTOR, ELECTRICABACT12AC19TERMINAL, LUGBACC10FY063SECLAMP, BANDBACC45FT14C12PCONNECTOR, ELECTRICABACJ40K5A5A8JUMPERBACC45FT12-12P6CONNECTOR, ELECTRICABACC65AJ111SCONNECTOR, ELECTRICABACC45FT12-12S6CONNECTOR, ELECTRICABACC10BN262L5MECLAMPBACC47EG3CONTACT, SOCKETBACC63BP14A7SNLCONNECTOR, PLUGBACC45FN14-12SCONNECTOR, ELECTRICABACJ40AD44-10JUMPERBAC1523-9MOHAIRBACJ40D20-24BONDING JUMPERBACP30M1APULLEYBACC47CP1ASOCKET CONTACT
Back to Boeing 747-400D