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.

BACE21AW0808JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW08008J · Jul 17, 2001 BACT16AZ040404Tee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ040404 · Jul 17, 2001 BACT16AS060404Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604 · Jul 17, 2001 BACN10YA12Nut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA12 · Jul 17, 2001 BACU24AB16HUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB16H · Jul 17, 2001 BACT16BN080808JTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN080808J · Jul 17, 2001 BACN10YA8Nut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA8 · Jul 17, 2001 BACU24AB16AHUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB16AH · Jul 17, 2001 BACT16BT080608PTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT080608P · Jul 17, 2001 BACT16AY050505LTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY050505L · Jul 17, 2001 BACU24AB12HUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB12H · Jul 17, 2001 BACT16AS080608Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080608 · Jul 17, 2001 BACT16BL060404PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL060404P · Jul 17, 2001 BACE21BN0808PElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21BN0808P · Jul 17, 2001 BACU24AB12WUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB12W · Jul 17, 2001 BACT16AS060608WTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060608W · Jul 17, 2001 BACT16BT120812JTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT120812J · Jul 17, 2001 BACE21AW0606JELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606J · Jul 17, 2001 BACT16AY080806DTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY080806D · Jul 17, 2001 BACT16AS100808Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100808 · Jul 17, 2001 BACT16AS121205JTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121205J · Jul 17, 2001 65-49628NETBridport Air Carrier Inc · Replaces BOEING 65-49628 · Jul 17, 2001 BACN10CS10DNNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS10DN · Jul 17, 2001 BACT16AZ050505DTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ050505D · Jul 17, 2001 BACN10CS5NNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS5N · Jul 17, 2001 BACN10YA6NNut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA6N · Jul 17, 2001 BACE21AW0808DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW08008D · Jul 17, 2001 BACP20AU10DPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU10D · Jul 17, 2001 BACT16AW100808TEE, TUBE, FLARELESS- BULKHEAD ON SIDE,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AW100808 · Jul 17, 2001 BACN10YL10LNUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL10L · Jul 17, 2001 BACS13BX06HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX06HP · Jul 17, 2001 BACT16AY040404WTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY040404W · Jul 17, 2001 BACE21AU0505MElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21AU0505M · Jul 17, 2001 BACN10YL04NUT, COUPLING, LIGHTWEIGHT, FLARELESS, ALUMINUM ALLOYAirdrome Parts Company LLC · Replaces BACN10YL04 · Jul 17, 2001 BACU24AB10CUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB10C · Jul 17, 2001 BACN10CS6SNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS6S · Jul 17, 2001 BACT16AS080606Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080606 · Jul 17, 2001 BACT16AS060604DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604D · Jul 17, 2001 BACS13BX16HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX16HP · Jul 17, 2001 BACT16AS101004DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS101004D · Jul 17, 2001 BACT16AS080806STee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080806S · Jul 17, 2001 BACR17E8-6REDUCER, EXTERNAL THREAD, FLARELESS TUBEAirdrome Parts Company LLC · Replaces BACR17E8-6 · Jul 17, 2001 BACN10YE8NNUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE8N · Jul 17, 2001 BACT16AT060612TEE, TUBE, FLARELESS, BOSS ON SIDE, BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AT060612 · Jul 17, 2001 BACT16BT080808JTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT080808J · Jul 17, 2001 BACT16AS100610WTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS100610W · Jul 17, 2001 BACP20AU6JPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU6J · Jul 17, 2001 BACU24AB8HUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB8H · Jul 17, 2001 BACT16AZ050505MTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ050505M · Jul 17, 2001 BACN10YA16LNut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA16L · Jul 17, 2001

Back to Boeing 737-287C