Douglas DC-9-11
PMA parts · 9,789
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 ('A6WE')
AND len(list_intersect(tcds_models, ['DC-9-11'])) > 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 ('A6WE')
AND len(list_intersect(tcds_models, ['DC-9-11'])) > 0
ORDER BY supplement_date DESC, drs_guid DESCRun 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.
1268VWBMarker-"Stab etc."1772VWBMarker-"Smoke etc."3869VBWLMarker-"Use etc."1267VWBMarker-"Stab etc."5091MRWLMarker-"Stairway etc."2096VWBMarker-"115 etc"4814VBWMarker-"Buckle etc."4792VRWMarker-"Evacuation etc."3084VBWMarker-"Life etc."1668VWBMarker-"Proximity etc."4757VBWMarker-"Aileron etc."4779VBWMarker-"Toilet etc."4776VBWMarker-"Attention etc."5876VBWMarker-"Emergency etc."3356PRWLMarker-"Open etc."3156VBWMarker-"Emergency etc."3415PRWLMarker-"Life etc"2030PRWMarker-"Halon"1653MSBMarker-"Emergency etc."1651VRWMarker-"Cuerda etc."2749VWBMarker-"F/O etc."4345VWRLMarker-"Remove etc."5007VWBLMarker-"Caution etc."2553VRWMarker-"Do etc."3975PRWLMarker-"Life etc"1621MSBMarker-"Mach etc"4725VXWMarker-"Do etc."4583VBWLMarker-"0 etc"4090VWBLMarker-"Bin etc."1641PRWMarker-"Arrow"3856MBSLMarker-"Coffee etc."4724VBGMarker-"Exit etc."2933PBWMarker-"Door etc."4099PRWLMarker-"Emergency"1622VRWMarker-"Federal etc."4295CEBMarker- Boom etc.4884MBSMarker-"Down etc."2098VWBMarker-"Tcas etc"2701VWBMarker-"Omega etc."4785VWBLMarker-"Life etc."ABYT4V-105Bearing AssemblyARY5-17CRPAFNRod End AssemblyARY5-17CRPAFNWRod End AssemblyASBY3SP11Bearing AssemblyATLF06-103CRBearing AssemblyARY5-14WRod End AssemblyAHJ14C-1001Bushing AssemblyATN4-4CRBearing AssemblyARY5-14Rod End Assembly32800-1710Hat Section Track Cover
Back to Douglas DC-9-11