Skip to content

PMA parts · 10,464

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 ('4A26')
    AND len(list_intersect(tcds_models, ['707-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 ('4A26')
  AND len(list_intersect(tcds_models, ['707-400 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.

BACC14AD5ADLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD5ADL · Mar 21, 2004 BACS13BX Spec Rev T 8-5-99Sleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX · Mar 21, 2004 BACN10CS6HNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS6H · 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 BACC14AD6Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD6 · 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 BACC14AD12Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD12 · Mar 21, 2004 BACN10YA10Nut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA10 · Mar 21, 2004 BACN10CS4NNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS4N · Mar 21, 2004 BACP20AU6SPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU6S · Mar 21, 2004 BACN10CS6DHNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS6DH · Mar 21, 2004 BACN10CS4Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS4 · Mar 21, 2004 BACN10YA16NNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA16N · Mar 21, 2004 BACN10CS04DNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS04D · 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 BACN10CS8NNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS8N · Mar 21, 2004 BACS13BX8HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX8HP · Mar 21, 2004 BACN10CS5JNNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS5JN · 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 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 BACN10CS10Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS10 · Mar 21, 2004 BACC14AD8JCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD8J · Mar 21, 2004 BACN10CS08DNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS08D · Mar 21, 2004 BACR17E12-10Reducer, External thread, Flareless tubeAtlas Specialty Products · Replaces BACR17E12-10 · Mar 21, 2004 BACC14AD05Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD05 · Mar 21, 2004 BACU24AA0608DUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0608D · Mar 21, 2004 BACN10CSD3Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CSD3 · Mar 21, 2004 BACN10CSD6Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CSD6 · Mar 21, 2004 BACS13BX6Sleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX6 · 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 BACN10NR10Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10NR10 · 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 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 BACU24AA0804Union, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0804 · Mar 21, 2004 BACN10CS06DHNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS06DH · 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 BACU24AA1008Union, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA1008 · Mar 21, 2004

Back to Boeing 707-430