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.
B737-MKCL-0019-HWWire Installation Hardware KitB737-MKCL-0019-WRWire Routing KitB737-MKCL-0017-AKStructural Installation KitBAC29PPS33852MarkerBAC29PPS45165MarkerBAC27DPA5304MarkerBAC29PPS22094MarkerBAC29PPS33851MarkerBAC29PPS48907MarkerBAC29PPS45151MarkerBAC29PPS45167MarkerBAC29PPS45161MarkerBAC29PPS48901MarkerBAC29PPS33481MarkerBAC29PPS51177MarkerBAC29PPS34955MarkerBAC29PPS33345MarkerBAC29PPS34954MarkerBAC29PPS36219MarkerDG222-9807A1-11Routing, Rescu 406AFN2ELT, B737-200/300/400/500PL23-9807A1-12ELT Transmitter Mod KitPL23-9807A1-01ELT Transmitter Mod KitPL23-9807A1-11ELT Transmitter Mod KitDG222-9807A1-12Routing, Rescu 406AFN2ELT, B737-200/300/400/50065-53875-19JPGasketPM-585Tail Bullet Mask2609691ABPlate-Warning2612856ABPlate-WarningBACB10Y4ROD ENDBACB10AG4MBearingBACB10AG4MCBearingBACB10AG22CBearingBACB10Y4TROD ENDBACB10AB10MBearingBACB10AB20MBearingBACB10Y6MBEARING, ROD END, PLAIN SPHERICAL, MALEBACB10AG4BearingBACB10AB12MBearingBDS20H-121BEARING, SPHERICALBACB10Y6TROD ENDN65-45791- 2Pane, Outer Passenger WindowN65-45792- 1Pane – Middle, Passenger WindowN65-45792- 2Pane – Middle, Passenger WindowN65-45790- 59Cabin Window AssemblyN65-45792- 5Pane – Middle, Passenger WindowN65-45791- 4Pane, Outer Passenger WindowN140N213 8-1Pane – Outer Passenger WindowN65-45792- 4Pane – Middle, Passenger WindowN65-45790- 61Cabin Window AssemblyN65-45792- 3Pane – Middle, Passenger Window
Back to Boeing 737-476