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.

BACU24AB6HUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB6H · Mar 21, 2004 BACS13BX08HSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX08H · Mar 21, 2004 BACN10YL04 Spec Rev L 8-5-99Nut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL04 · Mar 21, 2004 BACC14AD4DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD4D · Mar 21, 2004 BACC14AD8JCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD8J · Mar 21, 2004 BACU24AA0410Union, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0410 · Mar 21, 2004 BACN10CS08DNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS08D · Mar 21, 2004 BACU24AB08WUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB08W · Mar 21, 2004 BACN10YL08LNut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL08L · Mar 21, 2004 BACU24AA0608DUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0608D · Mar 21, 2004 BACC14AD05JLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD05JL · Mar 21, 2004 BACN10CS16DNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS16DN · Mar 21, 2004 BACU24AA0605DUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0605D · Mar 21, 2004 BACC14AD08DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD08D · Mar 21, 2004 BACS13BX04HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX04HP · Mar 21, 2004 ME596369-3005Cover AssyMechanical Enterprises, Inc. · PMA PQ1359CE · Replaces Boeing P/N 5-96369-3005 · Mar 21, 2004 BACN10CS4JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS4JN · Mar 21, 2004 BACC14AD10JCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD10J · Mar 21, 2004 BACN13BX10HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX10HP · Mar 21, 2004 BACC14AD8DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD8D · Mar 21, 2004 BACN10CS5DNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS5DN · Mar 21, 2004 BACC14AD6DLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD6DL · Mar 21, 2004 BACN10YL16LNut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL16L · Mar 21, 2004 BACN10YL10LNut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL10L · Mar 21, 2004 BACC14AD5DMCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD5DM · Mar 21, 2004 BACC14AD6JCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD6J · Mar 21, 2004 BACN10CS5NNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS5N · Mar 21, 2004 BACN10YE16LNut, coupling, Lightweight,FlarelessAtlas Specialty Products · Replaces BACN10YE16L · Mar 21, 2004 BACN10CS06DHNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS06DH · Mar 21, 2004 BACN10YA4Nut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA4 · Mar 21, 2004 BACS13BX06HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX06HP · Mar 21, 2004 BACU24AA0406Union, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0406 · Mar 21, 2004 BACU24AB16WUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB16W · Mar 21, 2004 BACN10CS06DNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS06D · Mar 21, 2004 BACN10YL12NNut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL12N · Mar 21, 2004 BACS13BX04HSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX04H · Mar 21, 2004 BACU24AB12HUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB12H · Mar 21, 2004 BACN10YE10NNut, coupling, Lightweight,FlarelessAtlas Specialty Products · Replaces BACN10YE10N · Mar 21, 2004 MKSP5NJCBearing, RollerRBC Heim Bearings · PMA PQ1036NE · Replaces BACB10AR05 · Mar 18, 2004 5-89354-3136Window AssemblyPPG Industries Inc · Replaces 5-89354-3136 · Mar 18, 2004 GDSRP5NJCBearing, RollerRBC Heim Bearings · PMA PQ1036NE · Replaces BACB10C161GH · Mar 18, 2004 DSRP4NJCBearing, RollerRBC Heim Bearings · PMA PQ1036NE · Replaces BACB10C160H · Mar 18, 2004 5-89354-3135Window AssemblyPPG Industries Inc · Replaces 5-89354-3135 · Mar 18, 2004 5-89358-41Window AssemblyPPG Industries Inc · Replaces 5-89358-41 · Mar 18, 2004 5-89354-3130Window AssemblyPPG Industries Inc · Replaces 5-89354-3130 · Mar 18, 2004 5-89357-34Window AssemblyPPG Industries Inc · Replaces 5-89357-34 · Mar 18, 2004 5-89354-3140Window AssemblyPPG Industries Inc · Replaces 5-89354-3140 · Mar 18, 2004 65-16323-25Windshield AssemblyPPG Industries Inc · Replaces 65-16323-25 · Mar 18, 2004 5-89355-78WindshieldPPG Industries Inc · Replaces 5-89355-78 · Mar 18, 2004 5-89354-3139Window AssemblyPPG Industries Inc · Replaces 5-89354-3139 · Mar 18, 2004

Back to Boeing 737-287C