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 DALA2016061604703Intercostal · crackedCRACKED INTERCOSTAL STA Y= 1497, CANT POS 10 HRS AT AFT ACCESSORY COMPARTMENT.
INTERCOSTAL WAS REPLACED IAW SRM 51-30-2 AND 51-30-5 AND DWG 9911875, REV J.SDR DALA2016061604702Channel · crackedCRACK ON CHANNEL AT FLOOR PANEL 693A. CRACK .165" WAS REPAIRED WITH SRM 53-05, FIGURE 131B.SDR DALA2016061604700Doubler · dentedDENT ON FUSELAGE SKIN PREVIOUS DOUBLER REPAIR STA Y=256 BETWEEN AND LONGERON 19LT. REPAIR DOUBLER AND FILLER WERE REPLACED IAW ER/A 332142-14, REV A.SDR DALA2016061504699Slide · defectiveL1 DOOR SLIDE PARACHUTE PINS NOT INSTALLED. R & R L1 DOOR SLIDER IAW WC 2561-4964. OK FOR SERVICE.SDR DALA2016061504696Connector · unsecure30DE EMERGENCY LIGHT INOPERATIVE. RESECURED PLUG ASSY, OPS CK NORMAL AT THIS TIME.SDR DALA2016061604675Warning Light · false activationRIGHT HYDRAULIC "HOT" OAP LIGHT ON, THEN ZERO HYDRAULIC PRESSURE BOTH SYS. ACCOMPLISHED QRH PROCEDURES FOR TOTAL HYDRAULIC FAILURE. ON BASE LEG AT 3000' AGL BOTH HYDRAULIC SYSTEMS CAME BACK TO NORMAL. ACCOMPLISHED NORMAL LANDING. FOUND RT HYD SYSTEM WITH EXSDR DALA2016061604701Channel · crackedCRACK ON CHANNEL AT FLOOR PANEL 541A, CRACK .135" WAS REPAIRED IAW SRM 53-05, FIG 131B, SHEET 1.SDR DALA2016061504698Skin · corrodedCORROSION ON BARREL NUT HOLE NR 14 AT HORIZONTAL STABILIZER CENTER SECTION BOX STA XH= -7. CORROSION ON BARREL NUT HOLE 14 AT HORIZONTAL STABILIZER CENTER SECTION BOX STA XH=-7 WAS REPAIRED IAW ER/A 546502-14, REV ORIGINAL.SDR DALA2016061504695Doubler · corrodedCORROSION ON LOWER DOOR JAMB REPAIR DOUBLER BETWEEN STA Y=636-Y 693 MID CARGO COMPARTMENT. DOUBLER ON LOWER DOOR JAMB WAS REPLACED IAW SRM 53-05, FIG 123 AND 51-30-5.SDR DALA2016061504694Access Door · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS DOOR NR 1462C AT RT WING. FUEL ACCESS DOOR 1462C WAS REPLACED.SDR DALA2016061504693Access Door · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS DOOR 1355C AT LT WING. FUEL ACCESS DOOR 1355C WAS REPLACED.SDR DALA2016061504692Access Door · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS DOOR NR 1456C AT RT WING. FUEL ACCESS DOOR 1456C WAS REPLACED.SDR DALA2016061504691Access Door · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS DOOR NR 1454C AT RT. FUEL ACCESS DOOR 1454C WAS REPLACED.SDR DALA2016061504690Access Door · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS DOOR 1363C AT LT WING. ACCESS DOOR 1363C WAS REPLACED.SDR DALA2016061504689Channel · crackedCRACK ON CHANNEL AT FLOOR PANEL NR 927E, CRACK .160" WAS REPAIRED IAW SRM 53-05, FIG 131B.SDR DALA2016061404686Light · inoperativeRIGHT EXTERIOR OVERWING EXIT LIGHT INOPERATIVE. INSTALLED NEW BULB IN EXTERIOR OVERWING EXIT LIGHT. OPS CK OK. OK FOR SERVICE.SDR DALA2016061404685Battery · dischargedLEFT AND RIGHT OVERWING EXIT DOORS AFT, OVERHEAD INTERIOR EXIT SIGN INOPERATIVE. INSTALLED NEW BATTERY IN BATTERY PACK FOR AFT OVERWING DOORS UPPER EXIT SIGNS. OPS CK OK. OK FOR SERVICE.SDR DALA2016061504604Sensor · malfunctionedWHILE ENROUTE FLIGHT DIVERTED DUE TO RT ENGINE HIGH OIL TEMP, THE ENGINE WAS NOT SHUTDOWN BUT AN EMERGENCY WAS DECLARED. MAINTENANCE RAN ENGINE AND DUPLICATED THE OIL TEMP ISSUE, REPLACED OIL TEMP BULB AND PERFORMED IMMERSION THERMOCOUPLE TEST. OIL TEMP GOODSDR DALA2016061504687Bushing · corrodedAWR HIDDEN DAMAGE: CORROSION ON LT UPPER T/E BUSHINGS, 10 EA BELOW HEATER BLANKET. BUSHINGS WERE REPLACED IAW PS-900-9-1, NR 06, PAR D, 1, A, SRM 51-30-10, PAR 7.SDR DALA2016061404684Skin · corrodedCORROSION ON BARREL NUT HOLE NR 14 AT HORIZONTAL STABILIZER CENTER SECTION BOX STA XH=7.234. CORROSION ON BARREL NUT HOLE 14 AT HORIZONTAL STABILIZER CENTER SECTION WAS REPAIRED IAW ER/A 546502-14, REV ORIGINAL.SDR DALA2016061404683Skin · corrodedCORROSION ON LT BARREL NUT HOLES NR 14, 17 AND 26 AT HORIZONTAL STABILIZER UPPER SKIN. BOLTS AND BARREL NUTS 14, 17 AND 26 WERE REMOVED IAW SRM 51-30-0, BARREL NUT HOLES 14 & 26 WERE REPAIRED IAW ER/A 546501-14, REV ORIGINAL, AND BARREL NUT HOLE 17 WAS REPAIRESDR DALA2016061404681Bushing · corrodedAWR HIDDEN DAMAGE: CORROSION ON LT UPPER T/E BUSHINGS, 10 EA, BELOW HEATER BLANKET. BUSHINGS WERE REPLACED IAW PS-900-9-1, NR 06 PAR D, 1, A, SRM 51-30-10, PAR 7.SDR DALA2016061404679Cusp Web · corrodedCORRODED RT CUSP WEB BETWEEN STA Y=636 TO 655 X=54 TO 60 AT CPAX. DUE TO EXCESSIVE CORROSION ON CUSP WEB, THIS AREA WAS REPAIRED IAW. SRM 53-05, FIGURE 131A-17.SDR DALA2016061404678Pan · crackedCRACK ON WINDOW RING PAN FWD UPPER CORNER STA Y=927 TO Y=946 AT CABIN STRUCTURE. AREA WAS REPAIRED IAW SRM 53-05, FIG 122 AND ER/A 493648-14MA, REV A AND 487747-14MA, REV A.SDR DALA2016061404659Skin · damagedSEVERAL LIGHTNING STRIKES ON WINDOW BELTS FROM BS 598 TO 655 LONGERONS 11 - 14R. REPAIRED IAW ER/A 546537-14, REV ORIGINAL AND SRM 53-05, FIG 111.SDR DALA2016061404682Doubler · corrodedCORRODED RT CUSP WEB PREVIOUS REPAIR STA Y=731 TO 750 X= 54 TO 60 RT AT CPAX. CUSP WEB PREVIOUS REPAIR WAS REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-5, SRM 53-05, FIG 131A-751-10-3 PAR 14, 21, 38.SDR DALA2016061404680Skin · damagedDAMAGED METALLIZED COAT ON RUDDER RT, LT SIDES. SUMMARY METALLIZED COAT WAS REPAIRED IAW ERA 092613-14MA, REV A.SDR DALA2016061304655Cusp Web · crackedCRACK ON LT CUSP WEB BTW BS 607-608 X 54 TO X 60. REPAIRED IAW SRM 53-05, FIG 131A-13, 51-10-3 PAR 38,-21-14, 51-30-2, 51-30-5.SDR DALA2016061304603Lamp · inoperativeDURING SERVICE CHECK, LT OVERWING EMERGENCY LAMP WAS NOT ILLUMINATING. REPLACED THE LAMP AND OPS CHECKED NORMAL.SDR DALA2016061304602Battery Pack · inoperativeDURING SERVICE CHECK, FOUND OVERWING EMERGENCY LIGHTS REMAINED ILLUMINATED AFTER EMERGENCY POWER REMOVED. REPLACED OVERWING EMERGENCY LIGHTS BATTERY PACK.SDR DALA2016061304572Rivet · looseWORKING RIVETS ON FUSELAGE AT BS 1437, RT SIDE L6. REPAIRED IAW PRI 547965-14, REV 0 AND COMPLIED WITH ERA 547965-14, REVISION ORIGINAL.SDR DALA2016061304570Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM BS Y: 796 TO 800 AND X -54 TO -60 AT PAX CABIN. AREA WAS REPAIRED IAW SRM 53-05, FIG 131A-1.SDR DALA2016061304568Hinge Fitting · crackedCRACKED HINGE FITTING OF SLAT PANEL NR 3, BS XOS= 332 AL LT WING. SLAT PANEL NR 3 WAS REPLACED IAW AMM 27-80-01.SDR DALA2016061304566Seat Track · corrodedCORROSION ON SEAT TRACK X 44 BETWEEN BS 200, TO 207 AT PAX CABIN. SEAT TRACK WAS REPAIRED IAW SRM 53-05, FIG 4F.SDR DALA2016061404656Floor Panel · crackedCRACK ON CHANNEL AT FLOOR PANEL NR 1003 F. CRACKS .125", .165" WERE REPAIRED IAW SRM 53-05, FIG. 131C, TREATED AND PAINTED IAW SRM 51-10-3 PARS. 14 AND 21, AND INSTALLED IAW SRM 51-30-2.SDR DALA2016061204564Door Frame · corrodedCORROSION ON DOOR JAMB BEAM, BS 375 TO 417 LONGERON 28R AT CARGO DOOR JAMB C1. SECTION OF DOOR JAMB WAS REPLACED IAW SRM 53-05, FIG 44A.SDR DALA2016061204560Pan · crackedCRACKED FWD LOWER CORNER OF LT RING PAN BETWEEN BS Y=712 TO Y=731, Y=1079 TO Y=1060, Y=1060 TO Y=1091 ATINTERNAL STRUCTURE. CRACKED RING PANS BETWEEN BS Y=712 TO Y=731, Y=1060 TO Y= 1079 AND Y=1041 TO Y=1060 WERE REPAIRED IAW SRM 53-05, FIG. 122, 51-30-02, 51SDR DALA2016061204559Cusp Web · corrodedCORRODED RT CUSP WEB PREVIOUS REPAIR BETWEEN BS 598 TO 617 RBL 54 - 60 IN PAX CABIN. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131 A-14 SRM 51-30-02, 51-30-05, 51-10-03, PAR 14 AND 21.SDR DALA2016061204555Cusp Web · crackedCRACKED LT CABIN FLOOR CUSP WEB DOUBLER AT BS 809 BETWEEN X=54 TO X=60. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A, 51-30-2, 51-30-5, 51-10-3 PAR 14 AND 21, 385.SDR DALA2016061204558Skin · damagedNICKS ON FUSELAGE SKIN L1 HOOK CUTOUT PREVIOUS REPAIR. NICKS WERE REPAIRED IAW ETI-88-16-223 AND ER/A 546555-14 REV ORIGINAL.SDR DALA2016061204557Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK ON FUEL ACCESS PLATE NR 1355C. ACCESS PLATE IS OUT OF LIMITS AND WAS REPLACED.SDR DALA2016061104553Cusp Web · corrodedCORRODED RT CUSP WEB PEVIOUS REPAIR BS 218 TO 226 RBL 54-60 IN PAX CABIN. PREVIOUS REPAIR WAS REPLACED IAW SRM 53-05, FIG 131A AND SRM 51-30-2.SDR DALA2016061104552Skin · damagedLOST MATERIAL ON UPPER AND LOWER SKIN AT LT ELEVATOR DOUBLER SETTLEMENT AREA BS XHR 217. AREA WAS REPAIRED IAW SRM 55-01, FIG 4 AND SRM 51-30-8.SDR DALA2016061104551Spar · crackedONE CRACK WAS FOUND ON INBD UPPER HOLE OF THE HORIZONTAL STABILIZER RT REAR CAP. INBD UPPER HOLE WAS DRILLED TO SECOND OVERSIZE IAW SR09550032, REV B, BHEC INSPECTION WAS PERFORMED NO CRACKS WERE FOUND IAW DC-MD NDT SPM 01-10-01.003, SECOND OVERSIZE IS WITHINSDR DALA2016061204556Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCES DOOR NR 1410C. ACCESS PLATE WAS REPLACED.SDR DALA2016061104554Frame · crackedCRACK ON FRAME BS 1174 BETWEEN LONGERON 6 - 7L IN AFT CABIN PAX CEILING AREA. REPAIRED IAW ER/A 495237-14, REV-B.SDR DALA2016061004526Seat Track · corrodedCORROSION ON REPAIR PLUG OF LT SEAT TRACK X 54 IN BS 935 AT PASSENGER CABIN. PLUG WAS REPLACED IAW SRM 53-05, FIG 4A.SDR DALA2016061004525Seat Track · corrodedCORROSION ON RT SEAT TRACK, PLUG X=-54 BETWEEN BS 343 TO 348. PLUG WAS REPLACED IAW SRM 53-05, FIG 4A.SDR DALA2016061004524Cusp Web · corrodedCORROSION ON CUSP WEB LOWER SURFACE OVER UPPER DOOR JAMB BEAM. BS 397 TO 403 X -51 TO X -57, LONGERON 18, RT CARGO DOOR JAMB C1. CORROSION WAS FOUND OUT OF LIMITS, AREA WAS REPAIRED IAW 53-05, FIG 131A-5, SHEET 1.SDR DALA2016061004523Window Frame · crackedCRACK ON FWD/LOWER RT WING PAN BETWEEN BS 576 TO 598 IN CPAX. RING PAN RT FWD/LOWER WAS REPAIRED IAW SRM 53-05, FIG 122 AND ERA 487747-14 MA, REV A ER/A 493648-14, REV A.
Back to Mcdonnell Douglas MD-88