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 WX0A201803073311Light · defectiveFA NOTICED SMOKE SMELL IN GALLEY AND ISOLATED SMOKE TO THE LIGHT ABOVE OVEN. LIGHT WAS TURNED OFF AND SMOKE DISSIPATED/PERFORMED CABIN SMOKE T/S IAW WORK CARD. DETERMINED THAT IT WAS FROM GALLEY LIGHT OVER OVEN. PLACED LIGHT ON MEL.SDR DALA2018022801283Skin Panel · debondedLT WING UPPER PANEL FWD OF AILERON HAS AREA OF DISBOND BULGING MARKED. REPLACED PANEL ASSY REF BACDWG 5910515-507 INSTALL.SDR DALA2018022701255Skin · corrodedWALK AROUND FOUND CORROSION ON BELLY SKIN APPROX 7 FT AFT OF C2 CARGO DOOR RT OF CNT LINE AT SKIN SPLICE. VERIFIED CORROSION AT FS 758 BETWEEN LONGERONS 29R AND 28R. REMOVED FASTENERS COMMON TO BUTT SPLICE FOR VERIFICATION. REMOVED FASTENERS COMMON TO INTERNASDR DALA2018022701206Panel · corrodedCORROSION ON THE AFT LAVATORY SERVICE PANEL. REPAIRED IAW TOPP 20-50-20, AND PRI 541624-14 REV O -2. ERA 541624-14 REV A STEPS 1-13.SDR DALA2018022701205Battery Pack · inoperativeCEILING EMERGENCY LIGHTS INOPERATIVE AT ROW 16 - 20. REPLACED THE BATTERIES, CHECKED GOOD IAW AMM 33-50.SDR DALA2018022601128Connector · disconnectedON SVC CK FOUND EMERGENCY LIGHT OUT, ROW 26. FOUND PLUG DISCONNECTED UNDER SEAT RECONNECTED. CKS OK.SDR DALA2018022601127Battery Pack · dischargedEMERGENCY LIGHTS BETWEEN ROW 22-25 CEILING INOP. REPL BATTERY PACK PER AMM 33-53. OPS CHECK GOOD.SDR DALA2018022601129Compressor · stalledLARGE BOOM SOUND , FOLLOWED WITH VIOLENT A/C SHAKE AND FLASH OUTSIDE OF AIRCRAFT. FLIGHT ATTENDANT SMELLED SMOKE IN AFT CABIN. PASSENGER SMELLED ELECTRICAL FIRE AT ROW 19. NO AIRCRAFT SYSTEM OF ENGINE MALFUNCTIONS.
OPENED LEFT AND RIGHT ENGINE FOR BOROSCOPE. SDR DALA2018022601126Spar · crackedRT VERTICAL STAB FRONT SPAR FORWARD FLANGE L/E ATTACH HOLES 3 EACH INDICATE CRACK. HOLES ARE MARKED 4,7, AND 8 BELOW L/E SPLICE PLATE. COMPLIED WITH ERA 556177-14AD REV A AND FOUND TO MATCH PRI 556177-14 REV A REVISION 0.SDR DALA2018022401123Skin · crackedAFT LAV SERVICE PANEL HAS CRACK SKIN AND CORROSION ON AFT LOWER CORNER. REPAIRED PER PRI 565769-14 REV 0 THRU REV 8. RECEIVED FINAL ERA 565769-14 REV ORIG. FINAL ERA 565769-14 AND PRI 565769-14 REV 0 THRU REV 8 MATCH. REF LOG 0431540 FOR TRACKING.SDR DALA2018022301104Throttle · malfunctionedLEFT THROTTLE WOULD NOT ADVANCE PAST 1.5 ON THROTTLE QUADRANT AT LEVEL OFF. INSPECTED THE PUSH - PULL CABLE, CROSSOVER SHAFT, LT THROTTLE CABLE AFT CARGO DOOR TO PYLON, LT THROTTLE CABLE IN FWD CARGO FWD BULKHEAD TO AFT BULKHEAD, ALSO INSPECTED THE CABLESDR DALA2018022301105Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERIES.SDR DALA2018022301103Lanyard · disconnectedTAILCONE SLIDE DEPLOYMENT LANYARD DISCONNECTED. CONNECTED THE TAILCONE SLIDE DEPLOYMENT LANYARD.SDR DALA2018022201080Battery · dischargedAFT LEFT LAV SMOKE DETECTOR, INTERMITTENT FALSE AURAL ALARMS. R&R LAV DETECTOR BATT PER AMM 26-13. OK FOR SVC.SDR DALA2018022301079Floor Panel · damagedFWD GALLEY FLOOR SAGGING. REMOVED TWO FLOOR PANELS ADJACENT TO SERVICE DOOR. REMOVED GALLEY DOOR AND GALLEY MOUNT. MANUFACTURED AND INSTALLED FLOOR PANELS PER MD88AMM 53-20. INST GALLEY MOUNT AND DOOR.SDR DALA2018022301078Battery · dischargedEMERGENCY LIGHTS ABOVE EXIT ROW SEATS INOP. REPLACED BATTERIES IAW AMM 33-53.SDR DALA2018022101017Smoke Detector · false activationCREW VERBAL, F/C LAV SMOKE ALARM SOUNDED ON TAXI IN. FLIGHT NUMBER WAS NOT SPECIFIED. R&R DETECTOR.SDR DALA2018021900997Battery · dischargedEMERGENCY ESCAPE CEILING LIGHTS INOP ON TEST BETWEEN ROWS 27-31. REPL BATTERIES ABOVE SEAT ROW 29DE PER AMM 33-53. OPS CHECK GOOD.SDR DALA2018021900999Smoke Detector · false activationAFT LAV SMOKE DETECTOR INTERMITTENT ALARM ON CLIMBOUT. NO SMOKE-ODORS OR FUMES PRESENT. REMOVED SMOKE DETECTOR BATTERY IN LT AFT LAV AND REINSTALLED SMOKE DETECTOR. C /W M PROCEDURES - VERIFIED TRASH CONTAINER EMPTY AND LOCKED AND PLACARDED DOOR CLOSED. FWD TSDR DALA2018021800996Wire Harness · brokenROW 15 EMERGENCY LIGHT HARNESS BROKEN. R&R ROW 15 EMERGENCY LIGHT HARNESS. CKS GOOD. A/C OK FOR SVC.SDR DALA2018021700967Service Door · crackedAFT LAV SERVICE DOOR CRACK IN FUSELAGE. TRACKING FOR ACCOMPLISHMENT OF SECTION III: PERMANENT REPAIR PER ER/A 538941-14 REV B. FUSELAGE SKIN BELOW AFT LAVATIRY SERVICE PANEL WAS PERMANENT REPAIRED PER ER/A 538941-14 REV.C AND ETI 88-18-008 REV.2. (LP0226265)SDR DALA2018021700972Light · inoperativeEMERGENCY LIGHT 24ED INOPERATIVE. R & R THE LIGHT ASSY. OPS NORMAL IAW AMM 33-52.SDR DALA2018021700971Lamp · inoperativeUPPER SIDEWALL EMERGENCY SIGN HAS ONE LAMP INOPERATIVE. REPLACED THE LAMP IAW AMM 33-53. OPS NORMAL.SDR DALA2018021800998Apu · odorUPON ARRIVAL IN YYZ AFTER STARTING APU DURING TAXI TO GATE GOT A STRONG RAW FUEL ODOR THROUGHOUT CABIN. CREW ALSO SMELLED IN COCKPIT. PASSENGERS COMPLAINED OF FUMES. THE APU WAS REPLACED AND DOCUMENTED ON LP 9983360.SDR DALA2018021700966Vane · delaminatedDELAMINATED OTBD GUIDE VANE OF INBD FLAP ON THE LT WING. THE GUIDE VANE WAS REMOVED AND REPLACED IAW AMM 27-51-03-201.SDR DALA2018021700965Bulkhead · crackedCRACKS FOUND ON THE AFT CARGO BAY FWD PRESSURE BULKHEAD BS 1003, Z-6 TO Z-9, LBL 26 TO 26. THE PRESSURE BULKHEAD WAS REPAIRED IAW ER/A 565886-14, REV ORIGINAL.SDR DALA2018021600964Battery Pack · inoperativeCEILING EMERGENCY LIGHTS ROWS 22 TO 26 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK B5104 IAW AMM 33-53.SDR DALA2018021600936Light · inoperativeEMERGENCY LIGHTS ON CEILING PANELS FROM ROW 14-20 INOP. EXTERNAL EMERGENCY LIGHTS INOP. REPLACED PART NUMBER AD4002P FOR CEILING EMERGENCY LIGHTS. REMOVED AND REPLACED PART NUMBER AD-3110 FOR EXTERNAL EMERGENCY LIGHTS REF AMM 33-53-00. OPS CHECK GOOD.SDR DALA2018021600935Door Frame · delaminatedFOUND SEVERE DELAM CORROSION. AFT RT CORNER OF AFT LAV SVC DOOR FRAME. COMPLIED WITH ERA 482821-14 REV A. RECEIVED FINAL ERA 48281-14 REV A. COMPARED TO PRI 482821-14 REV A. REV 2. PRI MATCHES ERA.SDR DALA2018021600963Doubler · corrodedCORROSION FOUND ON THE EXTERNAL DOUBLER, AROUND THE AFT LAVATORY WASTE SERVICE PANEL. THE DOUBLER WAS REPLACED IAW ER/A 482821-14, REV ORIGINAL, REVISION A.SDR DALA2018021600934Hose · tornDURING INSPECTION OF LAVATORY OXYGEN MASK, HOSE ON RT AFT LAVATORY WAS FOUND TORN. IN REF 3500-7457 STEP 5. LAVATORY OXYGEN MASK HOSE ON RT AFT LAVATORY WAS REPLACED PER AMM 35-22-02.SDR DALA2018021600933Skin · crackedCRACKED SKIN BTW BEAM NR 4 TO 5 MID SECTION AT MAIN ENTRANCE DOOR. CRACKED SKIN BTW BEAM NR 4 TO 5 MID SECTION WAS REPAIRED PER ER/A:501106-14MA REVISION: C READY FOR ENTRY PERFORM VISUAL DEACL INSPECTION CONDITION EVERY C (L1).SDR DALA2018021500932Light · inoperativeCOCKPIT OVERHEAD AND FIRST CLASS OVERHEAD EMERGENCY LIGHTS INOP. RE LAMPED IAW MM 33-50 AND ALL LIGHTS OPS CHECK GOOD.SDR DALA2018021500930Battery · dischargedFWD GALLEY EMERGENCY LIGHTS INOP. R&R BATTERIES IN FORWARD GALLEY LOC B5-23 PER AMM 33-53 OP CKS GOOD OK FOR SVC.SDR DALA2018021500929Angle · crackedRIGHT MAIN GEAR WHEEL WELL, CRACK IN OUTBOARD AFT ANGLED, CORNER OF WHEEL WELL PREVIOUSLY REPAIRED. REPAIRED JAM PER ERA 520687-14MA REV A.SDR DALA2018021500931Tape · missingAWR AD INITIAL INSPECTION, MISSING AND WORN TIE TAPE ON AUX HYDRAULIC PUMP POWER FEEDER WIRING. TIE TAPE WAS REPLACED PER ERA 467688-14MAAD REV D.SDR DALA2018021500901Skin · crackedFOUND A CRACK IN THE FUSELAGE BELOW THE AFT LAVATORY SERVICE DOOR. THE SKIN WAS REPAIRED IAW ER/538941-14, REV C, AND ETI-88-18.SDR DALA2018021500900Frame · crackedFOUND A CRACKED FRAME BS 1510. THE FRAME WAS REPLACED IAW SRM 51-30-2 AND 53-14-4, FIG 3.SDR DALA2018021400899Battery Pack · inoperativeROWS 1 - 4, OVERHEAD EMERGENCY LIGHTS FOUND INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-53.SDR DALA2018021400898Pin · missingDURING INSPECTION OF THE L1 DOOR SLIDE, FOUND THE PARACHUTE PINS NOT INSTALLED. R & R THE L1 DOOR SLIDE IAW W/C 2561-4964.SDR DALA2018021400876Pin · missingMISSING SECURITY PIN ON AFT PASSENGER ENTRANCE EVACUATION SLIDE AND TAIL CONE EVACUATION SLIDE IN REF 2520-2169. PIN ON TAIL CONE EVACUATION SLIDE AND PIN ON AFT PASSENGER ENTRANCE EVACUATION SLID WERE INSTALLED PER AMM 25-62-00-201.SDR DALA2018021400875Longeron · corrodedAWR HIDDEN CORROSION: CORROSION WAS FOUND ON LONGERON 22L FROM STA Y=1331 TO Y=1333 IN AFT CARGO COMPARTMENT DURING REPAIR OF AFT LAVATORY SERVICE PANEL REF NRC S/N 00051. LEVEL CORROSION 2 DAMAGE LONGERON WAS REPAIRED (PERMANENT REPAIR) PER SRM 53-02 FIG 18.SDR DALA2018021300874Skin · crackedCRACK IN FUSELAGE, AFT LEFT SIDE, 20 INCHES FWD OF TAIL JETTISON HANDLE. INSTALLED REPAIR DOUBLER REF SRM 53-01, FIG 4 SHT 4.SDR DALA2018021300877A/C Pack · shutdownSMOKE - COLD TEMPERATURE IN DSM. WHILE AT GATE DURING BOARDING PLACED RIGHT PACK TO "ON". RT PACK OVER TEMP SHUTDOWN WITH SMOKE IN AFT CABIN. SMOKE DISSIPATED AFTER RT PACK WAS SHUTDOWN. ONLY 15 PASSENGERS WERE DEPLANED PER THE FLIGHT CREW REPORT AND NONE REPOSDR DALA2018021300856Pan · crackedCRACKED PAN ABOVE THE NR 1 BEAM, FWD EDGE AT MAIN ENTRANCE DOOR. THE PAN WAS REPAIRED IAW SRM 52-05, PAR 14, FIG 18A.SDR DALA2018021200855Battery Pack · failedL1 & R1 DOORS AND FLIGHT DECK EMERGENCY LIGHTS INOPERATIVE. AFTER TROUBLESHOOTING, FOUND THE BATTERY PACK FAILED. REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-50.SDR DALA2018021200854Connector · brokenCENTER LIGHT IN AFT STAIRWELL, THE CONNECTOR FOUND BROKEN ON CEILING WHEN CATWALK IS DOWN. REPAIRED THE CONNECTOR IAW SWPM 20-30-12. EMERGENCY LIGHT OPS CHECKED GOOD.SDR DALA2018021300857Seat Track · damagedWHILE TROUBLESHOOTING A FAULT, FOUND ELECTRICAL ARC DAMAGE ON THE SEAT TRACK AT BS 279. REPAIRED THE SEAT TRACK IAW PRI 565645-14, REV 0.SDR DALA2018021200828Guide Vane · wornWEAR ON LT WING OUTBOARD FLAP INBOARD GUIDE VANE STA XFLS=151. LT WING OUTBOARD FLAP INBOARD GUIDE VANE STA XFLS=151 WAS REPAIRED PER SRM 57-03 D PARAGRAPH 11 AND 2000-8149-01.SDR DALA2018021100814Seat Track · damagedDUE PRI 565645-14 REV 0. MD-88 / FUSELAGE / AUXILIARY STRUCTURE / SEAT TRACK STA 279, LBL 54.5 / DAMAGED FROM AN ARCING FEEDER CABLE. C/W PRI 565645-14 REV 0. C/W ERA 565645-14 REV 0. (LP0420138)
Back to Mcdonnell Douglas MD-88