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.

S-13788-153SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-153 · Aug 28, 2015 D1-4275-145SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-145 · Aug 28, 2015 D1-4275-150SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-150 · Aug 28, 2015 D1-4275-28SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-28 · Aug 28, 2015 4791-20Fabric Covered Seal AerodynamicKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-20 · Aug 28, 2015 S-13788-121SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-121 · Aug 28, 2015 4791-17SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-17 · Aug 28, 2015 5677-12SEAL - FABRIC IMPREGNATEDKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60824-12 · Aug 28, 2015 5673-3AERODYNAMIC SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-3 · Aug 28, 2015 D1-4275-146SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-146 · Aug 28, 2015 S-13789-55SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-55 · Aug 28, 2015 S-13789-16SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-16 · Aug 28, 2015 D1-4275-137SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-137 · Aug 28, 2015 D1-4275-34SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-34 · Aug 28, 2015 S-13789-7SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-7 · Aug 28, 2015 S-13789-22SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-22 · Aug 28, 2015 S-13788-19SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-19 · Aug 28, 2015 4791-22SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-22 · Aug 28, 2015 D1-4275-143SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-143 · Aug 28, 2015 S-13789-43SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-43 · Aug 28, 2015 S-13788-67SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-67 · Aug 28, 2015 D1-4275-133SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-133 · Aug 28, 2015 D1-4275-121SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-121 · Aug 28, 2015 S-13788-128SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-128 · Aug 28, 2015 S-13788-1027SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-1027 · Aug 28, 2015 S-13788-18SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-18 · Aug 28, 2015 D1-4275-142SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-142 · Aug 28, 2015 S-13789-44SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-44 · Aug 28, 2015 D-1859-1FLEXIBLE BELLOWSKirkhill-TA Co · PMA PQ1981NM · Replaces 10-3274-1 · Aug 28, 2015 S-13789-5SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-5 · Aug 28, 2015 S-13788-151SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-151 · Aug 28, 2015 S-13788-136SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-136 · Aug 28, 2015 S-13788-39SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-39 · Aug 28, 2015 4791-16SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-16 · Aug 28, 2015 5926-3SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60912-3 · Aug 28, 2015 S-13788-115SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-115 · Aug 28, 2015 S-13788-125SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-125 · Aug 28, 2015 D1-4275-117SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-117 · Aug 28, 2015 S-13788-139SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-139 · Aug 28, 2015 S-13789-49SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-49 · Aug 28, 2015 S-13788-117SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-117 · Aug 28, 2015 BACG20AF4B7GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF4B7 · Aug 28, 2015 D1-4275-55SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-55 · Aug 28, 2015 S-13788-113SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-113 · Aug 28, 2015 S-12778SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60824-11 · Aug 28, 2015 D1-4275-135SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-135 · Aug 28, 2015 D1-4275-18SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-18 · Aug 28, 2015 S-13789-50SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60120-50 · Aug 28, 2015 D1-4275-139SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-2737-139 · Aug 28, 2015 SF15-103-659SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-659 · Aug 28, 2015

Back to Boeing 707-430