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.
800-010146-1LIGHTPLATE VERTICAL T SECTION425-10-1LIGHTPLATE - PTT/CLOCK RIGHTSIDE800-010409-1LIGHTPLATE HORIZONTAL T SECTION800-010171-1LIGHTPLATE VERTICAL T SECTION800-010852-1LIGHTPLATE HORIZONTAL T SECTION800-011957-1LIGHTPLATE - FLASH HORIZONTAL T-SECTION800-009953-1LIGHTPLATE - OVERHEAD PANEL HORIZONTAL T-SECTION425-11-1LIGHTPLATE - PTT/CLOCK LEFTSIDE800-011953-1LIGHTPLATE800-011968-1LIGHTPLATE - FLASH HORIZONTAL T-SECTION504-200ATSChannel Band Sleeve1145-0015MAGNA-SWITCH, WATER QUANTITY,TRAMSMITTER1145-0035MAGNA-SWITCH, WATER QUANTITY,TRAMSMITTER870700-604AIRSTAIR ASSEMBLY-FWD 73717351-400CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE504-700SLEEVE- CHANNEL BAND51200-2-300CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE504-200SLEEVE CHANNEL BAND42535-200SCOUPLING .1900 T-BOLT, QUICK COUPLER, CHANNEL BAND57490-336CLAMP- .1900-32 T-BOLT51200-2-250CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE17351-200CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE504-650SLEEVE CHANNEL BAND11684BLOCK LUG504-550SLEEVE CHANNEL BAND51200-2-200CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE51200-2-450CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE631-700SHCOUPLING .250 T-BOLT CHANNEL BAND51200-2-100CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE24366-200SLEEVE4101-900SCOUPLING- .190-32 T-BOLT 55 DEGREE V-BANDCF15-650JOINT ASSEMBLY FLEXIBLE HOT AIR24098-300SLEEVE16502-200CLAMP631-650SHCOUPLING .250 T-BOLT CHANNEL BAND24098-250SLEEVE4353-1191SHCOUPLING 1/4 QUICK COUPLER, 40 DEGREE V-BAND450-75-300WCLAMP .250 T-BOLT QUICK COUPLER51200-2-350CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE16502-350CLAMP17351-100CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE631-800SHCOUPLING .250 T-BOLT CHANNEL BAND24170-450ACLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE17351-350CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE365-62-635SCLAMP- .1900-32 QUICK COUPLER CODED17351-450CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE17351-250CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE601-550SHCOUPLING .1900 T-BOLT, QUICK COUPLER, CHANNEL BAND24098-350SLEEVE802-512CLAMP BAND .190-24 SCREW
Back to Boeing 737-476