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 AALA20100922DFW01Anti-Ice Valve · faultyDFW - DURING CRUISE THE RIGHT ENGINE COWL ANTI ICE CIRCUIT BREAKER POPPED. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT ENGINE COWL ANTI-ICE VALVE AND L-30 BREAKER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100922TUL01Cusp Web · crackedFORWARD CARGO AT STATION 224 HAS INTERM REPAIR TO 2 AND 1/2 INCH CRACK AT LIGHTENING HOLE ON LEFT CUSP MEMBRANE PER EA MD80-53-006092 PERMANENT REPAIR TO BE ACCOMPLISHED AT OR BEFORE NEXT HEAVY C-CHECK. INSTALLED SERVICEABLE CUSP SHEET PER AARD 53-20-00-16.SDR AALA20100921TUL02Shear Tie · crackedCRACKED SHEAR TIE AT STATION 1437 AND LONGERON 2 LEFT. INSTALLED SERVICABLE SHEAR TIE PER SRM"S 53-05-00, 51-30-05, 51-30-02.SDR AALA20100920AUS01Sensor · out of adjustAUS - CREW REPORTED AFT CARGO DOOR OPEN LIGHT ILLUMINATED AFTER TAKEOFF AND AIRCRAFT WAS HAVING DIFFICULTY PRESSURIZING. EMERGENCY DECLARED RETURNED AUS LANDED WITHOUT INCIDENT. CHECKED AND ADJUSTED AFT CARGO DOOR LIGHT SENSOR. PERFORMED BITE TEST ON BOTH PSDR AALA20100920TUL15Frame · crackedCRACKED FRAME AT STATION 1418 AND LONGERON 2 LEFT. INSTALLED DOUBLER PER AARD 5310-00-15 AND SRM 51-30-05.SDR AALA20100920TUL14Skin · gougedGOUGE FOUND IN SKIN AT STATION 210 LONGERON 19 LEFT. MEASURES .029 DEEP X .025 AFTER BLENDING ACCOMPLISHED. PERFORMED PERMANENT REPAIR PER EA MD80-53-013084 DATED 9/20/2010.SDR AALA20100920TUL12Pan · crackedRIGHT WINDOW PAN CRACKED AT LOWER EAR, AFT OF STATION 807 MARKED. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20100920TUL11Pan · crackedWINDOW PAN CRACKED AT LOWER EAR. REMOVED CRACK INSTALLED DOUBLER REPAIR PER AARD 53-10-00-25.SDR AALA20100920TUL10Pan · crackedRIGHT WINDOW PAN CRACKED AT UPPER EAR. REMOVED CRACK INSTALLED DOUBLER REPAIR PER AARD 53-10-00-25.SDR AALA20100920TUL09Frame · crackedFRAME CRACKED AFT SIDE 1418 LONGERON 2 RIGHT. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-15.SDR AALA20100920TUL08Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE 1451 LONGERON 2 LEFT. INSTALLED NEW SERVICEABLE SHEAR TIE AFT OF STATION 1451 LONGERON 2 LEFT PER SRM 53-30-05.SDR AALA20100920TUL01Diaphragm · corrodedFORWARD CABIN SUBFLOOR IS CORRODED BEYOND LIMITS FROM STATIONS 200 TO 218 JUST AFT OF FORWARD SERVICE DOOR. DOUBLER WAS INSTALLED PER AARD 53-20-00-16.SDR AALA20100919TUL06Support Angle · corrodedCORROSION ON SUPPORT ANGLE AT STATIONS 200 TO 208 RIGHT CUSP LINE. INSTALLED NEW SUPPORT ANGLE AT STATIONS 200 TO 208 RIGHT CUSP PER SRM 51-01-00 AND SRM 51-30-05.SDR AALA20100919TUL05Floorbeam · damagedG-1 GALLEY MOUNT HOLES OVERSIZED AT STATION 160 AT RIGHT BUTTLINE 45 TO 51 THROUGH FLOORBEAM. INSTALLED REPAIR STRAP ON TOP OF FLOORBEAM STATION 160 RIGHT BUTTLINE 42 TO 58 PER EA MD80-53-013020.SDR AALA20100919TUL04Membrane · corrodedCABIN SUBFLOOR IS CORRODED BEYOND LIMITS STATIONS 160 TO 200 INBOARD OF FORWARD SERVICE DOOR. INSTALLED REPAIR DOUBLER AND FACTORY DOUBLER AT STATIONS 160 TO 200 PER AARD 53-20-00-16.SDR AALA20100919TUL03Intercostal · crackedINTERCOSTAL CRACKED BETWEEN FLOORBEAMS STATION 1271 TO 1287 AT CENTER. REPLACED CRACKED INTERCOSTAL PER SRM 51-30-05 AND EA MD80-51-013029.SDR AALA20100919TUL02Cusp Web · corrodedCUSP MEMBRANE AT FORWARD ENTRY AREA, IS CORRODED AT LEFT BUTTLINE 60 FROM STATIONS 160 TO 200. INSTALLED CUSP MEMBRANE PER AARD 53-20-00-16.SDR AALA20100919TUL01Mount · corrodedCABIN GALLEY TIE-DOWN CORRODED AT STATION 218 RIGHT BUTTLINE 10. INSTALLED DOUBLER ON SUBFLOOR PER AARD 53-20-00-16. INSTALLED UPPER G2 GALLEY MOUNT PER SRM 51-30-05.SDR AALA20100918TUL03Cusp Web · crackedFORWARD CARGO AT STATION 224 HAS INTERIM REPAIR TO 2 AND 1/2 IN CRACK AT LIGHTENING HOLE ON LEFT CUSP MEMBRANE PER EA MD80-53-006092 PERMANENT REPAIR TO BE ACCOMPLISHED AT OR BEFORE NEXT HEAVY C CHECK. INSTALLED CUSP SHEET AT STATION 218 TO 237 PER AARD 53-20SDR AALA20100917TUL17Membrane · puncturedSUBFLOOR PUNCTURED STATION 148 RIGHT BUTTLINE 9. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100917TUL16Strap · damagedFORWARD CARGO 2 SCREW GOUGES IN STRUCTURE INBOARD SIDE OF RIGHT TIE DOWN TRACK AT STATION 360 TO 370. REMOVED AND REPLACED STRAP PER SRM 51-10-03.SDR AALA20100917TUL14Shear Tie · crackedAFT ACCS SHEAR TIE CRACKED AFT SIDE OF 1451 AFT OF LONGERON 2 RIGHT. INSTALLED NEW SERVICEABLE SHEAR TIE AFT SIDE OF 1451 FRAME LONGERON 2 RIGHT PER SRM 51-30-05.SDR AALA20100916TUL08Stop Fitting · crackedAFT CARGO DOOR FORWARD EDGE CENTER STOP PAD FITTING CRACKED. REPLACED STOP PER SRM 52-33-00 AND BOEING PRINT NUMBER 5910141 AND INSTALLED STOP FITTING PER SRM 51-01-00.SDR AALA20100915TUL06Seat Track · corrodedNUMBER 4 SEAT TRACK INBOARD FLANGE CORRODED STATION 224. INSTALLED STRAP PER AARD 53-20-00-13.SDR AALA20100915TUL05Stop Fitting · crackedFORWARD CARGO DOOR TOP FORWARD DOOR STOP PAD FITTING CRACKED. INSTALLED NEW DOOR STOP FITTING PER SRM 51-30-00.SDR AALA20100915TUL04Bracket · crackedVAULT DOOR CUTOUT RIGHT LOWER JAMB BRACKET CRACKED. INSTALLED NEW BRACKET PER SRM 51-30-02.SDR AALA20100915TUL03Bracket · crackedVAULT DOOR CUT OUT RIGHT MID JAMB BRACKET CRACKED. INSTALLED NEW BRACKET PER SRM 51-30-02.SDR AALA20100915TUL02Shear Tie · crackedFRAME SHEAR TIE CRACKED AT STATION 237 LEFT BETWEEN LONGERON 17 LEFT AND LONGERON 18 LEFT. INSTALLED FRAME SHEAR TIE AT STATION 237 LEFT PER SRM 51-30-02, SRM 51-30-05 AND ATTACHED EA MD80-51-013003.SDR AALA20100914TUL02Skin · gougedDEEP GOUGE IN SKIN BELOW CUSP LINE AT STATION 229.7. INSTALLED DOUBLER, FILLER AND FINGER DOUBLER PER SRM 53-04-00 FIGURE 12B.SDR AALA20100914TUL05Bracket · crackedVAULT DOOR CUTOUT RIGHT TOP JAM BRACKET CRACKED. INSTALLED NEW BRACKET PER SRM 51-30-02.SDR AALA20100914TUL04Seat Track · corrodedSEAT TRACK NUMBER 3 OUT OF LIMITS AT STATION 1304. INSTALLED NEW NUMBER 3 SEAT TRACK SECTION STATIONS 1262 TO 1304 AND SPLICE AT STATION 1262 AS PER SRM 53-05-00 FIGURE 4F.SDR AALA20100914TUL03Longeron · crackedLONGERON 5 LEFT STATION 1309 HAS CRACKS AFT SIDE. INSTALLED LONGERON SPLICE REPAIR PER SRM 53-02-00.SDR AALA20100914LGA01Battery Pack · dischargedEMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CABIN. OPS CHECK NORMAL.SDR AALA20100913TUL12Support · crackedRIGHT MAIN LANDING GEAR WHEEL WELL - GREEN BRACKET CRACKED AT TOP OF WHEEL WELL DOOR ACTUATOR. REMOVED AND INSTALLED SERVICEABLE SHELF ABOVE RIGHT MAIN LANDING GEAR DOOR ACTUATOR PER SRM 51-30-5.SDR AALA20100913TUL10Bracket · crackedVAULT DOOR CUTOUT MID-JAMB BRACKET CRACKED LEFT SIDE. REMOVED AND REPLACED BRACKET PER SRM 51-01-00.SDR AALA20100913TUL09Window Frame · crackedLEFT WINDOW FRAME BETWEEN STATIONS 1022 AND 1003 AFT TOP CRACKED MARKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100912TUL01Pump · malfunctionedJFK - INFLIGHT ORD-LGA. CREW REPORTED LEFT HYDRAULIC PRESSURE LOSS. EMERGENCY DECLARED DIVERTED JFK LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE DRIVEN PUMP, SPOILER SHUT-OFF VALVE AND TRANSFER PUMP. SYSTEM GROUND CHECKED NSDR AALA20100910DFW01Engine · malfunctionedDFW - DURING CLIMBOUT WITH ENGINE PRESSURE RATIO AT 1.8 LEFT ENGINE POWER FELL OFF AND TEMPERATURE SPIKED. WHILE PERFORMING QHR PROCEDURE POWER SUDDENLY CAME BACK UP AND TEMPERATURE DROPPED TO NORMAL. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT RESDR WX0A070603Battery Pack · inoperativeIT HAS BEEN REPORTED BY THE FLIGHT CREW, THE EMERGENCY EVACUATION LIGHTING SYSTEM HAS BEEN FOUND TO BE DEFECTIVE. MX R & R THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERY PACK AND MADE ALL REQUIRED CORRECTIONS. OPS CHECK WAS ACCOMPLISHED IAW AMM 33-50-0SDR AALA20100910TUL08Skin · damagedDENT AND GOUGE STATION 218 LONGERON 17 LEFT. GOUGE BLENDED OUT WITHIN LIMITS PER SRM 53-04-00 FIG 38 SHEET 3 CONDITION 1. COLD WORKED DENT, DYE CHECKED, NO CRACKS FOUND PER SRM 53-04-00 FIGURE 38 SHEET 11. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 38 SHEET SDR AALA20100910TUL07Skin · dentedDENT IN SKIN AT STATION 237 BETWEEN LONGERON 16 LEFT AND LONGERON 17 LEFT. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 38 SHEET 30 VIEW P.SDR AALA20100908LAX01Switch · faultyON INITIAL APPROACH TO LAX THE CREW DROPPED THE GEAR AND ALL THREE INDICATORS FOR THE LANDING GEAR SHOWED RED. SECOND ATTEMPT AT PUTTING THE GEAR DOWN HAD SAME RESULTS AND GO AROUND WAS MADE. ON THIRD ATTEMPT THE HANDLE WAS PLACED DOWN AND THIS TIME THE NOSESDR AALA20100908LGA01Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE AROUND ROWS B-23. REMOVED AND REPLACED BATTERY PACK.SDR AALA20100907TUL08Skin · damagedSTATIC BURNS IN FUSELAGE SKIN AT STATIONS 337 TO STATION 345 ABOVE AND BELOW LONGERON 10 LEFT. INSTALLED DOUBLER PER SRM 53-04-02 AND DWG SG05930001.SDR AALA20100905LGA01Battery Pack · dischargedEMERGENCY CEILING LIGHTS AT ROWS 3 TO 6 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY CEILING LIGHT AT ROWS 3 TO 6. OPS CHECKED NORMAL.SDR RYNA2010009020028Warning System · malfunctionedUPON TAXI OUT HAD ELEVATOR POWER ON ON LIGHT REMAIN ON. PLACE LIGHT INOP PER MEL 27-14 CAT C DDD 9/11/10 DMI 1165 ISSUED BY MXC.SDR WX0A070596Battery · 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 AALA20100830DFW05Boot · looseDFW - CREW REPORTED ON CLIMBOUT THE TAIL COMPARTMENT OVERHEAT LIGHT ILLUMINATED. EMERGENCY DECLARED RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LEFT AIR CYCLE MACHINE BOOT OFF AND CLAMP LOOSE. RE-INSTALLED BOOT AND RESECURED SDR WX0A070595Battery · 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 WX0A070594Battery · 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 BATTER
Back to Mcdonnell Douglas DC-9-82