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 DESCRun 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.
BACE21BL0808JElbow, Flare Less Tube, 90 Deg, Reducer LightweightBACE21BM1010PElbow, Flareless Tube, 45 Deg, Bulkhead LightweightBACE21AU0606DElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightBACE21BN0604PElbow, Flareless Tube, 90 Deg, Bulk-Head, Reducer, Light-WeightBACE21AT1012Elbow, Tube, Flareless 45 Deg, Bulkhead Reducer, Standard WeightBACE21BN0606TElbow, Flareless Tube, 90 Deg, Bulk-Head, Reducer, Light-WeightBACE21BN0404PElbow, Flareless Tube, 90 Deg, Bulk-Head, Reducer, Light-WeightBACE21BN0606PElbow, Flareless Tube, 90 Deg, Bulk-Head, Reducer, Light-WeightBACE21AT1008JElbow, Tube, Flareless 45 Deg, Bulkhead Reducer, Standard WeightBACE21AU1212LElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightBACE21AU0806DElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightBACC27AD12060812Cross, Tube, Flareless-Swivel, Reducer And Nom. Size, Al, Cres, And SteelBACE21BN0504JElbow, Flareless Tube, 90 Deg, Bulk-Head, Reducer, Light-WeightBACE21AT1012DElbow, Tube, Flareless 45 Deg, Bulkhead Reducer, Standard WeightBACE21AT0408Elbow, Tube, Flareless 45 Deg, Bulkhead Reducer, Standard WeightBACE21AU1010DElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightBACE21AT1008SElbow, Tube, Flareless 45 Deg, Bulkhead Reducer, Standard WeightBACE21BN0406PElbow, Flareless Tube, 90 Deg, Bulk-Head, Reducer, Light-WeightBACE21AU0505MElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightBACE21BN1010JElbow, Flareless Tube, 90 Deg, Bulk-Head, Reducer, Light-WeightBACE21AU0808JElbow, Tube, Flareless 45 Deg, Swivel, Reducer And Nom. Size, Standard WeightBACE21AT0806JElbow, Tube, Flareless 45 Deg, Bulkhead Reducer, Standard WeightBACE21BN0808PElbow, Flareless Tube, 90 Deg, Bulk-Head, Reducer, Light-WeightBACE21AT0604Elbow, Tube, Flareless 45 Deg, Bulkhead Reducer, Standard WeightBACE21AT0506DElbow, Tube, Flareless 45 Deg, Bulkhead Reducer, Standard Weight541674-4Nut Tube AssemblyBACN10YA10Nut, Coupling, Lightweight, Flareless, Titanium AlloyM33440018-7Rupture DiscBACN10YA8NNut, Coupling, Lightweight, Flareless, Titanium AlloyBACN10YA4Nut, Coupling, Lightweight, Flareless, Titanium AlloyM33440016-8Rupture DiscBACN10YA16NNut, Coupling, Lightweight, Flareless, Titanium AlloyBACN10YA8Nut, Coupling, Lightweight, Flareless, Titanium AlloyM35240130-8Fill FittingM35240130-17Fill FittingBACN10YA10NNut, Coupling, Lightweight, Flareless, Titanium AlloyBACN10YA12NNut, Coupling, Lightweight, Flareless, Titanium AlloyBACN10YA6Nut, Coupling, Lightweight, Flareless, Titanium AlloyM35240130-3Fill FittingBACN10YA6NNut, Coupling, Lightweight, Flareless, Titanium AlloyBACN10YA12Nut, Coupling, Lightweight, Flareless, Titanium AlloyM35240130-6Fill FittingM35240130-14Fill FittingM33440016-1Rupture DiscBACN10YA16LNut, Coupling, Lightweight, Flareless, Titanium AlloyWF336011Filter Element, HydraulicBACT16BN080808PTee, Flareless Tube, Bulkhead On Run, LightweightBACT16BN060806JTee, Flareless Tube, Bulkhead On Run, LightweightBACT16BN120812JTee, Flareless Tube, Bulkhead On Run, LightweightBACT16BN100808JTee, Flareless Tube, Bulkhead On Run, Lightweight
Back to Boeing 737-287C