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.

ACLSTB542-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GP21JP · Feb 5, 2015 SSMDPP3-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FX3J · Feb 5, 2015 ANZMDPP5-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FX5JZ · Feb 5, 2015 65-85901-2Latch AssyPECO Inc · PMA PQ0160NM · Replaces 65-85901-2 · Feb 2, 2015 65C16871-1Door FramePECO Inc · PMA PQ0160NM · Replaces 65C16871-1 · Feb 2, 2015 65C16865-4AOxygen BoxPECO Inc · PMA PQ0160NM · Replaces 65C16865-4A · Feb 2, 2015 65C18084-1Diffuser AssemblyPECO Inc · PMA PQ0160NM · Replaces 65C18084-1 · Feb 2, 2015 65C34522-2Door AssyPECO Inc · PMA PQ0160NM · Replaces 65C34522-2 · Feb 2, 2015 65-85900-1Clamp AssyPECO Inc · PMA PQ0160NM · Replaces 65-85900-1 · Feb 2, 2015 742896WERing, Seal MatingWencor LLC · PMA PQ1370NM · Replaces 742896 · Feb 1, 2015 SP2510-00-2097HBlock, SupportSoundair Aviation Services · PMA PQ2540NM · Replaces 62-0126-1 · Jan 27, 2015 SP3810-09-1005HNNut, HexSoundair Aviation Services · PMA PQ2540NM · Replaces 10601CB-251 · Jan 27, 2015 SP2510-00-2095Sensor AssemblySoundair Aviation Services · PMA PQ2540NM · Replaces 62-0075-1 · Jan 27, 2015 ANZMKP20A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS20JZ · Jan 25, 2015 ANZMB544DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU29RJZ · Jan 25, 2015 ANZMKSP10-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP10JZ · Jan 25, 2015 ANZMKP16B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR16JZ · Jan 25, 2015 ANZMKSP3L-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP03LJZ · Jan 25, 2015 ANZMKP21BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV21JZ · Jan 25, 2015 SSMB546DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU37J · Jan 25, 2015 ANZMKP29BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV29JZ · Jan 25, 2015 SSMB545DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU33J · Jan 25, 2015 ANZMKP25B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR25JZ · Jan 25, 2015 ANZMKP37BR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR37RJZ · Jan 25, 2015 SSMKP23B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR23J · Jan 25, 2015 ANZMKSP4A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP04AJZ · Jan 25, 2015 SSMKP23BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV23RJ · Jan 25, 2015 ANZMKSP5-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP05JZ · Jan 25, 2015 ANZMB542DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU21JZ · Jan 25, 2015 ANZMKSP5A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP05AJZ · Jan 25, 2015 ANZMKP6AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS06RJZ · Jan 25, 2015 ANZMKSP4-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP04JZ · Jan 25, 2015 SSMKP29B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR29J · Jan 25, 2015 ANZMKP16BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV16RJZ · Jan 25, 2015 ANZMB543-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU25JZN · Jan 25, 2015 SSMB539DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU12J · Jan 25, 2015 SSMB542-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU21JN · Jan 25, 2015 SSMKSP10-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP10J · Jan 25, 2015 ANZMKP56B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR56JZ · Jan 25, 2015 ANZMKP8AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS08RJZ · Jan 25, 2015 ACMB543DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU25JP · Jan 25, 2015 SSMB546DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU37RJ · Jan 25, 2015 ANZMKP25BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV25RJZ · Jan 25, 2015 ANZMKP16BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV16JZ · Jan 25, 2015 SSMKSP6-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP06J · Jan 25, 2015 SSMKP3L-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FT03LJ · Jan 25, 2015 KP33BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10EX33 · Jan 25, 2015 ANZMKP5AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS05RJZ · Jan 25, 2015 ANZMKP72BR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR72RJZ · Jan 25, 2015 SSMKP37B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR37J · Jan 25, 2015

Back to Boeing 727-259