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 AALA20100224TUL03Vane · gougedLEFT WING NUMBER 5 VANE TRAILING EDGE HAS GOUGE. INSTALLED HOT BOND DOUBLER PER SRM 51-70-2.SDR AALA20100224TUL02Doubler · gougedLEFT WING NUMBER 3 VANE LEADING EDGE HAS A GOUGE ON DOUBLER. INSTALLED DOUBLER WITH HOT BOND PER SRM 51-70-02.SDR AALA20100224LGA02Battery Pack · dischargedESCAPE PATH LIGHT AB5-3 BATTERY LOW VOLTS. REPLACED ESCAPE PATH LIGHT BATTERY PACK AB5-3. OPS CHECKED NORMAL.SDR AALA20100224LGA01Battery Pack · dischargedESCAPE PATH LIGHTING AB5-2 BATTERY LOW VOLTS. REMOVED AND REPLACED ESCAPED PATH LIGHT BATTERY AB5-2. OPS CHECKED NORMAL.SDR AALA20100223TUL10Longeron · crackedCABIN HAS A CRACK IN LONGERON 4 LEFT AT STATION 200. INSTALLED LONGERON SPLICE REPAIR PER SRM 53-02 FIGURE 18.SDR AALA20100223TUL09Cargo Track · corrodedAFT CARGO TIE DOWN TRACK CORRODED AT CLIP NUT TABS AND MOUNTING LOCATIONS. REMOVED AND REPLACED AFT SECTION OF LEFT TIE DOWN TRACK PER SRM 51-30-01.SDR AALA20100223TUL07Casting · crackedPULLEY BRACKET SUPPORT CASTING CRACKED INBOARD OF NUMBER 8 SLAT TRACK FRONT SPAR LEFT WING. REMOVED AND REPLACED CASTING PER BOEING DRAWING 9930529 SRM 51-60 AND EA MD80-57-009274.SDR AALA20100223TUL06Cusp Web · crackedCRACK ON RIGHT CUSP STATION 881 TO 884. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100223TUL05Seat Track · corrodedSEAT TRACK NUMBER 3 CORRODED BEYOND LIMITS. REMOVED CORROSION AND INSTALLED PLUG PER AARD 53-20-00-10.SDR AALA20100223TUL02Controller · faultedIAD - INFLIGHT DFW-DCA. CREW REPORTED ANTI-SKID INOPERTAIVE LIGHT ILLUMINATED. FLIGHT DIVERTED IAD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ANTI-SKID CONTROLLER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20100222TUL22Cusp Web · damagedCORROSION ON CUSP UNDER GIRT BAR FITTING AT AFT SERVICE DOOR FORWARD FITTING STATION 1142. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100222TUL13Cusp Web · corrodedCORROSION ON BOTTOM OF LEFT CUSP FROM STATION 1305 TO 1309. REMOVED AND REPLACED CUSP SHEET FROM STATION 1250-1309 PER SRM 51-01.SDR AALA20100222TUL12Cusp Web · damagedDAMAGE TO CUSP SHEET AT STATION 1218 LEFT. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100222TUL10Rib · crackedHIGH FREQUENCY EDDY CURRENT INSPECTION OF RIGHT NUMBER 5 SLAT REVEALED CRACK IN LEADING EDGE SLAT RIB AT 2ND MOST OUTBOARD SLAT RIB BRACKET AT LUG. REPLACED DAMAGED 2ND MOST OUTBOARD RIB ON SLAT IN ACCORDANCE WITH SRM 57-50-13.SDR AALA20100222TUL09Rib · crackedHIGH FREQUENCY EDDY CURRENT INSPECTION REVEALED CRACK ON NUMBER 5 SLAT LEADING EDGE SLAT RIB. MOST OUTBOARD SLAT RIB BRACKET CRACKED AT OUTBOARD LUG. REPLACED DAMAGED MOST OUTBOARD RIB SLAT IN ACCORDANCE WITH SRM 57-50-13.SDR AALA20100222LGA01Battery Pack · dischargedFORWARD OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD OVERWING EMERGENCY EXIT LIGHTS. OPS CHECKED NORMAL.SDR AALA20100221TUL07Door Frame · corrodedCORROSION ON FORWARD CARGO DOOR PAN STATION 370 TO 408 HORIZONTAL LEG OUTBOARD EDGE AND FORWARD VERTICAL LEG. INSTALLED NEW CARGO DOOR PAN SPLICE STATION 370 TO 427 PER SRM 53-05-00.SDR AALA20100221TUL06Stop Fitting · crackedMID CARGO DOOR FORWARD CENTER STOP FITTING CRACKED. REMOVED AND REPLACED STOP FITTING PER ESO 80174.SDR AALA20100221TUL05Cusp Web · corrodedCORROSION UNDER DOUBLER, UNDER AFT GIRT BAR BRACKET AT AFT SERVICE DOOR STATION 1170. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100221TUL01Pan · crackedFORWARD LOWER EAR IS CRACKED ON WINDOW PAN AT STATION 1022 LEFT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100221LGA01Battery Pack · not seatedAFT CATWALK AND OVERHEAD TAIL EMERGENCY LIGHTS INOPERATIVE DURING TEST OF EMERGENCY EVACUATION LIGHTS SYSTEM. RESEATED BATTERY PACK AND SYSTEM RECHARGED PER NORMAL OPERATION. RETEST CHECKS GOOD.SDR AALA20100219TUL02Intercostal · crackedINTERCOSTAL IN CEILING BETWEEN STATIONS 1287 AND 1309 AT BUTTLINE 0 CRACKED AT AFT RADIUS. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-01-00.SDR AALA20100222TUL07Pan · crackedCRACKED WINDOW PAN AT STATION 1022 UPPER AFT CORNER LEFT SIDE. INSTALLED DOUBLER PER 53-10-00-25.SDR AALA20100222TUL06Pan · crackedUPPER AFT EAR IS CRACKED ON WINDOW PAN AT STATION 1098 LEFT. INSTALLED DOUBLER PER 53-10-00-25.SDR AALA20100222TUL05Pan · crackedFORWARD UPPER EAR IS CRACKED ON WINDOW PAN AT STATION 946 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100222TUL04Pan · crackedUPPER AFT EAR IS CRACKED ON WINDOW PAN AT STATION 1041 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100222TUL02Pan · crackedFORWARD LOWER EAR IS CRACKED ON WINDOW PAN AT STATION 984 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100222TUL01Pan · crackedFORWARD LOWER EAR IS CRACKED ON WINDOW PAN STATION 946 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100218TUL01Casting · crackedLEFT WING FORWARD INBOARD CORNER OF GROUND SPOILER ACTUATOR CASTING CRACKED. REMOVED AND REPLACED CASTING PER SRM 57-01-00.SDR AALA20100217TUL11Fuel Control · inoperativeLIT - INFLIGHT LGA-DFW. CREW REPORTED NUMBER 2 ENGINE N1, N2 AND EPR HAD ROLLED BCAK. EMERGENCY DECLARED FLIGHT DIVERTED LIT LANDED WITHOUT INCIDENT. REPLACED ENGINE FUEL CONTROL AND FUEL PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20100217TUL04Floor Support · looseFLOORBOARD SUPPORT BETWEEN NUMBER 3 AND 4 SEAT TRACK IS LOOSE. REPLACED FLOORBOARD SUPPORT BETWEEN SEAT TRACK NUMBER 3 AND 4 PER SRM 51-10-1.SDR AALA20100217TUL10Cusp Web · corrodedRIGHT CUSP TEE CORRODED STATIONS 154 TO 229. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR PER SRM 53-05-00 AND EA MD80-53-009094.SDR AALA20100217TUL05Track · corrodedLEFT TIE-DOWN CORRODED OUT OF LIMITS IN AFT CARGO FROM STATIONS 1220 TO 1332. REPLACED LEFT TIE-DOWN TRACK PER SRM 51-01-00-02, SRM 51-30-01 AND SRM 51-30-05.SDR AALA20100216TUL09Fitting · corrodedGALLEY TIE DOWN CORRODED 17 INCHES INBOARD OF FORWARD SERVICE DOOR STATION 160. REMOVED AND REPLACED GALLEY TIE DOWN PER SRM 51-30-05.SDR AALA20100216TUL07Angle · damagedRIGHT CUSP T ANGLE OUT OF LIMITS APPROXIMATE STATION 150 TO 250. INSTALLED SECTION OF CUSP T ON RIGHT SIDE STATION 154 TO 229 PER SRM 53-05-00 AND EA MD80-53-009094.SDR AALA20100216TUL04Mount · damagedCORROSION ON GALLEY TIE DOWN 10 INCHES OF FORWARD SERVICE DOOR. INSTALLED GALLEY MOUNT PER AARD 53-20-00-19 AND REPAIR PLUG PER AARD 53-20-00-19.SDR AALA20100216TUL03Frame · corrodedHEAVY CARGO/AFT - CORROSION ON FRAME LOWER FLANGE STATION 1271 LONGERON 28 LEFT TO LONGERON 28 RIGHT. BLENDED AND REMOVED CORROSION PER SRM 51-10-03 FOUND TO BE OUT OF LIMITS PER SRM 53-01. TREATED AND PRIMED AREA PER SRM 51-10-3. INSTALLED REPAIR DOUBLER PSDR AALA20100216SFO01Battery Pack · dischargedEMERGENCY LIGHT AT RIGHT NUMBER THREE DOOR SIDEWALL LOWER AREA INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT RIGHT NUMBER THREE DOOR SIDEWALL LOWER AREA, OPS CHECK NORMAL.SDR AALA20100215TUL09Fitting · corrodedCORROSION G1 OUTBOARD TIE DOWN STATION 160. INSTALLED NEW G-1 GALLEY TIE DOWN FITTING PER SRM 51-01.SDR AALA20100215TUL08Doubler · corrodedCORROSION ON DOUBLER BOTTOM CENTER OF STATION 1338 BULKHEAD. REMOVED CORROSION INSTALLED NEW DOUBLER PER SRM 51-30-05 AND 51-60.SDR AALA20100215TUL07Cusp Web · corrodedCORROSION ON WEB INBOARD OF FORWARD SERVICE DOOR STATION 168 TO 200. REMOVED CORRODED AREA INSTALLED NEW CUSP PER AARD 53-20-00-16.SDR AALA20100215TUL06Doubler · corrodedCORROSION OUT OF LIMITS ON DOUBLER AT CENTER OF 1138 BULKHEAD AT LONGERON 30. INSTALLED DELTA PLATE DOUBLER PER SRM 51-30-00.SDR AALA20100215TUL05Cusp Web · corrodedCORROSION BELOW AFT GIRT BAR SUPPORT AT AFT SERVICE DOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100215TUL04Frame · crackedAFT ACCESSORY CANT FRAME CRACKED AT STATION 1497 BELOW RIGHT LOUVER BOX. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-15 AND SRM 51-01-00.SDR AALA20100215TUL03Cusp Web · corrodedLEFT CUSP CORRODED OUT OF LIMITS AT STATION 714 TO 716 LEFT. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20100215TUL02Structure · misrepairedIMPROPER REPAIR AT AFT SERVICE DOOR HOLD OPEN HOOK AREA. REMOVED IMPROPER DOUBLER, DRILLED NEW DOUBLER TO FIT AND INSTALLED NEW DOUBLER ON AFT SERVICE DOOR PER SRM 52-05-00, FIG 54.SDR AALA20100215TUL01Mount · corrodedG2 GALLEY MOUNT CORRODED OUT OF LIMITS AT STATION 210 INBOARD OF SEAT TRACK NUMBER 4. REPLACED G2 GALLEY MOUNT PER SRM 51-01.SDR RYNA2010002170004Fan Blade · bentRIGHT ENGINE HAD 3 COMPRESSOR STALLS DURING CLIMB THROUGH 16,000 TO 17,000 FT. DURING TROUBLESHOOTING FOR COMPRESSOR STALL FOUND DAMAGED 1ST STAGE FAN BLADE. PERFORMED VISUAL INSP OF BLADE DAMAGE, BLADE BENT 1 ¼ (L/E TO T/E) AND 1 24/32 (TIP TO SHANK) WITH NSDR AALA20100214AUS01Anti-Ice Valve · inoperativeAUS - INFLIGHT FLL-DFW. CREW TURNED ON ENGINE ANTI-ICE IN CRUISE AND DISAGREE LIGHT ILLUMINATED. NO CIRCUIT BREAKER POPPED OR OTHER INDICATIONS. FLIGHT DIVERTED AUS LANDED WITHOUT INCIDENT. FOUND COWL ANTI ICE VALVE INOPERATIVE. REPLACED RIGHT ENGINE COWLSDR AALA20100214TUL01Skin · corrodedAFT LEFT NOSE GEAR DOOR AFT HINGE CUTOUT ON SKIN IS CORRODED & CRACKED. INSTALLED REPAIR DOUBLER PER EA MD80-53-009048.
Back to Mcdonnell Douglas DC-9-82