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 DALA2015091305607Stop Fitting · crackedCRACK FOUND ON INTERIOR FITTING OF DOOR STOP AT R1, DOOR NR 1 BEAM FWD EDGE, INTERNAL STRUCTURE. DAMAGE FITTING WAS REPLACED IAW SRM 51-30-5.SDR DALA2015091305606Intercostal · crackedCRACKED INTERCOSTAL ON KEEL BEAM, BS 978. INTERCOSTAL WAS REPAIRED IAW SRM 53-01, FIG 2, SHEET 3.SDR DALA2015091205605Cusp Web · crackedCRACKED CUSP WEB X=-55, BS 807. CUSP WEB WAS REPLACED IAW SRM 53-05, FIG 131A-24.SDR DALA2015091505660Skin · damagedACFT DELAMINATED AREA CAUSED BY DENT ON LT ELEVATOR CONTROL TAB 17" FROM INBD EDGE, ALSO PUNCTURE ON ELEVATOR CONTROL TAB 28" FROM OTBD EDGE, BOTH AT LOWER SKIN. DENT ON LT ELEVATOR CONTROL TAB 17" FROM INBD EDGE, ALSO PUNCTURE ON ELEVATOR CONTROL TAB 28" FROSDR DALA2015091405621Battery Pack · inoperativeDURING SERVICE CHECK, MAINTENANCE FOUND FOUND EMERGENCY LIGHTS IN CEILING FORWARD OF AFT CABIN DOOR INOPERATIVE. BATTERIES AT B5-27 AND B5-28 WERE REPLACED.SDR DALA2015091205602Intercostal · crackedCRACKED INTERCOSTAL BS 1416 CANT BETWEEN LONGERONS 11 - 12 LTT. REMOVED AND REPLACED IAW SRM 51-30-2, 51-30-5, 53-01, 51-01, PAR 21, 53-01 FIG 2.SDR DALA2015091205601Stiffener · crackedACFT HAS A CRACKED STIFFENER BS 1339 BETWEEN PROYECTION LONGERONS 3-4L AT AFT BULKHEAD. STIFFENER WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-4, 51-10-3 PAR 21 AND 14 AND DWG 99155625, REV P.SDR DALA2015091105555Frame · crackedRT MLG WW FRAME IS CRACKED IN THE BEND RADIUS ALON THE OTBD END NEAR THE HYD SERVICE BAY. REMOVED FWD FRAME PN 5930584. REPLACED FWD W/W FRAME IAW DWG 5930584, SHEET 1.SDR DALA2015091105553Cusp Web · corrodedCORROSION FOUND ON LT CUSP WEB BETWEEN X 54 TO X 60 AND BS 322 - 540. REPAIRED IAW SRM 53-05, FIG. 131A.SDR WX0A2015091472858Power Supply · inoperativeFOUND ON WAKE UP, TAIL CONE EMER LIGHT INOPERATIVE & ALL THREE TAIL CONE LIGHTS VERY DIM. REPLACED BOTH POWER SUPPLIES & ONE EMER EXIT IDENTIFIER LIGHT ASSEMBLY. OPERATIONS CHECKED GOOD IAW AMM 33-53-00 & 33-53-01.SDR DALA2015091405619Battery Pack · inoperativeMAINTENANCE FOUND A CABIN EMERGENCY LIGHT INOPERATIVE. AN EMERGENCY BATTERY BACK WAS REPLACED.SDR DALA2015091205604Vane · wornWEAR ON REPAIR DOUBLER OF LT OTBD FLAP INBD VANE. LT OTBD FLAP INBD VANE WAS REPAIRED IAW SRM 57-03D, PAR. II.SDR DALA2015091205603Frame · crackedCRACKED FRAME ANGLE BS 1451 BETWEEN LONGERON 2 - 3L. REMOVED AND REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2015091105557Skin · wornWEAR FOUND ON EXTERNAL SKIN OF CARGO DOOR BARRIER. REPAIRED IAW ER/A 096425-14 MA, REV. "D".SDR DALA2015091105554Access Panel · corrodedCORROSION ON HEATER BLANKET SKIN AROUND OF SETTLEMENT SECONDARY ACCESS PANELS NR 1303C AND 1307C AT LT WING. HEATER BLANKET WAS REPAIRED IAW ER/A 537748-14AD, REV ORIGINAL.SDR DALA2015091105551Shear Tie · corrodedAFT CARGO HAD SIGNS OF CORROSION ON SHEAR TIE BS 1149 BETWEEN LONGERONS 29 AND 30R. REMOVED AND REPLACED THE SHEAR TIE IAW DWG 9936074.SDR DALA2015091105556Door Frame · crackedDURING SERVICE CHECK, RT MLG FWD DOOR FRAME CRACKED. STOP DRILLED ALL CRACK TIPS ON THE FRAME WITH A .2500 DIA HOLE IAW TOPP 40-60-05, SECTION X B2 CRACKS ARE ACCEPTABLE TO ENGINEERING FOR A 1-TIME NON REV. PRESSURIZED FERRY FLIGHT CONTINGENT UPON COMPLETION SDR DALA2015091005550Angle · crackedL1 MAIN CABIN DOOR, NR 1 BEAM AFT END ANGLE CRACKED. REPAIRED IAW SRM 52-05D, FIG 97.SDR DALA2015091005549Pan · dentedA DENT WAS FOUND ON THE RT FWD OVERWING EMERGENCY DOOR PAN. REPAIRED IAW ERA 537797-14, REV ORIGINAL.SDR DALA2015091005548Pan · dentedA DENT WAS FOUND ON THE RT AFT OVERWING EMERGENCY DOOR PAN. REPAIRED IAW ERA 537798-14, REV ORIGINAL.SDR DALA2015091005547Skin · damagedAFT CARGO BARRIER DOOR REPAIR DOUBLER ON INBD SKIN LOOSE. REPAIRED IAW ERA 094625-14MA, REV 0.SDR DALA2015091005546Fuse · failedMAINTENANCE FOUND EMERGENCY LIGHTS FROM ROWS 31 - 36 INOPERATIVE. REPLACED THE FUSE ON POWER PACK B5-212.SDR DALA2015091005544Cargo Track · corrodedTHE CARGO TRACK HAS CORROSION BETWEEN BS 1003 - 1322. REPLACED IAW SRM 51-30-1.SDR DALA2015091005540Frame · crackedACFT HAS A CRACKED FRAME WEB BS 1437, LONGERON 10R. FRAME WEB WAS REPAIRED IAW SRM 53-01, FIG. 2.SDR DALA2015091005538Cusp Web · corrodedACFT HAS CORROSION ON RT CUSP WEB BS 629 - 712. CUSP WEB WAS REPLACED IAW SRM 53-05, FIG 131A-24, SHEET 1.SDR DALA2015091005537Web · crackedCRACKED WEB ON LT INTERNAL PYLON STRUCTURE BS 1386 AND X 68. THE WEB WAS REPAIRED IAW SRM 54-01, FIG 2.SDR DALA2015091005536Access Panel · delaminatedDELAMINATION ON RT SECONDARY ACCESS PANEL 1410C ON RT WING. THE ACCESS PANEL WAS REPAIRED IAW ERA NR 530866-14MA REV ORIGINAL.SDR DALA2015091005535Bushing · corrodedACFT HAS CORROSION ON BUSHINGS OF T/E RT WING UPPER SKIN FROM AFT BOLTS HEATER BLANKET. REPAIR WAS ACCOMPLISHED IAW ER/A 537750-14, AD REV. A AND ETI-88-15-291, REV. 2.SDR DALA2015091005533Fastener · missingLOOSE AND MISSING FASTENERS, TWO ROWS ABOVE AND TWO ROWS BELOW THE SPLICE AT ZFS=52.267, LT/RT SIDE. FASTENERS WERE REMOVED AND FASTENERS WERE INSTALLED IAW SRM 51-30-1, REPAIR WAS ACCOMPLISHED IAW ETI-88-15-319, REV 2, ERA 477118-14AD, REV B.SDR DALA2015091305610Cusp Web · corrodedCRACK FOUND ON CUSP WEB BETWEEN BS 903 - 916, BETWEEN X -50 AND X -60. WEB WAS REMOVED. CRACK WAS STOPPED, REPAIR IN CUSP WEB WITH DOUBLER AND FILLER WERE FABRICATED, TREATED, PAINTED AND INSTALLED IAW SRM 51-30-5, 53-01 FIG 2, 53-05, FIG 131A, 51-10-3 FOR 1SDR DALA2015091105542Connector · burnedCREW NOTICED AN ELECTRIC SMOKE ODOR IN CABIN AND COCKPIT JUST BEFORE BOARDING. MAINTENANCE FOUND A BURNED LIGHT CONNECTOR OVER SEAT 28ABC AND REPLACED THE BULB, BULB HOLDER AND BALLAST ASSY.SDR DALA2015091005545Seat Track · corrodedCORROSION FOUND ON SEAT TRACK X 22, BS 199 - 227. SECTION OF THE SEAT TRACK WAS REPLACED IAW SRM 53-05, FIG 4F.SDR DALA2015091005543Vane · wornTHE RIGHT WING TE FLAP VANE HAS WEAR ON THE REPAIR DOUBLER. REPAIRED IAW SRM 57-03D, PAR II.SDR DALA2015090905507Lanyard · brokenFLIGHT CREW FOUND GIRT BAR LANYARD AT L1 DOOR BROKEN. MAINTENACE INSTALLED A NEW LANYARD.SDR DALA2015090905505Pan · crackedACFT HAS CRACK ON PAN OF R1 DOOR LOCATION. LOWER HINGE AREA APPROXIMATELY. INTERNAL STRUCTURE. PERFORMED REPAIR ON PAN OF R1 DOOR LOCATION. LOWER HINGE INTERNAL STRUCTURE IAW SRM 51-30-2, SRM 51-10-2, SRM 52-03, D FIGURE 3, SRM 51-10-3 PAR 14 AND 21.SDR DALA2015090905503Cusp Web · damagedACFT DUE TO EXCESSIVE BLENDING, WORN OUT ON CUSP WEB, UNDER SEAT TRACK X=-54 BETWEEN BS 1136 - 1155. CUSP WEB WAS REPAIRED IAW SRM 53-05, 51-30-1, 51-30-2, 51-30-5, AND 51-10-3.SDR DALA2015090905502Stiffener · crackedACFT HAS A CRACK ON STIFFENER END, BETWEEN PROJECTION LONGERON 12LT AND 11LT AT PRESSURE BULKHEAD BS 1338. STIFFENER END WAS REPLACED IAW SRM 51-30-1, 51-30-5, SRM 51-10-4, AND 51-10-3 PAR 14, 21.SDR DALA2015090905501Floor Panel · corrodedACFT HAS CORRODED FERRULES ON PAX CABIN FLOOR PANEL. FABRICATED IAW AMM 53-20-01-201. REPLACED IAW AMM 53-20-01-201.SDR DALA2015090905500Bushing · corrodedACFT HAS CORROSION ON RT MLG SUPPORT FITTING BUSHING BORE. DAMAGE ON BUSHING BORE WAS REPAIRED IAW DWG SR09570087, NOTE 11, REV. B.SDR DALA2015090905499Fitting · corrodedACFT HAS CORROSION ON LT MLG SUPPORT FITTING BUSHING BORE. DAMAGE ON BUSHING BORE WAS REPAIRED IAW DWG SR09570087, NOTE 11, REV. B.SDR DALA2015090905498Floor Panel · corrodedACFT HAS EXCESSIVE CORROSION ON FLOOR PANEL 160G. FLOOR PANEL 160G WAS REPLACED IAW SRM 51-10-2, 51-10-4, DWG 9957828, REV AB.SDR DALA2015090905497Door · crackedACFT HAS CRACKED SLAT TRACK DOOR NR 13 AND NR 14 AT LT WING. SLAT TRACK DOOR NR 13 AND 14 WERE FABRICATED IAW ER/A 512356-14MA REV. ORIGINAL.SDR DALA2015090905496Skin · damagedACFT HAD LIGHTNING STRIKE FUSELAGE BS 400 LONGERONS 1-2R. LONGERON AND SKIN WAS REPAIRED WITH PERMANENT REPAIR IAW SRM 53-04-2, FIG 2, SHEET 26 AND 53-02, FIG 18.SDR DALA2015090905495Longeron · crackedHAS CRACKED LONGERON 16L, BS 1437 AT AFT ACCESORY COMPARTMENT. LONGERON WAS REPLACED IAW SRM 53-14-4 AND 51-30-2, 51-30-5.SDR DALA2015090905494Longeron · crackedACFT HAS A CRACK ON LONGERON 16R, BS 1437 AT AFT ACCESSORY COMPARTMENT. LONGERON WAS REPLACED IAW 53-14-4, 51-30-2, 51-30-5.SDR DALA2015090905493Longeron · crackedCRACKED LONGERON 4L, BS 200 AT CABIN PAX. THE LONGERON WAS REPLACED IAW SRM 53-02, FIG 18, 51-30-2 AND 51-30-5.SDR DALA2015090905504Frame · crackedACFT HAS A CRACKED FRAME BS 1322 AND LONGERON 17L. DAMAGE WAS REMOVED, REPAIR PARTS WERE FABRICATED, TREATED, PAINTED AND INSTALLED IAW ER/A 493697-14MA, REV B.SDR DALA2015090805476Cap · crackedOUTER CAP HAS A CRACK BETWEEN LONGERONS 1 - 2L, BS 1437. LOWER OUTER CAP WAS REPAIRED IAW ER/A NR 537773-14, REV ORIGINAL.SDR DALA2015090805475Angle · crackedCRACKED ANGLE ON INTERNAL STRUCTURE OF RT AFT OVERWING EMERGENCY DOOR NR 10 STOP FITTING. A NEW ANGLE WAS INSTALLED IAW DWG 9957735, REV G, SRM 51-10-2, 51-10-4, 51-10-2, PARA 14 & 21, 51-30-2 AND 51-30-5.SDR DALA2015090705474Hinge Bracket · crackedRT ELEVATOR NR 6 HINGE BRACKET CRACKED. REPLACED IAW DWG SR09550030 REV C.
Back to Mcdonnell Douglas MD-88