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 AALA20070701Connector · defectiveLGA EMERGENCY LIGHT AT FLOOR LEVEL AT FIRST CLASS LAVATORY INOPERATIVE. REPLACED CONNECTOR FOR EMERGENCY LIGHT AT FLOOR LEVEL AT FIRST CLASS LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20070700Battery Pack · dischargedLGA EMERGENCY LIGHT AT LEFT AND RIGHT HAND AFT OF WING INOPERATIVE. REPLACED BATTERY PACK FOR LEFT AND RIGHT HAND AFT OF WING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20070694Strut · defectiveORD INFLIGHT T1872/16APR UNABLE TO RETRACT NOSE GEAR. RED LIGHT ILLUMINATED WITH GEAR HANDLE IN UP POSITION ACCOMPANIED BY AIR NOSE. NOSE LANDING HEAR PIN WAS FLUSH. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED AND SERVICED NOSE LANDING GEAR STRUSDR AALA20070692Seal · damagedJFK INFLIGHT T1977/15APR NOSE LANDING GEAR WOULD NOT RETRACT. LANDED JFK WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR STRUT SEALS AND SERVICED NOSE LANDING GEAR. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20070684Switch · inoperativeABQ INFLIGHT T1898/14APR - AFTER TAKEOFF, RIGHT PACK WENT TO ZERO. PRESSURIZATION FLOW INDICATION ILLUMINATED AND AIRCRAFT LOST PRESSURE. MASKS DID NOT DROP. RETURNED TO ABQ AND LANDED WITHOUT INCIDENT. LEFT PACK WAS ON PLACARD. AFTER LANDING RIGHT PACK SDR AALA20070686Lens · missingMSP - EMERGENCY LIGHT AT SEAT ROW 22 MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 22. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070685Bulb · missingMSP - EMERGENCY LIGHT AT SEAT ROW 22 MISSING LAMP. RELAMPED EMERGENCY LIGHT AT SEAT ROW 22. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070687Battery Pack · inoperativeMSP - CEILING EMERGENCY LIGHTS AT SEAT ROWS 25 AND 26 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS AT SEAT ROWS 25 AND 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070679Turbine Blades · failedSTL INFLIGHT T2303/13APR - ORD - DFW DURING CRUISE AT FLIGHT LEVEL 320, CREW HEARD LOUD BANG AND FELT A YAW. INDICATIONS SHOWED THE LEFT ENGINE SHUTDOWN. LANDED STL WITHOUT INCIDENT. SINGLE ENGINE TIME APPROXIMATELY 15 MINUTES. REPLACED LEFT ENGINE ON 15 SDR MWEA070095Lanyard · brokenAFT GALLEY GIRT BAR CABLE BROKEN. REMOVED AND REPLACED AFT GALLEY GIRT LANYARD.SDR MWEA070094Girt Bar · stuckFLIGHT ATTENDANT UNABLE TO DISARM GIRT BAR AT AFT GALLEY DOOR. DISARMED AFT GALLEY SLIDE.SDR AALA20070623Bumper Block · missingLGA - OVERHEAD EMERGENCY EXIT LIGHT AT SEAT ROW 21 RIGHT HAS MISSING BUMPER. REPLACED BUMPER FOR OVERHEAD EMERGENCY EXIT LIGHT AT SEAT ROW 21 RIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070622Bumper Block · missingLGA - OVERHEAD EMERGENCY EXIT LIGHT AT SEAT ROW 20 HAS MISSING BUMPER. REPLACED BUMPER FOR OVERHEAD EMERGENCY EXIT LIGHT AT SEAT ROW 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070624Strap · brokenLGA - EMERGENCY AFT FLASHLIGHT HAS BROKEN STRAP. REPLACED STRAP FOR EMERGENCY AFT FLASHLIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070615Battery Pack · dischargedLGA - EMERGENCY LIGHT AT SEAT ROW 25 INOPERATIVE. REPLACED BATTERY PACK AT OVERHEAD BIN FOR EMERGENCY LIGHT AT SEAT ROW 25. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070612Battery Pack · dischargedLGA - EMERGENCY LIGHT AT OVERHEAD COCKPIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070613Valve · faultyYYC - NOSE GEAR WOULD NOT RETRACT AFTER TAKEOFF. RETURNED TO YYC AND LANDED WITHOUT INCIDENT. SERVICED NOSE GEAR STRUT WITH NITROGEN AND REPLACED VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR 070089Pitot Line · disconnectedFLIGHT 707 SFB/DSM. THE FLIGHT CREW REPORTED THE LOSS OF CAPT'S ALTIMETER, MACH/AIRSPEED INDICATOR, EPR BUGS AND AUTO THROTTLE. 'NO MODE DISPLAY ON THRUST RATING PANEL. THE FLIGHT RETURNED WHERE IT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPORT THAT TSDR MWEA070078Shear Tie · damagedSHEAR CLIP DAMAGE FROM DRILL MARK. FABRICATED AND INSTALLED SHEAR TIE.SDR AALA20070803Slide · looseMEX - EMERGENCY SLIDE AT AFT GALLEY DOOR LOOSE. REPOSITIONED EMERGENCY SLIDE AT AFT GALLEY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070604Battery Pack · dischargedLGA - EMERGENCY LIGHT AT FORWARD OVERHEAD MAIN ENTRY DOOR INOPERATIVE. REPLACED BATTERY PACK AT FORWARD OVERHEAD PANEL FOR INOPERATIVE EMERGENCY LIGHT AT FORWARD OVERHEAD MAIN ENTRY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070599Light · brokenMSP - EMERGENCY LIGHT AT FIRST CLASS GALLEY WALL BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY AT FORWARD FIRST CLASS GALLEY WALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070075Skin · dentedDENT IN FUSELAGE SKIN AT FRAME STATION 214 JUST ABOVE LONGERON 15 RIGHT. [SUP 4/13/07] FABRICATED AND INSTALLED DOUBLER.SDR MWEA070077Skin · dentedEVIDENCE OF SKIN DENTED AT STATION 541 BETWEEN LONGERERON 26 AND LONGERON 27. FABRICATED AND INSTALLED FILLER.SDR MWEA070076Skin · dentedLONGERON 27 AT STATION 636 EVIDENCE OF SKIN DENTED. FABRICATED AND INSTALLED DOUBLER.SDR AALA20070575Control Valve · inoperativePRESSURIZATION FLOW LIGHT ILLUMINATED DURING FLIGHT. CABIN ALTITUDE SLOWLY INCREASED FROM 4 TO 6.0 AT FLIGHT LEVEL 250. DECLARED EMERGENCY AND LANDED DFW WITHOUT INCIDENT. REPLACED FLOW CONTROL VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070571Controller · inoperativeCABIN PRESSURE ROSE AT FLIGHT LEVEL 340 AND CABIN MASKS AUTO DEPLOYED AT FLIGHT LEVEL 140. EMERGENCY DESCENT TO 10000. AFTER LEVEL AT 10000 PACK FLOW RETURNED AND BOTH PRESSURIZATION CONTROLLERS RESET. FAILURE OCCURRED JUST AFTER EXITING ICING CONDITIONS ASDR AALA20070569Battery Pack · inoperativeLGA - EMERGENCY EGRESS LIGHT AT RIGHT NUMBER ONE DOOR INOPERATIVE. REPLACED FORWARD EGRESS BATTERY PACK FOR EMERGENCY EGRESS LIGHT AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070568Battery Pack · inoperativeLGA - EMERGENCY EXIT LIGHT AT RIGHT NUMBER ONE DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHT AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070566Battery Pack · inoperativeSFO - EMERGENCY LIGHT AT OVERWING EXIT AT SEAT ROW 21 LEFT AND RIGHT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERWING EXIT AT SEAT ROW 21 LEFT AND RIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070563Engine · stalledAT FLIGHT LEVEL 240, RIGHT ENGINE COMPRESSOR STALLED. ENGINE GAS TEMPERATURE ROSE TO 750. UNCOMMANDED ENGINE SHUTDOWN. DUE TO INABILITY TO MAINTAIN RUDDER CONTROL MISSED APPROACH. WAS UNABLE TO CONTROL RUDDER UNTIL POWER PULL BACK ALL THE WAY. LANDED WITSDR AALA20070561Coffeemaker · smokeACRID ODOR THROUGH AIR CONDITIONING SYSTEM AND SMOKE REPORTED IN CABIN BY FLIGHT ATTENDANT, PASSENGERS, AND DEADHEADING CREW DURING CLIMB-OUT. CREW TURNED OFF GALLEY POWER AND SMOKE DISSIPATED AT FLIGHT LEVEL 050. FLIGHT CONTINUED TO DFW AND LANDED WITHOUT ISDR AALA20070554Pump · inoperativePASSING FLIGHT LEVEL 200, FOUND FUEL BURNING OUT OF THE MAIN TANKS AND THE CENTER TANK WAS INCREASING. FLIGHT LANDED DFW WITHOUT INCIDENT. REPLACED BOTH CENTER BOOST PUMPS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070556Battery Pack · inoperativeLGA - OVERHEAD EMERGENCY LIGHTS IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070543Gearbox · inoperativeAFTER TAKEOFF FLIGHT ATTENDANT REPORTED HEARING LOUD POP FOLLOWED BY A MODERATE VIBRATION. ALL INSTRUMENTS APPEARED NORMAL. AT FLIGHT LEVEL 290 RIGHT ENGINE OIL STRAINER CLOG LIGHT ILLUMINATED. CREW SHUT DOWN RIGHT ENGINE AND LANDED DFW WITHOUT INCIDENT. RSDR AALA20070538Indication Sys · inoperativeRIGHT ENGINE OIL STRAINER CLOG LIGHT ILLUMINATED AT FLIGHT LEVEL 370. LIGHT STAYED ON AT IDLE. CREW SHUT DOWN RIGHT HAND ENGINE. ENGINE WINDMILLED FOR 27 MINUTES WITH NORMAL OIL PRESSURE AND QUANTITY. RETURNED TO TPA AND LANDED WITHOUT INCIDENT. REPLACED SDR AALA20070532Strap · brokenLGA - AFT FORWARD EMERGENCY FLASHLIGHT STRAP BROKEN. REPLACED STRAP FOR AFT FORWARD EMERGENCY FLASHLIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070519Light · missingORD - EMERGENCY EXIT LIGHT AT FORWARD GALLEY WALL FLOOR MISSING. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT FORWARD GALLEY WALL FLOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070515Light · brokenMSP - EMERGENCY EXIT ARROW LIGHT AT AISLE OUTSIDE OF FORWARD LAVATORY BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY EXIT ARROW LIGHT AT AISLE OUTSIDE OF FORWARD LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071791Slide · failedFLL - RIGHT NUMBER ONE DOOR SLIDE FELL TO RAMP WHEN DOOR OPENED BY CATERING. SLIDE WAS NOT ARMED. FOUND DEFECTIVE CLIPS THAT HOLD CHUTE INSIDE DOOR. SLIDE FELL OFF DOOR AND LANDED INTACT. DID NOT DEPLOY. PRESSURE INDICATOR IS DAMAGED AND UNREADABLE. REPLSDR AALA20070504Battery Pack · inoperativeLGA - EMERGENCY EXIT SIGNS AT OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT SIGNS AT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070502Handle · pulledMCO - LANDING GEAR WOULD NOT RETRACT. RETURNED TO MCO AND LANDED WITHOUT INCIDENT. FOUND MAIN LANDING GEAR DOOR BYPASS LEVER PULLED. STOWED HANDLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070501Light · brokenDEN - SEAT MOUNTED EMERGENCY LIGHTS BY GALLEY CART BROKEN. REPLACED LIGHT ASSEMBLY FOR SEAT MOUNTED EMERGENCY LIGHTS BY GALLEY CART. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070043Ground Wire · inoperativeOVERHEAD EMERGENCY LIGHT, ROW 9 IS INOPERATIVE. REPAIRED GROUND WIRE AT LIGHT SOCKET.SDR AALA20070497Controller · inoperativeDFW TO ATL DIVERTED TO LIT DUE TO PRESSURIZATION LOSS AT 29000 FEET. DEPLOYED OXYGEN MASKS. PRESSURIZATION RETURNED AT 20000 BUT DIVERTED TO LIT DUE TO DEPLETED PASSENGER OXYGEN. LANDED LIT WITHOUT INCIDENT. REPLACED BOTH NUMBER ONE AND NUMBER TWO PRESSURSDR AALA20070471Oil System · low pressureORD INFLIGHT - LEFT ENGINE LOW OIL PRESSURE LIGHT ILLUMINATED FOLLOWED BY OIL QUANTITY DEGRADING. CREW SHUTDOWN ENGINE. NO HIGH OIL TEMPERATURES OR ENGINE GAS TEMPERATURES OBSERVED. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. SINGLE ENGINE TIME APPROXIMATSDR AALA20070465Duct · damagedDFW INFLIGHT - DURING CLIMB, LEFT ENGINE FIRE LOOP ILLUMINATED. AFTER ACCOMPLISHING CHECKLIST THE FIRE LOOP WARNING EXTINGUISHED. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED LEFT ENGINE ANTI ICE BLEED LINE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070462Gearbox · leakingDFW TO GDL, DURING CRUISE RIGHT ENGINE OIL QUANTITY WENT FROM 12 QUARTS TO 4 QUARTS IN TWO HOURS. OIL PRESSURE AND TEMPERATURE NORMAL. CREW SHUTDOWN RIGHT ENGINE AND LANDED MTY WITHOUT INCIDENT. FOUND NUMBER TWO GEARBOX LEAKING OIL. REPLACED NUMBER TWO GEASDR AALA20070455Engine · leakingTPA INFLIGHT - RSW TO DFW, DURING CRUISE RIGHT ENGINE OIL QUANTITY AND PRESSURE DROPPED. CREW PERFORMED RIGHT ENGINE SHUTDOWN AND DIVERTED TO TPA. LANDED WITHOUT INCIDENT. SINGLE ENGINE TIME 15 MINUTES. FOUND RIGHT ENGINE LEAKING OIL. PERFORMED FLIGHT DASDR AALA20070454Lens · missingLGA - EMERGENCY ESCAPE PATH LIGHT IN CABIN HAS LENS MISSING. REPLACED LENS FOR EMERGENCY ESCAPE PATH LIGHT IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82