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.

69-38997-7Spring AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38997-7 · Feb 12, 2015 69-51840-3ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-51840-3 · Feb 12, 2015 69-31981-2Retainer-SpringAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-31981-2 · Feb 12, 2015 65-46150-25BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-25 · Feb 12, 2015 65C31706-1Cam-LowerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65C31706-1 · Feb 12, 2015 65-44751-2ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44751-2 · Feb 12, 2015 65-46210-27Steering PlateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46210-27 · Feb 12, 2015 146T6333-1RetainerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 146T6333-1 · Feb 12, 2015 69-68880-1Conduit SupportAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-68880-1 · Feb 12, 2015 65-46150-49BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-49 · Feb 12, 2015 65-46113-16Trunnion Pin AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46113-16 · Feb 12, 2015 66-24105-3Piston RingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-24105-3 · Feb 12, 2015 65-84108-1LockAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-84108-1 · Feb 12, 2015 65-44825-18ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44825-18 · Feb 12, 2015 65-44650-25ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44650-25 · Feb 12, 2015 69-58823-4Rod AttachmentAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-58823-4 · Feb 12, 2015 66-21730-1SpringAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-21730-1 · Feb 12, 2015 65-46100-31Shock Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46100-31 · Feb 12, 2015 69-54504-1SeatAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54504-1 · Feb 12, 2015 66-24109-3Piston RingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-24109-3 · Feb 12, 2015 65-46150-19BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-19 · Feb 12, 2015 65-46116-20Inner Cyl AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46116-20 · Feb 12, 2015 110A0114-1Seal RingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 110A0114-1 · Feb 12, 2015 65-44521-5Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44521-5 · Feb 12, 2015 69-54784-2Washer- SpecialAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54784-2 · Feb 12, 2015 65-46244-1BracketAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46244-1 · Feb 12, 2015 112N4508-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 112N4508-1 · Feb 12, 2015 69-35587-6StrapAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35587-6 · Feb 12, 2015 69-35587-8StrapAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35587-8 · Feb 12, 2015 69-70281-1Link AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-70281-1 · Feb 12, 2015 65-46150-71BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-71 · Feb 12, 2015 65-44713-10PlateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44713-10 · Feb 12, 2015 65-46150-74BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-74 · Feb 12, 2015 65-46150-33BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-33 · Feb 12, 2015 65-44567-1015Tube AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44567-1015 · Feb 12, 2015 65-73761-35Main Gear AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-73761-35 · Feb 12, 2015 69-41637-1NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41637-1 · Feb 12, 2015 69-41252-1LockAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41252-1 · Feb 12, 2015 69-78230-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-78230-1 · Feb 12, 2015 66-1884-1Hinge HalfAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-1884-1 · Feb 12, 2015 69-73042-1LocknutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-73042-1 · Feb 12, 2015 69-64900-21Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-21 · Feb 12, 2015 69-35397-1LockAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-31997-1 · Feb 12, 2015 69-64900-53Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-53 · Feb 12, 2015 251N4276-1Coupling SleeveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 251N4276-1 · Feb 12, 2015 69-68779-1Bracket AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-68779-1 · Feb 12, 2015 65-46103-13Drag Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46103-13 · Feb 12, 2015 65-73762-5Nose Gear AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-73762-5 · Feb 12, 2015 69-56489-1KeyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-56489-1 · Feb 12, 2015 69-35500-5ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35500-5 · Feb 12, 2015

Back to Boeing 737-287C