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 DALA2016040402511Line · looseSTRONG JET FUEL ODOR IN AIRPLANE AFTER STARTING APU GROUND PERSONEL POINTED OUT FUEL FROM LT SIDE OF ACFT. FOUND RT WHEEL WELL UPPER AFT FUEL LINE IN SHROUD UNSAFTIED AND LOOSE. RESECURED LINE IAW AMM 28-20. REINST SHROUD IAW AMM 28-20.SDR DALA2016040402507Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1303C AND 1409C. FUEL ACCESS PLATE NR 1303C AND 1409C WERE REPLACED IAW SRM 51-22-2A, CONDTION III.SDR DALA2016040402506Channel · crackedCRACKS ON PREVIOUS REPAIR AND CHANNEL FLOOR PANEL 927E. FLOOR PANEL 927E WAS REPLACED IAW SRM 51-10-4 AND 51-10-3, PAR 21 AND 14.SDR DALA2016040302518Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1414C AT RT WING. ACCESS PLATE WAS REPLACED.SDR DALA2016040302517Skin · damagedSCRATCH ON WINDOW BELT BETWEEN BS 1003-1022 AT RT EXTERNAL FUSELAGE. WINDOW BELT WAS REPAIRED IAW ER/A 543202-14, REV.SDR DALA2016040302516Cargo Track · corrodedCORROSION ON LT CARGO TRACK BETWEEN BS 1320 - 1218 IN AFT CARGO COMPARTMENT. CARGO TRACK WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016040302515Cargo Track · corrodedCORROSION ON RT CARGO TRACK BETWEEN BS 1212 - 1320 IN AFT CARGO COMPARTMENT. CARGO TRACK WAS REPLACED IAW SRM 51-30-1 AND 51-30-2.SDR DALA2016040302505Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1414C AT RT WING. ACCESS PLATE WAS REPLACED.SDR DALA2016040302504Skin · damagedSCRATCH ON WINDOW BELT BETWEEN BS 1003-1022 AT RT EXTERNAL FUSELAGE. WINDOW BELT WAS REPAIRED IAW ER/A 543202-14, REV.SDR DALA2016040302503Cargo Track · corrodedCORROSION ON LT CARGO TRACK BETWEEN BS 1320 - 1218 IN AFT CARGO COMPARTMENT. CARGO TRACK WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016040302502Cargo Track · corrodedCORROSION ON RT CARGO TRACK BETWEEN BS 1212 - 1320. CARGO TRACK WAS REPLACED IAW SRM 51-30-1 AND 51-30-2.SDR DALA2016040502651Cable · frayedMSP MAINTENANCE FOUND THE KEVLAR CABLE FOR THE TAILCONE EMERGENCY ESCAPE SLIDE FRAYED. THE CABLE WAS REPLACED.SDR DALA2016040502650Wire · brokenEXIT PATH EMERGENCY LIGHTS ROW 24-30 AND OVER WING EXIT LIGHTS INOPERATIVE. WIRE BROKEN AT SIDEWALL VENT ROW 28R. REPAIRED IAW WDM 33-51-14.SDR DALA2016040502649Battery Pack · inoperativeFIRST CLASS CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5-100.SDR DALA2016040402522Skin · damagedLIGHTNING STRIKE ON LT FUSELAGE SKIN. WINDOW BENT AFT LOWER CORNER BETWEEN BS 750 TO 769 . AREA WAS REPAIRED IAW ER/A 545088-14, REV ORIGINAL AND ETI -88-16-107. RII INSPECTION WAS VERIFIED.SDR DALA2016040402521Skin · corrodedCORROSION ON BARREL NUT HOLE NR 26 AT LT HORIZONTAL ESTABILIZER UPPER SKIN BS XH=27.2. REPAIR WAS PERFORMED IAW ER/A 543212-14 REV ORIGINAL.SDR DALA2016040202514Access Panel · corrodedCORROSION ON RT WING FUEL ACCESS 1470C COUNTERSINK HOLES. FUEL ACCESS PLATE 1470C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016040202513Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1357C AT LT WING. COUNTERSINK HOLES ON ACCESS PLATE 1357C AT LT WING REMOVED, COUNTERSINK HOLES WERE MEASSURED, MAX DIAMETER ALLOWABLE IN 8 HOLES IS 0.532 IN AND MAX DIAMETER MEASURED SDR DALA2016040202512Skin · damagedLIGHTNING STRIKE ON LT FUSELAGE SKIN WINDOW BELT FWD LOWER CORNER BETWEEN BS 769 - 788. AREA WAS REPAIRED IAW ER/A 545088-14, REV ORIGINAL AND ETI-88-16-107, REV 3.SDR DALA2016040402509Skin · damagedLIGHTNING STRIKE ON LT FUSELAGE SKIN. WINDOW BENT AFT LWR CORNER BETWEEN BS 750 TO BS 769. AREA WAS REPAIRED IAW ER/A 545088-14, REV ORIGINAL AND ETI -88-16-107. RII INSPECTION WAS VERIFIED.SDR DALA2016040402508Skin · corrodedCORROSION ON BARREL NUT HOLE NR 26 AT LT HORIZONTAL ESTABILIZER UPPER SKIN BS XH=27.2. REPAIR WAS PERFORMED IAW ER/A 543212-14, REV ORIGINAL.SDR DALA2016040202501Access Panel · corrodedCORROSION ON RT WING FUEL ACCESS 1470C COUNTERSINK HOLES. FUEL ACCESS PLATE 1470C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016040202500Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OFFUEL ACCESS PLATE NR 1357C AT LT WING. COUNTERSINK HOLES ON ACCESS PLATE 1357C AT LT WING REMOVED, COUNTERSINK HOLES WERE MEASURED, MAX DIAMETER ALLOWABLE IN 8 HOLES IS 0.532 IN AND MAX DIAMETER MEASSURED ISDR DALA2016040202499Skin · damagedLIGHTNING STRIKE ON LT FUSELAGE SKIN WINDOW BELT FWD LOWER CORNER BETWEEN BS 769 TO 788. AREA WAS REPAIRED IAW ER/A 545088-14, REV ORIG AND ETI-88-16-107, REV 3.SDR DALA2016040102491Repair · crackedWHILE IN C-CHECK, MAINTENANCE DISCOVERED THAT PREVIOUS REPAIRS TO THE LT AND RT AFT NOSE GEAR DOOR HINGE CUTOUTS WERE CRACKING. PREVIOUSLY, THE SRM AUTHORIZED A REPAIR USING A 0.050 THICK DOUBLER TO REPAIR 0.063" SKIN; THIS REPAIR HAS SINCE BEEN SUPERSEDED BSDR DALA2016033102490Vane · delaminatedDELAMINATED LOWER/UPPER FACE, LEFT SIDE PREVIOUSLY REPAIRED AT OTBD VANE/INBD FLAP LT WING. OTBD VANE, INBD FLAP LT WING WAS REPLACED IAW SRM 57-04, PAR 2.SDR DALA2016033102489Channel · crackedCRACKED CHANNEL ON FLOOR PANEL 927E. FLOOR PANEL WAS REPAIRED IAW SRM 53-05, PAR 145.SDR DALA2016033102488Channel · crackedCRACK ON CHANNEL, AFT SIDE AT FLOOR PANEL 1003A. FLOOR PANEL WAS REPAIRED IAW SRM 53-05, PAR 145.SDR DALA2016033102487Channel · crackedCRACK ON CHANNEL AT FLOOR PANEL 1003F. FLOOR PANEL WAS REPAIRED IAW SRM 53-05, AR 145.SDR DALA2016033102486Frame · corrodedCORROSION OUT OF LIMITS ON FRAME BS 1307 BETWEEN LONGERON 29 LT AND 29 RT AT C3. THE FRAME WAS REPAIRED IAW SRM 53-03, FIG 2A.SDR DALA2016033102472Battery Pack · inoperativeTHE FLIGHT CREW FOUND THAT THE EMERGENCY LIGHTS WOULD NOT ILLUMINATE WHEN TESTED. MAINTENANCE REPLACED EMERGENCY LIGHT BATTEY PACKS AND THE LIGHTS CHECKED OK.SDR DALA2016033102471Hinge · damagedELONGATED HOLES ON FWD/AFT HINGES AT MID CARGO COMPARTMENT DOOR. FWD/AFT HINGES WERE REMOVED IAW AMM 52-31-02. FWD/AFT HINGES WERE REPAIRED IAW ER/A 10-521061-14MA REV. ORIGINAL. HINGES WERE INSTALLED IAW AMM 52-31-02.SDR DALA2016033102470Angle · crackedCRACK ON ANGLE BS 1485 AT THE TWO O`CLOCK POSITION AT AFT ACCESORY COMPARTMENT. THE ANGLE FABRICATED AND REPLACED IAW DGW 9911842, REV DH AND SRM 51-30-2 AND 51-30-5.SDR DALA2016033102469Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1472C AT RT WING. ACCESS PLATE WAS REPLACED.SDR DALA2016033102467Access Panel · unknownINAPPROPRIATE FUEL ACCESS PANEL AT POSITION 1414C RT WING. FUEL ACCESS DOOR 1414C WAS REPLACED IAW AMM 28-00-00.SDR DALA2016033102466Intercostal · corrodedCORROSION ON INTERCOSTAL JUST UNDER RT CARGO TRACK BETWEEN BS 1307 - 1322 IN AFT CARGO COMPARTMENT. INTERCOSTAL WAS REPLACED IAW SRM 51-30-2.SDR DALA2016033102465Ferrule · damagedDAMAGED FERRULE ON FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016033102464Support Fitting · gougedDURING MAINTENANCE ACTIVITIES WAS FOUND A GOUGE AT RT MLG SUPPORT FITTING BEARING BORE. THE REPAIR WAS PERFORMED IAW ER/A 543217-14AD, REV A.SDR DALA2016033102463Channel · crackedCRACKED CHANNELS ON FLOOR PANEL. THE NEW CHANNEL INSTALLED IAW SRM 51-30-1, SRM 51-10-4, SRM 51-10-3, PAR 14 - 21, AND DWG 9936639, REV P.SDR DALA2016033102462Intercostal · crackedCRACK ON INTERCOSTAL, X=58, BS 937 AT AREA HYD. GROUND SERVICING ACCESS W/W, SIDE LT. INTERCOSTAL WAS REPLACED IAW DWG 5930584, REV BY SRM 53-14-3, 51-30-5 AND 51-30-2.SDR DALA2016033102461Access Panel · corrodedCORROSION ON RT WING FUEL ACCESS 1476C COUNTERSINK HOLES, 2 EA. ACCESS PLATE NR 1476C WAS REPLACED UNDER CONDITION III IAW SRM 51-22-2A.SDR DALA2016033102460Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1363C. ACCESS PLATE NR 1363C WAS REPLACED UNDER CONDITION III IAW SRM 51-22-2A.SDR DALA2016033102459Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1335C AT LT WING. ACCESS PLATE NR 1335C WAS REPLACED UNDER CONDITION III IAW SRM 51-22-2A.SDR DALA2016033102458Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1311C AT LT WING. ACCESS PLATE NR 1311C WAS REPLACED UNDER CONDITION III IAW SRM 51-22-2A.SDR DALA2016033102457Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1365C AT LT WING. ACCESS PLATE NR 1365C WAS REPLACED UNDER CONDITION III IAW SRM 51-22-2A.SDR DALA2016033102456Vane · delaminatedDELAMINATED LOWER/UPPER FACE LT SIDE PREVIOUSLY REPAIR AT OTBD VANE, INBD FLAP LT WING IN REF CARD 62, ZONE 10. OTBD VANE, INBD FLAP LT WING WAS REPLACED IAW SRM 57-04 PAR 2.SDR DALA2016033002455Pin · disengagedMAINTENANCE FOUND THAT THE L1 DOOR EMERGENCY SLIDE HAD A PARACHUTE PIN DISENGAGED. THE L1 EMERGENCY ESCAPE SLIDE WAS REPLACED.SDR DALA2016033002421Skin · corrodedCORROSION DAMAGE ON SKIN AT BS 588 BETWEEN L30 AND L29. DUE PRI 545426-14, REV 6. DUE ERA 545426-14, REV ORIGINAL SECTION I PERM REPAIR. C/W PRI 545426-14, REV 6, 116607. C/W ERA 545426-14 REV ORIGINAL SECTION I PERM REPAIR. COMPARED PRI 545426-14, REV 6 SDR DALA2016033002425Skin · damagedON WALK AROUND FOUND A BLISTER ON BOTTOM OF FUSELAGE AT APPROXIMATELY 580. THE SKIN IS ALSO CRACKED BETWEEN 2 RIVET HOLES. C/W REPAIR ON ERA 545426-14, REV ORIG, SECT. I, PERM REPAIR. COMPARED PRI 545426-14, REV 6 TO ERA 545426-14, ORIG, NO DIFFERENCES FOUNDSDR DALA2016033002424Structure · damagedTOP OF FLAP DAMAGE FROM SPOILER MOVEMENT. R & R RT OTBD FLAP INBD FLAP VANE IAW AMM 27-51. OPS CK GOOD.
Back to Mcdonnell Douglas MD-88