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.

BACU24AA0604JUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0604J · Mar 21, 2004 BACP20AU10JPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU10J · Mar 21, 2004 BACN10CS06DNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS06DN · Mar 21, 2004 BACP20AU12JPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU12J · Mar 21, 2004 BACU24AA1612JUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA1612J · Mar 21, 2004 BACU24AB4HUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB4H · Mar 21, 2004 BACN10CS8DNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS8D · Mar 21, 2004 BACC14AD04, SPEC REV P 8-26-99Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD04 · Mar 21, 2004 BACC14AD04JLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD04JL · Mar 21, 2004 BACU24AB12WUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB12W · Mar 21, 2004 BACR17E8-6Reducer, External thread, Flareless tubeAtlas Specialty Products · Replaces BACR17E8-6 · Mar 21, 2004 BACC14AD12JCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD12J · Mar 21, 2004 BACS13BX6HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX6HP · Mar 21, 2004 BACP20AU8DPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU8D · Mar 21, 2004 BACS13BX8HSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX8H · Mar 21, 2004 BACC14AD04NCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD04N · Mar 21, 2004 BACN10YL06Nut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL06 · Mar 21, 2004 BACN10CS05JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS05JN · Mar 21, 2004 BACN10YE6NNut, coupling, Lightweight,FlarelessAtlas Specialty Products · Replaces BACN10YE6N · Mar 21, 2004 BACU24AA0604DUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0604D · Mar 21, 2004 BACC14AD5DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD5D · Mar 21, 2004 BACN10YE12NNut, coupling, Lightweight,FlarelessAtlas Specialty Products · Replaces BACN10YE12N · Mar 21, 2004 BACC14AD08JLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD08JL · Mar 21, 2004 BACS13BX6HSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX6H · Mar 21, 2004 BACN10YE8Nut, coupling, Lightweight,FlarelessAtlas Specialty Products · Replaces BACN10YE8 · Mar 21, 2004 BACS13BX10HSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX10H · Mar 21, 2004 BACN10YE6LNut, coupling, Lightweight,FlarelessAtlas Specialty Products · Replaces BACN10YE6L · Mar 21, 2004 BACC14AD04DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD04D · Mar 21, 2004 BACC14AD06Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD06 · Mar 21, 2004 BACC14AD5ADMCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD5ADM · Mar 21, 2004 BACN10CS8KHNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS8KH · Mar 21, 2004 BACN10CS8Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS8 · Mar 21, 2004 BACN10YA6Nut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA6 · Mar 21, 2004 BACN10YA16LNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA16L · Mar 21, 2004 BACP20AU6Plugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU6 · Mar 21, 2004 BACS13BX12HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX12HP · Mar 21, 2004 BACP20AU8JPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU8J · Mar 21, 2004 BACS13BX05HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX05HP · Mar 21, 2004 BACU24AA1012JUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA1012J · Mar 21, 2004 BACS13BX08HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX08HP · Mar 21, 2004 BACN10CS04JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS04JN · Mar 21, 2004 BACP20AU10DPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU10D · Mar 21, 2004 BACU24AA1210DUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA1210D · Mar 21, 2004 BACU24AA0406DUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0406D · Mar 21, 2004 BACC14AD4Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD4 · Mar 21, 2004 BACN10YL08Nut, coupling, Lightweight, Flareless, Aluminum AlloyAtlas Specialty Products · Replaces BACN10YL08 · Mar 21, 2004 BACU24AA0604Union, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0604 · Mar 21, 2004 BACN10YA12NNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA12N · Mar 21, 2004 BACU24AA0504DUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0504D · Mar 21, 2004 BACC14AD10SCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD10S · Mar 21, 2004

Back to Boeing 737-287C