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 AALA20070451Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 22 TO 26 INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 26 FOR EMERGENCY LIGHTS AT SEAT ROWS 22 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070448Gearbox · seizedMEM INFLIGHT, AT FLIGHT LEVEL 350 LEFT ENGINE SHUTDOWN. LANDED MEM WITHOUT INCIDENT. FOUND NUMBER ONE ENGINE GEARBOX SEIZED. REPLACED NUMBER ONE ENGINE ON 08 MARCH 2007 AT MEM. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070041Latch · brokenAFT TAIL CONE DOOR ARMING, DISARMING GUARD WILL NOT REMAIN DOWN AND LOCKED ON PLACE. REMOVED AND REPLACED LATCH.SDR AALA20070426Lens · missingSFO - EMERGENCY LIGHT AT SEAT 16D HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070425Bezel · missingSFO - EMERGENCY LIGHT AT SEAT 16D HAS MISSING BEZEL. REPLACED BEZEL FOR EMERGENCY LIGHT AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070424Bulb · missingSFO - EMERGENCY LIGHT AT SEAT 16D HAS MISSING BULB. RELAMPED EMERGENCY LIGHT AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070415Pressure Switch · inoperativeDFW - INFLIGHT ON APPROACH RIGHT ENGINE CLOGGED STRAINER INDICATION ILLUMINATED. CREW PERFORMED IN FLIGHT SHUTDOWN. LANDED DFW WITHOUT INCIDENT. ALL CHECKS NORMAL. INSTALLED NEW FILTER AND OIL FILTER DIFFERENTIAL PRESSURE SWITCH. DRAINED AND REPLENISHED OSDR AALA20070414Strut · damagedYYC - INFLIGHT NOSE LANDING GEAR WOULD NOT RETRACT. RETURNED TO YYC AND LANDED WITHOUT INCIDENT. REPACK NOSE GEAR SHOCK STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070039Skin · gougedGOUGE/DENT IN FUSELAGE SKIN AT FRAME STATION 237 LEFT BETWEEN LONGERON 18 LEFT & LONGERON 17 LEFT. FABRICATED AND INSTALLED FILLER.SDR AALA20070413Battery Pack · inoperativeLGA - EMERGENCY EXIT LIGHT AT RIGHT AFT LOWER OVERWING INOPERATIVE. REPLACED BATTERY PACKS AT BOTH MID AND AFT FOR LOWER OVERWING EMERGENCY EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070404Wire Harness · inoperativeLGA - FOUND EMERGENCY LIGHTS IN AFT STAIRWAY INOPERATIVE. REPLACED SPLICE ON HARNESS FOR EMERGENCY LIGHTS IN AFT STAIRWAY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070038Slide · unserviceableAFT GALLEY SERVICE DOOR EMERGENCY SLIDE GAUGE SHOWS -NO GO-. REMOVED AND REPLACED AFT GALLEY SERVICE DOOR EMERGENCY SLIDE.SDR 070054Structure · ground damageFLIGHT 475 FSD/LAS - DURING THE DE-ICING OPERATION THE EQUIPMENT OPERATOR STRUCK THE AIRPLANE ON THE LEFT ELEVATOR AT THE AFT OUTBOARD CORNER. AMERICAN AIRLINES PERSONNEL REPORT THAT THEY REMOVED AND REPLACED THE LEFT ELEVATOR TRAILING EDGE. REF SRM 55-01-00SDR AALA20070387Fan · inoperativeSDF INFLIGHT - CREW REPORTED SMOKE AND FUMES FROM AIR CONDITIONING PACKS. LANDED SDF WITHOUT INCIDENT. FOUND RECIRCULATION FAN BREAKERS POPPED. REPLACED RECIRCULATION FAN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070391Connector · looseLGA - FOUND EMERGENCY LIGHT AT OVERWING INOPERATIVE. RESEATED CONNECTOR ON POWER SUPPLY FOR EMERGENCY LIGHT AT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070385Door · inoperativeORD INFLIGHT - AFTER TAKEOFF CREW RETRACTED NOSE GEAR AND EXPERIENCE A SEVERE NOSE GEAR DOOR VIBRATION. LOWERED GEAR AND VIBRATION REDUCED. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. FOUND LEFT NOSE GEAR DOORS DOWN. PERFORMED NOSE GEAR DOOR INSPECTION WISDR AALA20070386Schrader Valve · inoperativeLAX INFLIGHT - AFTER TAKEOFF CAPTAIN WAS UNABLE TO RAISE NOSE LANDING GEAR. RETURNED TO LAX AND LANDED WITHOUT INCIDENT. REMOVED PISTON AND INSPECTED. REPLACED STRUT. INSTALLED NEW SCHRADER VALVE AND O-RING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070380Duct · blownTPA INFLIGHT - LEFT FIRE WARNING ACTIVATED AFTER DURING CLIMB. RETURNED TO TPA AND LANDED WITHOUT INCIDENT. FIRE WARNING STOPPED AFTER REDUCING THROTTLE TO IDLE. REPLACED ANTI-ICE DUCT AND UPPER COWLING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070383Oxygen Mask · deployedDFW INFLIGHT - AIRCRAFT EXPERIENCED PRESSURIZATION PROBLEMS DURING CLIMB AND PASSENGER OXYGEN MASKS DEPLOYED. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED ALL PASSENGER OXYGEN MASKS AND OXYGEN GENERATORS REPLACED AS NECESSARY. SYSTEM GROUND CHECKESDR AALA20070381Wire Harness · damagedYUL - EMERGENCY EXIT LIGHT AT SEAT 5EF INOPERATIVE. REPAIRED HARNESS FOR EMERGENCY LIGHT AT SEAT 5EF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070897Shroud · brokenMSP - EMERGENCY AISLE LIGHT AT SEAT 17D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY AISLE LIGHT AT SEAT 17D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070377Battery Pack · inoperativeLGA - FOUND EMERGENCY LIGHT IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK IN FIRST CLASS OVERHEAD PANEL FOR EMERGENCY LIGHTS IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070372Lens · damagedDFW - FOUND EMERGENCY LIGHTS NEAR SEAT 28D DAMAGED BY CART. REPLACED LIGHT LENS, TRIM AND BULBS FOR DAMAGED EMERGENCY LIGHTS NEAR SEAT 28D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070370Oil System · leakingAFTER TAKEOFF, CREW REPORTED SMOKE AND FUMES IN CABIN. LANDED MCI WITHOUT INCIDENT. FOUND AUXILLIARY POWER UNIT (APU) LEAKING OIL AND INGESTING OIL INTO INLET. REPLACED APU ON 27 FEB AT RDU. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA200700015Floorbeam · corrodedCABIN FLOORBEAM CORRODED. REPLACED FLOOR SUPPORT BEAM.SDR AALA20070360Battery Pack · inoperativeDFW - FOUND EMERGENCY EXIT LIGHTS FROM FORWARD CABIN TO SEAT ROW 21 INOPERATIVE. REPLACED BATTERY PACKS AND MODULES AT AB51 AND AB52 FOR EMERGENCY EXIT LIGHTS FROM FORWARD CABIN TO SEAT ROW 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070359Battery Pack · inoperativeDFW - FOUND EMERGENCY SEAT MOUNTED LIGHTS FROM FORWARD CABIN TO SEAT ROW 21 INOPERATIVE. REPLACED BATTERY PACKS AND MODULES AT AB51 AND AB52 FOR EMERGENCY SEAT MOUNTED FROM FORWARD CABIN TO SEAT ROW 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070358Shroud · brokenDFW - FOUND EMERGENCY LIGHT SHROUD AT SEAT 23D BROKEN. REPLACED EMERGENCY LIGHT SHROUD AT SEAT 23D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070362Lens · brokenDFW - EMERGENCY EXIT LIGHT AT AFT LEFT OVERWING HATCH HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY EXIT LIGHT AT AFT LEFT OVERWING HATCH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070361Battery · looseDFW - EMERGENCY LIGHTS AT AFT CABIN CEILING AND TAIL COMPARTMENT LOWER SLIDE FLOOD LIGHT INOPERATIVE. REPOSITIONED BATTERIES IN THE BATTERY PACK CLIPS FOR EMERGENCY LIGHTS IN AFT CABIN CEILING AND TAIL COMPARTMENT LOWER SLIDE FLOOD LIGHT. SYSTEM GROUND CHECKSDR GTIA200700014Floorbeam · corrodedCORROSION ON FLOORBEAM ANGLE. REPLACED FLOORBEAM.SDR GTIA200700013Intercostal · crackedAFT CARGO CABIN FLOOR INTERCOSTAL CRACKED. REPLACED INTERCOSTAL.SDR AALA20070355Strut · leakingORD INFLIGHT - UNABLE TO RETRACT LANDING GEAR. THREE GREEN INDICATION AT ALL TIMES. GEAR HANDLE WOULD NOT MOVE FULL RANGE. LANDED ORD WITHOUT INCIDENT. FOUND NOSE LANDING GEAR STRUT NOT FULLY EXTENDING. REPACKED NOSE LANDING GEAR STRUT. SYSTEM GROUND CHESDR 070043Battery Pack · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK LAS VEGAS, MAINTENANCE REPORTED THAT THE EMERGENCY EXIT OVERHEAD SIGNS WOULD NOT TEST. REPLACED THE BATTERY PACK IN B5-27 POWER SUPPLY. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED PER AMM 33-51-12. THE AIRPLANESDR 070041Display · unknownFLIGHT 715 SFB/LAN - THE FLIGHT CREW REPORTED; DURING TAKEOFF ROLL "F/S FAIL" INTERMITTENTLY APPEARED ON BOTH PRIMARY FLIGHT DISPLAYS. REJECTED TAKEOFF AT 100 KTS. UPON CLEARING THE RUNWAY THE SYSTEM INDICATION RETURNED TO NORMAL. SFB MAINTENANCE REPORT THASDR AALA20070345Seal · dirtyORD INFLIGHT T1349/16FEB - CREW UNABLE TO RETRACT LANDING GEAR. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. CLEANED AND REPLACED SEALS, BEARING PLATE, AND SCHRADER VALVE. SERVICED STRUT WITH NEW FLUID. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070350Battery · dischargedSFO - EMERGENCY FLASHLIGHT AT FORWARD LEFT DOOR INOPERATIVE. REPLACED BATTERY IN EMERGENCY FLASHLIGHT AT FORWARD LEFT DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070343Seal · inoperativeORD INFLIGHT - NOSE GEAR WOULD NOT RETRACT. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED NOSE STRUT SEAL AND SERVICED NOSE STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070035Gyro · failedCAPTAIN'S ATTITUDE INDICATOR FAILED. REMOVED AND REPLACED CAPTAINS FOG GYRO.SDR GTIA200700012Floorbeam · corrodedCORROSION AFT CARGO CABIN FLOORBEAM. INSTALLED NEW FLOORBEAM.SDR GTIA200700011Floorbeam · corrodedCORROSION ON FLOORBEAM. INSTALLED NEW FLOORBEAM.SDR GTIA200700010Floorbeam · corrodedCORROSION AT FWD CABIN FLOOR SUPPORT. INSTALLED NEW FLOOR SUPPORT.SDR GTIA200700009Floor Support · corrodedCORROSION ON FLOOR SUPPORT. REPAIRED FLOOR SUPPORT.SDR AALA20070332Seal · damagedORD INFLIGHT T644/14FEB - COULD NOT RETRACT LANDING GEAR. RED UNSAFE INDICATION. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPACKED NOSE LANDING GEAR STRUT SEALS AND REPLACED LOWER TURNING TUBE BEARING. SERVICED STRUT. SYSTEM GROUND CHECKED NORMAL OPERSDR AALA20070342Battery Pack · inoperativeSFO - EMERGENCY LIGHT AT LOWER FORWARD CORNER OF RIGHT NUMBER ONE DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT LOWER FORWARD CORNER OF RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA200700008Longeron · corrodedAFT CARGO COMPT LONGERON 29R HAS CORROSION. MADE LONGERON REPAIR.SDR AALA20070327Seal · inoperativeIND INFLIGHT T1077 - NOSE GEAR WOULD NOT RETRACT. RED UNSAFE INDICATION REMAINED ILLUMINATED ALONG WITH VIBRATION. RETURNED IND AND LANDED WITHOUT INCIDENT. REPLACED NOSE STRUT SEALS AND SERVICED NOSE STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070311Slide · inoperativeLAS - RAMP SERVICE FOUND SLIDE PACK AT LEFT SERVICE DOOR BROKEN AND ON GROUND. CATERING DROPPED SLIDE WHEN SERVICING AIRCRAFT. SLIDE DID NOT DEPLOY. REPLACED SLIDE FOR LEFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070312Piston · inoperativeORD INFLIGHT T1462/10FEB - ON RETRACTION, NOSE GEAR UNSAFE LIGHT ILLUMINATED. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPACKED NOSE GEAR LOWER PISTON. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070309Lens · brokenLGA - FOUND EMERGENCY LIGHT AT SEAT 5E HAS LENS BROKEN. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 5E. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82