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-65393-1Upper BearingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-65393-1 · Feb 12, 2015 69-54541-4Hose GuideAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54541-4 · Feb 12, 2015 65-44610-4ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44610-4 · Feb 12, 2015 69-64900-58ClampAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-58 · Feb 12, 2015 251T2125-2BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 251T2125-2 · Feb 12, 2015 65-46150-34BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-34 · Feb 12, 2015 251T2125-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 251T2125-1 · Feb 12, 2015 65-46116-41Inner Cyl AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46116-41 · Feb 12, 2015 69-41278-4Tow FittingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41278-4 · Feb 12, 2015 69-62795-3BracketAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-627953 · Feb 12, 2015 69-38235-5Rod AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38235-5 · Feb 12, 2015 69-41251-1NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41251-1 · Feb 12, 2015 65-46112-14Rub StripAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46112-18 · Feb 12, 2015 69-54743-1Hose GuideAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54743-1 · Feb 12, 2015 69-54784-1Swivel AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54784-1 · Feb 12, 2015 69-35719-2Clamp BaseAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35719-2 · Feb 12, 2015 66-13873-3Bearing PlateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-13873-3 · Feb 12, 2015 69-40944-1RetainerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-40944-1 · Feb 12, 2015 69-37182-6Bracket ClampAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-37182-6 · Feb 12, 2015 69-53852-1Shim LaminatedAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-53852-1 · Feb 12, 2015 69-35587-4StrapAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35587-4 · Feb 12, 2015 69-58327-1ShimAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-58327-1 · Feb 12, 2015 65-84106-1Retention NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-84106-1 · Feb 12, 2015 69-38709-5Rod AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38709-5 · Feb 12, 2015 69-62283-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-62283-1 · Feb 12, 2015 69-41624-1BoltAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41624-1 · Feb 12, 2015 65-46150-93BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-93 · Feb 12, 2015 69-43201-1Lower BearingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-43201-1 · Feb 12, 2015 65-46150-89BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-89 · Feb 12, 2015 69-63573-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-63573-1 · Feb 12, 2015 65-46200-36Shock Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46200-36 · Feb 12, 2015 65-44713-51Insp Plate AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44713-51 · Feb 12, 2015 65-46150-90BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-90 · Feb 12, 2015 65-44810-6ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44810-6 · Feb 12, 2015 65-46203-24Collar AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46203-24 · Feb 12, 2015 69-63929-2BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-63929-3 · Feb 12, 2015 69-38980-2Orifice PlateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38980-2 · Feb 12, 2015 65-46104-5Drag Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46104-5 · Feb 12, 2015 65-46147-2SleeveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46147-2 · Feb 12, 2015 65-73761-69StrapAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-73761-69 · Feb 12, 2015 65-44566-24FillerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44566-24 · Feb 12, 2015 69-37867-53Bushing-FlangedAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-37867-53 · Feb 12, 2015 69-38709-4RodAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38709-4 · Feb 12, 2015 65-46158-4SpacerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46158-4 · Feb 12, 2015 69-53869-5Rod AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-53869-5 · Feb 12, 2015 69-42183-2NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-42183-2 · Feb 12, 2015 69B70231-1Nut-JamAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69B70231-1 · Feb 12, 2015 69-41622-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41622-1 · Feb 12, 2015 69-54427-1NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54427-1 · Feb 12, 2015 69-59023-1NameplateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-59023-1 · Feb 12, 2015

Back to Boeing 737-287C