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-39PlugAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46116-39 · Feb 12, 2015 69-76508-1Lower BearingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-76508-1 · Feb 12, 2015 65-46150-73BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-73 · Feb 12, 2015 69-73008-2PinAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-73008-2 · Feb 12, 2015 66-23737-187Support BracketAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-23737-187 · Feb 12, 2015 65-63415-2Fitting AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-63415-2 · Feb 12, 2015 69-54618-1Hose GuideAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54618-1 · Feb 12, 2015 65-44713-14Insp Plate AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44713-14 · Feb 12, 2015 69-41262-1PinAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41262-1 · Feb 12, 2015 69-35987-1Hose Guide AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35987-1 · Feb 12, 2015 65-46150-70BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-70 · Feb 12, 2015 65-17819-3StrapAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-17819-3 · Feb 12, 2015 65-49753-22Conduit AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-49753-22 · Feb 12, 2015 65-46244-2BracketAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46244-2 · Feb 12, 2015 65-17821-9Package AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-17821-9 · Feb 12, 2015 69-38983-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38983-1 · Feb 12, 2015 69-42195-1Dowel PinAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-42195-1 · Feb 12, 2015 6-66189Extension SpringAviation Materials Management, Inc · PMA PQ5273NM · Replaces 6-66189 · Feb 12, 2015 69-42189-1RetainerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-42189-1 · Feb 12, 2015 65C26833-3Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65C26833-3 · Feb 12, 2015 65-63397-9Side Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-63397-9 · Feb 12, 2015 69-37156-17AngleAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-37156-17 · Feb 12, 2015 65-46150-95BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-95 · Feb 12, 2015 69-40763-1RetainerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-40763-1 · Feb 12, 2015 65-46150-86BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-86 · Feb 12, 2015 69-61785-8Bearing AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-61785-8 · Feb 12, 2015 65C26885-6Valve AssemblyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65C26885-6 · Feb 12, 2015 69-64900-22Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-22 · Feb 12, 2015 69-39474-1PinAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-39474-1 · Feb 12, 2015 69-41636-1NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41636-1 · Feb 12, 2015 65-17821-19Package AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-17821-19 · Feb 12, 2015 65-46150-30BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-30 · Feb 12, 2015 65-46150-42BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-42 · Feb 12, 2015 66-25180-1Pin-RetainerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-25180-1 · Feb 12, 2015 65-46107-1Universal AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46107-1 · Feb 12, 2015 69-54541-5Hose GuideAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54541-5 · Feb 12, 2015 69-54508-1SpringAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54508-1 · Feb 12, 2015 65-46150-4BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-4 · Feb 12, 2015 69-35500-6ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35500-6 · Feb 12, 2015 65-46150-54BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-54 · Feb 12, 2015 66-24146-1Retainer RingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-24146-1 · Feb 12, 2015 65-46113-8Trunnion Pin AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46113-8 · Feb 12, 2015 69-39469-1SpacerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-39469-1 · Feb 12, 2015 65-46150-58BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-58 · Feb 12, 2015 LA555022DiaphragmLanAir Research and Development Inc · PMA PQ1031NE · Replaces 555022 · Feb 11, 2015 AC9117LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU85PPJ · Feb 10, 2015 SS1904-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT20C · Feb 10, 2015 AC9110LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU50P · Feb 10, 2015 AC9113LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU65PPJ · Feb 10, 2015 SS1910-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT50C · Feb 10, 2015

Back to Boeing 737-287C