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.

BACT16AY060808DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060808D · Jul 17, 2001 BACT16AX081008TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX081008 · Jul 17, 2001 BACE21AU0806DElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU0806D · Jul 17, 2001 BACU24AB8CUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB8C · Jul 17, 2001 BACN10YL06NNUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL06N · Jul 17, 2001 BACP20AU12JPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU12J · Jul 17, 2001 BACT16AS101006Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS101006 · Jul 17, 2001 BACT16AS101004Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS101004 · Jul 17, 2001 BACT16AX060604DTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX060604D · Jul 17, 2001 BACT16AS121012WTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121012W · Jul 17, 2001 BACS13BX05HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX05HP · Jul 17, 2001 BACT16AY061006DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY061006D · Jul 17, 2001 BACT16BN080806PTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN080806P · Jul 17, 2001 BACE21BL0606PELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21BL0606P · Jul 17, 2001 BACU24AA0406DUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0406D · Jul 17, 2001 BACE21AW1205DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW1205D · Jul 17, 2001 BACT16AZ060606DTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ060606D · Jul 17, 2001 BACU24AB4HUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB4H · Jul 17, 2001 BACT16AX040606TEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX040606 · Jul 17, 2001 BACS13BX16HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX16H · Jul 17, 2001 BACT16AX080606DTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX080606D · Jul 17, 2001 BACT16AS121206DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121206D · Jul 17, 2001 BACT16AT060804TEE, TUBE, FLARELESS, BOSS ON SIDE, BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AT060804 · Jul 17, 2001 BACT16BR060604PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR060604P · Jul 17, 2001 BACT16AS080806JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080806J · Jul 17, 2001 BACT16AZ080608Tee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ080608 · Jul 17, 2001 BACN10YE12NNUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE12N · Jul 17, 2001 BACP20AU6DPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU6D · Jul 17, 2001 BACN10NR4Nut, Coupling Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10NR4 · Jul 17, 2001 BACE21BN0606TElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21BN0606T · Jul 17, 2001 BACT16AS100810DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100810D · Jul 17, 2001 BACT16BR040404PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR040404P · Jul 17, 2001 BACT16AW040406TEE, TUBE, FLARELESS- BULKHEAD ON SIDE,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AW040406 · Jul 17, 2001 BACT16AS080606DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080606D · Jul 17, 2001 65-45953STANCHIONSBridport Air Carrier Inc · Replaces BOEING 65-45953 · Jul 17, 2001 BACN10YE6NUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE6 · Jul 17, 2001 BACN10YA6Nut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA6 · Jul 17, 2001 BACT16AZ050505LTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ050505L · Jul 17, 2001 BACT16BR80808JNTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR80808JN · Jul 17, 2001 BACN10CS10JNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS10JN · Jul 17, 2001 BACT16AS120512DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS120512D · Jul 17, 2001 BACT16AS121012Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121012 · Jul 17, 2001 BACN10CS16JNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS16JN · Jul 17, 2001 BACS13BX05HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX05H · Jul 17, 2001 BACS13BX06HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX06H · Jul 17, 2001 BACS13BX6HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX6HP · Jul 17, 2001 BACT16AZ060604Tee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ060604 · Jul 17, 2001 BACT16BT101010TTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT101010T · Jul 17, 2001 BACN10YL08NNUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL08N · Jul 17, 2001 BACN10YL16LNUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL16L · Jul 17, 2001

Back to Boeing 737-287C