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.

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 BACN10YE6NNut, coupling, Lightweight,FlarelessAtlas Specialty Products · Replaces BACN10YE6N · Mar 21, 2004 BACN10CS12CNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS12C · Mar 21, 2004 BACC14AD6SCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD6S · Mar 21, 2004 BACC14AD5DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD5D · Mar 21, 2004 BACC14AD8KCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD8K · Mar 21, 2004 BACS13BX10HSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX10H · Mar 21, 2004 BACC14AD10LCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD10L · 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 BACS13BX8Sleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX8 · 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 BACS13BX12HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX12HP · Mar 21, 2004 BACA14AZ12ADAdapter, Straight, Flareless Tube To Recessed Seal BossAtlas Specialty Products · Replaces BACA14AZ12AD · Mar 21, 2004 BACC14AD12DCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD12D · Mar 21, 2004 BACP20AU8JPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU8J · Mar 21, 2004 BACU24AA1012JUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA1012J · Mar 21, 2004 BACN10NR16Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10NR16 · Mar 21, 2004 BACC14AD5JMCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD5JM · Mar 21, 2004 BACS13BX08HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX08HP · 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 BACU24AA0604Union, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0604 · Mar 21, 2004 BACN10CS6Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS6 · Mar 21, 2004 BACN10CS10NNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS10N · Mar 21, 2004 BACN10YA12NNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA12N · Mar 21, 2004 BACN10CS4DNut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10CS4D · Mar 21, 2004 BACN10YA4NNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA4N · Mar 21, 2004 BACU24AB6WLUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB6WL · Mar 21, 2004 BACP20AU6KPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AU6K · Mar 21, 2004 BACC14AD10Cap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD10 · Mar 21, 2004 BACN10YA8NNut, coupling, lightweight, Flareless, titanium alloyAtlas Specialty Products · Replaces BACN10YA8N · Mar 21, 2004 BACN10NR6Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10NR6 · Mar 21, 2004 BACU24AB10WLUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB10WL · Mar 21, 2004 BACN10NR8Nut, Tube Coupling, Flareless, Lockwire and Solid Film Lubricant ProvisionsAtlas Specialty Products · Replaces BACN10NR8 · Mar 21, 2004 BACU24AB20HUnion, Tube, Flareless, Internally swagedAtlas Specialty Products · Replaces BACU24AB20H · Mar 21, 2004 BACU24AA0812DUnion, tube, Flareless-bulkhead, Reducer, Alum, Cres, Steel and TitaniumAtlas Specialty Products · Replaces BACU24AA0812D · Mar 21, 2004 BACC14AD04DLCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD04DL · 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 BACC14AD6KCap assembly, Pressure seal, flareless tube, Al, cres and steel, solid film lubricant provisionsAtlas Specialty Products · Replaces BACC14AD6K · Mar 21, 2004 BACS13BX4HPSleeve, Flareless Tube Fitting, Internally swaged, 15-5 PH Cres,2 Groove DesignAtlas Specialty Products · Replaces BACS13BX4HP · 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 BACP20AUBDPlugs, Flareless tubeAtlas Specialty Products · Replaces BACP20AUBD · Mar 21, 2004

Back to Boeing 707-430