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 AALA20090611TUL03Stop Fitting · crackedNR 5 STOP PAD FITTING CRACKED ON FWD SIDE OF FWD CARGO DOOR. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090611TUL02Stop Fitting · crackedNR 4 STOP PAD FITTING CRACKED ON FWD SIDE OF FWD CARGO DOOR. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090611TUL01Stop Fitting · crackedNR 2 STOP PAD FITTING ON FWD SIDE OF FWD CARGO DOOR CRACKED. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA2009061100001Battery Pack · dischargedMCO - LEFT NUMBER 2 DOOR EMERGENCY EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK FOR LEFT NUMBER 2 DOOR EMERGENCY EXIT SIGN.SDR AALA2009061000007Relay · openSPS - INFLIGHT COS-DFW. WHILE DESCENDING FLIGHT LOST BOTH A/C PACKS. EMERGENCY DECLARED, LANDED SPS WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND OPEN COIL ON RELAY R2-279. REPLACED AIR CONDITIONING THERMOSTAT RELAY R2-279. REPLACED BOTH COALESCSDR AALA20090624TUL06Beam · crackedFORWARD ENTRY DOOR APPROXIMATELY .25 INCH CRACK AT FORWARD END OF SECOND FROM TOP BEAM.SDR AALA20090623TUL19Splice · corrodedSEAT TRACK GALLEY TIE DOWN SPLICE CORRODED. INSTALLED SERVICEABLE SEAT TRACK TIE DOWN SPLICE PER SRM 53-01-00.SDR AALA20090826TUL02Angle · crackedLOWER DOOR STOP INTERCOSTAL TO SKIN T-ANGLE IS CRACKED. REMOVED AND INSTALLED A SERVICEABLE T-ANGLE UNDER ESO 80497.SDR AALA20090623TUL18Floorbeam · crackedSTATION 927 RIGHT SIDE OF FLOORBEAM HAS CRACK IN UPPER LEG OF BEAM 6 INCHES INBOARD OF FRAME. REPLACED FLOORBEAM AT STATION 927 RIGHT BUTTLINE 22 TO 56 PER SRM 51-01-00.SDR DU4R2009378Skin · dentedDURING SCHEDULED INSP, FOUND PREVIOUSLY REPORTED DENT AT FS 246.5, L-22R - L-23R IS CREASED, OUT OF LIMITS IAW SRM 53-04 FIG. 38, SHT. 13, CONDITION 3.SDR AALA2009060900006Battery Pack · dischargedSTL - FORWARD EXIT LIGHTS WOULD NOT TEST. REPLACED BATTERY PACKS FOR FORWARD EXIT LIGHTS.SDR AALA2009060900005Placard · unserviceableDFW - TAIL CONE EXIT SIGN AT HANDLE UNREADABLE. REPLACED EXIT SIGN.SDR AALA2009060900004Placard · unserviceableDFW - TAIL CONE DROP HANDLE PULL PLACARD UNREADABLE. REPLACED DROP HANDLE PULL PLACARD.SDR AALA20090624TUL05Diaphragm · corrodedCORROSION ON SUBFLOOR UNDER SEAT TRACK NR 6. INSTALLED DOUBLER ON SUBFLOOR PER AARD 53-20-00-16.SDR DU4R2009376Skin · dentedDURING SCHEDULED INSP, FOUND DENT NEXT TO L-15L AT FS 211.5 OUT OF LIMITS DUE TO BEING CLOSE TO LONGERON.SDR AALA20090609TUL50Frame · crackedFRAME CRACKED. REPAIRED PER EA MD80-53-006456.SDR AALA20090609TUL49Seat Track · damagedDEEP WORN AREA ON NR 4 SEAT TRACK. INSTALLED SEAT TRACK PLUG REPAIR PER AARD 53-20-00-10.SDR AALA20090609TUL48Cusp Web · damagedLEFT CUSP HAS CORROSION BENEATH AFT GIRT BAR FITTING. INSTALLED DOUBLER ON LEFT CUSP UNDER AFT GIRT BAR BRACKET STA 1166 PER AARD 53-20-00-16.SDR AALA20090609TUL08Shear Tie · damagedCORROSION ON SHEAR TIE STATION 1155 LONGERON 29R TO LONGERON 30. REMOVED AND REPLACED SHEAR TIE PER SRM 51-30-05.SDR AALA20090609TUL09Shear Tie · corrodedCORROSION ON FORWARD AND AFT SIDE OF SHEAR TIE AT STATION 1287 BETWEEN L26L-L27L. REMOVED AND REPLACED SHEAR TIE PER SRM 51-30-05.SDR AALA20090609TUL07Floor Support · crackedCRACK ON VERTICAL FLOORBOARD SUPPORT OUTBOARD OF LONGERON 29R. REMOVED AND REPLACED VERTICAL SUPPORT PER SRM 51-30-05.SDR AALA20090623TUL17Cusp Web · corrodedCORROSION ON LEFT CUSP BETWEEN STATIONS 604-711. INSTALLED CUSP SHEET PER SRM 51-01.SDR AALA20090623TUL15Cusp Web · corrodedLEFT CUSP CORRODED. INSTALLED CUSP DOUBLER BELOW GIRT BAR BRACKET PER AARD 53-20-00-16.SDR AALA2009060700001Battery Pack · dischargedSTL - AFT SECTION FLOOR PROXIMITY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACKS FOR AFT SECTION FLOOR PROXIMITY EXIT LIGHTS.SDR AALA2009060600005Wire · brokenDFW - LEFT ENGINE SHUT DOWN IN FLIGHT DUE TO HIGH OIL TEMPERATURE. SINGLE ENGINE TIME 29 MINUTES. EMERGENCY DECLARED RETURNED TO DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND BROKEN WIRE TO LEFT ENGINE TEMPERATURE LAMP AND LOOSE PNEUMATIC LINESDR AALA2009060600004Control Cable · out of rigJFK - INFLIGHT LGA-LGA. DURING FUNCTIONAL FLIGHT CHECK THE LANDING GEAR DOOR WAS UNABLE TO CLOSE. EMERGENCY DECLARED, LANDED JFK WITHOUT INCIDENT. ACCOMPLISHED RE-RIG OF LEFT AND RIGHT MAIN LANDING GEAR DOOR PUSH/PULL CONTROL CABLES. SYSTEM GROUND CHECK NOSDR AALA20090609TUL22Support · damagedCORROSION ON WATER PAN SUPPORT. REMOVED AND REPLACED WATER PAN SUPPORT PER SRM 53-00.SDR AALA20090609TUL12Skin · damagedSKIN CORRODED AT STATION 1287 UNDER LONGERON 29R. COMPLETED DOUBLER INSTALLED PER SRM 53-04-00.SDR AALA20090609TUL13Cusp Web · puncturedHOLE PUNCTURED IN CUSP SHEET LEFT SIDE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090609TUL11Shear Tie · corrodedCORROSION IN AFT CARGO ON SHEAR TIE BETWEEN L29L-L30. INSTALLED NEW SHEAR TIE PER 51-30-00 AND SRM 51-30-02.SDR AALA2009060600003Battery Pack · not seatedLGA - TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERY PACK FOR TAIL COMPARTMENT EMERGENCY LIGHTS.SDR AALA2009060500002Valve · inoperativeLGA - AFTER TAKEOFF LEFT GEAR RED LIGHT REMAINED ON AFTER RETRACTION. LANDED LGA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED LANDING GEAR VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090609TUL30Skin · damagedDENT WITH GOUGE RIGHT SIDE FUSELAGE. REMOVED DAMAGE AND INSTALLED DOUBLER PER SRM 53-01 FIGURE 04 SHEET 4.SDR AALA20090609TUL27Intercostal · crackedMID CARGO HAS CRACK IN CABIN FLOORBEAM INTERCOSTAL AT STA 782. REPLACED INTERCOSTAL AT STATION 782 PER SRM 51-3-05.SDR AALA20090609TUL21Skin · dentedSKIN IS DENTED AND BUCKLED OVER FRAME BETWEEN L18L-L17L. INSTALLED DOUBLER PER SRM 53-04 FIGURE 38.SDR AALA20090609TUL18Cusp Web · corrodedCORROSION ON LEFT CUSP. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090609TUL17Cusp Web · crackedCUSP CRACKED RIGHT SIDE OUTBOARD OF NR 5 SEAT TRACK. INSTALLED NEW CUSP SHEET PER SRM 51-30.SDR AALA20090609TUL16Stop Fitting · crackedFORWARD CARGO DOOR NR 5 BEAM AFT STOP PAD CRACKED. REMOVED AND REPLACED STOP PAD PER ESO 80174.SDR AALA20090609TUL14Stop Fitting · crackedFORWARD CARGO DOOR NR 5 BEAM FORWARD STOP PAD FITTING CRACKED. REMOVED AND REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20090609TUL10Cusp Web · corrodedLEFT CUSP CORRODED AT FOOT FRAME LEFT SIDE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090609TUL28Web · damagedTOOLING MARKS ON SUB FLOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090609TUL26Bracket · gougedOUTBOARD FORWARD G1 GALLEY FLOOR TIE DOWN BRACKET HAS DEEP GOUGE AND BROKEN FASTENER. REPLACED G1 GALLEY TIE DOWN BRACKET PER SRM 51-01.SDR AALA2009060400004Battery Pack · dischargedDFW - CEILING EMERGENCY LIGHTS IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS IN FIRST CLASS.SDR AALA2009060300004Hydraulic Line · looseDFW - AIRCRAFT EXPERIENCED LOSS OF LEFT HYDRAULIC SYSTEM. EMERGENCY DECLARED, LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LOOSE LINE ON THRUST REVERSER LEFT CONTROL VALVE. TIGHTENED LEFT CONTROL VALVE LINE. SYSTEM GROUND CHECK NORMALSDR AALA20090609TUL29Skin · dentedDENT IN FUSELAGE SKIN BELOW L18L. MEASURES 3 INCHES BY 11 INCHES BY .055 DEEP. INSTALLED DOUBLER PER AARD 53-30-00-9 AND SRM 53-04-12B.SDR AALA20090609TUL19Seat Track · corrodedCORROSION ON SEAT TRACK NR 1 OUT OF LIMITS. INSTALLED SEAT TRACK PLUG PER SRM 53-05 FIG 4A.SDR AALA20090605TUL15Cusp Web · crackedCRACK IN CUSP. CUSP WAS REMOVED AND REPLACED PER AARD 53-20-00-16.SDR AALA20090605TUL17Casting · corrodedLT WING GROUND SPOILER CASTING CRACKED. NEW CASTING WAS INSTALLED PER SRM 51-01.SDR AALA20090605TUL13Fitting · corrodedCORROSION IN G-2 GALLEY TIE DOWN FITTING. REMOVED AND REPLACED WITH NEW FITTING PER SRM 51-00.SDR AALA20090605TUL07Casting · brokenCASTING IS BROKE BELOW SEAT TRACK. REMOVED AND REPLACED WITH NEW CASTING PER SRM 51-01.
Back to Mcdonnell Douglas DC-9-82