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 AALA200810030Seat Track · corrodedSEAT TRACK NR 6 HAS CORROSION, STATION 214-220 RIGHT. INSTALLED NR 6 SEAT TRACK SPLICE PER SRM 53-05-00.SDR AALA200810029Cusp Web · corrodedCRACK IN CUSP STATION 219 RIGHT OUTBOARD OF NR 6 SEAT TRACK. INSTALLED NEW CUSP AT STATION 218 TO 237 RIGHT, PER AARD 53-20-00-16.SDR AALA200810084Cusp Web · corrodedCORROSION UNDER LEFT CUSP AT STATION 489. REMOVED CORROSION. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810028Cusp Web · corrodedCORROSION ON CUSP STATION 218 UNDER G-2 GALLEY MOUNT. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA200810083Bracket · corrodedAFT CARGO AREA, TEE BRACKET CORRODED STATION 1155 LOWER FORWARD CORNER OF DOOR OPENING. REMOVED AND REPLACED TEE BRACKET AT STATION 1155 PER SRM 51-10-1.SDR AALA200810081Cusp Web · corrodedRIGHT HAND CUSP CORRODED AT STATION 1155-1174 IN PASSENGER CABIN. REMOVED CORROSION PER SRM 51-10-3, INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810080Floor Support · corrodedAFT CARGO FLOORBOARD SUPPORT CORRODED STATION 1212 AT LONGERON 28L TO 29L. REMOVED AND REPLACED FLOORBOARD SUPPORT PER SRM 51-10-1.SDR AALA200810079Shear Tie · corrodedAFT CARGO AREA, CORROSION AFT LOWER ANGLE STATION 1211 AT LONGERON 30R TO 29R. INSTALLED SERVICEABLE SHEAR TIE AT STATION 1211 PER SRM 51-10-1.SDR AALA200810078Intercostal · corrodedAFT CARGO COMPARTMENT, INTERCOSTAL BETWEEN FLOORBEAMS AT STATION 1287-1309 UPPER LEG HAS CORROSION AFT END IS CRACKED. INSTALLED NEW INTERCOSTAL PER AARD 51-00-012 AT STATION 1287.SDR AALA200810077Cusp Web · corrodedCORROSION ON CUSP AT STATION 1136 TO 1174. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810076Cusp Web · corrodedLEFT CUSP CORRODED AT STATION 1155 TO 1174. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200802739Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT MID CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT MID CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802738Battery Pack · dischargedLGA - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810096Doubler · cracked"J" ANGLE DOUBLER CRACKED. INSTALLED NEW J ANGLE DOUBLER.SDR AALA200810074Structure · crackedSUBFLOOR CRACKED OUTBOARD SIDE OF NUMBER 2 SEAT TRACK AT STATION 218. INSTALLED DOUBLER PER SRM 53-20-00-16.SDR AALA200810042Frame · cutBELLFRAME STATION 1338 CUT AT LONGERON 6 RIGHT. REMOVED SECTION FROM LONGERON 6 RIGHT TO LONGERON 18 RIGHT FOR OTHER MAINTENANCE. SPLICED IN REPAIR PER ESO 80559 DATED SEPT 29-08 IN AFT CABIN.SDR AALA200810097Floor Support · crackedFLOOR BOARD SUPPORT CRACKED AT LOWER FWD SIDE BELOW SEAT TRACK NR 5. INSTALLED NEW SUPPORT.SDR AALA2008Angle · crackedLEFT NOSE LANDING GEAR DOOR JAM BEAM J ANGLE DOUBLER CRACKED AT STA 47. INSTALLED NEW J ANGLE DOUBLER.SDR AALA200810027Cusp Web · corrodedRIGHT CUSP CORRODED. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810026Angle · corrodedCORROSION ON UNDERSIDE OF CUSP ANGLE BETWEEN STATION 204-218. REPLACED CUSP ANGLE.SDR AALA200810025Cusp Web · corrodedCUSP ANGLE CORRODED STATION 160 RIGHT. REPLACED CUSP ANGLE FROM STATION 144 TO 227 PER SRM 53-05-00 AND ESO 80559 DATED 10/13/08.SDR AALA200810082Cusp Web · corrodedCORROSION ON DOUBLER LEFT CUSP AT STATION 664-668. INSTALLED NEW CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA200802734Lamp · burned outLGA - SEAT MOUNTED EMERGENCY LIGHT AT SEAT 23D INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 23D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810024Bolt · migratedBOLT FOR NOSE LANDING GEAR RETRACK CYLINDER SCORED DUE TO MIGRATING EYE BOLT BUSHINGS. REPLACED BOLT AND BUSHINGS PER 32-32-06.SDR AALA200810023Cylinder · damagedRETRACK CYLINDER STRUCK NOSE LANDING GEAR CASTING. INSTALLED NEW NOSE LANDING GEAR RETRACK CYLINDER.SDR AALA200810022Shear Tie · corrodedSHEAR TIE CORRODED IN AFT CARGO AT STATION 1287 LONGERON 29 LEFT. INSTALLED SHEAR TIE AND DOUBLER PER SRM 53-03-00.SDR AALA200810020Floor Panel · corrodedCORROSION ON SUBFLOOR FORWARD OF NR 6 SEAT TRACK. CORROSION REMOVED AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810007Membrane · corrodedSUB FLOOR HAS 1 INCH AREA OF CORROSION AT G1 GALLEY STATION 154 TO 160. REMOVED CORROSION AND INSTALLED REPAIR DOUBLER PER ESO 80559 DATED 10-13-2008 AND AARD 53-20-00-16.SDR AALA200802731Oil System · low pressurePHL INFLIGHT JFK TO DFW - DURING CLIMB NUMBER ONE ENGINE OIL PRESSURE LOW LIGHT ILLUMINATED. OIL PRESSURE DROPPED TO ZERO ON GAUGE AND OIL TEMPERATURE DROPPED. CREW SHUT DOWN ENGINE AS PRECAUTION. LANDED PHL WITHOUT INCIDENT. SINGLE ENGINE TIME 15 MINUTES.SDR AALA200810073Floorbeam · crackedCRACK AT FORWARD LOWER END OF FLOORBEAM SUPPORT, STATION 927 BELOW NR 2 SEAT TRACK. REPLACED FLOORBEAM SUPPORT PER SRM 51-01SDR AALA200810072Window Frame · crackedCRACK AT BELT BOTTOM CORNER ON WINDOW FRAME STATION 1098 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA200810071Structure · crackedFORWARD LOWER TANG CRACKED ON LT WINDOW PAN. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA200810019Beam · corrodedAFT DOOR BEAM CORRODED. INSTALLED DOUBLER PER AARD 53-10-00-03.SDR AALA200810018Seat Track · corrodedNUMBER 3 SEAT TRACK CORRODED AT STATION 1176 TO 1180. INSTALLED SEAT TRACK SPLICE PER 53-05-00.SDR AALA200810013Beam · out of limitsMID CARGO DOOR LAMB BEAM DAMAGE OUT OF LIMITS. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR AALA200810017Cusp Web · corrodedBOTTOM OF CUSP CORRODED AT STATION 1308 TO 1309 LONGERON 18 RIGHT. CUSP SHEET REPLACED FROM STATION 1250 TO 1309 PER AARD 53-20-00-16.SDR AALA200810016Cusp Web · cracked3 INCH CRACK IN LEFT CUSP BETWEEN NR 1 AND NR 2 SEAT TRACK AT STATION 1295. NEW LEFT CUSP INSTALLED AT STATION 1250 TO 1309 PER AARD 53-20-00-16.SDR AALA200810014Cusp Web · corrodedCORROSION ON RIGHT CUSP AT STATION 1155 TO 1174. CORROSION REMOVED AND DOUBLER INSTALLED PER AARD 53-20-00-16.SDR AALA200802724Battery Pack · looseLGA EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. RESET BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS BETWEEN AFT LAVATORIES. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200802723Battery Pack · dischargedLGA EMERGENCY LIGHTS IN FIRST CLASS CABIN INOPERATION. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200802721Battery Pack · dischargedLGA EMERGENCY LIGHTS AT OVERHEAD COCKPIT INOPERATIVE. REPLACED BATTERY PACK AT FIRST CLASS OVERHEAD ELECTRICAL BAY FOR EMERGENCY LIGHTS AT OVERHEAD COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200802720Battery Pack · dischargedLGA EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 6 TO 9 INOPERATIVE. REPLACED BATTERY PACK AT OVERHEAD BIN 6F FOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200810015Skin · scratchedSCRATCHES IN SKIN AFT OF AFT CARGO DOOR MEASURING 8 INCHS BY 1.25 INCHES. INSTALLED EXTERNAL FUSELAGE DOUBLER AND FILLER PER SRM 53-05, FIG 80.SDR AALA200810003Cusp Web · crackedCRACK IN CUSP AT STATION 223 RIGHT SIDE LIGHTING HOLE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810001Cusp Web · crackedCRACK IN CUSP AT STATION 223 RIGHT SIDE LIGHTING HOLE. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810095Cusp Web · corrodedCORROSION ON RIGHT HAND CUSP STATION 1179 TO 1189. REMOVED CORROSION AND INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA200810037Mount · corrodedGALLEY TIE DOWN MOUNT CORRODED. REPLACED GALLEY FLOOR MOUNT.SDR AALA20081010001Cusp Web · cracked2 EACH CRACKS IN LEFT HAND CUSP BETWEEN STATION 229 AND 237. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA200802710Wire Harness · disconnectedLGA EMERGENCY ESCAPE PATH LIGHT IN AFT SIDEWALL PANEL IN TAILCONE HAS WIRES DISCONNECTED. SECURED WIRES FOR EMERGENCY LIGHT IN AFT SIDEWALL PANEL IN TAILCONE. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200802709Connector · looseLGA EMERGENCY PATH LIGHTING AT SEAT 20D INOPERATIVE. RECONNECTED LOOSE CONNECTOR AT SEAT 20D FOR EMERGENCY PATH LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)
Back to Mcdonnell Douglas DC-9-82