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.
40495WDBearing, Ball, Annular358713-1WDBearing, Ball, AnnularA022310WDBall, Spherical3606229-1WDBearing, Ball, Annular3614920-1WDBearing, Ball, AnnularAHQH6428V600WFCSHalogen LampAHQH6428V600 WFCSHalogen LampDEC38-030-001Shaft ShoulderDEC38-030-003Pin, RetainingDEC38-030-501Worm Shaft AssemblyDEC38-030-002Gear, WormAE980-5435-3Hub Assembly-Detent, Pedal Adjust10321A-3Capacitor AssemblyMEC-1210-1Hydraulic Pump installation Kit7934123-517Conduit Assembly3934165-513Wire AssemblyA1107VYYMarker-Thrust etc.A1150VYYMarker-Interphone etc.A1084VBWLMarker-Controls etc.A1140VYYMarker-Apu etc.A1123VYYMarker-Sump etc.A1112VYYMarker-Warning etc.A1076CEBMarker-Aiu etc.A1125VYYMarker-Oxygen etc.A1143VYYMarker-Caution etc.A1137VYYMarker-Push etc.A1117VYYMarker-Fire etc.A1113VYYMarker-Exit etc.A1134VYYMarker-Push etc.A1154VYYMarker-Dripstick etc.A1108VYYMarker-Starter etc.A1163VYYMarker-Cabin etc.A1172MBSMarker-Los etc.A1148VYYMarker-Service etc.A1129VYYMarker-Handle etc.A1130VYYMarker-Fuel etc.A1136VYYMarker-Open etc.A1121VYYMarker-Jackpoint etc.A1153VYYMarker-Arrow etc.A1096MSBMarker-Coffee etc.A1157VYYMarker-Stairwell etc.A1152VYYMarker-Push etc.A1122VYYMarker-Lav etc.A1165VYYMarker-Auxiliary etc.A1169PRGMarker-Cualquier etc.A1167VYYMarker-Captain etc.A1155VYYMarker-Stair etc.A1132VYYMarker-Static etc.A1102VYYMarker-Fire etc.A0916VBWMarker-Caution etc.
Back to Douglas DC-9-11