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 AALA20060736Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060732Schrader Valve · inoperativeRDU - AFTER TAKEOFF LANDING GEAR RETRACTED AND RED NOSE GEAR LIGHT STAYED ON. LANDED RDU WITHOUT INCIDENT. INSPECTED NOSE STRUT PISTON. REPLACED NOSE SCHRADER VALVE AND O-RING AND REPACKED NOSE STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060731Oil System · contaminatedDFW - LEFT ENGINE OIL STRAINER CLOG LIGHT ILLUMINATED. LIGHT EXTINGUISHED AFTER REDUCING POWER TO IDLE AND RETURNED TWO MINUTES LATER. CREW SHUT ENGINE DOWN. ENGINE WINDMILLED 18 MINUTES. LANDED DFW WITHOUT INCIDENT. AIRCRAFT TAKEN OUT OF SERVICE FOR EVALSDR ASMF200609008Water Heater · shortedAIRCRAFT RETURNED TO PLATFORM, SMOKE ODOR IN FORWARD GALLEY. CAPTAIN SHUTDOWN ENGINES AND DURING MAINTENANCE CHECK A PIECE OF LOCKWIRE WAS DETECTED IN THE WATER HEATER CIRCUIT BREAKERS, CAUSING A SHORT CIRCUIT. GALLEY, COFFEE MAKERS AND OVENS CIRCUIT BREAKERS SDR AALA20060718Apu · leakingDFW - SMOKE IN CABIN AFTER MAXIMUM POWER TAKEOFF. SMOKE CLEARED UP DURING CLIMB. SMELLED LIKE OIL BURNING. LANDED DFW WITHOUT INCIDENT. FOUND OIL LEAK FROM APU. PERFORMED WORK CARD 21-92-12. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060708Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD DOOR COCKPIT OVERHEAD INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD DOOR COCKPIT OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060695Battery Pack · dischargedLGA - EMERGENCY EXIT LIGHTS AT LEFT AND RIGHT HAND OVERWING AT SEAT ROW 21 INOPERATIVE. RESECURED BATTERY FOR EMERGENCY EXIT LIGHTS AT LEFT AND RIGHT HAND OVERWING AT SEAT ROW 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060696Apu · inoperativeSTL - CREW REPORTED SMOKE IN CABIN. RETURNED TO STL AND LANDED WITHOUT INCIDENT. FOUND APU HAD INGESTED OIL. REPLACED APU ON 16 SEPTEMBER AT DFW. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASMF200609005Connector · dirtyAIRCRAFT RETURNED TO PLATFORM DUE TO DURING TAXING AND AFTER RELEASING PARKING BRAKES, THE 4 ANTI-SKID LIGHTS TURNED ON. AT PLATFORM ANTI-SKID DUAL PRESS CONTROL VALVES CONNECTORS AND SWITCHES S1-130 AND S10-195 WERE CLEANED IAW MM 32-43-05. ANTI-SKID SYSTEM WSDR MWEA060198Attach Angle · damagedTASK 99 ZONE 63, REPLACE DORSAL FIN ATTACHMENT ANGLE. REPLACED DORSAL FIN ATTACHMENT ANGLES.SDR MWEA060197Angle · damagedTASK 99 ZONE 63 REPLACE DORSAL FIN ATTACHMENT ANGLE. REPLACED DORSAL FIN ATTACH ANGLES.SDR AALA20060692Lens · missingDFW - CEILING EMERGENCY LIGHT AT SEAT 5D MISSING LENS. REPLACED LENS FOR CEILING EMERGENCY LIGHT AT SEAT 5D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060694Battery Pack · inoperativeJAX - EMERGENCY LIGHTS IN CABIN INOPERATIVE. EMERGENCY LIGHTS LEFT IN ARMED POSITION. REPLACED ALL CABIN BATTERY PACKS FOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060686Light · missingMSP - EMERGENCY LIGHT AT 18D MISSING SHROUDS, LENS AND BULBS. REPLACED BULBS, SHROUD, AND LENS AT SEAT 18D FOR EMERGENCY AISLE LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060685Lens · missingMSP - EMERGENCY AISLE LIGHT AT SEAT 9D MISSING SHROUD AND LENS. REPLACED SHROUD AND LENS AT SEAT 9D FOR EMERGENCY AISLE LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060687Lens · inoperativeMSP - EMERGENCY AISLE LIGHTS AT SEAT 14D MISSING LENS. REPLACED LENS AT SEAT 14D FOR EMERGENCY AISLE LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060681Lens · brokenDFW - EMERGENCY TAIL CONE HANDLE LIGHT LENS BROKEN. REPLACED TAIL CONE HANDLE EMERGENCY LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060674Lens · missingDFW - EMERGENCY LIGHTS AT SEATS 16D, 17D, AND 28D HAVE MISSING LENS. SEAT 27D HAS WRONG LENS. REPLACED EMERGENCY LIGHT LENS AT 16D, 17D, AND 28D AND REPLACED CORRECT LENS FOR SEAT 27D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060678Battery · dischargedLGA EMERGENCY FLASHLIGHT BY LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED BATTERY FOR EMERGENCY FLASHLIGHT BY LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060675Battery Pack · dischargedDFW - EMERGENCY LIGHTS AT TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS AT TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA060195Skin · dentedFUSELAGE DENT AT STATION 508 TO 520 BETWEEN LONGERON 20R AND 21R. RECONTOURED DENT AREA FABRICATED AND INSTALLED DOUBLERS.SDR MWEA060194Skin · dentedFUSELAGE DENT AT STATION 486 TO 503 BETWEEN LONGERON 20R AND 21R. RECONTOURED DENT AREA.SDR MWEA060193Skin · dentedFUSELAGE DENT AT STATION 449 TO 465 BETWEEN LONGERON 20R AND 21R. RECONTOURED DENT AREA.SDR MWEA060196Frame · bentFORWARD GALLEY DOOR CUTOUT AFT FRAME IS BENT AT FUSELAGE 200. FABRICATED AND INSTALLED FRAME SHIELD.SDR MWEA060181Skin · damagedDAMAGE TO LOWER PASSENGER DOOR SKIN. FABRICATED AND INSTALLED FILLER.SDR MWEA060180Frame · crackedCRACKED FRAME AT 2 EACH RIVETS AT Y 446 LONGERON 5 RIGHT. FABRICATED AND INSTALLED RIVETS.SDR AALA20060662Battery Pack · not seatedSFO - RIGHT AND LEFT AFT OVERWING EMERGENCY EXIT LIGHTS AT SEAT ROW 21B AND 21D INOPERATIVE. RESEATED BATTERY PACK FOR INOPERATIVE RIGHT AND LEFT AFT OVERWING EMERGENCY EXIT LIGHTS AT SEAT ROW 21B AND 21D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060661Light · inoperativeSFO - EMERGENCY LIGHT AT SEATS 12D AND 23D INOPERATIVE. RELAMPED EMERGENCY LIGHTS AT SEATS 12D AND 23D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060655Connector · looseLGA - EMERGENCY PATH LIGHT AT SEAT 3E INOPERATIVE. RESECURED ELECTRICAL CONNECTION AT SEAT 3E FOR INOPERATIVE EMERGENCY PATH LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060658Battery Pack · dischargedLGA - EMERGENCY LIGHT ON CEILING AT LEFT AND RIGHT NUMBER ONE DOORS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT ON CEILING AT LEFT AND RIGHT NUMBER ONE DOORS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060656Battery Pack · dischargedLGA - OVERHEAD EMERGENCY LIGHTS AT FORWARD ENTRY AND FLIGHT DECK INOPERATIVE. REPLACED BATTERY PACK IN FORWARD CABIN FOR INOPERATIVE OVERHEAD EMERGENCY LIGHTS AT FORWARD ENTRY AND FLIGHT DECK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060654Battery Pack · dischargedDFW - RIGHT AND LEFT AFT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR RIGHT AND LEFT AFT EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060650Pump · failedDFW - IAH TO ORD - FUEL WOULD NOT FEED FROM CENTER TANK. LANDED DFW WITHOUT INCIDENT. FOUND AFT CENTER TANK FUEL BOOST PUMP CIRCUIT BREAKER TRIPPED. REPLACED BOTH CENTER FUEL BOOST PUMPS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060646Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT OVERHEAD AND TAIL CONE INOPERATIVE. REPLACED BATTERY PACKS AT AFT RIGHT LAVATORY FOR INOPERATIVE EMERGENCY LIGHTS AT OVERHEAD AND TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA060286Flashlight · inoperativeEMERGENCY LIGHT BESIDE ENTRANCE DOOR INOPERATIVE. REMOVED AND REPLACED FLASH LIGHT.SDR AALA20060640Light · inoperativeDFW - EMERGENCY PATH LIGHT AT SEAT 16D INOPERATIVE. REPLACED EMERGENCY PATH LIGHT ASSEMBLY AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060645Pump · inoperativeDFW - LOSS OF RIGHT HYDRAULIC SYSTEM QUANTITY PRIOR TO LANDING. LANDED DFW WITHOUT INCIDENT. REPLACED MAIN LANDING GEAR TRANSFER CYLINDER AND HYDRAULIC AUXILIARY PUMP AND RIGHT HAND ENGINE DRIVEN HYDRAULIC PUMP AND FILTER. SYSTEM GROUND CHECKED NORMAL OPERASDR AALA20060638Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT FORWARD CEILING INOPERATIVE. REPLACED BATTERY PACK AT B520 FOR INOPERATIVE EMERGENCY LIGHTS AT FORWARD CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060639Battery Pack · dischargedLGA - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060821Battery Pack · dischargedTUL - EMERGENCY LIGHTS AT OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS AT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060613Battery Pack · dischargedDFW - EMERGENCY LIGHTS AT RIGHT NUMBER ONE DOOR EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK AND CHARGER ASSEMBLY FOR EMERGENCY LIGHTS AT RIGHT NUMBER ONE DOOR EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATIONS.SDR AALA20060619Control Panel · inoperativeSTL IN FLIGHT LOST LT AC BUSS AND LT GENERATOR. HAD ASSOCIATED AC CROSS TIE LOCKOUT. LT SIDE WAS NOT PICKED UP BY THE RT SIDE. SERVICED LT CONSTANT SPEED DRIVE TO PROPER LEVEL AND CHANGED LT BUSS CONTROL PANEL. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSEDSDR AALA20060614Light · inoperativeEMERGENCY LIGHTS AT AFT SEAT ROW SEVEN INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHTS AT AFT SEAT ROW SEVEN. SYSTEM GROUND CHECKED NORMAL OPERATIONS. (CLOSED)SDR AALA20060612Light · damagedEMERGENCY LIGHTS AT TAIL CONE HANDLE DAMAGED. REPLACED EMERGENCY TAILCONE HANDLE LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATIONS. (CLOSED)SDR AALA20060607Battery Pack · inoperativeEMERGENCY LIGHTS AT CEILING FROM SEATS 7D TO 11D INOPERATIVE. REPLACED BATTERY PACK AT 8D FOR EMERGENCY LIGHTS AT CEILING FROM SEATS 7D TO 11D. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR FX7A200600007Seal · misriggedAFTER TAKEOFF AND DURING CLIMB WHEN THE CREW NOTICED A PROBLEM ON THE RATE OF CLIMB PRESSURIZATION INDICATOR, THE CREW COULD NOT CONTROL THE PRESSURIZATION, RETURNED TO BASE. PERFORMED RIGGING OF THE AFT SERVICE DOOR IAW MD-80MM 52-42-00 OPS CHECKED GOOD, AIRSDR GTIA200600082Battery · inoperativeEMERGENCY LIGHTS INOP AFT STAIRWELL. REPLACED 2 EA BATTERIES AND 3 EA CATWALK LIGHT ASSEMBLIES.SDR AALA20060599Cylinder · inoperativeINFLIGHT T1107/22AUG CREW REPORTED NOSE GEAR VIBRATION AFTER GEAR RETRACTION THAT INCREASED AS THEY ACCELERATED. LANDED TPA WITHOUT INCIDENT. REPLACED LT AND RT GEAR DOOR CYLINDERS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20060583Battery Pack · inoperativeDTW - EMERGENCY LIGHTS IN FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK AT FORWARD GALLEY FOR INOPERATIVE EMERGENCY LIGHTS IN FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060581Battery · looseSFO - EMERGENCY LIGHTS AFT CABIN AND STAIRWAY INOPERATIVE. RESEATED BATTERIES AND CYCLED POWER FOR EMERGENCY LIGHTS AT AFT CABIN AND STAIRWAY. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82