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 DALA2015080304834Skin · crackedCRACKED FUSELAGE SKIN JUST FWD OF CANTED FRAME BS 1463 AND LONG 2L. REPAIR FABRICATED IAW ETI 88-15-272 AND ER/A 537728-14, REV ORIG. REPAIR WERE TREATED AND PAINTED IAW SRM 51-10-3. MAJOR REPAIR.SDR DALA2015080304826Angle · crackedCRACK ON FWD ANGLE OF UPPER CHANNEL IN LT FWD OVERWING EMERGENCY EXIT DOOR. A NEW ANGLE WAS INSTALLED IAW DWG 9957735, REV G, SRM 51-10-2, 51-30-5, AND 51-10-2 PARA 14 AND 21.SDR DALA2015080304825Hinge Fitting · corrodedCORROSION ON RT ELEVATOR NR 6 HINGE FITTING. THE RT ELEVATOR HINGE FITTING WAS REPAIRED IAW ER/A NR 537742-14, REV ORIGINAL.SDR DALA2015080304824Frame · crackedCRACKED FRAME BS 1452 LONGERON 1. THE FRAME WAS REPLACED IAW DWG 9911860, REV L, SRM 51-30-2 AND 51-30-5.SDR DALA2015080304823Longeron · crackedCRACKED LONGERON 17L BS 1380. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015080304822Seat Track · corrodedCORROSION ON LT SEAT TRACK, REPAIR PLUG X54, BS Y=351-355 AND BS 421-427. REPAIR PLUG REMOVED IAW SRM 51-30-1, AND NEW PLUGS INSTALLED IAW SRM 51-30-1.SDR DALA2015080304821Pan · crackedCRACKED OUTER PAN ON STOP FITTING NR 1 AFT EDGE AT MID CARGO DOOR. THE PAN WAS REPAIRED IAW ER/A: 455904-14MA, REV A HFEC WAS PERFORMED.SDR DALA2015080204820Frame · corrodedCORROSION FOUND ON FRAME BS 1380 BETWEEN LONGERONS 24L & 24R. THE FRAME WAS REPLACED IAW SRM 57-10-3, 51-30-2, 51-30-5 AND DWG 9912246.SDR DALA2015082505202Tab · dentedSEVERAL DENTS ON UPPER SKIN AT RT ANTI-FLOAT TAB GEARED TAB AND CONTROL TAB AT RT SIDE. DUE EXCESSIVE DAMAGE THE RT ANTI-FLOAT TAB, GEARED TAB AND CONTROL TAB AT RT SIDE WERE REPLACED IAW SRM 55-04, P.2.SDR DALA2015080204819Frame · crackedCRACKED FRAME ANGLE DOUBLER BS 1452 BETWEEN LONGERONS 2 & 3L. A NEW FRAME ANGLE WAS FABRICATED AND INSTALLED IAW DWG 9911860, REV LT, SRM 51-30-2 AND 51-10-2.SDR DALA2015080204818Longeron · crackedCRACKED LONGERON 5R BS 1437. REMOVED THE LONGERON SECTION IAW SRM 53-02, PAR 12, REPAIRED IAW SRM 53-02, FIG 18. MAJOR REPAIR.SDR DALA2015080204817Frame · crackedCRACKED FRAME ANGLE BS 1452 BETWEEN LONGERONS 2 & 3L. A NEW FRAME ANGLE WAS FABRICATED AND INSTALLED IAW DWG 9911860, REV C, SRM 51-30-2, AND 51-10-2.SDR DALA2015080204805Floorbeam · crackedCRACKED FLOORBEAM AT BS 927 AND X-44, Z-2. FLOORBEAM WAS REPLACED IAW SRM 51-10-04, 51-30-01, 51-30-02, 51-30-05, AND DWG 5930561, REV AC.SDR DALA2015080204804Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1322, X -20, X-42. FOUND TO BE OUT OF LIMITS. REPAIRED IAW SRM 53-05, FIG 20A AND ER/A 397783-14MA.SDR DALA2015080204803Longeron · crackedCRACKED LONGERON 9R BS 1174. DAMAGE SECTION LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18. MAJOR REPAIR.SDR DALA2015080204802Frame · crackedCRACKED FRAME BS 1322 LONGERON 17L. REPAIRED THE FRAME IAW ER/A 493647-14MA, REV B.SDR DALA2015080304808Axle · corrodedEVIDENCE OF CORROSION ON RT NLG AXLE SHAFT, REF CRD 3200-01207-0101. RT AXLE SHAFT IAW AMDS 6221-6192.SDR DALA2015080304807Axle · corrodedEVIDENCE OF CORROSION ON LT NLG AXLE SHAFT. R & R LT NLG AXLE SHAFT IAW AMDS 3221-6192.SDR DALA2015080304806Hinge · corrodedCORROSION ON LT HORIZONTAL STABILIZER HINGE BOLT AND SLEEVE. BOLTS & SLEEVES WERE REPLACED.SDR DALA2015080204801Floorbeam · corrodedCORROSION ON FLOORBEAM, BS 1338 BETWEEN X -13 TO -17. FLOORBEAM WAS REPAIRED IAW ER/A 397783-14MA, REV ORIGINAL.SDR DALA2015080104800Floor Panel · crackedCRACKED COCKPIT FLOOR PANEL 120D. A NEW FLOOR PANEL WAS ADJUSTED AND DRILLED IAW SRM 51-10-4.SDR DALA2015080104799Fitting · crackedCRACK ON FITTING AT BS 905 X -51 AND Z -2. ADJUSTED AND DRILLED NEW FITTING IAW DWG 3922286, REV D, SRM 51-10-4, NEW FITTING WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 14 AND 21, NEW FITTING WAS INSTALLED IAW SRM 51-30-5.SDR DALA2015073104776Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS AT ROWS 13-26 WERE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR DALA2015073104775Longeron · crackedCRACKED LONGERON 12L, BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015073104774Pan · crackedCRACKS WERE FOUND ON THE UPPER FWD AND AFT CORNERS OF LT AFT OVERWING EMERGENCY EXIT DOOR PAN. REPAIR INSTALLED IAW SRM 52-05D, FIG 51 51-30-1, 51-30-2, 51-30-5, 51-10-2 AND 51-10-3 PARA 14, 21.SDR DALA2015073104773Cusp Web · crackedA CRACK WAS FOUND ON THE RT CUSP WEB BETWEEN X -54 TO X -60, BS 1295 - 1298. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A. HFCE INSPECTION WAS ACCOMPLISHED AND NO CRACKS WERE FOUND AFTER DAMAGE REMOVED.SDR DALA2015073104772Longeron · crackedCRACKED LONGERON 16L BS 408. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18, 51-30-2, AND 51-10-3, PAR 21, 14SDR DALA2015073104771Access Panel · corrodedCORROSION ON FUEL ACCESS PANEL 1361C. THE CORROSION WAS REMOVED. REMOVED AND REPLACED THE ACCESS PANEL IAW AMM 28-40-2.SDR DALA2015073104770Longeron · crackedCRACKED LONGERON 4R BS 464. THE LONGERON WAS REPAIRED IAW SRM 53-05, FIG 18, 51-10-3, PARR 21, 14, 51-10-4, 51-30-2 AND 51-30-5.SDR DALA2015073004759Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS IN ROWS 27-34 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR DALA2015073004758Oven · odorELECTRICAL ODOR DURING CRUISE. CHECK LIST COMPLIED WITH, ODOR DISSIPATED AFTER GALLEY POWER TURNED OFF. IDENTIFIED OVEN AS FAULT CAUSE.SDR DALA2015073004751Frame · crackedCRACKED AT THE BS 1463 FRAME 1:00 POSITION. REPAIRED IAW ER/A 535920-14, REV ORIGINAL.SDR DALA2016111108828Angle · corrodedCORROSION ON CUSP WEB ANGLE BS 685 - 690 BETWEEN RBL 54 TO 60. AREA WAS REPAIRED IAW ER/A.SDR DALA2015081805097Skin · corrodedAFT FUSELAGE SKIN CORRODED ALONG LOWER EDGE OF LAV PANEL. COMPLY WITH ERA 537873-14, REV O.SDR DALA2015073004757Frame · crackedCRACKED FRAME, BS 1322 LONGERON 17R. FRAME WAS REPAIRED IAW 493697-14MA, REV "B".SDR DALA2015073004756Skin · wornWEAR ON DOUBLER ON AFT/FWD LWR CORNER AT FWD CARGO COMPARTMENT DOOR OUTER SKIN. DOUBLERS WERE REPLACED IAW ER/A 486624-14MA, REV ORIGINAL.SDR DALA2015073004754Stiffener · damagedAT BS 1463 WEB, FOUND STIFFNER, HAS FOUR HOLES MISALIGNED, DUE TO OIL CANNING OF WEB. DAMAGE REMOVED AND THE .1875" HOLES ARE NOW .390-.400 DIAMETER. REPAIRED IAW ER/A 535920-14, REV ORIGINAL.SDR DALA2015073004753Frame · crackedFRAME BS 1463, CRACKED AT THE 1:00 POSITION. REPAIRED IAW ER/A 535920-14, REV ORIGINAL.SDR DALA2015073004752Tab · not reportedBUSHING GEARED TAB ATTACH POINTS WERE REPLACED. FITTING ON GEARED TAB ATTACH POINTS WAS REMOVED AND NEW FITTING WAS DRILLED, TREATED, PAINTED AND INSTALLED IAW CMM 27-30-1, AMM 20-30-01-201, SRM 51-10-4, 51-10-3, PAR 21 AND 14 AND 51-30-2. FREE PLAY WAS CORRSDR DALA2015073004750Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1322 X 21, X 43. THE FLOORBEAM WAS REPAIRED IAW SRM 53-05, FIG 20A.SDR DALA2015073004749Frame · crackedTAIL INTERIOR, LOWER AFT FLANGE AT OF FRAME, BS 1418 IS CRACKED AT L2L. REPAIRED IAW ER/A 538118-14, REV 0.SDR DALA2015073004748Guide Vane · damagedNICKS AND GOUGES FOUND ON INBD GUIDE VANE L/E OF INBD RT WING TE FLAP. THE GUIDE VANE WAS REPAIRED IAW SRM 57-03D.SDR DALA2015073004747Cusp Web · corrodedCORROSION OUT OF LIMITS FOUND ON LT CUSP WEB BETWEEN X 54 AND X 60, BS 1077 - 1086 . THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-6.SDR DALA2015073004746Cable · brokenBREAK TENSION NOSE WHEEL STEERING CONTROL SYSTEM CABLES ARE BROKEN. REPAIRED IAW AMM 32-51-00.SDR DALA2015073004755Bushing · corrodedFREEPLAY AND CORROSION ON BUSHING OF CONTROL TAB ATTACH POINTS AT RT ELEVATOR. CONTROL TAB ATTACH POINTS WERE REPLACED IAW CMM 27-30-1. FITTING ON BS XET=48.293 WAS REMOVED IAW AMM 20-30-01-201 NEW FITTING WAS DRILLED, TREATED, PAINTED AND INSTALLED IAW SRM SDR DALA2015072904743Finger Doubler · corrodedCORROSION ON INNER FINGER DOUBLER BETWEEN BS 1291 - 1295, LONGERONS 25 - 26L. THE FINGER DOUBLER WAS REPAIRED IAW SRM 51-30-2, 53-04, FIG 12E, 51-10-1, FIG 36 AND 51-10-3, PAR 14, 21.SDR DALA2015072904742Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 490 - 522, X -54 TO -60. THE CUSP WEB WAS REPLACED.SDR DALA2015072904739Longeron · corrodedCORROSION ON LONGERON 24L BS 1380 - 1385. THE LONGERON WAS REMOVED AND REPLACED IAW SRM 51-30-2, 51-30-5, SRM 51-10-4, SRM 51-10-3, PAR 14 AND 21, AND INSTALLED IAW SRM 51-30-2,51-30-5 SRM 51-30-5, AND SRM 53-02, FIG 18.SDR DALA2016111108827Skin · corrodedCORROSION ON LOWER INTERCOSTAL AT AFT LAVATORY SERVICE PANEL, BETWEEN BS 1322 TO 1338, LONGERONS 21 - 22L. THE INTERCOSTAL WAS REPLACED IAW SRM.SDR DALA2015072904738Door Frame · corrodedCORROSION ON LOWER DOOR FRAME. REPAIRED IAW SRM 53-05, FIG 123, SRM 51-10-3, PAR 14, 21, AND SRM 51-30-5.
Back to Mcdonnell Douglas MD-88