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 AALA20110909TUL01Cusp Web · corrodedCORROSION ON RIGHT CUSP AT STATION 1305. INSTALLED NEW RIGHT CUSP SHEET FROM STATIONS 1250 TO 1309 PER AARD 51-10-00-5.SDR AALA20110908LGA01Battery Pack · dischargedCOCKPIT, FORWARD DOORS AND FIRST OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20110908TUL01Cusp Web · corrodedBOTTOM OF LEFT CUSP STATION 1287 HAS HEAVY CORROSION. REMOVED CUSP SHEET FROM STATIONS 1250 TO 1309 AND INSTALLED NEW CUSP SHEET PER AARD 51-10-00-5.SDR AALA20110907TUL07Doubler · damagedDOUBLER AT STATION 239 LONGERONS 17 TO 18 LEFT DAMAGED. INSTALLED NEW DOUBLER, FILLER, FINGER DOUBLER, LOWER FILLER AND EXTERNAL REPAIR STRAP PER SRM 53-04-05 FIGURE 2 SHEET 1.SDR AALA20110907TUL11Longeron · corrodedCORROSION IN CTR OF LONGERON 29 LEFT, STATION 1289. INSTALLED U-CHANNEL PER SRM 53-02-00 FIGURE 19.SDR AALA20110907TUL10Longeron · corrodedCORROSION IN CENTER OF LONGERON 28 LEFT, STATION 1289. INSTALLED U-CHANNEL PER SRM 53-02-00 FIGURE 19.SDR AALA20110907TUL09Frame · corrodedCORROSION ON AFT SIDE OF FRAME, LONGERON 30, STATION 1250. INSTALLED J-ANGLE REPAIR PER AARD 53-10-00-14.SDR AALA20110907TUL06Cusp Web · damagedSMALL HOLE IN RIGHT CUSP STATION 570. ACCOMPLISHED REPAIR PER AARD 53-20-00-16.SDR AALA20110907TUL05Cusp Web · corrodedLEFT CUSP STATION 1144 CORRODED. ACCOMPLISHED REPAIR PER AARD 53-20-00-16.SDR AALA20110907TUL03Cusp Web · corrodedCORROSION ON LEFT CUSP STATION 1164. ACCOMPLISHED REPAIR PER AARD 53-20-00-16.SDR AALA20110907TUL02Cusp Web · crackedCRACK IN LEFT CUSP SHEET STATION 1245. DOUBLER INSTALLED PER AARD 53-20-00-16.SDR AALA20110907TUL01Cusp Web · corrodedCORROSION ON BOTTOM OF LEFT CUSP, STATION 1088. REMOVED CUSP SHEET AND INSTALLED NEW SHEET AT STATIONS 1079 TO 1098 PER BOEING DRAWING SG09530019.SDR AALA20110831TUL04Web · crackedWEBBING CRACKED STATION 208 LONGERON 11 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20110831TUL03Web · crackedWEBBING CRACKED STATION 208 LONGERON 15 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20110831TUL02Floorbeam · damagedFLOOR BEAM DAMAGED, LOWER SIDE, STATION 665, 1 INCH RIGHT OF CENTER LINE. BLENDED OUT DAMAGE ON LOWER SIDE OF FLOOR BEAM AT STATION 665 1 INCH RIGHT OF CENTER LINE AND INSTALLED DOUBLER PER AARD53-20-00-21.SDR AALA20110831LGA01Battery Pack · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 23 TO 26 INOPERATIVE. RESEATED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20110830TUL04Seat Track · corrodedSEAT TRACK NUMBER 3 AT STATION 1201 AT INBOARD FLANGE OUT OF LIMITS. INSTALLED REPAIR PLUG PER SRM 53-05-00 FIGURE 4A.SDR AALA20110829LAS01Line · leakingLAS - CREW REPORTED TAIL COMPARTMENT OVERHEAT LIGHT ILLUMINATED AFTER TAKEOFF. EMERGENCY DECLARED FLIGHT RETURNED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND RIGHT FLOW CONTROL VALVE LINE AND TEMP SENSOR GASKET LEAKING. REPAIRED VALVESDR AALA20110829TUL07Pan · crackedAFT UPPER WINDOW PAN TAB CRACKED RIGHT STATION 1079. INSTALLED NEW DOUBLER PER AARD 53-10-00-25.SDR AALA20110829TUL06Pan · crackedAFT LOWER WINDOW PAN TAB CRACKED RIGHT STATION 1060. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20110829TUL05Pan · crackedAFT UPPER WINDOW PAN TAB CRACKED RIGHT STATION 1060. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20110829TUL03Pan · crackedFORWARD CARGO DOOR PAN CRACKED AT STATION 358. COMPLETED INSTALLATION OF FASTENERS IN THE REPAIR AREA OF THE LOWER CUTOUT SECTION OF THE DOOR PAN OF THE FORWARD CARGO DOOR, AND THE TWO SPLICE DOUBLERS (ONE ON THE FORWARD SIDE AND THE OTHER ON THE AFT SIDE) PESDR AALA20110829TUL02Pan · crackedFORWARD CARGO DOOR PAN CRACKED AT STATION 404. COMPLETED INSTALLATION OF FASTENERS IN THE REPAIR AREA OF THE LOWER CUTOUT SECTION OF THE DOOR PAN OF THE FORWARD CARGO DOOR, AND THE TWO SPLICE DOUBLERS (ONE ON THE FORWARD SIDE AND THE OTHER ON THE AFT SIDE) PESDR AALA20110828MCO01Hydraulic System · overservicedMCO - CREW REPORTED RIGHT HYDRAULIC QUANTITY GAUGE INCREASING TO ABOVE FULL MARK. RIGHT HYDRAULIC PRESSURE REMAINED NORMAL. QRH ACCOMPLISHED AND QUANTITY RETURNED TO NORMAL INDICATION. EMERGENCY DECLARED FLIGHT LANDED MCO WITHOUT INCIDENT. AIRCRAFT REMOVEDSDR AALA20110824PHL02Connector · dirtyPHL - CREW REPORTED HIGH OIL TEMPERATURE ON NUMBER 1 ENGINE INDICATION AND FUEL TEMPERATURE ALSO HIGH. EMERGENCY DECLARED FLIGHT RETURNED PHL LANDED WITHOUT INCIDENT. CLEANED OIL TEMPERATURE CONNECTOR ON NUMBER 1 ENGINE. SYSTEM GROUND CHECK NORMAL OPERATIONSDR AALA20110822DFW03Filter · dirtyDFW - CREW REPORTED LEFT CONSTANT SPEED DRIVE OIL PRESSURE LOW LIGHT FLICKERED ON AND OFF. CREW UNABLE TO START APU. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. UPON DESCENT ABLE TO START APU. AIRCRAFT REMOVED FROM SERVICE. REPLACED CHSDR AALA20110821TUL01Clamp · loosePHX - CREW REPORTED TAIL COMPARTMENT HIGH LIGHT ILLUMINATED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED PHX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. TIGHTENED CLAMP AT CABIN TEMPERATURE CONTROL VALVE. SYSTEM GROUND CHECK NORMAL OPERATSDR AALA20110819DFW02Downlock Sensor · inoperativeDFW - CREW REPORTED UNSAFE INDICATION FOR THE RIGHT MAIN LANDING GEAR. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT MAIN LANDING GEAR DOWN AND LOCK SENSOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110819TUL03Skin · damagedAIRCRAFT DAMAGED BY ELECTRICAL CART. A 12 INCH HOLE IN FUSELAGE SKIN, FORWARD OF LEFT WING ROOT STATIONS 577 TO 597. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-04-00, 12C AND EA MD80-53-018160.SDR AALA20110818DFW01Seal · leakingDFW - (REPEAT ITEM) CREW REPORTED TAIL TEMPERATURE HIGH LIGHT ILLUMINATED DURING CLIMBOUT. ACCOMPLISHED QRH AND LIGHT EXTINGUISHED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED SEALS IN LEFT PACK SISDR AALA20110816ORD01Sensor · inoperativeORD - CREW REPORTED YELLOW GEAR DOOR OPEN LIGHT STAYED ON AFTER TAKEOFF. CYCLED GEAR AND LIGHT REMAINED ON. EMERGENCY DECLARED FLIGHT LANDED ORD WITHOUT INCIDENT. AFTER GEAR EXTENSION FOR LANDING LIGHT WAS STILL ILLUMINATED. AIRCRAFT REMOVED FROM SERVICE. SDR AALA20110815DFW01Clamp · brokenDFW - CREW REPORTED TAIL COMPARTMENT TEMPERATURE OVERHEAT LIGHT ILLUMINATED. ACCOMPLISHED QRH AND LIGHT EXTINGUISHED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CLAMP FROM AIR CYCLE MACHINE TO HESDR AALA20110813AUS01Light · inoperativeEMERGENCY LIGHT AT FIRST OFFICERS GLARESHIELD INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT FIRST OFFICERS GLARESHIELD. OPS CHECK NORMAL.SDR AALA20110812TUL02Skin · dentedDENT ON LEFT SIDE OF FUSELAGE AT THE TOP OF AA OF 586AA. INSTALLED FILLER AND DOUBLER AT STATION 1431 LONGERON 8 LEFT PER SRM 53-04-00 FIGURE 18 SHEET 1 AND 2.SDR AALA20110812DWH01Skin · damagedJETBRIDGE PUNCTURED SKIN OF AIRCRAFT ABOVE FORWARD LAVATORY SERVICE DOOR STATION 256. ACCOMPLISHED DOUBLER REPAIR EA MD80-53-018509.SDR AALA20110808TUL01Skin · dentedTWO DENTS APPROXIMATELY 2 INCHES APART IN FUSELAGE 40 AND 58 INCHES FORWARD OF CENTER CARGO DOOR CUTOUT AND 10 INCHES BELOW RIGHT TURNOFF LIGHT STATION 579 AT LONGERON 22 RIGHT. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLER PER SRM 53-04-03, DWG SG09530002 AND SDR AALA20110806DFW01Fan · faultyDFW - FLIGHT ATTENDANT REPORTED SMELLING SMOKE IN CABIN. PILOT TURNED OFF RECIRCULATION FAN AND SMOKE DISSIPATED. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RECIRCULATION FAN. SYSTEM GROUND CHECK NORMAL SDR AALA20110805TUL02Cusp Web · damagedELONGATED HOLES IN CUSP, UNDER NUMBER 6 SEAT TRACK STATIONS 221 TO 235. INSTALLED CUSP SHEET ON RIGHT SIDE AT STATIONS 218 TO 237 PER AARD 51-10-00-5.SDR AALA20110805TUL01Seat Track · corrodedNUMBER 6 SEAT TRACK CORRODED BEYOND LIMITS AT STATIONS 215 TO 218. INSTALLED NEW SEAT TRACK NUMBER 6 STATIONS 215 TO 265 AND SPLICE AT STATION 265 PER SRM 53-05-00 FIGURE 4F.SDR AALA20110804TUL07Structure · corrodedCORROSION AROUND AFT LAV SERVICE PANEL CUTOUT IN CARGO, STATIONS 1316 TO 1322, LONGERONS 21 TO 22. INSTALLED REPAIR DOUBLER PER EA MD80 53-018439.SDR AALA20110804TUL05Membrane · corrodedCORROSION ON SUBFLOOR UNDER G1 GALLEY DRAIN PAN. INSTALLED G1 GALLEY SUB-FLOOR DOUBLER AARD 53-20-00-16.SDR AALA20110804TUL04Membrane · crackedCABIN FORWARD SUBFLOOR CRACKED AT FASTENER STATIONS 179, 26 INCHES RIGHT OF CENTER LINE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20110804TUL03Tie Down · corrodedCORROSION ON TOP OF RIGHT TIE-DOWN TRACK, STATIONS 1007 TO 1155. INSTALLED NEW TIE-DOWN TRACK PER AARD 51-10-00-5 AND SRM 51-30-01.SDR AALA20110804TUL01Angle · corrodedAFT CARGO CORROSION ON LOWER FORWARD ANGLE IN DOOR CUTOUT FORWARD OF STATION 1155 FRAME. INSTALLED NEW LOWER ANGLE AT STATION 1155 PER SRM 51-30-05.SDR AALA20110808TUL03Skin · gougedGOUGE IN SKIN AT STATION 1406 ABOVE STRINGER 5 RIGHT. INSTALLED DOUBLER AND FILLER PER SRM 53-01-00 FIGURE 2 SHEET 3.SDR AALA20110802ORD02Battery Pack · dischargedEMERGENCY LIGHTS OVER AFT ACCESSORY COMPARTMENT CATWALK INOPERATIVE. REPLACED BATTERY PACK B5-28.SDR AALA20110802TUL01Cusp Web · damagedELONGATED HOLES IN CUSP UNDER NUMBER 6 SEAT TRACK, STATIONS 221 TO 235. REMOVED DAMAGED CUSP, STATIONS 218 TO 237, AND INSTALLED SERVICEABLE CUSP PER AARD 51-10-00-5.SDR AALA20110801DFW05Switch · inoperativeDFW - CREW REPORTED ALL THREE GEAR INDICATED "UNSAFE". EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED GROUND SENSING INTERLOCK SWITCH. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110801TUL06Membrane · corrodedCORROSION ON SUBFLOOR UNDER FIBERGLASS HAT CHANNEL INBOARD OF FORWARD SERVICE DOOR. INSTALLED DIAPHRAM REPAIR DOUBLER AT STATIONS 160 TO 200 RIGHT BUTTLINES 36 TO 56 PER AARD 53-20-00-16.SDR AALA20110731TUL08Mount · corrodedCORROSION ON G1 GALLEY FORWARD MOUNT, 12 INCHES INBOARD OF FORWARD SERVICE DOOR AT STATION 160. INSTALLED NEW GALLEY MOUNT PER AARD 51-10-00-5.
Back to Mcdonnell Douglas DC-9-82