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 DALA2016021301063Cusp Web · crackedCRACK ON CUSP WEB LOWER SURFACE STA 845 AND X= 54 AT CABIN PASSENGER CUSP WEB BS 807 TO 845 AND X=54 WAS REPLACED IAW SRM 51-30-2, SRM 51-30-5, SRM 53-05, FIG 131A- 24 AND SRM 51-10-3 PAR 14, 21.SDR DALA2016021301062Pan · crackedCRACK ON RING PAN FWD UPPER CORNER IN BS 750-984 SIDE AT CABIN PAX. DAMAGED AREAS WERE REPAIRED IAW SRM 53-05, PAR 139, FIG 122.SDR DALA2016021301061Splice · corrodedCORROSION ON SPLICE, BS 1338 BETWEEN OF 28RT TO 28LT. SPLICE DOUBLER WAS REPLACED IAW SRM 51-30-5, 51-30-2 AND DWG 9915561, REV CG.SDR DALA2016021301060Stringer · crackedONE CRACK WAS FOUND ON STR 17R. STRINGER WAS REPAIRED IAW ER/A 541614-14 AD REV ORIGINAL AND ER/A 541616-14, REV ORIGINAL.SDR DALA2016021301059Stringer · crackedONE CRACK WAS FOUND ON STRINGER 17L. STRINGER WAS REPAIRED IAW ER/A 541614-14 AD, REV ORIGINAL AND ER/A 541616-14, REV ORIGINAL.SDR DALA2016021601091Transducer · faultedTHE LEFT OTBD NR 1 ANTI-SKID FAULT ILLUMINATED ON THE EOAP ON APPROACH, WHEN GEAR WAS EXTENDED. CREW INITIATED A GO AROUND AND COMPLIED WITH QRH. DUE TO LANDING FIELD CONDITION DIVERTED. MAINTENANCE FOUND INTERMITTENT TRANSDUCER FAULT AND REPLACED THE LT OTBSDR DALA2016021201015Fan · failedF/A NOTICED AN ACRID ODOR AT 1300 FT ON ARRIVAL. TURNED OFF ALL CABIN LIGHTS, ODOR DISSAPATED YET NEVER WENT AWAY. W/C 2120-2367, FOUND RECIRCULATION FAN WITH SMOKE ODOR AND EXCESSIVE VIBRATION. R & R RECIRCULATION FAN IAW AMM 21-20, CONTACTED OK FOR SERVICSDR DALA2016021201014Warning Horn · false activationDURING TAKEOFF AND LANDING WITH ENGINE ANTI-ICE ON, NO WING ANTI-ICE SMOKE ALARMS IN BOTH AFT LAVS CAME ON, THEN SILENCED AFTER SEVERAL MINUTES. AT FL 360 WITH ONLY ENGINE ANTI-ICE ON, GOT RT AIR CONDITIONING SUPPLY TEMP HIGH ANNUNCIATION WITH SOME CABIN SMOKSDR DALA2016021201013Bulkhead · dentedDENTED FWD BULKHEAD, BS 37, X=0 TO X=-2 AND Z=-18 IN NLG COMPARTMENT. REPAIRED IAW ER/A 543140-14, REV ORIG AND ETI 88-16-047, REV 1.SDR DALA2016021201012Intercostal · corrodedCORROSION ON INTERCOSTAL IN BS 1347 BETWEEN X -18 TO X -25. DAMAGE INTERCOSTAL WAS REMOVED IAW SRM 51-30-2. A NEW INTERCOSTAL WAS DRILLED IAW SRM 51-10-4. NEW HOLES ON INTERCOSTAL WERE TREATED AND PAINTED IAW SRM 51-10-3 OAR 14 AND 2. NEW INTERCOSTAL WAS ISDR DALA2016021201011Intercostal · crackedCRACKED INTERCOSTAL BETWEEN BS 769 -788 AND X 0. THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-02, 51-30-05, 51-10-4 AND 51-10-3, PAR 21 AND 14.SDR DALA2016021201010Longeron · crackedCRACKED LONGERON 16R BS 1429 AT AFT ACCESSORY COMPARTMENT. LONGERON WAS REPLACED IAW SRM 53-14-4, 51-30-2 AND 51-30-5.SDR DALA2016021201009Longeron · crackedCRACKED LONGERON 16L, BS 1429. THE LONGERON WAS REPLACED IAW SRM 53-14-41, 51-30-2 AND 51-30-5.SDR DALA2016021201008Seat Track · corrodedCORROSION ON SEAT TRACK PLUG AT BS 858. THE PLUG WAS REPLACED IAW SRM 53-05, FIG 4.SDR DALA2016021201007Floor Panel · crackedCRACKED FLOOR PANEL 1307B. THE FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2016021201006Frame · crackedCRACKED FRAME BS 1380 AND LONGERON 15L AT AFT ACCESSORY COMPARTMENT FRAME WAS REPLACED IAW SRM 53-14-4, FIG 1 AND 51-30-5.SDR DALA2016021201005Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1077 AT X -60 AND X -54. EXECESS DAMAGE WAS REMOVED IAW SRM 51-30-2. FABRICATE DOUBLER, RING DOUBLER AND FILLER IAW SRM 53-05, FIG 131-A-7 SHEET 1 AND WERE TREATED AND PAINTED IAW SRM 51-10-3 PARR 14 AND 21. REPAIR PART WERE INSSDR DALA2016021201004Fairing · damagedEXPOSE METALIZER MATERIAL ON RUDDER FAIRING NR 6508A. THE METALIZER WAS INSTALLED IAW SRM 51-70-1AD, PAR 23.SDR DALA2016021201003Door Frame · crackedCRACKED FRAME ON BS 1485 CANT BELOW OF PASSENGER AFT ENTRANCE DOOR STAIRWAY ACTUATING CYLINDER. FRAME WAS REPAIRED IAW SRM 53-03D, FIG 43.SDR DALA2016021201002Door Sill · corrodedLOWER CARGO DOOR SILL HAS SEVERAL AREAS OF CORROSION AND EDGE SEAL DETERIORATED. REPAIRED IAW PRI 543287-14 ALL REVISIONS AND COMPLIED WITH ERA 543287-14, REV ORIGINAL.SDR DALA2016021200999Access Panel · corrodedCORROSION ON SETLEMENT AREA AND COUNTERSINK AT FUEL ACCESS PANEL 1436C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016021200997Control Valve · failedDURING CLIMBOUT PASSING 5000 FT, THE FLOW LIGHT, ILLUMINATED. THE RT PACK HAD SHUTDOWN. ACCOMPLISED QRH PROCEDURE WITH NO POSITIVE RESULT. RT PACK WOULD NOT RECOVER AND LT PACK WOULD MANAGE THE CABIN ALTITUDE KEPT CLIMBING. RETURNED TO DEPARTURE. REPLACED RTSDR DALA2016021100980Handle · misinstalledMAINTENANCE FOUND THE TAILCONE EXTERNAL RELEASE HANDLE IMPROPERLY INSTALLED. CABLE WAS REINSTALLED PROPERLY IAW AMM 53-53-00-501.SDR DALA2016021000969Pin · pulledMAINTENANCE FOUND THE L1 DOOR EMERGENCY ESCAPE SLIDE PINS PULLED OUT. THE EMERGENCY ESCAPE SLIDE PACK WAS REPLACED AT DOOR L1.SDR DALA2016021100981Ferrule · damagedDAMAGE FERRULES ON FLOOR PANEL. DAMAGE FERRULE REPLACED IAW AMM 53-20-01-201.SDR DALA2016021000968Frame · corrodedCORROSION ON FRAME BS 1250 ON LONGERON 30 AT C3. FRAME WAS REPAIRED IAW SRM 53-03"D", FIG 2A SHEET 3.SDR DALA2016021000967Cusp Web · crackedCRACK ON RT CUSP WEB BETWEEN BS 807 - 826 BETWEEN SEAT TRACK X=54, X=60. CRACKED RT CUSP WEB BETWEEN BS Y=807, Y=826 BTW SEAT TRACK X=54, X=60 WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2016021000965Intercostal · crackedCRACK ON PREVIOUS REPAIR OF INTERCOSTAL IN BS 1355, FRONT OF AFT PRESSURE BULKHEAD X= -25 AT CABIN FLOOR STRUCTURE. INTERCOSTAL WAS REPAIRED IAW SRM 51-10-3, PAR 21 AND 14, SRM 51-30-2 AND SRM 51-30-5.SDR DALA2016021000964Floor Support · crackedCRACKED CHANNEL AT LT FLOOR PANEL 1155 A. CHANNEL AT LT FLOOR PANEL NR 1155A WAS REPAIRED IAW SRM 51-70-1D, PAR 10.SDR DALA2016021000963Access Panel · corrodedCORROSION ON FUEL ACCESS PLATE NR 1367C COUNTERSINK AREA. FUEL ACCESS WAS REPLACED.SDR DALA2016021000962Cusp Web · crackedCRACKED ON LT CUSP WEB AND MISSING BRACKET BS 242 BETWEEN X=60 AND X=54 AT CAB PASSENGER REMOVED DAMAGE AND DOUBLER WAS FABRICATED. TREATED AND PAINTED AND DOUBLER WAS INSTALLED IAW SRM 53-05; 51-10-3 PAR 14 AND 21; 51-30-2 AND 51-30-5.SDR DALA2016021000961Cable · wornMAINTENANCE FOUND A TAILCONE CABLE WORN AT THE LOOP END. THE CABLE WAS REPLACED IAW AMM 53-53.SDR DALA2016021000960Cable · obstructedMAINTENANCE FOUND THE TAILCONE FRAME INTERFERING WITH A RELEASE CAM. THE TAILCONE RING WAS ROUTED AND A DOUBLER WAS INSTALLED IAW DWG 991157.SDR DALA2016022201299Vane · corrodedCORROSION ON INTERNAL STRUCTURE TO ATTACH CLEVIS BS XV2=245 AT LT OTBD FLAP MID GUIDE VANE. LT OTBD FLAP MID GUIDE VANE WILL BE REPLACE DUE TO SEVERAL DAMAGE THEREFORE WAS REMOVED WITH CARD 2710-4629, JOB 001-0166 AND WAS REPLACED WITH REPAIRED LT OTBD FLAP MSDR DALA2016020900938Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM 503 TO 598, X=54 TO X=60 AT CABIN FLOOR STRUCTURE. CUSP WEB WAS REPLACED IAW SRM 51-30-2 AND DWG 9930538, REV CF DUE EXCESSIVE CORROSION.SDR DALA2016021901249Stop Fitting · wornWEAR ON FWD AND AFT STOPS BETWEEN BEAM 1 AND 2 AT FWD CARGO DOOR. STOPS WERE REPLACED IAW SRM 51-30-1.SDR DALA2016020800920Structure · damagedSCRATCHES AND CORROSION ON LT & RT INBD AND OTBD HINGE PIVOT BORE AT HORIZONTAL STABILIZER. LT & RT INBD AND OTBD HINGE PIVOT BORE WAS REPAIRED IAW SRM 55-02D PAR 7B ETI-88-16-042 REV 1 AND ER/A 543136-14, FINAL 1D.SDR DALA2016020900940Structure · crackedLEFT WHEEL WELL FWD OF GEAR DOOR BELOW GEAR DOOR SENSOR IS CRACKED. PERFORMED REPAIR IAW ERA 543814-14, REV ORIG SECTION II PERMANENT REPAIR.SDR DALA2016020900939Channel · crackedRIGHT WHEEL WELL DOOR JAMB CHANNEL, FWD OF GEAR DOOR CRACKED BELOW DOOR SENSOR. REMOVED WHEEL WELL DOOR JAMB CHANNEL. DRILLED UP REPLACEMENT JAMB AND BEGAN INSTALLING WHEEL WELL DOOR JAMB. PERFORMED REPAIR AS PER ERA 543814-14 REV ORIG SECTION II PERMANENT REPSDR DALA2016020800924Pan · crackedCRACK ON PAN AT LOWER FWD CORNER OF LT AFT EMERGENCY EXIT DOOR. PAN WAS REPAIRED IAW SRM 52-05D, FIG 51.SDR DALA2016020800923Cusp Web · corrodedCORROSION UPPER AND UNDER AT TRIPLER AND DOUBLER FROM LT CUSP WEB BS 897. REPAIR DOUBLER AND TRIPLER WERE REPLACED IAW SRM 53-05, FIG 131A-11, SHEET 1.SDR DALA2016020800922Skin · damagedSUNKEN FASTENERS 9 EA AT REMOVABLE L/E SECOND ROW ABOVE BS ZFS=52.267 VERTICAL STABILIZER. VERTICAL STABILIZER WAS REPAIRED IAW SRM 55-03D, PAR 28, FIG 30, 55-03, PAR 27, FIG 29, 51-10-3, PAR 14/21, 51-10-2, 51-10-4 AND 51-30-5 AND AMDS 55-30-01045-08.SDR DALA2016020800921Rib · crackedCRACK OF 0.625" OF LENGTH ON HORIZONTAL STABILIZER CENTER SECTION RT RIB HINGE PIVOT BEARING LUG. RIB WAS REPLACED IAW AMM 20-10-14, 55-10-00-201, PARA 8B, 7B AND CARD 5500-01011-08, JOB 184-0001.SDR DALA2016020800919Pan · crackedCRACK ON PAN AT UPPER FWD CORNER OF LT FWD EMERGENCY EXIT DOOR. PAN FWD CORNER OF LT FWD EMERGENCY EXIT DOOR WAS REPAIRED IAW SRM 52-05D, FIG 51.SDR DALA2016020800917Former · crackedCRACKED FORMERS ON BS ZFS=23 LT SIDE AND BS ZFS=23 AND 36 AT VERTICAL STABILIZER LEADING EDGE INTERNAL STRUCTURE. CRACKED FORMERS WERE REPAIRED IAW DC9/MD80 SRM 55-02D, FIG 27, PERFORM INSPECT FOR CRACKS ON L/E SKIN EVERY C-CHECK IAW SRM 55-02D, FIG 27 PAG 113SDR DALA2016020900941Door Frame · crackedLT MLG FWD DOOR JAMB CRACKED. REMOVED DAMAGED CHANNEL, DRILLED UP NEW CHANNEL REPAIR SECTION. C/W ERA 543810-14, REV ORIGINAL SECTION II, PERMANENT REPAIR.SDR DALA2016020800930Wire · brokenTHE AFT EQUIPMENT BAY EMERGENCY LIGHTS WERE FOUND INOPERATIVE. MAINTENANCE RETERMINATED 2 CONNECTORS AND THE LIGHTS CHECKED OK.SDR DALA2016020800929Hinge · damagedELONGED HOLES AT FWD AND AFT HINGES OF MID CARGO DOOR. HOLES OF HINGES WERE REPAIRED IAW ER/A 497387-14 MA, REV B, HOLE HINGE AFT ID 0.798" AND HOLE HINGE FWD ID 0.799.SDR DALA2016020700916Cusp Web · corrodedCORROSION ON RT CUSP WEB PREVIOUS REPAIR DOUBLER BETWEEN BS 484, BS 527 BETWEEN TRACK X=54/ X=60. DOUBLER WAS REPLACED IAW SRM 51-30-2 53-01, FIG 2 AND 51-10-3, PAR 14, 21.SDR DALA2016020700915Cargo Track · corrodedCORROSION ON LT CARGO TRACK SPLICES, BS 1212 AT C3. DUE TO EXCESSIVE CORROSION CARGO TRACK SPLICES WERE REPLACED IAW SRM 51-10-2 AND 51-30-5, DWG 5936660, REV: BZ ORIGINAL.
Back to Mcdonnell Douglas MD-88