Mcdonnell Douglas MD-88
Service difficulty reports · 21,991
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 = 'MD88' 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 = 'MD88' 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 DALA2018041702526Cusp Web · corrodedCORROSION OUT OF LIMITS ON THE RT CUSP WEB BETWEEN RBL 44 TO 60, BS 741 - 747. REPAIRED IAW SRM 53-05, FIG 131A-14.SDR DALA2018041702525Cusp Web · corrodedCORROSION OUT OF LIMITS ON THE RT CUSP WEB, BETWEEN RBL 44 TO 60, BS 786 - 788. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-9, SHEET 1, AND SRM 51-30-2.SDR DALA2018041702524Cusp Web · corrodedCORROSION FOUND ON THE RT CABIN FLOOR CUSP WEB, RBL 54 TO 60, BS 1237 - 1239. FOUND TO BE OUT OF LIMITS. THE SECTION OF THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13, AND 51-30-5,51-30-2.SDR DALA2018041702523Cusp Web · corrodedCORROSION FOUND ON THE RT CABIN FLOOR CUSP WEB RBL 54 TO 60, BS 1098 - 1117. FOUND TO BE OUT OF LIMITS. THE SECTION OF CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-6, 51-30-5, AND 51-30-2.SDR DALA2018041702522Cusp Web · corrodedCORROSION ON LEFT CABIN FLOOR CUSP WEB UPPER & LOWER SURFACES FROM LBL 54 TO 60, BETWEEN BS 1240 TO 1245. FOUND OUT OF LIMITS. AREA WAS REPAIRED IAW SRM 53-05, REPAIR CONFIGURATION 7011, FIG. 131A-6.SDR DALA2018041702521Fitting · crackedCRACKED FITTINGS AT THE RT AND LT SIDES AT AFT CABIN BULKHEAD DOOR FRAME. FITTINGS REPLACED IAW SRM 51-30-2, 51-30-5, AND 51-30-1.SDR DALA2018041602519Fire Warning · false activationRIGHT ENGINE FIRE WARNING AURAL, NO LIGHTS. PERFORMED ENGINE FIRE TEST IAW AMM 26-20. NO 30 DAY HISTORY. OK FOR SERVICE.SDR DALA2018041602518Cusp Web · corrodedLEFT CUSP WEB BETWEEN BS 750 TO 757 AND LBL 44 -60, FOUND TO BE OUT OF LIMITS. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-9.SDR DALA2018041602517Cusp Web · corrodedCORROSION ON THE LEFT CABIN FLOOR CUSP WEB UPPER AND LOWER SURFACES, LBL 44 TO 60 BETWEEN BS 886 TO 905. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-2.SDR DALA2018041602516Skin · wornINITIAL INSPECTION, WORN FWD AND AFT LOWER EXTERNAL DOUBERS ON OUTER SKIN AT FWD CARGO DOOR COMPARMENT. DOUBLERS WERE REPLACED PER ERA 486624-14MA REV ORIGINAL.SDR DALA2018041602514Tab · dentedSEVERAL DENTS ON UPPER SKIN AT THE LT GEARED TAB. THE TAB WAS REPLACED IAW 55-04, PAR 2.SDR DALA2018041602513Tab · debondedDISBONDED UPPER AND LOWER SKIN AT LT ANTI FLOAT TAB, XEFT 160. THE LT ANTI-FLOAT TAB WAS REPLACED IAW 55-04, PAR 2.SDR DALA2018041602512Intercostal · crackedCRACKED INTERCOSTAL BETWEEN RIBS 4 & 5, BS 185 AT FWD ENTRY DOOR. THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-2, 51-30-5, AND DWG 9955763, REV K.SDR DALA2018041602511Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE, ROW 24 - 36. REPLACED THE BATTERY BASE B5-212, CHECKED OK IAW WDM 33-51.SDR DALA2018041502435Channel · crackedCRACK CHANNEL ON GENERATION FLOOR NBR 313A, 313E, 389G, 541F, 617G, 927A AND 927E. CHANNEL ON GENERATION FLOOR NBR 313A, 313E, 389G, 541F, 617G AND 927E WERE REPAIR PER DC-9/MD-80 SRM 53-05 FIG.131B AND 131C (SHEET 1 ), AND FLOOR PANEL NBR. 927A WAS REPLACED PSDR DALA2018041702536Unknown · odorFLIGHT ATTENDANTS REPORTED THE AFT LEFT LAVATORY SMOKE DETECTOR SOUNDED. FAINT BURNING ODOR IN CABIN AND COCKPIT. ENGINE ANTI-ICE WAS SELECTED ON. SHUT OFF GALLEY POWER AND UPPER SIDEWALL LIGHTS IAW QRH. PLACED PACKS TO FULL COLD. SMOKE ALARM STOPPED THEN CAMESDR DALA2018041502436Cusp Web · corrodedOUT OF LIMITS CORROSION ON RT CABIN FLOOR CUSP WEB X= - 54 TO X=- 60 AND STA Y= 1162-1163. CUSP WEB X= - 54 TO X=- 60 AND STA Y= 1162-1163 WAS REPAIRED PER SRM 53-05 FIG 131A-5.SDR DALA2018041502433Cusp Web · damagedAREA OUT OF LIMITS ON LT CUSP WEB BETWEEN STA Y=826-845 AND X=44/X=60. AREA OUT OF LIMITS ON LT CUSP WEB BETWEEN STA Y=826-845 AND X=44/X=60. IN REF NRC 00556. WAS REPAIRED PER SRM 53-05 FIG 131A-13.SDR DALA2018041402429Access Panel · corrodedCORROSION ON RH FUEL ACCESS PLATES NBR 1436C, 1454C, 1414C, 1478C AND 1470C. FUEL ACCES PLATE 1454C, 1436C, 1414C, 1478C AND 1470C WERE REPLACED PER DC9/MD-80 SRM 51-22-2A. (LP0507595)SDR DALA2018041402427Access Panel · corrodedCORROSION ON LH FUEL ACCESS PLATES NBR 1311C, 1335C AND 1363C. ACCESS PLATE NBR 1311C, 1335C AND 1363C WERE REPLACED PER DC-9/MD-80 SRM 51-22-2A PAR 6 (LP0507458)SDR DALA2018041302411Floor Panel · delaminatedDELAMINATION ON FLOOR PANELS NBRS 160E, 148C, 160A, AND 617F AT PAX CAB. FLOOR PANELS NBRS 160E, 148C, 160A, AND 617F WERE FABRICATE REPLACED AND IDENTIFIED PER MD88 A.M.M 53-20-01-201 AND WERE INSTALLED PER ROUTINE TASK CARD 001-0071:2500-0539. (LP0506769)SDR DALA2018041402432Fitting · crackedCRACK ON SHEAR CLIP STA Y= 1380 LONG 15L AT AFT ACCESSORIES COMPARTMENT. FRAME CLIP WAS REPLACED PER SRM 53-14-4 & DWG 9912246 REV CY.SDR DALA2018041402431Floor Panel · damagedELONGATED HOLES ON COCKPIT FLOOR PANEL NR 120B LT SIDE. FLOOR WAS REPAIRED (PERMANENT REPAIR) PER DC-9/MD-80 SRM 53-01 FIG 4 (SHEET4).SDR DALA2018041402430Floor Panel · crackedCRACK COCKPIT RT FLOOR PANEL NR 120D. FLOOR PANEL WAS REPAIRED (PERMANENT REPAIR) PER SRM 53-01 FIG 2 (SHEET3).SDR DALA2018041402428Floor Panel · crackedCRACK UPPER SKIN ON GENERATION FLOOR NR 465E AND 826G. FLOOR NR 465E AND 826G WERE REPAIRED (AS A PERMANENT REPAIR) PER SRM 53-01 FIG.2 (SHEET3) AND FIG 4 (SHEET4).SDR DALA2018041402426Beam · crackedINITIAL INSPECTION. CRACK BEAM NR 5 BTW STA 370 TO STA 389 AT FWD CARGO DOOR COMPARTMENT. BEAM NR 5 WAS REPLACED PER SRM 51-30-2, 51-30-5 AND DWG 9957663 REV W.SDR DALA2018041402425Cusp Web · corrodedCORROSION ON LEFT CABIN FLOOR CUSP WEB UPPER/LOWER SURFACE FROM X=44 TO X=60 BTW STA Y=332 TO Y=351. CORROSION ON LEFT CABIN FLOOR CUSP WEB UPPER/LOWER SURFACE FROM X=44 TO X=60 BTW STA Y=332 TO Y=351 (IN REFERENCE TO NRC 00549) WAS REPAIRED PER SRM 53-05 PAR SDR DALA2018041302410Floor Panel · crackedCRACKED FLOOR PANEL NBR: 200C. A NEW FLOOR PANEL WAS FABRICATED, AND REPLACED IAW AMM 53-20-01-201.SDR DALA2018041302409Floor Panel · crackedCRACKS ON FLOOR PANELS NBRS 160D, 160F, 200B, 148B, 120E, 643C , AND 886B AT PAX CAB. FLOOR PANELS NBRS 160D, 160F, 200B, 148B, 120E, 643C , AND 886B WERE FABRICATE REPLACED AND IDENTIFIED PER MD88 A.M.M 53-20-01-201 AND WERE INSTALLED PER ROUTINE TASK CARD 00SDR DALA2018041302407Access Panel · corrodedCORROSION ON LH/RH FUEL ACCESS PLATES NBR 1303C AND 1409C IN REF AMDS 2000-2636. DUE TO BLEND OUT REPAIR IS NOT PERMITTED ON THE UPPER WING ACCESS DOOR (P/N 3912757) DUE TO THE REDUCED AREA OF THE CONDUCTIVE INTERFACE. FUEL ACCESS DOOR 1409C AND 1303C WERE REPSDR DALA2018041502520Fire Loop · out of positionLEFT ENGINE FIRE LOOP B LIGHT ILLUMINATED AFTER DEPARTURE. ALL OTHER INDICATIONS NORMAL. FOLLOWED QRH NOTIFIED ATL MTC OPS NORMAL REMAINDER OF FLIGHT. INSPECTED LT LOWER PYLON BURN THRU DETECTOR AND FOUND LOOPS RUBBING AGAINST FLUID PIPE. DETECTOR WORN THROUGHSDR DALA2018041502434Tab · crackedCRACKED UPPER LEADING EDGE SKIN AT RT GEARED TAB NEAR TO FIRST HINGE. REPLACED WITH SERVICEABLE RT ELEVATOR GEARED TAB.SDR DALA2018041302415Bulb · inoperativeDURING LINE CHECK, THE SEAT MOUNTED EMERGENCY LIGHT AT ROW 13 INOPERATIVE. INSTALLED A NEW BULB IAW MM 33-51. OPS CHECKED GOOD.SDR DALA2018041302414Fuse · failedALL EMERGENCY LIGHTS AFT OF OVERWING EXIT INOPERATIVE. FOUND THE FUSE BLOWN IN FWD BATTERY PACK B5-211. REPLACED THE FUSE AND OPS CHECKED GOOD IAW MM 35-50.SDR DALA2018041302408Cusp Web · corrodedAWR : IN REF NRC 00535: OUT OF LIMITS : CORROSION ON RH CABIN FLOOR CUSP WEB X= - 54 TO X=- 60 AND STA Y= 1082-1094. CORROSION ON RH CABIN FLOOR CUSP WEB X= - 54 TO X=- 60 AND STA Y= 1082-1094 ( CPAX ) WAS REPAIRED PER DC9/MD80 SRM 53-05 FIG. 131 A-14. (LP050SDR DALA2018041302406Floor Support · crackedCRACKED FLOOR SUPPORT, BS 1271 TO 1287, LBL 2. REPAIRED IAW SRM 53-01, PAR. 4 FIG.2, SHEET 4.SDR DALA2018041202405Light · inoperativeFIRST CLASS EMERGENCY CEILING LIGHTS NOT WORKING. RESET EMERGENCY LIGHTING SYSTEM IAW AMM 33-53. LIGHTS WORK OK.SDR DALA2018041102337Floor Panel · crackedINITIAL INSPECTION CRACKS ON FLOOR PANELS NBRS 168B, 200C, 160A, 389F AND 1003B AT PAX CAB. FLOOR PANELS NBRS 168B, 200C, 160A ,389F AND 1003B WERE FABRICATED REPLACED AND IDENTIFIED PER MD88 A.M.M. 53-20-01-201 AND WERE INSTALLED PER ROUTINE TASK CARD 001-007SDR DALA2018041102336Floor Panel · delaminatedINITIAL INSPECTION DELAMINATION ON FLOOR PANELS NBRS 160D, 120C, 160C, 160E, 200D, 200B, 1174E, 160F, 617D, 617E, 617F, 769E, 769F, AND 826E. FLOOR PANELS NBRS 160D, 120C, 160C, 160E, 200D, 200B, 1174E, 160F, 617D, 617E 617F, 769E, 769F, AND 826E WERE FABRICATSDR DALA2018041102335Access Panel · corrodedCORROSION AT FUEL ACCESS PLATES 1409C AND 1303C. 1409C AND 1303C BLEND OUT REPAIR IS NOT PERMITTED AND WERE REPLACED PER DC-9/MD-80 SRM 51-22-2A CONDITION III. (LP0503717)SDR DALA2018041202380Cusp Web · corrodedCORROSION ON RT CUSP WEB STA Y =1072 AT CPAX. CORROSION 2: REPAIR WAS ACCOMPLISHED (PERMANENT REPAIR) PER SRM53-05 FIG 131-A-13.SDR DALA2018041202379Skin · crackedCRACK ON UPPER SKIN APPROX STA Y=1421 AT RT PYLON TRAILING EDGE. TRAILING EDGE WAS REPAIRED PER DC9-MD80 SRM 53-01 FIG 2 SHEET 3 EXAMPLE C.SDR DALA2018041202378Longeron · crackedCRACK LONG 12L STA Y=1437 AT AFT ACCESSORIES COMPARTMENT. LONG 12L STA Y=1437 AT AFT ACCESSORIES WAS REPAIR ( AS A PERMANENT REPAIR )PER SRM 53-02-FIG.18, SRM 51-30-5 AND SRM 51-30-2.SDR DALA2018041202377Beam · crackedCRACKED RIB 1 AFTER STOP DRILL ON AFTER EDGE AT FWD ENTRY DOOR. BEAM WAS REPAIRED PER SRM 52-05 PAR 76 FIG 97.SDR DALA2018041202376Access Panel · wornWEAR ON FUEL ACCESS PLATE NR 1367C. DUE TO EXCESSIVE DAMAGE FUEL ACCESS PLATE NR 1367C WAS REPLACED PER SRM 51-22-2A PAR 6.SDR DALA2018041202375Diaphragm · puncturedINITIAL INSPECTION: PUNCTURES ON DIAPHRAGM STA Y=200 X=-12 AT PAX CABIN. PUNCTURES ON DIAPHRAGM STA Y=200 X=-12 AT PAX CABIN (W1) WERE REPAIRED PER SRM 51-70-04.SDR DALA2018041202374Cusp Web · corrodedCORROSION ON LT CUSP WEB STA X=54 TO X=60 BTW STA Y=674 AND Y=693. CORROSION 2; LT CUSP WEB STA X=54 TO X=60 BTW STA Y=674 AND Y=693 WAS REPAIRED (PERMANENT REPAIR) PER SRM 53-05 FIG 131A-9.SDR DALA2018041202373Cusp Web · corrodedAWR AREA OUT OF LIMITS AT CUSP WEB BETWEEN X=-44 TO X=-54 ON STA Y= 559. IN REF NRC 00525. LEVEL CORROSION 2)CUPS WEB WAS REPAIRED PER SRM 53-05 FIG 131A-17 AND SRM 51-30-2.SDR DALA2018041202372Light · brokenL1 EMERGENCY EXIT LIGHT FIXTURE BROKEN. REMOVED AND REPLACED EMERG EXIT LIGHT BY L1 DOOR - OPS CHECK GOOD IAW AMM 33-53.SDR DALA2018041102338Cusp Web · corrodedCORROSION ON THE RT CUSP WEB BS 1049. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A.
Back to Mcdonnell Douglas MD-88