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 AALA20120512003Stiffener · damagedAFT SIDE OF FRAME 1418 AT LONGERON 2 LEFT UPPER OUTBOARD AND INBOARD HOLES ATTACHING FRAME TO LONGERON HATS ARE MISS DRILLED. REPLACED STIFFENER PER AARD 51-10-00-5.SDR AALA20120510007Membrane · corrodedCORROSION UNDER G1 GALLEY DRAIN PAN. INSTALLED DOUBLER PER AARD 53-20-00-16 AND EA MD80-53-023501.SDR AALA20120509002Angle · damagedLEFT STATION 674 HAS TOOLING MARK ON CUSP T-ANGLE. INSTALLED REPLACEMENT CUSP T-SECTION, FORWARD AND AFT SPLICE ANGLE PER SRM 53-05-00 FIGURE 25.SDR AALA20120509009Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE OF 1437 ABOVE LONGERON 17 RIGHT. INSTALLED NEW SHEARTIE AFT SIDE OF STATION 1437 AND ABOVE LONGERON 17 RIGHT PER AARD 51-10-00-5.SDR AALA20120509007Door Frame · damagedOBLONG HOLE IN DOOR BEAM STATION 1212 BETWEEN LONGERONS 25 AND 24 RIGHT. INSTALLED DOUBLER REPAIR PER EA MD80-53-023616.SDR AALA20120509003Cusp Web · damagedCUT FROM LIGHTENING HOLE TO OUTBOARD EDGE OF CUSP SHEET, STATION 0687 FOR ELECTRICAL WIRING. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120508018Charger · inoperativeEMERGENCY EXIT LIGHTS FOR COCKPIT PORT FRONT DOORS AND FIRST CLASS OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED CHARGER AND BATTERIES, OPS CHECK NORMAL.SDR AALA20120508004Cusp Web · corrodedCORROSION ON LEFT CUSP BETWEEN STATIONS 579 TO 598. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120508027Longeron · crackedLONGERON 2 RIGHT CRACKED AFT OF STATION 1418. INSTALLED LONGERON SPLICE REPAIR PER SRM 53-02-00 FIGURE 18.SDR AALA20120508024Cusp Web · corrodedRIGHT CUSP SHEET FROM STATIONS 446 TO 457 CORRODED. INSTALLED REPAIR DOUBLER FROM STATIONS 438 TO 454 RIGHT BUTTLINES 50 TO 60 PER AARD 53-20-00-16.SDR AALA20120507025Cusp Web · corrodedAFT SERVICE DOOR AFT GIRT BAR MOUNT BRACKET HAS CORROSION UNDER BRACKET ON SUB FLOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120507024Cusp Web · corrodedAFT SERVICE DOOR FORWARD GIRT BAR MOUNT BRACKET HAS CORROSION UNDER BRACKET ON SUB FLOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120507023Cusp Web · corrodedRIGHT CUSP SHEET FROM STATIONS 640 TO 650 CORRODED. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120507022Cusp Web · corrodedCORROSION ON BOTTOM OF RIGHT CUSP AT STATION 522. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120507021Cusp Web · damagedDAMAGE ON RIGHT CUSP AT STATION 890 INBOARD OF SEAT TRACK 6. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120507019Cusp Web · corrodedCORROSION ON LEFT CUSP OUTBOARD OF CENTER LIGHTNING HOLE BETWEEN STATIONS 522 TO 541. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120507018Membrane · corrodedRIGHT SUBFLOOR CORRODED AT STATION 216 RIGHT BUTTLINE 56. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120507017Cusp Web · corrodedCORROSION ON LEFT CUSP FROM STATIONS 541 TO 560. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120505022Controller · inoperativeLIT - CREW REPORTED PRESSURIZATION FAULT. EMERGENCY DECLARED FLIGHT LANDED LIT WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. PLACARD BOTH CABIN AUTO PRESSURE CONTROLLERS PER MEL 21-23B. REPLACED NUMBER 1 PRESSURE CONTROLLER AT DFW ON 05/07/2012. SYSTEMSDR AALA20120506006Battery Pack · not seatedOVERHEAD EMERGENCY LIGHTS 3AB AND 3EF INOPERATIVE. RESEATED BATTERY PACK IN BIN 4DEF. OPS CHECK NORMAL.SDR AALA20120505007Terminal · looseOVERHEAD EMERGENCY LIGHTS FROM ROWS 12 TO 18 CAME ON WITH SWITCH OFF. TIGHTENED LOOSE TERMINALS ON BATTERY PACK B5-101. OPS CHECK NORMAL.SDR AALA20120501014Engine · failedBNA - CREW REPORTED LEFT ENGINE OIL FILTER CLOG LIGHT ILLUMINATED. THERE WAS SOME TYPE OF VIBRATION FELT BY THE FLIGHT CREW AND FLIGHT ATTENDANT WHICH WENT AWAY WHEN ENGINE WAS BROUGHT BACK TO IDLE. EMERGENCY DECLARED FLIGHT LANDED BNA WITHOUT INCIDENT. AIRSDR AALA20120501012Diaphragm · corrodedCORROSION ON DIAPHRAM SHEET UNDER GALLEY TIEDOWN AT STATION 218 INBOARD OF NUMBER 4 SEAT TRACK. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120430015Cusp Web · crackedCRACK IN LEFT CUSP STATION 218 JUST OUTBOARD OF NUMBER 2 SEAT TRACK. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20120429006Oil Cooler · crackedPSP - CREW REPORTED SMOKE IN THE CABIN. EMERGENCY DECLARED FLIGHT RETURNED PSS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND AUXILIARY POWER UNIT OIL COOLER CRACKED AT CORNER SEAM. REPLACED APU. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120428007Switch · failedDFW - CREW REPORTED SLAT AURAL WARNING AND SLAT DISAGREE LIGHT ON. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FLAP HANDLE SWITCH. SYSTEM GROUND CHECK NORMAL OPERATION.SDR WX0A071193Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20120427011Frame · crackedTHE 1510 CANT FRAME CRACKED BELOW MAINTENANCE LIGHT SWITCH. INSTALLED DOUBLER PER EA MD80-53-023404.SDR AALA20120426005Controller · failedSTL - CREW REPORTED WHEN GEAR WAS EXTENDED ANTISKID LIGHTS ILLUMINATED. LEFT OUTBOARD ANTISKID LIGHT REMAINED ILLUMINATED. FOLLOWED QRH PROCEDURE. FLIGHT LANDED STL WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ANTISKID CONTROLLER. SYSTEM GROSDR AALA20120426003Light · inoperativeLEFT NUMBER 1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR LEFT NUMBER 1 DOOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120425016Skin · crackedFUSELAGE SKIN IS CRACKED AT 2 EACH RIVETS IN THE SHEAR TIE AT STATION 1380 LONGERON 14 RIGHT ABOVE THE ENGINE PYLON. CUT OUT DAMAGED FASTENER HOLES AND INSTALLED FILLER AND REPAIR DOUBLER PER SRM 53-01-00.SDR AALA20120425015Skin · crackedFUSELAGE CRACKED AT FASTENER ABOVE PYLON AT STATION 1380. CUT OUT DAMAGED FASTENER HOLES AND INSTALLED FILLER AND REPAIR DOUBLER PER SRM 53-01-00.SDR RYNA201204240019Slide · low pressureR1 DOOR SLIDE PRESSURE NEEDLE OUT OF GREEN BAND. REPLACED R1 DOOR SLIDE IAW AMM 25-62-00.SDR AALA20120421004Regulator Valve · defectiveDFW - CREW REPORTED STRONG BURNING RUBBER SMELL THROUGHOUT CABIN DURING TAKEOFF AND LIGHT SMOKE IN REAR CABIN. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BOTH AIR CONDITIONING PRESSURE REGULATOR VSDR AALA20120420022Casting · crackedLEFT WING TRAILING EDGE HAS A CRACK IN RADIUS OF GROUND SPOILER ACTUATOR CASTING AT INBOARD END OF FORWARD MOUNT LUG. REMOVED AND REPLACED SPOILER CASTING PER AARD 51-10-00-5.SDR AALA20120420016Shutoff Valve · inoperativeDFW - FLIGHT ATTENDANT REPORTED PAPER BURNING SMELL IN MID CABIN. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT AND RIGHT PRESSURE REGULATING SHUT OFF VALVES. SYSTEM GROUND CHECK NORMAL OPERATISDR AALA20120420003Frame · crackedFRAME 1418 CRACKED ALONG RADIUS AT LONGERON 2 RIGHT AREA. INSTALLED DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR AALA20120419006Bullet · inoperativeDFW - CREW REPORTED SIGNFICANT ENGINE PRESSURE RATIO SPLIT THAT BECAME WORSE AS ALTITUDE INCREASED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 1 ENGINE PT2 BULLET. SYSTEM GROUND CHECK NORMSDR AALA20120419011Skin · dentedDENT IN FUSELAGE FROM STATIONS 237 TO 246 LONGERON 18 LEFT. INSTALLED DOUBLER PER SRM 53-04-02 FIGURE 2 VIEW B.SDR AALA20120419004Skin · dentedSCRATCH/DENT TO FUSELAGE STATION 226. INSTALLED DOUBLER, FILLER AND STRAP PER SRM 53-04-05 FIGURE 2.SDR AALA20120418014Shear Tie · crackedSTATION 1451, AFT SIDE, LONGERON 2 RIGHT, SHEAR TIE CLIP CRACKED. REMOVED CRACKED SHEAR TIE CLIP AND INSTALLED SERVICEABLE SHEAR TIE CLIP PER AARD 51-10-00-5.SDR AALA20120417025Frame · wornAFT ACCY-1380 FRAME WEB CRACKED. COCKPIT TEMP CONTROL VALVE IN CONTACT WITH EXISTING WEB FRAME DOUBLER. REMOVED AND INSTALLED NEW WEB FRAME DOUBLER PER AARD 53-10-00-28. COCKPIT TEMP CONTROL VALVE REPOSITIONED.SDR AALA20120418005Battery Pack · out of adjustLEFT FORWARD AND AFT OVERWING DOOR UPPER EXIT SIGNS DIM. RE-ADJUSTED BATTERY PACK, OPS CHECK NORMAL.SDR AALA20120418004Battery Pack · out of adjustCEILING EMERGENCY LIGHTS FROM ROWS 3 TO 6 INOPERATIVE. RE-ADJUSTED BATTERY PACK, OPS CHECKS NORMAL.SDR AALA20120418001Portable Light · inoperativeLEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT AT LEFT NUMBER 1 DOOR. OPS CHECK NORMAL.SDR AALA20120417002Clamp · looseSTL - INFLIGHT ORD-TUS. CREW REPORTED LEFT PACK FAILED ON CLIMBOUT. FLIGHT DIVERTED STL LANDED WITHOUT INCIDENT. FOUND CLAMP LOOSE FOR BOOT AT LEFT FORWARD HEAT EXCHANGER OUTLET. REPOSITIONED DUCT AND SECURED BOOT AT LEFT FORWARD HEAT EXCHANGER OUTLET. SYSSDR AALA20120416009Oven · odiferousDFW - CREW REPORTED STRONG ELECTRICAL SMOKE SMELL IN COCKPIT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FORWARD OVENS THAT WERE EMITTING ODOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120416007Cusp Web · corrodedCORROSION ON RIGHT CUSP AT STATION 563. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20120415005Seat Track · corrodedNR 1 SEAT TRACK FROM BS 1117 TO 1176 CORRODED. REPLACED SEAT TRACK PER AARD 51-10-00-05.SDR AALA20120418009Skin · damagedLIGHTNING/STATIC DISCHARGE AT FRAME STATION 144 AND LONGERON 14 RIGHT. TRIMMED OUT DAMAGE AND INSTALLED EXTERNAL DOUBLER PER EA MD80-53-023130.
Back to Mcdonnell Douglas DC-9-82