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.
4919185-1GBanjo Fitting-Main Landing GearS3NPPBearing106010Switch - Flap HandleGB-44BearingG40263409AshtrayS15734Seal95200-784Elect Conduit Assembly95200-518Elect Conduit Assembly95200-585Elect Conduit Assembly95200-640Elect Conduit Assembly95200-765Elect Conduit Assembly95200-637Elect Conduit Assembly95200-766Elect Conduit Assembly95200-524Elect Conduit Assembly10258-00Heavy Duty Plain Bushing HDB Series (PBA-5)IT-5008HoseIT-5094HoseNLI16870 DWG.: NLI 7079, Rev.-.Dated 4/4/90 Or Later FAA Approved RevisionLampIT-5022HoseIT-5020HoseIT-5021HoseNLI11631 DWG.: NLI4174, Rev. A, Dated 6/18/90 Or Later FAA Approved RevisionLampIT-5090Hose9527Valve Assembly, Waste System Drain303225RCF Seal 3.25" Series,303100RCF Seal 1" Series303275RCF Seal 3.75" Series9008D09-3Power Relay2101140-1Controller2101140-2Controller3-5619-5-72-6Hose713606-1Sleeve09614-1Lavatory Oxygen Doors09614-1 and 09614-2Lavatory Oxygen Doors1041-4G,-5G,-6G,-8G,-10G,-12G, 16G,-20G,-24G,-28G, -32G,-40GCoupling Assembly, MS33658 Hose End,7-44479-3Fuel shut off control2520-0154-05/-07Controller Rack Assembly22270-1, 22270-2, 22270-3, 22270-4Valve28470-3Valve Assembly42D230Valve, Ram Air Vent2520-0024-05Controller Rack Assembly2510-0051-07Warming Oven2510-0066-01Oven2510-0065Oven41C989Actuator, Radio Valve600-0108-5/-7Controller28470-2Valve Assembly561349Switch Auxiliary Trim103-2200Switch, Emergency Power306-5300Switch, Trim
Back to Douglas DC-9-11