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 AALA20090309TUL03Battery Pack · dischargedFORWARD AISLE BATTERY PACK HAS VERY LOW OUTPUT. INSTALLED SERVICEABLE BATTERY PACK AND ACCOMPLISHED OPERATIONAL CHECK PER M/M 33-60-98-4.SDR AALA20090304TUL17Shear Tie · crackedCRACK IN SHEAR TIE AT STATION 1437 LONGERON 16L-17L. REMOVED AND REPLACED SHEAR TIE PER SRM 51-01-00.SDR AALA20090304TUL16Battery Pack · dischargedEXTERNAL OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AND PERFORMED OPERATIONS PER M/M 33-53-00-4.SDR AALA2009030400546Light · defectiveLGA EMERGENCY LIGHT BY LEFT NUMBER 1 DOOR WILL NOT SHUT OFF. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT BY LEFT NUMBER ONE DOOR.SDR AALA2009030400535Battery Pack · dischargedLGA - EMERGENCY LIGHT AT ROW DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT ROW DEF.SDR AALA20090626TUL01Shear Tie · crackedSHEAR CRACKED AT STATION 1437, LONGERON 16L. INSTALLED SERVICEABLE SHEAR TIE PER SRM 51-01-00.SDR AALA20090313TUL06Beam · crackedFWD ENTRY DOOR SECOND FROM TOP HORIZONTAL BEAM CRACKED IN RADIUS AT FWD END. INSTALLED DOUBLER PER SRM 52-05-00 FIGURE 31.SDR AALA20090305TUL01Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK IS INOPERATIVE. REMOVED AND REPLACED UNSERVICEABLE BATTERY PACK AND OPERATIONAL CHECK GOOD PER M/M 33-53-00-6 AND WORK CARDS 4289 AND 4854.SDR AALA20090304TUL21Battery Pack · dischargedESCAPE PATH LIGHTING BATTERY PACK WEAK. REPLACED BATTERY PACK WITH SERVICEABLE UNIT AND OPERATIONAL CHECK PER M/M 33-60-98-4 AND WORK CARDS 4289 AND 4854.SDR AALA20090304TUL20Battery Pack · dischargedESCAPE PATH LIGHTING BATTERY PACK WEAK. REPLACED BATTERY PACK WITH SERVICEABLE UNIT AND OPERATIONAL CHECK GOOD PER M/M 33-60-98-4 AND WORK CARDS 4289 AND 4854.SDR AALA20090304TUL19Battery Pack · dischargedESCAPE PATH BATTERY PACK WEAK. REPLACED BATTERY PACK WITH SERVICEABLE UNIT, OPERATIONAL CHECK GOOD PER M/M 33-60-98-4 AND WORK CARDS 4289 AND 4854.SDR AALA20090304TUL18Battery Pack · dischargedESCAPE PATH BATTERY PACK IS WEAK. REPLACED BATTERY PACK AND OPS CHECKED PER M/M 33-60-98-4.SDR AALA20090304TUL15Battery Pack · dischargedAFT FLIGHT ATTENDANT SEAT AT AFT SERVICE DOOR, EMERGENCY LIGHT BATTERY WEAK. REPLACED BATTERY PACK FOR AFT SERVICE DOOR EMERGENCY LIGHT.SDR AALA20090304TUL14Battery Pack · inoperativeEMERGENCY BATTERY PACK INOPERATIVE AT STATION 211 CENTER. REPLACED BATTERY PACK, OPERATIONAL CHECK GOOD.SDR WX0A070280Battery Pack · inoperativeDURING 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 AALA20090304TUL13Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2R. DOUBLER INSTALLED PER SRM 53-01 FIGURE 2 AND EA MD80-53-005611.SDR AALA20090304TUL12Longeron · crackedLONGERON 2R IS CRACKED AFT OF STATION 1418. INSTALLED REPAIR PER AARD 53-30-00-2.SDR AALA20090304TUL10Bulkhead · crackedCRACK IN BULKHEAD SKIN AT RIGHT BOTTOM ALIGNMENT PIN FOR RADOME, STATION 37. INSTALLED DOUBLER PER AARD 53-10-00-19.SDR AALA20090304TUL09Frame · crackedCANT FRAME AT STATION 1510 CRACKED ABOVE MAINTENANCE LIGHT. INSTALLED DOUBLER PER EA MD80-53-00-5606.SDR AALA20090313TUL09Bolt · spunIDLER HINGE BOLT ON LEFT FLAP AT STATION 333.148 ROTATED/BORE WORN. REPAIRED PER AARD 57-40-00-1.SDR AALA20090304TUL11Frame · crackedCANTED FRAME CRACKED BELOW MAINTENANCE LIGHT SWITCH AT STATION 1510. INSTALLED DOUBLER PER EA MD80-53-00-5606.SDR AALA2009022700529Lamp · shortedLGA - SEAT MOUNTED EMERGENCY LIGHTS FROM SEAT 21 ALL THE WAY AFT INOPERATIVE. REPLACED SHORTED LAMP AT 23DEF.SDR AALA2009022600527Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT SEAT 21 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT 21.SDR WX0A070277Battery Pack · inoperativeDURING 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 AALA20090317TUL12Skin · dentedTWO DENTS FORWARD OF FORWARD ENTRY DOOR JUST ABOVE LONGERON 19L AT STATION 133. INSTALLED DOUBLER PER SRM 53-04-00 AND EA MD80-53-00-5267.SDR WX0A070276Battery Pack · inoperativeDURING 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 AALA2009022400521Lamp · burned outDFW - TAIL COMPARTMENT SLIDE LIGHT INOPERATIVE. REPLACED LAMP FOR TAIL COMPARTMENT SLIDE LIGHT.SDR AALA2009022400520Lamp · burned outDFW - EMERGENCY PATH LIGHTING ON AFT GALLEY CEILING PANEL INOPERATIVE. REPLACED LAMPS FOR EMERGENCY PATH LIGHTING ON AFT GALLEY CEILING PANEL.SDR AALA2009022400519Lens · wrong partDFW - SEAT 21D HAS WRONG COLOR LENS ON EMERGENCY PATH LIGHTING. REPLACED LENS ON SEAT 21D FOR EMERGENCY PATH LIGHTING.SDR AALA2009022400518Lens · missingDFW - EMERGENCY PATH LIGHTING LENS FROM SEAT 7D MISSING. REPLACED LENS FOR EMERGENCY PATH LIGHTING AT SEAT 7D.SDR AALA2009022400517Lamp · burned outLGA - EMERGENCY LIGHT AT SEAT 27D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 27D.SDR AALA2009022200509Battery Pack · dischargedLGA - FORWARD GALLEY EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK AT FORWARD GALLEY.SDR AALA20090226TUL13Cusp Web · corrodedCORROSION ON BOTTOM SURFACE OF RIGHT CUSP MEMBRANE, INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20090226TUL14Frame · crackedFRAME CRACKED AT LONGERON FASTENER HOLES AFT SIDE OF STATION 1418, INSTALLED FRAME DOUBLER PER ENGINEERING AUTHORIZATION NR MD80-53-005548.SDR AALA20090226TUL12Longeron · crackedLONGERON L2R CRACKED AFT OF STATION 1418, INSTALLED REPAIR SPLICE PER AARD 53-30-00-2.SDR AALA2009021900499Battery · not seatedLGA AFT AISLE OVERHEAD EMERGENCY LIGHT AT AFT LAVATORY INOPERATIVE. RESEATED BATTERY IN PACK FOR EMERGENCY LIGHT AT AFT AISLE OVERHEAD AT AFT LAVATORY.SDR AALA2009021900498Battery Pack · dischargedPHX - FORWARD OVERWING EXIT DOOR LIGHTS FAILED TO ILLUMINATE DURING TEST. REPLACED BATTERY PACK FOR FORWARD OVERWING EXIT DOOR.SDR AALA20090226TUL16Longeron · crackedLONGERON CRACKED AFT OF STATION 1418 AT L2L, INSTALLED LONGERON SPLICE PER AARD 53-30-00-2.SDR AALA2009021700200Stop Fitting · crackedAFT CENTER STOP FITTING CRACKED ON MID CARGO DOOR, REPLACED AFT CENTER FITTING PER ESO 80174.SDR AALA2009021700184Casting · crackedRIGHT GROUND SPOILER CASTING IS CRACKED ON OTBD SIDE. INSTALLED SERVICEABLE GROUND SPOILER CASTING PER AARD 57-20-00-15.SDR AALA2009021600203Longeron · crackedLONGERON 2 RIGHT CRACKED AFT OF STATION 1418, INSTALLED LONGERON REPAIR SPLICE PER AARD 53-30-00-2 FIGURE 1, SHEET 1.SDR AALA2009021500493Light · brokenLGA - EMERGENCY LIGHT AT SEAT 14D INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 14D.SDR AALA2009021400742Strap · brokenLGA FORWARD UPPER EMERGENCY FLASHLIGHT SAFETY STRAP BROKEN. REPLACED SAFETY STRAP FOR FORWARD UPPER EMERGENCY FLASHLIGHT.SDR AALA2009021400489Battery · dischargedLGA FORWARD UPPER EMERGENCY FLASHLIGHT BATTERY LOW. REPLACED BATTERY FOR FORWARD UPPER EMERGENCY FLASHLIGHT.SDR AALA2009021400488Battery Pack · dischargedLGA AFT EMERGENCY EXIT PATH LIGHTING INOPERATIVE. REPLACED BATTERY PACK AT AFT EMERGENCY EXIT.SDR AALA2009021400487Lens · damagedTUL EMERGENCY PATH LIGHTING AT SEAT 26D IS DAMAGED. REPLACED LENS FOR EMERGENCY PATH LIGHTING AT SEAT 26D.SDR AALA2009021400486Shroud · damagedTUL EMERGENCY PATH LIGHTING AT SEAT 26D IS DAMAGED. REPLACED SHROUD AT SEAT 26D.SDR AALA2009021400485Light · damagedTUL EMERGENCY PATH LIGHTING AT SEAT 26D IS DAMAGED. REPLACED LAMPS AT SEAT 26D.SDR AALA2009021400186Attach Fitting · wrong partCARGO DOOR UPPER AFT T CLIP WRONG TYPE. REPLACED T CLIP PER ESO K3250AESDR AALA2009021400185Attach Fitting · wrong partCARGO DOOR UPPER FWD T CLIP WRONG TYPE. REPLACED UPPER FWD T CLIP PER ECO K3250AE.
Back to Mcdonnell Douglas DC-9-82