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.
BAC29PPS15045MarkerBAC29PPS15100MarkerBAC29PPS15106MarkerBAC29PPS15113MarkerBAC29PPS15050MarkerBAC29PPS15107MarkerBAC29PPS15094MarkerBAC29PPS15059MarkerBAC29PPS15049MarkerBAC29PPS15052MarkerBAC29PPS15096MarkerBAC29PPS15058MarkerBACC47CN2SCONTACTBAC1530-76SEALBACJ40AB20-5BONDING JUMPERBACC45FN22-55P8CONNECTOR, ELECTRICABACC47CP1SCONTACT, SOCKETBACJ40AB20-10BONDING JUMPERBACC45FN22-19PCONNECTOR, ELECTRICABACC63BP18H31PNCONNECTOR, ELECTRICALBACJ40AB20-6BONDING JUMPERBACC63CE24A22PCONNECTOR, PLUGBACJ40AC44-8JUMPERBACC10DK24CLAMP, LOOPBACC45FT18-31PCONNECTOR, ELECTRICABACC63BP16H24PNCONNECTOR, ELECTRICALBACC10FY081SECLAMP, BANDBACJ40AD45-11BONDING JUMPERBACC47CN1CONTACT, PINBACC47DJ2CONTACT, SOCKETBACC10GE27CLAMP, LOOPBACC45FM12-3PCONNECTOR, ELECTRICALBACC45FT16A24PCONNECTOR, ELECTRICABACC45FT10B5SCONNECTOR, ELECTRICABACC45FN24-61P6CONNECTOR, ELECTRICABACC45FN12-12SCONNECTOR, ELECTRICABACC10DK7CLAMP, LOOPBACC47DE7ACONTACT, PINBAC1521-780SCOOPBACC45FT16A24P9CONNECTOR, ELECTRICABACC14AD06JCAPBACC63BP18H14SNCONNECTOR, ELECTRICALBACJ40AC44-7JUMPERBACC10GT3-06CLAMP ASSEMBLYBACC10BN400L5MECLAMPBACC14AD4CAPBACC45FT14A7SCONNECTOR, ELECTRICABACC63BP12H3S6CONNECTOR, ELECTRICALBACC45FN10-5PCONNECTOR, ELECTRICABACC45FN10-5SCONNECTOR, ELECTRICA
Back to Boeing 747-400D