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.

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 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 AC9102LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU15PPJ · Feb 10, 2015 AC1912LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT60P · Feb 10, 2015 AC9102-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU15 · 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 AC1900LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT10P · 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 SS1912-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT60C · Feb 10, 2015 AC1906-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT30 · Feb 10, 2015 305560HSyphon TubeHRD Aerosystems Inc · PMA PQ1451NM · Replaces 305560 · Feb 10, 2015 SS1913LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT65PPJC · 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 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 AC9108-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU40 · Feb 10, 2015 AC1913LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT65P · Feb 10, 2015 SS1906-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT30C · Feb 10, 2015 AC1908LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT40PPJ · Feb 10, 2015 AC9118-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU90 · Feb 10, 2015 AC9105LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU25PPJ · Feb 10, 2015 AC1915-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT75 · Feb 10, 2015

Back to Boeing 737-287C