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-46116-40PlugAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46116-40 · Feb 12, 2015 65-73761-113Side Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-73761-113 · Feb 12, 2015 65-46150-59BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-59 · Feb 12, 2015 69-64900-17Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-17 · Feb 12, 2015 65-46150-39BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-39 · Feb 12, 2015 69-68730-2Snubber ValveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-68730-2 · Feb 12, 2015 65-61794-1Metering PinAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-61794-1 · Feb 12, 2015 69-63320-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-63320-1 · Feb 12, 2015 65-44741-7Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44741-7 · Feb 12, 2015 65-46150-55BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-55 · Feb 12, 2015 69-53203-1SpacerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-53203-1 · Feb 12, 2015 65-46150-85BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-85 · Feb 12, 2015 69-38981-1Scraper AdapterAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38981-1 · Feb 12, 2015 69-39152-1Name PlateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-39152-1 · Feb 12, 2015 65-44910-3WireAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44910-3 · Feb 12, 2015 69-36621-1Washer-LockAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-36621-1 · Feb 12, 2015 65-44713-15Insp Plate AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44713-15 · Feb 12, 2015 65-46116-19Inner Cyl AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46116-19 · Feb 12, 2015 69-64900-54Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-54 · Feb 12, 2015 65-44825-17ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44825-17 · Feb 12, 2015 65-46150-3BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-3 · Feb 12, 2015 65-44651-17ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44651-17 · Feb 12, 2015 69-39468-1Retainer RingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-39468-1 · Feb 12, 2015 69-41249-1Washer-LockAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41249-1 · Feb 12, 2015 66-13205-1Retaining NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-13205-1 · Feb 12, 2015 69-36446-4BoltAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-36446-4 · Feb 12, 2015 65-44503-8Cylinder AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44503-8 · Feb 12, 2015 69-71714-4AdapterAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-71714-4 · Feb 12, 2015 65-46142-7Hook AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46142-7 · Feb 12, 2015 65-44521-6Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44521-6 · Feb 12, 2015 65-45190-9ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-45190-9 · Feb 12, 2015 65-49716-15TubeAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-49716-15 · Feb 12, 2015 65-44961-7ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44961-7 · Feb 12, 2015 65-73761-81Main Gear AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-73761-81 · Feb 12, 2015 69-35800-2WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35800-2 · Feb 12, 2015 65-46150-62BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-62 · Feb 12, 2015 65-84107-1Reservoir AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-84107-1 · Feb 12, 2015 69-65397-1Outer Shell AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-65397-1 · Feb 12, 2015 65-46150-83BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-83 · Feb 12, 2015 65-46200-54Metering Pin AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46200-54 · Feb 12, 2015 69-36629-2Scraper AdapterAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-36629-2 · Feb 12, 2015 65-46147-3SleeveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46147-3 · Feb 12, 2015 65-46150-21BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-21 · Feb 12, 2015 65-46203-12Collar AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46203-12 · Feb 12, 2015 69-42187-1Roller AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-42187-1 · Feb 12, 2015 65-46100-27Shock Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46100-27 · Feb 12, 2015 65-46150-125BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-125 · Feb 12, 2015 69-62723-1Shear StudAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-62723-1 · Feb 12, 2015 69-64900-50Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-50 · Feb 12, 2015 65-46150-75BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-75 · Feb 12, 2015

Back to Boeing 737-287C