Skip to content

Boeing 737-287C

PMA parts · 38,312

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 ('A16WE')
    AND len(list_intersect(tcds_models, ['737-200C 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 ('A16WE')
  AND len(list_intersect(tcds_models, ['737-200C 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.

BACT16AZ080608DTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ080608D · Jul 17, 2001 BACC27AC10060606TCROSS, TUBE, FLARELESS-REDUCER, AL, CRES, STEEL, AND TITANIUMAirdrome Parts Company LLC · Replaces BACC27AC10060606T · Jul 17, 2001 BACN10NR8Nut, Coupling Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10NR8 · Jul 17, 2001 BACT16AY060606DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060606D · Jul 17, 2001 BACT16AS120505JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS120505J · Jul 17, 2001 BACN10CS08DNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS08D · Jul 17, 2001 BACT16AU060604DTEE, TUBE, FLARELESS, BOSS AND BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AU060604D · Jul 17, 2001 BACU24AA0608JUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0608J · Jul 17, 2001 BACU24AB6CUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB6C · Jul 17, 2001 BACT16BL060608PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL060608P · Jul 17, 2001 BACT16AY121205LTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY121205L · Jul 17, 2001 BACN10YE10NNUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE10N · Jul 17, 2001 BACT16BL101008PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL101008P · Jul 17, 2001 BACT16AS100610Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100610 · Jul 17, 2001 BACS13BX4HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX4HP · Jul 17, 2001 BACE21AW0505RELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0505R · Jul 17, 2001 BACU24AA0405Union, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0405 · Jul 17, 2001 BACU24AB6HLUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB6HL · Jul 17, 2001 BACT16AX060406TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX060406 · Jul 17, 2001 BACN10YA8NNut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA8N · Jul 17, 2001 BACT16AW100808DTEE, TUBE, FLARELESS- BULKHEAD ON SIDE,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AW100808D · Jul 17, 2001 BACU24AB16WUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB16W · Jul 17, 2001 BACT16AZ060404Tee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ060404 · Jul 17, 2001 BACT16BL060606PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL060606P · Jul 17, 2001 65-25756NETBridport Air Carrier Inc · Replaces BOEING 65-25756 · Jul 17, 2001 BACT16AW100808WTEE, TUBE, FLARELESS- BULKHEAD ON SIDE,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AW100808W · Jul 17, 2001 BACP20AU8DPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU8D · Jul 17, 2001 BACN10CS12JNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS12JN · Jul 17, 2001 BACE21AW1010ELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW1010 · Jul 17, 2001 BACE21BN0406PElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21BN0406P · Jul 17, 2001 BACT16BM060604PTee, Flareless Tube, Bulkhead on side, LightweightAirdrome Parts Company LLC · Replaces BACT16BM060604P · Jul 17, 2001 BACT16AS060406Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604 · Jul 17, 2001 65-49630NETBridport Air Carrier Inc · Replaces BOEING 65-49630 · Jul 17, 2001 BACT16BT040404PTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT040404P · Jul 17, 2001 BACE21AW0404JMELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0404JM · Jul 17, 2001 BACT16AS060608JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060608J · Jul 17, 2001 BACE21AW0808ELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW08008 · Jul 17, 2001 BACT16AS080606JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080606J · Jul 17, 2001 BACT16AX040505JTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX040505J · Jul 17, 2001 BACT16AX120612TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX120612 · Jul 17, 2001 65-78967NET INSTLBridport Air Carrier Inc · Replaces BOEING 65-78967 · Jul 17, 2001 BACT16BR080808PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR080808P · Jul 17, 2001 BACT16AS100810Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100810 · Jul 17, 2001 BACU24AA0605DUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0605D · Jul 17, 2001 BACE21AW0606ELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606 · Jul 17, 2001 65-54404NETBridport Air Carrier Inc · Replaces BOEING 65-54404 · Jul 17, 2001 BACT16AX101212DTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX101212D · Jul 17, 2001 BACS13BX08HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX08H · Jul 17, 2001 BACT16AS050405JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS050405J · Jul 17, 2001 BACT16AS121206WTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121206W · Jul 17, 2001

Back to Boeing 737-287C