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 DALA2016090906488Floor Support · corrodedINITIAL, CORROSION ON FLOOR SUPPORT BEAMS AT STA Y=1322 AND 1338 RT AFT LAVATORY, PASSENGER CABIN. FLOOR SUPPORTS BEAMS AT STA Y= 1322 AND 1338 RT AFT LAVATORY, PASSENGER CABIN WERE REPAIRED IAW SRM 53-05, PAR-21, FIG-20.SDR DALA2016090906487Cusp Web · corrodedINITIAL, CORROSION ON UPPER /LOWER LT CUSP WEB FROM STA Y=579 TO Y=598 BETWEEN X=54 AND X =60 AT CABIN PAX. LT CUSP WEB FROM STA Y=579 TO Y=598 BETWEEN X=54 AND X=60 WAS REPAIRED IAW SRM 53-05, FIG 131A-14.SDR DALA2016090906486Tab · nickedRE-WRITE: LATE FINDING: NICK ON LT ELEVATOR CONTROL TAB T/E. ELEVATOR CONTROL TAB OFF SN 53378 WAS REPLACED BY ELEVATOR CONTROL TAB ON SN 53380 IAW IPC 55-20-03 AND WAS INSTALLED IAW CARD 2730-4334; JOB 001-0232.SDR DALA2016090906485Longeron · crackedRE-WRITE: INITIAL, CRACKED END LONGERON 2 RT STA Y=1418 AT AFT ACCESSORY COMPARTMENT. REASON FOR RE-WRITE: LONGERON AND END LONGERON
NOT INSTALLED. LONGERON AND LONGERON END WERE INSTALLED IAW SRM 51-30-5 AND 53-02, FIG 18.SDR DALA2016090906484Floor Panel · delaminatedDELAMINATED FLOOR PANEL 120E. FLOOR PANEL 120E WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2016090906483Pan · crackedINITIAL, CRACK ON INNER PAN, BEAM NR 1 FWD EDGE AT MID CARGO COMPARTMENT DOOR C2. INNER PAN WAS REPAIRED IAW SRM 52-03D, FIG 8.SDR DALA2016090906482Floorbeam · corrodedINITIAL, CORROSION AT FLOORBEAMS AT STA Y= 1322 AND 1338, LT AFT LAVATORY, PASSENGER CABIN. FLOORBEAM AT STA Y= 1322 LT AFT LAVATORY, PASSENGER
CABIN WAS REPAIRED IAW SRM 53-05, PAR-21, FIG-20.SDR DALA2016090906480Cusp Web · corrodedINITIAL, CORROSION ON RT CUSP WEB FROM STA Y=297 TO Y=300 BETWEEN X=-44 AND X=- 60 AT CPAX. REPAIRED IAW SRM 53-01, FIG 131A-13.SDR DALA2016090906479Splice Plate · crackedTAIL INTERIOR, BS 1429 SPLICE PLATE HAS 1" LONG CRACK APPROXIMATELY 9" LBL. CRACK OTBD END MARKED WITH HFEC IAW NDT SPM, INBD END IS OBSCURED BY VERTICAL STABILIZER LT ATTACH DOUBLER. REPAIRED IAW PRI 550396-14, REV 0 AND COMPLIED WITH ERA 550396-14, REV ORISDR DALA2016090906478Longeron · crackedINITIAL, CRACKED LONG 4 LT AND 5 LT STA Y=1437 AT AFT ACCESSORY COMPARTMENT. LONGERONS 4 LT AND 5 LT STA Y=1437 WERE REPAIRED IAW SRM 53-02, FIGURE 18.SDR DALA2016090906477Floorbeam · corrodedCORROSION ON FLOORBEAM OF LT AFT LAVATORY STA Y: 1338, PASSENGER CABIN. FLOORBEAM OF LT AFT LAVATORY STA Y: 1338 WAS REPAIRED IAW SRM 53-05 FIG-20.SDR DALA2016090906476Heater Blanket · corrodedDURING OK TO CLOSE INSPECTION, FOUND LIGHT SURFACE CORROSION ON UPPER SURFACE OF RT OVERWING HEATER BLANKET, IN AREA OF SECONDARY COVER OVERLAP. R & R HEATER BLANKET IAW AMDS 3080-4001-RT.SDR DALA2016090806469Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS FROM ROW 1 THROUGH ROW 12 INOPERATIVE. REPLACED THE BATTERY PACK.SDR DALA2016090806465Access Panel · bentBENT RIGHT WING ACCESS PANEL 1476C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016090906489Panel · bulgedWING PANEL FORWARD OF INBD SPOILER ON RT WING BULGING IN FLIGHT. REMOVED PANEL. INSTALLED NEW PANEL IAW DWG 5936824-508.SDR DALA2016090906481Frame · crackedINITIAL, CRACKED FRAME STA Y=1452, LONGERON 8RT AT AFT ACCESSORY COMPARTMENT. FRAME WAS REPLACED IAW DWG 9911860-3, REV L.SDR DALA2016090806470Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS FROM ROW 1 THROUGH ROW 12 INOPERATIVE. REPLACED BATTERY PACK.SDR DALA2016090806468Clamp · damagedTAILCONE RELEASE CABLE, FWD END AT FWD SIDE OF APB RUBBER BOOT INCORRECTLY CLAMPED. REPLACED THE CLAMP.SDR DALA2016090806467Boot · misinstalledTAILCONE RELEASE CABLE, FWD END AT FWD SIDE OF APB RUBBER BOOT INCORRECTLY CLAMPED. REPLACED THE CLAMP BOOT.SDR DALA2016090806466Skin · damagedDENT AND SRATCHES ON UPPER SKIN XET=82 AT RT ELEVATOR. AREA WAS FOUND OUT OF LIMITS AND WAS REPAIRED IAW ETI-88-16-327 REVISION 1 AND ER/A 550271-14 REV. ORIGINAL.SDR DALA2016090806464Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1307 X 20 LEFT SIDE AT PAX CABIN. REPAIRED IAW SRM 51-70-5.SDR DALA2016090806463Frame · crackedCRACKED FRAME BS 1474, LONGERON 18R AT AFT ACCESSORY COMPARTMENT. THE FRAME WAS REPAIRED IAW SRM 51-70-5 FIG. 1.SDR DALA2016090806462Support Fitting · corrodedCORROSION ON RT MLG SUPPORT FITTING BUSHING BORE. REPAIRED IAW ER/A 549274-14AD REV ORIG.SDR DALA2016090806461Skin · bentSKIN BENT UP JUST BELOW AFT LAV SERVICE DOOR. REPAIRED IAW PRI 550392-14 REV 0 AND 1 AND COMPLIED WITH ERA 550392-14 REV ORIG.SDR DALA2016090806460Floor Panel · crackedCRACK ON CHANNEL OF FLOOR PANEL. THE FLOOR PANEL REPAIRED IAW SRM 53-05 FIG 131B AND 131C, AND SRM 51-70-1 PAG. 10.SDR DALA2016090806459Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM BS 400 - 405, BETWEEN RBL 44 - 60. THE CUSP WEB WAS REPAIRED SRM 53-05 FIG 131A-13.SDR DALA2016090806458Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM BS 446 - 465, BETWEEN RBL 44 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A -14.SDR DALA2016090706438Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM STA Y:487 TO Y:501 AND STA X:-54 TO -60 AT PAX CABIN. RT CUSP WEB FROM STA Y:- 487 TO Y:501 AND STA X: -54 TO -60 WAS REPAIRED IAW SRM 53-05, FIG 131A-14.SDR DALA2016090706442Unknown · malfunctionedTAILCONE WOULD NOT RELEASE WITH INTERIOR HANDLE OPERATION IAW AMDS 5350-01077-0101, STEP 11A. CORRECTED ON NON-ROUTINE. CHECKS PASSED IAW AMDS 5350-01077-0101. PULL CHECK WITH-IN LIMITS AT 33LBS.SDR DALA2016090706441Doubler · corrodedINITIAL: CM CORROSION ON PREVIOUS DOUBLER REPAIR STA Y=1309 BETWEEN LONGERON 28 LT-28 RT. AT AFT CARGO COMPARTMENT C3. CORROED PARTS OF PREVIOUS REPAIR WERE REMOVED IAW SRM 51-30-5 AND REPAIR PLATE WAS FABRICATED IAW SRM 53-03D, FIG 2A AND ALSO NEW REPAIR ANSDR DALA2016090706440Spar · unknownDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND, 7 DIFFERENT FASTENERS OF PSE, ON LOWER SKIN REAR SPAR BETWEEN XRS=163 TO 168 AT RT WING. THESE NRC IS ATTENDED WITH ER/A NR 549305-14AD, REV ORIGINAL.SDR DALA2016090706439Spar · unknownDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND, 7 DIFFERENT FASTENERS OF PSE, ON LOWER SKIN REAR SPAR BETWEEN XRS=163 TO 168 AT LT WING. THESE NRC IS ATTENDED WITH ER/A NR 549305-14AD, REV ORIGINAL.SDR DALA2016090706437Spring · brokenAWR RII: BROKEN EMERGENCY EXIT PRESSURE BULKHEAD DOOR ARM SPRING. SPRING PN 4951062-1 WAS REPLACED IAW AMM 53-53-02 AND WAS VERIFIED WITH IPC 52-10-02.SDR DALA2016090706436Cusp Web · corrodedINITIAL: CORROSION ON UPPER, LOWER LT CUSP WEB FROM STA Y=560 TO Y=579 BETWEEN X=54 AND X=60 AT PASSENGER CABIN. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A.SDR DALA2016090706435Doubler · wornINITIAL WEAR REPAIR DOUBLER AT LT INBD VANE OF OTBD FLAP. LT INBD VANE OF OTBD FLAP WAS REPAIRED BY SRM 57-03D, PAR 11.SDR DALA2016090706434Floor Panel · damagedINITIAL PART RACK. REPAIR AS REQUIRED, INSERT, DELAMINATION, PUNCTURE FLOOR PANEL OF CPAX NR 826B, C, D, E, F, NR 886 B, C, D AND NR 927 B, C, D, WING BOX AREA. FLOOR PANEL NR: 927C, 826F, 826C AND 886D WERE FABRICATED IAW AMM 53-20-01-201 AND FERRULES ON FLOSDR DALA2016090706433Doubler · wornINITIAL WEAR DOUBLER ON T/E AT RT INBD VANE OF OTBD FLAP. RT INBD VANE OF OTBD FLAP WAS REPAIRED BY SRM 57-03D, PAR 11.SDR DALA2016090706432Floor Panel · damagedPARTS RACKS: DAMAGED FERRULES, PUNCTURED AND MISSING MATERIAL ON FLOOR PANELS NR 1003C, 1117D, 1174D, 1174C, 1250B, 1307B WING BOX AND AFT FUSELAGE. FLOOR PANEL NRS: 1307B, 1117D AND 1174C WERE REPLACED FERRULES IAW AMM 53-20-01-201 FLOOR PANEL NBR: 1003C, 11SDR DALA2016090706431Skin · puncturedINITIAL: PUNCTURE ON LT ELEVATOR ANTI-FLOAT TAB UPPER SKIN. LT ELEVATOR ANTI-FLOAT TAB WAS REPAIRED BY SRM 55-04, PAR 2.SDR DALA2016090706430Skin · damagedDURING X-RAY IAW AMDS 5310-01449-01, FOUND SPLICE CUT LINE ON LT SIDE BETWEEN L26L AND L27L AT STA 1338 TO BE A CATEGORY 24 CUT. REQUIRING REPAIR DOUBLER,ACCOMPLISH ER/A 550138-14, REV ORIGINAL.SDR DALA2016090706429Skin · damagedDURING X-RAY IAW AMDS 5310-01449-01, FOUND SPLICE CUT LINE ON RT SIDE BETWEEN L26R AND L27R AT STA 1338 TO BE A CATEGORY 24 CUT. REQUIRING REPAIR DOUBLER. ACCOMPLISH ER/A 550138-14, REV ORIGINAL.SDR DALA2016090606421Frame · crackedINITIAL: CRACKED FRAME STA Y=1322 AND LONGERON 17TH PASSENGER CABIN. FRAME WAS REPAIRED IAW ER 493697-14MA, REV B.SDR DALA2016090606417Skin · crackedCORROSION WITH CRACK FS 588 AT STR 28R REF LOG 9299465. C/W PRI 550488-14, REV 0, REV 1, 334465. COMPLIED WITH ERA 550488-14, REV ORIGINAL.SDR DALA2016090606425Cusp Web · corrodedCORROSION ON UPPER, LOWER RT CUSP WEB FROM STA Y=503 TO Y=598 BETWEEN X=-44 AND X =-60. DUE TO EXCESSIVE CORROSION, CUSP WEB WAS REPLACED IAW DWG 9930538 REV CF AND SRM 51-30-2, SRM 51-30-5, SRM 51-30-1.SDR DALA2016090606424Fitting · crackedINITIAL, CRACKED FRAME CLIP STA Y=1437 PROYECTION LONGERON 2RT AT AFT ACCESSORY COMPARTMENT. CLIP WAS REPLACED IAW DWG 9953016-30, REV AT
SRM 51-30-2 AND SRM 51-30-5.SDR DALA2016090606422Skin · cracked2" CRACK LOCATED 4 FT FWD AND 3" BELOW LOWER RT CORNER OF MID CARGO DOOR. REPAIRED ON NR 001 IAW ERA 550488-14, REV ORIGINAL.SDR DALA2016090606420Spring Assy · corrodedRUSTED PISTON END AT RUDDER TRIM TAB ACTUATOR ON AFT ACCESSORY COMPARTMENT. RUDDER TRIM LOAD-FEEL SPRING ASSY WAS REMOVED AND INSTALLED IAW AMM 27-207. AREA AT SHAFT OF RUDDER TRIM LOAD-FEEL SPRING ASSY WAS REWORKED MEASUREMENT ORIGINAL 0.686" AND MINIMUM RESDR DALA2016090606419Access Door · corrodedCORROSION ON FUEL ACCESS PLATE NR 1303C. FUEL ACCESS DOOR 1303C WAS REPLACED IAW SRM 51-22-2A CONDITION 3, PAR B AND IPC 57-30-00.SDR DALA2016090606418Access Door · corrodedCORROSION ON FUEL ACCESS PLATE NR 1409C. FUEL ACCESS DOOR 1409C WAS REPLACED IAW SRM 51-22-2A CONDITION 3, PAR B AND IPC:5730-00.SDR DALA2016090606416Floor Panel · damagedDAMAGE FERRULES AND DELAMINATED FLOOR PANELS NRS 200D, 160B, 160E, 148B, 160D, 148A, 148C, 160F, 160C, 210C AT PASSENGER CABIN. FLOOR PANELS NRS 200D, 160B, 160E, 148B, 160D, 148A, 148C, 160F, 160C, 200C WERE FABRICATED AND IDENTIFIED IAW AMM 53-20-01-201, FL
Back to Mcdonnell Douglas MD-88