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-44651-16ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44651-16 · Feb 12, 2015 69-64900-55Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-55 · Feb 12, 2015 65-44566-3020Tube AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44566-3020 · Feb 12, 2015 69-54618-3Guide ClampAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54618-3 · Feb 12, 2015 69-35849-2BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35849-2 · Feb 12, 2015 69-35395-3WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-31995-3 · Feb 12, 2015 69-61381-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-61381-1 · Feb 12, 2015 66-23751-3Bracket ClampAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-23751-3 · Feb 12, 2015 69-44404-1Ground Strap AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-44404-1 · Feb 12, 2015 65-46150-48BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-48 · Feb 12, 2015 65-46150-87BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-87 · Feb 12, 2015 69-61382-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-61382-1 · Feb 12, 2015 65-84105-1RetainerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-84105-1 · Feb 12, 2015 66-25608-2Shim-WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-25608-2 · Feb 12, 2015 69-71714-3Lube Fitting AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-71714-3 · Feb 12, 2015 65-46113-5Trunnion Pin AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46113-5 · Feb 12, 2015 66-23289-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-23289-1 · Feb 12, 2015 65-44910-12ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44910-12 · Feb 12, 2015 69-61946-1Tube AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-61946-1 · Feb 12, 2015 65-46150-66BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-66 · Feb 12, 2015 65-46100-26Shock Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46100-26 · Feb 12, 2015 65-44503-10Cylinder AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44503-10 · Feb 12, 2015 65-44713-56Cover AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44713-56 · Feb 12, 2015 69-64900-18Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-64900-18 · Feb 12, 2015 65-46165-3Seal AdapterAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46165-3 · Feb 12, 2015 65-44810-5ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44810-5 · Feb 12, 2015 69-35573-3SupportAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35573-3 · Feb 12, 2015 69-40942-1Seal RingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-40942-1 · Feb 12, 2015 69-14169-4End CapAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-14169-4 · Feb 12, 2015 69-63392-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-63392-1 · Feb 12, 2015 65-44925-15ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44925-15 · Feb 12, 2015 65-67963-3Torsion Link AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-67963-3 · Feb 12, 2015 69-35849-3BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35849-3 · Feb 12, 2015 69-38248-2Link AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38248-2 · Feb 12, 2015 69-43203-1FillerAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-43203-1 · Feb 12, 2015 69-35573-1Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-35573-1 · Feb 12, 2015 69-54541-3PlateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54541-3 · Feb 12, 2015 69-41900-5Ground AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-41900-5 · Feb 12, 2015 69-39467-1LockwasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-39467-1 · Feb 12, 2015 69-37867-15Bushing-FlangedAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-37867-15 · Feb 12, 2015 69-38989-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-38989-1 · Feb 12, 2015 65-46203-19Laminated ShimAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46203-19 · Feb 12, 2015 65-46150-81BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46150-81 · Feb 12, 2015 65-44625-14Lock Actuator AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-44625-14 · Feb 12, 2015 69-73133-1Support AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-73133-1 · Feb 12, 2015 69-54577-1PistonAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-54577-1 · Feb 12, 2015 69-56457-4WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-56457-4 · Feb 12, 2015 65-46100-54Shock Strut AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46100-54 · Feb 12, 2015 65-46147-1SleeveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-46147-1 · Feb 12, 2015 69-35393-1NutAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69-31993-1 · Feb 12, 2015

Back to Boeing 737-287C