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 AALA20090406TUL10Pan · crackedTOP AFT TANG CRACKED ON RIGHT WINDOW PAN AT STATION 1042. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090406TUL09Longeron · crackedLONGERON 4L CRACKED AT OUTBOARD FASTENER STATION 200. INSTALLED NEW LONGERON PER SRM 53-02.SDR AALA20090406TUL08Pan · crackedLEFT PAN CRACKED TOP FORWARD CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090406TUL07Cusp Web · corrodedCORROSION ON BOTTOM SIDE OF CUSP RIGHT SIDE STATION 636-655. REPLACED CUSP SHEET PER AARD 53-20-00-16.SDR AALA20090406TUL06Cargo Track · corrodedCORROSION ON LEFT HAND TIE DOWN TRACK IN AFT CARGO STATION 1022-1212. REMOVED AND REPLACED TIE DOWN TRACK PER AARD 51-00-00-012.SDR AALA20090409TUL02Support Bracket · damagedFWD GIRT BAR SUPPORT BRACKET WAS DAMAGED DURING REMOVAL FOR OTHER MAINTENANCE (CUSP REPAIR). INSTALLED NEW BRACKET AT STATION 1143 LEFT SIDE PER SRM 51-01.SDR AALA20090403TUL07Cusp Web · corrodedLEFT CUSP CORRODED STATION 1163-1168. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20090403TUL06Cusp Web · corrodedCORROSION ON TOP OF LEFT CUSP STATION 570-579. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090331TUL50Cusp Web · crackedCRACK IN RIGHT CUSP AT STATION 218 OUTBOARD OF NR 5 SEAT TRACK. INSTALLED CUSP SHEET PER AARD 53-20-00-16.SDR AALA20090331TUL46Cusp Web · corrodedCORROSION FOUND UNDER AFT GIRT BAR SUPPORT BRACKET AT STATION 1170. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20090331TUL43Cusp Web · corrodedRIGHT CUSP CORRODED FROM STATION 1174-1193. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-18.SDR AALA20090331TUL42Seat Track · corrodedSEAT TRACK NR 5 CORRODED BEYOND LIMITS FROM STATION 200-206. INSTALLED NEW TRACK SECTION PER SRM 53-05-00 FIGURE 4.SDR RYNA200903200004Proximity Sensor · out of adjustON DEPARTURE FROM SAP DURING INITIAL GEAR RETRACTION THE RED NOSE LANDING GEAR UNSAFE LIGHT REMAINED ON. RECYCLED GEAR OPS CHECK NORMAL NO FURTHER PROBLEMS WERE NOTED. FOUND LOCK SENSOR CONDUIT MISROUTED AND CLAMP SMASHED. REPLACED CLAMP AND REROUTED CONDUISDR AALA20090403TUL08Cusp Web · corrodedCORROSION ON BOTTOM SIDE OF LEFT CUSP BETWEEN STATIONS 636-655. INSTALLED NEW LEFT CUSP SECTION FROM STATION 598-710 PER SRM 51-30.SDR AALA20090403TUL05Cusp Web · corrodedHEAVY CORROSION ON TOP OF LEFT CUSP STATION 826-845. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090403TUL04Cusp Web · corrodedHEAVY CORROSION ON TOP OF LEFT CUSP STATION 826-845. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090403TUL03Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 1380 LONGERON 12R. INSTALLED DOUBLER PER AARD 53-30-00-02.SDR AALA20090403TUL02Strap · damagedSCREW GOUGE IN STRAP BELOW Z-ANGLE INBOARD SIDE AT STATION 698 IN MID CARGO. REMOVED AND REPLACED STRAP PER AARD 51-00-00-12.SDR AALA20090402TUL29Strap · damagedGOUGE IN STRAP AT STATION 630 IN MID CARGO. REPLACED STRAP PER AARD 51-00-00-12.SDR AALA20090402TUL28Frame · damagedUPPER HORIZONTAL FLANGE OF FRAME DAMAGED WHERE 2 FASTENERS ATTACH TO LONGERON 4L. INSTALLED J-ANGLE DOUBLER AND FILLER PER AARD 53-10-00-17.SDR AALA20090402TUL27Cusp Web · corrodedCUSP CORRODED LEFT SIDE UNDER GIRT BAR FITTING AT STATION 1143. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090331TUL41Cusp Web · corrodedCORROSION ON CUSP UNDER FORWARD GIRT BAR BRACKET AT AFT SERVICE DOOR. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090331TUL40Bracket · corrodedFORWARD GIRT BAR BRACKET CORRODED AT AFT SERVICE DOOR. REMOVED AND REPLACED GIRT BAR BRACKET PER AARD 53-20-00-16.SDR AALA2009031700983Battery · dischargedLGA - AFT GALLEY FLASHLIGHT INOPERATIVE. INSTALLED NEW BATTERIES FOR AFT GALLEY FLASHLIGHT.SDR AALA20090402TUL25Beam · corrodedMID CARGO DOOR BEAM CORRODED BETWEEN STATION 636 AND 693. REPAIRED PER EA MD80 53-005707 DATED 03/12/09.SDR AALA20090402TUL24Frame · crackedOVERWING FRAME CRACKED IN UPPER RADIUS AT LEFT SIDE STATION 886. REPLACED STATION 886 FRAME PER SERVICE REWORK DRAWING SRO 9530282.SDR AALA20090402TUL23Cusp Web · corrodedCARGO ON BOTTOM OF CUSP RIGHT SIDE FROM STATION 1193-1212. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090402TUL22Frame · crackedCRACK IN RADIUS OF CANTED FRAME 1463, LONGERON 18L. REPAIRED PER SRM 53-01-00 FIGURE 2 SHEET 4.SDR AALA20090402TUL21Beam · corrodedCORROSION ON AFT CARGO DOOR BEAM VERTICAL LEG STATION 1155 TO 1211. REPAIRED DOOR BEAM PER AARD 53-10-00-3 AND EA MD80-53-005703.SDR AALA20090402TUL20Cusp Web · corrodedCORROSION ON TOP OF LEFT CUSP AT STATION 219. REPLACED CUSP SHEET FROM STATION 218 TO 237 PER AARD 53-20-00-16.SDR AALA20090331TUL39Pan · crackedRIGHT WINDOW PAN CRACKED AT STATION 946 LOWER CORNER. REMOVED CRACKED TAB AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090331TUL38Seat Track · corrodedSEAT TRACK NR 2 CORRODED FROM STATION 216-220. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090317TUL39Frame · crackedSTATION 1485 CANTED FRAME LEFT UPPER WEB IS CRACKED. INSTALLED DOUBLER REPAIR PER AARD 53-10-00-32.SDR AALA20090317TUL38Frame · crackedSTATION 1510 CANTED FRAME IS CRACKED AT LEFT LOWER ALIGNMENT PIN. INSTALLED DOUBLER PER EA MD80-53-005724 DATED 03/16/09.SDR AALA2009031500002Module · inoperativeMSP - FLOOR OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED MODULE FOR AISLE EMERGENCY LIGHTS.SDR AALA2009031500001Module · inoperativeMSP - SEATS 1 TO 21 TRACK LIGHTING INOPERATIVE. REPLACED MODULE FOR AISLE EMERGENCY LIGHTS.SDR AALA20090402TUL15Doubler · crackedCRACK IN REPAIR DOUBLER AT CANTED FRAME 1485 LEFT SIDE BELOW AIRSTAIR RETRACT ACTUATOR. INSTALLED NEW DOUBLER PER AARD 53-10-00-33.SDR AALA20090402TUL14Frame · corrodedCORROSION ON LOWER FLANGE OF FRAME AT STATION 1309, LONGERON 30. INSTALLED J-ANGLE DOUBLER PER AARD 53-10-00-17.SDR AALA20090331TUL36Cusp Web · crackedLEFT CUSP CRACKED BETWEEN STATION 218-237. REMOVED AND REPLACED CUSP SHEET PER SRM 51-01-00.SDR AALA20090331TUL35Frame · crackedFRAME CRACKED OUT AT STATION 905 ABOVE CENTER FUEL TANK AT THE CENTER FLOORBOARD. REMOVED AND REPLACED CRACKED FRAME PER SRM 51-01-00 PARAGRAPH 2D.SDR AALA2009031500600Battery Pack · dischargedDFW - OVERWING EMERGENCY LIGHTS AT SEAT 21 ABOVE WINDOW INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHT AT SEAT 21.SDR AALA2009031500599Battery Pack · dischargedMSP - OVERHEAD EMERGENCY EXIT LIGHTS AT ROW 7 TO 11 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY EXIT LIGHTS AT ROW 7 TO 11.SDR AALA2009031500598Lamp · missingMSP - EMERGENCY LIGHT AT SEAT 13D MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 13D.SDR AALA2009031500597Lens · missingMSP EMERGENCY LIGHT AT SEAT 13D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 13D.SDR AALA2009031500596Battery Pack · dischargedMSP EXTERIOR LEFT AND RIGHT HAND OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT EXTERIOR LEFT AND RIGHT HAND OVERWING.SDR AALA2009031500590Wire · brokenLGA - EXIT LIGHTS AT ROW 17 INOPERATIVE. REPAIRED BROKEN WIRE UNDER ROW 17.SDR AALA20090403TUL01Bracket · crackedSHELF BRACKET JUST FORWARD OF RIGHT DOOR ACTUATOR UPPER MOUNT IS CRACKED AT THE AFT SIDE. REMOVED AND REPLACED DOOR ACTUATOR BRACKET PER SRM 51-01.SDR AALA20090402TUL30Bracket · crackedSHELF BRACKET JUST FORWARD OF THE LEFT GEAR DOOR ACTUATOR UPPER MOUNT IS CRACKED AT THE AFT SIDE OF THE RADIUS. REMOVED AND REPLACED LEFT DOOR ACTUATOR BRACKET PER SRM 51-01.SDR AALA20090402TUL26Intercostal · crackedINTERCOSTAL CRACKED IN CEILING OF AFT CARGO AT STATION 1309. INSTALLED DOUBLER PER EA MD80 53-005713 DATED 03/13/09.SDR AALA20090402TUL19Cusp Web · crackedCRACK IN LEFT CUSP AT STATION 245. INSTALLED DOUBLER PER AARD 53-20-00-16.
Back to Mcdonnell Douglas DC-9-82