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 DALA2016033002423Structure · corrodedCORROSION ON RT, LT ELEVATOR SECTOR. LT ELEVATOR SECTOR WAS REPLACED UNDER CARD 2730-4234, JOB 001-0357 AND RT ELEVATOR SECTOR WAS REPLACED AND IS INSTALLED UNDER CARD 2730-4234, JOB 001-0357.SDR DALA2016033002422Hinge · damagedELONGATED HOLES ON FWD, AFT HINGES AT FWD CARGO COMPARTMENT. HINGES WERE REMOVED IAW AMM 52-31-02. FWD/AFT HINGES WERE REPAIRED IAW ER/A 497387-14MA, REV B. HINGES WERE INSTALLED IAW AMM 52-31-02.SDR DALA2016033002420Structure · not reportedPRESSURE DOME LOWER CHARD SPLICE FOUND BETWEEN LONGERON 26, 27 RT/LT IN DISCREPANCY TO INSPECTION CARD 5310-01414-1701 AT AFT CARGO COMPARTMENT. AREA WAS REPAIRED IAW ER/A 593209-14, REV ORIGINAL AND ETI 88-16-114, REV 1.SDR DALA2016033002473Attach Fitting · crackedSPOILER DEPLOYED MESSAGE. FOUND NR 2 SPOILER ON RT WING INBD ATTACH FITTING CRACKED. SPOILER MOVING AWAY FROM SENSOR WHEN RETRACTED. REPLACED ATTACH FITTING IAW CMM 27-61-10.SDR DALA2016032902418Light · damagedTHE FLIGHT CREW FOUND EMERGENCY LIGHTS DAMAGED. MAINTENANCE RESECURED THE EMERGENCY EXIT LIGHT AT DOOR R1 AND THE FORWARD EMERGENCY EXIT FLOOR LIGHT IN THE G2 GALLEY.SDR DALA2016032902415Strap · corrodedCORROSION ON STRAP JUST ABOVE FINGER DOUBLER PRODUCTION BETWEEN LONGERON 26 LT AND 25 LT BS 1307 TO BS 1287 AT AFT CARGO COMPARTMENT. FASTENER WAS REMOVED, DAMAGE ON BS 1276 TO BS 1294 WAS REMOVED. NEW SECTION FINGER DOUBLER WAS FABRICATED, DRILLING AND ADJSDR DALA2016032902414Longeron · crackedCRACKED LONGERON 12R, BS 1431 CANT AT AFT COMPARTMENT. THE LONGERON WAS REPAIRED IAW ER/A 543219-14, REV ORIG AND ETI-88-16-125, REV 1.SDR DALA2016032902413Frame · crackedCRACK UPPER FRAME CUP, BS 1463, LONG 18LT AT AFT ACCESSORY COMPARTMENT. FRAME WAS REPAIRED IAW SRM 53-01, FIG 2, 51-01, 53-14-4, FIG 3, 51-30-2, 51-30-5.SDR DALA2016032902412Vane · wornWORN OTBD FLAP INBD VANE L/E AT LT WING. REPAIRED IAW SRM 57-03D, PAR 11.SDR DALA2016032902411Skin · dentedDENT ON LOWER SKIN OF RT GEARED TAB AT HORIZONTAL STABILIZER. LOWER SKIN OF RT GEARED TAB AT HORIZONTAL STABILIZER WAS REPAIRED IAW SRM AND 1031 CARD 2000-8149-04.SDR DALA2016032902410Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOORS PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016032902409Bracket · wornWEAR ON RT HORIZONTAL STABILIZER FWD SPAR ANTI-FLOAT TAB BRACKET. ANTI-FLOAT TAB BRACKET AT FWD SPAR ON RT HORIZONTAL STABILIZER WAS REPLACED IAW AMM 20-30-01.SDR DALA2016032902408Rod End · wornFREE PLAY ON ROD END OF ANTI-FLOAT TAB PUSH ROD AT LT ELEVATOR. ANTI-FLOAT TAB PUSH ROD ASSY AT LT ELEVATOR WAS REPLACED IAW AMM 27-30-14 AND STEP 5B AT AMM 27-30-14 WILL BE PERFORMED WITH CARD 2730-4831, JOB 001-0231 AND FREE PLAY WAS CORRECTED.SDR DALA2016032902407Fairing · crackedCRACKED GEARED TAP FIXED FAIRING ON BS XET=89 AT RT ELEVATOR. FAIRING WAS REPAIRED IAW SRM 51-30-2, 51-30-8, 51-10-3, PAR 14 AND 21 AND 55-01, FIG 2, SHEET 2.SDR DALA2016032902406Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN LONG 26RT AND 27LT, BS 788 TO BS 769 AT MID CARGO COMP. DUE TO EXCESIVE CORROSION INSTERCOSTAL WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-3 PAR 14 ,21 DWG 9915554, REV: J.SDR DALA2016032802382Battery Pack · inoperativeTHE CREW FOUND THAT CABIN EMERGENCY ESCAPE LIGHTS WOULD NOT TEST. MAINTENANCE REPLACED THE BATTERY PACK AND THE LIGHTS CHECKED OK.SDR DALA2016032802381Fuse · failedMAINTENANCE FOUND THE AFT SECTION EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY CHARGER FUSE AND THE LIGHTS OPERATED OK.SDR DALA2016040802709Skin · not reportedRUDDER FLAME SPRAY BAD. REPLACED RUDDER IAW WC 2720-4187.SDR DALA2016032802417Ground Stud · looseTHE CREW OF FLIGHT 1302 FOUND THAT THE L2 DOOR EMERGENCY LIGHTS WILL NOT WORK WHEN TESTED. MAINTENANCE FOUND A GROUND STUD CONNECTION FOR THE BATTERY PACK LOOSE AND RETORQUED IT AND ALSO REPLACED THE BATTERY PACK POWER SUPPLY. LIGHT CHECKED OK.SDR DALA2016032802375Frame · corrodedCORROSION FOUND OUT OF LIMITS AT FRAME ANGLE ON BS 1287. FRAME ANGLE BETWEEN LONGERONS 26L-26R WAS R & R IAW SRM 53-14-3 AND 51-30-2 AND 51-10-3 PAR 21 AND 14; 51-30-5.SDR DALA2016032802373Frame · wornWEAR ON FRAME, BS 1338 AREA APU COMPARTMENT ATA FT ACCESSORY COMPARTMENT. FRAME WAS REPAIRED IAW ER/A 094719-14MA, REV A.SDR DALA2016032802371Intercostal · corrodedCORROSION ON INTERCOSTAL JUST ABOVE LONGERON 29L BS 1212 - 1231 IN AFT CARGO COMPARTMENT. INTERCOSTAL WAS REPLACED IAW SRM 53-14-3, 51-30-2, 51-30-5, 51-10-2, 51-10-4, 51-10-3 PAR 21, 14 AND 38.SDR DALA2016032802370Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016032802369Cusp Web · crackedCRACKED LT CUSP WEB BETWEEN X=44-X=54, BETWEEN BS 1212 TO 1231. REMOVE DAMAGE AND DOUBLER WAS FABRICATED IAW SRM 53-05, FIG 131A-1, 51-30-2, 51-10-3, PAR 38.SDR DALA2016032802368Skin · damagedFUSELAGE EXTERIOR SKIN DOUBLER/TRIPLER REPAIR DAMAGED AT FORWARD END JUST AFT OF C3 DOOR CUTOUT AT BS 1211. DOUBLER AND TRIPLER WERE REPLACED IAW ER/A 271897-14 REV C STEP 4, 8, 9 AND SRM 51-10-3, 5130-5, 51-10-2, PERMANENT REPAIR: REQUIREMENT REPAIR APPROVAL SDR DALA2016032802367Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016032802366Skin · corrodedCORROSION ON LT BARREL NUT NR 24 AT LT UPPER SURFACE OF HORIZONTAL STABILIZER REF CARD 12, ZONE 60. DUE TO EXCESSIVE CORROSION ON BARREL NUT PANEL WAS REPLACED IAW DWG 5922575, REV DA AND ER/A 543203-14, REV ORIGINAL.SDR DALA2016032802365Skin · damagedEXPOSED MATERIAL AND DAMAGE COAT PAIN ON RUDDER ACCESS NR 6502G, 6508G, 6513G. EXPOSED MATERIAL AND DAMAGE COAT PAIN ON RUDDER ACCESS NBR 6502G, 6508G, 6513G WERE REPAIRED IAW SRM 51-70-1A, PAR 23.SDR DALA2016032802364Access Panel · corrodedCORROSION ON 4 INNER HOLES AT LT LOWER ACCESS DOOR CUTOUT XRS=189 TO 214. HOLES ON LOWER ACCESS DOOR CUTOUT WERE REPAIRED IAW ER/A 543204-14AD REV ORIGINAL SECTION I: PERMANENT REPAIR ER/A APPROVAL IS LIMITED TO 67,000 TOTAL CYCLES ONLY IAW ER/A 543204-14AD, SDR DALA2016032802363Access Panel · corrodedCORROSION ON 14 INNER HOLE AT RT LOWER ACCESS DOOR CUTOUT BETWEEN XRS 189 TO 214. HOLES ON LWR ACCESS DOOR CUTOUT WERE REPAIRED IAW ER/A 543204-14AD, REV ORIGINAL SECTION I: PERMANENT REPAIR ER/A APPROVAL IS LIMITED TO 67,000 TOTAL CYCLES ONLY IAW ER/A 543204SDR DALA2016032802362Spar Cap · corrodedCORROSION WAS FOUND ON THE 3 FASTENER HOLES OF THE HORIZONTAL STABILIZER REAR LT UPPER SPAR CAP. FASTENER HOLES WERE REPAIRED IAW ER/A 543184-14AD, REV ORIGINAL AND ETI 88-16-095, REV 7.SDR DALA2016032802380Duct · crackedCRACKS ON RAM AIR DUCT. CRACKS ON RAM AIR "Y" DUCT WERE REPAIRED, WELDED IAW ER/A 503276-14MA, REV C AND AREA WAS TREATED AND PAINTED IAW ER/A 503276-14MA, REV C AND SOPM 20-60-1.SDR DALA2016032802379Pin · gougedTHE TAILCONE RELEASE OPS CHECK FAILED. MSP MAINTENANCE FOUND A T-PIN GOUGED AND REPLACED IT.SDR DALA2016032802378Pin · gougedON SHIP 945, MSP MAINTENANCE FOUND THE UPPER LT TAIL CONE RELEASE LOCK PIN GOUGED. THE LOCK PIN WAS REPLACED BY MSP MAINTENANCE.SDR DALA2016032802374Former · crackedCRACK ON CANTED FORMER BS 1510, 10:00, O' CLOCK POSITION AT AFT ACCESSORY COMPARTMENT. FRAME, BS 1510 WAS REPLACED IAW DWG 9911843, REV: AC AND SRM 51-30-2.SDR DALA2016032702361Doubler · wornWORN REPAIR DOUBLER ON OTBD FLAP MID VANE BS XVZ=254 AT LT WING. OTBD FLAP MID VANE BS XVZ= 254 AT LT WING WAS REPAIRED IAW SRM 57-03D PAR.SDR DALA2016032702359Intercostal · crackedCRACK ON INTERCOSTAL X=58, BS 937 AT AREA HYD GROUND SERVICEABLE ACCESS W/W. CRACKED INTERCOSTAL X=58, 937 RT AT AREA HYD GROUND SERVICEABLE ACCESS W/W WAS REPLACED IAW DWG 5930584-57, REV BY AND SRM 51-30-2 AND 51-30-5.SDR DALA2016032702358Skin · damagedLIGHTNING STRIKE ON WINDOW FRAME BETWEEN BS 750 TO 769 AND LONGERONS 12RT TO 13RT. REWORKED AREAS WERE MEASURED, UT WAS ACCOMPLISHED IAW NDT SPM 04-00-07, PAR 5, FIG 3, SHEET 1 AND 2. BLEND OUTS ON ZONE CRITICAL, THE ORIGINAL THICKNESS ON BLEND OUT 1 IS .086"SDR DALA2016032702356Access Panel · corrodedCORROSION ON RT WING FUEL ACCESS 1410C COUNTERSINK HOLES, 5 E/A. CORROSION ON COUNTERSINK HOLES AT FUEL ACCESS 1410C WAS REMOVED, COUNTERSINK HOLES WERE MEASURED ELONGATION CONTINUED THEREFORE IT IS OUT OF LIMITS THEN FUEL ACCESS PLATE WAS REPLACED IAW SRM 51SDR DALA2016032702355Channel · crackedCRACK ON FWD CHANNEL BS 937 X=4 BETWEEN LT/RT MLG WW. CRACKS ON FWD CHANNELS WERE REPAIRED IAW SRM 53-05D, FIG 821D.SDR DALA2016032702354Floor Panel · puncturedPUNCTURED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016040502657Skin · damagedDELAMINATED OTBD FLAP MID VANE LOWER SURFACE BS XVZ=220 AT RT WING. DAMAGE TO THE INTERNAL STRUCTURE OF THE MID VANE OF THE RT WING FLAP ARE OUT OF LIMITS BY CORROSION FOR REPLACE AND REPAIR. OTBD FLAP MID VANE AT RT WING WAS REPLACED IAW SRM 57-50-14, FIG 2SDR DALA2016032802405Skin · damagedFLAME SPRAY EXPOSED AND FLAKING ON RUDDER. RUDDER REMOVED ON AMDS CARD 2720-4187. INSTALLED RUDDER, PN 5955501-501, SN F137 IAW AMDS 2720-4421.SDR DALA2016032502384Battery Pack · inoperativeTHE CREW FOUND THE AFT LT AND RT OVERWING EXIT SIGNS INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY BATTERIES AND THE LIGHTS CHECKED OK.SDR DALA2016032802376Hinge · wornFREE PLAY ON FWD/AFT HINGE AT FWD CARGO COMPARTMENT. HINGE AFT AT FWD CARGO DOOR WERE REPAIRED AND FWD HINGE HARDWARE WERE REPLACED AND FREE PLAY WAS CORRECTLY IAW AMM 52-31-02 AND ER/A 497387-14MA, REV B.SDR DALA2016032702357Skin · damagedLIGHTING STRINKE ON LOWER WINDOW FRAME, BS 1100 RT SIDE. REWORKED AREAS WERE MEASURED, UT WAS ACCOMPLISHED IAW NDT SPM 04-00-07, PAR 5, FIG 3, SHEET 1 AND 2. BLEND OUT ON ZONE CRITICAL, 1 THE ORIGINAL THICKNESS IS .084" AND REMAINING THICKNESS .080", THE ORISDR DALA2016032702353Skin · damagedLIGHTNING STRIKES ON WINDOW FRAME BETWEEN BS 731 TO BS 750 AND LONGERONS 12 RT TO 13 RT. REWORKED AREAS WERE MEASURED (UT) WAS ACCOMPLISHED IAW NDT SPM 04-00-07, PARAGRAPH 5, FIG 3, SHEET 1 AND 2. BLEND OUT ON ZONE CRITICAL, 1 IS .090" AND REMAINING THICKNESSDR DALA2016032702352Skin · damagedLIGHTNING STRIKES, FOUR ON WINDOW FRAME BETWEEN BS 674 TO 693 AND LONGERONS 14TO 15R. MEASURE REWORKED AREAS, UT) WAS ACCOMPLISHED IAW DC/MD NDT SPM 04-00-07 PAR 5, FIG 3, SHEET 1 AND 2. BLEND OUT ON ZONE CRITICAL BLEND OUT, 2 THE ORIGINAL THICKNESS ES .120 SDR DALA2016032602312Vane · delaminatedDELAMINATED INBD FLAP OTBD VANE XOVIF=68 BELOW RUB STRIP, ON LT WING. VANE REPAIRED IAW SRM 57-03D, PAR II.SDR DALA2016032602309Skin · dentedSEVERAL DENTS ON LOWER SKIN, BELOW OF REPAIR DOUBLER OF LT WING OTBD FLAP INBD GUIDE VANE. LOWER SKIN OF LT WING OTBD FLAP INBD GUIDE VANE WAS REPAITED IAW SRM 57-03D, PAR II.
Back to Mcdonnell Douglas MD-88