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 AALA20100119TUL01Diaphragm · crackedDIAPHRAGM SKIN CRACKED AT STATION 200 LEFT, LONGERON 11 LEFT AT DOOR JAMB TAB STA. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR WX0A070511Apu · malfunctionedFLIGHT CREW REPORTED WHILE TAXING TO GATE AFTER LANDING IN SGF AND SWITCHING AIR CONDITIONING PACK TO THE APU THE CABIN FILLED WITH HAZE AND STENCH. MAINTENANCE DEPARTMENT PERSONNEL INSPECTED THE AIRCRAFT AND REMOVED AND REPLACED THE APU ASSY, IAW ALLEGIANT ASDR AALA20100117PHX01Schrader Valve · defectivePHX - AFTER TAKEOFF NOSE LANDING GEAR WOULD NOT RETRACT. RETURNED PHX WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPACKED NOSE STRUT AND VALVE SUPPORT SCHRADER VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20100112STL01Cylinder · inoperativeSTL - LEFT MAIN LANDING GEAR WOULD NOT RETRACT ON TAKEOFF. EMERGENCY DECLARED, RETURNED STL WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT MAIN GEAR RETRACT SUPPORT FITTING AND LEFT MAIN GEAR RETRACT CYLINDER AND CYLINDER LINKAGES. SYSTEM GSDR AALA20100109ORD01Generator · failedORD - DURING CLIMBOUT RIGHT ENGINE GENERATOR FAILED AND AIR CONDITIONING LOCKOUT LIGHT ILLUMINATED. EMERGENCY DECLARED, RETURNED ORD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED RIGHT ENGINE CONSTANT SPEED DRIVE AND RIGHT ENGINE GENSDR AALA20100109DFW01Shroud · missingEMERGENCY LIGHT AT SEAT 25D MISSING LENS SHROUD. REPLACED LENS SHROUD ON SEAT 25D.SDR WX0A070508Battery Pack · no testDURING 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 AALA20100103DFW02Circuit Breaker · trippedDFW - CREW REPORTED LEFT AFT FUEL BOOST PUMP CIRCUIT BREAKER TRIPPED. LEFT FORWARD FUEL BOOST PUMP ON PLACARD. EMERGENCY DECLARED RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. RESET AFT LEFT FUEL CIRCUIT BREAKER AND REPLACED LEFT FORWARD FUSDR AALA20091231LGA01Light · defectivePORTABLE EMERGENCY LIGHT WILL NOT CHARGE. RELAMPED LIGHT.SDR AALA20091223BOS01Yaw Damper · failedCREW REPORTED AIRCRAFT YAWING SIGNIFICANTLY. INHIBITED YAW DAMPER AND DE-PRESSURIZED RUDDER SYSTEM. RETURNED TO BOS AND LANDED WITHOUT INCIDENT. REPLACED YAW DAMPER ACTUATOR.SDR AALA20091222TUL06Bracket · corrodedFORWARD CABIN HAS CORROSION AT G-1 GALLEY, FORWARD INBOARD SUBFLOOR BRACKET AT STATION 160. INSTALLED FLOORBEAM I ANGLE REPAIR PER SRM 53-05-00 FIG 20A AND AARD 53-00-00-06.SDR AALA20091222TUL05Pan · corrodedCORROSION ON PAN ALONG THE FORWARD CARGO DOOR THRESHOLD. INSTALLED NEW DOOR PAN PER SRM 53-05 FIG 44.SDR AALA20091222TPA01Battery Pack · dischargedEMERGENCY EXIT LIGHT SWITCH IN ARM POSITION AND EMERGENCY EXIT LIGHTS ARE ON. REPLACED BATTERY PACK FOR EMERGENCY EXTERIOR LIGHTS.SDR AALA20091221DFW02Seal · failedCREW REPORTED A NOSE GEAR UNSAFE INDICATION AFTER TAKEOFF. NOSE GEAR DID NOT RETRACT. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR SHOCK STRUT SEAL.SDR AALA20091221TUL08Pan · corrodedFORWARD CARGO DOOR CUTOUT THRESHOLD PAN CORRODED. REMOVED AND REPLACED DOOR JAMB PAN AND SPLICE PLATES PER SRM 53-05-00 FIGURE 44.SDR AALA20091221TUL07Flap · damagedAIRCRAFT FLAP DAMAGED DUE TO IMPACT. REMOVED DAMAGED SECTION OF FIBERGLASS TRAILING EDGE AND SPLICED IN NEW SECTION BOTH INBOARD AND OUTBOARD ENDS UNDER SRM 57-03-00.SDR AALA20091221TUL06Longeron · crackedFORWARD CABIN HAS A CRACK AT LONGERON 3 LEFT STATION 160. INSTALLED LONGERON SPLICE AND END FITTING PER SRM 53-02-00 FIGURE 18.SDR AALA20091221TUL05Longeron · crackedFORWARD CABIN HAS A CRACK AT LONGERON 3 LEFT, STATION 200. INSTALLED LONGERON SPLICE AND END FITTING PER SRM 53-02-00 FIG 18.SDR AALA20091221TUL04Longeron · crackedFORWARD CABIN HAS A CRACK AT LONGERON 4 LEFT STATION 200. INSTALLED LONGERON SPLICE PER SRM 53-02-00 FIGURE 18.SDR AALA20091221TUL03Membrane · corrodedCORROSION ON SUB FLOOR STATION 148 AT RIGHT BUTTLINE 8. INSTALLED 7075 T-6 DOUBLER AS PER AARD 53-20-00-16.SDR AALA20091220TUL01Beam · crackedFORWARD ENTRY DOOR NUMBER FIVE BEAM CRACKED IN RADIUS FORWARD SIDE. STOPPED DRILLED AND INSTALLED DOUBLER PER SRM 52-05-00 FIG 31.SDR AALA20091219LGA01Strap · brokenFORWARD UPPER FLASHLIGHT SAFETY STRAP BROKEN. REPLACED SAFETY STRAP.SDR AALA20091218LGA01Strap · missingAFT GALLEY EMERGENCY FLASHLIGHT MISSING SAFETY STRAP. REPLACED SAFETY STRAP AFT GALLEY FLASHLIGHT.SDR AALA20091218TUL21Frame · crackedCRACK IN FRAME STATION 1497 AT 4 O`CLOCK POSITION. INSTALLED DOUBLER PER ENGINEERING AUTHORIZATION 53-008466, DATED 12/18/09.SDR AALA20091218TUL20Longeron · crackedCRACK IN LONGERON 2 LEFT SIDE AT STATION 160. REPLACED LONGERON PER SRM 53-02-00 FIG 18.SDR AALA20091218TUL19Mount Bracket · crackedAFT DOOR, LOWER STOP PAD MOUNT BRACKET IS CRACKED. INSTALLED A NEW PAD MOUNT BRACKET PER ESO 80174.SDR AALA20091217TUL05Shutoff Valve · leakingRIGHT HYDRAULIC QUANTITY WENT TO ZERO UPON RAISING GEAR HANDLE. RETURNED TO ICT AND LANDED WITHOUT INCIDENT. FOUND RUDDER HYDRAULIC SHUT OFF VALVE LEAKING. REPLACED RUDDER HYDRAULIC SHUT OFF VALVE AND RIGHT ENGINE HYDRAULIC DRIVEN PUMP AND CASE DRAIN FILTERSDR AALA20091217TUL04Longeron · crackedLONGERON 3 LEFT CRACKED AT STATION 160. ACCOMPLISHED SPLICE REPAIR UNDER SRM 53-02-00 FIG 18.SDR AALA20091217TUL01Cusp Web · crackedTHREE EACH CRACKS AT LEFT CUSP STATION 218 TO 225. REPLACED CUSP UNDER AARD 53-20-00-16.SDR AALA20091217LGA01Battery Pack · dischargedFIRST CLASS OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091216TUL14Tee Fitting · crackedTEE CORD CRACKED AT STATION 1338 LEFT. REPAIRED PER ENGINEERING AUTHORIZATIONS- MD80-53-007882, MD80-53-007988, MD80-53-008214 AND MD80-53-008309.SDR AALA20091216TUL13Casting · crackedLEFT WING LEADING EDGE FRONT SPAR FRONT SIDE CASTING CRACKED AT STATION XRS 240. NEW CASTING INSTALLED PER SRM 51-30-05.SDR AALA20091215TUL05Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 1244. REPAIRED PER AARD 53-20-00-16.SDR AALA20091215TUL04Frame · crackedAFT FUSELAGE CANT FRAME WEB AT STATION 1463 CRACKED AT LONGERON 18 RIGHT. STOP DRILLED CRACK AND INSTALLED DOUBLER.SDR AALA20091215TUL02Bulkhead · crackedRADOME BULKHEAD CRACKED AT RIGHT UPPER RADOME ALIGNMENT PIN. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-19.SDR AALA20091214TUL10Skin · damagedSKIN DAMAGED AT WATER DRAIN AT STATION 275. REMOVED DAMAGE AND INSTALLED DOUBLER PER SRM 53-04-03 AND DRAWING SG09530002.SDR AALA20091214TUL09Fitting · crackedCRACK ON FORWARD CARGO DOOR AT FORWARD EDGE MIDDLE BRACKET. REMOVED OLD FITTING, DRILLED UP AND INSTALLED NEW FITTING PER ESO 80174.SDR AALA20091214TUL05Pan · crackedRIGHT FORWARD UPPER WINDOW PAN TAB IS CRACKED AT STATION 946. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20091214TUL04Pan · crackedRIGHT FORWARD UPPER WINDOW PAN TAB IS CRACKED AT STATION 927. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20091214TUL02Skin · dentedFOUND 2 DENTS IN SKIN AT STATION 235 BETWEEN LONGERON 18 LEFT AND 17 LEFT. REPAIRED PER SRM 53-04 FIG 12B.SDR AALA20091216TUL02Skin · damagedDURING AUTO LAND RIGHT WING CONTACTED RUNWAY. AIRCRAFT OUT OF SERVICE FOR INSPECTION AND REPAIR. REPLACED NUMBER 5 SLAT AND CENTER SECTION RETRACT CABLE. REPLACED NUMBER 15 SLAT TRACK AND RIGHT OUTBOARD FLAP WEDGE. REPLACED NUMBER 1 AND 2 MAIN LANDING GEARSDR AALA20091212TUL01Tripler · crackedAFT FUSELAGE FRAME 1463 TRIPLER CRACKED AT LONGERON 18 LEFT. REMOVED CRACKED TRIPLER AND INSTALLED NEW REPAIR DOUBLER AND TRIPLER.SDR AALA20091211TUL05Rib · crackedNUMBER 15 LEADING EDGE SLAT RIB SHOWS CRACK INDICATION AT INBOARD SIDE LEFT WING OUTBOARD SLAT. REPLACED CRACKED RIB AT OUTBOARD NUMBER 15 POSITION, LEFT NUMBER 5 SLAT PER ESO 80117.SDR AALA20091211TUL02Longeron · crackedLONGERON 2 LEFT CRACKED AFT OF STATION 1418. INSTALLED LONGERON SPLICE REPAIR PER AARD 53-30-00-2.SDR AALA20091211TUL01Longeron · crackedLONGERON 2 RIGHT CRACKED JUST AFT OF STATION 1418. INSTALLED LONGERON SPLICE REPAIR PER AARD 53-30-00-2.SDR AALA20091211LGA01Light · inoperativeEMERGENCY LIGHT AT SEAT 12D INOPERATIVE. REPLACED LAMP.SDR AALA20091210TUL04Frame · crackedCANT FRAME 1497 CRACKED AT LINE SUPPORT BELOW RIGHT LOUVER BOX. INSTALLED DOUBLER PER EA MD80-53-008359.SDR AALA20091209TUL02Doubler · corrodedINTERNAL DOUBLER AROUND FORWARD LAVATORY SERVICE PANEL CORRODED. INSTALLED FABRICATED REPAIR DOUBLER AND FILLER PER EA MD80-53-008336.SDR AALA20091207TUL01Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091206LGA02Light · inoperativeCABIN OVERHEAD EMERGENCY LIGHT AT SEAT ROW 26 RIGHT INOPERATIVE. RELAMPED OVERHEAD LIGHT AT ROW 26 RIGHT.
Back to Mcdonnell Douglas DC-9-82