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-09060ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-226,, KOITO P/N… · Feb 1, 2009 82000-78125ATSExit Sign LensAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N S479W220-1125, KOITO P/N… · Feb 1, 2009 82000-09022ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-99,, KOITO P/N… · Feb 1, 2009 82000-09015ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-63,, KOITO P/N… · Feb 1, 2009 82000-09040ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-157,, KOITO P/N… · Feb 1, 2009 82000-09089ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-332,, KOITO P/N… · Feb 1, 2009 82000-09029ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-124,, KOITO P/N… · Feb 1, 2009 82000-09074ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-267,, KOITO P/N… · Feb 1, 2009 82000-09032ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-131,, KOITO P/N… · Feb 1, 2009 82000-09018ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-82,, KOITO P/N… · Feb 1, 2009 82000-09056ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-217,, KOITO P/N… · Feb 1, 2009 82000-09027ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-120,, KOITO P/N… · Feb 1, 2009 82000-09049ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-165,, KOITO P/N… · Feb 1, 2009 82000-09016ATSExit Sign Type DAaxico Technical Services · PMA PQ1565CE · Replaces BOEING P/N, S417T504-67,, KOITO P/N… · Feb 1, 2009 JA43702005Bushing - FoodtrayJet Avion Corporation A HEICO Aerospace Company · PMA PQ1015CE · Replaces 43702005 · Jan 29, 2009 46675-101Folding Center Guide AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17718E-100Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-600Assembly Rear PanelAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17701E-100Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17455-200Base AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 45145-102Lower Compartment Cargo Pallet Restraint SystemAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-900Assembly Door FabricAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 22056DLCargo Restraint SystemAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-100Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17170-100-2Assembly LD-3 Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17630E-100Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-500Assembly OutboardAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-300Assembly BottomAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17455-100Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17083-100Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-700Assembly Front PanelAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-200Assembly BottomAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 46675-105Folding Center Guide AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17609E-100Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17455-600Door AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17455-300Top AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17455-400Panel AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 46675-104Folding Center Guide AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-1000Assembly ShelfAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-400Assembly InboardAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17617E-100Cargo ContainerAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17455-500Panel AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 46675-103Folding Center Guide AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 17026-800Assembly Rigid DoorAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 47152Modification PartAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 46675-102Folding Center Guide AssemblyAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 45478-102Lower Compartment Cargo Pallet Restraint SystemAAR Cargo Systems · PMA PQ3981CE · Modification part · Jan 22, 2009 AD-15576Terminal ConnectorAero Design Inc · PMA PQ1465CE · Replaces Saft 015576-000 and 057014, Installed… · Jan 7, 2009 AD-15578Terminal ConnectorAero Design Inc · PMA PQ1465CE · Replaces Saft 015578-000 and 015266, Installed… · Jan 7, 2009 69B17928-1WDPlate, BearingWencor LLC (formerly Dixie Aerospace LLC) · PMA PQ1630CE · Replaces Boeing 69B17928-1 · Jan 7, 2009

Back to Boeing 747-SR