Mcdonnell Douglas DC-9-13
PMA parts · 9,394
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-13'])) > 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-13'])) > 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.
34011-180Ashtray4929794-1GBushing - Flanged, Aircraft Towing, NLG20176-560Ashtray30101-046Ashtray30079-046-2Ashtray45008-510Ashtray67012-222Ashtray87305-3GLiner51329-311-1Ashtray10019Hi-Lo TableKT-693206GasketD1775-1ActuatorMEI 199209-1Headrest Pan Model 881 SeatMEI 1442-1FTray Insert Model 940 SeatMEI 74940-40Escutheon LH Lower Model 940 SeatMEI 1441-1FTray Insert Model 940 SeatDEC31-030-503Gear Assembly, Fuel PumpDEC31-030-501Gear Assembly, Fuel PumpDEC31-029-501Gearshaft Assembly - SpurDEC31-026-503Shaft, Drive - Oil PumpDEC31-026-501Shaft, Drive - Oil PumpDEC31-027-505Shaft, Drive, Fuel PumpDEC31-027-501Shaft, Drive, Fuel PumpDEC31-027-503Shaft, Drive, Fuel Pump708494WEGear, Spur695983WEPlug, straight thread0105606-001Lamp module assembly20175-560-1Ashtray20024-560Brake Arm36268-303, 36268-303-1Grill Assembly30032-046Ashtray20025-560Brake Arm43014-169Roller Eccentric9934503-634Light Plate6634503-628Light Plate9934504-549Light Plate9934503-633Light Plate9934504-67Light Plate9934503-640Light Plate9934503-635Light Plate9934503-632Light Plate9934504-65Light Plate9934503-627Light Plate9934503-626Light Plate9934503-625Light Plate9934503-630Light Plate731222EShaft, shouldered696766WEGear, helical378405WEPawlL8602344-1Secondary Heat Exchanger
Back to Mcdonnell Douglas DC-9-13