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.
0340-29-0024-9Tube Assy, HYD, Wheel Well, B737-400 MCD0340-29-0034-9Tube Assy, HYD, Wheel Well, B737-400 MCD0340-24-0006-9Loose Wire007-00522-13Inner Skin0340-29-0056-9Tube Assy, HYD, HYD Panel, B737-400 MCD007-00500-69Installation -4000340-25-0007-129Insulation Blanket Assy0340-25-0007-89Insulation Blanket Assy0340-24-0001-19Freighter Installation0340-29-0042-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-33-0002-9Loose Wire0340-29-0054-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-53-0013-19Tube0340-29-0059-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-25-0007-169Insulation Blanket Assy0340-29-0022-9Tube Assy, HYD, Wheel Well, B737-400 MCD0340-29-0053-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-25-0007-139Insulation Blanket Assy0340-25-0007-159Insulation Blanket Assy0340-25-0007-119Insulation Blanket Assy0340-29-0058-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-53-0013-13Fitting0340-29-0026-9Tube Assy, HYD, Wheel Well, B737-400 MCD0340-25-0007-109Insulation Blanket Assy0340-25-0007-99Insulation Blanket Assy0340-29-0044-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-29-0001-49Wire Harness0340-29-0029-9Tube Assy, HYD, Wheel Well, B737-400 MCD0340-24-0005-19MCD Jumper Harness0340-25-0007-19Insulation Blanket Assy0340-53-0012-9Roller Guide Install0340-29-0060-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-29-0038-9Tube Assy, HYD, Wheel Well, B737-400 MCD0340-29-0061-9Tube Assy, HYD, HYD Panel, B737-400 MCD007-00400-59Sub-Assy (737-400)0340-29-0057-9Tube Assy, HYD, HYD Panel, B737-400 MCD007-00120-49Installation (without Airstairs)0340-29-0050-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-24-0001-9Combi Installation0340-29-0049-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-25-0007-79Insulation Blanket Assy0340-29-0031-9Tube Assy, HYD, Wheel Well, B737-400 MCD0340-29-0041-9Tube Assy, HYD, HYD Panel, B737-400 MCD0340-29-0036-9Tube Assy, HYD, Wheel Well, B737-400 MCD007-00404-15Intercostal0340-53-0013-17Tube0340-53-0013-23Shaft007-00401-15Channel0340-29-0043-9Tube Assy, HYD, HYD Panel, B737-400 MCD007-00516-15Longeron
Back to Boeing 737-476