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 GTIA040742Bearing · failedFLT 380 - LT MAIN GEAR UNSAFE LIGHT REMAINED ON AFTER RETRACTION. GEAR RECYLE SATISFACTORY. REPLACED BEARING ON LEFT TORQUE TUBE VERIFIED PROPER RIGGING. PERFORMED MULTIPLE GEAR SWINGS CHECKS GOOD. (M)SDR AALA20040880Battery Pack · inoperativeSEA - CEILING EMERGENCY LIGHT IN TAIL INOPERATIVE. REPLACED BATTERY PACK AT B528 FOR CEILING EMERGENCY LIGHT IN TAIL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040878Battery Pack · inoperativeAUS - EMERGENCY LIGHTS IN TAIL CONE INOPERATIVE. REPLACED BATTERY PACK IN AFT RIGHT LAVATORY FOR EMERGENCY LIGHTS IN TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040877Battery Pack · inoperativeRDU - CEILING EMERGENCY LIGHTS BETWEEN ROWS 18 AND 21 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS BETWEEN ROWS 18 AND 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040743Slide · dislodgedFLT 1504 - RSW - UPON L1 DOOR CLOSURE AT PUSHBACK THE SLIDE PACK FELL OFF DOOR. RE-INSTALLED L1 SLIDE PACK ASSEMBLY. (M)SDR CALA0400609Release Cable · out of rigTHE TAILCONE PULL CHECK FROM THE INTERIOR RELEASE HANDLE, FAILED. THE CABLES WERE ADJUSTED IAW MM 53-53-00.SDR CALA0400607Slat Track · crackedINSPECTION FOUND A 1.5 INCH CRACK IN NR 10 AUX TRACK SLAT CAN XOS 380.229. THE NR 10 AUX TRACK SLAT, CAN WAS REMOVED AND REPLACED IAW SRM 51-30-0 AND 51-20-0.SDR GTIA040741Control Valve · malfunctionedAFTER TAKEOFF, AIRCRAFT SPEED APPROX 150 KNOTS THERE WAS NO DRAG 100 FEET AGL 12 DEGREE PITCH UPLEFT MAIN GEAR, GEAR WAS UP RED LIGHT STAYED ON AFTER GEAR RETRACTION GEAR DOOR OPEN LIGHT WAS NOT ON AND NOSE AND RIGHT MAIN GEAR LIGHTS NOT ON AT SPEED 200 KNOTS SDR AALA20040864Battery Pack · inoperativeDEN - OVERHEAD EMERGENCY LIGHTS AT SEATS 27 AND 29 INOPERATIVE. REPLACED BATTERY PACK M5107 FOR OVERHEAD EMERGENCY LIGHTS AT SEATS 27 AND 29. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040863Battery Pack · inoperativeDEN - CEILING EMERGENCY LIGHTS AT AFT SERVICE DOOR INOPERATIVE. REPLACED BATTERY PACK B5107 FOR CEILING EMERGENCY LIGHTS AT AFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040736Slide · misinstalledDTW - FOUND CHECK L2 SLIDE FOR CORRECT INSTALLATION. REMOVED AND REPLACED L2 SLIDE PACK. ESCAPE SLIDE REMOVAL AND INSTALLATION. (M)SDR GTIA040734Guide Vane · crackedDTW - NR 1 ENGINE IGV HAS A HAIRLINE CRACK ON THE VANE ATTACHMENT WELD AT THE 3:30 POSITION APPROX 2.750 INCH LONG. REMOVED AND REPLACED IGV. (M)SDR AALA20040860Battery Pack · inoperativeDEN - EMERGENCY LIGHTS AT COCKPIT AND FORWARD DOORS INOPERATIVE. REPLACED BATTERY PACK B5-23 AT STATION 211 FOR COCKPIT AND FORWARD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040725Conduit · out of positionDTW - FLT 563 - AFTER TAKEOFF LEFT MAIN GEAR UNSAFE LIGHT REMAINED ON/RED FOR ONE MINUTE AFTER ALL OTHER LANDING GEAR LIGHTS OUT. AS SLOWED TO 230 KIAS FOR QRH PROCEDURE LIGHT WENT OUT AND REMAINED OUT FOR REMAINDER OF FLIGHT. FOUND WIRE CONDUIT FROM GEAR UPSDR GTIA040729Lanyard · missingFOUND L2 SLIDE PACK NOT INSTALLED CORRECTLY PULL CABLE NOT INSTALLED. INSTALLED MANUAL PULL CABLE. (M)SDR GTIA040735Engine · leakingPOSSIBLE FUEL LEAK ON NR 1 ENGINE. REMOVED AND REPLACED NR 1 ENGINE. (M)SDR GTIA040748Roller · out of adjustDURING CRUISE FLIGHT, GEAR DOOR OPEN LIGHT CAME ON, PUT HYDRAULIC PUMPS ON HIGH AND LIGHT WENT OUT AFTER APPROXIMATELY 3 MINUTES. FOUND DOOR ROLLER TO HOOK CLEARANCE OUT OF ADJUSTMENT. ADJUSTED CLEARANCE. (M)SDR AALAA20040855Battery Pack · inoperativeEMERGENCY CEILING AISLE LIGHTS AT SEATS 23D AND 26D INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY CEILING AISLE LIGHTS AT SEATS 23D AND 26D. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040854Battery Pack · inoperativeEMERGENCY LIGHTS AT SEAT 8 AB AND AFT GALLEY OVERHEAD INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS AT SEAT 8 AB AND AFT GALLEY OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040858Slide · dislodgedDCA - FORWARD ENTRY DOOR SLIDE PACK FELL OFF WHEN AGENT TRIED TO CLOSE THE DOOR. UNSUCCESSFUL DEPLOYMENT. REPLACED DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040722Proximity Sensor · malfunctionedLGA - FLT 779 - FOUND LEFT MAIN GEAR UNSAFE LIGHT CAME ON AND STAYED ON IN FLIGHT. FOLLOW QRH PROCEDURES CONT TO FLL AT .700 MACH. REMOVED AND REPLACED PROXIMITY SWITCH ELECTRONIC UNIT. (M)SDR GTIA040732Isolator · shiftedRSW - FOUND FORWARD LOWER ISOLATOR FOUND SHIFTED ON NR 2 PYLON. REPLACED FORWARD LOWER ISOLATOR. (M)SDR AALA20040845Compressor · failedDFW - INFLIGHT T1446/15 COMPRESSOR STALL AT 17500 ON CLIMBOUT AND ENGINE NUMBER 1 AT 10LR FOR REMAINDER OF FLIGHT. OIL LEAK REPORTED WITHIN CLEAR OF RUNWAY. REPLACED ENGINE NUMBER 1 PER WORKCARD 71 91 99. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040723Proximity Sensor · malfunctionedORD - FLT 1525 - LEFT MAIN LANDING GEAR INDICATOR STAYED RED AFTER GEAR RETRACTION FOLLOWED QRH AND HAD NORMAL INDICATIONS AFTER. REMOVED AND REPLACED LEFT MLG UPLOCK PROX SENSOR. PERFORMED OPS CHECK OF SENSOR THROUGH PROX SWITCH ELECT. (M)SDR GTIA040730Controller · malfunctionedLGA - FLT 779 - LEVEL AT FL280, FLOW LT ILLUMINATED AND CABIN ALT STARTED CLIMBING. PRESSURIZATION CONFIRMED FULL FORWARD. DESCENDED INITIATED AND CABIN PRESSURIZATED AT 17000 FLOW LIGHT OUT COMPLIED WITH QRH PROC. REMOVED AND REPLACED 7 CONTROLLER/SELECTORSDR ASMF200408013Compensator · failedCAPTAIN REPORTED DIFFERENCE BETWEEN LT AND RT FUEL INDICATORS. DURING COMPENSATORS TEST WAS DETECTED THAT THE RIGHT TANK HAD 2500 LBS, LT TANK HAD 2600 LBS AND CENTRAL TANK HAD 3000 LBS. FUEL WAS TRANSFERRED FORM PRINCIPAL TANKS TO CENTRAL TANK AND BOTH TANKS SDR AALA20040846O-Ring · leakingINFLIGHT T313/13, FLIGHT ATTENDANTS SMELLED AND SAW SMOKE IN CABIN. FIRST OFFICER REPORTED ODOR LIKE BURNING CLOTHING. RETURNED AND LANDED WITHOUT INCIDENT. ACCOMPLISHED PACK BURNOUT IAW MCM CARD 21 92 12 AND ACCOMPLISHED WORK CARD 21 96 01. FOUND APU LOW SDR CALA0400602Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT STA 1007-1098, BL 0 TO LBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F.SDR CALA0400601Skin · crackedINSPECTION FOUND A .5 INCH CRACK IN FUSELAGE SKIN AT RIVET HOLE, STA 1380, BETWEEN LONGERON 13R AND 14R. THE SKIN WAS REPAIRED IAW SRM 53-04, FIGURE 18.SDR CALA0400600Skin · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE SKIN AT RIVET HOLE, STA 1380, LONGERON 13L TO 14L. THE CRACKED AREA OF SKIN WAS CUT OUT AND FILLER AND A DOUBLER WERE INSTALLED IAW SRM 53-04, FIGURE 18 AND 51-10-3B.SDR GTIA040731Engine · failedFOUND RIGHT ENGINE FAILED AT 800 FEET DURING CLIMB-OUT FROM RSW. REPLACED NR 2 ENGINE. (M)SDR ASMF200408011Regulator · openCAPTAIN REPORTED THAT AT FL 330 FLOWS LIGHT TURNED ON DUE TO PRESSURIZATION FAILURE PERFORMING AN ABNORMAL AND EMERGENCY PROCEDURE. ANTI-ICE WAS APPLIED TO ENGINES AND WINGS BUT LIGHT CONTINUE AND CABIN ALTITUDE LIGHT TURNED ON, PRESSURIZATION WAS CONTROLLED SDR CALA0400598Seat Track · corrodedINSPECTION FOUND RT CENTER SEAT TRACK CORRODED AT STA 200-218, RBL 22. A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-05.SDR CALA0400596Seat Track · corrodedINSPECTION FOUND LT MID SEAT TRACK CORRODED FROM STA 1098-1201, LBL 30. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2.SDR AALA20040840Battery Pack · inoperativeMIA - FORWARD MOST BLOCK OF CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK NEXT TO FORWARD LAVATORY FOR FORWARD MOST BLOCK OF CEILING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA040145Support Angle · corrodedPAX DOOR THRESHOLD FLOORBOARD ATTACH ANGLE CORRODED AT NUTPLATE FLANGE FORWARD AND AFT. FABRICATED AND INSTALLED SUPPORT ANGLE.SDR MWEA040142Fitting · corrodedFORWARD IB GALLEY 1 SUPPORT FITTING CORRODED AT FRAME STA 160, 6 INCHES LT OF CENTER LINE. FABRICATED AND INSTALLED SUPPORT FITTING.SDR MWEA040147Fitting · corrodedBOTH FORWARD AND AFT GALLEY SERVICE DOOR GIRT BAR LATCH SUPPORT FITTINGS ARE CORRODED BEYOND REPAIR. FABRICATED AND INSTALLED FITTINGS.SDR MWEA040146Floor Support · corrodedFORWARD AND AFT PLUGS FOR THE FLOOR SUPPORT BETWEEN STA 148-200 RT OF FUSELAGE CENTER LINE ARE CORRODED. FABRICATED AND INSTALLED PLUGS.SDR MWEA040144Pan · corrodedFORWARD WATER SERVICE PAN LIP CORRODED AT FRAME STA 155. FABRICATED AND INSTALLED SUPPORT.SDR MWEA040143Floor Support · corrodedCENTER LINE FLOOR SUPPORT BETWEEN FRAME STATION 160 AND 200 CORRODED ON TOP AND SIDE. FABRICATED AND INSTALLED NEW SUPPORT.SDR MWEA040141Floorboard · corrodedFORWARD GALLEY SERVICE DOOR FLOORBOARD CORRODED ALL OVER. FABRICATED AND INSTALLED SHIM.SDR GTIA040728Handle · looseFOUND L1 DOOR HANDLE LOOSE. TIGHTENED L1 DOOR HANDLE ASSEMBLY. (M)SDR GTIA040717Lanyard · misroutedORD - FLT 433 - TAILCONE ESCAPE SLIDE LANYARDS NOT ROUTED CORRECTLY. ROUTED LANYARDS CORRECTLY. (M)SDR AALA20040839Wire · damagedLAX - RIGHT HAND OVERHEAD EMERGENCY LIGHT AT STATION 1296 IS INOPERATIVE. REPLACED WIRE TO L794N20 ON L2 615 FOR RIGHT HAND OVERHEAD EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA040137Support · corrodedFLOOR SUPPORT INBOARD OF FORWARD SERVICE DOOR CORRODED, SUPPORT GOES FROM STATION 150-200. FABRICATED AND INSTALLED SUPPORT.SDR MWEA040140Web · corrodedSUBFLOOR WEB CORRODED UNDER GALLEY 1 WATER PAN. STA 155 AND RT OF BUTT LINE 44. FABRICATED AND INSTALLED WEB.SDR MWEA040139Cusp Web · crackedFRAME STA 1309 LT CUSP MEMBRANE IS CRACKED FROM LIGHTNING HOLE TO LIGHTNING HOLE. FABRICATED AND INSTALLED DOUBLER.SDR MWEA040138Clip · elongatedFLOORBEAM AND ATTACHMENT CLIP AT STATION 148.50 HAS ELONGATED HOLES APPROXIMATELY 15 INCHES RT OF AIRCRAFT CENTERLINE WHERE STICK PUSHER BRACKET BOLTS UP. FABRICATED AND INSTALLED NEW CLIP.SDR GTIA040719Mechanism · stickingDTW - FLT 417 - FOUND MAIN CABIN DOOR WILL NOT CLOSE. INSPECTED AND FOUND INTERLOCK MECH STICKING, LUBED AND ADJUSTED INTERLOCK ARM. OPS CHECK GOOD. INSPECTED L1 DOOR. (M)
Back to Mcdonnell Douglas DC-9-82