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.

BACT16BN060406PTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN060406P · 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 BACT16BT060406PTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT060406P · Jul 17, 2001 BACT16AY080804Tee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY080804 · Jul 17, 2001 BACN10CS3NNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS3N · Jul 17, 2001 BACT16AS120812WTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS120812W · Jul 17, 2001 BACN10CS08JNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS08JN · Jul 17, 2001 BACT16AY060612DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060612D · Jul 17, 2001 BACN10CS16DNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS16DN · Jul 17, 2001 BACT16AX101212WTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX101212W · Jul 17, 2001 BACU24AA0608Union, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0608 · Jul 17, 2001 BACT16AX120812JTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX120812J · Jul 17, 2001 BACT16AY080808DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY080808D · Jul 17, 2001 BACN10YL12NNUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL12N · Jul 17, 2001 BACT16AX101212TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX101212 · Jul 17, 2001 BACT16AZ121212DTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ121212D · Jul 17, 2001 BACU24AB8WUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB8W · Jul 17, 2001 BACN10YA10Nut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA10 · Jul 17, 2001 BACT16BM040404PTee, Flareless Tube, Bulkhead on side, LightweightAirdrome Parts Company LLC · Replaces BACT16BM040404P · Jul 17, 2001 65-19329NETBridport Air Carrier Inc · Replaces BOEING 65-19329 · Jul 17, 2001 BACT16BN060806JTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN060806J · Jul 17, 2001 65-49625NETBridport Air Carrier Inc · Replaces BOEING 65-49625 · Jul 17, 2001 BACU24AB6WUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB6W · Jul 17, 2001 BACE21AW1212JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW1212J · Jul 17, 2001 BACU24AA0604JUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0604J · Jul 17, 2001 BACT16AX040406TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX040406 · Jul 17, 2001 BACN10YL08NUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL08 · Jul 17, 2001 BACT16BR080808JTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR080808J · Jul 17, 2001 BACT16AS100610DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100610D · Jul 17, 2001 BACT16AU080806DTEE, TUBE, FLARELESS, BOSS AND BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AU080806D · Jul 17, 2001 BACN10CS06JNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS06JN · Jul 17, 2001 BACS13BX04HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX04H · Jul 17, 2001 65-63646NETBridport Air Carrier Inc · Replaces BOEING 65-63646 · 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 BACU24AB4HLUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB4HL · Jul 17, 2001 BACN10CS8DNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS8D · Jul 17, 2001 BACT16AY060808Tee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060808 · Jul 17, 2001 BACT16AX081010TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX081010 · Jul 17, 2001 BACT16BR060604JNTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR060604JN · Jul 17, 2001 BACE21AR0604DELBOW, TUBE, FLARELESS, 90 DEG, REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AR0604D · 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 BACN10CS16JHNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS16JH · Jul 17, 2001 BACT16AY121205MTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY121205M · Jul 17, 2001 65-25757NETBridport Air Carrier Inc · Replaces BOEING 65-25757 · Jul 17, 2001 BACU24AA1012JUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA1012J · Jul 17, 2001 BACP20AU6Plugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU6 · Jul 17, 2001 BACT16BN080810TTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN080810T · Jul 17, 2001

Back to Boeing 737-287C