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 AALA20090605TUL09Cusp Web · crackedCRACK IN LEFT CUSP. REMOVED AND REPLACED CUSP SHEET PER SRM 53-01 FIG 1.SDR AALA2009052700971Battery Pack · dischargedSTL - FORWARD EXIT LIGHTS DO NOT TEST, NEW BATTERIES NO HELP. REPLACED FORWARD BATTERY PACK.SDR AALA2009052600001Outflow Valve · inoperativeDFW - NEITHER PRESSURIZATION SYSTEM WOULD MAINTAIN PRESSURE DURING CLIMBOUT. RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED THE OUTFLOW VALVE ACTUATOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090618TUL10Fitting · crackedSKIN TO WEB T-ANGLE AT LOWER FORWARD STOP PAD SUPPORT FITTING CRACKED. INSTALLED NEW FITTING PER ESO 80174.SDR AALA20090618TUL09Angle · crackedSKIN TO WEB T-ANGLE AT LOWER AFT STOP PAD SUPPORT FITTING CRACKED. INSTALLED NEW FITTING PER ESO 80174.SDR AALA20090618TUL08Pan · crackedAFT CARGO DOOR PAN IS CRACKED AT LOWER FORWARD STOP. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 52-03-00 FIG 8 SHEET 4.SDR AALA20090605TUL43Seat Track · corrodedNUMBER 6 SEAT TRACK CORRODED. INSTALLED NEW NUMBER 6 SEAT TRACK PER AMM 53-40-01-2.SDR AALA20090605TUL41Strap · gougedSCREW GOUGE IN TOP OF STRAP AT STATION 1148 INBOARD OF RIGHT TIE DOWN TRACK. REMOVED AND REPLACED STRAP PER SRM 51-30-05.SDR AALA20090605TUL34Angle · crackedCRACK IN MID CARGO LOWER OUTBOARD T-ANGLE. REMOVED CRACKED T-ANGLE AND INSTALLED NEW T-ANGLE PER ESO 80174 IN SHOP.SDR AALA20090605TUL14Bracket · corrodedCORROSION ON ANGLE BRACKET AT LOWER CORNER OF CARGO DOOR CUTOUT. REMOVED AND REPLACED BRACKET PER SRM 51-30-05.SDR AALA20090605TUL12Mount · wornG1 GALLEY FORWARD OUTBOARD MOUNT WORN. REMOVED AND REPLACED GALLEY MOUNT PER SRM 51-01.SDR AALA20090605TUL11Mount · corrodedG1 GALLEY FORWARD INBOARD TIE DOWN FITTING CORRODED. REMOVED AND REPLACED GALLEY MOUNT PER SRM 51-01.SDR AALA20090624TUL04Window Frame · crackedLEFT WINDOW PAN FRAME IS CRACKED AT TOP FORWARD CORNER STATION 946. INSTALLED DOUBLER PER AARD 53-10-00-25 LEFT WINDOW PAN TOP FORWARD CORNER STATION 946.SDR AALA20090624TUL03Window Frame · crackedLEFT WINDOW PAN FRAME IS CRACKED AT FORWARD LOWER CORNER STATION 845. INSTALLED ANGLE REPAIR AT FORWARD LOWER LEFT CORNER OF WINDOW PAN AT STATION 845 AS PER AARD 53-10-00-25.SDR AALA20090624TUL02Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 1301 BETWEEN SEAT TRACKS 5 AND 6. INSTALLED RIGHT CUSP SHEET AT STATIONS 1250 AND 1309 PER AARD 53-20-00-16.SDR AALA20090624TUL01Longeron · crackedLONGERON 2 RIGHT CRACKED AFT OF STATION 1418. ACCOMPLISHED SPLICE REPAIR PER AARD 53-30-00-2.SDR AALA20090609TUL35Seat Track · corrodedSEAT TRACK NR 5 CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK PER SRM 53-40-01-2SDR AALA20090605TUL46Cusp Web · corrodedCORROSION ON CUSP UNDER GIRT BAR FITTING AT AFT DOOR SERVICE FORWARD FITTING. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090605TUL45Pan · crackedWINDOW PAN IS CRACKED AT LOWER FORWARD CORNER LEFT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009052500967Light · not seatedEWR - RIGHT AISLE FORWARD ENTRY EMERGENCY LIGHTS ON INTERMITTENTLY. RESEATED FORWARD REMOVABLE EMERGENCY LIGHT UNIT.SDR AALA2009052400001Pump · inoperativeDFW - RIGHT HYDRAULIC PRESS DECLINED TO ZERO FOLLOWED BY RIGHT HYDRAULIC PRESS LOW LIGHT AND RUDDER MANUAL LIGHT CAME ON. RETURNED DFW WITHOUT INCIDENT. REPLACED RIGHT ENGINE HYDRAULIC PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090609TUL40Cusp Web · damagedHEAVY CABIN CORROSION ON CUSP UNDER GIRT BAR FITTING AT AFT SERVICE DOOR AFT FITTING. REMOVED CORROSION PER SRM 51-10-3, INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090609TUL36Cusp Web · corrodedRIGHT CUSP CORRODED. INSTALLED DOUBLER PER SRM 53-20-00-16.SDR AALA2009052400966Light · inoperativeLGA - LEFT NUMBER 1 DOOR EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 1 DOOR EXIT LIGHT.SDR AALA2009052400962Battery Pack · dischargedLGA - CEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. REPLACED BATTERY PACK AT ROW 29.SDR AALA2009052300957Light · defectiveLGA - LEFT NUMBER ONE DOOR EMERGENCY LIGHT WILL NOT SHUT OFF. REPLACED LEFT NUMBER ONE DOOR EMERGENCY LIGHT ASSEMBLY.SDR AALA2009052200002Placard · missingLGA PUSH PLACARD MISSING FROM TAIL CONE JETTISON PANEL AFT LEFT SIDE FUSELAGE. INSTALLED PUSH PLACARD.SDR AALA20090609TUL34Cusp Web · crackedRIGHT CUSP SHEET CRACKED BELOW NR 6 SEAT TRACK. INSTALLED DOUBLER FROM STA 882-887 PER AARD 53-20-16.SDR AALA20090618TUL05Stop Fitting · crackedHFEC INDICATES CRACKS ON 3 EACH STOP BRACKETS OF MID CARGO. REPLACED 3 EACH STOP BRACKETS PER ESO 80174.SDR AALA20090609TUL38Cusp Web · crackedLEFT CUSP CRACKED. ROUTED OUT CRACK AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA2009052100955Light · inoperativeLGA EMERGENCY SEAT PATH LIGHTS AT ROW 30DEF INOPERATIVE. REPLACED LAMP FOR EMERGENCY SEAT PATH LIGHTS AT ROW 30DEF.SDR AALA2009052100954Battery Pack · dischargedLGA CEILING EMERGENCY LIGHTS AT ROW 17 TO 22 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS AT ROW 17 TO 22.SDR AALA2009052000003Gearbox · crackedMEM - INFLIGHT DFW-LGA. LEFT ENGINE HAD INFLIGHT SHUTDOWN WHILE IN CRUISE. SINGLE ENGINE TIME 25 MINUTES. EMERGENCY DECLARED, LANDED MEM WITHOUT INCIDENT. INSPECTED AND FOUND LEFT ENGINE GEARBOX ASSEMBLY CRACKED. REPLACED NUMBER ONE ENGINE ON MAY 22,2009 SDR AALA2009052000002Oil System · leakingCMH - CREW REPORTED SMOKE IN CABIN. RETURNED CMH WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND AUXILIARY POWER UNIT LEAKING OIL AND EVIDENCE OF OIL INGESTION INTO APU INLET. ACCOMPLISHED MCM CARD 21-96-01 AND MCM CARD 21-92-12. SYSTEM GROUND CHECSDR AALA20090609TUL46Seat Track · corrodedSEAT TRACK NR 4 HAS CORROSION. INSTALLED SEAT TRACK PLUG AS PER AARD 53-20-00-10.SDR AALA20090609TUL42Seat Track · corrodedCORROSION ON SEAT TRACK NR 5 BEYOND LIMITS. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090609TUL41Seat Track · corrodedCORROSION BEYOND LIMITS ON SEAT TRACK NR 5. INSTALLED PLUG PER AARD 53-20-00-10.SDR AALA20090609TUL33Vane · damagedTEMP REPAIR ON L/E OF VANE. INSTALLED HOT BOND REPAIR ON DAMAGED AREA PER ESO8OO95.SDR AALA2009052000949Portable Light · inoperativeLGA PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT.SDR AALA2009051900001Indication Sys · no indicationSAT - NOSE GEAR DOWN SAFE LIGHT FAILED TO ILLUMINATE. FLIGHT ACCOMPLISHED A FLY BY OF TOWER. EMERGENCY DECLARED, LANDED SAT WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. INSPECTED NOSE GEAR D1-32 SENSOR AND ACCOMPLISHED BITE TEST ON PSEU NO FAULTS. SYSSDR AALA20090609TUL51Doubler · damagedTEMP REPAIR INOPERATIVE. REMOVED OLD TEMP REPAIR AND INSTALLED PERMANENT REPAIR AS PER SRM 53-04 FIG 38.SDR AALA2009051800002Slide · dislodgedSTL LEFT NUMBER ONE DOOR FELL OUT OF HOUSING. REMOVED AND REPLACED LEFT NUMBER ONE DOOR SLIDE.SDR AALA2009051800001Sense Line · looseAMA - INFLIGHT ABQ-DFW. AIRCRAFT LOST PRESSURIZATION, MASKS DID NOT DROP. EMERGENCY DECLARED, LANDED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND AIR CONDITIONING PILOT PRESSURE REGULATOR SENSE LINE LOOSE AT RIGHT A/C PACK. RE-SECURED SENSE SDR AALA2009051800947Guard · brokenLGA EMERGENCY LIGHT GUARD BROKEN AT SEAT 15D. REPLACED GUARD FOR EMERGENCY LIGHT AT SEAT 15D.SDR AALA2009051800946Guard · missingLGA EMERGENCY LIGHT GUARD MISSING AT SEAT 16D. REPLACED GUARD FOR EMERGENCY LIGHT AT SEAT 16D.SDR AALA2009051800945Lens · missingLGA EMERGENCY LIGHT LENS MISSING AT SEAT 16D. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 16D.SDR AALA2009051700943Battery Pack · dischargedSTL AFT EXIT LIGHTS DIM IN AFT SECTION. REPLACED BATTERY PACK FOR EXIT LIGHTS IN AFT SECTION.SDR AALA2009051700942Battery Pack · dischargedSTL FORWARD EXIT LIGHTS UP TO ROW 20 INOPERATIVE. REPLACED BATTERY PACK.SDR AALA2009051600001Proximity Sensor · inoperativeLGA - FLIGHT ABORTED TAKEOFF ON ACCOUNT OF MID CARGO DOOR LIGHT ILLUMINATION. RETURNED LGA WITHOUT INCIDENT. REPLACED PROXIMITY SENSOR AND ADJUST. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA2009051600936Battery Pack · dischargedLGA COCKPIT OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED FORWARD CABIN EMERGENCY LIGHT BATTERY PACK.
Back to Mcdonnell Douglas DC-9-82