Mcdonnell Douglas DC-9-82
Service difficulty reports · 23,866
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'DC982' ORDER BY difficulty_date 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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'DC982' ORDER BY difficulty_date DESC
Run 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.
SDR WX0A071057Regulator Valve · faultyAFTER TAKEOFF F/A NOTIFIED FLIGHT CREW OF SMOKE IN THE CABIN. ALL SYSTEM AND INDICATION NORMAL, BOTH TEMP PACK GAUGES WERE BOTH INDICATING AT THE 2 O`CLOCK POSITION. AFTER 10 MINUTES, SMOKE CLEARED. MAINTENANCE DEPARTMENT PERSONNEL TROUBLESHOT TO THE RIGHT SDR AALA20120103DFW01Probe · leakingDFW - CREW REPORTED RIGHT THROTTLE 3 KNOBS FORWARD OF LEFT WITH EPR MATCHED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED PT2 ON RIGHT ENGINE THAT WAS LEAKING. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120102ORD01Warning System · malfunctionedCREW REPORTED SLAT DISAGREE INDICATION. FLIGHT RETURNED AND LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED PROXIMITY BOX AS A PRECAUTION. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120103DFW02Wire · damagedEGRESS LIGHT WILL NOT COME ON IN FORWARD CABIN. REPAIR DAMAGED WIRE AT SEAT ROW 18DEF.SDR AALA20111231DFW01Light · brokenFORWARD GALLEY INBOARD FLOOR LEVEL EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. REPLACED LIGHT ASSEMBLY AT FORWARD GALLEY WALL. OPS CHECK NORMAL.SDR RYNA2011123000023Wire Harness · defectiveAIR TURNBACK - CENTER FUEL PUMP CIRCUIT BREAKER POPPED AND CREW WAS UNABLE TO GET FUEL OUT OF THE CENTER TANK. TROUBLESHOT AND FOUND DEFECTIVE FUEL HARNESS. IN TANK WORK IN PROGRESS TO REPLACE HARNESS. SUPPLEMENTAL REPORT TO FOLLOW UPON COMPLETION AND OPERSDR AALA20111230LGA02Battery Pack · dischargedRIGHT AND CENTER CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. REPLACED RIGHT AFT LAVATORY FORWARD BATTERY PACK. OPS CHECK NORMAL.SDR AALA20111230LGA01Portable Light · inoperativeLEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED LEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111228TUL01Doubler · damagedCOUNTERSINK FASTENER HOLE ON VERTICAL STABILIZER, STATION ZFS=52 LEFT LOWER DOUBLER AREA HAS DIVOT ON OUTER CIRCUMFERENCE OF COUNTERSINK. INSTALLED DOUBLER REPAIR PER SRM 55-03-00 FIGURE 31.SDR AALA20111226STL01Warning System · activatedCREW REPORTED TAIL COMPARTMENT HIGH LIGHT FLICKERED THEN CAME ON STEADY DURING CLIMBOUT. LIGHT EXTINGUISHED WITH REDUCED POWER. EMERGENCY DECLARED FLIGHT RETURNED AND LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM.SDR AALA20111224TUL01Generator · failedRNO - CREW REPORTED RIGHT GENERATOR FAILED AND AUXILIARY POWER UNIT FAILED TO PICK UP LOAD. EMERGENCY DECLARED FLIGHT RETURNED RNO LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT ENGINE CONSTANT SPEED DRIVE AND GENERATOR. SYSTEM GROUSDR WX0A071044Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR WX0A071043Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20111224LGA01Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. RESEATED EMERGENCY LIGHT BATTERIES FOR LIGHTS FROM ROWS 28 TO 30. OPS CHECK NORMAL.SDR WX0A071055Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20111222LGA02Battery Pack · dischargedCEILING EMERGENCY LIGHTS FROM ROWS 18 TO 20 INOPERATIVE. REPLACED BATTERY PACK AT ROW 20. OPS CHECK NORMAL.SDR AALA20111222TUL08Cusp Web · damagedSTATIONS 826 TO 845, 5/16 INCH GAP BETWEEN NUMBER 1 SEAT TRACK AND CUSP. INSTALLED NEW LEFT CUSP SHEET FROM STATIONS 807 TO 845 PER AARD 51-10-00-5.SDR AALA20111221TUL01Tee Fitting · damagedAT APPROXIMATE STATION 836, LEFT CUSP TEE HORIZONTAL FLANGE BENT AT CUSP SHEET TO CUSP TEE FASTENER HOLE. INSTALLED NEW SECTION OF LEFT CUSP TEE STATIONS 826 TO 845 AARD 51-10-00-5.SDR AALA20111220TUL01Frame · cracked1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00.SDR WX0A071054Power Supply · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE POWER SUPPLY BATTERY PACK AND MADE ASDR AALA20111219TUL06Shear Tie · crackedRIGHT SIDE SHEAR TIE IS CRACKED FORWARD SIDE OF FRAME 1380 ABOVE LONGERON 14 RIGHT. INSTALLED DOUBLER ON SHEAR TIE AT STATION 1380 LONGERON 14 RIGHT PER AARD 53-10-00-20.SDR AALA20111219TUL05Longeron · crackedOUTBOARD SIDE OF LONGERON IS CRACKED AT STATION 160 LONGERON 2 LEFT. REPAIRED LONGERON PER SRM 53-02-00 FIGURE 18.SDR AALA20111219TUL04Mount · corrodedGALLEY MOUNT CORROSION AT STATION 160 RIGHT BUTTLINE 11. REPLACED MOUNT PER AARD 51-10-00-5.SDR AALA20111219TUL01Beam · corrodedAFT CARGO, LOWER DOOR BEAM VERTICAL AND HORIZONTAL LEG HAS CORROSION, STATIONS 1155 TO 1212. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR AS PER AARD 53-10-00-3.SDR WX0A071053Power Supply · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE POWER SUPPLY BATTERY PACK AND MADE ASDR WX0A071052Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20111218TUL12Cusp Web · corrodedCUSP SHEET ON LEFT AROUND STATION 840 IS CORRODED. REPAIRED CUSP PER AARD 53-20-00-16.SDR AALA20111218TUL11Cusp Web · corrodedCORROSION ON CUSP UNDER NUMBER 6 SEAT TRACK AT STATION 256. REPAIRED CUSP PER AARD 53-20-00-16.SDR AALA20111218TUL10Cusp Web · corrodedCORROSION ON CUSP UNDER NUMBER 6 SEAT TRACK AT STATIONS 237 TO 242. REPAIRED CUSP PER AARD 53-20-00-16.SDR AALA20111218TUL09Seat Track · corrodedNUMBER 6 SEAT TRACK CORRODED AT STATIONS 214 TO 227. REPAIRED SEAT TRACK PER SRM 53-05-00 FIGURE 4F.SDR AALA20111218TUL08Mount · corrodedFORWARD OUTBOARD G2 GALLEY MOUNT CORRODED AT STATION 215 RIGHT BUTTLINE 56. INSTALLED NEW MOUNT PER AARD 51-10-00-5.SDR AALA20111218TUL07Membrane · damagedFORWARD LEFT SUBFLOOR HAS DAMAGED HOLES BELOW FLOORBOARD SUPPORT STATIONS 162 TO 196 LEFT BUTTLINE 55. REPAIRED SUBFLOOR PER AARD 53-20-00-16.SDR AALA20111218TUL06Intercostal · crackedINTERCOSTAL BETWEEN LONGERONS 28 AND 27 RIGHT AT STATIONS 237 TO 218 IS CRACKED. INSTALLED NEW INTERCOSTAL PER AARD 51-10-00-5.SDR AALA20111218TUL05Cusp Web · damagedRIGHT CUSP AT STATION 163 RIGHT BUTTLINE 12 DAMAGED. REPAIRED CUSP PER AARD 53-20-00-16.SDR AALA20111218TUL04Tee Fitting · corrodedCORROSION ON CUSP TEE STATION 200, INBOARD OF FORWARD SERVICE DOOR. REPAIRED CUSP TEE PER AARD 53-20-00-14.SDR AALA20111218TUL03Membrane · corrodedCORROSION ON SUB-FLOOR AT STATION 199, 4 INCHES INBOARD OF FORWARD SERVICE DOOR JAMB. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-14.SDR AALA20111218TUL02Membrane · corrodedCORROSION ON SUB-FLOOR AT STATION 200, 2 INCHES INBOARD OF FORWARD SERVICE DOOR JAMB. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-14.SDR AALA20111218TUL01Mount · corrodedGALLEY MOUNT HAS CORROSION AT STATION 160 RIGHT BUTTLINE 11. INSTALLED NEW MOUNT PER AARD 51-10-00-5.SDR WX0A071042Power Supply · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE POWER SUPPLY BATTERY PACK AND MADE ASDR AALA20111217TUL06Membrane · corrodedCORROSION ON SUBFLOOR UNDER G-1 GALLEY DRAIN PAN. INSTALLED DOUBLER ON SUBFLOOR UNDER G-1 GALLEY DRAIN PAN PER AARD 53-20-00-16.SDR AALA20111222TUL07Battery Pack · dischargedEMERGENCY LIGHTS IN FIRST CLASS AND HALF OF COACH CAME ON AFTER ENGINE START. REPLACED BATTERY PACK AND MODULE AT ROW 20DEF. OPS CHECK NORMAL.SDR AALA20111217DFW02Battery Pack · dischargedEMERGENCY LIGHTS IN FIRST CLASS AND HALF OF COACH CAME ON AFTER ENGINE START. REPLACED THE FORWARD EPM BATTERY PACK AND MODULE. OPS CHECK NORMAL.SDR AALA20111217TUL03Membrane · corrodedCORROSION ON SUBFLOOR AT G-2 GALLEY AFT INBD FLOOR TIEDOWN FITTING AT STATION 216. INSTALLED SUB-FLOOR DOUBLER PER AARD 53-20-00-16.SDR AALA20111217TUL02Tie Down · corrodedCORROSION ON G-2 GALLEY AFT INBD FLOOR TIEDOWN FITTING AT STATION 216. INSTALLED UPPER G-2 GALLEY MOUNT PER AARD 51-10-00-5.SDR AALA20111216TUL11Cusp Web · crackedCRACK ON LEFT CUSP AT STATION 220 AT LIGHTENING HOLE EXTENDING INBOARD. INSTALLED NEW LEFT CUSP FROM STATIONS 218 TO 237 PER AARD 51-10-00-5.SDR AALA20111216TUL10Cusp Web · corrodedCABIN HAS BULGE IN RIGHT CUSP AT STATION 1308. INSTALLED NEW RIGHT CUSP SHEET STATIONS 1250 TO 1309 PER AARD 51-10-00-5.SDR AALA20111216TUL04Track · corrodedAFT CARGO CORROSION ON LEFT TIE DOWN TRACK FROM STATIONS 1174 TO 1212. INSTALLED NEW TRACK PER AARD 51-10-00-5.SDR AALA20111216TUL03Track · corrodedCORROSION ON LEFT TIE DOWN TRACK FROM STATIONS 1250 TO 1287. INSTALLED NEW TRACK PER AARD 51-10-00-5.SDR AALA20111216LGA02Light · inoperativeLEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT WILL NOT ILLUMINATE. REPLACED EMERGENCY LIGHT ASSEMBLY, OPS CHECK NORMAL.SDR AALA20111216LGA01Battery Pack · dischargedCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. REPLACED BATTERY POWER SUPPLY AT 29DEF, OPS CHECK NORMAL.
Back to Mcdonnell Douglas DC-9-82