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.
BACC2A6B00413EGCable AssemblyBACC2A3C03110EGCable AssemblyBACC2D3B01903EGCable AssemblyBACC2A3C00793FGCable AssemblyBACC2A3C03139EGCable AssemblyBACC2D3B00640FGCable AssemblyBACC2A4B00385FGCable AssemblyBACC2D3B02703FFCable AssemblyBACC2A3A00358DGCable AssemblyBACC2A3A00110DHCable AssemblyBACC2A3A00445FGCable AssemblyBACC2A3C06064EGCable AssemblyBACC2A6B04191FGCable AssemblyBACC2A3A00912EGCable AssemblyBACC2A3A02572FGCable AssemblyBACC2A4B00315FGCable AssemblyBACC2A3C03610EGCable AssemblyBACC2A3A00707CGCable AssemblyBACC2D3B03591EGCable AssemblyBACC2A4B05312FGCable AssemblyBACC2A3A05700EGCable AssemblyBACC2D3B03610EGCable AssemblyBACC2A3C02823EECable AssemblyBACC2A3C00815EGCable AssemblyBACC2A3A01640EGCable AssemblyBACC2A3A00769CGCable AssemblyMDL 12107Smoke detection systems lower cargo compartmentsBACC2A3A00585EGCable AssemblyBACC2A3A00713DGCable AssemblyBACC2D3B02592FFCable AssemblyBACC2D3B02723EECable AssemblyBACC2A3A02640FGCable AssemblyBACC2A3A00385FGCable AssemblyBACC2D3B01257EGCable AssemblyBACC2A4B18834BGCable AssemblyBACC2D3B01853FGCable AssemblyBACC2D3B02692FFCable AssemblyBACC2A3A00864FGCable AssemblyBACC2A4B09349FFCable AssemblyBACC2A3A00630FGCable AssemblyBACC2A4B00321DGCable AssemblyBACC2A3A00827EGCable AssemblyBACC2A3C06053EGCable AssemblyBACC2A3C00865FGCable AssemblyBACC2D3B00864FGCable AssemblyBACC2A3A01418FGCable AssemblyBACC2A3A01853FGCable AssemblyBACC2D3B00614FGCable AssemblyBACC2D3B00911FGCable AssemblyBACC2D3B02625FGCable Assembly
Back to Boeing 737-287C