Skip to content

PMA parts · 19,401

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 ('A3WE')
    AND len(list_intersect(tcds_models, ['727-200 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 ('A3WE')
  AND len(list_intersect(tcds_models, ['727-200 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-17882-31Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65-17882-31 · Feb 12, 2015 6-66189Extension SpringAviation Materials Management, Inc · PMA PQ5273NM · Replaces 6-66189 · Feb 12, 2015 LA555022DiaphragmLanAir Research and Development Inc · PMA PQ1031NE · Replaces 555022 · Feb 11, 2015 54C54667A2Main Cargo Door ActuatorTactair Fluid Controls Inc · PMA PQ0847NE · Replaces Tactair 54C54667E01 · 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 SS1910-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT50C · Feb 10, 2015 SS1913-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT65C · Feb 10, 2015 AC1913-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT65 · Feb 10, 2015 AC1900-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT10 · Feb 10, 2015 AC1916-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT80 · Feb 10, 2015 AC9102LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU15P · Feb 10, 2015 FL4C6-2PULLEYSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACP30G8 · Feb 10, 2015 AC1904-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT20 · Feb 10, 2015 AC1910LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT50P · Feb 10, 2015 SSLST49BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GR49J · Feb 10, 2015 AC1916LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT80P · Feb 10, 2015 AC9106-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU30 · Feb 10, 2015 AC1903LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT17PPJ · Feb 10, 2015 AC9101LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU12PPJ · Feb 10, 2015 AC9105-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU25 · Feb 10, 2015 AC9102-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU15 · Feb 10, 2015 AC1907-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT35 · Feb 10, 2015 AC9107LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU35P · Feb 10, 2015 AC9104-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU20 · Feb 10, 2015 AC1915LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT75P · Feb 10, 2015 AC1912-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT60 · Feb 10, 2015 AC1903-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT17 · Feb 10, 2015 SS1903LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT17PPJC · Feb 10, 2015 AC1306-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GW30 · Feb 10, 2015 FL3C3-4PULLEYSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACP30G1A · Feb 10, 2015 AC1911-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT55 · Feb 10, 2015 FL3C6-3PULLEYSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACP30G5 · Feb 10, 2015 AC9108LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU40PPJ · Feb 10, 2015 AC1913LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT65PPJ · Feb 10, 2015 AC9107LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU35PPJ · Feb 10, 2015 AC1904LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT20P · Feb 10, 2015 SS1905-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT25C · Feb 10, 2015 AC1910-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT50 · Feb 10, 2015 AC1906-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT30 · Feb 10, 2015 AC1907LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT35P · Feb 10, 2015 AC9106LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU30PPJ · Feb 10, 2015 AC1909LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT45PPJ · Feb 10, 2015 AC1911LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT55P · Feb 10, 2015 AC9103-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU17 · Feb 10, 2015 AC9120-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU100 · Feb 10, 2015 SS1908LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT40PC · Feb 10, 2015 AC9109LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU45PPJ · Feb 10, 2015 FL3C3-3PULLEYSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACP30G2 · Feb 10, 2015

Back to Boeing 727-259