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 AALA20060578Bulb · brokenLGA - EMERGENCY EXIT LIGHT AT SEAT 12D HAS BROKEN LENS AND BEZEL. REPLACED LENS AND BULB FOR EMERGENCY EXIT LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060579Lens · missingLGA - EMERGENCY EXIT LIGHT AT SEAT 19D RED LENS MISSING. REPLACED BEZEL AND RED LENS FOR EMERGENCY EXIT LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060577Shroud · brokenDFW - EMERGENCY LIGHTS AT SEATS 9D AND 12D HAVE BROKEN SHROUDS. REPLACED SHROUDS FOR EMERGENCY LIGHTS AT SEATS 9D AND 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASMF200608013Lock · misinstalledAIRCRAFT RETURNED, RT LANDING GEAR RED LIGHT AND (GEAR DOOR OPEN) LIGHT, REMAINED ON. THEREFORE, ABNORMAL PROCEDURE WAS PERFORMED. DURING MAINTENANCE REVIEW, THE LANDING GEAR LOCK WAS DETECTED INSTALLED BUT WITHOUT THE RED TAPE. THE LANDING GEAR LOCK WAS RESDR AALA20060564Oil Cap · leakingONT - ON TAKEOFF REPORTED SMOKE IN CABIN. RETURNED TO ONT AND LANED WITHOUT INCIDENT. FOUND APU OIL LEAK FROM OIL CAP. REINSTALLED CAP AND COALESCER BAGS ON BOTH PACKS. ACCOMPLISHED PACK BURN AND OVERWEIGHT LANDING INSPECTION. SYSTEM GROUND CHECKED NORMALSDR AALA20060567Pin · brokenLGA - EMERGENCY LIGHTS AT REAR TAIL CATWALK INOPERATIVE. RE-PINNED BROKEN PIN FOR EMERGENCY LIGHTS AT REAR TAIL CATWALK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060559Battery Pack · dischargedLGA - EMERGENCY LIGHTS IN FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS IN FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060557Battery · dirtySFO - TWO EMERGENCY LIGHTS IN AFT CABIN OVERHEAD JUST FORWARD OF AFT AIRSTAIR DOOR INOPERATIVE. CLEANED BATTERY FOR INOPERATIVE EMERGENCY LIGHT IN AFT CABIN OVERHEAD FORWARD OF AFT AIRSTAIR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060560Slide · low pressureDFW - EMERGENCY SLIDE AT AFT GALLEY DOOR HAS LOW PRESSURE. REPLACED AFT GALLEY DOOR EMERGENCY SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060556Strut · unknownNOSE GEAR WOULD NOT RETRACT. RETURNED TO TUL AND LANDED WITHOUT INCIDENT. REPACKED NOSE LANDING GEAR STRUT PER PATTERN CARD 4753. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060550Lens · missingLGA - EMERGENCY LIGHT LENS AT SEAT 24D MISSING. REPLACED MISSING LENS FOR EMERGENCY LIGHT AT SEAT 24D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060546Battery Pack · dischargedLGA - EMERGENCY LIGHT AT AFT OVERWING INOPERATIVE. REPLACED BATTERY PACK AT LOCATION B5105 FOR INOPERATIVE EMERGENCY LIGHT AT AFT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060540Shroud · brokenDFW - SEAT MOUNTED EMERGENCY LIGHT AT SEAT 13D HAS SHROUD BROKEN. REPLACED SEAT MOUNTED EMERGENCY LIGHT SHROUD AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060537Battery · dischargedLGA - EMERGENCY FLASHLIGHT BY FORWARD JUMP SEAT INOPERATIVE. REPLACED BATTERY FOR EMERGENCY FLASHLIGHT BY FORWARD JUMP SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060525Lens · missingSFO - EMERGENCY LIGHT LENS AT STAIRWAY MISSING. REPLACED MISSING LIGHT LENS FOR EMERGENCY LIGHT AT STAIRWAY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060524Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK AT FORWARD GALLEY FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060522Connector · looseSEAT MOUNTED EMERGENCY LIGHT AT SEAT 22D INOPERATIVE. FOUND CONNECTOR UNDER SEAT LOOSE. RECONNECTED AND SECURED SEAT MOUNTED EMERGENCY LIGHT AT SEAT 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060521Engine · contaminatedDCA TO DFW, RIGHT ENGINE OIL CLOG LIGHT ILLUMINATED. INFLIGHT SHUTDOWN. LANDED MEM WITHOUT INCIDENT. REPLACED NUMBER TWO ENGINE DUE TO OIL SYSTEM CONTAMINATION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070023Screw · missingTHE PIN FROM TOP OF AFT PRESSURE BULKHEAD FAILED TO ENGAGE THE ARM. INSTALLED MISSING SCREW.SDR AALA20060571Slide · inoperativeORD - TAIL CONE WAS DEPLOYED WHEN AFT ENTRY DOOR WAS OPENED WHILE DOOR WAS ARMED. SLIDE DID NOT DEPLOY. INSTALLED NEW TAIL COMPARTMENT EMERGENCY EVACUATION SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060500Battery Pack · dischargedDFW - EMERGENCY STANDBY CEILING LIGHTING AT OVERWING INOPERATIVE. REPLACED BATTERY PACK B5104 FOR INOPERATIVE EMERGENCY STANDBY CEILING LIGHTING AT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060496Battery Pack · dischargedLGA - CEILING EMERGENCY EXIT LIGHTS IN COACH CABIN INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 29 FOR CEILING EMERGENCY EXIT LIGHTS IN COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060499Lens · missingDFW - STANDBY CEILING LIGHT LENS MISSING ABOVE AFT FLIGHT ATTENDANT SEAT. REPLACED LIGHT FIXTURE L2671 FOR MISSING CEILING LIGHT ABOVE AFT FLIGHT ATTENDANT SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060498Battery Pack · dischargedLGA - EMERGENCY LIGHTS IN FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 5 FOR INOPERATIVE EMERGENCY LIGHTS IN FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060497Blade · failedSWF - INFLIGHT/27JUL LGA TO ORD AT FLIGHT LEVEL 210, CREW HEARD A LOUD BANG FOLLOWED BY AIRCRAFT YAW. LEFT HAND ENGINE EXHAUST GAS TEMPERATURE ROSE TO 700C WITH ENGINE ROLLBACK. LANDED SWF WITHOUT INCIDENT. FOUND COMPRESSOR BLADE FAILURE. REPLACED NUMBER OSDR AALA20060495Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK AT FORWARD GALLEY FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060492Battery Pack · dischargedLGA CEILING EMERGENCY LIGHTS AT ROWS 29 TO 32 INOPERATIVE. REPLACED BATTERY PACK AT AFT RIGHT HAND LAVATORY FOR CEILING EMERGENCY LIGHTS AT ROWS 29 TO 32. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR FX7A200600005Seal · looseAFTER TAKEOFF, THE A/C DID NOT PRESSURIZE ALL THE EMERGENCY PROCEDURES WERE ACCOMPLISHED AND RETURN. LOG PAGE NR 38667 LINE MTX TROUBLESHOT AND FOUND THAT THE AFT LT GALLEY DOOR SEAL NOT IN THE TRACK, RESEATED THE SEAL, PRESSURIZED THE AIRCRAFT OPS CHECKED NOSDR AALA20060490Battery Pack · dischargedDFW - EMERGENCY OVERHEAD LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. REPLACED BATTERY PACK AND RELAMPED EMERGENCY OVERHEAD LIGHTS FROM ROWS 28 TO 30. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060493Light · brokenDFW - EMERGENCY ESCAPE PATH LIGHTING IN SEAT 10D BROKEN. REPLACED EMERGENCY ESCAPE PATH LIGHT ON SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060489Lens · missingDFW - OVERHEAD EMERGENCY LIGHT LENS COVER MISSING AT ROW 28 AND ONE LENS COVER LOOSE AT ROW 28. REPLACED LENS COVER FOR MISSING LENS AND REPLACED GROMMET AND SECURED LENS COVER FOR LOOSE COVER AT ROW 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060488Lens · missingDFW - EMERGENCY PATH LIGHT LENS COVER MISSING AT SEAT 11D. REPLACED LENS COVER AT SEAT 11D FOR EMERGENCY PATH LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060491Battery Pack · dischargedSFO RT EMERGENCY LIGHTS ABOVE OVERWING DOOR AT ROW 21D INOPERATIVE. REPLACED BATTERY PACK AND RELAMPED RT EMERGENCY LIGHTS ABOVE OVERWING DOOR AT ROW 21D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060487Light · inoperativeDFW EMERGENCY PATH LIGHTING AT SEAT 14D INOPERATIVE. RELAMPED EMERGENCY PATH LIGHTS AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20060486Battery Pack · dischargedLGA OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE OVERWING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20060485Cylinder · defectiveDFW - UNABLE TO RETRACT NOSE GEAR. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR INNER STRUT CYLINDER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060484Battery Pack · dischargedDFW - EXIT EMERGENCY LIGHT AT AFT SERVICE DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHTS AT AFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060482Lens · missingDFW - FORWARD EMERGENCY LIGHT LENS MISSING FROM SEAT 7D. REPLACED MISSING EMERGENCY LIGHT LENS AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060481Wire · damagedDFW - SIDEWALL EMERGENCY EXIT LIGHTS IN AFT STAIRWAY INOPERATIVE. REPAIRED WIRE AT STATION 1462 FOR INOPERATIVE SIDEWALL EMERGENCY EXIT LIGHTS IN AFT STAIRWAY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060483Battery Pack · dischargedEMERGENCY CEILING LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. REPLACED BATTERY PACK IN OVERHEAD BIN ABOVE ROW 29 FOR INOPERATIVE EMERGENCY CEILING LIGHTS FROM ROWS 28 TO 30. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR ASMF200607015Rivet · looseREPORTED A WATER LEAK IN THE OVERHEAD PANEL NEAR TO THE CABIN CREW DOOR. AIRCRAFT WAS SENT TO THE HANGAR AND INTERIORS AND AIR CONDITIONING DUCTS WERE REMOVED, DETECTING 30 RIVETS LOOSEN BETWEEN LONGERONS 1 TO 4, FROM STATION 148 TO 180; IT PROMOTED A PRESSURISDR AALA20060470Battery Pack · inoperativeORD - CEILING EMERGENCY LIGHTS THROUGHOUT CABIN INOPERATIVE. REPLACED BATTERY PACKS B527, B528, B5106, AND B5107 FOR INOPERATIVE CEILING EMERGENCY LIGHTS THROUGHOUT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060461Lamp · inoperativeLGA - EMERGENCY LIGHT AT NUMBER ONE LEFT DOOR INOPERATIVE. REPLACED LAMP AT NUMBER ONE LEFT DOOR FOR INOPERATIVE EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060460Battery Pack · inoperativeLGA - CEILING EMERGENCY LIGHTS AT ROW 20DEF INOPERATIVE. REPLACED BATTERY PACK AT ROW 20DEF FOR CEILING EMERGENCY LIGHTS AT ROW 20DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060457Switch · inoperativeORD - RIGHT HAND ENGINE OIL STRAINER CLOGGING LIGHT ILLUMINATED ABOUT 12 MINUTES INTO FLIGHT. RETARDED THROTTLE LIGHT REMAINED ON. ENGINE SHUT DOWN BY CREW. ENGINE WINDMILLED 20 MINUTES AT 10 POUNDS PER SQUARE INCH. LANDED ORD WITHOUT INCIDENT. AIRCRAFT TSDR AALA20060454Battery Pack · inoperativeORD - EMERGENCY LIGHTS IN AFT CABIN INOPERATIVE. REPLACED BATTERY PACKS AT B527 FOR EMERGENCY LIGHTS IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060455Battery Pack · inoperativeORD - EMERGENCY EXIT LIGHTS AT OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHTS AT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060444Battery Pack · inoperativeLGA - AFT FLOOR PROXIMITY EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AND MODULE FOR AFT FLOOR PROXIMITY EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA060141Seal · crackedCARGO DOOR SEAL DRESSER HAS APPROXIMATELY .250 INCH CRACK, LOCATED AT BOTTOM EDGE OF DOOR CUTOUT AT STATION 674. FABRICATED AND INSTALLED SEAL DEPRESSOR.SDR MWEA060140Support · corrodedCORROSION ON MID CARGO DOOR THRESHOLD PLATE SUPPORT STRUCTURE, LOCATED AT FORWARD, LOWER CORNER OF DOOR CUTOUT. FABRICATED AND INSTALLED STRAP.
Back to Mcdonnell Douglas DC-9-82