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 DALA2015040902715Frame · crackedCRACKED FORMER ON AFT PRESSURE BULKHEAD FS Y=1338 PROJECTION LONGERON 7R. FORMER WAS REPLACED IAW SRM 51-30-1, 51-30-2 AND 51-30-5. LP 1896855.SDR DALA2015040802698Floor Panel · crackedCRACKED STIFFENERS OF FLOOR PANEL. STIFFENERS OF FLOOR PANEL REPAIRED IAW SRM 53-05, FIG 131C.SDR DALA2015040702639Access Panel · corrodedCORROSION ON FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1303C. FUEL TANK ACCESS PANEL 1303C WAS REPLACED IAW SRM 51-22-2A, STEP 6, PAR B. LP 1893796SDR DALA2015040702638Access Panel · corrodedCORROSION ON FAYING SURFACE AT RT FUEL TANK ACCESS PANEL 1409C. FUEL TANK ACCESS PANEL 1409C WAS REPLACED IAW SRM 51-22-2A, STEP 6, PAR B.SDR DALA2015040702637Skin · damagedELONGATED HOLES ON UPPER, LOWER SKIN AT LT WING TIP. ELONGATED HOLES ON UPPER, LOWER SKIN REPAIR IAW EA 09-478904-14MA, SECTION 2, PAGE 2 AFT MOUNT HOLES REPAIR. LP 1893532SDR DALA2015040702636Skin · damagedELONGATED HOLES ON UPPER, LOWER SKIN AT RT WING TIP. ELONGATED HOLES ON UPPER, LOWER SKIN REPAIR IAW EA 09-478904-14MA SECTION 2, PAGE 2. AFT MOUNT HOLES REPAIR.SDR DALA2015040702635Cusp Web · corrodedCORROSION ON RT CUSP WEB STA Y=604-606, BETWEEN X=-54 TO X=-60. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13 AND SRM 51-10-3, PAR 14, 21, 38, SRM 51-30-2.SDR DALA2015040702632Cargo Track · corrodedCORROSION ON LT TIE TRACK FROM BS Y= 1222 TO Y= 1250 UPPER AND LOWER SURFACES AFT CARGO BAY. DUE EXCESSIVE CORROSION ON TIE TRACK WILL REPLACED. NEW TIE TRACK WAS INSTALLED IAW SRM 51-10-4 AND DWG 5936660.SDR DALA2015040702631Cargo Track · corrodedCORROSION ON LT TIE TRACK FROM BS Y=1007 TO Y= 1231 AT AFT CARGO COMPARTMENT. DUE TO EXCESSIVE CORROSION ON TIE TRACK. LT TIE TRACK WAS REPLACED IAW SRM 51-10-4 AND IPC 25-50-00.SDR DALA2015040702630Cargo Track · corrodedCORROSION ON LT TIE TRACK SPLICES BOTH SIDES UPPER AND LOWER SURFACES BETWEEN BS Y= 1214 AND Y= 1226 AT AFT CARGO. CORROSION WAS REMOVED AND NEW SPLICES WERE MANUFACTURED AND INSTALLED IAW DWG 5936660, REV BV, SRM 51-10-3, PARS 21 & 14 AND 51-30-5. LP 1892SDR DALA2015040902716Channel · crackedCRACKS ON CHANNEL STA Y=953 AT LT MLG INBD DOOR. FASTENERS WAS REMOVED, CRACK WAS STOP DRILL AND DOUBLER REPAIR WAS FABRICATED, TREATED AND PAINTED IAW SRM 51-30-2, 52-05, FIG 6, 51-10-3, PAR 14/21 AND INSTALLED IAW SRM 52-05, FIG 60. LP 1896870.SDR DALA2015040702634Door Frame · wornWEAR ON ANGLE TEE AND SETTLEMENT STRIP OF RT AFT MLG DOOR JAMB STA XCW=60. ANGLE "T" AND RUBSTRIP WERE REPLACED BY NEW ANGLE AND STIP IAW SRM 51-30-2 , 51-30-5 , 53-14-3. LP 1893020SDR DALA2015040702633Floorbeam · corrodedCORROSION ON FRAME TEE BS Y=1380 BETWEEN X=15 TO X=-15 AT A/A. TEE FRAME WAS REPLACED IAW D. DWG 9912246, REV DE AND SRM 51-10-3/51-30-2/51-30-5/51-30-1 AND 51-10-4.SDR DALA2015040602628Wire · looseDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 26D IN THE CABIN WAS INOPERATIVE. MAINTENANCE CORRECTED A LOOSE CONNECTION AND THEN OPERATIONALLY CHECKED THE SYSTEM. LP 6721008SDR DALA2015040602627Connector · failedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS AT ROW 4C, 24E, 28E, AND 33E IN THE CABIN WERE INOPERATIVE. MAINTENANCE FOUND A FAILED CONNECTOR IN THE WIRE HARNESS AND REPLACED IT. THE FUNCTIONAL CHECK OF THE SYSTEM WAS GOOD. LP 1892209SDR DALA2015040602611Support · brokenBROKEN LT SLANT SUPPORT BS 1271 AT AFT CARGO BAY. SLANT SUPPORT WAS REPLACED IAW DAL ER/A 413029-14MA, REV D.SDR DALA2015040602610Support · brokenBROKEN RT SLANT SUPPORT BS 1136 AT AFT CARGO COMPARTMENT. SLANT SUPPORT WAS REPLACED IAW ER/A 413029-14MA, REV.D.SDR DALA2015040502607Access Door · wornWORN ELEVATOR ACCUMULATOR ACCESS DOOR AT AFT ACCESSORIES COMPARTMENT. ACCESS DOOR WAS REPLACED. LP 1891517SDR DALA2015040802673Pan · crackedCRACKED PAN BELOW FWD STOP NR 3 AT FWD CARGO BAY DOOR, C1. CRACK WAS STOPPED, DOUBLER WAS FABRICATED, TREATED, PAINTED AND INSTALLED IAW SRM 52-05, FIG 50, 51-10-2 , 51-10-3, PAR 21 AND 14 , 51-30-1 , 51-30-2. CRACK LONG: 750". LP 1894575.SDR DALA2015040602629Wire · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 24D IN THE CABIN WAS INOPERATIVE. MAINTENANCE FOUND A BROKEN WIRE IN THE CONNECTOR. THE CONNECTOR WAS REPAIRED AND THE SYSTEM RETURNED TO NORMAL OPERATION. LP 6466124SDR DALA2015040602609Bulkhead · crackedCRACKED BULKHEAD BS 1437 AND 10 HRS POSITION. BULKHEAD WAS REPAIRED IAW ERA 519146-14MA, REV A.SDR DALA2015040502606Doubler · wornWORN INTERNAL PRODUCTION DOUBLER ON ELEVATOR. ACCUMULATOR ACCESS CUTOUT AT AFT ACCESSORIES COMPARTMENT. DOUBLER WAS REPLACED IAW SRM 51-30-2, DWG 5917686, REV AA ON ELEVATOR ACCUMULATOR ACCESS CUT OUT AT AFT ACCESSORIES COMPARTMENT.SDR DALA2015040502605Longeron · crackedCRACKED LONGERON 4 LT AT BS 200. LONGERON REPLACED IAW SRM 51-30-5, 53-14-1, FIG 3.SDR DALA2016111108849Cusp Web · corrodedLEFT CUSP WEB CORROSION BS 522-533, 541-560, 737-747, LBL 54 TO 60. DAMAGE REMOVED, REPAIR DOUBLER INSTALLED.SDR DALA2015040402602Access Panel · corrodedCORROSION ON HOLE, COUNTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1355C. CORROSION ON HOLES COUNTERSINK ACCESS PANEL 1355C WAS REMOVED. THE MAX DIAMETER ALLOWED IS 0.532 AND FOUND 3 HOLES ADJACENT WITH 0.572, 0.547 AND 0.565. THE MAX BUSHING PSDR DALA2015040402601Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1357C. CORROSION ON HOLES COUNTERSINK ACCES PANEL 1357C WAS REMOVED. THE MAX DIAMETER ALLOWED IS 0.532 AND FOUND 3 HOLES DAMAGED ADJACENT WITH .554, .551 AND .538.
THE MAX BUSHSDR DALA2015040402600Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1379C. CORROSION ON HOLES COUNTERSINK AT FUEL TANK ACCESS PANEL 1379C WAS REMOVED. THE MAX DIAMETER IS 0.532 AND FOUND 3 HOLES ADJACENT WITH 0.537, 0.536 AND 0.537. THE MAX BUSHISDR DALA2015040402599Skin · crackedCRACK ON RACKS COWLING EXHAUST AT FUSELAGE SKIN BETWEEN BS Y= 256-275 AND LONGS 20 LT TO 21 LT. REPAIRED WITH WELD IAW ER /A 464964-14, REV "C". LP 1889906.SDR DALA2015040502604Door Frame · crackedCRACKED FITTING STOPS 2, 3, 5 ON FWD FRAME CUTOUT OF C2 DOOR. STOP FITTINGS WERE REMOVED IAW SRM 51-30-1 AND 51-30-5 , STOPS FITTINGS WERE DRILLED IAW SRM 51-10-4, NEW STOP FITTINGS WERE TREATED AND PAINTED IAW SRM 51-10-3, PAR 21 AND 14 , NEW STOP FITTINGS WSDR DALA2015040902728Seat Track · corrodedPITTING CORROSION ON PLUG AT LT SEAT TRACK X= 22, FS Y= 701-704. PLUG WAS REMOVED, AND NEW PLUG WAS INSTALLED IAW SRM 53-5, FIG 4A. LP 1892451.SDR DALA2015040502608Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1367C. CORROSION ON HOLE COUNTERSINKS AT FUEL TANK ACCESS PLATE, 1367C WAS REMOVED. THE MAX DIAMETER ALLOWED IS .532 AND FOUND 3 HOLES DAMAGE ADJACENT WITH .539, .535 AND .550 ANDSDR DALA2015040502603Door Frame · crackedCRACKED FITTINGS STOPS 2, 4, 5 ON AFT FRAME CUTOUT OF C2 DOOR. SUMMARY:STOPS FITTING WERE REMOVED IAW SRM 51-30-1 AND 51-30-5 , STOP FITTINGS WERE DRILLED IAW SRM 51-10-4 , STOPS FITTING WERE TREATED AND PAINTED IAW SRM 51-10-3, PAR 21 AND 14 , STOP FITTINGS SDR DALA2015040402598Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS NR 1361C. FUEL ACCESS 1361C WAS REPLACED. LP 1889493.SDR DALA2015040302597Longeron · crackedCRACK ON LONGERON 4L BS 160 AND 200 AT PAX CABIN. LONGERON REPLACED IAW SRM 53-02, FIG 18, 51-30-2 AND 51-30-5.SDR DALA2015040202595Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1377C. CORROSION ON HOLES COUNTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1377C WAS REMOVED THE ACCESS PANEL WAS OUT LIMIT THEN THE ACCESS PANEL WAS REPAIRED WITH BUSHSDR DALA2015040202594Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT CENTRAL FUEL TANK ACCESS PANEL 2302C IN REF CARD 5, ZONE 10. CORROSION ON HOLES COUNTERSINK AT FUEL TANK ACCESS PLATE 2302C WAS REMOVED AND WAS REPAIRED WITH BUSHING. LP 1886912.SDR DALA2015040202593Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AT LT FUEL TANK ACCESS PANEL. CORROSION ON HOLES COUNTERSINKS AT LT FUEL TANK ACCESS PANEL 1371C WAS REMOVED. THE ACCESS PANEL WAS OUT LIMITS THEN THE ACCESS PANEL WAS REPAIRED WITH BUSHINGS. LP 1886884SDR DALA2015040202592Frame · corrodedCORROSION ON FRAME PREVIOUS REPAIR BS Y= 1309 AT AFT CARGO COMPARTMENT. REPAIR PART WITH CORROSION WAS REPLACED IAW SRM 53-03 "D" FIG 2.4. IT WAS TREATED AND PAINTED IAW SRM 51-10-3 PAR 14, 21. LP 1886319SDR DALA2015040202591Intercostal · corrodedCORROSION ON INTERCOSTAL STA Y=1310 BETWEEN LONGERON 27LT-28LT AT AFT CARGO COMPARTMENT. REPAIR PARTS WERE FABRICATED, DAMAGE ON INTERCOSTAL WAS REMOVED, FABRICATED REPAIR PARTS WERE TREATED AND PAINTED, REPAIR PARTS WERE INSTALLED, INTERCOSTAL WAS INSTALLEDSDR DALA2015040202590Longeron · crackedCRACKED LONGERON 2 LT AT STA Y=200, SM. SECTION DAMAGE FROM BS Y=150 TO Y=307 WAS R & R IAW SRM 53-02, FIG 18, NEW SECTION OF LONGERON WAS ADJUSTED, DRILLED, TREATED & PAINTED IAW SRM 51-10-3, PAR 21 & 14, 51-10-1, 51-30-2 AND 51-30-5, AND 53-02, FIG 18.SDR WX0A2015040272507Battery · dischargedAFT OVERHEAD EMER EXIT LIGHTS INOPERATIVE. REPLACED BATTERIES IN BATTERY PACK. OPERATIONS CHECKED GOOD IAW AMM 33-53-00.SDR DALA2015040202596Seat Track · corrodedCORROSION ON PLUG ON LT SEAT TRACK X=22 AT Y=879 PAX CABIN, SM CARD 35, ZONE 201. PLUG WAS REPLACED IAW SRM 53-05, FIG 4A. LP 1887253SDR DALA2015040102550Doubler · wornWEAR LOWER FWD AND AFT EXTERNAL DOUBLER AT FWD CARGO COMPARTMENT DOOR. NEW DOUBLER WERE INSTALED IAW SRM 51-30-2.SDR DALA2015040102549Doubler · corrodedCORROSION ON INNER PRODUCTION DOUBLER BS X=571 BETWEEN LONG 30-29 RT AT MID CARGO COMPARTMENT. CORROSION ON INNER PRODUCCTION DOUBLER BS Y= 571 BETWEEN LONGERON 30-29 RT WAS REMOVED AND REWORKED AREAS WAS TREATED AND PAINTED IAW SRM, 51-10-3 PAR.SDR DALA2015040102547Window 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 REPAIR IAW SRM 53-05, PAR 139, FIG 122, SRM 51-36-2 AND 51-30-5 AND ER/A 487747-14MA.SDR DALA2015040102546Rib · crackedCRACKED RT WING L/E RIB STA XRS 271. RIB WAS REPLACED IAW SRM 51-30-2; 51-30-5 AND DWG 9937588-4, REV G.SDR DALA2015040102545Finger Doubler · corrodedINITAL AD: CORROSION ON FINGER DOUBLER REPAIR BETWEEN STA Y=1187 TO Y= 1195 AND LONGERON 29 LT TO 30 AT AFT CARGO COMPARTMENT. DOUBLER WAS REPLACED IAW SRM 53-04-2, 51-10-3, PAR 14 AND 21, 38, 51-30-5.SDR DALA2015040102544Access Panel · corrodedCORROSION ON HOLE COUTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1361C. PLATE 1361C WAS REMOVED. THE ACCESS PLATE WAS OUT LIMITS THEN THE ACCESS PLATE WAS REPAIRED WITH BUSHINGS IAW SRM: 51-22-2A.SDR DALA2016111108850Access Panel · corrodedFUEL TANK ACCESS PANEL 1303C COUNTERSINKS CORRODED, REPLACED THE ACCESS PANEL.SDR DALA2015033102511Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT LT FUEL TANK ACCESS PANEL 1311C. THE FUEL TANK ACCESS PLATE WAS REPLACED AND WILL BE INSTALLED UNDER CARD 28:00-0120 ZONE 13 IAW AMM: 28-00-00.
Back to Mcdonnell Douglas MD-88