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.
TA025041-26STClampTA025041-04STClampTA025041-15STClampTA025041-08STClampTA025041-22STClampTA025041-24STClampTA025041-19STClampTA025041-11STClampTA025041-07STClampTA025041-25STClampTA025041-23STClampTA025041-02STClampAAP- 585898Bearing422B340LAOverhaul KitT-411N1144-1-74Shade-Window PanelT-10-1327-759Lens AssemblyA-411N1133-3C1Inner Pane-Cabin WindowA-65-21912-8B2Inner Pane- Cabin WindowA-411N1133-7B2Inner Pane-Cabin WindowAMB8V4029BEARING
ASSEMBLY –SLOTTED ENTRYAMB8V4029Bearing Assembly-Slotted EntryAMB8V4019BEARING
ASSEMBLY –SLOTTED ENTRYAMB8V4019Bearing Assembly-Slotted EntryP01532PoppetP01410AshtrayAV1292-3Air Outlet AssemblyHSP128D-219-050KTSpacer106995-1-100-660KTBoltHSP207-1-1290KTRivetH2868-1-100-660KTPush Button Latch Assy100806-15KTBracket100818-1KTBolt Spring100816-3KTPin100931-1-112KTButton Bolt100929-1KTTrigger Button Gasket101123-1KTTrigger100930-1KTBolt Gasket101535-1KTTrigger Button Bottom100819-1KTTrigger Spring113764-1-100KTTrigger ButtonH2868-1-100-660KTPush Button Latch Assy384-1Air Chiller344-1Air Chiller311-1Model 311 4500 BTU/H Air ChillerT-411N1281-1-74Shade-Window PanelBAC27DEX6854MarkerBAC27DCC2920MarkerBAC27DEX6857MarkerBAC29PPS60365MarkerBAC29PPS43520Marker
Back to Boeing 737-476