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 AALA20131126004Stop Fitting · crackedFWD CARGO DOOR, FWD SIDE UPPER STOP PAD FITTING CRACKED. R & R STOP PAD FITTING IAW AARD 51-00-05-1.SDR AALA20131122009Lens · missingEMERGENCY LIGHT AT ROW 26 MISSING LENS COVER. REPLACED EMERGENCY LIGHT LENS COVER AT ROW 26. OPERATIONS CHECKED NORMAL.SDR AALA20131122002Battery Pack · dischargedEMERGENCY EXIT SIGNS WERE AT ROW 21 BOTH SIDES INOPERATIVE. REPLACED BATTERY PACKS FOR EXIT SIGNS. OPERATIONS CHECKED NORMAL.SDR AALA20131121012Skin · gougedGOUGE BELOW LT FWD LAVATORY SERVICE DOOR. FABRICATED & INSTALLED DOUBLER IAW SRM 53-04-05 & EA MD80-53-032568.SDR AALA20131126003Rib · crackedLT WING LE RIB INBD OF NR 4 SLAT TRACK CRACKED AT PULLEY BRACKET MOUNT LOWER AFT LUG. INSTALLED DOUBLER IAW EA MD80-57-032563.SDR AALA20131120013Former · crackedLT HAND WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED INBD FORMER DOUBLER IAW EA MD80-57-032474.SDR AALA20131119022Control Box · inoperativeDFW CREW REPORTED AFTER EXTENDING GEAR RT HAND OTBD ANTI SKID LIGHT ILLUMINATED. FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ANTI SKID CONTROL BOX, SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20131119012Portable Light · failedLT NR 1 DOOR PORTABLE EMERGENCY LIGHT FAILED. REPLACED PORTABLE LIGHT ASSEMBLY. OPERATIONS CHECKED NORMAL.SDR AALA20131119001Battery Pack · dischargedAFT TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK FOR AFT TAIL COMPARTMENT EMERGENCY LIGHTS. OPERATIONS CHECKED NORMALSDR AALA20131116005Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS AT LT NR 1 DOOR INOPERATIVE. REPLACED BATTERY B5-23 AT DROP DOWN PANEL ADJACENT TO FWD LAVATORY. OPERATIONS CHECKED NORMAL.SDR AALA20131115014Schrader Valve · faultyLAX CREW REPORTED NOSE GEAR WOULD NOT RETRACT AFTER TAKEOFF. EMERGENCY DECLARED FLIGHT RETURNED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED SHRAEDER VLV & REPACKED LOWER STRUT PISTON WITH NEW SEALS. SYSTEM GROUND CHECKED NORMAL OPESDR AALA20131112019Valve · leakingLAX CREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED DURING CLIMB-OUT. ACCOMPLISHED QRH & THE LIGHT EXTINGUISHED. EMERGENCY DECLARED FLIGHT RETURNED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. AIRCRAFT FERRIED TO TUL FOR MXSDR AALA20131108008Transducer · inoperativeDFW CREW REPORTED WHEEL NOT TURNING LIGHT ILLUMINATED ON TAKE-OFF ROL. CREW ABORTED TAKE-OFF. LIGHT WENT OUT AFTER ABORT. REPLACED NRS 1, 2 & 3 ANTI SKID TRANSDUCERS ALONG WITH ANTISKID CONTROL BOX. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20131107001Battery Pack · dischargedEMERGENCY LIGHTS OVER TAIL SLIDE INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY PACK FOR TAIL COMPARTMENT EMERGENCY LIGHTS OVER SLIDE. OPERATIONS CHECKED NORMAL.SDR AALA20131105001Wire · pinchedSEAT PATH EMERGENCY LIGHTS WERE INOPERATIVE IN ALL SEAT ROWS. FOUND PINCHED WIRING UNDER THE LAST SEAT ROW. CORRECTED WIRING ISSUES & REPAIRED PINCHED WIRE.SDR AALA20131104002Power Supply · inoperativeFWD CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED POWER SUPPLY B5-23. OPERATIONS CHECKED NORMAL.SDR AALA20131104001Portable Light · inoperativeFWD CABIN PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20131103001Power Supply · inoperativeFORWARD CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED B5-23 EMERGENCY LIGHTS POWER SUPPLY. OPERATIONS CHECKED NORMAL.SDR AALA20131102001Start Valve · failedMCI RT HAND ENGINE START VLV OPEN LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED MCI LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT HAND ENGINE START VLV & STARTER ASSEMBLIES. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20131101004Battery · dischargedAB5-3 EGRESS POWER SUPPLY FAILS DUAL FEEDBACK CHECK. REPLACED BATTERY. OPERATIONS CHECKED NORMAL.SDR AALA20131101003Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 27 TO 31 FAILED. REPLACED BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20131031002Battery Pack · dischargedTAIL EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR TAIL COMPARTMENT EMERGENCY LIGHTS. OPERATIONS CHECKED NORMAL.SDR AALA20131028003Battery Pack · dischargedCOCKPIT EMERGENCY LIGHTS FAILED TEST. REPLACED BATTERY PACK AT FWD DROP CEILING FOR COCKPIT EMERGENCY LIGHTS. OPERATIONS CHECKED NORMALSDR AALA20131026001Proximity Sensor · inoperativeSAT DURING LANDING GEAR EXTENSION, GREEN NLG DOWN LIGHT DID NOT ILLUMINATE. EMERGENCY DECLARED FLIGHT ACCOMPLISHED GO AROUND & LANDED SAT WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NOSE GEAR LOCKED PROXIMITY SENSOR D1-32 & CONNECTOR P1-1157. SDR AALA20131025001Wire · brokenDFW CREW REPORTED NLG & RT MLG HAVE NO INDICATION. EMERGENCY DECLARED FLIGHT EXECUTED GO AROUND & LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND WIRE G200F24 BROKEN AT L2-632. REPAIRED WIRE, SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20131025003Battery Pack · dischargedEMERGENCY LIGHTS AT MID CABIN POSITION FAILED TEST. REPLACED EMERGENCY LIGHT BATTERY PACK AT MID CABIN POSITION. OPERATIONS CHECKED NORMAL.SDR AALA20131024021Fuel Line · crackedPHX INFLIGHT LAX-STL. CENTER FUEL TANK FAILED TO FEED. EMERGENCY DECLARED FLIGHT DIVERTED PHX LANDED WITHOUT INCIDENT. PLACARDED BOTH CENTER FUEL BOOST PUMPS IAW MEL 28-1B. FLIGHT CONTINUED TO DESTINATION. FOUND TWO CRACKED FUEL LINES. REPLACED FUEL PLUMBISDR AALA20131023002Target · faultyPDX LANDING GEAR DOOR LIGHT INDICATION. EMERGENCY DECLARED FLIGHT LANDED PDX WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED DOOR OPEN PROXIMITY SENSOR TARGET & TWO BRACKETS. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20131022010Spring · brokenLT NR 2 DOOR GUST LOCK RETURN SPRING INOPERATIVE. REPLACED LT NR 2 DOOR GUST LOCK SPRING IAW AMM. OPERATIONS CHECKED GOOD.SDR AALA20131021016Stop Fitting · crackedFWD CARGO DOOR, DOORSTOP FITTING CRACKED FORWARD CENTER. REMOVED CRACKED DOORSTOP FITTING & INSTALLED SERVICEABLE DOORSTOP FITTING IAW AARD 51-00-05-1.SDR AALA20131022012Skin · damagedDAMAGE TO FORWARD ENTRY DOOR, EXTERNAL SKIN LOWER EDGE. BLENDED OUT DAMAGE & INSTALLED EXTERNAL DOUBLE IAW AARD 52-10-00-2.SDR AALA20131019002Smoke Detector · faultyLT HAND AFT LAVATORY SMOKE DETECTOR WOULD NOT TEST. INSTALLED NEW SMOKE DETECTOR. OPERATIONS CHECKED NORMAL.SDR AALA20131029003Rib · crackedLT WING NR 4 SLAT TRACK SUPPORT RIB CRACKED. REMOVED CRACKED LUG & HAND BLENDED REAMED TO COMPLETELY REMOVE THE CRACK FROM THE RIB IAW EA MD80-57-032110.SDR AALA20131016014Skin · crackedLT SIDE FUSELAGE CRACKED IN SKIN AT STATION 1437 BETWEEN LONGERONS 3 & 4. INSTALLED DOUBLER IAW EA MD80-53-032059 & SRM 53-04-00.SDR AALA20131022005Rib · crackedRT WING NR 4 SLAT TRACK SUPPORT RIB CRACKED. STOP DRILLED CRACK & INSTALLED SLAT TRACK SUPPORT DOUBLER IAW EA MD80-57-032050.SDR AALA20131015021Pressure Deck · crackedRT WW PRESSURE PANEL IS CRACKED AT THE FUEL DRAIN SHROUD AFT ATTACH ANGLE. REPAIRED PRESSURE DECK IAW AARD 53-30-00-13.SDR AALA20131014002Longeron · crackedLT LONGERON 24 UPPER FLANGE IS CRACKED AT STATION 160. INSTALLED LT 24 LONGERON SPLICE REPAIR AT STATION 160 IAW SRM 53-02-00.SDR AALA20131014011Longeron · crackedLONGERON 24 LT CRACKED AT STATION 160. INSTALLED LONGERON REPAIR AT STATION 160 IAW SRM 53-20-00.SDR AALA20131016001Battery · dischargedAFT SECTION ESCAPE PATH LIGHTING WOULD NOT EXTINGUISH. RECHARGED BATTERIES. OPERATIONS CHECKED NORMAL.SDR AALA20131012003Battery Pack · dischargedOVERWING EXIT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EXIT EMERGENCY LIGHTS. OPERATIONS CHECKED NORMAL.SDR AALA20131008022Casting · crackedLT WING NR 4 SLAT TRACK CASTING INBD SIDE CRACKED. REPAIRED CASTING IAW EA MD80-57-031745.SDR AALA20131007001Casting · crackedRT WING, CRACK ON INBD SIDE OF RIB CASTING INBD OF NR 4 SLAT TRACK. INSTALLED REPAIR FITTING ON NR 4 SLAT TRACK INBD SUPPORT RIB IAW EA MD80-57-031777.SDR AALA20131006013Skin · crackedFUSELAGE SKIN, CRACK AT FASTENER BELOW LONGERON 4 RT & ABOVE LONGERON 3 RT AT STATION 1437. INSTALLED EXTERNAL DOUBLER IAW EA MD80-53-031801.SDR AALA20131005003Bungee Cylinder · brokenDURING GEAR RETRACTION ON TAKEOFF, LT MAIN GEAR RED LIGHT REMAINED ILLUMINATED AS WELL AS THE AMBER GEAR DOOR OPEN LIGHT. EMERGENCY DECLARED FLIGHT RETURNED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED MAIN GEAR BUNGEE CYLINDER THAT SDR AALA20131004007Computer · malfunctionedDFW CREW REPORTED ELECTRICAL SMELL IN THE CABIN & SEVERAL CIRCUIT BREAKERS POPPED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NR 1 DFGC. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20131003015Compressor · stalledBHM CREW REPORTED ON CLIMB OUT, RT HAND ENG ENCOUNTERED 2 SUCCESSIVE COMPRESSOR STALLS. EMERGENCY DECLARED FLIGHT RETURNED BHM LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE FOR REPAIR. REPLACED RT HAND ENGINE AT BHM ON 10/04/2013. SYSTEM GROUND CHSDR AALA20131003003Sense Line · disconnectedDFW CREW REPORTED ON TAKEOFF, BOTH AIR CONDITIONING SUPPLY TEMPERATURE HIGH LIGHTS ILLUMINATED & STAYED ON UNTIL POWER REDUCTION. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LT & RT HAND AUGMENTATION VALVE SENSING LINE SDR AALA20131001003Skin · crackedFS SKIN CRACKED AT FASTENER BS 1309 ABOVE LONGERON 7 LT. INSTALLED DOUBLER IAW EA MD80-53-031001.SDR AALA20131001002Rivet · crackedFOUR EACH RIVETS HAVE CRACK INDICATIONS AT STRINGER 22 LT FROM BS 190 TO 200 BELOW AIRSTAIR CUTOUT. INSTALLED DOUBLER IAW EA MD80-53-031800.SDR AALA20130930016Skin · crackedCRACK AT FASTENER BETWEEN LONGERONS 4 & 5 LT AT BS 1437. INSTALLED REPAIR DOUBLER & FILLER IAW SRM 53-04-00 FIGURE 27 & EA MD80-53-031802.
Back to Mcdonnell Douglas DC-9-82