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 AALA20101022TUL01Frame · crackedSTATION 1497 CANT FRAME CRACKED BELOW RIGHT LOUVER BOX. REPAIRED CANT FRAME 1497 PER EA MD80-53-011694.SDR AALA20101019TUL11Shear Tie · crackedAFT ACCESSORY SHEAR TIE CRACKED AFT SIDE OF 1451 FRAME AFT OF LONGERON 2 LEFT. INSTALLED SHEAR TIE PER SRM 51-30-05 AND EA MD80-53-013580.SDR AALA20101018TPA01Engine · malfunctionedTPA - CREW REPORTED ON CLIMB OUT AT FL 250 LEFT ENGINE EMITTED LOUD BANG, RPM ROLLED BACK TO SUB-IDLE AND EGT BEGAN TO SLOW CLIMB. SHUTDOWN ENGINE AT THAT POINT (SINGLE ENGINE TIME 13 MINUTES). EMERGENCY DECLARED RETURNED TPA LANDED WITHOUT INCIDENT. AIRCRASDR AALA20101017TUL05Beam · corrodedAFT CARGO DOOR BEAM HAS CORROSION FROM STATIONS 1155 TO 1212. INSTALLED DOOR BEAM / DOUBLER PER AARD 53-10-00-3 AND EA MD80-53-013563.SDR AALA20101017TUL02Bracket · corrodedAFT CARGO LOWER CORNER BRACKET IS CORRODED AT AFT END OF LOWER DOOR JAMB STATION / 1211. INSTALLED NEW CORNER BRACKET PER SRM 51-30-05.SDR AALA20101017TUL04Mount · corrodedFORWARD GALLEY MOUNT AT STATIONS 215 TO 216 SEAT TRACK NUMBER 6 IS BLENDED OUT OF LIMITS. INSTALLED NEW G2 GALLEY MOUNT ON FORWARD END OF NUMBER 6 SEAT TRACK AS PER SRM 51-30-02.SDR AALA20101017TUL03Shear Tie · crackedAFT ACCESSORY SHEAR TIE CRACKED AFT SIDE OF 1451 FRAME AFT OF LONGERON 2 LEFT. INSTALLED SHEAR TIE PER SRM 51-30-05.SDR AALA20101016TUL03Sense Line · crackedFAT - CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED AFTER TAKEOFF. EMERGENCY DECLARED RETURNED FAT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED AUG VALVE SENSE LINE THAT WAS CRACKED. SYSTEM GROUND CHECK NORMAL OPERATSDR AALA20101016LGA02Battery Pack · dischargedEMERGENCY LIGHTS FOR TAIL COMPARTMENT AND CATWALK AREA INOPERATIVE. REPLACED EMERGENCY LIGHTING BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20101016LGA01Battery Pack · dischargedEMERGENCY ESCAPE PATH LIGHTING INOPERATIVE FROM FIRST CLASS GALLEY TO ROW 15. REPLACED ESCAPE PATH LIGHTING BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20101015TUL11Floorbeam · damagedFLOOR BEAM, STATION 160 RIGHT BUTTLINE 52 AT OUTBOARD G-1 GALLEY MOUNT LOCATION HAS A .5 INCH HOLE IN AFT SIDE OF TOP TEE. INSTALLED REPAIR STRAP AT FLOORBEAM TOP TEE CAP STATION 160 RIGHT BUTTLINE 48 TO RIGHT BUTTLINE 56 PER EA MD-53-013532.SDR AALA20101015TUL08Diaphragm · corrodedSUB-FLOOR CORRODED STATIONS 160 TO 200 RIGHT BUTTLINES 44 TO 57. REMOVED DAMAGED AREA, INSTALLED CUSP DIAPHGRAM REPAIR, AND INSTALLED NEW FACTORY DOUBLER PER AARD 53-20-00-16.SDR AALA20101015TUL07Frame · crackedSTATION 1418 FRAME CRACK FORWARD SIDE AT LONGERON 2 LONG. INSTALLED DOUBLER REPAIR AND RADIUS BLOCK ON FORWARD SIDE OF STATION 1418 FRAME AT LONGERON 2 LEFT PER EA NUMBER MD80-53-011672 AND SRM 53-03-00.SDR AALA20101015TUL06Fitting · corrodedG-1 GALLEY OUTBOARD TIE-DOWN FITTING CORRODED. INSTALLED NEW TIE-DOWN FITTING PER SRM 51-30-05.SDR AALA20101015TUL05Fitting · corrodedCORROSION ON G-1 GALLEY TIE-DOWN FITTING. INSTALLED NEW TIE-DOWN FITTING PER SRM 51-30-02 AND 51-30-05.SDR AALA20101015TUL01Fitting · corrodedHEAVY CABIN CORROSION ON NUMBER 1 GALLEY TIE-DOWN FITTING NUMBER 2 OUTBOARD. INSTALLED G-1 GALLEY TIE-DOWN FITTING NUMBER 2 OUTBOARD PER SRM 51-30 05.SDR AALA20101014TUL06Cusp Web · crackedCRACK IN RIGHT CUSP SHEET AT STATION 219 OUTBOARD OF NUMBER 5 SEAT TRACK. INSTALLED DOUBLER AND FILLER PER AARD 53-20-00-16.SDR AALA20101014TUL05Support · crackedSEAT TRACK SUPPORT BELOW NUMBER 3 SEAT TRACK AT STATION 927 IS CRACKED AT BOTTOM. FABRICATED DOUBLER AND FILLER, IAW EA MD80-53-013492. INSTALLED FILLER AND DOUBLER IAW EA MD80-53-013492 AND SRM 51-30-05.SDR AALA20101014TUL04Pan · crackedAFT CARGO DOOR HAS CRACK ON LOWER INNER PAN AT LOWER STOP PAD CUTOUT. REPLACED LOWER INNER PAN PER ESO 80174.SDR AALA20101014TUL03Cusp Web · damagedRIGHT CUSP CORRODED AT STATION 463. INSTALLED REPAIR DOUBLER AT STATION 463 RIGHT PER AARD 53-20-00-16.SDR AALA20101014LGA02Battery Pack · dischargedEMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CABIN. OPS CHECK NORMAL.SDR AALA20101014LGA04Battery Pack · dischargedEGRESS LIGHTS ROW 22 ALL THE WAY BACK TO TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK AT POSITION AB5-3. OPS CHECKS NORMAL.SDR AALA20101014LGA03Battery Pack · dischargedEGRESS LIGHTS ROW 22 ALL THE WAY TO TAIL COMPARTMENT. REPLACED BATTERY PACK POSITION AB5-4. OPS CHECKS NORMAL.SDR AALA20101014LGA01Module · shortedEGRESS LIGHTS ROW 22 ALL THE WAY BACK TO TAIL COMPARTMENT INOPERATIVE. REPLACED MODULE POSITION AB5-4. OPS CHECKED NORMAL.SDR AALA20101013TUL11Pan · crackedCRACK IN UPPER AFT CORNER OF WINDOW PAN AT STATION 1041 LEFT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101013TUL10Pan · crackedCRACK IN LOWER FORWARD CORNER OF WINDOW PAN AT STATION 1060 RIGHT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101013TUL09Pan · crackedUPPER AFT CORNER OF WINDOW PAN CRACKED AT STATION 1250 RIGHT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101013TUL08Seat Track · corrodedCORROSION ON NUMBER 2 SEAT TRACK AT STATION 1201 OUT OF LIMITS. BLENDED TO REMOVE CORROSION AND INSTALLED SEAT TRACK PLUG REPAIR PER AARD 53-20-00-10.SDR AALA20101013TUL01Cusp Web · crackedCABIN LEFT CUSP CRACKED STATION 671. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101013TPA01Light · inoperativeEMERGENCY LIGHT IN CABIN INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT IN CABIN. OPS CHECK NORMAL.SDR AALA20101012TUL07Cusp Web · crackedCUSP CRACKED IN ELECTRICAL EQUIPMENT COMPARTMENT JUST AFT OF STATION 157 APROXIMATLEY 18 INCHES OF FORWARD SERVICE DOOR. INSTALLED NEW CUSP SUB-FLOOR AND DOUBLER PER AARD53-20-00-16.SDR AALA20101012TUL05Doubler · corrodedSUBFLOOR DOUBLER UNDER G-1 GALLEY DRAIN PAN CORRODED. REPAIRED SUBFLOOR UNDER G-1 GALLEY DRAIN PAN REFERENCE PRELIMINARY EA DATED 10-8-10 AND FINAL EA MD80-53-013476 AND AARD 53-20-00-16.SDR AALA20101012TUL04Pan · crackedFORWARD LOWER CORNER OF WINDOW PAN CRACKED STATION 1136 RIGHT SIDE. CUT OUT CRACKED AREA. FABRICATED DOUBLER, TREATED, PRIMED, AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20101012TUL03Seat Track · corrodedCORROSION IN SEAT TRACK NUMBER THREE (3) AT STATION 1201. SEAT TRACK PLUG REPAIR INSTALLED PER AARD 53-20-00-10.SDR AALA20101012TUL02Seat Track · corrodedCORROSION IN SEAT TRACK NUMBER THREE(3) STATION 1175. SEAT TRACK PLUG REPAIR INSTALLED PER AARD 53-20-00-10.SDR AALA20101012TUL01Pan · crackedFORWARD LOWER CORNER OF WINDOW PANE CRACKED AT STATION 160 RIGHT SIDE. DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20101011TUL23Skin · dentedAIRSTAIR DOOR DEEP DENT RIGHT SIDE. INSTALLED DOUBLER PER SRM 52-01-00 FIGURE 4 SHEET 3.SDR AALA20101011TUL22Skin · crackedSTATION 1380 SKIN CRACK ABOVE PYLON. INSTALLED DOUBLER PER SRM 53-01-00 FIGURE 2 SHEET 3.SDR AALA20101011TUL20Longeron · crackedLONGERON 2 RIGHT IS CRACKED ON OUTBOARD FLANGE AFT OF FRAME 1418. REPAIRED LONGERON PER AARD 53-30-00-2.SDR AALA20101011TUL19Pan · crackedFORWARD LOWER CORNER OF WINDOW PAN CRACKED AT STATION 1136 RIGHT SIDE. REPAIR DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20101011TUL18Attach Fitting · crackedRIGHT NUMBER 5 SLAT OUTBOARD TRACK ATTACH BRACKET CRACKED. RIGHT NUMBER 5 SLAT REMOVED OUTBOARD ATTACH FITTING, LOCATED, DRILLED AND INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20101011TUL17Attach Fitting · crackedRIGHT NUMBER 5 SLAT 2ND FROM OUTBOARD TRACK ATTACH BRACKET CRACKED. RIGHT NUMBER 5 SLAT REMOVED 2ND FROM OUTBOARD END ATTACH FITTING, LOCATED, DRILLED AND INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20101011TUL04Pan · crackedUPPER AFT CORNER OF WINDOW PAN CRACKED AT STATION 886 LEFT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101010TUL03Frame · damaged16 EACH IMPROPER FASTENERS INSTALLED IN FRAME STATION 865 BETWEEN LONGERON 9 AND 10 RIGHT (STANDARD FASTENER SHOULD BE 1ST OVER). REMOVED 16 STANDARD LOCK FASTENER, REAMED HOLES AND INSTALLED 1ST OVER LOCK FASTENER PER SRM 51-30-05 AND DRAWING SR09530282 AND SDR WX0A070613Door Frame · crackedAFT CABIN PRESSURE BULKHEAD DOOR JAMB HAS TWO CRACKS IN THE UPPER RIGHT CORNER FACING AFT (LEFT CORNER). REPAIRED VENTRAL DOOR JAMB UPPER RIGHT SIDE FACING AFT (LEFT CORNER) IAW MD80 SRM 53-05 FIG 29.SDR AALA20101010DFW07Switch · faultyDFW - CREW REPORTED NOSE LANDING GEAR UNSAFE LIGHT ILLUMINATED AND WOULD NOT EXTINGUISH. CYCLED GEAR AND NO HELP. EMERGENCY DECLARED VERIFIED GEAR EXTENDED AND LANDED AT DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NOSE GEAR GROUND INTERLOSDR AALA20101010DFW06Fire Loop · faultedDFW - CREW REPORTED FIRE LOOP B INDICATION DURING FLIGHT. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. RESET FIRE DETECTOR LOOP B AUXILIARY POWER UNIT CIRCUIT BREAKER AND REPLACED AUXILIARY POWER UNIT FIRE CONTROL AS A PRECAUTSDR AALA20101010TUL02Pan · crackedCRACK IN UPPER FORWARD CORNER OF WINDOW PAN AT STATION 769 RIGHT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101010TUL01Pan · crackedCRACK IN FORWARD LOWER CORNER OF WINDOW PAN AT STATION 1079 RIGHT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101010LGA01Light · inoperativeCABIN WALK AROUND EMERGENCY LIGHT AT LEFT NUMBER 1 DOOR WILL NOT TEST. REPLACED LIGHT ASSEMBLY. OPS CHECKS NORMAL.
Back to Mcdonnell Douglas DC-9-82