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.

BACE21AU1212LElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU1212L · Jul 17, 2001 BACT16AX060406DTEE, TUBE, FLARELESS- BULKHEAD ON RUN,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AX060406D · Jul 17, 2001 BACT16AS040405JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS040405J · Jul 17, 2001 BACT16AY080606JTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY080606J · Jul 17, 2001 BACE21AW0404JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0404J · Jul 17, 2001 BACN10CS06DNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS06DN · Jul 17, 2001 BACE21AU1010DElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU1010D · Jul 17, 2001 BACS13BX08HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX08HP · Jul 17, 2001 BACT16AZ050404DTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ050404D · Jul 17, 2001 BACT16BN080808PTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN080808P · Jul 17, 2001 BACN10YL06NUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL06 · Jul 17, 2001 BACT16AY121205DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY121205D · Jul 17, 2001 BACT16AS080806Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080806 · Jul 17, 2001 BACT16BR060406PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR060406P · Jul 17, 2001 BACT16BN120812JTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN120812J · Jul 17, 2001 65-78968NET INSTLBridport Air Carrier Inc · Replaces BOEING 65-78968 · Jul 17, 2001 BACT16AT060612DTEE, TUBE, FLARELESS, BOSS ON SIDE, BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AT060612D · Jul 17, 2001 BACT16BL040404PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL040404P · Jul 17, 2001 BACT16AS100606DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100606D · Jul 17, 2001 65-49626NETBridport Air Carrier Inc · Replaces BOEING 65-49626 · Jul 17, 2001 BACS13BX6HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX6H · Jul 17, 2001 BACT16AY050505STee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY050505S · Jul 17, 2001 BACN10CS5DNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS5DN · Jul 17, 2001 BACT16BL080608PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL080608P · Jul 17, 2001 BACT16AZ120612DTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ120612D · Jul 17, 2001 BACT16AS161216JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS161216J · Jul 17, 2001 BACT16BR080806PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR080806P · Jul 17, 2001 BACN10CS6JNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS6J · Jul 17, 2001 BACT16AU040604DTEE, TUBE, FLARELESS, BOSS AND BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AU040604D · Jul 17, 2001 65-53882STANCHIONBridport Air Carrier Inc · Replaces BOEING 65-53882 · Jul 17, 2001 BACT16BN060606PTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN060606P · Jul 17, 2001 BACN10CS4JNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS4JN · Jul 17, 2001 BACT16BT060606PTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT060606P · Jul 17, 2001 BACE21AW1010WELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW1010W · Jul 17, 2001 BACT16AS121206Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121206 · Jul 17, 2001 BACT16AY040604Tee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY040604 · Jul 17, 2001 BACU24AB10HUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB10H · Jul 17, 2001 BACT16AZ121212JTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ121212J · Jul 17, 2001 BACT16AS121205DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121205D · Jul 17, 2001 BACP20AU4JPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU4J · Jul 17, 2001 BACE21AU0606DElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU0606D · Jul 17, 2001 BACS13BX10HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX10HP · Jul 17, 2001 BACT16BL100810PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL100810P · Jul 17, 2001 BACN10CS8KHNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS8KH · Jul 17, 2001 BACT16BR060606PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR060606P · Jul 17, 2001 BACT16BL060604PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL060604P · Jul 17, 2001 BACT16BT060606JNTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT060606JN · Jul 17, 2001 BACT16AS100606Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100606 · Jul 17, 2001 BACT16AS120812JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS120812J · Jul 17, 2001 BACT16AS101006DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS101006D · Jul 17, 2001

Back to Boeing 737-287C