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 WX0A071455Skin · chafedRIGHT WING I/B FLAP O/B VANE HAS 2 EA CHAFES ON UPPER SKIN AT I/B END. CUT OUT DAMAGED AREA. FABRICATED REPAIR FILLER AND DOUBLER AND INSTALLED REPAIR PARTS.SDR AALA20121226004Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 23 TO 26 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM ROWS 23 TO 26. OPS CHECK NORMAL.SDR AALA20121224003Battery Pack · not seatedTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE WALK WAY INOPERATIVE. RESEATED BATTERY PACK, OPS CHECK NORMAL.SDR AALA20121224002Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. RESEATED BATTERY. OPS CHECK NORMAL.SDR AALA20121220002Membrane · crackedCRACK IN SUBFLOOR AT STATION 215 UNDER SEAT TRACK NUMBER 5. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20121220001Cusp Web · corrodedRIGHT CUSP AT STATION 1185 CORRODED. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130112008Support Fitting · crackedRIGHT WING GROUND SPOILER DRIVE SUPPORT FITTING CRACKED, AT OUTBOARD SIDE OF ACTUATOR FORWARD ATTACH POINT. REMOVED AND REPLACED FITTING PER SRM 51-30-05 AND 51-30-02.SDR WX0A071454Battery · 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 AALA20121219017Pan · crackedRIGHT WINDOW PAN CRACKED BETWEEN STATIONS 769 TO 788 AT LOWER FORWARD CORNER. INSTALLED DOUBLER REPAIR AND FILLER PER AARD 53-10-00-25.SDR AALA20130108014Cusp Web · crackedCUSP SHEET CRACKED AT STATION 842 RIGHT, UNDER HORSE COLLAR DOUBLER. ROUTED OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20121217040Beam · corrodedAFT CARGO DOOR BEAM CORRODED FROM STATIONS 1155 TO 1212. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-10-00-3.SDR AALA20121217024Tee Fitting · corrodedCORROSION ON T FITTING BELOW CUSP SHEET FOR AFT SERVICE DOOR GIRT BAR FITTING AT STATION 1166. INSTALLED NEW T FITTING PER AARD 53-20-00-16 AND SRM 51-30-05.SDR AALA20121217010Cusp Web · corrodedCORROSION ON CUSP SHEET AT STATION 1166 BELOW AFT SERVICE DOOR GIRT BAR FITTING. INSTALLED CUSP REPAIR DOUBLER PER BOEING DRAWING 9930612 AND AARD 53-20-00-16.SDR AALA20121217009Cusp Web · corrodedAFT CARGO LEFT CUSP CORRODED FROM STATIONS 1136 TO 1155. INSTALLED CUSP REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20121215002Skin · dentedDENT AT STATION 160, LONGERON 20 RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-04-03.SDR AALA20130109003Cusp Web · corrodedSUBFLOOR IS CORRODED FROM STATIONS 1170 TO 1174 FORWARD OF NUMBER 1 SEAT TRACK. INSTALLED DOUBLER PER EA MD80-53-027744.SDR AALA20121214008Longeron · crackedLONGERON 2 LEFT CRACKED AFT OF STATION 1418. INSTALLED DOUBLER PER SRM 53-02-00 FIGURE 7 AND SRM 51-60-00.SDR AALA20121212024Longeron · crackedCRACK AT LONGERON 2 LEFT, STATION 160, ON OUTBOARD SIDE. INSTALLED NEW SECTION AND SPLICE AT LONGERON 2 LEFT FROM STATIONS 148 TO 175 PER SRM 53-02-00 FIGURE 18.SDR AALA20121212022Web · corrodedCORROSION ON WEB BETWEEN STATIONS 1149 TO 1155 BETWEEN LONGERONS 25 AND 27 RIGHT. REMOVED DAMAGE AND INSTALLED SPLICE REPAIR PER AARD 53-10-00-24.SDR AALA20121212008Cusp Web · corrodedLEFT CUSP CORRODED FROM STATIONS 725 TO 727. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20121212006Membrane · gougedSTATION 200, RIGHT BUTTLINE 6, GOUGE IN SUBFLOOR. REMOVED DAMAGED AREA IN SUBFLOOR AND INSTALLED DOUBLER REPAIR AS AARD 53-20-00-16.SDR AALA20121212005Fitting · corrodedSTATION 160, GALLEY NUMBER 1 TIE DOWN FITTING CORRODED. INSTALLED SERVICEABLE TIE DOWN FITTING PER AARD 51-00-05-1.SDR AALA20121212012Battery Pack · not seatedLEFT AND RIGHT AFT OVERWING DOOR UPPER EXIT SIGNS INOPERATIVE. RESEATED BATTERIES BY 20DEF. OPS CHECK NORMAL.SDR AALA20121212011Connector · disconnectedFORWARD AND AFT ESCAPE PATH LIGHTS AT SEAT 20D INOPERATIVE. RECONNECTED CONNECTOR. OPS CHECK NORMAL.SDR AALA20121211017Stiffener · crackedSTIFFENER CRACKED BELOW LONGERON 1 ABOVE VAULT DOOR JAMB. INSTALLED DOUBLER PER AARD 53-10-00-15.SDR AALA20121211015Shear Tie · damagedFUSELAGE SKIN FORMER (SHEAR TIE) DAMAGED AT STATION 446 BETWEEN LONGERONS 20 AND 21 LEFT. INSTALLED SHEAR TIE REPAIR PER SRM 53-03-00 FIGURE 3.SDR AALA20121211014Shear Tie · damagedFUSELAGE SKIN FORMER (SHEAR TIE) DAMAGED AT STATION 427 BETWEEN LONGERONS 20 AND 21 LEFT. INSTALLED SHEAR TIE REPAIR PER SRM 53-03-00 FIGURE 3.SDR AALA20121211010Skin · damagedLIGHTNING STRIKE DAMAGE AT STATION 323 AND LONGERON 28 RIGHT. INSTALLED REPAIR DOUBLER AND FINGERS PER SRM 53-04-03.SDR AALA20121211004Cusp Web · corrodedRIGHT CUSP FROM STATIONS 1165 TO 1170 CORRODED. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20121215001Fairing · crackedTAB FAIRING CRACKED ON LEFT ELEVATOR. INSTALLED REPAIR DOUBLER PER ESO 80080 PG 601(O).SDR WX0A071439Battery · 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 AALA20121211003Lens · missingCEILING EMERGENCY LIGHT AT SEAT 23D MISSING LENS. REPLACED LENS FOR CEILING EMERGENCY LIGHT AT SEAT 23D. OPS CHECK NORMAL.SDR AALA20121211002Lens · missingCEILING EMERGENCY LIGHT AT SEAT 11D MISSING LENS. REPLACED LENS FOR CEILING EMERGENCY LIGHT AT SEAT 11D. OPS CHECK NORMAL.SDR AALA20121210004Skin · dentedDEEP DENT IN FUSELAGE SKIN AT STATION 436 BELOW LONGERON 21 LEFT. INSTALLED EXTERNAL DOUBLER PER SRM 53-04-03 FIGURE 1.SDR AALA20121210001Angle · crackedSTATION 237, FORWARD CARGO, ANGLE CRACKED BELOW LEFT TIE DOWN TRACK, FORWARD SIDE OF FRAME. REMOVED CRACKED ANGLE AND INSTALLED SERVICEABLE ANGLE PER AARD 51-00-05-1.SDR AALA20121209014O-Ring · damagedDFW - CREW REPORTED LOSS OF LEFT HYDRAULIC SYSTEM PRESSURE AND QUANTITY LOSS IN FLIGHT. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED O-RING ON MIDDLE FITTING ON NUMBER 2 SPOILER ACTUATOR ON LEFT WING. SYSTESDR AALA20121209007Controller · inoperativeDFW - CREW REPORTED HAD RAPID DEPRESSURIZATION WHILE IN AUTO. SWITCHED TO MANUAL CONTROL AND WAS ABLE TO CONTROL. NO FLOW LIGHTS ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 1 SDR AALA20121209003Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 21 TO 32 ON SEATS AND CEILING INOPERATIVE. REMOVED AND REPLACED AFT BATTERY PACK. OPS CHECK NORMAL.SDR AALA20121208003Skin · dentedDENT WITH GOUGES AT FUSELAGE STATIONS 1186 LEFT AT LONGERON 19 LEFT. INSTALLED DOUBLER AND FILLER PER EA MD80-53-027475.SDR AALA20121217012Skin · damagedRIGHT WING INBOARD FLAP DENT IN BOTTOM SKIN 15 INCHES FROM INBOARD EDGE OF WEDGE. REMOVED AND REPLACED RIGHT INBOARD FLAP AFT WEDGE LOWER SKIN PER ESO 80095 AND SRM 51-01-00.SDR AALA20121217011Skin · damagedRIGHT WING INBOARD FLAP DENT IN BOTTOM SKIN 18 INCHES FROM INBOARD EDGE OF WEDGE. REMOVED AND REPLACED RIGHT INBOARD FLAP AFT WEDGE LOWER SKIN PER ESO 80095 AND SRM 51-01-00.SDR AALA20121207023Door Frame · crackedFORWARD CARGO DOOR FORWARD PAN FRAME CRACKED AT NUMBER 1 BEAM RADIUS BLOCK. INSTALLED DOUBLER PER EA COMP-52-027430.SDR AALA20121207022Door Frame · crackedAFT CARGO DOOR FORWARD PAN FRAME CRACKED AT NUMBER 5 BEAM. STOP DRILLED CRACK AND INSTALLED DOUBLER PER ESO80174 AND SRM 52-03-00 FIGURE 8.SDR AALA20121207021Structure · damagedFOUND COMPOSITE DAMAGE ON RUDDER WHEN SANDING. DAMAGE AND REPAIR IS LOCATED ON THE RIGHT SIDE OF RUDDER. APPLIED WET OVERLAYS TO REPAIR AREA PER SRM 51-90-00.SDR AALA20121207020Cusp Web · damagedLEFT CUSP INBOARD LIGHTNING HOLE AT STATION 1234 DAMAGED. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20121207019Cusp Web · damagedLEFT CUSP INBOARD LIGHTNING HOLE AT STATION 1238 DAMAGED. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20121207008Cusp Web · corrodedLEFT CUSP CORRODED FROM STATIONS 1174 TO 1176. INSTALLED DOUBLER PER SRM 53-05-00 FIGURE 131A-23.SDR AALA20121207007Door Frame · crackedFORWARD CARGO DOOR AFT PAN FRAME CRACKED AT NUMBER 5 BEAM. STOP DRILLED CRACK AND INSTALLED REPAIR DOUBLER PER SRM 52-03-00 FIGURE 8.SDR AALA20121206012Bracket · corrodedCORROSION ON T BRACKET AT STA 1155 AT LONGERON 28 RIGHT. REPLACED BRACKET PER AARD 51-00-05-1.SDR AALA20121206011Web · corrodedCORROSION ON WEB FROM STATIONS 1149 TO 1220. REPLACED WEB PER AARD 51-00-05-1.
Back to Mcdonnell Douglas DC-9-82