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.
7957MBSMarker-"Doors etc."7954MBSMarker-"Maximum etc."7956MBSMarker-"All etc."7958VRWMarker-"Do etc."7960MBSMarker-"Curtain etc."7925VYYMarker- symbol etc.7873VDWMarker- No etc.7961MBSMarker- CD etc.8048MSBMarker- Lycoming etc.55238WE, 688658WEWasher, Pressure Seal27114-5WE, TA1720SS5TWEClamp-Loop Cushioned27114-6WE, TA1720SS6TWEClamp-Loop Cushioned961-5059-002CONTROLLER, WINDSHIELD TEMP.969-0034-001SENSOR, BATTERY126372WESeal693588WESpacer975-0041-001Switch, Thermal969-0018-001SENSOR, CABIN AIR965-3025-001Detector27114-3WE, TA1720SS3TWEClamp-Loop Cushioned27114-2WE, TA1720SS2TWEClamp-Loop Cushioned2013-1ASMIBattery Assembly "D" Cell (NiCad)2144Valve-Solenoid, Rain RepellentP4-01-0021SMIPower Unit661980-21-6WEDisk759259WEHOUSING, PUMP711150WEHOUSING, PUMP40405-17WEGeroter708023WECover707337AWEPump AssemblyAHQH6428V600 WFCSHalogen695978WERace695990WERace0924801Cover - Switch, Downlatch Ventral Stairs2605750Quick Connector-Lav Wast System700347WEGearshaft, Spur696783WEGear, Spur707334A-A1Scavenge Pump1019-3MIRROR- Aft Lav1019-4MIRROR- Aft Lav708024ATIPump Cover759278ATIPump Housing708025ATIPump Housing4287-17AKILiner, Bearing695803KILiner, Bearing699287-3KILiner, Bearing708511KIBushing699287-1KILiner, Bearing699287-4KILiner, Bearing4287-07AKILiner, Bearing
Back to Douglas DC-9-11