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 DALA2016012100497Longeron · crackedCRACKED LONGERON 7L BS 1338 AT FUSELAGE CABIN STRUCTURE. LONGERON END 7 LT WAS REPLACED IAW DWG, REV H, SRM 51-10-3, PAR 14, 21, SRM 51-10-4 AND SRM 51-30-5.SDR DALA2016012100496Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM BS 598 TO 617 BETWEEN X=44 TO X=60 AT CABIN FLOOR STRUCTURE. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2016012100495Longeron · crackedCRACK LONGERON 16R WITH FRAME BS 1437. SECTION LONGERON WAS REPLACED BS 1437 IAW SRM 53-14-4, 51-30-2, 51-30-05 51-10-3, PAR 21 AND 14 AND DWG 5910228, REV KH.SDR DALA2016012100494Cusp Web · corrodedOUT OF LIMITS CUSP WEB BETWEEN BS 739-743 AND BS 772-776 X=-54 TO X=-60 AT RT SIDE. CUSP WEB WAS REPAIRED ON BS 739-743 AND 772-776 BETWEEN X=-57 TO X=-60 AT RT SIDE. ON REF CARD 73, ACFT ZONE 201 IAW SRM 51-30-1, 51-30-5, 51-30-2, 53-05, FIG 131A-6, 53-05 SDR DALA2016102510212Skin · gougedFUSELAGE SKIN L-1 PASSENGER DOOR DENT AND GOUGE. REPAIRED PER ERA 532474-14.SDR DALA2016012000445Longeron · crackedCRACKED LONGERON 12L BS 1437. LONGERON REPAIRED IAW SRM 53-02, FIG 18, 51-30-2, 51-10-3 PAR 21/14 AND 51-30-5.SDR DALA2016012000444Intercostal · crackedCRACKED INTERCOSTAL BETWEEN BEAMS NR 4 AND NR 5 AT PASSENGER ENTRANCE DOOR L1. INTERCOSTAL BETWEEN BEAM NR 4 AND 5 AT WAS REPLACED IAW DWG 9955763, REV:M AND 51-30-2, 51-10-3.SDR DALA2016012000443Access Panel · damagedDAMAGE FLAME SPRAY ON ACCESS PLATE 6504A0. ACCESS PLATE 6504A WAS REPAIRED IAW SRM 51-70-1AD, PAR 23, AND CARD 2000-8149-01, JOB 000-002.SDR DALA2016012000442Cusp Web · corrodedCORROSION ON RT CUSP WEB UPPER AND LOWER SURFACE BETWEEN X=-54 TO X=-60 FROM BS 599 TO BS 610 AND BS 600 TO BS 604, IN REF ORNRC 78, ZONE 201, SM, CARD 310, ZONE 201. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-14.SDR DALA2016012300543Bottle · low pressureMAINTENANCE FOUND THE R1 EMERGENCY ESCAPE SLIDE BOTTLE PRESSURE INDICATOR IN THE RED. THE R1 EMERGENCY ESCAPE SLIDE WAS REPLACED.SDR WX0A2016012173072Battery · dischargedAFT EMER FLASHLIGHT INOPERATIVE. R & R AFT EMER FLASHLIGHT BATTERY IAW AMM 25-60-00. OPERATIONS CHECKED GOOD.SDR DALA2016011900440Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016011900423Seat Track · corrodedCORROSION ON RT SEAT TRACK X=-54 BETWEEN BS 214 - 234. A NEW SEAT TRACK WAS DRILLED AND ADJUSTED IAW SRM 51-10-4 AND INSTALLED IAW SRM 53-05, FIG 4F.
SDR DALA2016011900422Access Panel · corrodedCORROSION ON FUEL ACCESS DOOR COUNTERSINK/SETTLEMENT AREA NR 1361C AT LT WING. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A. ANGLE ON NEW FUEL ACCESS WAS INSTALLED IAW SRM 51-30-05.SDR DALA2016011900421Web · crackedCRACK ON INTERNAL WEB, ANTI-ICE DUCT HOUSING, APPROXIMATELY XOS=379 AT RT SLAT NR 3. INNER SKIN WAS REMOVED AND INTERNAL WEB WAS FABRICATED AND REPLACED THEN INNER SKIN WAS INSTALLED IAW SRM 51-30-2, 51-30-8 AND DWG 9922514-REV U.SDR DALA2016011900420Longeron · crackedCRACK ON LONGERON 4R BS 522 AT CABIN STRUCTURE. LONGERON SECTION WAS REPAIRED IAW SRM 53-02, FIG 18, 51-30-5, 51-30-2, AND 51-10-3, PAR 21 AND 14.SDR DALA2016012500568Wire · brokenMAINTENANCE FOUND BROKEN WIRES ON THE TAILCONE SLIDE DEPLOYMENT CABLES 545 AND 547. CONTROL CABLES 545 AND 547 WERE REPLACED.SDR DALA2016011800416Longeron · crackedCRACKED LONGERON 4L AT INTERSECTION WITH FRAME AT BS 200. SECTION OF THE LONGERON WAS REMOVED IAW SRM 53-02, PAR 12, FIG 18. A NEW SECTION AND REPAIR SPLICE WERE ADJUSTED IAW SRM 53-02, PAR 12, FIG 18. THE NEW LONGERON AND SPLICE WERE TREATED AND PAINTED IASDR DALA2016011800415Skin · wornWEAR ON BS 1309, LONGERON 19R OUTER FUSELAGE SKIN. REPAIRED IAW SRM 53-04-2, FIGURE 2, SHEET 3.SDR DALA2016011900441Fuse · failedMAINTENANCE FOUND THE EMERGENCY LIGHTS INOPERATIVE IN THE AFT CABIN ZONE. A BLOWN F1 FUSE WAS FOUND AND REPLACED IN THE AFT CABIN BATTERY PACK. ALSO, WIRE L962U14 ADJACENT TO LIGHT ASSY L2-848 WAS FOUND CHAFING AGAINST A STRUCTURE AND THE WIRE WAS REPAIRED. SDR WX0A2016011973068Regulator Valve · faultyWITH TAKEOFF POWER ON LATIER RALE OF TAKEOFF & CLIMB OUT STROAS BURNING RUBBER SMELL FILLED THE CABIN. FA RETRACED SMELL TO COMPORT 3 TO 4 MINUTES, AFTER CLIMB POWER SELECTED BURNING RUBBER SMELL DISSIPATED. R & R LT PRESS REGULATOR VLV IAW AMM 21-31-01-2. SDR DALA2016011800419Skin · crackedUPPER RT WING T/E PANEL CRACKED FWD OF GROUND SPOILER OTBD END. REMOVED AND REPAIRED IAW SRM 51-90-0, PAR 8I. REINSTALLED IAW DWG 5936824.SDR DALA2016011800417Guide Vane · dentedDENT LT MID GUIDE VANE OF OTBD FLAP BETWEEN BS XV2=218 AND XV2=245. DENT ON LT MID GUIDE WAS REPAIRED IAW SRM 57-03, PAR 11 AND OPEN 1031, CARD 2000-8149-06.SDR DALA2016011700414Access Panel · corrodedCORROSION ON FUEL ACCESS DOOR COUNTERSINK SETTLEMENT AREA NR 1436C AT RT WING. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011700413Longeron · crackedCRACKED LONGERON 5L WITH FRAME BS 1437. LONGERON REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016011700412Skin · crackedRUN CRACK ON EXTERNAL FUSELAGE SKIN BS 100 BETWEEN LONGERONS 27 - 28R. HFEC INSPECTION WAS PERFORMED ON EXTERNAL FUSELAGE SKIN BETWEEN LONGERONS 27RT -28RT, BS 100 AND WAS FOUND A CRACK OF 0.375" LENGTH IAW NDT SPM 06-10-01.001. CRACK WAS STOP DRILLED WITH 0SDR DALA2016011700411Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G. THE FLOOR PANEL WAS REPLACE IAW DWG 9957828 AND CORROSION ON FILLER WAS ATTENDED IAW SRM 51-10-3, PAR 26-21-14.SDR DALA2016011700410Doubler · wornWORN DOUBLER, TITANIUM, ON AFT LAVATORY PANEL BS 1287-1309. DOUBLER WAS FABRICATED IAW SRM 51-30-2, 51-10- 3 AND DWG 5911423, REV CD.SDR DALA2016011700409Frame · crackedTAIL INTERIOR, LT CANTED FRAME WEB HAS .5" LONG CRACK AT FASTENER, BS 1485, 10 O`CLOCK POSITION, 1" BELOW HORIZONTAL STIFFENER.INSTALLED LT VENT BOX ASSY. ALL WORK PERFORMED AND COMPLETED IAW SRM 53-03, FIG. 48.SDR DALA2016011700408Skin · damagedLIGHTNING STRIKE ON COUNTERSINK AT FUSELAGE SKIN BS 261 BETWEEN LONGERON 29LT TO 30. FUSELAGE SKIN BS 261 BETWEEN LONGERON 29LT TO 30 IN REF MON, 88 L/L , 0592913; VIS ER/A 498753-II; FSLG SKN ; 996. WAS REPAIRED IAW SRM 53-04-2, FIGURE 2, SHEET 6 AND 33. PERSDR DALA2016011700407Vane · damagedNR 4 LEFT OTBD FLAP FIXED VANE HAS HOLE .7500" TO 1" LARGER AREA MAYBE DETERIATED. INSP LT OTBD FLAP, OTBD VANE AND FOUND DAMAGE IN 2 LOCATIONS BOTH WITH CORROSION AND BOTH WITH HOLES. FIRST AREA IS 18" FROM INBD END AND IS 1.25" FROM L/E. TAP TEST SHOWS AN SDR DALA2016011700406Access Panel · corrodedCORROSION ON COUNTER SINK AND SEATING AREA OF FUEL ACCESS PLATE NR 13570. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011700405Access Panel · corrodedCORROSION ON COUNTER SINK AND SETTLEMENT AREA AT FUEL ACCESS NR 1462C. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011700404Access Panel · corrodedELONGED HOLES AND CORROSION ON COUNTER SINK AT FUEL ACCESS NR 1464C. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011700403Access Panel · corrodedCORROSION ON COUNTER SINK AND SETTLEMENT AREA OF FUEL ACCESS NR 1454C. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011700402Access Panel · corrodedCORROSION ON COUNTER SINK AND TOOL DAMAGE ON SKIN AT FUEL ACCESS NR 1363C. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011700401Access Panel · corrodedCORROSION ON COUNTERSKIN AT FUEL ACCESS NR 1355C. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011700400Access Panel · corrodedCORROSION ON COUNTERSKIN AND SETTLEMENT AREA AT FUEL ACCESS NR 1456C. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011700399Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 582 TO 594, X = 54-60 AT CPAX, IN REF CARD 122, A/C ZONE 201. REMOVE DAMAGE, REPAIR PARTS WAS FABRICATED IAW SRM 53-05, FIG 131A-14. REPAIR PART WAS TREATED AND PAINTED, APPLY CIC IAW SRM 51-10-3, PAR 21,14 AND 38.SDR DALA2016011600398Access Panel · corrodedCORROSION AT COUNTERSINK AREA OF FUEL ACCESS PANEL 1476C. FUEL ACCESS DOOR 1476C WAS REPLACED IAW SRM 51-22-2A AND IPC 57-30-00.SDR DALA2016011600397Access Panel · corrodedCOOROSION AT COUNTERSINK AREA OF FUEL ACCESS PANEL 1436C. FUEL ACCESS DOOR 1436C WAS REPLACED IAW SRM: 51-22-2A AND IPC:57-30-00.SDR DALA2016011600396Guide Vane · gougedGOUGE ON RT INBD GUIDE VANE 3 OTBD FLAP LOWER SURFACE BETWEEN BS XV1 =153 AND XV1=181. GOUGE ON RT INBD GUIDE VANE OTBD FLAP LOWER SURFACE BETWEEN XV1=153 AND XV1=181 WAS REPAIRED IAW SRM 57-03.SDR DALA2016011600395Access Panel · corrodedCORROSION AT COUNTERSINK AREA OF FUEL ACCESS PANEL 1454C. FUEL ACCESS DOOR 1454C WAS REPLACED IAW SRM: 51-22-2A AND IPC: 57-30-00.SDR DALA2016011600394Seat Track · corrodedCORROSION ON RT SEAT TRACK X=-44 BETWEEN BS 200 TO 237 AT PAX CABIN IN REF CARD 78, ZONE 200, NRC 20000093922 CARD. SEAT TRACK X=-44 BETWEEN BS 200 TO 237 WAS REPLACED IAW SRM 53-05, FIG 4F, 51-10-4, 51-30-1, AND 51-30-5.SDR DALA2016011600393Access Panel · corrodedCORROSION AT COUNTERSINK AREA OF FUEL ACCESS PANEL 1355C. FUEL ACCESS DOOR 1355C WAS REPLACED IAW SRM: 51-22-2A AND IPC:57-30-00.SDR DALA2016011600392Door Frame · wornWORN CHANNEL ON RT FWD MLG WHEEL WELL DOOR JAMB BETWEEN X= -30 TO X=-60. CHANNEL WAS REPLACED IAW DWG 5930584, REV BY, SRM 51-30-2, AND SRM 51-30-5.SDR DALA2016011600391Intercostal · crackedCRACKED INTERCOSTAL BETWEEN BEAM 3 AND 4 AND MECHANISM AREA AT FWD MAIN ENTRANCE DOOR. THE INTERCOSTAL WAS REPLACED IAW DWG 9955763 REV M AND SRM 51-30-1, 51-30-2, 51-30-5 AND 51-10-4.SDR DALA2016011600390Access Panel · corrodedCORROSION AT COUNTERSINK AREA OF FUEL ACCESS PANEL 1371C. FUEL ACCESS DOOR 1371C WAS REPLACED IAW SRM 51-22-24 AND IPC 57-30-60.SDR DALA2016011600389Access Panel · corrodedCORROSION AT COUNTERSINK AREA OF FUEL ACCESS PANEL 1357C. FUEL ACCESS DOOR 1357C WAS REPLACED IAW SRM 51-22-2A AND IPC 57-30-00.SDR DALA2016011600388Access Panel · damagedSCRATCHES ON COUNTERSINK AT FUEL TANK ACCESS PANEL 1307C. FUEL ACCESS DOOR 1307C WAS REPLACED IAW SRM 51-22-2A AND IPC 57-30-00.
Back to Mcdonnell Douglas MD-88