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 AALA20100205TUL03Casting · crackedLEFT WING TRAILING EDGE CRACKED IN FORWARD INBOARD CORNER OF GROUND SPOILER ACTUATOR MOUNT CASTING. REPLACED LEFT GROUND SPOILER ACTUATOR CASTING PER BOEING DRAWING 5936832.SDR AALA20100205TUL01Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 1265. INSTALLED DOUBLER PER SRM 53-20-00-16.SDR AALA20100204TUL13Bushing · wornLEFT WING KNUCKLE BUSHINGS WORN OUTBOARD END OF NUMBER 4 SLAT. REPLACED KNUCKLE RIB ON NUMBER 4 OUTBOARD SLAT WITH NEW ONE IAW AARD 27-80-00-2.SDR AALA20100204TUL01Intercostal · crackedINTERCOSTAL AT STATION 180 UNDER FORWARD ENTRY SUBFLOOR CRACKED. INSTALLED NEW INTERCOSTAL PER SRM 51-00-00-012.SDR AALA20100204TUL14Skin · dentedDENT IN FUSELAGE STATION 179 AT LONGERON 22 LEFT. DAMAGED REMOVED AND DOUBLER INSTALLED PER EA008978.SDR AALA20100204LGA01Battery Pack · dischargedMID POSITION BATTERY PACK INOPERATIVE. REMOVED AND REPLACED BATTERY PACK.SDR AALA20100204TUL12Cargo Track · corrodedLEFT CARGO TIE DOWN TRACK CORRODED. REMOVED AND REPLACED TRACK PER SRM 53-01-01.SDR AALA20100204TUL09Intercostal · crackedINTERCOSTAL CRACKED AT CENTER OF CEILING IN AFT CARGO. REMOVED AND REPLACED INTERCOSTAL PER SRM 53-30-1.SDR AALA20100204TUL08Frame · damagedFRAME 1322 DAMAGED. INSTALLED SPLICE REPAIR PER SRM 53-03-00 FIGURE 2A.SDR AALA20100204TUL07Frame · damagedDAMAGE ON FRAME 1309. INSTALLED SPLICE REPAIR PER SRM 53-03-00 FIGURE 2A.SDR AALA20100204TUL15Cusp Web · corrodedCORROSION ON RIGHT CUSP STATION 1030. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20100204TUL11Doubler · corrodedCORROSION AT AFT CARGO DOOR BEAM DOUBLER. REMOVED DOUBLER AND CORROSION AND INSTALLED DOUBLER PER AARD 53-10-00-3.SDR AALA20100204TUL10Track · corrodedLEFT TIE DOWN TRACK HAS CORROSION STATION 1250. INSTALLED LEFT TIE DOWN TRACK FROM STATION 1220 TO 1322 AND TRACK SPLICE AT STATION 1220 PER SRM 51-30-01 AND 51-30-05.SDR AALA20100204TUL06Longeron · crackedHEAVY CABIN - CRACK AT LONGERON 3 LEFT IN RADIUS STATION 160. INSTALLED NEW LEFT LONGERON NUMBER 3 FROM STATION 148 TO 190 PER SRM 53-02-00.SDR AALA20100204TUL05Pan · crackedWINDOW PAN 32 RIGHT HAS CRACK IN UPPER FORWARD CORNER. TRIMMED OUT CRACK ON WINDOW PAN AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100204TUL04Pan · crackedSTATION 946 TO 965 LEFT SIDE WINDOW PAN CRACKED AT FORWARD UPPER CORNER. TRIMMED OUT CRACK ON WINDOW PAN AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100203SAN01Compressor · stalledSAN - CREW REPORTED RIGHT ENGINE COMPRESSOR STALLED TWICE DURING CLIMBOUT. EMERGENCY DECLARED RETURNED SAN LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT ENGINE AT SAN ON 02/04/2010. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20100204TUL03Longeron · crackedCRACK AT LONGERON 4 LEFT IN RADIUS STATION 200. REMOVED AND REPLACED CRACKED LONGERON FROM STATION 148 TO EXISTING SPLICE AT STATION 227 PER SRM 53-02-00.SDR AALA20100204TUL02Longeron · crackedCRACK AT LONGERON 4 LEFT IN RADIUS STATION 160. REMOVED AND REPLACED CRACKED LONGERON TO EXISTING SPLICE PER SRM 53-02-00.SDR AALA20100203TUL14Cusp Web · damagedDAMAGE ON CUSP AT STATIONS 1155 TO 1174. INSTALLED SERVICEABLE CUSP SHEET IAW SRM 53-20.SDR AALA20100203TUL12Skin · dentedDENT IN FUSELAGE SKIN 5 INCHES LONG, .021 INCHES DEEP AT STATION 70, BETWEEN LONGERON 24 RIGHT AND LONGERON 25 RIGHT. COLD WORKED DENT, DYE-CHECKED NO CRACKS FOUND. INSTALLED DOUBLER PER AARD 53-30-00-02.SDR AALA20100203TUL11Bearing · wornRIGHT WING SLAT EXCESSIVE PLAY IN KNUCKLE AT INBOARD END OF NUMBER 5 SLAT. REMOVED OLD BEARINGS AND INSTALLED NEW BEARINGS PER ESO 80117.SDR AALA20100203TUL09Support · crackedVERTICAL SUPPORT FOR SEAT TRACK 3 CRACKED. REMOVED AND REPLACED SUPPORT PER SRM 51-30.SDR AALA20100203TUL07Pan · crackedSTATION 1003 TO 1022 LEFT SIDE WINDOW PAN CRACKED AT UPPER AFT CORNER. TRIMMED OUT CRACK ON WINDOW PAN AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100203TUL06Pan · crackedSTATION 946 TO 965 LEFT SIDE WINDOW PAN CRACKED AT FORWARD UPPER CORNER. TRIMMED OUT CRACK IN PAN AND INSTALLED DOUBLER IAW AARD53-10-00-25.SDR AALA20100203TUL05Pan · crackedWINDOW PAN 44 RIGHT AFT UPPER CORNER HAS CRACK. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100203TUL04Pan · crackedWINDOW PAN 38 RIGHT FORWARD UPPER CORNER HAS CRACK. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100203TUL01Seat Track · corrodedCORROSION REMOVAL ON SEAT TRACK NUMBER 3 IS BEYOND LIMITS FROM STATION 1202 TO 1205. INSTALLED NEW SECTION OF TRACK STATION 1164 TO 1222 AND INSTALLED SPLICE AT 1222 PER SRM 53-05-00.SDR AALA20100204DFW05Computer · faultedDFW - ON SHORT FINAL GEAR DOWN AND LOCKED FORTY FLAPS GOT RED GROUND PROXIMITY WARNING THREE RED GEAR LIGHTS AND AURAL TOO LOW GEAR. RESET GEAR HANDLE AND WARNING WENT AWAY. FLIGHT LANDED DFW WITHOUT INCIDENT. REPLACED GROUND PROXIMITY WARNING COMPUTER AND SDR AALA20100202TUL03Floor Support · corrodedFLOORBOARD SUPPORT CORRODED AT STATIONS 160 TO 198 LEFT SIDE. INSTALLED NEW FLOORBOARD SUPPORT PER SRM 53-00-00-012.SDR AALA20100202TUL02Membrane · corrodedHEAVY CORROSION ON SUBFLOOR AT STATIONS 160 TO 198 LEFT HAND SIDE. INSTALL DOUBLER ON SUBFLOOR PER AARD 53-20-00-016.SDR AALA20100202TUL07Support · crackedVERTICAL SUPPORT FOR SEAT TRACK NUMBER 3 IS CRACKED. REMOVED AND REPLACED SUPPORT PER SRM 51-30-00.SDR AALA20100202TUL06Stiffener · crackedCABIN VERTICAL STIFFENER CRACKED FORWARD SIDE OF AFT PRESSURE BULKHEAD AT 12 O’CLOCK. INSTALLED VERTICAL STIFFENER AND BRACKETS ON AFT BULKHEAD ABOVE VAULT DOOR PER AARD 51-00-00-012 AND SRM HI-LOCS 51-30-05.SDR AALA20100202TUL05Intercostal · crackedINTERCOSTAL BETWEEN FLOORBEAMS 769 TO 788 BL 0 IS CRACKED. COMPLETED INSTALLING INTERCOSTAL BETWEEN FLOORBEAMS 768 AND 788 PER SRM 53-30-05.SDR AALA20100202TUL04Intercostal · crackedINTERCOSTAL BETWEEN FLOORBEAMS 769 TO 788 BL 0 IS CRACKED. COMPLETED INSTALLING INTERCOSTAL BETWEEN FLOORBEAMS 768 AND 788 PER SRM 53-30-05.SDR AALA20100202TUL01Intercostal · crackedINTERCOSTAL CRACKED CENTER BUTTLINE BETWEEN FLOORBEAM STATION 1271 TO 1286. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-30-05.SDR AALA20100201TUL16Skin · dentedDENT AT STATION 480 BETWEEN LONGERON 22 LEFT AND 23 LEFT. MEASURES 1.0 X 1.0 X .035D. WITHIN LIMITS. RIVET WAS INSTALLED TO REMOVE GOUGE. INSTALLED DOUBLER PER SRM 53-04-02 DWG SG09530001.SDR AALA20100201TUL11Skin · damagedFORWARD ENTRY DOOR LOWER DOOR SKIN BENT AND OIL CANNED. STRAIGHTENED AREAS OF LOWER SKIN AND DYE CHECKED AND FOUND NO CRACK INDICATIONS. TREATED AND PRIMED AFFECTED AREAS. INSTALLED REPAIR DOUBLER AARD 52-10-00-2 FIGURE 1.SDR AALA20100201TUL10Door Frame · corrodedAFT CARGO CORROSION AROUND RIVNUTS ON LOWER DOOR JAMB BETWEEN STATION 1155 AND 1212. INSTALLED DOUBLER ON DOOR BEAM PER AARD 53-10-00-3.SDR AALA20100201TUL17Cusp Web · corrodedFOUND CORROSION ON CUSP UNDER AFT GIRT BAR SUPPORT BRACKET. INSTALLED CUSP DOUBLER STATION 1165 UNDER AFT GIRT BAR SUPPORT BRACKET PER AARD 53-20-00-16.SDR AALA20100201TUL14Beam · crackedFORWARD SERVICE DOOR TOP FORWARD BEAM CRACKED. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 52-05 FIGURE 25.SDR AALA20100206TUL02Cusp Web · damagedFOUND TOOLING MARKS IN LEFT CUSP T UPPER BETWEEN STATION 1214 TO STATION 1224, STATION 1231 TO STATION 1239, STATION 1240 TO STATION 1242. ACCOMPLISHED EA MD80-53-008953.SDR AALA20100130TUL03Longeron · corrodedLONGERON 29 LEFT AT STATION 1322 HAS CORROSION. REPLACED LONGERON PER SRM 53-04 FIGURE 38 VIEW G.SDR AALA20100130TUL04Cusp Web · corrodedCUSP CORRODED OUT OF LIMITS AT STATION 702 TO 712 RIGHT. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20100130TUL02Shear Tie · corrodedSHEAR TIE AFT SIDE STATION 1322 BETWEEN LONGERON 29 LEFT AND LONGERON 29 RIGHT HAS CORROSION. INSTALLED SHEAR TIE AT STATION 1322 BETWEEN LONGERON 29 AND LONGERON 29 RIGHT PER SRM 53-04 FIGURE 38 VIEW G.SDR AALA20100130TUL01Skin · damagedAFT CARGO DOOR LOWER JAMB AT STATION 1200 SKIN PUSHED UP AT CORNER. COMPLETED INSTALLATION OF QUADRUPLER PER EAMD80-008877.SDR AALA20100129TUL02Cusp Web · crackedCRACK FOUND AT LIGHTENING HOLE IN CUSP AT STATION 1293 LEFT. REPLACED CUSP SHEET BETWEEN 1250 TO 1309 PER SRM 51-30-01 AND 51-30-05.SDR AALA20100129TUL05Support Bracket · crackedSUPPORT BRACKET CRACKED IN AFT CARGO AT STATION 1212 AT LONGERON 23 TIGHT. REPLACED BRACKET MPN 4912817-503 PER SRM 51-30-00.SDR AALA20100129TUL04Pan · crackedWINDOW PAN CRACKED UPPER AFT EAR IS CRACKED AT STATION 769 LEFT. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100129TUL03Cusp Web · corrodedLEFT CUSP CORRODED OUT OF LIMITS AT STATION 560 LEFT. INSTALLED DOUBLER PER AARD 53-20-00-16.
Back to Mcdonnell Douglas DC-9-82