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.

BACT16AZ060606JTee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ060606J · Jul 17, 2001 BACT16BT040406PTee, Lightweight, Flareless Tube To Swivel, Swivel On SideAirdrome Parts Company LLC · Replaces BACT16BT040406P · Jul 17, 2001 BACT16BL060406PTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL060406P · Jul 17, 2001 BACU24AA0604Union, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0604 · Jul 17, 2001 BACN10CS06DNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS06D · Jul 17, 2001 BACS13BX04HPSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX04HP · Jul 17, 2001 BACE21AW0608DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0608D · Jul 17, 2001 BACT16AY040606Tee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY040606 · Jul 17, 2001 BACT16AY060406Tee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY060406 · Jul 17, 2001 BACU24AB8WLUnion, Tube, Flareless, Internally SwagedAirdrome Parts Company LLC · Replaces BACU24AB8WL · Jul 17, 2001 BACT16AS060406WTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604W · Jul 17, 2001 BACN10YA16NNut, Coupling, Lightweight, Flareless, Titanium AlloyAirdrome Parts Company LLC · Replaces BACN10YA16N · Jul 17, 2001 BACT16AS060604Tee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060604 · Jul 17, 2001 BACT16AS121012DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121012D · Jul 17, 2001 BACT16AY041010WTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY041010W · Jul 17, 2001 BACP20AU10JPlugs, Flareless TubeAirdrome Parts Company LLC · Replaces BACP20AU10J · Jul 17, 2001 65-49627NETBridport Air Carrier Inc · Replaces BOEING 65-49627 · Jul 17, 2001 BACN10YE16LNUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE16L · Jul 17, 2001 BACT16AS060608DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS060608D · Jul 17, 2001 BACT16BL121208JTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL121208J · Jul 17, 2001 BACT16AS080608DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS080608D · Jul 17, 2001 BACU24AA0410Union, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0410 · Jul 17, 2001 BACN10CS06DHNUT, TUBE COUPLING, FLARELESS, LOCKWIRE, AND SOLID FILM LUBRICANT PROVISIONSAirdrome Parts Company LLC · Replaces BACN10CS06DH · Jul 17, 2001 BACT16BM080810TTee, Flareless Tube, Bulkhead on side, LightweightAirdrome Parts Company LLC · Replaces BACT16BM080810T · Jul 17, 2001 65C33868NETBridport Air Carrier Inc · Replaces BOEING 65C33868 · Jul 17, 2001 BACE21BN0404PElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACE21BN0404P · Jul 17, 2001 BACT16BL060606JTee, Flareless Tube, Male LightweightAirdrome Parts Company LLC · Replaces BACT16BL060606J · Jul 17, 2001 BACS13BX12HSLEEVE, FLARELESS TUBE FITTING, INTERNALLY SWAGED, 15-5 PH CRES, 2 GROOVE DESIGNAirdrome Parts Company LLC · Replaces BACS13BX12H · Jul 17, 2001 BACT16AT1010-08JTEE, TUBE, FLARELESS, BOSS ON SIDE, BULKHEAD ON RUN, REDUCER, ALUM, CRES AND STEELAirdrome Parts Company LLC · Replaces BACT16AT1010-08J · Jul 17, 2001 BACT16AZ080806Tee, Tube, Flareless, Swivel On Side, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AZ080806 · Jul 17, 2001 65-52970STANCHIONBridport Air Carrier Inc · Replaces BOEING 65-52970 · Jul 17, 2001 BACE21AW1212DELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW1212D · Jul 17, 2001 BACE21AW0606LHELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606LH · Jul 17, 2001 BACU24AA0806JUnion, Tube, Flareless-Bulkhead, Reducer, Alum, Cres, Steel And TitaniumAirdrome Parts Company LLC · Replaces BACU24AA0806J · Jul 17, 2001 BACE21BP0808CELBOW, LIGHTWEIGHT, REDUCER, 90 DEG, TUBE WELD, 3000 PSI, HYDRAULIC, WELDED TUBE TO FLARELESS SWIVELAirdrome Parts Company LLC · Replaces BACE21BP0808C · Jul 17, 2001 BACT16AY050505MTee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY050505M · Jul 17, 2001 BACE21AW0505MELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0505M · Jul 17, 2001 BACN10YE8NUT, COUPLING, LIGHTWEIGHT, FLARELESSAirdrome Parts Company LLC · Replaces BACN10YE8 · Jul 17, 2001 BACT16AW060604TEE, TUBE, FLARELESS- BULKHEAD ON SIDE,REDUCER, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACT16AW060604 · Jul 17, 2001 BACE21AW0606LELBOW, TUBE, FLARELESS 90 DEG, SWIVEL, REDUCER AND NOM SIZE, STANDARD WEIGHTAirdrome Parts Company LLC · Replaces BACE21AW0606L · Jul 17, 2001 BACT16BN040606PTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN040606P · Jul 17, 2001 BACT16BR101008PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR101008P · Jul 17, 2001 BACT16AY080808ETee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY080808E · Jul 17, 2001 BACT16BN100808JTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN100808J · Jul 17, 2001 BACE21BL0404PELBOW, FLARELESS TUBE 90 DEG, REDUCER, LIGHTWEIGHTAirdrome Parts Company LLC · Replaces BACE21BL0404P · Jul 17, 2001 BACT16BR100808PTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR100808P · Jul 17, 2001 BACT16BR080808JNTEE, LIGHTWEIGHT, FLARELESS TUBE TO SWIVEL, SWIVEL ON THE RUNAirdrome Parts Company LLC · Replaces BACT16BR080808JN · Jul 17, 2001 BACT16AS121010DTee, Tube, Flareless, Reducer, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AS121010D · Jul 17, 2001 BACT16AY040404Tee, Tube, Flareless, Swivel On Run, Reducer And Nom. Size, Standard WeightAirdrome Parts Company LLC · Replaces BACT16AY040404 · Jul 17, 2001 BACT16BN080810PTee, Flareless Tube, Bulkhead On Run, LightweightAirdrome Parts Company LLC · Replaces BACT16BN080810P · Jul 17, 2001

Back to Boeing 737-287C