Skip to content

Boeing 737-287C

PMA parts · 38,312

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-200C 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-200C Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC

Run 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.

2887328AA-77Rail Cover Assembly., 4.0, Bev.Approved Aeronautics LLC · Replaces 90870-37,-57 · Jul 15, 2004 2887328AA-13Base Cover Assembly.Approved Aeronautics LLC · Replaces 90840-23, -31 · Jul 15, 2004 2887328AA-15Rail Cover Assembly., 4.0Approved Aeronautics LLC · Replaces 90870-10,-38 · Jul 15, 2004 B3459-7HeaterMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Vautier Lacroix P/N 7001119 Lermer P/N… · Jul 13, 2004 A3446-9StrikeMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N SB83314CE · Jul 13, 2004 C3274-7Lid GasketMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N B5377 · Jul 13, 2004 B3489-10Spigot AssemblyMidwest Aircraft Prod Co · Replaces Vautier Lacroix 00222-01, Lermer… · Jul 13, 2004 B3458-20Heater TrayMidwest Aircraft Prod Co · Replaces Mansfield C6656 · Jul 13, 2004 B3459-7HeaterMidwest Aircraft Prod Co · Replaces Vautier Lacroix 7001119, Lermer… · Jul 13, 2004 A3469-7Wave WasherMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N B60361-7 · Jul 13, 2004 B10253-7Widget PlugMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N B56485-7 · Jul 13, 2004 C3274-7Lid GasketMidwest Aircraft Prod Co · Replaces Vautier Lacroix 7001102, Lermer T1738381 · Jul 13, 2004 B10163-10ReceptacleMidwest Aircraft Prod Co · Replaces Lermer U58081402, Mansfield C33300-20 · Jul 13, 2004 A10237-7BracketMidwest Aircraft Prod Co · Replaces Vautier Lacroix 7001124 · Jul 13, 2004 A3446-7CatchMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N… · Jul 13, 2004 A3456-7ThermostatMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Vautier Lacroix P/N 7001120 Lermer P/N… · Jul 13, 2004 A3446-7CatchMidwest Aircraft Prod Co · Replaces Mansfield CB83314-2200CE · Jul 13, 2004 A3474-7Retaining NutMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N C3728-7 · Jul 13, 2004 A3469-7Wave WasherMidwest Aircraft Prod Co · Replaces Mansfield B60361-7 · Jul 13, 2004 A4135-7Lid GasketMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Vautier Lacroix P/N 7001102 Lermer P/N… · Jul 13, 2004 A10236-7BracketMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Vautier Lacroix P/N 7001123 · Jul 13, 2004 B10163-10ReceptacleMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Lermer P/N U58081402 BE Aerospace/… · Jul 13, 2004 B10291-7BracketMidwest Aircraft Prod Co · Replaces Lermer T81221050 · Jul 13, 2004 B3489-10Spigot AssemblyMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Vautier Lacroix P/N 00222-01 Lermer… · Jul 13, 2004 B10250-7Spigot AdapterMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N B4196-2 · Jul 13, 2004 B10253-7Widget PlugMidwest Aircraft Prod Co · Replaces Mansfield B56485-7 · Jul 13, 2004 A3466-7O Ring GasketMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N C33300-9 · Jul 13, 2004 C3274-7Lid GasketMidwest Aircraft Prod Co · Replaces Mansfield B5377 · Jul 13, 2004 B10250-7Spigot AdapterMidwest Aircraft Prod Co · Replaces Mansfield 4196-23 · Jul 13, 2004 A3467-7O RingMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N C3728-19 · Jul 13, 2004 A10237-7BracketMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Vautier Lacroix P/N 7001124 · Jul 13, 2004 A3435-7Insert NutMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N C3728-14 · Jul 13, 2004 A3466-7O Ring GasketMidwest Aircraft Prod Co · Replaces Mansfield 33300-9 · Jul 13, 2004 10952 Gallon Liquid ContainerMidwest Aircraft Prod Co · Replaces Aircraft Products Corp. Models 180-146 · Jul 13, 2004 A3456-7ThermostatMidwest Aircraft Prod Co · Replaces Vautier Lacroix 7001120, Lermer… · Jul 13, 2004 A3446-9StrikeMidwest Aircraft Prod Co · Replaces Mansfield SB83314CE · Jul 13, 2004 D10120-20Liquid Container 2 Gallon Model 1095Midwest Aircraft Products Company · PMA PQ2372CE · Replaces Mansfield Model 180-146 · Jul 13, 2004 B10126-10ReceptacleMidwest Aircraft Prod Co · Replaces Vautier Lacroix 7001125, Lermer… · Jul 13, 2004 B3458-20Heater TrayMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N B6656 · Jul 13, 2004 A3474-7Retaining NutMidwest Aircraft Prod Co · Replaces Mansfield 3728-7 · Jul 13, 2004 A10236-7BracketMidwest Aircraft Prod Co · Replaces Vautier Lacroix 7001123 · Jul 13, 2004 A3435-7Insert NutMidwest Aircraft Prod Co · Replaces Mansfield C3728-14 · Jul 13, 2004 A3468-7Adapter RingMidwest Aircraft Products Company · PMA PQ2372CE · Replaces BE Aerospace/ Mansfield P/N C3728-8 · Jul 13, 2004 B10126-10ReceptacleMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Vautier Lacroix P/N 7001125 Lermer P/N… · Jul 13, 2004 A3468-7Adapter RingMidwest Aircraft Prod Co · Replaces Mansfield C3728-8 · Jul 13, 2004 A3467-7O RingMidwest Aircraft Prod Co · Replaces Mansfield C3728-19 · Jul 13, 2004 B10291-7BracketMidwest Aircraft Products Company · PMA PQ2372CE · Replaces Lermer P/N T81221050 · Jul 13, 2004 P00460Bushing, UpperAviation Component Solutions · Replaces Grimes Aerospace Company 32-0897-9… · Jul 12, 2004 A0321VXWLMarker- Oxygen etc.Aero Decals Inc · Replaces Aero Decals A0321VXWL · Jul 8, 2004 A0359VBWMarker- B737 etc.Aero Decals Inc · Replaces Aero Decals A0359VBW · Jul 8, 2004

Back to Boeing 737-287C