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 DALA2017071805519Indicator · malfunctionedFUELING PANEL QTY INDICATION INOPERATIVE. THE FUEL SPILL WAS DETERMINED TO BE A PROCEDURAL ERROR. MAINTENANCE PERFORMED AN OPERATIONAL TEST OF THE COCKPIT DISPLAY UNIT AND IT MATCHED THE LSDU, TESTED OK IAW AMM 28-40.SDR DALA2017070705268Wire Harness · damagedEMERGENCY LIGHT AT 35D INOPERATIVE. FOUND HARNESS DAMAGED. REPLACED HARNESS IAW AMM 33-53. OPS NORMAL.SDR DALA2017070705267Fuse · failedDURING SERVICE CHECK, EMERGENCY LIGHTS AT SEAT ROWS 24 TO 30 INOPERATIVE. TROUBLESHOT IAW WDM 33-51-14. FOUND A BAD FUSE F-2 AT THE B5-212 BATTERY PACK. REPLACED THE FUSE, OPS NORMAL.SDR DALA2017070605247Schrader Valve · leakingATB - AFTER TAKEOFF WITH THE GEAR HANDLE RAISED, THE NOSE GEAR DID NOT RETRACT. THE NOSE GEAR UNSAFE RED LIGHT ILLUMINATED ACCOMPANIED BY AN ASSOCIATED AIR NOISE. THE GEAR WAS CYCLED PER THE QRH WITH THE SAME RESULTS. THE CREW EXTENDED THE GEAR AND RETURNED TOSDR DALA2017070605246Cap · missingTHE FLIGHT CREW REPORTED HAZE AND SMOKE IN CABIN DURING CLIMB WITH BOTH AFT LAVATORY SMOKE DETECTORS SOUNDING. AN AIR TURN BACK TO DEPARTURE WAS ACCOMPLISHED. MAINTENANCE FOUND AN APU OIL LEAK WHICH RESULTED FROM THE CAP BEING LEFT OFF. THE APU WAS REPLACED DSDR DALA2017070605222Control Valve · failedAFTER TAKEOFF FELT VIBRATION AND OBSERVED RT MAIN GEAR RED LIGHT, GEAR HANDLE UP AND GEAR DOOR LIGHT ILLUMINATED. SLIGHT BURNING RUBBER ODOR. AUTO SPOILER FAIL LIGHT ILLUMINATED. RAN QRH FOR LDING GEAR UNSAFE. GEAR HANDLE AND TIRE FAILURE QRH. GEAR PINS INSDR DALA2017070505218Battery Pack · inoperativeFWD GALLEY OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACKS IAW AMM 33-50. OPS CHECKED GOOD.SDR DALA2017070505223Transmitter · failedDURING CLIMBOUT, A FAINT BURNING ODOR BECAME APPARENT THROUGHOUT THE COCKPIT AND CABIN. AUTO THROTTLES FAILED. NR 1 ENG EPR STUCK AT 1.53 REGARDLESS OF THROTTLE POSITION, EVEN AT SHUTDOWN. NO CIRCUIT BREAKERS TRIPPED. NO OTHER INDICATIONS. ALL OTHER ENG PASDR DALA2017070505220Cap · displacedON TAXI IN, CABIN BEGAN TO FILL WITH SMOKE. FOUND APU OIL CAP ON CROOKED AND OIL DRIPPING OUT OF APU INLET.SDR DALA2017070505219Firewall · wornNR 2 ENGINE FIREWALL PASS THRU WORN AT PREVIOUS REPAIR LOCATED AT HYD PRESS LINE. SAME AREA HYD PRESS LINE LOOSE. FOUND DOUBLER AT PASS THRU FOR HYD LINES WORN. REMOVED OLD DOUBLER AND BAD HYD LINE. INSTALLED NEW DOUBLER IAW ERA 553921-14 REV ORIG. REINSTSDR DALA2017070305173Wire · defectiveSEAT MOUNTED EMERGENCY LIGHTS AT 14D AND 28D INOP. REPLACED PIG TAIL AT 14D AND RETERMINATED CONNECTOR AT 28D PER AMM 33-52 AND EWIS. OPS CKS GOOD.SDR DALA2017070205172Slide · defectiveTAIL SLIDE PACK UNRAVELING, WON'T FIT INTO PACK COVER. TAILCONE SLIDE ASSY REPLACED PER OPN 2561-4001 JOB 000- 0004. SLIDE OFF 88-2561-9-0003 00821.SDR DALA2017122208797Flap Track · corrodedCORRODED FLAP TRACK MOUNT ATTACH HOLES. REPLACED THE FITTINGS WITH SERVICEABLE FITTINGS IAW CMM 27-50-01, REV 20.SDR DALA2017063005085Oxygen Mask · unwanted deployON NORMAL LANDING ALL OXYGEN MASK DOORS OPENED. INSPECTED AND REPACKED THE OXYGEN MASKS, NO PINS FIRED, SECURED ALL OXYGEN MASK DOORS CLOSED IAW AMM 35-02. VERIFIED SWITCH GUARDED AND SAFETIED. PERFORMED ADJUSTMENT TEST ON ANAROID SWITCH IAW AMM 35-21-02-201.SDR DALA2017063005083Fitting · brokenCREW REPORTED A RED LT MLG UNSAFE INDICATION WITH ASSOCIATED AMBER GEAR DOOR OPEN LIGHT AND AUTO-SPOILER FAIL EOAP MESSAGE AFTER GEAR RETRACTION. GEAR WAS EXTENDED AND CREW RECEIVED 3 GREEN DOWN AND LOCKED INDICATIONS WITH GEAR DOOR LIGHT EXTINGUISHED AND RETUSDR DALA2017062905084Fire Warning · false activationRIGHT ENGINE FIRE LOOP B LIGHT ILLUMINATED WITH OAP FIRE DETECTOR LOOP MESSAGE. IAW QRH, PERFORMED LOOP TEST ON SYSTEM A, TESTED NORMAL. COULD NOT DUPLICATE FAULT. TESTED SEVERAL TIMES AND LOOPS INDIVIDUALLY. NO HISTORY. ACFT OK FOR SERVICE.SDR DALA2017062805042Warning System · false activationDIV TO BHM DUE TO NO 2 ENGINE OIL STRAINER CLOGGED MESSAGE CAUSING ENGINE TO REMAIN AT IDLE. ENGINE WAS NOT SHUT DOWN. CONTRACT MAINTENANCE REMOVED FILTER AND CONFIRMED CLEAN. REMOVED FILTER AND FOUND CLEAN. REPLACED FILTER AND FORWARDED INDICATION TO MEL 79-0SDR DALA2017062805041Water Heater · defectiveAFT LT LAV SMOKE DETECTOR GOING OFF. R&R 3 SMOKE DETECTORS NO HELP 609925. R&R WATER HEATER PER AMM 38-14. PERFORMED DUCT BURNOUT AND REPLACED COALESCER BAGS.SDR DALA2017062805040Battery · dischargedFOUND SEVERAL EMERGENCY LIGHTS INOP. R&R BATTERYS IN POWER SUPPLY B5106 OPS OK PER AMM 33-50.SDR DALA2017062805039Door Frame · crackedCRACKED LOWER DOOR JAMB WEB STA Y=370 PROJECTION LONG 27R AT FWD CARGO COMPARTMENT. LOWER DOOR JAMB WEB STA Y=370 PROJECTION LONG 27R AT FWD CARGO COMPARTMENT WAS REPAIRED PER ER/A 558172-14AD REV ORIGINAL, SECTION I AND ETI-88-17-191 REV 3.SDR DALA2017062805038Doubler · crackedCRACKED PREVIOUS REPAIR ON FRAME STA Y=1485 CANT NEAR TO ACTUATOR. DOUBLER WAS FABRICATED AND REPLACED PER SRM 53-03 PAR 38 FIG 43 SHEET 3.SDR DALA2017081006121Skin · dentedOUTER SKIN DENTS. REPAIRED SKIN DENTS, REPLACED TORQUE TUBES, REPAIRED OUTER PAN DAMAGE, REPLACED SEAL, RESTORED PROTECTIVE FINISH, PERFORMED CSVE INSPECTION, REFERENCE CMM 52-30-1, REV 74. REPAIRED SKIN DENTS, REPLACED TORQUE TUBES, REPAIRED OUTER PAN DAMAGSDR DALA2017062705037Doubler · crackedCRACK WAS FOUND ON INTERNAL DOUBLER STA Y=198 BTW LONGS 17R TO 18R AT LOWER AFTER DOOR JAMB CORNER OF FWD SERVICE DOOR (R1). DOUBLER AND TRIPLER WERE FABRICATED PER SRM 53-05 PAR 168 FIG 178.SDR DALA2017062705036Doubler · crackedCRACKED REPAIR DOUBLER ON FWD ACCESSORY COMPARTMENT DOOR JAMB. AREA WAS REPAIRED PER ETI-88-17-194 REV 5 AND ER/A 559494-14 REV ORIGINAL.SDR DALA2017062604965Doubler · crackedA CRACK WAS FOUND ON INTERNAL DOUBLER BS 198 BETWEEN LONGERONS 17R TO 18R AT LOWER AFTER DOOR FRAME CORNER OF FWD SERVICE DOOR. REPAIRED IAW AMM 53-05, PAR 168, FIG, 178.SDR DALA2017062604970Wire · damagedACFT DIVERTED, DURING CLIMB OUT, PASSING THROUGH 26K, A STRONG ACRID ODOR BECAME APPARENT IN THE COCKPIT. FLIGHT ATTENDANTS REPORTED SAME ODOR IN CABIN. BEGAN DESCENT DIVERSION. AFTER APPROXIMATELY 1-1.5 MINUTES BOTH OIL TEMP HIGH LIGHTS ILLUMINATED. THROTTSDR DALA2017062604968Strut · corrodedCORROSION AT LOWER END OF NLG PISTON. REPLACED CYLINDER IAW WORKCARD 3221-6192.SDR DALA2017062604967Wire · disconnectedDUAL RED EMERGENCY LIGHTS AT ROW 24 INOPERATIVE. CONNECTED WIRES TO CONNECTOR. LIGHTS OPERATED NORMALLY IAW AMM 33-53.SDR DALA2017062604966Wire · disconnectedAISLE EMERGENCY LIGHT AT ROW 26 INOPERATIVE. RECONNECTED WIRES TO CONNECTOR. LIGHT OPERATES NORMALLY IAW AMM 33-53.SDR DALA2017062604958Inlet · contaminatedON TAXI OUT, THE AFT FLIGHT ATTENDANT REPORTED SMOKE & FUMES IN AFT CABIN. RETURNED TO GATE AND DEPLANED PASSENGERS. FOUND APU INLET CONTAMINATED WITH OIL.SDR DALA2017070505221Selector Switch · shortedSMOKE CAME FROM ROW 1DC LOWER WALL VENT. ON ACFT POWER UP. FOUND WATER QUANTITY MODE SELECTOR SWITCH SHORTED. REPLACED FILL VENT VALVE (M1-75). ALL CHECKED GOOD.SDR DALA2017062705010Wire · damagedDURING FLIGHT, A RT ENGINE FIRE LOOP MESSAGE DISPLAYED. FOLLOWED QRH, PUT INTO LOOP B. FWD RT ENGINE LOOP A. REPAIRED A DAMAGED WIRE.SDR DALA2017062604969Light · burned outWHILE PARKED AT GATE DURING BOARDING, CAPTAIN AND FIRST OFFICER SMELLED A HOT ELECTRICAL OR MELTING PLASTIC BURNING ODOR IN THE COCKPIT. PASSENGERS WERE DEPLANED. MAINTENANCE PERFORMED AMDS WC 2120-2367 WITH NO TROUBLE FOUND. DURING TROUBLESHOOTING, MAINTENASDR DALA2017062604957Cable · obstructedON APPROACH, THE GEAR HANDLE WOULD NOT MOVE MORE THAN ONE INCH OUT OF THE UP POSITION. PERFORMED QRH ALTERNATE GEAR EXTEND. GEAR PINS INSTALLED AFTER LANDING. FOUND INSULATION BLANKET TAPE JAMMED IN GEAR HANDLE CABLE & PULLEY BELOW COCKPIT FLOOR. REMOVED TAPESDR DALA2017062404962Cap · crackedCRACK ON OUTER CAP BS 1437, LONGERON 2R. THE CAP WAS REPAIRED IAW ER/A 558132-14, REV ORIG, AND ETI-88-17-170, REV 3.SDR DALA2017062404961Cap · crackedCRACKED INNER CAP BS 1437 LONGERON 2L AND 2R. THE INNER CAP WAS REPAIRED IAW ER/A 558132-14, REV.SDR DALA2017062404960Frame · crackedCRACKED FRAME BS 1485. THE FRAME WAS REPAIRED IAW ER/A 558162-14, REV ORIG, AND ETI-88-17-188, REV 2.SDR DALA2017062404959Frame · crackedCRACKED FRAME BS 1485. THE FRAME WAS REPAIRED IAW ER/A 558162-14, REV ORIG. AND ETI-88-17-188, REV 2.SDR DALA2017062304901Handset · shortedDURING CLIMBOUT AT APPROX 7500 FT, FLIGHT ATTENDANTS NOTIFIED COCKPIT OF AN ELECTRICAL ODOR WHICH DID DISAPATE. EXACT ORIGIN UNKNOWN BUT CONCENTRATED IN REAR OF AIRCRAFT. FOUND AFT F/A HANDSET HAD BEEN PINCHED AND WORN BY JUMPSEAT CAUSING BARE WIRES TO SHORT SDR DALA2017070805272Frame · crackedFRAME BS 1437 AT THE BULKHEAD UPPER & LOWER CAPS FOUND CRACKED. REPAIRED IAW ER/A 88-558132-14, SECTION II.SDR DALA2017062304900Fire Loop · malfunctionedFWD CARGO B LOOP FIRE WARNING STUCK ON. BREAKERS RESET. OPS CHECKED NORMAL. LOOPS "A" "B" "BOTH" ALL FUNCTION NORMAL. (LP# 3142068)SDR DALA2017062304898Doubler · crackedCRACKED FUSELAGE INTERNAL DOUBLER BS 1463. REPAIRED THE DOUBLER IAW ER/A 558149-14.SDR DALA2017062605034Step · corrodedCORROSION ON WEB OF STEP 5 AT VENTRAL STAIRWAY. WEB WAS FABRICATED AND REPLACED PER DWG 9915570 REV BW & SRM 51-30-5 & 51-30-2.SDR DALA2017062204888Frame · crackedCRACKED FRAME BS 1463. REPAIRED IAW SRM 53-03D, FIG 38A, 51-30-5, AND 51-30-2.SDR DALA2017062104858Anti-Ice Valve · failedLEFT ENGINE ANTI-ICE VALVE CIRCUIT BREAKER TRIPPED WITH ODOR AND SMALL AMOUNT OF SMOKE. DISCONNECTED THE VALVES FROM B1-43, MEGGED WIRES FROM B1-43 TO PL809. ALL GOOD IAW WDM 75-11-00. REPLACED THE CIRCUIT BREAKER B1-43. FOUND COWL ANTI ICE VALVE BAD.SDR DALA2017062104857Light · illuminatedGEAR DOOR OPEN LIGHT ILLUMINATED IN CRUISE. PER QRH, ALTERNATE GEAR EXTEND USED FOR LANDING. REPLACED L1-122 MAIN GEAR OPEN LIGHT ASSEMBLY. JACKED A/C AND COMPLETED MULTIPLE GEAR SWINGS WHILE COMPLYING WITH POSITION AND WARNING INDICATION TEST. POSITIVE RESULTSDR DALA2017061804798Battery · dischargedON SVC CK FOUND OVERHEAD EMERGENCY LIGHTS INOP ROW 17-21. REPLACED EMER LIGHT BATTERIES AT ROW 17 OPS CHECK GOOD.SDR DALA2017061804800Battery Pack · dischargedTAIL CONE ESCAPE LIGHTS INOP. REPLACED BATTERY PACKS IAW AMM 33-53.SDR DALA2017061804799Light · inoperativeEMERGENCY LIGHTS ON CATWALK INOP. RELAMPED LIGHT ASSY 2EA. LOCATIONS, CATWALK PER AMM 33-52. CHECKS OK.SDR DALA2017061804797Support · corrodedCORROSION ON TEE BTW STA Y=1401 TO Y=1425 AT LONG 25L. REPAIRED PER ETI-88-17-183 REV 1 AND ER/A 558154-14.
Back to Mcdonnell Douglas MD-88