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.
BACC10GT3-04CLAMPBAC1521-673SECTION - RUBBER EXTRUDEDBACC45FT18-14PCONNECTOR, ELECTRICABACC45FN12-12PCONNECTOR, ELECTRICABACC10GT2-08CLAMP ASSEMBLYBACC45FT22-55PCONNECTOR, ELECTRICABACC63CB10-5SNCONNECTOR, ELECTRICABACP30M1ACPULLEYBACP11K5PACKINGBACH20X3HINGEBACC10GT1-06CLAMP ASSEMBLYBACS38Y1SUPPORTBAC1530-17SEALBACJ40A20-20BONDING JUMPERBACC15AJ2CLIPBACC63BP18H31P7CONNECTOR, ELECTRICALBACC63BP14A4SNLCONNECTOR, CIRCULARBACC45FT8-3PCONNECTOR, ELECTRICABACC63CB14-7SNCONNECTOR, ELECTRICABACJ40AB20-28BONDING JUMPERBACC45FT8-3SCONNECTOR, ELECTRICABACJ40A20-5BONDING JUMPERBACJ40AD45-12BONDING JUMPERBACC10GT2-06CLAMP ASSEMBLYBACC45FN22-55PCONNECTOR, ELECTRICABACJ40A20-3BONDING JUMPERBACC63BP14B7PNLCONNECTORBACC63BP18A31P7CONNECTOR, PLUGBACC45FN16-24P7CONNECTOR, ELECTRICABACC45FT20-16SCONNECTOR, ELECTRICABACP30M4CPULLEYBACJ40A21-12BONDING JUMPERBACC10GE4CLAMP, LOOPBACC10FY128TECLAMP, BANDBACJ40AB24-8BONDING JUMPERBACJ40AB22-7BONDING JUMPERBACT12AC13TERMINAL, LUGBACJ40AB20-16BONDING JUMPERBACC45FT18A31S8CONNECTOR, ELECTRICABACC10DK3CLAMP, LOOPBACC45FT16-10SCONNECTOR, ELECTRICABACC47CN3CONTACT, PINBAC1521-678AERODYNAMIC SEALBACJ40K5A5A14BONDING JUMPERBACC47CN1ACONTACT, PINBACC63BN14C7SNCONNECTOR, ELECTRICABACS38Y2SUPPORT, WIRE HARNESBACC47ER1CONTACT, SOCKETBACT12M4TERMINALBACC45FT20A41SCONNECTOR, ELECTRICA
Back to Boeing 747-400D