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 AALA2009032200001Slide · looseEWR - SLIDE PACKAGE IN FORWARD GALLEY SERVICE DOOR CAME LOOSE. SLIDE DID NOT DEPLOY. REPLACED RIGHT NUMBER 1 DOOR SLIDE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090406TUL35Cusp Web · damagedLEFT CUSP SEVERELY RIPPLED STATION 769-788. INSTALLED NEW CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL28Cusp Web · corrodedCORROSION ON RIGHT CUSP STATION 160-175. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL27Cusp Web · damagedHOLE IN CUSP APPROXAMATELY .375 INCH IN DIAMETER AT STATION 864 RIGHT SIDE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA2009032200980Slide · unserviceableDFW - LEFT NUMBER 2 DOOR EMERGENCY SLIDE HAS WORN VELCRO ON GIRT ASSEMBLY. INSTALLED NEW LEFT NUMBER 2 DOOR EMERGENCY SLIDE.SDR AALA2009032200979Slide · unserviceableDFW - LEFT NUMBER 1 DOOR EMERGENCY SLIDE HAS WORN VELCRO ON GIRT ASSEMBLY. INSTALLED NEW LEFT NUMBER 1 DOOR EMERGENCY SLIDE.SDR AALA2009032200633Battery Pack · dischargedLGA - EMERGENCY LIGHTS FOR ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 20.SDR AALA2009032100004Control Box · inoperativeDURING TAXI BRAKES FAILED. REPLACED ANTI-SKID MAIN LANDING GEAR WHEEL BRAKE CONTROL BOX.SDR AALA2009032100003Fan · malfunctionedSTL - DURING DESCENT CREW REPORTED SMOKE SMELL IN CABIN. EMERGENCY DECLARED, LANDED STL WITHOUT INCIDENT. REPLACED RECIRCULATION FAN. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090406TUL32Cusp Web · corrodedRIGHT CUSP CORRODED AT STATION 219. INSTALLED CUSP SHEET PER SRM 53-01.SDR AALA20090406TUL23Cusp Web · corrodedCORROSION ON RIGHT CUSP STATION 1304-1309. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA2009032100624Battery Pack · not seatedLGA - EMERGENCY LIGHT AT ROW 18 INOPERATIVE. RESEATED ROW 18 BATTERY PACK.SDR AALA2009032100623Battery Pack · dischargedLGA - FIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EMERGENCY LIGHTS.SDR AALA2009032100621Portable Light · inoperativeLGA - FORWARD ENTRY PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT AT FORWARD ENTRY.SDR AALA2009032100620Light · missingTPA CLEAR EMERGENCY PATH LIGHT AT SEAT 19D MISSING LAMP. REPLACED LAMP FOR CLEAR EMERGENCY PATH LIGHT AT SEAT 19D.SDR AALA2009032100619Lens · missingTPA CLEAR EMERGENCY PATH LIGHT AT SEAT 19D MISSING LENS. REPLACED LENS FOR CLEAR EMERGENCY PATH LIGHT AT SEAT 19D.SDR AALA2009032000001Pump · inoperativeDFW - CAPTAIN REPORTED, COULD NOT USE FUEL IN CENTER TANK. RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CENTER TANK AFT TRANSFER BOOST PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090406TUL39Mount · corrodedNR 2 GALLEY INBOARD MOUNT FORWARD END AT STATION 200 CORRODED. REMOVED AND REPLACED GALLEY MOUNT PER SRM 51-01.SDR AALA20090406TUL25Frame · gougedWEB GOUGED IN CANTED FRAME AT STATION 1338. INSTALLED DOUBLER PER SRM 51-70-04 FIGURE 2 SHEET 2.SDR AALA20090409TUL03Support · crackedABOVE CENTER FUEL TANK STA 927, FLOORBEAM SUPPORT CRACKED LEFT SIDE. REPLACED SUPPORT PER SRM 51-00-01.SDR AALA20090409TUL01Stiffener · wornSTIFFENER WORN ON CANTED FRAME AT STATION 1338. REMOVED AND REPLACED STIFFENER PER SRM 51-30-05.SDR AALA20090331TUL55Angle · brokenATTACH ANGLE INSIDE DOOR BEAM, AFT END BROKEN. REMOVED AND REPLACED ATTACH ANGLE PER SRM 51-10-00-3.SDR AALA20090331TUL51Beam · corrodedAFT CARGO DOOR CORROSION ALONG DOOR BEAM STATION 1158-1160 AND 1203-1206. INSTALLED FULL LENGTH DOUBLER PER AARD 53-10-00-3.SDR AALA20090331TUL37Pan · crackedCRACK ON UPPER FORWARD CORNER OF PAN ON FORWARD CARGO DOOR. INSTALLED REPAIR DOUBLER PER SRM 52-03-00.SDR AALA20090324TUL03Casting · crackedRIGHT GROUND SPOILER CASTING CRACKED. INSTALLED NEW GROUND SPOILER CASTING PER SRM 51-10.SDR AALA20090406TUL34Cusp Web · corrodedCORROSION ON TOP OF LEFT CUSP STATION 503-522. INSTALLED DOUBLER PER SRM 53-20-00-16.SDR AALA20090406TUL31Cusp Web · corrodedCORROSION ON BOTTOM OF RIGHT CUSP AT STATION 1219. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL26Cusp Web · corrodedCORROSION ON BOTTOM OF LEFT CUSP BETWEEN STATIONS 712-731. INSTALLED NEW CUSP SHEET FROM STATION 712-788 PER SRM 51-10-3 AND 53-01 FIGURE 1.SDR AALA20090406TUL24Angle · corrodedCUSP T-ANGLE TANG AT STATION 200 RIGHT SIDE CORRODED. INSTALLED CUSP ANGLE SPLICE REPAIR PER SRM 53-05-00 FIGURE 55 SHEET 2.SDR AALA20090406TUL22Cusp Web · crackedCRACK IN LIGHTNING HOLE ON CUSP MEMBRANE AT STATION 451 LEFT SIDE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL21Fitting · corrodedAFT SERVICE DOOR, FORWARD GIRT BAR FITTING CORRODED ON TOP AT STATION 1142. REMOVED AND REPLACED FORWARD GIRT BAR FITTING PER SRM 51-01.SDR AALA20090406TUL17Frame · corrodedCORROSION ON FRAME 1250 LOWER FLANGE LONGERON 29L-29R IN AFT CARGO. INSTALLED REPAIR SPLICE PER SRM 53-03-02A SHEET 5.SDR AALA20090406TUL15Seat Track · wornNR 6 SEAT TRACK WORN BEYOND LIMITS. INSTALLED SEAT TRACK PLUG PER SRM 53-05-00.SDR AALA20090406TUL14Cusp Web · corrodedCORROSION ON LEFT CUSP AT STATION 480. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL13Cusp Web · corrodedLEFT CUSP CORRODED STATION 1163-1168 AT AFT SERVICE DOOR. REPAIRED PER AARD 53-20-00-16.SDR AALA20090401TUL01Cusp Web · crackedRIGHT CUSP HAS A CRACK JUST AFT OF STATION 218. INSTALLED NEW CUSP SHEET STATION 218-237 PER AARD 53-20-00-16.SDR AALA20090331TUL49Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1451, LONGERON 2R. REPLACED SHEAR TIE PER SRM 51-30-00.SDR AALA20090331TUL48Cusp Web · corrodedCORROSION ON CUSP IN THE LEFT TUNNEL STATION 554. INSTALLED CUSP DOUBLER FROM STATION 541-560 PER AARD 53-20-00-16.SDR AALA20090331TUL47Bracket · corrodedCORROSION ON CORNER ANGLE BRACKET STATION 1155, LONGERON 25R-27R. REPLACED BRACKET PER AARD 53-10-00-3.SDR AALA20090331TUL45Longeron · crackedLONGERON 2L CRACKED AFT OF STATION 1418. REMOVED DAMAGED SECTION AND INSTALLED LONGERON AND SPLICE PER AARD 53-30-00-2.SDR AALA20090331TUL44Longeron · crackedLONGERON 2R CRACKED AFT OF STATION 1418. INSTALLED NEW LONGERON WITH REPAIR SPLICE PER AARD 53-30-00-2.SDR AALA2009031900610Lens · missingLGA - SEAT 16D MISSING LENS FOR EMERGENCY TRACK LIGHTING. REPLACED LENS AT SEAT 16D FOR EMERGENCY TRACK LIGHTING.SDR AALA2009031800001A/C Pack · malfunctionedDFW - CREW REPORTED OIL SMELL AND BLUISH COLOR SMOKE IN CABIN AND COCKPIT. EMERGENCY DECLARED, LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED AUXILIARY PACK UNIT AND ACCOMPLISHED A PACK BURN. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090406TUL38Pan · crackedWINDOW PAN CRACKED AT AFT UPPER CORNER AT STATION 1041 RIGHT. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20090406TUL20Casting · crackedGROUND SPOILER CASTING CRACKED IN RADIUS ABOVE FORWARD END OF ACTUATOR, OUTBOARD SIDE. REPLACED SPOILER CASTING PER SRM 51-30.SDR AALA20090406TUL19Skin · dentedDENT AT STATION 1380 LONGERON 8L. INSTALLED DOUBLER PER SRM 53-01 FIGURE 2 SHEET 3.SDR AALA20090406TUL18Fitting · corrodedAFT SERVICE DOOR, AFT GIRT BAR FITTING CORRODED. INSTALLED NEW GIRT BAR FITTING PER SRM 53-10.SDR AALA20090406TUL16Longeron · crackedLONGERON 2R CRACKED OUTBOARD SIDE JUST AFT OF FRAME AT STATION 1418. INSTALLED REPLACEMENT LONGERON AND SPLICE DOUBLER PER AARD 53-30-00-2.SDR AALA20090406TUL12Cusp Web · corrodedCORROSION ON BOTTOM SIDE OF RIGHT CUSP STATION 1174-1193. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL11Pan · crackedWINDOW PAN CRACKED RIGHT SIDE STATION 1041. INSTALLED DOUBLER PER AARD 53-10-00-25.
Back to Mcdonnell Douglas DC-9-82