Skip to content

PMA parts · 38,389

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 ('A20WE')
    AND len(list_intersect(tcds_models, ['747SR 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 ('A20WE')
  AND len(list_intersect(tcds_models, ['747SR 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.

82000-09036ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-143,, KOITO P/N… · Feb 1, 2009 82000-09010ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-35,, KOITO P/N… · Feb 1, 2009 82000-09033ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-132,, KOITO P/N… · Feb 1, 2009 82000-09028ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-123,, KOITO P/N… · Feb 1, 2009 82000-09035ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-142,, KOITO P/N… · Feb 1, 2009 82000-78129ATSExit Sign LensAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N S479W220-1129, KOITO P/N… · Feb 1, 2009 82000-09057ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-218,, KOITO P/N… · Feb 1, 2009 82000-09045ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-178,, KOITO P/N… · Feb 1, 2009 82000-09012ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-44,, KOITO P/N… · Feb 1, 2009 82000-09079ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-303,, KOITO P/N… · Feb 1, 2009 82000-09082ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-309,, KOITO P/N… · Feb 1, 2009 82000-09011ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-40,, KOITO P/N… · Feb 1, 2009 82000-09078ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-294,, KOITO P/N… · Feb 1, 2009 82000-09008ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-27,, KOITO P/N… · Feb 1, 2009 82000-09007ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-26,, KOITO P/N… · Feb 1, 2009 82000-09038ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-160,, KOITO P/N… · Feb 1, 2009 82001-16402ATSExit Sign HousingAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N S417T504-3000, KOITO P/N… · Feb 1, 2009 82000-09065ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-240,, KOITO P/N… · Feb 1, 2009 82000-09025ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-106,, KOITO P/N… · Feb 1, 2009 82000-78128ATSExit Sign LensAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N S479W220-1128, KOITO P/N… · Feb 1, 2009 82000-09044ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-174,, KOITO P/N… · Feb 1, 2009 82000-09067ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-247,, KOITO P/N… · Feb 1, 2009 82000-09042ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-163,, KOITO P/N… · Feb 1, 2009 82000-09072ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-265,, KOITO P/N… · Feb 1, 2009 82000-09021ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-95,, KOITO P/N… · Feb 1, 2009 82000-09031ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-126,, KOITO P/N… · Feb 1, 2009 82000-09023ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-103,, KOITO P/N… · Feb 1, 2009 82000-09080ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-304,, KOITO P/N… · Feb 1, 2009 82000-09073ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-266,, KOITO P/N… · Feb 1, 2009 82000-09083ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-316,, KOITO P/N… · Feb 1, 2009 82000-09058ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-219,, KOITO P/N… · Feb 1, 2009 82000-09069ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-258,, KOITO P/N… · Feb 1, 2009 82000-09037ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-147,, KOITO P/N… · Feb 1, 2009 82000-09075ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-273,, KOITO P/N… · Feb 1, 2009 82000-09009ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-31,, KOITO P/N… · Feb 1, 2009 82000-09070ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-259,, KOITO P/N… · Feb 1, 2009 82000-09084ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-317,, KOITO P/N… · Feb 1, 2009 82000-09047ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-189,, KOITO P/N… · Feb 1, 2009 82000-78127ATSExit Sign LensAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N S479W220-1127, KOITO P/N… · Feb 1, 2009 82000-09024ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-104,, KOITO P/N… · Feb 1, 2009 82000-09048ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-191,, KOITO P/N… · Feb 1, 2009 82000-09050ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-197,, KOITO P/N… · Feb 1, 2009 82000-09064ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-239,, KOITO P/N… · Feb 1, 2009 82000-09062ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-231,, KOITO P/N… · Feb 1, 2009 82000-09061ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-230,, KOITO P/N… · Feb 1, 2009 82000-09030ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-125,, KOITO P/N… · Feb 1, 2009 82000-09017ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-76,, KOITO P/N… · Feb 1, 2009 82000-09052ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-207,, KOITO P/N… · Feb 1, 2009 82000-09071ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-260,, KOITO P/N… · Feb 1, 2009 82000-09085ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-325,, KOITO P/N… · Feb 1, 2009

Back to Boeing 747-SR