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.

ANZMB542DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU21JZ · Jan 25, 2015 ANZMKSP5A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP05AJZ · Jan 25, 2015 SSMKP23BR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR23RJ · 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 SSMKP33BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV33RJ · 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 ANZMKP23BR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR23RJZ · Jan 25, 2015 SSMB546DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU37RJ · 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 ANZMKP33BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV33RJZ · Jan 25, 2015 SSMKP68B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR68J · Jan 25, 2015 SSMB542DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU21J · Jan 25, 2015 SSMKP29BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV29RJ · Jan 25, 2015 ANZMKP23BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV23JZ · Jan 25, 2015 SSMB543-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU25JN · Jan 25, 2015 ANZMKP21B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR21JZ · Jan 25, 2015 ANZMKP49B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR49JZ · Jan 25, 2015 SSMKP72BR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR72RJ · Jan 25, 2015 ANZMKP47B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR47JZ · Jan 25, 2015 ANZMB542-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU21JZN · Jan 25, 2015 LST37B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FL37 · Jan 25, 2015 LST29B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FL29 · Jan 25, 2015 ANZMKP68BR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR68RJZ · Jan 25, 2015 ANZMKP23BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV23RJZ · Jan 25, 2015 SSMKSP4-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FP04J · Jan 25, 2015 ANZMKP29BSR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV29RJZ · Jan 25, 2015 SSMKP33BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV33J · Jan 25, 2015 SSMB539DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU12RJ · Jan 25, 2015 ANZMKP23B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FR23JZ · Jan 25, 2015 SSMKP3A-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FS03J · Jan 25, 2015 ANZMB540DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU14RJZ · Jan 25, 2015 ANZMB540-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU14JZN · Jan 25, 2015 ANZMB543DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU25JZ · Jan 25, 2015 ANZMB542DDR-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FU21RJZ · Jan 25, 2015 SSMKP21BS-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10FV21J · Jan 25, 2015

Back to Boeing 707-430