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 DALA2016071205212Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINKS OF LT WING FUEL TANK ACCESS PLATE NR 1361C. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016071105205Beam · crackedCRACKED BEAM NR 7 AFT SECTION ON FORWARD ENTRY DOOR L1. BEAM NR 7 WAS REPAIRED IAW SRM 52-05D, FIG 109, 51-30-2, 51-30-5 AND 51-10-3 PAR 14.SDR DALA2016071105201Doubler · wornWORN FORWARD, AFT DOUBLER ON LOWER EDGE AT FORWARD CARGO COMPARTMENT DOOR. FORWARD, AFT DOUBLER LOWER EDGE AT FORWARD CARGO COMPARTMENT DOOR C1 WERE REPLACED IAW ER/A 486624-14MA, REV ORIG AND SRM 51-30-2.SDR DALA2016072105476Vane · corrodedCORROSION ON MID INBD STUD ALSO INNER FITTING ON OUTBD FLAP, OUTBD VANE AT LT WING. THE GUIDE VANE WAS REPLACED.SDR DALA2016071305248Skin · dentedRT SLAT DENTED ON L/E ON NR 1 SLAT AT XFS 100. REPLACED RT NR 1 SLAT IAW CARD 2700-4224 RH-01.SDR DALA2016071105206Wire · damagedSEAT 12E EMERGENCY LIGHT INOPERATIVE. REPAIRED SEAT FRAME WIRING. OPS CKS GOOD. REF SWPM 20-10.SDR DALA2016071105202Beam · crackedCRACKED BEAM NR 1 ON FWD AND AFT SECTION AT FWD ENTRY DOOR. R1 BEAM NR 1 WAS REPAIRED IAW SRM 52-05D, FIG 81 AND 82, 51-30-1, 51-30-2, 51-30-5 AND 51-10-3 PAR. 14.SDR DALA2016071005199Cusp Web · damagedHIDDEN DAMAGE, ELONGATED HOLES ON DIAPHRAGM BETWEEN STA Y=180 TO Y=200 AND X=-54 - X=-44 AT W1 AREA. CUSP WEB WAS REPAIRED 51-70-4. REPAIR DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 51-30-20, 51-30-5 AND 51-70-4, FIG 2.SDR DALA2016071005198Longeron · crackedCRACK ON RT INTERNAL STRUCTURE FUSELAGE ON LONGERON 4 RT STA Y = 907. CRACK ON RT INTERNAL STRUCTURE FUSELAGE ON LONGERON 4 RT STA Y =907 WAS REPAIRED IAW SRM 53-02, FIG 18, SRM 51-30-1, 51-30-2, 51-30-5, SRM 51-10-3 PAR 14, 21. SRM 51-10-4, 51-10-2, AND 51-SDR DALA2016071005197Doubler · crackedCRACKED DOUBLER ON CUSP WEB STA Y=220 BETWEEN X=-54 AND X=-60 RT AT PAX CABIN. CUSP WEB WAS REPLACED IAW SRM 53-05, FIG 131A-24 AND 51-10-4, 51-30-2 AND 51-30-5.SDR DALA2016071005195Floor Panel · crackedCRACK FLOOR PANEL NR 541A AT CABIN PASSENGER. CRACK ON FLOOR PANEL WAS REPAIRED IAW SRM 53-01 FIG 4 AND 51-30-02.SDR DALA2016071005194Pan · crackedCRACK ON LT FORWARD LOWER CORNER RING PAN BETWEEN Y=1060 AND Y=1079, Y=1098 AND Y=1117 AT CABIN PASSENGER INTERNAL STRUCTURE. RING PAN WERE REPAIRED IAW SRM 53-05, FIG 122 AND ERA 493648-14MA, REV A. BETWEEN STA Y=1060- Y=1079 CRACK=L.550", AND STA Y=1098-Y=SDR DALA2016071005193Cusp Web · corrodedCORROSION ON RIGHT CUSP WEB AT STA Y=1010 BETWEEN X=-54 AND X=-60 AT PASSENGER CABIN. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13, 51-30-2, 51-30-5 AND 51-10-3 PAR 14, 21 AND 38.SDR DALA2016071005192Intercostal · crackedCRACKED INTERCOSTAL BETWEEN STA Y=1287 TO 1309, X= 0, Z= -1, AT CPAX. INTERCOSTAL WAS REPLACED IAW SRM 51-30-1, 51-30-5 AND 51-10-4.SDR DALA2016071005191Pan · crackedCRACK ON LT FORWARD LOWER CORNER RING PAN BETWEEN Y=1022 AND Y=1041, Y=984 AND Y=1003 AT CABIN PASSENGER INTERNAL STRUCTURE. RING PAN WERE REPAIRED IAW SRM 53-05, FIG 122 AND ERA 493648-14MA, REV A. BETWEEN STA Y=1060- Y=1079, CRACK=L 550", AND STA Y=1098, YSDR DALA2016071005190Pan · crackedCRACK ON RT AFT UPPER CORNER RING PAN BETWEEN Y=1060 AND Y=1079 AT CABIN PASSENGER INTERNAL STRUCTURE. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122 AND ERA 493648-14MA, REV A. HFEC WAS ACCOMPLISHED ON RT AFT UPPER CORNER RING PAN BETWEEN Y=1060 AND Y=1079 ATSDR DALA2016071005189Pan · crackedCRACK ON RT AFT LOWER CORNER RING PAN BETWEEN Y=1060 AND Y=1079 AT CABIN PASSENGER INTERNAL STRUCTURE. RING PAN WAS REPAIRED IAW
SRM 53-05, FIG 122 AND ERA 493648-14MA, REV A, CRACK: L=.500", HFEC WAS ACCOMPLISHED ON RT AFT LOWER CORNER RING PAN BETWEEN Y=1SDR DALA2016071005188Pan · crackedCRACK ON RT FWD LOWER CORNER RING PAN BETWEEN Y=1060 AND Y=1079, Y=1098 AND Y=1117 AT CABIN PASSENGER INTERNAL STRUCTURE. RING PAN WERE REPAIRED IAW SRM 53-05, FIG 122 AND ERA 493648-14MA, REV A.SDR DALA2016071105203Beam · crackedCRACKED BEAM NR 7 AFT SECTION ON FORWARD ENTRY DOOR. L1 BEAM NR 7 WAS REPAIRED IAW SRM 52-05D, FIG 109, 51-30-2, 51-30-5 AND 51-10-3, PAR 14.SDR DALA2016070905187Access Panel · corrodedCORROSION ON STTLEMENT AREA AND COUNTERSINKS OF LT WING FUEL TANK ACCESS PLATE NR 1303C. FUEL ACCESS PLATE 1303C WAS REPLACED FOR A NEW ONE UNDER CONDITION III SRM 51-22-2A.SDR DALA2016070905186Access Panel · corrodedCORROSION AND EVALUATED IAW SRM 51-22-2A. CENTER FUEL TANK ACCESS PLATE NR 2301C WAS REPLACED UNDER CONDITION III IAW SRM 51-22-2A.SDR DALA2016070905185Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINKS OF LT WING FUEL TANK ACCESS PLATE NR 1355C. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016070905184Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINKS OF LT WING FUEL TANK ACCESS PLATE NR 1307C. ACCESS PLATE NR 1307C WAS REPLACED UNDER CONDITION III IAW SRM 51-22-2A.SDR DALA2016071105204Pan · crackedCRACKED INNER PAN ON FORWARD, UPPER CORNER AT FORWARD ENTRY DOOR. L1 INNER PAN ON FORWARD, UPPER CORNER WAS REPAIRED IAW SRM 52-05D, FIG 18A.SDR DALA2016070805177Charger · inoperativeFOUND AFT SECTION OF EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY CHARGER AND BATTERY IAW AMM 33-53, OPS CHECK GOOD.SDR DALA2016070805176Channel · crackedCRACKED CHANNELS ON FLOOR PANELS NRS 541F, 927E, 1003F, 313A, AND 256A AT CAB PAX. CRACKS ON FLOOR PANELS WERE REPAIRED IAW SRM 53-05, FIG 131B & 131C AND 51-30-02. LONG OF CRACKS 541F=0.125", 927E=0.093", 1003F=0.140", 313A=.200", AND 256A=0.170".SDR DALA2016070805175Intercostal · crackedCRACKED AND WORN INTERCOSTAL BETWEEN STA Y= 1022 TO 1041, X=0, Z= -1 AT CPAX. CRACK WAS ATTENDED IAW SRM 53-01, FIG 2, WORN WAS BLENDED IAW SRM 53-01, FIG 1 UT WAS ACCOMPLISHED IAW NDT SPM 04-00-07 PAR 5, FIG 3.SDR DALA2016070805174Access Panel · corrodedCORROSION ON SETTLEMENT AREA OF RT WING FUEL TANK ACCESS PLATE NR 1409C. FUEL ACCESS PLATE 1409C WAS REPLACED UNDER CONDITION III IAW SRM 51-22-2A AND IPC 57-30-00.SDR DALA2016070705158Hinge · wornMID CARGO DOOR FWD AND AFT HINGES LOOSE & WORN, DOOR VERY LOOSE. REPLACED THE WORN PARTS AND ADJUSTED IAW AMM 52-31-02. LEAK CHECKED GOOD.SDR DALA2016070705157Release Mech · out of toleranceDURING TAILCONE RELEASE SYSTEM FUNCTIONAL CHECK, OPENING FORCE REQUIRE TO OPEN AFT VENTRAL DOOR IS 30 LBS. PULL TEST OUT OF LIMITS. RIGGED TAILCONE IAW AMDS 5350-01077-0101. ADJUSTED TEE PIN CLIPS, LATCHES, AND LUBED IAW AMDS 5350-01077-0101. PERFORMED TASDR DALA2016071805379Spar · crackedWING REAR SPAR CRACKED XRS 164.SDR DALA2016070705207Coffeemaker · malfunctionedCOFFEEMAKER, F303, NR 1 TURNED ON. IN FLT, SMELLED ELECTRICAL BURNING. SECURED, ODOR DISSIPATED IMMEDIATELY. DEFERRED IAW NEF 253602. COFFEEMAKER REPLACED ON 08JUL16.SDR DALA2016070705161Fuse · failedDURING CHECK, ROWS 31-36 EMERGENCY LIGHTS FOUND FUSE F1 OF R5-212 INOPERATIVE. REPLACED THE FUSE IAW BSWPM 20- CHECKED OK.SDR DALA2016070705160Battery Pack · inoperativeROW 11-21 OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-53-00 AND REPLACED POWER SUPPLY AT ROW 12 IAW AMM 33-53-00. OPS CHECKED GOOD.SDR DALA2016070705159Battery Pack · inoperativeFOUND OVERHEAD EMERGENCY LIGHTS 34 & 36 11-21 INOPERATIVE. REPLACED THE BATTERY PACK IAW MM 33-53. CHECKED GOOD.SDR DALA2016070705142Cusp Web · crackedCRACKED RT CUSP WEB BS 237, X 56. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-6 51-30-01, 51-30-03, 51-30-05, AND 51-10-03 PAR 14, 21, 38.SDR DALA2016070705141Cusp Web · crackedCORROSION ON CUSP WEB FROM BS 826 - 845 BETWEEN LBL 54 - 60. CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG131A-14.SDR DALA2016070705140Cusp Web · crackedPUNCTURED CUSP WEB BS 1028 RBL 54-60. CUSP WEB WAS REPAIRED IAW SRM 53-01 FIG.1 (SHEET1), 51-10-3 PAR. 21, 14, AND 51-30-2.SDR DALA2016070705139Longeron · crackedLONGERON 16R, BS 1437 CRACKED. LONGERON WAS REMOVED AND REPLACED IAW SRM 53-14-4, 51-30-5, AND 51-30-2.SDR DALA2016070705138Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINKS OF LT WING FUEL TANK ACCESS PLATE 1357C. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016070705137Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINKS OF LT WING FUEL TANK ACCESS PLATE 1365C. THE ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016070705136Angle · crackedCRACK ON ANGLE IN AFT EDGE NR 1 BEAM AT EMERGENCY DOOR RT FWD. A NEW ANGLE WAS FABRICATED IAW SRM 51-10-2, AND DWG 9957735 REV. G. THE ANGLE WAS REMOVED AND REPLACED IAW SRM 51-30-2, AND SRM 51-30-5.SDR DALA2016070705135Pan · crackedCRACKED PAN FWD NR 4 EDGE BEAM AT FWD GALLEY SERVICE DOOR. PAN WAS REPAIRED IAW SRM 52-03 D FIG. 3, 51-30-01, 51-30-02, 51-30-04, AND 51-10-03 PAR. 21 AND 14.SDR DALA2016070605117Longeron · crackedCRACKED LONGERON 3 LT ON STA Y=1437 AT AFT ACCESSORY COMPARTMENT. SECTION DAMAGED LONGERON AND SPLICE WERE REMOVED IAW SRM 51-30-5 AND 51-30-2. NEW SPLICE WAS FABRICATED IAW SRM 51-10-2 AND 51-10-2A AND NEW SPLICE AND SECTION LONGERON WERE INSTALLED IAW SRM SDR DALA2016072105475Vane · corrodedCORROSION ON OUTBD LOWER FACE MID VANE OUTBD FLAP RT WING. DUE TO EXCESSIVE CORROSION THE GUIDE VANE WAS REPLACED IAW SRM 57-03D PAR 11.SDR DALA2016072005448Vane · wornWEAR AT OUTBOARD FLAP VANE 3 RT WING. FLAP VANE REPLACED IAW SRM 57-03D PAR.11.SDR DALA2016070705156Spar · crackedWING REAR SPAR CRACKING AT XRS 164.SDR DALA2016070605126Slide · low pressureON PRE DOCK, LT AFT SERVICE DOOR SLIDE PRESSURE LOW. REMOVED AND INSTALLED L2 DOOR SLIDE IAW AMDS 2561-4002.SDR DALA2016070605125Repair · delaminatedRT ANTI-FLOAT TAB, INBD REPAIR IS DIS-BONDED, TOP SURFACE. REMOVED AND INSTALLED RT ANTI-FLOAT TAB ON AMDS 2730-4382.SDR DALA2016070605123Vane · damagedRT NR 4 VANE HAS RUBBING MARKS. R & R VANE REF AMM 27-51-03.
Back to Mcdonnell Douglas MD-88