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 DALA2016123010144Bearing · damagedHORIZONTAL STABILIZER FREE PLAY LT & RT ELEVATOR ANTI-FLOAT TABS. BEARING BUSHINGS AND HARDWARE WERE REPLACED FOR NEW ONES AT LH/RH ANTI-FLOAT TABS AND WERE INSTALLED AND ADJUSTED. (LP# 2827688)SDR DALA2016123010143Fitting · crackedRT WING GROUND SPOILER ACTUATOR ATTACH FRAME CRACKED AT FWD. INSTALLED THE FITTING IAW SRM 51-01 PG 1 AND SRM 51-30-02/05.SDR DALA2016123010142Longeron · crackedAFT ACCESORIES COMPARTMENT CRACK LONGERON 12R, BS 1431 BULKHEAD. REPAIRED IAW ETI-88-16-462 REV. 1 AND ER/A 552834-14.SDR DALA2016123010141Skin · crackedRIGHT WING CRACKS AND SHEARED FASTENERS AT SLAT PANEL NR 3 INBD SKIN. REPAIRED IAW SRM 57-01, FIG. 5.SDR DALA2016123010140Doubler · crackedLEFT WING CRACKED PRODUCTION DOUBLER AT LH WING UPPER SURFACE XW= 50. REPAIRED IAW SRM 57-03D FIG.34.SDR DALA2016122910134Coffeemaker · odorENROUTE, DIVERTED DUE TO FLIGHT ATTENDANTS REPORTING AN ELECTRICAL ODOR IN THE FIRST CLASS CABIN. MAINTENANCE FOUND A FORWARD GALLEY COFFEEMAKER HOT PLATE WAS BURNING COFFEE AND CAUSING ELECTRICAL ODOR. THE COFFEE MAKER WAS DEFERRED PER NEF (LP# 9480325) ANSDR DALA2016122910133Blanket · meltedLEFT REAR LAVATORY SMOKE DETECTOR WENT OFF ON FINAL APPROACH. NO SMOKE OR FUMES OBSERVED. PAX NOTED BURNED RUBBER ODOR IN AFT CABIN. ENGINE AND AIRFRAME ANTI-ICE WERE ON. FOUND RT TAILCONE SECTION COVERED IN DE-ICING FLUID, FOUND RED FIRE BLANKET MELTED TOSDR DALA2016122910132Diode · damagedSTRONG BURNING ODOR IN COCKPIT IMMEDIATELY AFTER TAKE OFF. NO SMOKE OR VISIBLE FUMES. NO ODORS IN CABIN AREA. ODOR DISSIPATED AFTER 3 OR 4 MINUTES. NO ABNORMAL COCKPIT INDICATIONS. FOUND TRANSFORMER RECITIFER DIODES DISCOLORED. REPLACED BOTH DIODES IAW AMSDR DALA2016122910131Acm · leakingON SHORT FINAL, SMELLED A SMOKE TYPE ODOR. FA STATED BOTH LAVATORY SMOKE DETECTORS ON CAPTAIN SIDE (FRONT & BACK) WENT OFF. A HAZE WAS OBSERVED IN THE CABIN. FOUND RIGHT ACM LEAKING OIL. REPLACED THE ACM. COMPLETED DUCT BURN-OUT.SDR DALA2016122910130Skin · crackedL1 DOOR CRACKED ON EXTERNAL SKIN ABOVE HANDLE. THE DOOR SKIN WAS REPAIRED IAW ER/A 501106-14MA.SDR DALA2016122910129Door Frame · corrodedMID CARGO LOWER DOOR FRAME HAS CORROSION BETWEEN BS 636 - 693. REPAIRED THE LOWER DOOR FRAME IAW PRI/ERA 553436-14.SDR DALA2016122910128Housing · wornWEAR ON AFT CARGO DOOR HANDLE HOUSING. HOUSING WAS REMPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016122910127Longeron · crackedCRACKED LONGERON 2L BS 160. REPAIRED IAW SRM 53-02 FIG. 18.SDR DALA2016122810103Angle · damagedDENT AND CRACKED ANGLE AT AIRSTAIR CUTOUT 1 FT FWD OF AFT RT CORNER. REPAIRED IAW ER/A 553772-14.SDR DALA2016122810102Frame · damagedREPAIR ANGLE CRACKED AT LOWER END OF BS 1485 FRAME RT SIDE NEAR STAIR ACTUATING CYLINDER. REPAIRED IAW ER/A 553772-14.SDR DALA2016122810100Skin · crackedCRACK CUTOUT ACCESS PANEL 6301A OF VERTICAL STAB PREVIOUS DOUBLER REPAIR WAS REMOVED, NEW DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 51-30-2, 55-05 FIG 3.SDR DALA2016122810101Slide · damagedL1 DOOR SLIDE ENGAGEMENT PINS ARE OUT. REPLACED L1 DOOR SLIDE IAW AMDS WORK CARD 2561-4964.SDR DALA2016122810099Door Frame · corrodedAFT CARGO DOOR FRAME CORRODED BS 1212 TO 1155. REPAIRED IAW SRM 53-05 FIG. 123 A.SDR DALA2016122810098Beam · crackedCRACKED BEYOND STOP DRILL ON AFT EDGE BEAM NR 1 AT MAIN ENTRANCE DOOR. REPAIRED IAW SRM 52-05 PAR 68 FIG 81.SDR DALA2016122810097Longeron · crackedCRACKED LONGERON 3L ON BS 160. REPAIRED IAW SRM 53-02 FIG.18.
SDR DALA2016122810091Pan · crackedR1 DOOR CRACKED ON PAN, FWD EDGE BETWEEN BEAMS 2 AND 3. THE PAN WAS REPAIRED IAW SRM 52-03 D FIGURE 3.SDR DALA2016122710090Fitting · crackedRT WING TE GROUND SPOILER ACTUATOR FWD FITTING CRACKED. REPLACED THE FITTING IAW DWG SR09570010 REV. H.SDR DALA2016122710085Connector · damagedWHILE PERFORMING SERVICE CHECK, FOUND SEAT 25ED FORWARD EMERGENCY LIGHT INOPERATIVE. FOUND LOOSE SOCKET IN CONNECTOR. CHANGED CONNECTOR, OPS CHECKED GOOD.SDR DALA2016122710084Pan · crackedCRACKED PAN BELOW STOP FITTING NR 2 ON FWD CARGO DOOR FWD EDGE. REPAIRED IAW ETI-88-16-480 REV. 2 AND ER/A 552866-14.SDR DALA2016122710083Door Frame · damagedMID CARGO BAY CORRODED ON PREVIOUS REPAIR SPACER AT LOWER DOOR JAMB. PREVIOUS REPAIR SPACER WAS REPLACED IAW SRM 53-05 FIG. 123.SDR DALA2016122510089Support · damagedRIGHT NLG STEERING ACTUATOR DAMAGED RIGHT SIDE NLG SUPPORT WEB. INSTALLED REPAIR IAW SRM 53-05 REPAIR 47A STEP (B) (3) (B).SDR DALA2016122610087Engine · contaminatedAFTER TAKE OFF AND ACTIVATION OF AIRFOIL ICE SMOKE HAZE FILLED CABIN AND COCKPIT AFT LAV FIRE DETECTOR ACTIVATED SMOKE DISSIPATED AFTER SELECTING ICE PROTECTION OFF.PREFORMED AIRFOIL ANTIICE OPERATION IAW AMM 30-10. NO SMOKE WAS FORMED IN CABIN NOW FUEL OIL/SWSDR DALA2016122610086Unknown · odorDURING APPROACH WITH ENGINE AND WING ANTI-ICE ON, F/A REPORTED BOTH AFT SMOKE DETECTORS ACTIVATED. F/A REPORTED SHE SMELLED A BURNING ODOR JUST BEFORE SMOKE DETECTOR ACTIVATED. FIRST OFFICER ALSO NOTED BURNING ODOR FROM HIS VENT . SELECTED WING ANTI -ICE OFSDR DALA2016122610082Wire Harness · burnedAT CRUISE, MASTER WARNING CAME ON OAP DISPLAY MACH TRIM INOP/ YAW DAMP INOP/ IRS1 BATT FAIL/STALL IND FAILURE. BOTH AP AND ATNOP- ATL WINDOW BLANK & COULD NOT ADJUST SPD INDICATOR. MASTER WARNING WOULD NOT RESET C/BS C12 AND C17 POPPED AND WOULD NOT RESET. SDR DALA2016122610088Lamp · inoperativeLEFT WING AFT OVERWING HATCH EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51.SDR DALA2016122610081Skin · damagedSTRUCTURAL DAMAGE ON RIGHT SIDE, FWD OF FWD CARGO DOOR. REPAIR ACCOMPLISHED PER ERA 553592-14 REV ORIG AND ERA 553600-14.SDR DALA2016122510080Skin · damagedPRODUCTION SPLICE DAMAGED AT BS 229 BETWEEN LONGERONS 23 AND 25 RIGHT. REPAIRED IAW ER/A 553600-14, REV. O AND ER/A 553600-14.SDR DALA2016122510079Beam · gougedNLG LEFT NOSE WHEEL WELL BEAM WEB GOUGED AND INDENTED BELOW BEAM. REPAIRED IAW ER/A #553598-14, REV. ORIGINAL AND ER/A 553598-14.SDR DALA2016122510078Skin · damagedSKIN DAMAGED AT LONGERON 25R BS 218. REPAIR ACCOMPLISHED IAW ER/A#553592-14, REV. 1 AND ER/A 553592-14.SDR DALA2016122510077Bulkhead · damagedFORWARD CARGO BULKHEAD DAMAGED BETWEEN LONGERON 24 AND 25R AT BS 218. FABRICATED AND INSTALLED STRUT AND BULKHEAD IAW DWG 9951888 AND SRM 51-01, PG. 1.SDR DALA2016122410060Door Frame · crackedCRACKED FWD DOOR JAMB CHANNEL BS 937 AND RBL 5. RH MLG JAMB CHANNEL WAS REPAIRED IAW ERA 552882-14.SDR DALA2016122410059Fairing · crackedCRACK ON LT ELEVATOR CONTROL TAB FAIRING. ELEVATOR CONTROL TAB FAIRING WAS REPAIRED IAW SRM 55-01 FIG 2 (SHEET 2).SDR DALA2016122410058Skin · crackedCRACK ON FUSELAGE SKIN BS 1474 LEFT SIDE (FUS). REPAIRED IAW SRM 53-01 FIG 4 SHEET 4,SDR DALA2016122410057Beam · corrodedAFT CARGO COMPARTMENT: CORROSION ON LOWER DOOR JAMB BEAM. REPAIRED IAW SRM 51-02 PAR- .A (6), SRM 53-05 FIG. 123, SHEET 2, AND DWG 5936038 REV. A.SDR DALA2016122310041Skin · crackedA CRACK ON THE FUSELAGE SKIN BS 1474 LONGERON 22L. THE SKIN WAS REPAIRED IAW SRM 53-01 FIG. 2 AND SRM 51-30-2.SDR DALA2016122310043Longeron · damagedLONGERON 25R DAMAGED AT BS 218. REPAIRED IAW PRI 553592-14REV 1 AND SRM 53-02 FIG 18.SDR DALA2016122310042Longeron · damagedLONGERON 24R DAMAGED AT BS 218. REPAIRED IAW PRI 553592-14 REV 0 AND SRM 53-02 FIG 18.SDR DALA2016122310040Doubler · corrodedCORROSION ON AFT LAVATORY SERVICE PANEL INNER DOUBLER. THE DOUBLER WAS REPLACED IAW ER/A 552849-14 REV: ORIGINAL.SDR DALA2016122310039Turbine · damagedENROUTE, LEFT ENGINE EXPERIENCED COMPRESSOR STALLS AND INCREASED EGT. REDUCED POWER TO KEEP EGT IN NORMAL RANGE. FOUND TURBINE DAMAGE REQUIRING ENGINE CHANGE. ENGINE CHANGED.SDR DALA2016122210031Transducer · failedLEFT INBD ANTI-SKID ON OAP WHEN GEAR EXTENDED. EMERGENCY WAS DECLARED. REPLACED ANTI-SKID TRANSDUCER.SDR DALA2016122210030Module · failedSEAT MOUNTED EMERGENCY LIGHT INOPERATIVE ROW 30. REPLACED THE LIGHT MODULE AND HARNESS IAW AMM 33-53. CHECKED GOOD.SDR DALA2016122210029Bracket · crackedTAILCONE UPPER RT LATCH BRACKET LOWER L BRACKET IS CRACKED. REMOVED, FABRICATED, DRILLED, TREATED, PRIMED, AND INSTALLED A NEW BRACKET IAW SRM 51-10-02.SDR DALA2016122210028Pan · crackedCRACKED PAN BELOW STOP FITTING NR 2 ON FWD CARGO COMPARTMENT DOOR FWD EDGE. CRACKED PAN WAS REPAIRED IAW ER/A 552873-14 REV: ORIGINAL, MESSAGE 16-0778-08B AND ETI-88-16-483 REV: NR 3.SDR DALA2016122210027Pan · crackedCRACK ON INNER PAN FWD LOWER CORNER AT FWD SERVICE DOOR. INNER PAN FWD LOWER CORNER AT FWD SERVICE DOOR WAS REPAIRED IAW ETI 88-16-483 REV.3 AND ER/A 552873-14 REV. ORIGINAL.SDR DALA2016122210026Beam · corrodedMID CARGO DOOR THRESHOLD BEAM SEVERAL AREAS OF CORROSION FROM BS 636 TO 693. REMOVED AND REPLACED THE BEAM IAW DWG 5936038.
Back to Mcdonnell Douglas MD-88