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 AALA20100811TUL05Cargo Track · corrodedHEAVY CARGO AFT CORROSION ON RIGHT TIE DOWN TRACK FROM STATIONS 1212 TO 1322. INSTALLED TIE DOWN TRACK PER SRM 51-30-01.SDR AALA20100811LAS01Engine · making metalLAS - INFLIGHT LAX-DFW. ON CLIMBOUT CREW REPORTED LOUD BANG FOLLOWED BY RIGHT ENGINE OIL FILTER CLOG LIGHT ACCOMPANIED WITH GRINDING NOISE. EMERGENCY DECLARED, DIVERTED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED RIGHT ENGINE OIL FISDR AALA20100811TUL10Pan · crackedWINDOW PAN CRACKED STATION 1022 AFT UPPER CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100811TUL09Pan · crackedRIGHT SIDE UPPER AFT CORNER STATION 1155 WINDOW PAN CRACKED. INSTALLED ANGLE DOUBLER CDK 3488-1 PER AARD-53-10-00-25.SDR AALA20100811TUL07Pan · crackedWINDOW PAN CRACKED STATION 1022 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100811TUL06Pan · crackedWINDOW PAN CRACKED AT LOWER AFT CORNER STATION 598 LEFT. REPAIRED PER AARD 53-10-00-25.SDR AALA20100811TUL01Cargo Track · corrodedHEAVY CARGO AFT CORROSION ON LEFT TIE DOWN TRACK FROM STATION 1007 TO 1220. INSTALLED NEW TIE-DOWN TRACK PER SRM 51-30-01.SDR AALA20100810TUL01Connector · brokenROW 14 SEAT MOUNTED ESCAPE PATH LIGHTING DOES NOT ILLUMINATE. REPLACED PLUG FOR ROW 14 SEAT MOUNTED ESCAPE PATH LIGHTING. OPS CHECKED NORMAL.SDR AALA20100809TUL05Door Frame · crackedLEFT FORWARD EXIT DOOR JAMB CRACKED AT UPPER STOP. INSTALLED DOUBLER PER SRM 53-05-00 FIGURE 32.SDR AALA20100809TUL04Fitting · corrodedLOWER FORWARD CORNER OF DOORWAY FITTING IS CORRODED. INSTALLED NEW FITTING PER DWG 5930483 AND AARD 51-00-00-012.SDR AALA20100809TUL03Stiffener · crackedSTIFFENER AFT SIDE OF STATION 1451 CRACKED AT LONGERON 2 LEFT. INSTALLED NEW STIFFENER PER AARD 51-00-00-012 AND SRM 51-30-05.SDR AALA20100809TUL02Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE OF STATION 1451 LONGERON 2 LEFT. INSTALLED NEW SHEAR TIE PER AARD 51-00-00-012 SRM 51-30-05.SDR AALA20100809TUL01Power Supply · failedTUS - CREW REPORTED POWER PORT SYSTEM ON SEAT 12B SPARKED. CIRCUIT BREAKER PULLED TO STOP SPARKS. EMERGENCY DECLARED, LANDED TUS WITHOUT INCIDENT. REPLACED THE IN SEAT POWER SOURCE AND THE OUTLET ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100808TUL04Seat Track · corrodedSEAT TRACK 5 OUTBOARD FLANGE CORRODED AT STATION 204. REMOVED AND REPLACED SEAT TRACK 5 STATION 200 TO 246 AND INSTALLED SPLICE PER SRM 53-05-00 FIGURE 4.SDR AALA20100808TUL03Cusp Web · corrodedCUSP MEMBRANE CORRODED AT FORWARD ENTRY IN SEVERAL PLACES BETWEEN STATION 180 AND 200. REPAIRED PER AARD 53-20-00-16.SDR AALA20100808TUL02Skin · crackedSKIN CRACKED AT STATION 1380 ABOVE STRINGER 14 RIGHT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 53-01-00.SDR AALA20100809LGA03Battery Pack · dischargedFOUND AFT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR AFT EMERGENCY LIGHTS. OPS CHECKED NORMAL.SDR AALA20100809LGA02Battery Pack · dischargedFOUND AFT DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR AFT DOOR EMERGENCY LIGHTS. OPS CHECKED NORMAL.SDR AALA20100809LGA01Battery Pack · dischargedFIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EMERGENCY LIGHTS. OPS CHECKED NORMAL.SDR AALA20100807TUL02Gcu · inoperativeMEM - CREW REPORTED RIGHT GENERATOR FAILED ALONG WITH CROSS TIE LOCK-OUT DURING APPROACH. EMERGENCY DECLARED LANDED MEM WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT GENERATOR CONTROL UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100815TUL01Longeron · damagedLONGERON 14 AT STATION 1410 HAS HEAT DAMAGE. REMOVED DAMAGED SECTION OF LONGERON 14 FROM STATION 1389 TO STATION 1435 AND INSTALLED A NEW SERVICEABLE SECTION OF LONGERON PER ATTACHED EA MD80-53-012438.SDR AALA20100807TUL04Cusp Web · crackedTWO CRACKS IN LEFT CUSP BETWEEN STATIONS 218 AND 237. REMOVED AND REPLACED LEFT CUSP SHEET BETWEEN STATIONS 218 AND 237 PER AARD53-20-00-16.SDR AALA20100807TUL03Cusp Web · corrodedLEFT CUSP STATION 612 TO 615 CORROSION ON BOTTOM SIDE OUT OF LIMITS. INSTALLED NEW CUSP DOUBLER FROM STATION 608 TO STATION 630 LEFT PER AARD 53-20-00-16.SDR AALA20100807TUL01Cusp Web · crackedCRACK IN RIGHT CUSP STATION 219 UNDER NUMBER 5 SEAT TRACK. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100808LGA02Battery Pack · dischargedCEILING EGRESS LIGHTS FROM ROWS 24 TO 28 INOPERATIVE. REPLACED BATTERY PACK AT ROW 26DEF FOR CEILING EGRESS LIGHTS FROM ROWS 24 TO 28. OPS CHECKED NORMAL.SDR AALA20100806TUL09Cusp Web · corrodedLEFT CUSP STATION 518-519 CORROSION ON LOWER SIDE OUT OF LIMITS. REMOVED CORROSION PER AARD 53-20-00-16. INSTALLED DOUBLER AT LEFT CUSP STATION 518-519 PER AARD 53-20-00-16.SDR AALA20100806TUL08Cusp Web · corrodedRIGHT CUSP AT STATION 620 TO 628 IS OUT OF MANUAL LIMITS. INSTALLED RIGHT CUSP DOUBLER AT STATION 620 TO 628 PER AARD 53-20-00-16.SDR AALA20100806TUL07Membrane · corrodedFORWARD CABIN SUB FLOOR HAS CORROSION AT STATION 200 TO 208 RIGHT BUTTLINE 45 TO RIGHT BUTTLINE 56. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20100806TUL06Skin · crackedFUSELAGE SKIN CRACKED BELOW FASTENER HOLE STATION 1380 ABOVE STR 14R. INSTALLED DOUBLER PER SRM 53-34-00.SDR AALA20100806TUL05Cusp Web · corrodedSUB FLOOR WEB HAS CORROSION AND WORN SPOTS STATION 1136 TO 1174. INSTALLED LEFT CUSP DOUBLER REPAIR AND CUSP FILLER PER AARD 53-20-00-16 UNDER AFT GIRT BAR FITTING STATION 1170.SDR AALA20100806TUL02Fitting · corrodedAFT CARGO LOWER AFT CORNER OF DOORWAY FITTING IS CORRODED. INSTALLED NEW FITTING AFT CORNER OF DOOR PER SRM 51-30-05.SDR AALA20100806TUL01Fitting · corrodedAFT CARGO LOWER FORWARD CORNER DOORWAY FITTING IS CORRODED. INSTALLED NEW FITTING PER DWG 5930483 & AARD 51-00-00-012.SDR AALA20100805TUL20Shear Tie · corrodedCORROSION ON SHEAR TIE AT STATION 1287 LONGERON 29 RIGHT TO LONGERON 30. FABRICATED SERVICEABLE SHEAR TIE AND REPAIR SPLICES PER SRM 53-03-00. TREATED, PRIMED AND PAINTED ALL BARE AREAS PER SRM 51-10-03.SDR AALA20100805TUL19Cusp Web · corrodedRIGHT CUSP AT STATION 560 TO 565 OUT OF LIMITS. INSTALLED DOUBLER RIGHT CUSP STATION 555 TO 568 AS PER AARD 53-20-00-16.SDR AALA20100805TUL18Cusp Web · corrodedAFT CARGO CORROSION ON LOWER SIDE OF LEFT CUSP AT STATION 1140. INSTALLED CUSP REPAIR DOUBLER AT LEFT STATION 1140 PER AARD 53-20-00-16.SDR AALA20100805TUL05Cusp Web · corrodedCORROSION ON RIGHT CUSP STATION 620 TO 628. REMOVED CORROSION INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20100805TUL04Cusp Web · corrodedCORROSION ON SUBFLOOR UNDER AFT SERVICE DOOR AFT GIRT BAR FITTING. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20100805TUL01Skin · dentedDENT IN FUSELAGE SKIN STATION 252 ABOVE LONGERON 18 LEFT. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER SRM 53-04-00 FIGURE 38 SHEET 36.SDR AALA20100805DFW02Sensor · faultyDFW - CREW REPORTED ON CLIMB OUT TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED. EMERGENCY DECLARED RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LEFT AND RIGHT TAIL COMPARTMENT HIGH TEMP SENSOR BAD. REPLACED TEMPERATURE SSDR WX0A070586Power Supply · 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 POWER SUPPLY BATTERY PACK AND MADE ASDR AALA20100804TUL29Skin · dentedDENT IN EXTERIOR OF FORWARD CARGO DOOR. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 38 SHEET 30 VIEW P.SDR AALA20100803TUL01Bushing · wornBUSHING WORN ON KNUCKLE RIB ON SLAT 1041. REPLACED WORN BUSHING PER ESO 80117 ON SLAT 1041.SDR AALA20100803TUL02Beam · crackedFORWARD ENTRY DOOR NUMBER 7 BEAM AFT SIDE CRACKED. STOP DRILLED BEAM CRACK AND INSTALLED DOUBLER PER SRM 52-05-00.SDR AALA20100803TUL23Frame · crackedAFT ACC RIGHT SIDE CRACK IN FRAME 1497 AT INSTRUMENT SENSE LINE BRACKET 12 INCHES BELOW RIGHT LOUVER BOX. INSTALLED DOUBLER PER EA MD80-53-012097 AND SRM 51-70-05.SDR AALA20100804SAT01Gasket · leakingSAT - INFLIGHT MFE-DFW. CREW REPORTED LEFT ENGINE FIRE INDICATION. BOTH FIRE BOTTLES USED AND LEFT ENGINE WAS SHUTDOWN. SINGLE ENGINE TIME 25 MINUTES. EMERGENCY DECLARED LANDED SAT WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LEFT ENGINE ANTI ISDR AALA20100803TUL03Service Panel · corrodedFUSELAGE AFT LAV SVC PANEL HAS CORROSION BETWEEN THE SKIN AND THE PAN AT THE LOWER AFT CORNER. INSTALLED NEW AFT LAVATORY SERVICE PANEL PAN PER AARD 53-30-00-07.SDR AALA20100804LGA02Light · inoperativeCEILING EMERGENCY LIGHT AT AISLE SEVEN INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT AISLE SEVEN. OPS CHECKED NORMAL.SDR AALA20100804LGA01Lens · missingCEILING EMERGENCY LIGHT AT SEAT AISLE 25 MISSING LENS. REPLACED LENS FOR CEILING EMERGENCY LIGHT AT AISLE SEAT 25. OPS CHECKED NORMAL.SDR AALA20100802TUL03Pan · crackedLEFT UPPER AFT WINDOW PAN TAB CRACKED AT STATION 1079. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100802TUL02Pan · crackedLEFT UPPER AFT WINDOW PAN TAB CRACKED AT STATION 1041. INSTALLED DOUBLER PER AARD 53-10-00-25.
Back to Mcdonnell Douglas DC-9-82