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.

ANZMKP8A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS08JZ · Jan 25, 2015 KP29BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10EX29 · Jan 25, 2015 ANZMKP12A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS12JZ · Jan 25, 2015 ANZMB540DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU14JZ · Jan 25, 2015 SSMKSP3L-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP03LJ · Jan 25, 2015 SSMKP16BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV16RJ · Jan 25, 2015 SSMKP21B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR21J · Jan 25, 2015 SSMKP48BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV48J · Jan 25, 2015 SSMB540DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU14J · Jan 25, 2015 KP48BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10EX48 · Jan 25, 2015 SSMKP3AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS03RJ · Jan 25, 2015 ANZMKP6A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS06JZ · Jan 25, 2015 ANZMKP68B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR68JZ · Jan 25, 2015 LST49B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FL49 · Jan 25, 2015 ANZMKP29B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR29JZ · Jan 25, 2015 KP49BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10EX49 · Jan 25, 2015 ANZMB539DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU12RJZ · Jan 25, 2015 LST33B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FL33 · Jan 25, 2015 SSMKP37BR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR37RJ · Jan 25, 2015 KP23BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10EX23 · Jan 25, 2015 ANZMKP12AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS12RJZ · Jan 25, 2015 ANZMKP33BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV33JZ · Jan 25, 2015 SSMKP16BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV16J · Jan 25, 2015 SSMB538DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU10RJ · Jan 25, 2015 SSMKP49BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV49J · Jan 25, 2015 SSMKSP4A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP04AJ · Jan 25, 2015 ANZMB545DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU33JZ · Jan 25, 2015 SSMKP56B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR56J · Jan 25, 2015 SSMB540DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU14RJ · Jan 25, 2015 LST21B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FL21 · Jan 25, 2015 ANZMB546DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU37RJZ · Jan 25, 2015 SSMB543DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU25J · Jan 25, 2015 SSMB538DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU10J · Jan 25, 2015 ACMKP20A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS20JP · Jan 25, 2015 SSMKP12AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS12RJ · Jan 25, 2015 ANZMKP37B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR37JZ · Jan 25, 2015 ANZMKP16A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS16JZ · Jan 25, 2015 ANZMKP3AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS03RJZ · Jan 25, 2015 SSMKP25B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR25J · Jan 25, 2015 ANZMB539DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU12JZ · Jan 25, 2015 ANZMKP10A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS10JZ · Jan 25, 2015 SSMKP47B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR47J · Jan 25, 2015 ANZMB538DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU10RJZ · Jan 25, 2015 SSMKP49B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR49J · Jan 25, 2015 SSMKP16B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR16J · Jan 25, 2015 ANZMKP33B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR33JZ · Jan 25, 2015 ANZMKSP6-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP06JZ · Jan 25, 2015 680146-916HO RingHRD Aerosystems Inc · PMA PQ1451NM · Replaces 680146-916 · Jan 15, 2015 1A2313-7HO-RingHRD Aerosystems Inc · PMA PQ1451NM · Replaces 1A2313-7 · Jan 15, 2015 680146-905HO-RingHRD Aerosystems Inc · PMA PQ1451NM · Replaces 680146-905 · Jan 15, 2015

Back to Boeing 737-287C