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.
A1124VYYMarker-Potable etc.A1086VBWLMarker-Thrust etc.A1144VYYMarker-Arrow etc.A1119VYYMarker-No etc.A1109VYYMarker-Warning etc.A1142VYYMarker-Pull etc.A1126VYYMarker-Warning etc.A1087VRWLMarker-Warning etc.A1139VYYMarker-Inside etc.A1131VYYMarker-Oxygen etc.A1135VYYMarker-Emergency etc.A1128VYYMarker-Unlocked etc.2560PRWMarker-Life etc.A1115VYYMarker-Max etc.A1164VYYMarker-First etc.A1151VYYMarker-Push etc.A1127VYYMarker-Locked etc.A1064VBWLMarker-Engine etc.A1141VYYMarker-Pull etc.A0721VRWMarker-This etc.A1166VYYMarker-Alternate etc.A1168MMSMarker-Para etc.A1114VYYMarker-Emergency etc.A1161VYYMarker-Caution etc.A1118VYYMarker-Ground etc.A1106VYYMarker-Controls etc.A1111VYYMarker-Engine etc.A1170PMGMarker-Salida etc.A1160VYYMarker-Static etc.A1104VYYMarker-Thrust etc.A0559VRWMarker-Pull etc.A1159VYYMarker-SymbolA1147VYYMarker-External etc.7286PRWMarker-Emergency etc.A1116VYYMarker-Open etc.A1105VYYMarker-Hoist etc.A1171MBSMarker-Los etc.A1103VYYMarker-Constant etc.A1095MSBMarker-coffee etc.A1133VYYMarker-For etc.A1138VYYMarker-Arrow etc.A0967PWBMarker-Emergency etc.A1162VYYMarker-Flight etc.A1120VYYMarker-Arrow etc.A1063VBWLMarker-Csd etc.A1145MSBMarker-Symbol etc.A1149VYYMarker-Close etc.S6-06-0136Standard Survival Kit211729Modification Kit, Thermostat122-30026-01841Self -Coil Shade Assy.
Back to Douglas DC-9-11