Skip to content

PMA parts · 10,464

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 ('4A26')
    AND len(list_intersect(tcds_models, ['707-400 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 ('4A26')
  AND len(list_intersect(tcds_models, ['707-400 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.

SSMKSP5-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP05J · Jan 25, 2015 ACMKP6A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS06JP · Jan 25, 2015 ANZMKP4AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS04RJZ · Jan 25, 2015 ANZMKP48BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV48JZ · Jan 25, 2015 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 ANZMKP68B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR68JZ · Jan 25, 2015 ANZMKP29B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR29JZ · 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 ANZMKP12AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS12RJZ · Jan 25, 2015 ACMKP3AR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS03RJP · Jan 25, 2015 ANZMKP33BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV33JZ · Jan 25, 2015 SSMB540-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU14JN · 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 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 SSMB541-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU17JN · 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 SSMKP29BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV29J · Jan 25, 2015 ANZMB541-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU17JZN · Jan 25, 2015 SSMKP10-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FT10J · 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 ANZMKSP6-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP06JZ · Jan 25, 2015

Back to Boeing 707-430