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 DALA2017071905530Floor Support · crackedCRACKED FLOOR SUPPORT BL 0 BETWEEN BS 769 - 788 AND BS 1287 - 1307. THE FLOOR SUPPORT WAS REPAIRED IAW SRM 53-01, FIG 2.SDR DALA2017071905529Angle · crackedCRACKED REPAIR ON FRAME ANGLE BS 1380 BETWEEN LONGERONS 14L AND 15L. REPLACED IAW SRM 53-14-04, AND 51-30-05.SDR DALA2018030801467Stop Fitting · crackedCRACK AT STOP FITTING. PERFORMED CSVE INSPECTION, REPAIRED STOP FITTING DAMAGE, REPLACED TORQUE TUBES, BLENDED OUTER SKIN DAMAGE, REPLACED SEAL, RESTORED PROTECTIVE FINISH, REFERENCE CMM 52-30-1 REV 75 PERFORMED CSVE INSPECTION, REPAIRED STOP FITTING DAMAGE, RSDR DALA2017071805533Line · leakingAFTER TAKE OFF, PASSENGERS AND AFT FLIGHT ATTENDANTS REPORTED AN ODOR OF HYDRAULIC FLUID AND A LIGHT A HAZE IN CABIN. THE ODOR AND HAZE DISIPATED QUICKLY. NO ABNORMAL HYD INDICATIONS IN FLIGHT DECK. PERFORMED WORKCARD 2120-2367. AFTER INSPECTION OF APU, APSDR DALA2017071805518Cusp Web · crackedCRACK ON RT CUSP WEB STA Y=905 TO 922 X= -54 TO X= -60 AT PASSENGER CABIN FLOOR STRUCTURE. CUSP WEB WAS REPAIRED PER SRM 53-05 FIG 131 A-4.SDR DALA2017071805517Skin Panel · crackedDURING LFEC INSPECTION OF RT HORIZONTAL STAB UPPER AFT SKIN PANEL, OBSERVED 1/2" LONG CRACK INDICATION AT SPECIFIED LOCATION. REFERENCE ER/A 558877-14AD REV ORIG.SDR DALA2017071805516Cusp Web · corrodedCORROSION OUT OF LIMITS DUE FOUR CRACKS ON REWORKED AREAS LT CUSP WEB AT STA Y=846, Y=862, Y=899 AND Y=905. CUSP WEB AT STA?S Y=846, Y=862, Y=899 AND Y=905 WERE REPAIRED PER SRM 53-05 FIG 131A-1 AND FIG 131A-6, SRM 51-30-02.SDR DALA2017071805515Skin · damagedEXPOSED MATERIAL ON RUDDER TAB LT SIDE, BOTTOM AT VERTICAL STABILIZER RUDDER. RUDDER TAB LT SIDE, BOTTOM AT VERTICAL STABILIZER RUDDER WAS REPAIRED PER SRM 51-70-1A P 23.SDR DALA2017071705509Battery Pack · inoperativeEMERGENCY LIGHTS IN FLIGHT DECK AND FWD GALLY INOPERATIVE. REPLACED THE BATTERY IAW AMM 33-53. LIGHTS TESTED GOOD. ACFT OK FOR SERVICE.SDR DALA2017071705514Structure · corrodedCORROSION ON VENTRAL STAIRWAY NR 11. THE SECTION OF STAIRWAY WAS REPLACED IAW SRM 51-30-5.SDR DALA2017071705511Slide · damagedFOUND SLIDE PACK UNFOLDING. REMOVED AND REPLACED THE TAILCONE SLIDE PACK.SDR DALA2017071705506Cusp Web · crackedCRACKED ON RT CUSP WEB BS 348, BETWEEN RBL 54 AND 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-1.SDR DALA2017071705505Cusp Web · corrodedCORROSION ON CUSP WEB BS 289 BETWEEN LBL 54 TO 60. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2017071705504Web · corrodedCORROSION OUT OF LIMITS ON LOWER AND UPPER WEB SURFACE FROM BS 469 - 471, RBL 54 TO 60. A NEW REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-05 FIG. 131A-13, 51-30-2, AND 51-10-3 PAR. 38.SDR DALA2017071705513Floor Panel · corrodedCORROSION ON FLOOR PANEL. THE FLOOR PANEL WAS REPAIRED IAW SRM 53-01, FIG 4.SDR DALA2017071705512Cover · looseR1 DOOR SLIDE COVER LOOSE. R & R THE R1 DOOR SLIDE IAW W/C 2561-4964.SDR DALA2017071705510Tab · delaminatedRIGHT ANTI-FLOAT TAB HAS AREA OF DELAMINATION ON OB AREA OF DELAMINATION ON OTBD END UPPER AND LOWER SURFACE. REMOVED AND REPLACED ANTI-FLOAT TAB ON AMDS 2730-4382.SDR DALA2017071605503Pan · crackedCRACK ON OUTER PAN BELOW STOP FITTING NR 5 AT FWD CARGO DOOR. THE PAN WAS REPAIRED IAW SRM 52-05, FIG 50.SDR DALA2017071605502Cusp Web · crackedCRACKED LT CUSP WEB BS 868 BETWEEN LBL 54 AND 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A, 51-30-02, AND 51-10-03, PAR 14, 21.SDR DALA2017071605501Longeron · crackedCRACKED LONGERON 12L, BS 1437 AT AFT ACCESSORY COMPARTMENT. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2017071605500Longeron · crackedCRACKED LONGERON 16R, BS 1437 AT AFT ACCESSORY. THE SECTION OF THE LONGERON WAS REPLACED IAW SRM 53-14-04, 51-30-02, AND 51-30-05.SDR DALA2017071505499Longeron · crackedCRACKED LONGERON 3L, BS 1437 AT AFT ACCESSORY COMPARTMENT. THE LONGERON REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2017071705508Cusp Web · corrodedCORROSION ON CUPS WEB BS 459 BETWEEN LBL 54 TO 60. THE CUPS WEB WAS REPAIRED IAW SRM 53-05, FIG 131A - 13 (SHEET 1).SDR DALA2017071705507Doubler · corrodedCORROSION ON CUSP WEB RING DOUBLER AT BS 728 AND RBL 54 - 60. RING DOUBLER WAS REPLACED SRM 53-05 FIG.131A-13.SDR DALA2017071505498Longeron · crackedCRACKED LONGERON 16L, BS 1437 IN THE AFT ACCESSORY BAY. THE LONGERON WAS REMOVED AND REPLACED IAW SRM 53-14-4, 51-30-5, AND 51-30-2.SDR DALA2017071405471Skin · damagedINSPECTION SHOWS MATERIAL THINNING BS 726 - 727 BETWEEN LONGERON 29L & 30R, .041 REMAINING FROM .063.SDR DALA2017071405470Wheel · undertorquedAFTER LANDING & NORMAL BRAKING, DURING LANDING BOTH BRAKES EXHIBITED SIGNIFICANT SHUDDER DURING STOP ATTEMPTS. AIRPLANE HAD TROUBLE STOPPING DUE TO THE BRAKE CHATTER. BRAKE TEMP AROUND 201 DEG. THIS WAS MORE THAN THE NORMAL BRAKE CHATTER. IT WAS VERY VIOLESDR DALA2017071405468Skin · crackedLOWER AFT SKIN AT STRINGER 17 CRACKED. REPAIRED IAW ER/A 560178-14AD.SDR DALA2017071405411Seat Track · corrodedCORROSION ON LT SEAT TRACK 22 FROM STA Y=1153 TO Y=1154. AREA OUT LIMIT WAS REPAIRED PER SRM 53-05, 51-30-1 AND 51-10-3 PAR 14, 21.SDR DALA2017071405410Doubler · corrodedCORROSION ON PREVIOUS INNER DOUBLERS REPAIR ON APU RIGHT DOOR. INNER DOUBLERS ON APU RIGHT DOOR WERE REPLACED PER SRM 51-30-02, 52-05 FIG 9.SDR DALA2017071405409Beam · crackedCRACKED BEAM NR 8 AFT EDGE AT FWD PASSENGER ENTRANCE DOOR (L1). CRACKED BEAM NR 8 AFT EDGE AT FWD PASSENGER ENTRANCE DOOR WAS REPAIRED PER SRM 52-05 FIG 111.SDR DALA2017071305407Battery · dischargedOVERWING EXIT FWD POSITION EMERGENCY LIGHTS INOP. REPLACED BATTERYS IN OVERWING BATTERY PACK AS PER AMM 33-53-00 CKS GOOD.SDR DALA2017071805532Light · sparksSPARKS IN AFT LEFT LAVATORY FROM LIGHT. COMPLIED WITH ERA 560231-14, REPLACED THE SWITCH . CHECKED GOOD.SDR DALA2017071705469Seat Track · corrodedCORROSION ON THE LEFT SEAT TRACK BS 642 AND 704. REPLACED.SDR DALA2017071305386Cusp Web · crackedCRACK ON RT CUPS WEB STA Y = 558 BTW X = - 54 AND X= - 60 AT PAX CABIN. RT CUPS WEB STA Y = 558 BTW X = - 54 AND X=- 60 AT PAX CABIN WAS REPLACED PER SRM 53-05 FIG 131A -24 AND DWG 9930538 REV BF.SDR DALA2017071305385Longeron · crackedCRACKED LONG NR 12L ON STA Y=1437 AT AFT ACCESSORY COMPARTMENT. SPLICE AND LONGERON 12L WAS REMOVED AND NEW SECTION LONGERON AND NEW SPLICE REPAIR WAS DRILLED AND ADJUSTED PER SRM 51-30-2 AND 51-30-5, 53-02 FIG18, AND NEW LONGERON AND NEW SPLICE WERE TREATED ASDR DALA2017071305384Longeron · crackedCRACKED LONG NR 13L ON STA Y=1437 AT AFT ACCESSORY COMPARTMENT. SPLICE AND LONGERON SECTION 13L WERE REMOVED AND NEW SECTION LONGERON AND NEW SPLICE REPAIR WERE DRILLED AND ADJUSTED PER SRM 51-30-2 AND 51-30-5 AND 51-10-4. NEW LONGERON AND NEW SPLICE WERE TREASDR DALA2017071205383Pan · crackedCRACKS ON WINDOW RING PAN AT STA Y=1155 FWD FACE (UPPER CORNER) STA Y=1060 FWD FACE (LWR CORNER) AND AT STA Y=845 AFT FACE (LWR CORNER).SDR DALA2017071205382Pan · crackedCRACKED WINDOW RING PAN ON UPPER CORNER STA Y=1041 AFT FACE. AREA WAS REPAIRED PER SRM 53-05 FIG 122, 51-30-2 AND 51-30-5 AND ER/A 493648-14MA REV A.SDR DALA2017071005349Hydraulic System · leakingAPU INLET SATURATED WITH HYD FLUID, CABIN HAZE WITH HYD MIST. CLEANED THE APU INLET & BELLY IAW W/C 4900-1184. PERFORMED FULL DUCT BURNOUT IAW W/C 7100-2619, NO SMOKE OR ODOR NOTED.SDR DALA2017071005346Wire Harness · defectiveON SERVICE CHECK FOUND SEAT 35C EMERGENCY SEAT LIGHT INOP. REPLACED EMERGENCY LIGHT SEAT HARNESS AT 35C. OPERATION IS NOW NORMAL. OK FOR SERVICE.SDR DALA2017070905274Cable · brokenCABLE ON VENTRAL STAIR CATWALK BROKEN.SDR DALA2017071105348Wire Harness · defectiveEMERGENCY LIGHT AT SEAT 31D INOP. REPLACED SEAT HARNESS AND PIG TAIL PER AMM 33-52.SDR DALA2017071105347Light · inoperativeEMERGENCY LIGHTS ON CATWALK NEED RELAMPED SEVERAL LOCATIONS. RELAMPED CATWALK EMERGENCY LIGHTS SEVERAL LOCATIONS PER AMM 33-52. CKS GOOD.SDR DALA2017070905273Wire · pinchedDURING A SERVICE CHECK, FOUND THE L1, R1, SEAT ROWS 1 THRU 12, AND FWD GALLEY EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT AND FOUND A PINCHED WIRE AT ROW 12 CAUSING BATTERY PACK TO BLOW F1 FUSE. REPOSITIONED AND SECURED THE WIRE. R & R THE BATTERY PACK AND TSDR DALA2017071405412Structure · crackedHFEC INSPECTION OF RIGHT SIDE CENTER WING SHOWS A CRACK INDICATIONON AFT ROW OF S-17 AT 7TH FASTENER OUTBOARD IN SCAN AREA. CRACK EXTENDS APPROX. 1/4" INBOARD OF FASTENER HEAD. REMOVED FASTENER AT CRACK INDICATION. REPAIRED PER PRI560178-14 REV 0-6 252477 PRI SDR DALA2017070805271Lamp · inoperativeRT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, CHECKED GOOD.SDR DALA2017070705270Light · inoperativeSEAT 29 MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT ASSY IAW AMM 33-53. OPS CHECKED OK.SDR DALA2017070705269Fuse · failedEMERGENCY FLOOR LIGHTS IN FWD CABIN WILL NOT TURN ON. REPLACED FUSES ON THE BATTERY PACK. EMERGENCY FLOOR LIGHTS IN FWD CABIN WORK GOOD. OK FOR SERVICE.SDR DALA2017070705245Battery Pack · dischargedEMER CEILING LIGHTS INOP FROM ROW 16-20. REPLACED BATTERY PACK AT B5-102 REF AMM 33-53. OPS CHECK GOOD.
Back to Mcdonnell Douglas MD-88