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.

BACE21AW0404ELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0404 · 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 BACT16BL080808JTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL080808J · Jul 17, 2001 BACE21AW0606DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606D · Jul 17, 2001 453A1810NETBridport Air Carrier Inc · Replaces BOEING 453A1810 · Jul 17, 2001 BACT16BL080808PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL080808P · Jul 17, 2001 BACT16AZ121212MTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ121212M · Jul 17, 2001 BACN10YL08LNUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL08L · Jul 17, 2001 BACU24AB08WUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB08W · Jul 17, 2001 BACU24AB10WUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB10W · Jul 17, 2001 BACE21AW0404DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0404D · Jul 17, 2001 BACE21BN0604PElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21BN0604P · Jul 17, 2001 BACS13BX12HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX12HP · Jul 17, 2001 BACT16AZ050505JTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ050505J · Jul 17, 2001 BACN10YE6NNUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE6N · Jul 17, 2001 65-78966NETBridport Air Carrier Inc · Replaces BOEING 65-78966 · Jul 17, 2001 BACE21AR1205DELBOW, TUBE, FLARELESS, 90 DEG, REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AR1205D · Jul 17, 2001 BACE21BN0504JElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21BN0504J · Jul 17, 2001 BACU24AB6WLUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB6WL · Jul 17, 2001 BACT16AX120612DTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX120612D · Jul 17, 2001 65C34576NETBridport Air Carrier Inc · Replaces BOEING 65C34576 · Jul 17, 2001 BACT16AX081212JTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX081212J · Jul 17, 2001 BACT16BL080804PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL080804P · Jul 17, 2001 BACE21AW0505JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0505J · Jul 17, 2001 BACT16BT060604JNTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT060604JN · Jul 17, 2001 BACT16AY060306DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060306D · Jul 17, 2001 BACT16AS120505DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS120505D · Jul 17, 2001 BACN10CS5JNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS5JN · Jul 17, 2001 BACE21AU0808JElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU0808J · Jul 17, 2001 BACE21BL0808JELBOW, FLARELESS TUBE 90 DEG, REDUCER, LIGHTWEIGHTAirdrome Parts Company LLC · Replaces BACE21BL0808J · Jul 17, 2001 BACN10CS04JNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS04J · Jul 17, 2001 BACT16AY080808LTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY080808L · Jul 17, 2001 BACE21BN0606PElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21BN0606P · Jul 17, 2001 65-52956NETBridport Air Carrier Inc · Replaces BOEING 65-52956 · Jul 17, 2001 BACP20AU4Plugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU4 · Jul 17, 2001 BACU24AA0608DUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0608D · Jul 17, 2001 BACT16AS080806WTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080806W · Jul 17, 2001 BACU24AA0604DUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0604D · Jul 17, 2001 BACS13BX10HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX10H · Jul 17, 2001 BACT16AS120512JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS120512J · Jul 17, 2001 BACT16AS060608Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060608 · Jul 17, 2001 BACT16AY060604DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060604D · Jul 17, 2001 BACT16AS080806DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080806D · Jul 17, 2001 BACU24AA0405DUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0405D · Jul 17, 2001 BACN10YE6LNUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE6L · Jul 17, 2001 BACE21AW1212MELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW1212M · Jul 17, 2001 BACT16AS060406DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604D · Jul 17, 2001 BACN10CS04NUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS04 · Jul 17, 2001 BACT16BR101004PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR101004P · Jul 17, 2001

Back to Boeing 737-287C