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 DALA2016080805839Battery Pack · inoperativeAFT CEILING EMERGENCY LIGHTS OVER AFT SERVICE DOOR INOPERATIVE. INSTALLED NEW BATTERIES IN POWER SUPPLY FOR AFT CEILING LIGHTS. OPS CHECKED OK. OK FOR SERVICE.SDR DALA2016080805857Frame · crackedCRACKED FRAME BS 1510. THE FRAME WAS REPLACED IAW 51-30-2 AND 51-30-5 AND DWG 9911843 REV. AC.SDR DALA2016080805860Light · inoperativeLEFT EXTERNAL EMERGENCY LIGHT INOPERATIVE. RESET AND CLEANED THE LIGHT. OPS NORMAL.SDR DALA2016080805859Pan · crackedCRACKED FWD EDGE PAN ON FWD CARGO DOOR OVER BEAM NR 5. THE EDGE PAN WAS REPAIRED IAW SRM 53-05D FIG.SDR DALA2016080805837Power Supply · inoperativeDURING SERVICE CHECK, FOUND NUMEROUS EMERGENCY LIGHTS INOPERATIVE. FOUND POWER SUPPLY B5-212 BAD. REMOVED AND REPLACED THE POWER SUPPLY IAW WDM 33-51-14.SDR DALA2016080805862Skin · damagedRUDDER EXTERIOR SKIN BONDED REPAIR DOUBLER COMING APART/PEELING OFF ON RT SIDE. REPLACED RUDDER ASSY IAW MM 27-20-01. RTS AND SENSOR CHECK ACCOMPLISHED ON AMDS CARD 2210-7849.SDR DALA2016080605856Skin · damagedLIGHTNING STRIKE ON OUTER FUSELAGE SKIN BS 170 BETWEEN LONGERONS 28 - 29L. REPAIRED IAW ETI 88-16-228 AND ER/A 547886-14 REV ORIGINAL.SDR DALA2016080605855Skin · corrodedCORROSION ON RT WING LOWER SKIN XRS 115. FAIRING WAS REMOVED, AREA WAS BLENDED, MEASURE (UT) NDT SPM 04-00-07 PAR 5 FIGURE 3 SHEET 1 & 2 WAS ACCOMPLISHED WITH ORIGINAL .340" MINIMUM REMAINING .333" AND FOUND WITHIN LIMITS, FLAP PENNING WAS PERFORMED, TREATED SDR DALA2016080605854Skin · damagedDURING X-RAY INSPECTION OF APB SPLICE, FOUND LT SPLICE LOCATION BETWEEN LONGERONS 26-27L WITH 2-4 FASTENER CONFIGURATION. MARKED SPLICE LINE ON APB SKIN. REPAIRED IAW PRI 549408-14 REV 0 AND COMPLIED WITH ERA 549408-14 REV ORIG.SDR DALA2016080605853Cusp Web · crackedA CRACK WAS FOUND ON LT CUSP WEB BETWEEN BS 845 - 864 AND X 44 TO X 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-10.SDR DALA2016080505788Light · brokenSEAT 24E EMERGENCY LIGHT BROKEN. R AND R SEAT 24E LOWER DOOR EMERGENCY LIGHT ASSY IAW AMM 33-50, OPS CKS GOOD.SDR DALA2016080505787Pin · not seatedAFT EMERGENCY LIGHT AT 24DE INOPERATIVE. FOUND PIN PUSHED BACK IN SEAT CONNECTOR. REINSERTED PIN, CKS GOOD.SDR DALA2016080505786Beam · crackedCRACKED BEAM NR 1 ON FWD ENTRY DOOR. PASSENGER FORWARD ENTRY DOOR WAS REMOVED AND INSTALLED IAW AMM 52-11-00 401. REPAIR BEAM NR 1 IAW SRM 52-05, FIG 98, SHEET 3.SDR DALA2016080505785Frame · corrodedCORROSION ON FRAME STA Y=1380, BETWEEN LONGERONS 29L-27R AT AFT ACCESSORY COMPARTMENT. FRAME WAS R & R IAW DWG 9912246-115, SRM 51-30-2, SRM 51-30-5 AND ER/A 547884-14, REV ORIGINAL.SDR DALA2016080505784Stringer · crackedCRACKED STR NR 20 LT STA Y, 1003 ABOVE TRAPEZOIDAL PANEL AT LT WHEEL WELL. STRINGER NR 20 WAS REPAIRED IAW SRM 53-02, FIG 22.SDR DALA2016080405769Skin · crackedCRACK ON OUTER SKIN BETWEEN BEAMS NR 1 TO 2 AND PROJECTION STA Y:658 OF AFT MID CARGO COMPARTMENT DOOR. SKIN WAS REPAIRED IAW ERA 486446-14MA, REV ORIGINAL.SDR DALA2016080405767Longeron · crackedINITIAL INSPECTION, CRACK ON LONG 4RT AND STA Y=1437 AT AFT ACCESSORIES COMPARTMENT. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016080405766Longeron · crackedINITIAL INSPECTION, CRACK ON LONG 3LT AND STA Y=1437 AT AFT ACCESSORIES COMPARTMENT. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016080405765Door Frame · corrodedCENTER CARGO COMPARTMENT, STA 693-STA 750, X-15 TO X-16, LOWER DOOR FRAME OTBD FACE HAS CORROSION AROUND RIV-NUTS. BLENDED AREAS AT CENTER CARGO COMPARTMENT, STA 693-STA 750, X15 TO X16 LOWER DOOR FRAME, BLEND AREA FWD WAS FOUND TO BE OUT OF LIMITS. ACCOMPLISDR DALA2016080405764Skin · crackedCRACK OF 0.062" ON FUSELAGE SKIN AT THE UPPER FWD DOOR JAMB CORNER STA Y=375.5 BETWEEN LONG 19-20 RT OF THE FWD CARGO COMPARTMENT. FUSELAGE SKIN AT THE UPPER FWD DOOR JAMB CORNER STA Y= 375.5 BETWEEN LONGERON 19-20 RT OF THE FWD CARGO COMPARTMENT WAS REPAIRED SDR DALA2016080405770Compressor · overheatedDURING CLIMB F/A NOTICED ODOR. ELECTRIC IN NATURE, IN CAB, STRONGER IN AFT. DISSIPATED AFTER A FEW MINUTES, NONE AT CRUISE. HAPPENED AGAIN DURING DESCENT, DISSIPATED BEFORE LANDING. NO SMOKE REPORTED. SIDEWALL LIGHTS WERE OFF. T/S IAW W/C 2120-2367. FOUSDR DALA2016080305732Beam · crackedCRACK ON BEAM NR 5 AND BS 427 OF FWD CARGO DOOR. THE BEAM WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016080305731Floorbeam · corrodedPASSENGER CABIN FLOORBEAM FWD WET AREA BS 256 LBL 22 - RBL 22 CORRODED. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-00-01 FIG. REMOVED AND REPLACED IAW SRM 51-30-05 VOL II.SDR DALA2016080305730Intercostal · crackedL1 DOOR INTERNAL LATCH MECHANISM INTERCOSTAL LOWER RADIUS CRACKED. REMOVED AND REPLACED THE INTERCOSTAL IAW DRAWING 99557653, SRM 51-30-02.SDR DALA2016080305729Access Panel · corrodedCORROSION ON COUNTERSINKS AND SETTLEMENT AREA ON FUEL ACCESS PANEL 1335. ACCESS PANEL WAS REPLACED.SDR DALA2016080305728Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1414C ON RT WING. THE ACCESS PANEL WAS REPLACED.SDR DALA2016080305727Floorbeam · corrodedFWD WET AREA RIGHT SIDE BS 256 RBL 22 - 44 FLOORBEAM CORRODED ON UPPER SURFACE. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-00-01 FIG 3. REMOVED AND REPLACED IAW SRM 51-30-05 VOL II.SDR DALA2016080305726Skin · cracked.405 INCH CRACK ON HORIZONTAL STABILIZER SKIN UPPER PANEL RT SIDE NEAR TO REAR SPAR PLANE BETWEEN XH=7.234 TO XH= 13.486. THE SKIN WAS REPLACED AND REPAIRED PER DWG SR09550028 REV.D AND SRM 51-30-2, SRM 51-30-5, SRM 51-30-9, SRM 51-10-3 PAR 14.21.SDR DALA2016080305725Frame · crackedCRACKED LOWER CAP ON FRAME BS 1437, LONGERON 2R. THE FRAME WAS REPAIRED IAW SRM 53-01 FIG. 2 & DWG 9953016 REV. AT.SDR DALA2016080305724Angle · crackedCRACKED ANGLE ON DOOR STOP AT RT AFT OVERWING EMERGENCY EXIT. THE ANGLE WAS REPLACED IAW DWG 9957735 REV. G AND SRM 51-30-5 AND 51-30-2.SDR DALA2016080305723Door Frame · crackedCRACK ON EMERGENCY EXIT DOOR FRAME (UPPER AREA) BS 919 LT SIDE. THE DOOR FRAME WAS REPAIRED IAW SRM 53-05 FIG.32.SDR DALA2016080205714Frame · crackedCRACK ON FRAME BS 1322 LONGERON 17R. THE FRAME WAS REPAIRED IAW ER 493697-14MA REV. B.SDR DALA2016080205715Connector · inoperativeSEAT 34D EMERGENCY LIGHT INOPERATIVE. REPLACED CONNECTOR AT SEAT 34D IAW AMM 33-50. OPS CHECKED GOOD.SDR DALA2016080205712Floor Panel · damagedDAMAGED FERRULS ON FLOOR PANEL. FLOOR PANEL REPAIRED IAW AMM 53-20-01-201 AND AMM 88 53-20-01-201.SDR DALA2016080205711Longeron · crackedCRACK FOUND ON LONGERON 16L, BS 1437. THE LONGERON WAS REPLACED IAW SRM 53-14-4 FIG 4, SRM 51-30-5, AND SRM 51-30-2.SDR DALA2016080105705Bracket · crackedCRACKED RT HORIZONTAL STAB SIDE ROLLER BRACKET. THE ROLLER BRACKET WAS REPLACED AND ADJUSTED IAW AMM 55-10-00.SDR DALA2016080105701Longeron · crackedCRACKED LONGERON 3L BS 1437. LONGERON REPAIRED IAW SRM 53-02 FIG. 18.SDR DALA2016080105699Cusp Web · crackedCRACK ON LEFT CUSP WEB BS 905 - 927, X 54 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-14 51-30-2, 51-30-5, AND 51-10-3 PAR. 14,21 & 38.SDR DALA2016080105698Cusp Web · corrodedPASSENGER CABIN RIGHT SIDE BS 712 TO 731 CUSP WEB CORRODED. REPAIRED IAW SRM 53-20-03 PAR 7 FIG 30.SDR DALA2016080105697Cusp Web · corrodedPASSENGER CABIN BS 731 - 750 CUSP WEB CORRODED. BLENDED BEYOND ALLOWABLE LIMITS. REPLACED THE CUSP WEB IAW SRM 53-20-02 PAR 7 FIG 30.SDR DALA2016080105696Longeron · corrodedAFT CARGO COMPARTMENT RIGHT SIDE BETEEN BS 1379 - 1395 LONGERON 29R CORRODED. INSTALLED A NEW LONGERON.SDR DALA2016080105695Intercostal · corrodedAFT CARGO COMPARTMENT BILGE AREA LEFT SIDE BS 1269 - 1288 LONGERON 29L INTERCOSTAL CORRODED ON AFT SIDE OF FRAME. INSTALLED A NEW INTERCOSTAL.SDR DALA2016073105664Doubler · corrodedCORROSION ON INNER PRODUCTION DOUBLER BETWEEN BS 1222 - 1234 AND BS 1205 - 1216, LONGERONS 25 - 26L. THE DOUBLER WAS REPLACED IAW SRM 53-34-0 FIG 3 AND 51-10-1 FIG G.36 (SHEET 6).SDR DALA2016080105709Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1003 - 1020. THE CUSP WEB WAS REPAIRED IAW SRM 51-30-2, 53-05 FIG. 131A-14 , 51-10-3 PAR. 21,14 AND 51-30-5 CABIN.SDR DALA2016080105708Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER ON LT CUSP WEB BS 934 - 946, X 54-60. REPAIRED IAW SRM 53-05 FIG 131. AND 51-30-2.SDR DALA2016080105707Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1060 - 1079. CUSP WEB REPAIRED IAW SRM 53-05 FIG. 131A-14 AND SRM 51-30-5.SDR DALA2016080105706Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1041 - 1050. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-13.SDR DALA2016080105704Splice · crackedCRACKED SPLICE ON FIXED LEADING EDGE STRUCTURE XFS=194.850 ON RT WING. THE DOUBLER WAS REPLACED IAW ER/A 379404-14MA REV.A.SDR DALA2016080105703Angle · crackedCRACK ON ANGLE BEAM FWD AT FWD ENTRY DOOR. ANGLE WAS REPLACED IAW SRM 51-30-2, 51-30-5, AND DWG 9955752 REV M.SDR DALA2016080105702Rib · crackedCRACK ON RIB XOS 455 ON RT WING FIXED LE STRUCTURE. THE RIB WAS REPAIRED IAW SRM 57-06B D FIG. 12 SHEET 4.
Back to Mcdonnell Douglas MD-88