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 AALA20071930Battery Pack · inoperativeLGA - OVERHEAD EMERGENCY LIGHTS AT SEAT ROWS 23 TO 25 INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 25 FOR OVERHEAD EMERGENCY LIGHTS AT SEAT ROWS 23 TO 25. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071925Lens · missingDFW - EMERGENCY LIGHT AT FIRST CLASS FLOOR OPPOSITE LAVATORY MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT FIRST CLASS FLOOR OPPOSITE LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071916Hose · crackedSTL INFLIGHT T1646/10OCT - ON APPROACH, LOST RIGHT HYDRAULIC PRESSURE AND EXTENDED ALTERNATE GEAR HANDLE. LANDED STL WITHOUT INCIDENT. FOUND GROUND SPOILER DOWN PRESSURE LINE CRACKED AT FLARE AT CONTROL VALVE. REPLACED HOSE. SYSTEM GROUND CHECKED NORMAL OPSDR AALA20071918Strap · brokenLGA - EMERGENCY FLASHLIGHT AT AFT FORWARD POSITION HAS BROKEN STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT FORWARD POSITION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071912Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT 15D NEEDS NEW SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 15D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071906Battery Pack · inoperativeSFO - EMERGENCY LIGHTS AT LEFT AND RIGHT FORWARD EXIT SIGNS AT SEAT ROW 20DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LEFT AND RIGHT FORWARD EXIT SIGNS AT SEAT ROW 20DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071904Tube · leakingDFW INFLIGHT T2485/09OCT ORD TO AUS - NUMBER ONE ENGINE HIGH OIL TEMPERATURE INDICATION. ALL OTHER ENGINE INDICATIONS NORMAL. CREW SHUT DOWN NUMBER ONE ENGINE. DIVERTED TO DFW AND LANDED WITHOUT INCIDENT. SINGLE ENGINE TIME 25 MINUTES. FOUND OIL LEAK FROSDR AALA20071902Reservoir · low pressurePHX INFLIGHT T2435/08OCT - LOST RIGHT HYDRAULIC SYSTEM. RIGHT HYDRAULIC PRESSURE LOW AND RUDDER MANUAL LIGHTS ILLUMINATED. LANDED PHX WITHOUT INCIDENT. LANDED WITH GEAR DOOR EXTENDED. INSPECTED GEAR DOORS WITH NO DAMAGE NOTED. BLED AIR FROM RIGHT HYDRAULISDR AALA20071892Sensor · leakingDFW INFLIGHT T2236/08OCT - TAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED DURING CLIMB. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED WASHER FOR AIR CONDITION HIGH TEMPERATURE SENSOR IN TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071900Lens · brokenLAX - EMERGENCY LIGHT AT SEAT ROW 29D HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 29D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071899Bulb · brokenLAX - EMERGENCY LIGHT AT SEAT ROW 29D BROKEN. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 29D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071898Lens · brokenLAX - EMERGENCY LIGHT AT SEAT ROW 16D HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071897Bulb · brokenLAX - EMERGENCY LIGHT AT SEAT ROW 16D BROKEN. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071879Strap · missingLGA - EMERGENCY FLASHLIGHT AT AFT FLIGHT ATTENDANT SEAT MISSING RETAINING STRAP. REPLACED RETAINING STRAP FOR EMERGENCY FLASHLIGHT AT AFT FLIGHT ATTENDANT SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071875Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 24D HAD BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 24D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071874Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 18D HAD BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071873Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 15D HAD BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 15D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071872Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 10D HAD BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071868Flashlight · crackedLGA - EMERGENCY FLASHLIGHT AT LEFT EMERGENCY DOOR HAS CRACKED CASE. REPLACED EMERGENCY FLASHLIGHT AT LEFT EMERGENCY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071871Light · brokenDFW - EMERGENCY SEAT MOUNTED LIGHT AT SEAT 23D BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY SEAT MOUNTED LIGHT AT SEAT 23D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071870Light · misinstalledDFW - EMERGENCY SEAT MOUNTED LIGHTS AT SEAT ROWS 28DEF AND 29DEF OUT OF CONFIGURATION. CORRECTED CONFIGURATION FOR EMERGENCY SEAT MOUNTED LIGHTS AT SEAT ROWS 28DEF AND 29DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071848Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT TAIL CONE INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20091008TUL10Membrane · crackedSUBFLOOR CRACKED 6.0 INCHES INBOARD OF DOOR FRAME AT STATION 200. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR MWEA070229Battery Pack · inoperativeCABIN CEILING EMERGENCY LIGHTS FROM ROW 8 TO 31 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK.SDR AALA20071824Line · brokenSTL INFLIGHT T1400/28SEP - NR 1 ENGINE FIRE IN FLIGHT. LOST BOTH SYS HYDRAULICS. RETURNED TO STL AND LANDED WITHOUT INJURIES. FIRE TEAM MET FLT UPON LANDING AND FOAMED BOTH ENGINES. PASSENGERS DEPLANED VIA FORWARD LEFT DOOR USING STAIRS. SINGLE ENGINE TIMSDR AALA20071828Placard · tornLGA - AFT EMERGENCY EXIT SLIDE HAD TORN DECAL. REPLACED DECAL FOR AFT EMERGENCY EXIT SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071826Proximity Switch · inoperativeORD INFLIGHT T1101/28SEP - DURING CLIMB CREW RECEIVED STALL THEN SLAT OVERSPEED INDICATION. ON APPROACH ANTI-SKID CIRCUIT BREAKER POPPED. LANDED ORD WITHOUT INCIDENT. REPLACED GROUND PROXIMITY BOX. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071817Placard · missingLGA - EMERGENCY EXIT LIGHT AT OVERHEAD BIN LEFT SEAT ROW 20 MISSING BRAILLE BUMPER. REPLACED BRAILLE BUMPER FOR EMERGENCY EXIT LIGHT AT OVERHEAD BIN LEFT SEAT ROW 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR 070166Shear Tie · damagedAFT CARGO COMPARTMENT SHEAR TIE HAS CORROSION AT STATION 1150 BETWEEN L29R AND L30R. FABRICATED FORMER FROM 7075-T6 .063 AND REPAIR SPLICE FROM 7075-T6 .063 PER SRM 53-03 FIGURE 3.SDR AALA20071815Shroud · missingLAX - EMERGENCY LIGHT AT SEAT 10D MISSING SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071814Bulb · missingLAX - EMERGENCY LIGHT AT SEAT 10D MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071813Lens · missingLAX - EMERGENCY LIGHT AT SEAT 10D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071809Slide · low pressureTPA - FORWARD GALLEY DOOR SLIDE PRESSURE OUT OF RANGE. REPLACED FORWARD GALLEY DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071806Schrader Valve · inoperativeDFW INFLIGHT T744/25SEP - NOSE GEAR WOULD NOT RETRACT. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED SCHRADER VALVE AND ACCOMPLISHED NOSE GEAR STRUT SERVICING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070227Pan · crackedAFT CARGO DOOR CORNER PAN CRACKED AT AFT LOWER SIDE OF DOOR. FABRICATED AND INSTALLED PAN.SDR MWEA070226Pan · crackedMID CARGO COMPARTMENT DOOR AFT EDGE CRACKED JUST BELOW UPLOCK CAM. FABICATED AND INSTALLED PAN.SDR 070159Battery · dischargedIT HAS BEEN REPORTED BY THE FLIGHT CREW THE EMERGENCY EVACUATION LIGHTING SYSTEM HAS BEEN FOUND TO BE DEFECTIVE. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE POWER SUPPLY BATTERY PACK AND MADE ALL REQUIRED CORRECTIONS, AN OPERATIONAL CHECK WAS ASDR AALA20071775Sensor · inoperativeSTL INFLIGHT T755/20SEP ORD TO SAT - RIGHT ENGINE OIL TEMPERATURE FLUCTUATED DURING CLIMB FROM 110 DEGREES TO 130 DEGREES. AT CRUISE THE TEMPERATURE ROSE TO ABOVE 140 DEGREES. DIVERTED TO STL AND LANDED WITHOUT INCIDENT. REPLACED RIGHT ENGINE OIL TEMPERATURSDR AALA20071765Battery Pack · inoperativeLGA - EMERGENCY LIGHTS IN FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK AT OVERHEAD ELECTRIC BAY FOR EMERGENCY LIGHTS IN FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071753Lens · missingORD - EMERGENCY LIGHT AT OVERHEAD FIRST CLASS GALLEY MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071741Lens · missingTPA - EMERGENCY LIGHT AT SEAT ROW 21E MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 21E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071740Compressor · stalledSTL INFLIGHT T1914/13SEP - FLIGHT EXPERIENCED COMPRESSOR STALL AT 800 FEET AND SEVERAL STALLS AT 16000 FEET. ENGINE INSTRUMENT INDICATIONS NORMAL. REDUCED NUMBER TWO ENGINE TO IDLE. RETURNED TO STL AND LANDED WITHOUT INCIDENT. REPLACED NUMBER TWO ENGINE ON SDR AALA20071739Pump · failedORD INFLIGHT T1493/13SEP - AFT CENTER TANK BOOST PUMP CIRCUIT BREAKER POPPED. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED AFT CENTER TANK BOOST PUMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071727Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071709Shroud · brokenDFW - SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 17 HAS BROKEN SHROUD. REPLACED SHROUD FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 17. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071708Shroud · missingDFW - SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 16 MISSING SHROUD. REPLACED SHROUD FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 16. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071693Bulb · inoperativeLGA - EMERGENCY LIGHT ON ANNUNCIATOR PANEL INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT ON ANNUNCIATOR PANEL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071668Battery Pack · looseLGA - EMERGENCY LIGHT AT SEAT ROW 25 INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT ROW 25. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071667Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071663Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK AT OVERHEAD BIN SEAT 25DEF FOR EMERGENCY LIGHTS AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82