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 AALA20100419TUL08Seat Track · corrodedSEAT TRACK NUMBER 3 STATIONS 1174 TO 1175 CORROSION OUT OF LIMITS. INSTALLED SEAT TRACK PLUG SRM 53-10-00.SDR AALA20100419TUL07Longeron · corrodedCARGO AFT CARGO CORROSION LONGERON 28 LEFT STATION 1289. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-02-00 FIGURE 19.SDR AALA20100419TUL06Seat Track · damagedSEAT TRACK NUMBER 6 DAMAGED AT STATION 207. INSTALLED SERVICEABLE TRACK PER SRM 53-05-00 FIGURE 4F.SDR AALA20100419TUL05Window Frame · crackedCABIN WINDOW FRAME CRACKED LOWER FORWARD CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100419TUL03Rib · crackedNUMBER 15 SLAT RIB CRACKED AT OUTBOARD SIDE RIGHT WING. REMOVED NUMBER 15 ATTACH FITTING. LOCATED, DRILLED, AND INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20100419TUL02Rib · crackedNUMBER 14 SLAT RIB CRACKED ON OUTBOARD SIDE RIGHT WING. REMOVED NUMBER 14 ATTACH FITTING. LOCATED, DRILLED, AND INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20100419TUL01Skin · crackedDAMAGE TO OUTER SKIN DOUBLER AT HOLD-OPEN HOOK ENTRY. DAMAGED OUTER SKIN DOUBLER AT HOLD-OPEN HOOK ENTRY REPLACED PER SRM 52-05-00 FIGURE 20A.SDR AALA20100418LGA03Battery Pack · shortedELECTRICAL BURNING SMELL IN CABIN AFTER AIRCRAFT WAS TOWED TO THE GATE. FOUND EMERGENCY LIGHT BATTERY PACK SHORTED AND A BURNT LIGHT SOCKET ABOVE SEAT 8DEF. REPLACED BATTERY PACK AND LIGHT SOCKET AT 8DEF. OPS CHECK NORMAL.SDR AALA20100418TUL05Cusp Web · corrodedCORROSION ON LEFT CUSP SHEET AT STATION 456 OUT OF LIMITS PER SRM 53-01 FIGURE 1 SHEET 3. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100418TUL02Cusp Web · corrodedCORROSION ON CUSP RIGHT STATIONS 1174 TO 1193 OUT OF LIMITS PER SRM 53-01 FIGURE 1 SHEET 3. INSTALLED REPAIR DOUBLER BETWEEN STATIONS 1174 TO 1193 PER AARD 53-20-00-16.SDR AALA20100418TUL01Longeron · crackedCABIN HAS A CRACKED IN LONGERON 2 LEFT IN LOWER RADIUS AT STATION 160. INSTALLED LONGERON AND SPLICE REPAIR PER SRM 53-03-00-FIGURE 18.SDR AALA20100419LGA01Battery Pack · not seatedDURING EMERGENCY LIGHT TEST FOUND AFT ACCESSORY COMPARTMENT EMERGENCY LIGHTS BARELY ILLUMINATED WHEN SELECTED ON. RE-SEATED BATTERY PACK IN AFT FUSELAGE AND EMERGENCY LIGHTS OPS CHECKS NORMAL DURING RETEST.SDR AALA20100417TUL01Cusp Web · damagedCUSP SHEET HAS TEAR AT RIVET HOLE STATION 1250 LEFT SIDE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100416TUL11Pan · crackedWINDOW PAN CRACKED AT UPPER FORWARD CORNER OF NUMBER R32 WINDOW. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100429TUL09Shear Tie · crackedAFT ACCS SHEAR TIE CRACKED AT STATION 1451 FRAME AFT OF LONGERON 2L. INSTALLED NEW SHEAR TIE PER SRM 51-30-05.SDR AALA20100416LAX01Trim Motor · failedLAX - CREW REPORTED PRIMARY TRIM SYSTEM FAILURE. FLIGHT LANDED LAX WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED PRIMARY LONGITUDINAL TRIM MOTOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100416TUL12Skin · damagedDENT WITH DEEP GOUGES ON FUSE SKIN LONGERON 15 LEFT STATION 365. INSTALLED PERMANENT REPAIR PER SRM 53-04-00 FIGURE 12B.SDR AALA20100416TUL09Structure · misrepairedWRONG REPAIR ANGLE INSTALLED AT LOWER FORWARD CORNER OF NUMBER R32 WINDOW AT STATION 807. INSTALLED PROPER REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20100416TUL07Indicator · faultyMCI - INFLIGHT MSP-DFW. HEADING ANNUNCIATOR ON BOTH FLIGHT MODE ANNUNCIATORS CAME ON. UNABLE TO DETERMINE WHICH SYSTEM WAS CORRECT DUE TO LARGE DEVIATIONS ON BOTH SYSTEMS COMPARED TO MAGNETIC COMPASS. FLIGHT DIVERTED MCI LANDED WITHOUT INCIDENT. REPLACEDSDR AALA20100416TUL02Cusp Web · corrodedCORROSION ON CUSP RIGHT STATIONS 522 TO 541 OUT OF LIMITS PER SRM 53-01 FIGURE 1 SHEET 3. INSTALLED DOUBLER PER AARD 53-20-0-16.SDR AALA20100416TUL01Seat Track · damagedSTATION 207 SEAT TRACK NUMBER 6 FORWARD END OF SEAT TRACK CORROSION OUT OF LIMITS OF SRM 53-01 FIGURE 1 SHEET 3. INSTALLED SEAT TRACK NUMBER 6 AND SPLICE PER SRM 53-05-00 FIGURE 4F.SDR AALA20100429TUL05Skin · crackedFUSELAGE EXTERIOR SKIN CRACKED STATION 1418 AT SHEAR TIE FASTENER LONGERON 2 LEFT TO 3 LEFT. INSTALLED REPAIR PER SRM 53-04-00 FIGURE 40 SHEET 1.SDR AALA20100415TUL09Skin · dentedCONDITION 1B DENT FOUND AT STATION 218 OVER SHEAR TIE BETWEEN LONGERON 18 LEFT AND LONGERON 19 LEFT. INSTALLED CLASS 1 DOUBLER PER SRM 53-04-00 FIGURE 12B.SDR AALA20100415TUL07Cusp Web · corrodedCORROSION OUT OF LIMITS LEFT CUSP STATION 1094 TOP SIDE. INSTALLED CUSP REPAIR PER AARD 53-20-00-16 AND SRM 51-30-05.SDR AALA20100415TUL05Cusp Web · corrodedCORROSION ON CUSP SHEET RIGHT STATIONS 560 TO 579 OUT OF LIMITS PER SRM 53-01 SHEET 3. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100415TUL04Web · damagedCORROSION ON TOP AND BOTTOM OF DOOR WEB STATIONS 1212 TO 1218 LONGERON 28 RIGHT AND LONGERON 27 RIGHT. NEW WEB SPLICE INSTALLED AT STATIONS 1200 TO 1218 FROM LONGERON 30 TO LONGERON 26 RIGHT PER WIP NUMBER 7 AND PER AARD 53-10-00-24.SDR AALA20100415TUL03Seat Track · wornNUMBER SIX SEAT TRACK WORN BEYOND LIMITS AT FUSELAGE STATION 363. DAMAGE ROUTED OUT AND A PLUG INSTALLED PER SRM 53-05-00.SDR AALA20100415TUL01Door Frame · damagedWEB STRAP ON DOOR CUTOUT BEAM WEB STATION 1174 IS CORRODED. INSTALLED NEW WEB STRAP ON DOOR CUTOUT BEAM WEB STATION 1174 LONGERON 29 RIGHT TO LONGERON 28 RIGHT PER SRM 51-30-00.SDR AALA20100414TUL11Frame · crackedAFT ACCESSORY 1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR AALA20100414TUL06Cusp Web · corrodedCORROSION ON BOTTOM SIDE OF SUB-FLOOR STATION 199 APPROXIMATELY 9 INCHES INBOARD OF FUSELAGE WALL. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100414TUL02Attach Bracket · crackedTHE LEFT NUMBER 5 SLAT NUMBER 15 SLAT TRACK ATTACH BRACKET IS CRACKED. REMOVED AND REPLACED BRACKET PER ESO 80117.SDR AALA20100429TUL06Casting · crackedGROUND SPOILER FITTING CASTING HAS CRACKS. SPOILER CASTING REPLACED PER EA MD80 51-010298 REV C, BOEING DRAWING SR095700010, AARD 57-20-00-13.SDR AALA20100413TUL12Attach Bracket · crackedTHE RIGHT NUMBER 5 SLAT TRACK ATTACH BRACKET IS CRACKED. REMOVED NUMBER 15 ATTACH BRACKET, LOCATED AND DRILLED AND INSTALLED NEW ATTACH BRACKET PER ESO 80117.SDR AALA20100413TUL02Bracket · crackedLEFT SPOILER ACTUATOR FITTING WAS FOUND CRACKED AND REPAIRED PER AARD 57-20-00-15 AND ESO 80559 DATED 12-5-08. REMOVED AND REPLACED GROUND SPOILER BRACKET PER AARD 57-20-00-15.SDR AALA20100413TUL01Intercostal · crackedINTERCOSTAL CRACKED AT STATIONS 1287 TO 1309. INSTALLED NEW INTERCOSTAL PER SRM 51-00-00-012.SDR AALA20100412TUL01Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 240. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100412STL01Pitot Tube · inoperativeSTL - INFLIGHT ORD-DEN. CREW REPORTED PITOT STALL HEATER OFF LIGHT ILLUMINATED. FLIGHT DIVERTED STL LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED AUXILIARY PITOT TUBE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100411TUL01Frame · wornFUSELAGE FRAME AT STATION 1041 RIGHT HAS DEEP WEAR 7 INCHES ABOVE CUSP AT FRAME FITTING. REPAIR WAS COMPLETED PER EAMD80-53-010080 AND SRM 51-70.SDR AALA20100412ATL01Bottle · low pressureAFT GALLEY DOOR EVACUATION SLIDE BOTTLE PRESSURE LOW. REMOVED AND REPLACED AFT GALLEY DOOR EVACUATION SLIDE ASSEMBLY. OPS CHECKED NORMALSDR AALA20100410TUL07Cusp Web · crackedCUSP CRACKED BETWEEN STATIONS 240 TO 259, 3 PLACES CRACKS RANGE FROM 1.5 INCHES TO 2.5 INCHES. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100410TUL06Tee Fitting · corrodedCUSP TEE CORRODED OUT OF LIMITS AT STATION 200 JUST AFT OF FORWARD SERVICE DOOR. INSTALLED DOUBLER PER AARD 53-20-00-14.SDR AALA20100410TUL05Membrane · corrodedSUB FLOOR CORRODED OUT OF LIMITS AT STATION 200 FORWARD OF NUMBER 6 SEAT TRACK. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100410TUL04Stiffener · crackedVERTICAL STIFFENER AT AFT BULKHEAD STATION 1338 CRACKED. STOP DRILLED CRACK AND INSTALLED DOUBLER REPAIR PER AARD 53-10-00-15.SDR AALA20100410TUL03Cusp Web · crackedRIGHT CUSP CRACKED AT STATIONS 991 TO 993. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100410LGA01Battery Pack · dischargedFIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED FIRST CLASS BATTERY PACK. OPS CHECKED NORMAL.SDR WX0A070545Unknown · odorFLIGHT ATTENDANT REPORTED SMELL IN AFT LAV AND BACK WALL WAS HOT. MAINTENANCE PERSONNEL INSPECTED AFT LAV LIGHTING WIRING AND WATER HEATER AND RUN ALL SYSTEMS CHECKS, NO DEFECTS NOTED AT THIS TIME IAW AMM 38-00-00 AND 25-41-00. AIRCRAFT OK FOR RETURN TO SERVSDR AALA20100409TUL06Splice Plate · corrodedAFT- CORROSION ON LEFT TIE-DOWN TRACK SLICE PLATES STATION 1220. (MKD) INSTALLED NEW SPLICE PARTS PER SRM 51-30-05.SDR AALA20100409TUL12Beam · corrodedCORROSION ON LOWER DOOR BEAM AT AFT CARGO DOOR OPENING. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR PER AARD 53-10-00-3.SDR AALA20100409TUL05Skin · damagedAFT CARGO BEAM AREA STATION 1165 TO 1200 SKIN UNDER BEAM HAS TOOLING MARKS FROM CLEAN-UP OF BEAM HORIZONTAL FLANGE. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER SRM 53-04 FIGURE 38 (SHEET 21) AND EA MD80-53-009976.SDR AALA20100409TUL02Skin · dentedDENT IN FUSE STATION 242 BETWEEN LONGERONS 15 AND 16 LEFT. INSTALLED DOUBLER PER BOEING REPAIR DOCUMENT SG09530001.
Back to Mcdonnell Douglas DC-9-82