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.

BACT16AS101010Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS101010 · Jul 17, 2001 BACT16AS121208KTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121208K · Jul 17, 2001 65-05602NETBridport Air Carrier Inc · Replaces BOEING 65-05602 · Jul 17, 2001 BACN10YA16NNut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA16N · Jul 17, 2001 BACT16AS060604Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604 · Jul 17, 2001 BACT16AY120812JTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY120812J · Jul 17, 2001 BACT16AS161612DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS161612D · Jul 17, 2001 65-12244NETBridport Air Carrier Inc · Replaces BOEING 65-12244 · Jul 17, 2001 BACP20AU10JPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU10J · Jul 17, 2001 BACT16AS040406Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS040406 · Jul 17, 2001 65-05426NETBridport Air Carrier Inc · Replaces BOEING 65-05426 · Jul 17, 2001 BACT16BL121208JTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL121208J · Jul 17, 2001 BACT16AS080608DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080608D · Jul 17, 2001 BACN10CS06DHNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS06DH · Jul 17, 2001 BACU24AA0804Union, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0804 · Jul 17, 2001 BACT16AY121212DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY121212D · Jul 17, 2001 BACS13BX12HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX12H · Jul 17, 2001 BACU24AB10WLUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB10WL · Jul 17, 2001 BACE21AW1212DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW1212D · Jul 17, 2001 BACE21AW0606LHELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606LH · Jul 17, 2001 BACT16AY050505MTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY050505M · Jul 17, 2001 BACE21AW0505MELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0505M · Jul 17, 2001 65-36054NETBridport Air Carrier Inc · Replaces BOEING 65-36054 · Jul 17, 2001 BA1CN10NR16Nut, Coupling Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10NR16 · Jul 17, 2001 65-72056NETBridport Air Carrier Inc · Replaces BOEING 65-72056 · Jul 17, 2001 BACT16BR060404JNTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR060404JN · Jul 17, 2001 BACT16AW060406TEE, TUBE, FLARELESS- BULKHEAD ON SIDE,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AW060406 · Jul 17, 2001 BACE21AW0808JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW08008J · Jul 17, 2001 BACT16AS060505Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060505 · Jul 17, 2001 BACT16AU101004DTEE, TUBE, FLARELESS, BOSS AND BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AU101004D · Jul 17, 2001 BACN10YA12Nut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA12 · Jul 17, 2001 BACN10YA8Nut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA8 · Jul 17, 2001 65-45958NETBridport Air Carrier Inc · Replaces BOEING 65-45958 · Jul 17, 2001 BACT16AS080608Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080608 · Jul 17, 2001 BACP20AUBDPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AUBD · Jul 17, 2001 BACT16AX121206TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX121206 · Jul 17, 2001 BACE21AW0606JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606J · Jul 17, 2001 BACT16AS100808Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100808 · Jul 17, 2001 BACE21AU0606Elbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU0606 · Jul 17, 2001 BACT16AS060808Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS0600808 · Jul 17, 2001 65-05642NETBridport Air Carrier Inc · Replaces BOEING 65-05642 · Jul 17, 2001 BACN10YA6NNut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA6N · Jul 17, 2001 65-05601NETBridport Air Carrier Inc · Replaces BOEING 65-05601 · Jul 17, 2001 BACE21AW0808DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW08008D · Jul 17, 2001 BACE21BN0806JElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21BN0806J · Jul 17, 2001 BACE21AU0808DElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU0808D · Jul 17, 2001 BACN10CS6HNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS6H · Jul 17, 2001 BACS13BX06HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX06HP · Jul 17, 2001 BACN10NR12Nut, Coupling Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10NR12 · Jul 17, 2001 BACT16AX121210DTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX121210D · Jul 17, 2001

Back to Boeing 707-430