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.

65-46150-18BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-18 · Feb 12, 2015 69-52228-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-52228-1 · Feb 12, 2015 69-71754-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-71754-1 · Feb 12, 2015 65-44725-44ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44725-44 · Feb 12, 2015 69-63319-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-63319-1 · Feb 12, 2015 65-44725-42ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44725-42 · Feb 12, 2015 65-44821-4Control ValveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44821-4 · Feb 12, 2015 69-38248-1Link AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38248-1 · Feb 12, 2015 65-46150-36BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-36 · Feb 12, 2015 69-60774-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-60774-1 · Feb 12, 2015 66-24494-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-24494-1 · Feb 12, 2015 251N4276-1Coupling SleeveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 251N4276-1 · Feb 12, 2015 65-49920-31Door AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-49920-31 · Feb 12, 2015 65-46150-100BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-100 · Feb 12, 2015 69-42190-2SpacerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-42190-2 · Feb 12, 2015 65-46150-5BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-5 · Feb 12, 2015 65-46150-29BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-29 · Feb 12, 2015 69-63574-1KeyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-63574-1 · Feb 12, 2015 65-73761-34Main Gear AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-73761-34 · Feb 12, 2015 66-18544-1Grounding TerminalAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-18544-1 · Feb 12, 2015 69-39461-2BoltAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-39461-2 · Feb 12, 2015 65-46150-67BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-67 · Feb 12, 2015 65-44650-26ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44650-26 · Feb 12, 2015 69-58853-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-58853-1 · Feb 12, 2015 65-46200-7SealAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46200-7 · Feb 12, 2015 66-24105-1Piston RingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-24105-1 · Feb 12, 2015 69-35719-1ClampAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35719-1 · Feb 12, 2015 140N2022-1Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 140N2022-1 · Feb 12, 2015 65-46150-24BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-24 · Feb 12, 2015 65-17822-9Package AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-17822-9 · Feb 12, 2015 65-46227-1Cam-UpperAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46227-1 · Feb 12, 2015 65-46150-16BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-16 · Feb 12, 2015 69-35587-15StrapAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35587-15 · Feb 12, 2015 69-78230-2BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-78230-2 · Feb 12, 2015 69-51840-4ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-51840-4 · Feb 12, 2015 66-24104-1LockAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-24104-1 · Feb 12, 2015 69-54357-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54357-1 · Feb 12, 2015 65-46150-40BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-40 · Feb 12, 2015 65-46150-20BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-20 · Feb 12, 2015 65-46228-3Cam LowerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46228-3 · Feb 12, 2015 65-46150-92BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-92 · Feb 12, 2015 65-44531-4Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44531-4 · Feb 12, 2015 66-24447-2Spacer WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-24447-2 · Feb 12, 2015 69-54356-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54356-1 · Feb 12, 2015 69-37182-7Bracket ClampAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-37182-7 · Feb 12, 2015 65-46150-88BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-88 · Feb 12, 2015 69-35587-5StrapAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35587-5 · Feb 12, 2015 65-46288-5Torsion Link AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46288-5 · Feb 12, 2015 69-63321-1NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-63321-1 · Feb 12, 2015 69-62228-2WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-62228-2 · Feb 12, 2015

Back to Boeing 737-287C