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.

65-45959NETBridport Air Carrier Inc · Replaces BOEING 65-45959 · Jul 17, 2001 BACN10CS8NUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS8 · Jul 17, 2001 BACP20AU8JPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AUJ · Jul 17, 2001 BACE21AW0606DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606D · Jul 17, 2001 BACT16AS121210DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121210D · Jul 17, 2001 65-12242NETBridport Air Carrier Inc · Replaces BOEING 65-12242 · Jul 17, 2001 BACT16AW121210JTEE, TUBE, FLARELESS- BULKHEAD ON SIDE,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AW121210J · Jul 17, 2001 BACT16AX121206JTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX121206J · Jul 17, 2001 BACT16AS120808KTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS120808K · Jul 17, 2001 BACN10CS4NNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS4N · Jul 17, 2001 BACE21AW0404DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0404D · Jul 17, 2001 BACS13BX12HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX12HP · Jul 17, 2001 65-05673NETBridport Air Carrier Inc · Replaces BOEING 65-05673 · Jul 17, 2001 BACT16AS060406KTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604K · Jul 17, 2001 BACN10YE6NNUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE6N · Jul 17, 2001 BACT16AX161612JTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX161612J · Jul 17, 2001 BACU24AB6WLUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB6WL · Jul 17, 2001 BACA14AZ12ADADAPTER, STRAIGHT, FLARELESS TUBE TO RECESSED SEAL BOSSAirdrome Parts Company LLC · Replaces BACA14AZ12AD · Jul 17, 2001 BACP20AU6KPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU6K · Jul 17, 2001 BACE21AW0404LELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0404L · Jul 17, 2001 BACA14AZ10A12DADAPTER, STRAIGHT, FLARELESS TUBE TO RECESSED SEAL BOSSAirdrome Parts Company LLC · Replaces BACA14AZ10A12D · Jul 17, 2001 BACN10CS5JNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS5JN · Jul 17, 2001 65-05600NETBridport Air Carrier Inc · Replaces BOEING 65-05600 · Jul 17, 2001 BACT16AX101210TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX101210 · Jul 17, 2001 BACP20AU4Plugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU4 · Jul 17, 2001 BACT16AS101008Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS101008 · Jul 17, 2001 BACU24AA0608DUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0608D · Jul 17, 2001 65-33172NETBridport Air Carrier Inc · Replaces BOEING 65-33172 · Jul 17, 2001 BACT16AX121208JTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX121208J · Jul 17, 2001 BACS13BX10HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX10H · Jul 17, 2001 BACT16AS060608Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060608 · Jul 17, 2001 65-07142NETBridport Air Carrier Inc · Replaces BOEING 65-07142 · Jul 17, 2001 BACT16AS080806DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080806D · Jul 17, 2001 65-05479NETBridport Air Carrier Inc · Replaces BOEING 65-05479 · Jul 17, 2001 65-05672NETBridport Air Carrier Inc · Replaces BOEING 65-05672 · Jul 17, 2001 BACT16AY060806DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060806D · Jul 17, 2001 BACE21AW0808MHELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW08008MH · Jul 17, 2001 BACT16BL060406PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL060406P · Jul 17, 2001 BACN10CS6NUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS6 · Jul 17, 2001 BACT16AX060604TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX060604 · Jul 17, 2001 BACU24AA0604Union, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0604 · Jul 17, 2001 BACN10CS4NUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS4 · Jul 17, 2001 BACS13BX04HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX04HP · Jul 17, 2001 BACE21AW0608DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0608D · Jul 17, 2001 BACN10CS10NUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS10 · Jul 17, 2001 BACU24AB20HUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB20H · Jul 17, 2001 BACT16AZ100610JTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ100610J · Jul 17, 2001 BACE21AU1010Elbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU1010 · Jul 17, 2001 65-05499NETBridport Air Carrier Inc · Replaces BOEING 65-05499 · Jul 17, 2001 BACU24AB8WLUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB8WL · Jul 17, 2001

Back to Boeing 707-430