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 DALA2015120807450Access Panel · corrodedCORROSION AT SETTLEMENT AND COUNTERSKIN AREAS OF FUEL ACCESS PANEL 1409C. FUEL ACCESS 1409C WAS REPLACED IAW SRM 51-22-2A CONDITION II PARAGRAPH, B.SDR DALA2015120707433Hinge · damagedELONGATED HOLE ON FWD/AFT HINGE AT AFT CARGO COMPARTMENT DOOR. DAMAGED HOLE ON FWD HINGE WAS REPAIRED IAW ER/A 497387-14MA, REV B AND AFT HINGE WAS REPLACED FOR A NEW HINGE.SDR DALA2015120707432Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN AT AFT UPPER CORNER LT WINDOW BELT BETWEEN BS 693 AND 712. LIGHTNING STRIKE WAS REPAIRED AND DIMENTIONS AS FOLLOW: (UT) WAS ACCOMPLISHED IAW NDT-SPM 04-00-07, PARA 5, FIG. 5, ON AFT UPPER CORNER ORIGINAL THICKNESS 0.090 AND RSDR DALA2015120707431Skin · damagedTWO LIGHTNING STRIKES ON FUSELAGE SKIN AT AFT LOWER CORNER LT WINDOW BELT BETWEEN BS 617 AND 636. REPAIRED IAW ER/A 541573-14 REV ORIGINAL., UT WAS ACCOMPLISHED IAW NDT-SPM, 04-00-07, PAR. 5, FIG 3SDR DALA2015120707430Skin · damagedLIGHTNING STRIKES, 3 EAS, ON FUSELAGE SKIN AT FWD LOWER CORNER LT WINDOW BELT BETWEEN BS 636 AND 655. LIGHTNING STRIKES WERE REPAIRED AND DIMENTIONS AS FOLLOW : UT WAS ACCOMPLISHED IAW NDT-SPM 04-00-07, PARA 5, FIG 3, ON FWD LWR CORNER, ORIGINAL THICKNESS 0.0SDR DALA2015120707429Skin · damagedLIGHTNING STRIKES ON FUSELAGE SKIN AT FWD UPPER CORNER LT WINDOW BELT BETWEEN BS 655 AND 674. LIGHTNING STRIKES WERE REPAIRED AND DIMENTIONS AS FOLLOW: UT, WAS ACCOMPLISHED IAW NDT-SPM, 04-00-07, PARA 5, FIG 3, ON FWD UPPER CORNER ORIGINAL THICKNESS 0.135" ANSDR DALA2015120707426Skin · wornWORN PREVIOUS REPAIR FILLER ON FUSELAGE SKIN BETWEEN BS 1287-1309 AND LONGERONS 18R-19R. FILLER WAS REPLACED IAW SRM 51-30-5, 51-10-3, PAR 14 AND 21 AND 53-04-2, FIG 2.SDR DALA2015120707425Vane · wornWORN PREVIOUS REPAIR DOUBLER ON INBD VANE, OTBD FLAP AT RT WING. REPAIR DOUBLER INBD VANE, OTBD FLAP AT RT WING WAS REPLACED IAW A/C 0992, CARD 2000-8149-05.SDR DALA2015120707424Skin · crackedCRACK ON RT WING SLAT PANEL NR 2 INNER SKIN BS XOS 240, CARD 04, ZONE 12. CRACK ON INNER SKIN WAS ATTENDED IAW SRM 57-01, FIG 3, SHT 2.SDR DALA2015120707423Cargo Track · corrodedCORROSION ON CARGO TRACK, AROUND FASTENERS FROM BS 1003 TO 1155. THE CARGO TRACK WAS REPLACED IAW SRM 51-30-1 AND 51-30-2, 51-10-4, 51-10-3 PARS 14 AND 21 AND 38.SDR DALA2015120707435Wire · looseTHE CREW FOUND THE EMERGENCY LIGHTS INOPERATIVE BETWEEN SEAT ROWS 17 AND 23. MAINTENACE TROUBLESHOT AND FOUND AND RESECURED A LOOSE CONNECTION AT SEAT ROW 17DE.SDR DALA2015120707434Battery Pack · inoperativeTHE FLIGHT CREW FOUND INTERIOR OVERWING EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY OVERWING EVACUATION BATTERY PACK AND THE LIGHTS CHECKED OK.SDR DALA2015120707427Structure · damagedTWO FASTENERS IN THE FWD TAB ON EITHER SIDE OF THE CUT LINE OF LT APB LOWER CHORD. REPAIRED IAW ER/A 541560-14, REV ORIG.SDR DALA2015120607421Floor Panel · crackedCRACK ON FLOOR PANEL 1079A. FLOOR PANEL REPAIRED IAW SRM 51-70-1, PAR 10.SDR DALA2015120607420Cusp Web · crackedCUSP WEB CRACKED AT PREVIOUS REPAIR IN AFT CARGO RT SIDE BETWEEN BS 1136-1155. CUSP WEB REPAIR IAW SRM 51-30-2, 53-05, FIG 131A-1, 51-30-5.SDR WX0A2015120873028Light · inoperativeR1 OVERHEAD EMER LIGHT, ONE LIGHT INOPERATIVE. R & R BULB IAW AMM 33-53-00. OPERATIONS CHECKED GOOD.SDR DALA2015120607422Floor Support · crackedFLOOR SUPPORT CRACKED AT UPPER SUPPORT ANGLE BETWEEN CABIN FLOORBEAMS 1271-1287 LBL 5. THE FLOOR SUPPORT WAS REPAIRED IAW SRM 53-01 51-30-2 AND 51-30-5.SDR DALA2015120507394Floor Panel · crackedCRACK ON FLOOR PANEL. FLOOR PANEL WAS REPAIRED IAW SRM 51-70-1-D, PAR 10, AND SRM 53-05, FIG 131-B.SDR DALA2015120507392Support · crackedCRACKED SUPPORT ON AFT FACE FRAME, BS 1437, LONG 1 AT AFT ACCESSORY COMPARTMENT. SUPPORT WAS REPLACED IAW SRM 53-30-5, 51-10-3 AND DWG 9911840-115, REV DC.SDR DALA2015121807671Skin · damagedCREASE ON EDGE OF CUT OUT BS 1211 AND LONGERON PROJECTION 23 TO 24 RT. EDGE OF CUT OUT ON BS 1211 AND LONGERON PROJECTION 23 TO 24 RT WAS REPAIRED IAW SRM 53-05, FIG 155, OPTION 1.SDR WX0A2015120773027A/C Pack · malfunctionedSHORTLY AFTER TAKEOFF LAVATORY SMOKE ANNUNCIATOR WENT OFF & MASTER CAUTION LAVATORY SMOKE DETECTOR WAS AUDIBLE THROUGHOUT THE CABIN & FLIGHT DECK. FLIGHT ATTENDANTS REPORT AFT RT SMOKE DETECTOR GOING OFF & A GRAY HAZE BEGAN TO FILL CABIN & FLIGHT DECK WHICH DSDR DALA2015120507393Door Frame · crackedCRACK ON FWD INBD DOOR JAMB OF RT MLG. CHANNEL WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-4 AND DWG 5930584.SDR DALA2015120507391Duct · wornWEAR AT FUEL VENT DUCT, RT WING. EDGE OF CUTOUT ON Y=1211 AND LONGERON 23 TO 24 RT WAS REPAIRED IAW SRM 53-05, FIG 155, OPTION 1.SDR DALA2015120407385Structure · crackedCRACKED INNER PANE BETWEEN BEAM 5 AND AFT EDGE AT AFT CARGO COMPARTMENT DOOR, INNER PANE BETWEEN BEAM 5 AND AFT EDGE AT AFT CARGO COMPARTMENT DOOR, C3 WAS REPAIRED IAW SRM 52-03D, FIG 8 CRACK LENGTH, 1".SDR DALA2015120407384Access Panel · corrodedCORROSION AT SETTLEMENT AND COUNTERSINK AREAS OF FUEL ACCESS PANEL 2301C. FUEL ACCESS 2301C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015120407383Doubler · crackedCRACK DOUBLER BETWEEN BS 1463 - 1474 BETWEEN LONGERONS 1-2R. DOUBLER WAS REPLACED IAW DWG 5710228-298, REV KT AND WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 21, 14.SDR DALA2015120407382Skin · damagedDAMAGE METALIZER ON BOTH SIDE RUDDER,VHS, SM, CARD 10, ZONE 65. METALIZER ON BOTH SIDE RUDDER WAS REPAIRED IAW SRM 51-70-1AD.SDR DALA2015120407381Tab · damagedLIGHTNING STRIKE ON T/E AT RT ELEVATOR CONTROL TAB BETWEEN BS XET=26.178 TO XET=46.293, VHS, SM, CARD 24, ZONE 060. RT ELEVATOR CONTROL TAB WAS REPLACED IAW SRM 55-04 AND WILL BE INSTALLED UNDER CARD 2730-4832, JOB 001-0233.SDR DALA2015120407380Tab · delaminatedDELAMINATED ON LOWER SKIN AT LT ELEVATOR CONTROL TAB BTW STA XET=65 TO XET=46 AND XET=46 TO XET=26 (VHS) (SM) (CARD 3 ZONE 65). LH ELEVATOR CONTROL TAB WAS REPLACED IAW SRM 55-04 AND WILL BE INSTALLED UNDER CARD 2730-4334, JOB 001-0229.SDR DALA2015120407379Access Panel · corrodedCORROSION AT SETTLEMENT AND CONTERSINK AREAS OF FUEL ACCESS PANEL 1470C, AYP. CORROSION ON FUEL ACCESS PLATE 1470C WAS REMOVED IAW SRM 51-22-2A AND COUNTERSINK HOLES WERE MEASURED AND MAX DIAMETER ALLOWABLE IS 0.532" AND MAX DIAMETER MEASURED IS 0.535" THEREFOSDR DALA2015120407378Access Panel · corrodedCORROSION AT SETTLEMENT AND COUNTERSINK AREAS OF FUEL ACCESS PANEL 1454C, AYP. CORROSION ON FUEL ACCESS 1454C WAS REMOVED IAW SRM 51-22-2A, COUNTERSINK HOLES WERE MEASURED AND MAX DIAMETER ALLOWABLE IS 0.532" AND MAX DIAMETER IS .528". FOUND WITHIN LIMITS, SESDR DALA2015120407377Stop Fitting · crackedCRACKED STOP FITTING NR 2, 3, 4 AT AFT CARGO COMPARTMENT DOOR AFT EDGE, C3, SM. STOP FITTINGS NR 2, 3, 4 AT AFT CARGO DOOR, C3, WERE REPLACED IAW SRM 51-30-01.SDR DALA2015120307363Skin · dentedDENTS ON OUTER SKIN AT AFT CARGO COMPARTMENT DOOR. DENT WERE MEASURED IAW ERA 541545-14, REV ORIGINAL HFEC INSPECTION WAS ACCPOMPLISHED, NO CRACKS WERE FOUND IAW ERA 541545-14, REV ORIGINAL.SDR DALA2015120307362Cable · corrodedRUSTED TAIL CONE CONTROL CABLE NR 547, AT BS 1510. RUSTED TAIL CONE MECHANIC CONTROL CABLE NR 547, AT BS 1510 WAS REMOVED IAW AMM 20-10-17 AND NEW CONTROL CABLE PN 3913359-547 WAS INSTALLED IAW AMM 20-30-01 AND WILL BE ADJUSTED UNDER CARD 5350-01077-0101.SDR DALA2015120307359Stop Fitting · crackedCRACKED STOP FITTING NR 2 AND 5 AT MID CARGO COMPARTMENT DOOR FWD EDGE. CRACK STOP FITTING NR 2 AND 5 WERE REMOVED IAW SRM 51-30-2 AND 51-30-5, NEW FITTINGS WERE DRILLED, TREATED AND PAINTED IAW 51-10-4, 51-10-3, PAR 14 AND 21. NEW STOP FITTINGS WERE INSTALLSDR DALA2015120307358Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201 AND REPLACED FERRULES IAW AMM 53-20-01-201.SDR DALA2015120307357Pan · crackedCRACKED INNER PAN BELOW STOP FITTING NR 2 AT MID CARGO COMPARTMENT DOOR. DAMAGE INNER PAN BELOW STOP FITTING WAS REWORKED AND MEASURED TRIM TO REMOVE DAMAGE: 0.236" LONG, IT IS WITHIN LIMITS IAW SRM 52-03D, FIG 10.SDR DALA2015120307356Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 1235 - 1238, X 54-60 AT PAX CABIN. CUSP WEB WAS REPAIRED IAW SRM 51-30-1, SRM 51-30-5, SRM 53-05 FIG 131A-6, SRM 51-10-3 PAR 14 & 21, SRM 51-30-2.SDR DALA2015120307354Door Frame · crackedCRACK ON FWD OTBD DOOR JAMB OF RT MLG, W/W, SM. FWD OTBD DOOR JAMB WAS REPLACED IAW SRM 51-30-2. DIMENTION CRACK IS 2.875".SDR DALA2015120207320Battery Pack · inoperativeMAINTENANCE FOUND THE LT AND RT AFT OVERWING EXIT SIGNS INOPERATIVE. THE EMERGENCY LIGHT BATTERIES WERE REPLACED.SDR DALA2015120207319Connector · unsecureMAINTENANCE FOUND EMERGENCY LIGHTS INOPERATIVE BETWEEN ROWS 17 AND 23. A LOOSE CONNECTOR WAS SECURED AT ROW 16DEF AND LIGHTS CHECKED NORMAL.SDR DALA2015120307361Fairing · damagedDAMAGED METALIZER ON RUDDER FAIRINGS NR 6502G AND 6508G. METALLIZED ON RUDDER FAIRINGS NR 6502G AND 6508G WERE REPAIRED IAW SRM 51-70-1A, PAR 23.SDR DALA2015120307360Gusset · corrodedCORROSION ON GUSSET BETWEEN BS 1211-1219, LONGERONS 30-26R AT AFT CARGO COMPARTMENT. GUSSET WAS REPLACED IAW SRM 51-10-3, PAR 14, 21, 38, SRM 51-30-2, SRM 51-30-5.SDR DALA2015120207318Cusp Web · crackedCRACKED WEB ON RT CUSP WEB BETWEEN BS Y=1122-1138 AND X=-54 TO X=-60. CRACK ON WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-6, SRM 51-10-3, PAR 21 AND 14 AND SRM 51-30-2 AND 51-30-5.SDR DALA2015120207317Access Panel · corrodedCORROSION AT SETTLEMENT AND COUNTERSINK AREA OF FUEL ACCESS PANEL 1462C. FUEL ACCESS PANEL WAS REPLACED IAW SRM 51-22-2 AND IPC 57-30-00.SDR DALA2015120207316Access Panel · corrodedCORROSION AT SETTLEMENT AND COUNTERSINK AREAS OF FUEL ACCESS PANEL 1464C. ACCESS PANEL WAS FOUND OUT OF LIMITS IAW SRM 51-22-2A ACCESS WAS REPLACED AND WILL BE INSTALLED UNDER CARD 2800-0390, JOB 001-0454.SDR DALA2015120207315Access Panel · corrodedACCESS PANEL 1456C WAS FOUND CORRODED OUT OD LIMITS IAW SRM 51-22-2A. ACCESS PANEL WAS REPLACED AND WILL BE INSTALLED UNDER CARD 2800-0390, JOB 001-0454.SDR DALA2015120207314Bolt · damagedSCRATCHES OF LT UPPER ENGINE MOUNT BOLT. LT UPPER ENGINE MOUT BOLT WAS REPLACED IAW AMM 71-20-03.SDR DALA2015120207313Bolt · damagedSCRATCHES AT RT UPPER ENGINE MOUNT BOLT. RT UPPER ENGINE MOUNT BOLT WAS REPLACED IAW AMM 71-20-03.SDR DALA2015120207312Cusp Web · corrodedCORROSION OUT OF LIMITS ON LT CUSP WEB BS 524-536 AND 552 AT PAX CABIN. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-14, SRM 51-10-3, PAR 21 AND 14, SRM 51-30-2 AND 51-30-5 AND CIC WILL BE APPLIED WITH NRC 20000088777 CARD 17, ZONE 201.
Back to Mcdonnell Douglas MD-88