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 AALA20100315LGA02Battery Pack · dischargedAFT ESCAPE PATH LIGHTING INOPERATIVE. REPLACED BATTERY PACK FOR AFT ESCAPE PATH LIGHTING. OPS CHECKED NORMAL.SDR AALA20100315LGA01Battery Pack · dischargedFORWARD ESCAPE PATH LIGHTING INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD ESCAPE PATH LIGHTING. OPS CHECKED NORMAL.SDR AALA20100313TUL05Angle · corrodedPLOW ANGLE CORROSION REMOVAL BEYOND LIMITS. REMOVED AND REPLACED PLOW ANGLE PER SRM 51-30-02.SDR AALA20100313TUL03Doubler · corrodedCARGO AFT CX CORROSION FORWARD SIDE OF AFT PRESSURE BULKHEAD PLOW ANGLE DOUBLER. DOUBLER WAS OUT OF LIMITS PER SRM 53-01. NEW AFT PRESSURE BULKHEAD DOUBLER (DELTA PLATE) WAS INSTALLED PER BOEING DRAWING PL5910130 AND SRM 51-30-05.SDR AALA20100313TUL02Cusp Web · crackedSTATION 218 RIGHT CUSP SHEET IS CRACKED AND CORRODED AT AFT OUTBOARD CORNER AREA AT NUMBER 6 SEAT TRACK AREA. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100312TUL04Pan · crackedAT STATION 1098 LEFT FOUND THE UPPER AFT EAR OF THE WINDOW PAN CRACKED. CUT OUT CRACKED AREA OF RING PAN AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100312TUL03Pan · crackedAT STATION 1060 LEFT FOUND THE LOWER FORWARD EAR OF THE WINDOW PAN CRACKED. CUT OUT CRACKED AREA OF RING PAN AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100312TUL02Cargo Track · corrodedAFT CARGO HAS CORROSION LEFT TIE DOWN TRACK ATTACH POINTS AND UPPER EDGE TABS STATION 1220 TO 1322. INSTALLED NEW TRACK PER SRM 51-30.SDR AALA20100312TUL01Cargo Track · corrodedCORROSION ON LEFT TIE DOWN TRACK STA 1220 SPLICE TOP AND BOTTOM IN AFT CARGO. INSTALLED NEW SPLICE PER SRM 51-30.SDR AALA20100311TUL05Frame · corrodedCORROSION ON FRAME 1231 AFT SIDE LONGERON 30. FRAME 1231 FOUND TO BE OUT OF LIMITS ABOVE LONGERON 30. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER AND FILLER PER AARD 53-10-00-17.SDR AALA20100311TUL04Rib · crackedRIGHT NUMBER 5 SLAT, NUMBER 15 SLAT TRACK RIB CRACKED ON OUTBOARD SIDE. REPLACED NUMBER 15 RIB ON NUMBER 5 SLAT UNDER ESO 80117.SDR AALA20100311TUL03Rib · crackedRIGHT NUMBER 5 SLAT, NUMBER 14 SLAT TRACK RIB CRACKED AT OUTBOARD SIDE. REPLACED DAMAGED NUMBER 14 RIB ON NUMBER 5 SLAT UNDER ESO 80117.SDR AALA20100311TUL02Skin · dentedDENT IN FUSELAGE STATION 206 BETWEEN LONGERON 4 LEFT AND 5 LEFT. COLD WORKED DENT REF: SRM 53-04 FIG 38 DYE CHECKED NO CRACKS FOUND. INSTALLED DOUBLER PER SRM 53-04 FIG 38.SDR AALA20100311TUL01Frame · corrodedAFT CARGO FRAME 1271 AFT SIDE LONGERON 27 LEFT TO LONGERON 26 RIGHT HAS CORROSION. BLENDED OUT CORROSION UNDER SRM 51-10-03. OUT OF LIMITS. INSTALLED REPAIR "J" ANGLE DOUBLER UNDER AARD 53-10-00-14.SDR AALA20100310TUL02Fitting · crackedFITTING IN LOWER FORWARD CORNER OF DOOR CUTOUT IS CRACKED STATION 1155 AT AFT CARGO. INSTALLED NEW CORNER SUPPORT PER SRM 51-30-05.SDR AALA20100310TUL11Frame · crackedSTATION 1418 FRAME CRACKED AT LONGERON 2 RIGHT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR AALA20100310TUL09Cusp Web · crackedRIGHT CUSP CRACKED STATION 1173. INSTALLED DOUBLER AT STATION 1173 PER EA MD80-53-009531.SDR AALA20100310TUL07Skin · damagedHOLE IN FUSELAGE ON LEFT SIDE JUST FORWARD OF TAIL CONE BELOW LOUVER BOX. INSTALLED DOUBLERS PER SRM 53-01-00 FIGURE 4 SHEET 4 AND SRM 53-01-00 FIGURE 1 SHEET 2.SDR AALA20100310TUL06Cusp Web · corrodedRIGHT CUSP CORRODED AT STATION 1183 TO 1186. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100310TUL05Membrane · corrodedCORROSION TOP SIDE OF SUBFLOOR STATION 200 TO 216 OUTBOARD SIDE OF SEAT TRACK NUMBER 5. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD53-20-00-16.SDR AALA20100311LGA01Battery Pack · dischargedEMERGENCY LIGHT AT OVERHEAD SEAT ROWS 17 TO 22 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROWS 17 TO 22. OPS CHECKED NORMAL.SDR AALA20100309TUL03Tie Down · corrodedCORROSION TOP OF GALLEY TIE DOWN. INSTALLED NEW GALLEY TIE DOWN FITTING PER SRM 51-30-05.SDR AALA20100309TUL02Membrane · corrodedCORROSION ON SUBFLOOR UNDER GALLEY TIE DOWN AT STATION 218 RIGHT BUTTLINE 11. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100309TUL09Seat Track · corrodedCORROSION AT NUT CLIP HOLE ON OUTBOARD FLANGE OF SEAT TRACK NUMBER 5 STATION 204 OUT OF LIMITS. CUT OUT CORROSION AND INSTALLED STRAP PER AARD 53-20-00-13.SDR AALA20100309TUL08Fitting · corrodedCORROSION ON LOWER AFT FITTING AFT CARGO DOOR CUTOUT STATION 1212. REPLACED SUPPORT FITTING PER AARD 51-00-00-12.SDR AALA20100309TUL07Cusp Web · corrodedCUSP HAS CORROSION BETWEEN NUMBER 10 SEAT TRACKS STATION 1287. REPLACED LEFT CUSP SHEET STATION 1250 TO 1309 PER AARD 53-20-00-16.SDR AALA20100309TUL06Beam · corrodedCORROSION ON LOWER DOOR CUTOUT BEAM STATION 1155 TO 1212 ON LOWER LEG FOR AFT CARGO. INSTALLED DOOR BEAM DOUBLER PER AARD 53-10-00-3 AND SRM 51-30.SDR AALA20100309TUL05Bracket · crackedCRACK IN SUPPORT SHELF ABOVE RIGHT MAIN LANDING GEAR DOOR ACTUATOR. REMOVED AND REPLACED SHELF BRACKET PER SRM 51-30-5.SDR AALA20100309TUL01Skin · dentedFUSELAGE DENT AT STATION 300 BETWEEN LONGERON 22 RIGHT AND 23 RIGHT. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 12B.SDR AALA20100309LGA02Battery Pack · dischargedSEAT EMERGENCY LIGHTS IN FORWARD CABIN INOPERATIVE. REPLACED FORWARD BATTERY PACK AT ROW 20DEF, OPS CHECKS NORMAL.SDR AALA20100309LGA01Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 9 TO 12 INOPERATIVE. REPLACED BATTERY PACK AT ROW 9 FOR EMERGENCY LIGHTS FROM ROWS 9 TO 12, OPS CHECKS NORMAL.SDR AALA20100308TUL04Fitting · corrodedGALLEY FITTING UNDER SUBFLOOR G-2 GALLEY INBOARD AFT MOUNT CORRODED. INSTALLED NEW FITTING PER SRM 51-30-05.SDR AALA20100308TUL03Seat Track · damagedNUMBER 2 SEAT TRACK HAS CORROSION STATION 1305. NUMBER 2 SEAT TRACK WAS REPAIRED PER SRM 53-05-00 FIGURE 4F.SDR AALA20100308TUL02Beam · crackedFORWARD ENTRY FORWARD END OF NUMBER 2 BEAM CRACKED. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 52-05-00 SHEET 13.SDR AALA20100308TUL01Beam · crackedFORWARD ENTRY DOOR AFT END NUMBER 2 BEAM CRACKED. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 52-05 -00 FIGURE 31 SHEET 13.SDR AALA20101122TUL09Lanyard · brokenFOUND RIGHT NUMBER 1 GIRT BAR LANYARD BROKEN AND FRAYED. REPLACED LANYARD FOR RIGHT NUMBER 1 GIRT BAR. OPS CHECK NORMAL.SDR AALA20100308ATL01Lanyard · brokenFOUND LEFT NUMBER 1 DOOR GIRT BAR LANYARD BROKEN AND FRAYED. REPLACED LANYARD FOR LEFT NUMBER 1 DOOR GIRT BAR. CPN LANR005SDR AALA20100308TPA02Wire · openEMERGENCY LIGHTS IN AFT STAIRS SIDEWALL INOPERATIVE. FOUND OPEN WIRE BETWEEN AFT AIRSTAIR SIDEWALL EMERGENCY LIGHT AND WIRE BUNDLE ON LEFT EMPENNAGE SIDEWALL APPROXIMATE STATION 1336 AFT TO STATION 1550. SPLICED WIRE IN PER WSPM CHAPTER 20. OPS CHECK NORMALSDR AALA20100307TUL05Door · damagedLOWER FORWARD CORNER WILL NOT FAIR, EXCEEDS UNDER FAIR REQUIREMENT BY .125 TO .200 POSITIVE FAIR. FABRICATED AND INSTALLED NEW DOUBLER CORNER DOUBLER PER ESO 80174.SDR AALA20100307TUL04Longeron · crackedLONGERON 3 LEFT CRACKED OUTBOARD SIDE AT RADIUS STATION 160. ACCOMPLISHED SPLICE REPAIR PER SRM 53-02-00 FIGURE 18.SDR AALA20100307TUL01Intercostal · crackedSTATION 826 HAS LOWER ANGLE ON INTERCOSTAL CRACKED AT TOP OF CENTER FUEL TANK AT RIGHT SIDE JUST BELOW NUMBER 5 SEAT TRACK. INSTALLED REPAIR ANGLES AT STATION 826 RIGHT SIDE PER EA MD80-57-009377 DATED 3/1/10 AND LEAK CHECKING FASTENERS PER AMM 28-10-01, NO LSDR AALA20100308TPA01Wire · brokenSEAT 28DEF EGRESS LIGHT INOPERATIVE. FOUND WIRE TO LIGHT SOCKET BROKEN. REPAIRED BROKEN WIRE. OPS CHECKED NORMAL.SDR WX0A070538Unknown · odorFLIGHT ATTENDANT REPORTED ELECTRICAL BURNING SMELL FROM ROW 24 THROUGH THE AFT GALLEY. SMELL STRONGEST AT ROW 24 AND AFT GALLEY. OVERHEAD PANELS FROM ROW 22-27 FELT VERY HOT, WHILE SURROUNDING AREAS WERE ICE COLD. MAINTENANCE DEPARTMENT PERSONNEL GAINED ACCSDR AALA20100307TUL02Doubler · corrodedAFT CARGO CORROSION FORWARD SIDE OF AFT PRESSURE BULKHEAD PLOW ANGLE DOUBLER STATION 1338 LONGERON 30. REPLACED DOUBLER PER SRM 51-01-00 AND SRM 51-30-00.SDR AALA20100306TUL02Membrane · crackedSUBFLOOR CRACKED STATION 155. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100306TUL01Cargo Track · corrodedAFT CARGO RIGHT TIE DOWN TRACK CORRODED OUT OF LIMITS AROUND FASTENER HOLES BETWEEN STATIONS 1122 AND 1155. REPLACED RIGHT TIE DOWN TRACK PER SRM 51-30-01 AND 51-01-00-02.SDR AALA20100305TUL08Pressure Panel · crackedCRACK IN PRESSURE DECK STATION 965. INSTALLED DOUBLER.SDR AALA20100305TUL12Cusp Web · crackedEMERGENCY EQUIPMENT COMPARTMENT RIGHT SIDE SUB FLOOR CRACKED BELOW GALLEY 1 WATER DRAIN PAN STATION 155. INSTALLED DOUBLER PER AARD 53-20-00-16SDR AALA20100305TUL09Shear Tie · damagedDAMAGED SHEAR TIE STATION 1287. REPLACED SHEAR TIE PER SRM 51-30-5.SDR AALA20100307TUL03Doubler · crackedSTATION 1022 LEFT WINDOW PAN DOUBLER IS CRACKED AT UPPER AFT CORNER. REPAIRED PER AARD 53-10-00-25.
Back to Mcdonnell Douglas DC-9-82