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 DALA2015111807041Pan · crackedCRACK FWD LOWER CORNER RING PAN BETWEEN BS 237 TO 256 RT SIDE. AREA WAS REPAIRED IAW SRM 53-05, FIG 122, 51-10-3, PAR 14 AND 21, 51-30-5, 51-30-2 ER/AS 487747-14MA REV A AND 493648-14MA, REV. A.SDR DALA2015111807040Pan · crackedCRACK FWD UPPER CORNER RING PAN BETWEEN BS 503 TO 522 RT SIDE. AREA WAS REPAIRED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5, 51-10-3, PAR 14 & 21 AND ER/AS 487747-14MA REV A,AND 493648-14MA, REV A.SDR DALA2015111807039Pan · crackedCRACK FWD LOWER CORNER RING PAN BETWEEN BS 1136 TO 1155 RT SIDE. RING PAN WAS REPAIRED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 122 AND 51-10-3, PAR. 14 AND 21 AND ER/A 487747-14MA REV A, AND 493648-14MA, REV A.SDR DALA2015111807036Pan · crackedCRACK AFT LOWER CORNER RING PAN BETWEEN BS 886 TO 905 RT SIDE. AREA WAS REPAIRED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5, 51-10-3, PAR 14 & 21 AND ER/AS 487747-14 MA, REV A, AND 493648-14 MA, REV A.SDR DALA2015111807033Pan · crackedCRACK AFT UPPER CORNER RING PAN BETWEEN BS 1022 TO 1041 RT SIDE. RING PAN WAS REPAIRED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 122 AND 51-10-3 PAR 14 AND 21 AND ER/A'S 487747-14MA, 493648-14MA.SDR DALA2015111807032Floor Panel · delaminatedDELAMINATED FLOOR PANEL 886C. FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201. FLOOR PANEL WAS CLEANED. FLOOR PANEL REPLACED IAW DWG 9936639, REV P.SDR DALA2015111807031Cargo Track · corrodedCORROSION ON LT TIE TRACK BETWEEN BS 1007 TO 1322 AT AFT CARGO COMPARTMENT. DUE TO EXCESSIVE CORROSION TIE TRACKS WERE REPLACED IAW SRM 51-10-04 AND 51-30-2.SDR DALA2015111707005Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING IN THE FIRST CLASS SECTION OF THE CABIN HAD FAILED. MAINTENANCE REPLACED THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR WX0A2015111973002Filter · dirtyJUST AFTER DEPARTURE, THE CREW RECEIVED, LAV SMOKE DET, ANNUNCIATOR WITH THE ASSOCIATED CAUTION LIGHT. THE CREW HEARD THE AUDIBLE LAVATORY SMOKE ALARM & THE FLIGHT ATTENDANTS CALLED FWD SHORTLY AFTER REPORTING WHAT WAS GOING ON & THAT THERE WAS A HAZE IN THE SDR DALA2015111807038Pan · crackedCRACK FWD LOWER CORNER RING PAN BETWEEN BS 845 TO 864 RT SIDE. AREA WAS REPAIRED IAW SRM 53-05, FIG 122, 51-30-5, 51-30-2, 51-10-3, PAR 14 AND 21, ER/A 487747-14MA, REV A AND 493648-14 MA, REV A.SDR DALA2015111807037Pan · crackedCRACK FWD LOWER CORNER RING PAN BETWEEN BS 807 TO 826 RT SIDE. AREA WAS REPAIRED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5, 51-10-3 PAR 14 AND 21 AND ER/AS 487747-14 MA, REV A AND 493648-14MA, REV A.SDR DALA2015111606975Skin · wornWEAR ON LOWER SKIN APPROXIMATELY XIVIF =47 ON INBD VANE OF INBD FLAP AT RT WING. THE FLAP WAS REPAIRED IAW SRM 57-03D, PAR II.SDR DALA2015111606974Skin · damagedNICKS ON LOWER PREVIOUS REPAIR DOUBLER ON INBD VANE OF INBD FLAP AT RT WING. INBD VANE OF INBD FLAP WAS REPAIRED IAW SRM 57-03, D PAR II.SDR DALA2015111606973Cargo Track · damagedELONGATED HOLES ON RT CARGO TRACK BETWEEN BS 731 - 773. THE CARGO TRACK WAS REPLACED IAW DWG 5936587, REV CC, AND SRM 51-30-1.SDR DALA2015111807035Pan · crackedCRACK FWD UPPER CORNER RING PAN BETWEEN BS 769 TO 788 RT SIDE. AREA WAS REPAIRED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5, 51-10-3 PAR 14 & 21 ER/AS 487747-14 MA REV A, 493648-14 MA REV A.SDR DALA2015111707030Power Supply · inoperativeMAINTENANCE FOUND THE EMERGENCY LIGHTS FROM SEAT ROWS 31 AND AFT TO BE INOPERATIVE. THE B5-212 POWER SUPPLY WAS REPLACED. THE LIGHTS TESTED GOOD.SDR DALA2015111506969Floor Panel · corrodedCORROSION OUT OF LIMITS ON FLOOR PANEL NR 120D. THE FLOOR PANEL WAS REPLACED.SDR DALA2015111506968Longeron · crackedCRACK ON LONGERON 4R BS 540. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015111506967Skin · damagedNICKS ON PREVIOUS REPAIR, LE AND LOWER SKIN ON INBD VANE OF INBD FLAP AT LT WING. PREVIOUS DOUBLER REPAIR WAS REPLACED IAW SRM 57-03D P.11.SDR DALA2015111506966Skin · dentedDENT ON PREVIOUS DOUBLER REPAIR, BS 238 BETWEEN LONG 17 - 18L ON OUTER FUSELAGE SKIN. REPAIRED IAW ER/A 273447-14, REV E.SDR DALA2015111506965Cargo Track · corrodedCORROSION ON RT CARGO TRACK BETWEEN BS 1212 - 1322. THE CARGO TRACK WAS REPLACED.SDR DALA2015112007097Skin · damagedDENTS ON UPPER SKIN AND NICK ON LOWER SKIN AT RT ELEVATOR GEARED TAB. RT GEARED TAB WAS REMOVED WITH CARD 2730-4830 AND WAS REPLACED DUE TO EXCEED THE ALLOWABLE REPAIRS IAW SRM 55-04, PAR 2 (4) AND REPAIRED RT GEARED TAB WILL BE INSTALLED WITH CARD 2730-4832.SDR DALA2015112007096Tab · contaminatedPRESENCE OF WATER WAS FOUND ON RT ELEVATOR ANTI-FLOAT TAB HONEYCOMB STRUCTURE. RT ANTI-FLOAT TAB WAS REMOVED WITH CARD AC 0992, CARD 2730-4830 AND REPLACE DUE TO PRESENCE OF WATER WITH REPAIRED RT ANTI-FLOAT TAB AND WILL BE INSTALLED WITH CARD 2730-4832.SDR DALA2015111406964Skin · damagedELONGATED HOLE ON INTERNAL FUSELAGE SKIN, BELLY DRAIN HOLE, BS 1210 BETWEEN LONGERONS 29 - 30L. REPAIRED IAW ETI-88-15-373, REV 1 AND ER/A 539904-14, REV ORIG.SDR DALA2015111406963Skin · crackedCRACK ON SKIN SURFACE AT LT INBD FLAP OTBD GUIDE VANE APPROXIMATELY ON BS XRS=121-TO XRS =124. DAMAGE AREA WAS REPAIRED IAW ERA NR 539946-14, REV ORIGINAL.SDR DALA2015111406962Door Frame · corrodedCORROSION ON PAN AT C1 CARGO DOOR JAMB FROM, BS 370 TO 427. BOTH SURFACES. C1 CARGO DOOR JAMB WAS REPAIRED IAM ER/A 539907-14, REV ORIGINAL.SDR DALA2015111406961Skin · damagedDAMAGE METALLIZED OF RUDDER BOTH SIDE. RUDDER BOTH SIDE WAS REPAIRED AND PAINTED IAW SRM 51-70-1A, P23 AND 51-10-3B, PROCESS "B".SDR DALA2015111406960Frame · unknownLOWER CHORD SPLICE ROUND ON BS 1338 BETWEEN LONGERONS 26-27L AND 26-27R. AREA WAS REPAIRED IAW ETI-88-15-372 REV 1 AND ER/A 539897-14, REV.SDR DALA2015111406959Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL TANK ACCESS DOOR NR 1311C AT LT WING. ACCESS DOOR 1311C WAS REPLACED IAW SRM: 51-22-2A, COND 2, PAR 1.SDR DALA2015111306942Door Frame · corrodedEXFOLIATION CORROSION ON LOWER DOOR JAMB BETWEEN BS Y=660 TO 693 MID CARGO COMP. PREVIOUS REPAIR AND CORROSION WERE REMOVED WITH ORIGINAL THICKNESS, BS Y=687 0.210" AND REMAINING IS 0.167", BS Y=645-686, ORIGINAL THICKNESS 0.280" AND REMAINING 0.219" THEREFORESDR DALA2015111306939Frame · crackedCRACK ON FRAME BS 1174, LONGERON 5L. THE FRAME WAS REPAIRED IAW SRM 51-30-2 AND 51-30-5 AND ETI 88-15-393 AND ER/A 539932-14, REV ORIGINAL.SDR DALA2015111306938Longeron · crackedCRACKED LONGERON 12R, BS 1437. THE LONGERON WAS ATTENDED WITH ER/A 539936-14, REV ORIG.SDR DALA2015111306937Floor Support · crackedCRACKED CHANNEL ON FLOOR PANEL NR 256A, 465E AND 541F AT CABIN PASSENGER FLOOR PANELS WERE REPAIRED IAW SRM 53-05, FIG 131B.SDR DALA2015111306936Skin · damagedDAMAGE METALLIZED ON RUDDER FAIRING NR 6508A. RUDDER FAIRING NR 6508A WAS REPAIRED IAW SRM 51-70-1A, PAR 23 AND CARD 2000-8149-01.SDR DALA2015111306935Door Frame · crackedCRACK ON FWD DOOR JAMB, BS 937, X-8 AT W/W . CRACK WAS STOP DRILLED AND FABRICATED DOUBLER TREATED AND PAINTED IAW SRM 53-01, FIG 2 AND 51-10-3, PAR 14.SDR DALA2015111306934Support · brokenBROKEN SLANT SUPPORT, BS 598 BETWEEN LONGERONS 27-28L. SLANT SUPPORT WAS REPLACED IAW ER/A 413029-14MA, REV D.SDR DALA2015111206911Support · brokenBROKEN RT SLANT SUPPORT BS 1271 AT AFT CARGO COMPARTMENT. SLANT SUPPORT WAS REPLACED IAW ER/A NR 413029-14MA.SDR DALA2015111206910Cusp Web · damagedTOOL DAMAGE ON LT CUSP WEB, BS 267-271 BETWEEN X 44-X 54 AT PAX CABIN. THE CUSP WEB WAS REPAIRED WITH ER/A 539927-14, REV ORIGINAL.SDR DALA2015111206909Skin · damagedWEAR ON RECEIVER OF L1 DOOR HOOK AT EXTERNAL FUSELAGE SKIN BETWEEN LONGERON 15LT AND 14LT, BS 160 TO 148. NEW DOUBLER WAS FABRICATED, DRILLED, PAINTED, AND INSTALLED IAW SRM 53-04, FIG 24, SHEET 2, 51-10-4, 51-10-3 PAR 14, 51-30-2, AND 51-30-5, 51-10-2. PISDR DALA2015111206908Floor Panel · delaminatedDELAMINATED FLOOR PANEL. THE FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201. AND REPLACED THE FERRULE IAW AMM 53-20-01-201.SDR DALA2015111807050Pan · crackedCRACKED LT RING PAN FWD UPPER CORNERS BETWEEN BS Y= 446-465, 655-674, 731-750, 1022-1041, 1060-1079 AT PAX CABIN. RING PAND WERE REPAIRED IAW SRM 51-30-2, 51-30-5 53-05, FIG 127 AND 51-10-3, PAR 14, 21 ERAS 487747-14MA REV A, 493648-14 MA, REV A.SDR DALA2015111807034Pan · crackedCRACK FWD UPPER CORNER RING PAN BETWEEN BS 788 TO 807 RT SIDE. AREA WAS REPAIRED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5, 51-10-3 PAR 14 & 21, ERAS 487747-14MA, REV A, 493648-14 MA, REV A.SDR DALA2015111206933Spar Cap · crackedCRACK WAS FOUND OF 4.000" ON ELEVATOR SPAR CAP OF THE LT ELEVATOR BETWEEN BS XE=136 AND XE=140. SM, CARD 35, ZONE 60. CRACK WAS REPAIRED IAW ER/A 539903-14, REV ORIGINAL. PERFORM DECAL INSPECTION CONDITION IAW TOPP 30-10-70, PAGE 13, PARAGRAPH I. RII COMPLESDR DALA2015111206907Longeron · crackedCRACKED LONGERON 3L AT BS 1437 AFT ACCESSORY COMPARTMENT. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015111206906Frame · crackedCRACK ON FRAME ANGLE BS 1380 LONGERON 15R IN AFT ACCESSORY COMPARTMENT. THE FRAME ANGLE WAS REPLACED IAW SRM 53-14-4, FIG 1, SHEET 2, SRM 51-30-5, 51-30-2.SDR DALA2015111206905Longeron · crackedCRACKED LONGERON 4L AT BS 1437 AFT ACCESSORY COMPARTMENT. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015111206903Floor Support · crackedSEVERAL CRACKS IN FLOOR SUPPORT BS 1287-1309, BL 0 BETWEEN CABIN FLOORBEAMS AFT CARGO. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-5, 51-10-4, AND DWG 5930560, REV BC.SDR DALA2015111206902Skin · crackedCORROSION ON FUSELAGE SKIN INTERNAL DOUBLER BETWEEN BS 1309-1322 AND LONGERONS 20-23L. REPAIRED IAW ER/A 508134-14, REV B.SDR DALA2015111206901Skin · crackedCRACK OF 0.150" LENGTH ON FUSELAGE SKIN, BS 1418 BETWEEN LONGERON 2-3 LT, SM, CARD 2, ZONE 65. DAMAGE WAS REPAIRED IAW ER/A 539886-14, AD REV: ORIGINAL. REPAIR APPROVAL IS LIMITED TO 75,000 TOTAL CYCLES ONLY. ADDITIONAL E/A, ER/A REVISION, IS REQUIRED FOR SDR DALA2015111206900Seat Track · corrodedCORROSION OUT OF LIMITS ON LT SEAT TRACK, X=22 BS 1214. SEAT TRACK WAS REPLACED IAW SRM 53-05, PAR 4B AND FIGURE 4F.
Back to Mcdonnell Douglas MD-88