Boeing 737-476
PMA parts · 66,360
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 ('A16WE')
AND len(list_intersect(tcds_models, ['737-400 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 ('A16WE')
AND len(list_intersect(tcds_models, ['737-400 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.
BACJ40AB24-8BONDING JUMPERBACC10DK3CLAMP, LOOPBACC63BP18C14P8CONNECTOR, ELECTRICABACP30F9PULLEYBACC47CN1ACONTACT, PINBACC45FT14-15S6CONNECTOR, ELECTRICABACT12AC1TERMINAL, LUGBAC1521-685SEALBACC45FT20A41SCONNECTOR, ELECTRICABACJ40A21-8BONDING JUMPERBACC63BV14F4SNCONNECTOR, ELECTRICABACJ40AD46-6BONDING JUMPERBACC63CB20-16SNCONNECTOR, ELECTRICABACJ40AB26-10BONDING JUMPERBACC10DU200ABECLAMP, MISCELLANEOUSBACC45FT14C7SCONNECTOR, ELECTRICABACC63BP16D10SNCONNECTOR, ELECTRICABACJ40A22-9BONDING JUMPERBAC1521-716GROMMETBACC14AD06DCAPBACC63BP16H10SNCONNECTOR, ELECTRICABACJ40D11-20BONDING JUMPERBACC63BP20D16SNCONNECTOR, CIRCULARBACP30F4PULLEYBACC15AJ1CLIP, LOCKINGBACJ40K5A7A5BONDING JUMPERBACC10DK5CLAMP, LOOPBACC47CN2APIN CONTACTBACC45FT12-3SCONNECTOR, ELECTRICABACP11K7PACKINGBACP11K12PACKINGBACD40W48-0032HOSEDUCT, MOBILITYBACC63CE24A22SCONNECTOR, CIRCULARBACL10AR2BLATCH, FLUSH, PUSH BBAC1521-598RUBBER - EXTRUDEDBACJ40A21-7BONDING JUMPERBACC63BP18C8PNCONNECTOR, ELECTRICABACC45FT12-12SCONNECTOR, ELECTRICABACC45FN14-12PCONNECTOR, ELECTRICABACC10GT1-08CLAMP ASSEMBLYBACC45FT16A24SCONNECTOR, ELECTRICABACC63BP14B7SNLCONNECTOR, CIRCULARBAC1521-681AERODYNAMIC SEALBACC10DU400ABECLAMP, MISCELLANEOUSBACJ40A20-7BONDING JUMPERBACC45FN24-43PCONNECTOR, ELECTRICABACC10DK16CLAMP, LOOPBACC45FT18A14PCONNECTOR, ELECTRICABACC45FT12-12PCONNECTOR, ELECTRICABACJ40D20-16BONDING JUMPER
Back to Boeing 737-476