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.
BACC10GF24CClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF80Clamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF96Clamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF48DClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF18CClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF20DClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF36Clamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF36DClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF88Clamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF8DClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF52DClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF16DClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10GF10DClamp, U Type, With or Without Crossbar, Aluminum, Steel or Cres, Silicon CushionBACC10CC5Clamp, U-Type, with Cross Bar, PTFE CushionBACC10CC16SClamp, U-Type, with Cross Bar, PTFE CushionBACC10GE26Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE40AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE64Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE9CClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE45AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10CC32SClamp, U-Type, with Cross Bar, PTFE CushionBACC10GE11AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE4AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10CC32Clamp, U-Type, with Cross Bar, PTFE CushionBACC10GE56Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE44Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE16CClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10CC12Clamp, U-Type, with Cross Bar, PTFE CushionBACC10GE37Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10CC40Clamp, U-Type, with Cross Bar, PTFE CushionBACC10GE40Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE32AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE4CClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE48Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE28CClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE48AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE56AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE8AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE23Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10CC24SClamp, U-Type, with Cross Bar, PTFE CushionBACC10GE25Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE19Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10CC40SClamp, U-Type, with Cross Bar, PTFE CushionBACC10CC64SClamp, U-Type, with Cross Bar, PTFE CushionBACC10GE42AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE7AClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE8CClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10CC56SClamp, U-Type, with Cross Bar, PTFE CushionBACC10GE20Clamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged CushionBACC10GE6CClamp, Loop, Aluminum, Steel or Cres, Reinforced Corners, Silicon Wedged Cushion
Back to Boeing 737-287C