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.

BACN10CS16JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS16JN · Mar 21, 2004 BACN10CS06JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS06JN · Mar 21, 2004 BACU24AB6WLUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB6WL · Mar 21, 2004 BACC14AD10Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD10 · Mar 21, 2004 BACU24AB4HLUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB4HL · Mar 21, 2004 BACU24AB10CUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB10C · Mar 21, 2004 BACN10YA8NNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA8N · Mar 21, 2004 BACN10NR8Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10NR8 · Mar 21, 2004 BACN10YL08NNut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL08N · Mar 21, 2004 BACC14AD06NCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD06N · Mar 21, 2004 BACN10CS6JNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS6J · Mar 21, 2004 BACC14AD06DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD06D · Mar 21, 2004 BACU24AB8WUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB8W · Mar 21, 2004 BACS13BX4HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX4HP · Mar 21, 2004 BACP20AU8Plugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU8 · Mar 21, 2004 BACP20AU6DPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU6D · Mar 21, 2004 BACC14AD08JCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD08J · Mar 21, 2004 BACU24AB10HUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB10H · Mar 21, 2004 BACC14AD06JLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD06JL · Mar 21, 2004 BACC14AD5ADLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD5ADL · Mar 21, 2004 BACU24AB10WUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB10W · Mar 21, 2004 BACN10CS12NNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS12N · Mar 21, 2004 BACU24AA0608Union, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0608 · Mar 21, 2004 BACU24AB8HUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB8H · Mar 21, 2004 BACC14AD05JCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD05J · Mar 21, 2004 BACC14AD6Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD6 · Mar 21, 2004 BACC14AD16JCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD16J · Mar 21, 2004 BACS13BX12HSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX12H · Mar 21, 2004 ME596369-3006Cover AssyMechanical Enterprises, Inc. · PMA PQ1359CE · Replaces Boeing P/N 5-96369-3006 · Mar 21, 2004 BACN10YA10Nut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA10 · Mar 21, 2004 BACN10CS6DHNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS6DH · Mar 21, 2004 BACC14AD10DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD10D · Mar 21, 2004 BACN10YA16NNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA16N · Mar 21, 2004 BACC14AD8DNCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD8DN · Mar 21, 2004 BACN10CS10DNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS10DN · Mar 21, 2004 BACN10CS08JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS08JN · Mar 21, 2004 BACN10CS12JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS12JN · Mar 21, 2004 BACN10YA10NNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA10N · Mar 21, 2004 BACC14AD06DLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD06DL · Mar 21, 2004 BACN10CS3NNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS3N · Mar 21, 2004 BACC14AD05DLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD05DL · Mar 21, 2004 BACC14AD12JLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD12JL · Mar 21, 2004 BACN10CS10JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS10JN · Mar 21, 2004 BACN10CS04JNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS04J · Mar 21, 2004 BACN10CS04Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS04 · Mar 21, 2004 BACN10YL10Nut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL10 · Mar 21, 2004 BACN10CS5JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS5JN · Mar 21, 2004 BACN10CS6SNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS6S · Mar 21, 2004 BACN10CS08DHNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS08DH · Mar 21, 2004 BACP20AU4Plugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU4 · Mar 21, 2004

Back to Boeing 737-287C