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 DALA2015033102513Window Frame · crackedCRACK ON FWD UPPER AND LOWER CORNERS AF WINDOW RING PAN STA Y=788 CABIN PAX LT SIDE. AREA WAS REPAIRED IAW SRM 53-05, PAR 139, SRM 51-30-2 AND 51-30-5 AND ER/A 487747-14MA REV ORIGINAL, SRM 51-10-3, PAR 14-21.SDR DALA2015033102512Window Frame · crackedCRACK ON FWD UPPER CORNER OF WINDOW RING PAN, STA Y= 845 AND Y=927 CABIN PAX LT SIDE. AREA WAS REPAIRED IAW SRM 53-05 PAR 139, 51-10-2, 51-10-3 PAR 14 & 21, 51-30-2, 51-30-5 & ER/A 487747-14MA, REV ORIGINAL.SDR WX0A2015032672485Battery · dischargedEMERGENCY LIGHTS IN TUNNEL CEILING & UPPER TWO TAIL CONE LIGHTS INOPERATIVE. REPLACED BATTERIES IN AFT POWER SUPPLY. OPERATIONS CHECKED GOOD IAW AMM 33-53-01.SDR DALA2015032502365Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM STA Y= 897 AND Y=902 BETWEEN X=-48 AND X=-60 FLOOR CABIN STRUCTURE. CORROSION WAS ATTENDED ON STA Y= 897 AND Y= 902 RT CUSP WEB IAW SRM 51-10-3 AND 53-05.SDR DALA2015032502363Support · crackedCRACKED FITTING SUPPORT STA Y=927, X=-44 AND Z=-10 AT FLOOR CABIN STRUCTURE. RT, SIDE. FITTING SUPPORT WAS REMOVED IAW SRM 51-30-1 AND 51-30-2. NEW FITTING WAS DRILLED IAW SRM 51-10-4. HOLES WERE TREATED AND PAINTED IAW SRM 51-10-3, PAR 21-14. NEW SUPPORT SDR DALA2015032502362Duct · crackedCRACKED APU EXHAUST DUCT. APU EXHAUST DUCT WAS REPAIRED, REWELDED, IAW ER/A 473221-14MA.SDR DALA2015032502361Rib · corrodedCORROSION ON BORED, INNER AND OUTER SURFACE ON RIBS FROM STA XOS=286, 332 AND 380 AT LT SLAT PANEL. DAMAGES ON RIBS STA XOS= 286; 332, 380 WERE REPAIRED IAW ER/A 533332-14, REV ORIGINAL AND ETI 88-15-104, REV 1.SDR DALA2015032502360Vane · delaminatedDELAMINATION ON LT OTBD VANE INBD FLAP BENEATH RUB STRIP INBD EDGE. DELAMINATED AREA WAS REPAIRED IAW SRM 57-03 D.SDR DALA2015032502359Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BETWEEN RT LONGERON 5 AND 6, STA Y=159. LIGHTHING STRIKE ON FUSELAGE SKIN WAS ATTENDED AND AFTER BLENDED WAS FOUND OUT OF LIMIT THEREFORE WAS REPAIRED WITH REPAIR DOUBLER AND DAMAGE WAS CUT OUT IAW SRM 53-04-1, PAR 6D, 3, CONSDR DALA2015032502358Cusp Web · corrodedCORROSION ON LT CUSP WEB UPPER AND LOWER SURFACE FROM STA Y=1250 TO Y=1271, STA Y=1271 TO Y=1287 BETWEEN X=54 TO X=60 AT CABIN FLOOR STRUCTURE. CORROSION WAS ATTENDED, REMOVED; MEASURED AND FOUND WITHIN LIMITS BETWEEN Y=1250-1271 BUT AT Y=1247 IT'S 0.035" ANSDR DALA2015032502357Seat Track · corrodedCORROSION ON RT SEAT TRACK FROM STA Y=790 TO Y=797 AND X=-54 AT CABIN FLOOR STRUCTURE. SEAT TRACK WAS REPLACED BETWEEN STA Y=701-797 IAW SRM 51-30-1; 51-10-4 AND 51-10-3, PARS 14 & 21.SDR DALA2015032602392Window Frame · crackedCRACK ON RT FWD/UPPER CORNER OF WINDOW RING PAN BETWEEN STA 598-617, 750-769 AND 927-946 AT PAX CABIN. AREA WAS REPAIRED IAW SRM 53-05, PAR 139, 51-10-3, 51-10-2, 51-30-2 AND 51-30-5 AND ERA 487747-14, MA REV ORIGINAL.SDR DALA2015032602391Window Frame · crackedCRACK ON RT AFT/LWR CORNER OF WINDOW RING PAN BETWEEN STA Y=845-894 AT PAX CABIN. AREA WAS REPAIR IAW SRM 51-30-2, 51-30-5, AND 53-05, PAR 139, FIG 122 AND ERA 487747-14MA REV ORIGINAL.SDR DALA2015032502364Diaphragm · damagedELONGATED HOLES ON DIAPHRAGM AT STA Y=160 TO Y=196, X=54 AT CABIN FLOOR STRUCTURE. DIAPHRAGM WAS REPAIRED IAW SRM 51-30-2, SRM 51-70-4, FIG 2, PAR 1, SRM 51-10-3, PAR 14, 21 SRM 51-30-5.SDR DALA2015032402331Tab · corrodedFREE PLAY, CORROSION AND SCRATCHES ON ANTI-FLOAT TAB, GEARED TAB ATTACH POINTS AT RT ELEVATOR. HARDWARE ATTACH PAINT AN ANTI-FLOAT TAB AND GEARED TAB RT ELEVATOR WAS R & R NEW HARDWARE IAW CMM 20-27-1 AND FREEPLAY WAS CORRECTED.SDR DALA2015032402329Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER AT RT CUSP WEB BETWEEN STA Y= 875 AND Y=880 ALSO BETWEEN Y=835 AND Y=841 BETWEEN X=-48 AND X=-60. CUPS WEB BETWEEN STA Y 875-880 WAS REPAIRED IAW SRM 53-05, FIG 131A-4. BETWEEN ON Y 835-Y 841 WAS ATTENDED WITH CARD 316, ZOSDR DALA2015032402328Cusp Web · corrodedCORROSION ON RT CUSP WEB STA Y=1035, 1047 AND 1071 BETWEEN X=-54 AND X=-60 AT CABIN FLOOR STRUCTURE. CUPS WEB ON Y=1035, 1047 AND 1071 BETWEEN X=-54 AND X=-60 WERE REPAIRED IAW SRM 53-05, FIG 131A-7.SDR DALA2015032402327Floor Support · crackedCRACKED FLOOR SUPPORT AT BS 965 AND 984, X=-30 TO X=-37 AT RT CABIN FLOOR STRUCTURE. CRACKED FLOOR SUPPORTS WERE REMOVED DRILLED ADJUSTED AND INSTALLED IAW SRM 51-10-3, PAR 13, 14 AND 21, SRM 51-30-5 AND 53-14-3 FIG 12, 51-10-4.SDR DALA2015032402326Cusp Web · corrodedCORROSION ON RT CABIN FLOOR CUSP WEB FROM BS 490 TO 503 BETWEEN X=-54 TO X=-60 UPPER AND LOWER SURFACE. CORROSION WAS ATTENDED IAW SRM 53-05, FIG 131A-6, 57-30-1, 57-10-3, PAR 14-21 AND 38 AND NEW DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 53-05, FIG 131 A-SDR DALA2015032402325Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1307C. CORROSION FOUND TO BE OUT OF LIMITS. ACCESS PLATE WAS REPLACED AND WILL BE INSTALLED UNDER CARD 2800-0120.SDR DALA2015032402324Angle · crackedAD INITIAL: INSPECTION: CRACK ON LOWER ANGLE FROM STA Y=650 AT MID CARGO COMPARTMENT DOOR. DAMAGE ANGLE WAS REMOVED. NEW ANGLE WAS INSTALLED IAW SRM 51-30-2.SDR DALA2015032402323Fitting · crackedAD INITIAL INSPECTION: CRACK ON LOWER INNER FITTINGS FROM STA Y= 650 AT MID CARGO COMPARTMENT DOOR. DAMAGE FITTING WAS REMOVED IAW SRM 51-30-2 AND 51-30-1. NEW FITTING WAS DRILLED, TREATED, PAINTED AMD INSTALLED IAW SRM 51-10-4, SRM 51-10-3 PAR 14/ 21, SRM 51SDR DALA2015032402322Fitting · crackedDURING AD INITIAL INSPECTION, A CRACK WAS FOUND ON UPPER INNER FITTING FROM STA Y= 650 AT MID CARGO COMPARTMENT. CRACK FITTING WAS REMOVED IAW SRM 51-30-1. NEW FITTING WAS FABRICATED, ADJUSTED AND DRILLED IAW SRM 51-10-4 NAD DWG N3926046-3. NEW FITTING WAS TSDR DALA2015032402321Floor Panel · crackedCRACK AND CORROSION ON FLOOR PANEL 160G AT PAX CABIN. FLOOR PANEL 160G AT PAX CABIN WAS REPLACED IAW SRM 51-10-3, PAR 21,14, SRM 51-10-4, DWG 9957828, REV AB.SDR DALA2015032402320Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM STA Y=1094 TO 1097 BETWEEN X=-54 AND X=-60 AT CABIN FLOOR STRUCTURE. DOUBLER REPAIR WAS FABRICATED AND TREATED, PAINTED IAW SRM 53-05 FIG 131A-10, SHEET 1 AND 51-10-3 PAR 14/21.SDR DALA2015032302319Doubler · corrodedTHE AFT LAV WATE SERVICE DR JAMB INTERNAL DOUBLER REPAIR WAS PERFORMED AT HMV4 TO REPLACE THE EXTERNAL DOUBLER AND CLEAN UP ADDITIONAL CORROSION THAT IS THEN WITHIN LIMITS. REPAIR WAS ACCOMPLISHED IAW ER/A 472127-14 REV C. SUPPLEMENTAL INFORMATION: EXTERNAL GESDR DALA2015032302307Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN STA Y=1035-1060, Y= 1071-1083, 1094-1103 X=-54 X=-60 AT CABIN FLOOR STRUCTURE. CORROSION ON RT CUSP WEB STA Y=1036-1060, Y=1071-1083 AND Y=1094-1103 WAS ATTENDED IAW DC-9/MD80 SRM 51-10-3 PAR. 14 AND 21 AND ER/A 511165-14 MA SDR DALA2015032302306Beam · crackedCRACKED BEAM N.1 FWD EDGE AT FWD SERVICE DOOR (R1). CRACKED BEAM N.1 FWD WAS REMOVED IAW SRM 51-30-2, 51-30-4 AND 51-30-5, NEW BEAM WAS INSTALLED IAW SRM 51-30-2, 51-30-4 AND 51-30-5.SDR DALA2015032302305Web · crackedCRACK ON WEB STA Y=101, X=0, Z=-8 AT INTERNAL STRUCTURE BELOW FLOOR PANEL. WEB ON STA Y= 101, X=0, Z=-8 WAS REPAIRED IAW SRM 53-01, FIG. 2.SDR DALA2015032302304Pan · crackedCRACKED INNER PAN FWD EDGE BELOW TO LOWER SECTION HINGE AT FWD SERVICE DOOR R1. CRACKED INNER PAN FWD WAS REPAIRED IAW SRM 52-03, FIG 3.SDR DALA2015032302303Angle · crackedCRACKED CLIP FWD /AFT EDGE OF BEAM N.1 LOWER SIDE AT FWD SERVICE DOOR. CRACKED CLIP FWD/AFT WERE REMOVED IAW SRM 51-30-5. NEW CLIPS WERE INSTALLED IAW SRM 51-30-5.SDR DALA2015032302302Cusp Web · corrodedCORROSION ON RT CABIN FLOOR CUSP WEB STA Y=803-804 ALSO ON DOUBLER PREVIOUS REPAIR STA Y=838-845 BTW X=-54 AND X=-60. DOUBLER PREVIOUS WAS REMOVED AND NEW DOUBLER, RIG DOUBLER, FILLER WERE FABRICATED, TREATED, PAINTED AND INSTALLED IAW FIG 131A-2, 51-10-3 PAR.SDR DALA2015032302301Intercostal · crackedCRACKED INTERCOSTAL AT STA Y=769 TO Y=788, X=0 AT CABIN FLOOR STRUCTURE. INTERCOSTAL WAS REMOVED IAW SRM 51-30-2 AND 51-30-5. NEW INTERCOSTAL WAS DRILLED IAW SRM 51-10-4. NEW INTERCOSTAL WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 14 AND 21. NEW INTERCOSTALSDR DALA2015032302300Cusp Web · corrodedCORROSION ON RT CABIN FLOOR STRUCTURE CUSP WEB STA Y= 438-440, Y=459-461, Y= 480, Y=489 BETWEEN X=-54 TO X=-60. UPPER AND LOWER SURFACES. CUSP WEB STA Y=438-440, Y=459-461 WERE REPAIRED IAW SRM 53-05, FIG 131A-13. CUSP WEB BETWEEN Y=479-484 WAS REPAIRED IAW SDR DALA2016041402903Skin · damagedREMOVED RT WINGTIP ASSY IAW AMM 57-20. REPLACED RT WING TIP ASSY IAW AMM 57-20-02. OPS CHECKED GOOD. COMPLIED WITH ER/A 534223-14, REV ORIGINAL.SDR DALA2015040102586Seat Track · corrodedCORROSION ON RT SEAT TRACK REPAIR PLUG X=-54 BETWEEN STA Y= 323-328 AND Y=429-434, SM, CARD 48 ZONE 201, SUMMARY: PLUGS WERE REMPLACE IAW SRM 53-05, FIG 4A 51-10-3 PARR. 14, 21, 38.SDR DALA2015032302311Rib · damagedDURING MAINTENANCE ACTIVITIES. DAMAGE BORES ON RIBS STA XOS 286, 332 AND 380 AT RT SLAT PANEL NR 3. DAMAGE ON RIB STA XOS=332 WAS REWORKED AND MEASURED WITH ID 0.938, 4 HOLES, THEREFORE LIMITS OF MAXIMUM REWOK HOLE DIAMETER IAW SRM 57-02, PAR 9 C (1). BUSHINGSDR DALA2015032302310Rib · corrodedINITIAL CORROSION FWD BORE ON RIB STA XOS 380 AT SLAT PANEL NR 4 RT WING. DAMAGE ON RIB STA XOS= 380 WAS REMOVED AND MEASURED, WITH ID 1.1265 ON FWD HOLE, THEREFORE OUT LIMIT OF MAXIMUM REWORK HOLE DIAMETER, THEREFORE WAS REPAIRED WITH AND ER/A 533326-14, REVSDR DALA2015032302309Rib · corrodedINITIAL CORROSION AFT BORE ON RIBS STA XOS 429 AT SLAT PANEL NR 4 RT WING. DAMAGE ON AFT BORE WAS REPAIRED IAW AND ER/A 533326-14 REV, ORIGINAL.SDR DALA2015032302308Cusp Web · corrodedCORROSION ON RT CABIN FLOOR CUSP WEB FROM STA Y=785 TO Y= 905 BETWEEN X=-48 AND X= -60 UPPER ANDLOWER SURFACES AND DOUBLER REPAIR. CORROSION WAS REMOVED IAW SRM 51-10-3 PAR 14, 21, 26. STA Y=897-902 WAS FOUND OUT OF LIMITS AND WILL BE REPAIRED WITH NRC 314 ZOSDR DALA2015032202299Angle · crackedINITIAL CRACKED FRAME CLIPS STA Y=1437 BETWEEN LONGERONS 2L-3L, 1-2R AT AFT ACCESSORIES COMPARTMENT. CLIPS WERE REPLACED IAW SRM 51-30-5, 51-30-2, 51-10-3 PAR 14 AND 21 AND DWG 9911840-112 AND 116 REV DC.SDR DALA2015032102298Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015032302294Battery Pack · inoperativeMAINTENANCE FOUND AFT SECTION OF OVERHEAD EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK IAW AMM 33-53. CKS GOOD.SDR WX0A2015032672475Wire · damagedEMERGENCY LIGHTS ALONG TAIL COMPARTMENT RAMP INOPERATIVE. WIRES BROKEN. REPAIRED DAMAGED WIRING BY R & R TERMINALS AT LIGHT L2-847 IAW SWPM 20-20-01. EMER LIGHTS TESTED GOOD IAW MM 33-53-00.SDR DALA2015032102297Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015032102296Cusp Web · corrodedCORROSION ON RT CABIN FLOOR CUSP WEB STA Y=503, Y=553 AND Y=580 BETWEEN X=-54 AND X=-60. CABIN FLOOR CUSP WEB STA Y=503, Y=553 AND Y=580 WERE REPAIRED IAW SRM 53-05, 51-10-3 PAR 14 AND 21 AND 38.SDR DALA2015032002295Connector · damagedMAINTENANCE FOUND EMERGENCY LIGHTS FROM ROWS 1-12 FLOOR LIGHTS INOPERATIVE AFTER ERA 531288-14MA WAS COMPLETED. MAINTENANCE R & R CONNECTOR PLUG P1-791 ON B5-211 IAW WDM 33-51-14 AND REPLACED B5-211 POWER SUPPLY AND BATTERY. OPS CKS NML IAW AMM 33-53.SDR DALA2015032002256Skin · damagedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND, DOUBLER REPAIR ON FUSELAGE SKIN AT BS 1418 AND BETWEEN LONG 1-3L. DOUBLER REPAIR IS ATTENDED WITH ER/A 496150-14, REV ORIGINAL AND WILL BE INSPECTED PRIOR TO REACHING 56.250 TOTAL CYCLES.SDR DALA2015032002255Structure · crackedCRACKED PREVIOUS REPAIR ON LT WING L/E PRODUCTION DOUBLER STA XRS 164. DOUBLER WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2015031902242Wire · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT SEAT 22DE IN THE CABIN WAS INOPERATIVE. MAINTENANCE FOUND WIRES BROKEN IN THE HARNESS. THE WIRE HARNESS WAS REPLACED AND THE SYSTEM RETURNED TO NORMAL OPERATION.
Back to Mcdonnell Douglas MD-88