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.

BACU24AA0806SUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0806S · Jul 17, 2001 BACT16AS080606Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080606 · Jul 17, 2001 BACT16AS060604DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604D · Jul 17, 2001 BACS13BX16HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX16HP · Jul 17, 2001 BACT16AS101004DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS101004D · Jul 17, 2001 65-05429NETBridport Air Carrier Inc · Replaces BOEING 65-05429 · Jul 17, 2001 BACT16AS080810Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080810 · Jul 17, 2001 BACP20AU6JPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU6J · Jul 17, 2001 BACU24AB8HUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB8H · Jul 17, 2001 BACN10YA12NNut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA12N · Jul 17, 2001 BACN10CS08DHNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS08DH · Jul 17, 2001 65-28567NETBridport Air Carrier Inc · Replaces BOEING 65-28567 · Jul 17, 2001 BACT16AY080804Tee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY080804 · Jul 17, 2001 BACT16AS161612TTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS161612T · Jul 17, 2001 65-08735NETBridport Air Carrier Inc · Replaces BOEING 65-08735 · Jul 17, 2001 65-05316NETBridport Air Carrier Inc · Replaces BOEING 65-05316 · Jul 17, 2001 BACT16AU060608DTEE, TUBE, FLARELESS, BOSS AND BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AU060608D · Jul 17, 2001 BACT16BM101010JTee, Flareless Tube, Bulkhead on side, LightweightAirdrome Parts Company LLC · Replaces BACT16BM101010J · Jul 17, 2001 65-07143NETBridport Air Carrier Inc · Replaces BOEING 65-07143 · Jul 17, 2001 65-05405NETBridport Air Carrier Inc · Replaces BOEING 65-05405 · Jul 17, 2001 65-05317NETBridport Air Carrier Inc · Replaces BOEING 65-05317 · Jul 17, 2001 BACU24AA0608Union, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0608 · Jul 17, 2001 BACT16AY080808DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY080808D · Jul 17, 2001 BACT16AZ121212DTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ121212D · Jul 17, 2001 65-05480NETBridport Air Carrier Inc · Replaces BOEING 65-05480 · Jul 17, 2001 BACT16AT120808JTEE, TUBE, FLARELESS, BOSS ON SIDE, BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AT120808J · Jul 17, 2001 BACN10YA10Nut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA10 · Jul 17, 2001 65-07299NETBridport Air Carrier Inc · Replaces BOEING 65-07299 · Jul 17, 2001 BACT16AX101208DTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX101208D · Jul 17, 2001 BACE21AW1212JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW1212J · Jul 17, 2001 BACN10CSD6NUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CSD6 · Jul 17, 2001 BACT16AX101004TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX101004 · Jul 17, 2001 BACE21AW0506KELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0506K · Jul 17, 2001 BACS13BX04HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX04H · Jul 17, 2001 BACU24AA1612JUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA1612J · Jul 17, 2001 BACE21AW0505LELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0505L · Jul 17, 2001 BACP20AU4DPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU4D · Jul 17, 2001 65-12245NETBridport Air Carrier Inc · Replaces BOEING 65-12245 · Jul 17, 2001 BACE21AW0606SELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606S · Jul 17, 2001 65-29375NETBridport Air Carrier Inc · Replaces BOEING 65-29375 · Jul 17, 2001 BACT16AZ040404JTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ040404J · Jul 17, 2001 BACU24AB6HUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB6H · Jul 17, 2001 BACT16AY060606Tee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060606 · Jul 17, 2001 BACS13BXSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX · Jul 17, 2001 BACT16AY121206DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY121206D · Jul 17, 2001 BACS13BX6SLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX6 · Jul 17, 2001 BACT16AS120812KTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS120812K · Jul 17, 2001 BACU24AA1012JUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA1012J · Jul 17, 2001 BACN10CS4DNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS4D · Jul 17, 2001 BACE21AW0404JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0404J · Jul 17, 2001

Back to Boeing 707-430