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 AALA200810175Frame · crackedFRAME CRACKED AT STATION 1510, LOWER RIGHT TAIL CONE ALIGNMENT PIN. INSTALLED DOUBLER PER ESO 80559 DATED, 10 NOV 08.SDR AALA200810174Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE AT 1451 LONGERON 2R. REPLACED SHEAR TIE.SDR AALA200810169Frame · crackedCRACK IN RADIUS ON FRONT SIDE OF FRAME 1418 AT LONGERON 2R. REPAIRED 1418 2R FRAME CRACK PER ESO 80559 DATED 11/10/08.SDR AALA200802475ABrake Assy · overheatedDFW - DURING TAKEOFF ROLL BRAKE TEMPERATURE LIGHT FLASHED AT 100 KNOTS FOLLOWED BY A STEADY LIGHT AND TEMPERATURE HIGH INDICATION. ABORTED TAKEOFF AT 110 KNOTS. AIRCRAFT TOWED TO HANGAR FOR EVALUATION. REPLACED NUMBER ONE MAIN LANDING GEAR BRAKE ASSEMBLY ANSDR AALA200810226Web · corrodedCORROSION ON SUBFLOOR, STATION 200 TO 218 BETWEEN NUMBER 4 AND NUMBER 5 SEAT TRACKS. REPAIRED PER AARD 53-20-00-16, INSTALLED DOUBLER.SDR AALA200810225Cusp Web · corrodedCORROSION ON CUSP BETWEEN STATION 256 TO 275 LEFT SIDE. INSTALLED NEW CUSP MEMBRANE FROM STATION 237 TO 313.SDR AALA200810173Longeron · crackedCRACK IN LONGERON RADIUS IN AFT ACCESSORY COMPARTMENT STATION 1418. INSTALLED LONGERON REPAIR SPLICE PER AARD 53-30-00-2.SDR AALA200810229Finger Doubler · corrodedCORROSION ON SKIN SPLICE FINGER DOUBLER STATION 1245 TO 1310 AT LONGERON 26L. REMOVED AND REPLACED SKIN SPLICE FINGER DOUBLER AND INSTALLED LONGERON SPLICES AT STATION 1240 AND 1310 PER SRM 51-01-00.SDR AALA200810228Cusp Web · corrodedCORROSION ON CUSP AT STATION 503 TO 617. REPLACED CUSP PER SRM 51-01-00.SDR AALA200810172Frame · crackedCRACK APPROXIMATELY 1 INCH IN LENGTH AT TOP OF OPENING FOR LEFT FORWARD OVERWING EXIT DOOR, FORWARD OF LATCH. STOP DRILLED AND DOUBLER INSTALLED PER SRM 53-05-00 FIGURE 32, SHEET 1.SDR AALA200810171Casting · crackedGROUND SPOILER ACTUATOR MOUNT CASTING IS CRACKED AT FORWARD INBOARD END. REMOVED AND REPLACED CASTING.SDR AALA200810170Frame · crackedFRAME CRACKED AT 4 O`CLOCK POSITION STATION 1510, AT TAIL CONE ALIGNMENT PIN. INSTALLED DOUBLER PER ESO 80559 DATED 11/07/08.SDR AALA200810236Seat Track · corrodedSEAT TRACK NR 2 CORRODED STATION 1221 TO 1307. REPLACED SEAT TRACK SECTION FROM STATION 1031 TO 1309 PER AARD 51-010-00-012.SDR AALA200810233Seat Track · corrodedSEAT TRACK NR 2 CORRODED FROM STATION 1031-1221. REPLACED SEAT TRACK.SDR AALA200810224Intercostal · crackedAFT CARGO, CRACK IN INTERCOSTAL AT STATION 1271 TO 1287. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-30-00.SDR AALA200810221Cusp Web · corrodedCORROSION ON CUSP AT STATION 598 TO 617 RIGHT SIDE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810220Web · crackedWEB CRACKED AT NUTPLATE, STATION 1215 LONGERON 28R. STOP DRILLED CRACK AND REPAIRED PER ESO 80559 DATED 11-06-08.SDR AALA200810219Angle · crackedVERTICAL ANGLE ABOVE VAULT DOOR JAMB FORWARD SIDE OF AFT PRESSURE BULKHEAD CRACKED AT STATION 1338. REMOVED AND REPLACED ANGLE PER SRM 53-30-00.SDR AALA200810218Intercostal · crackedCABIN FLOOR SUPPORT, INTERCOSTAL CRACKED AT STATION 1287 TO 1209. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-30-00.SDR AALA200810217Angle · corrodedCORROSION ON T-ANGLE AT STATION 1155 AT LONGERON 28R. REMOVED AND REPLACED T-ANGLE PER SRM 51-30-5.SDR AALA200810168Cusp Web · damaged3/8 INCH HOLE IN CUSP LEFT SIDE, AFT OF FRAME 864, APPROXIMATE 10 INCH AFT AND INBOARD 6 3/4 INCH. INSTALLED DOUBLER PER SRM 53-01-00 IN CABIN FLOOR CUSP.SDR AALA200810151Frame · wornRIGHT FRAME 1497 WORN. INSTALLED DOUBLER ON 1497 FRAME PER SRM 53-10-00-15.SDR AALA200810223Cusp Web · corrodedCORROSION ON CUSP T AT RIGHT SIDE AT STATION 598. INSTALLED SPAR SECTION OF TEE.SDR AALA200810215Cusp Web · corrodedLEFT CUSP MEMBRANE CORRODED STATION 1022. INSTALLED NEW CUSP SHEET PER AARD 51-00-00-12.SDR AALA200810214Longeron · crackedLONGERON 4 LEFT CRACKED AT STATION 180 AND 200. SPLICED IN A NEW SECTION OF LONGERON.SDR AALA200810213Skin · separatedFUSELAGE SKIN SEPARATED AT BOTTOM FORWARD CORNER OF THE AFT LAVATORY SERVICE PANEL. INSTALLED DOUBLER ON BOTTOM HALF OF SKIN AT AFT LAVATORY SERVICE PANEL CUT-OUT PER ESO 80559 DATED 11/05/2008.SDR AALA200810212Cusp Web · crackedCRACK IN CUSP MEMBRANE STATION 219 UNDER SEAT TRACK NUMBER 5. FABRICATED AND INSTALLED DOUBLER.SDR AALA200810211Pan · corrodedCORROSION ON FORWARD CARGO DOOR PAN STATION 370-427. SPLICED IN NEW SECTION OF PAN STATION 370-427.SDR AALA200810216Cusp Web · corrodedCORROSION ON RIGHT CUSP AT STATION 1281 TO 1309. REMOVED AND REPLACED CUSP FROM STATION 1250 TO 1309 RIGHT SIDE PER AARD 53-20-00-16.SDR AALA200810210Web · corrodedSUB FLOOR WEB CORRODED, STATION 160-200, JUST INBOARD OF THE FORWARD SERVICE DOOR. INSTALLED DOUBLER STATION 160-200 PER AARD 53-20-00-16.SDR AALA200810209Cusp Web · crackedLEFT CUSP MEMBRANE CRACKED AT STATION 1250 BELOW THE NUMBER 2 SEAT TRACK. INSTALLED NEW SECTION OF CUSP FROM STATION 1174-1250 PER AARD 53-20-00-16.SDR AALA200810208Beam · corrodedMID CARGO DOOR BEAM CORRODED STATION 637-693. INSTALLED DOOR BEAM DOUBLER PER AARD 53-10-00-3.SDR AALA200810150Beam · crackedFWD ENTRY DOOR NUMBER 2 BEAM CRACKED AT FORWARD END. INSTALLED DOUBLER REPAIR PER SRM 52-05-00 FIG 31 AND ESO 80172.SDR AALA200810207Cusp Web · corrodedRIGHT CUSP MEMBRANE CORRODED STATION 886-905. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA200810204Seat Track · brokenBROKEN TANG ON SEAT TRACK NUMBER 3 AT STATION 1060. REPAIRED WITH SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA200810203Web · crackedCRACKED TANG ON WEB AFT OF THE FWD ENTRY DOOR STATION 208 AT LONGERON 11 LEFT. FABRICATED AND INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA200810202Strap · crackedTEE STRAP CRACKED STATION 207 AT LONGERON 11 LEFT. FABRICATED AND INSTALLED DOUBLER PER AARD 53-10-00-011.SDR AALA200802459Shroud · missingDFW - EMERGENCY LIGHT AT SEAT ROW 22 MISSING SHROUD. REPLACED SHROUD AT SEAT ROW 22 SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802454ABattery Pack · dischargedLGA - EMERGENCY LIGHTS AT RIGHT OVERWING INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 20 FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802453ABattery Pack · dischargedLGA - EMERGENCY LIGHTS AT AFT GALLEY DROP DOWN PANEL INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802452ABattery Pack · dischargedLGA - EMERGENCY LIGHTS AT FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802451ABattery Pack · dischargedLGA - OVERHEAD EMERGENCY LIGHTS AT SEAT ROW 24 INOPERATIVE. REPLACED BATTERY AND CHARGER AT SEAT ROW 25DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802447ABattery Pack · dischargedLGA - EXTERNAL OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR EXTERNAL OVERWING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810149Bracket · crackedBRACKET CRACKED BY INSIDE DOOR HANDLE IN CORNER OF FWD PASSENGER DOOR. INSTALLED ANGLE DOUBLER PER SRM 52-05-00.SDR AALA200810206Cusp Web · corrodedRIGHT CUSP MEMBRANE CORRODED STATION 655-674. INSTALLED CUSP DOUBLER STATION 654-670.SDR AALA200810205Cusp Web · corrodedRIGHT CUSP MEMBRANE CORRODED AT STATION 1197 - 1200. INSTALLED CUSP DOUBLER STATION 1197-1200 PER AARD 53-20-00-16.SDR AALA200810201Cusp Web · corrodedRIGHT CUSP MEMBRANE CORRODED FROM STATION 1174 TO 1193. INSTALLED NEW CUSP MEMBRANE.SDR AALA200802442ABattery Pack · dislodgedLGA - EMERGENCY LIGHTS AT AFT LAVATORY INOPERATIVE. REPOSITIONED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802441ABattery Pack · dislodgedLGA - EMERGENCY LIGHTS AT SEAT ROWS 6 TO 12 INOPERATIVE. REPOSITIONED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802434ALight · inoperativeLGA - EMERGENCY LIGHT EXIT SIGN AT LEFT AFT STAIRWAY INOPERATIVE. REPLACED LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82