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.

D1-4275-151SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-151 · Aug 28, 2015 S-13788-120SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-120 · Aug 28, 2015 4791-8Seat AssyKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-8 · Aug 28, 2015 D1-4275-126SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-126 · Aug 28, 2015 5677-11SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60824-11 · Aug 28, 2015 4791-14SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-14 · Aug 28, 2015 S-13788-149SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-149 · Aug 28, 2015 BACG20AF4B2GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF4B2 · Aug 28, 2015 D1-4275-116SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-116 · Aug 28, 2015 S-13788-127SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-127 · Aug 28, 2015 D1-4275-138SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-138 · Aug 28, 2015 S-13789-26SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-26 · Aug 28, 2015 S-13789-53SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-53 · Aug 28, 2015 4791-30SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-30 · Aug 28, 2015 S-13788-148SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-148 · Aug 28, 2015 D1-4275-1027SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-1027 · Aug 28, 2015 S-13789-18SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-18 · Aug 28, 2015 S-13788-105SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-105 · Aug 28, 2015 S-13788-109SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-109 · Aug 28, 2015 S-13788-24SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-24 · Aug 28, 2015 S-13789-21SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-21 · Aug 28, 2015 S-13789-19SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-19 · Aug 28, 2015 D1-4275-148SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-148 · Aug 28, 2015 S-13789-10SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-10 · Aug 28, 2015 S-13788-147SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-147 · Aug 28, 2015 D1-4275-47SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-47 · Aug 28, 2015 D1-4275-128SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-128 · Aug 28, 2015 5673-130SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-130 · Aug 28, 2015 S-13788-1041SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-1041 · Aug 28, 2015 S-13789-28SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-28 · Aug 28, 2015 D1-4275-110SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-110 · Aug 28, 2015 4791-56SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-56 · Aug 28, 2015 D1-4275-153SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-153 · Aug 28, 2015 S-13788-138SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-138 · Aug 28, 2015 D1-4275-29SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-29 · Aug 28, 2015 4791-7SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-7 · Aug 28, 2015 D-1859-24DUCT - FLEXIBLEKirkhill-TA Co · PMA PQ1981NM · Replaces 10-3274-24 · Aug 28, 2015 4791-5Seat AssyKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-5 · Aug 28, 2015 D1-4275-19SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-19 · Aug 28, 2015 4791-45SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-45 · Aug 28, 2015 D1-4275-115SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-115 · Aug 28, 2015 D-1859-11SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-3274-11 · Aug 28, 2015 S-13788-23SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-23 · Aug 28, 2015 D1-4275-113SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-113 · Aug 28, 2015 S-13788-122SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-122 · Aug 28, 2015 S-13788-142SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-142 · Aug 28, 2015 S-13789-48SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-48 · Aug 28, 2015 S-13788-145SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-145 · Aug 28, 2015 S-13789-52SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-52 · Aug 28, 2015 S-13788-143SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-143 · Aug 28, 2015

Back to Boeing 707-430