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 DALA2016011500368Frame · crackedTAIL INTERIOR, AFT CANTED FRAME BS 1510 HAS .5" CRACK AT TAIL CONE ALIGNMENT PIN, 8 O`CLOCK. REPAIRED IAW ERA497316-14MA, REV ORIGINAL.SDR DALA2016011500366Cusp Web · puncturedPUNCTURED CUSP WEB AT BS 758 APPROXIMATELY AND X=-54 CABIN PASSENGER CUSP WEB WAS REPAIRED IAW SRM 51-10-3, PAR 14 AND 21, 53-05 FIG 131A-2, 51-30-2, SEAT TRACK WILL BE INSTALLED WITH CARD NR 309, ZONE 201 AND CIC BE APPLYED WITH CARD 18, ZONE 201.SDR DALA2016011500365Cusp Web · crackedCRACK ON LT CUSP WEB BS 592-595, X=-54 AT FLOOR STRUCTURE IN REF CARD 56, ZONE 201. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2016011500364Rib · corrodedCORROSION ON FWD AND AFT HOLES OF RIB IN BS XOS=380 AT RT SLAT NR 3. CARD 14, ZONE 12. HOLES OF RIB WERE REWORKED, REAMED, MEASURED ID 1.123" ON HOLE FWD AND 1.1235" ON HOLE AFT, TREATED AND REPAIRED IAW SRM 57-02, PAR 9, 51-10-3, PAR 21 AND 51-30-10, PAR 7.SDR DALA2016011500363Access Panel · corrodedCORROSION ON FUEL ACCESS DOOR COUNTERSINK/SETTLEMENT AREA NR 1466C AT RT WING. CARD 323, ZONE 100. FUEL ACCESS 1466C WAS REMPLACED IAW SRM 51-22-2A.SDR DALA2016011500362Longeron · crackedCRACK LONGERON 11R WITH FRAME, BS 1380. CARD 07, ZONE 61. LONGERON WAS REPLACED IAW SRM 51-30-2, 53-14-4, 51-30-5, 51-10-4 AND 51-10-3, PAR 14 AND 21.SDR DALA2016011500361Skin · dentedPROTUBERANCE ON, BETWEEN LONGERON 24RT AND 25RT BS 168 AT OUTER FUSELAGE SKIN. THIS DAMAGE WAS FOUND WITH PREVIOUS REPAIR IAW SRM 53-04-2, FIG 2, SHEET 3.SDR DALA2016011400303Channel · crackedCRACKED CHANNEL OF FLOOR PANEL. FLOOR PANEL REPAIRED IAW SRM 53-05, FIG 131B, AND SRM 51-70-1D PAR 10. HFEC INSPECTION WAS ACCOMPLISHED NO CRACKS FOUND AFTER STOP DRILL.SDR DALA2016011400302Longeron · crackedCRACKED LONGERON 13L BS 1437. THE LONGERON WAS REPLACED IAW SRM 53-14-4 AND 51-30-2 AND 51-30-5.SDR DALA2016011400305Beam · crackedCRACKED FWD EDGE OF BEAM, NR 4 AT FWD SERVICE DOOR. BEAM WAS REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-5.SDR DALA2016011400304Door Frame · crackedCRACK ON ELECTRONIC EQUIPMENT DOOR FRAME AT BS 146 AND LONG 27 LT. DOOR FRAME WAS REPAIRED IAW SRM 53-01, FIG 2.SDR DALA2016011400301Longeron · crackedCRACK ON LONGERON 4 LT BS 541 AT CABIN STRUCTURE. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18, 51-30-2 AND 51-10-3 PAR 14, 21.SDR DALA2016011400300Skin · crackedCRACK ON FUSELAGE SKIN BS 1480. THE SKIN WAS REPAIR IAW SRM 53-01.SDR DALA2016011400299Cusp Web · crackedCRACKED RT CUSP WEB X -44 TO X -54, BS 1079. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13 AND 51-30-2.SDR DALA2016011400298Bushing · corrodedCORROSION ON T/E BUSHINGS AT RT WING HEATER BLANKET AREA. BUSHINGS WERE REPLACED IAW PS 900-9-1, NR 6 AND SRM 51-30-10.SDR DALA2016011400297Cusp Web · crackedCRACKED RT CUSP WEB X -54 TO X -60, BS 994 TO 996. REPAIRED IAW SRM 53-05, FIG 131A-13, 51-30-2 AND 51-10-3 PAR 14 AND 21.SDR DALA2016011400296Tab · dentedSEVERAL DENTS ON GEAR TAB LT ELEVATOR. DENTS ON GEARED TAB WERE REPAIRED IAW SRM 55-04.SDR DALA2016011400295Skin · corrodedCORROSION ON INTERNAL FUSELAGE SKIN, BELLY DRAIN AREA, FROM BS 725 TO 731 BETWEEN LONGERON 30 AND LONGERON 29 RT AT MID CARGO COMPARTMENT. CORROSION WAS REMOVED IAW SRM 51-10-3, PAR 26 AREA WAS REPAIRED IAW ETI-88-16-004. REPAIR IAW ER/A 541602-14 REV ORIGINSDR DALA2016011400293Door · crackedCRACK ON RT SLAT TRACK DOOR NR 1 AND 13. SLAT TRACK DOOR NR 1 AND 13 WERE FABRICATED IAW ER/A 512356-14MA REV ORIGINAL.SDR DALA2016011400292Rib · crackedCRACKED RIB ON RT WING L/E AT BS XRS 339 APPROXIMATELY. RIB WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016011400291Floor Panel · puncturedPUNCTURES ON FLOOR PANEL OF PASSENGER CABIN. FLOOR PANEL WERE FABRICATED IAW AMM 53-20-01-201.SDR DALA2016011300242Access Panel · corrodedCORROSION AT SETTLEMENT AND COUNTERSINK AREAS OF FUEL ACCESS PANEL 1361C. ACCESS DOOR 1361C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011300241Access Panel · corrodedCORROSION AT COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1464C. FUEL ACCESS DOOR 1464C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011300240Access Panel · corrodedCORROSION ON SETTLEMENT OF FUEL TANK ACCESS 1307C. DUE TO ACCESS DOOR WAS FOUND WITH COUNTERSINK OUT OF LIMITS.SDR DALA2016011300239Access Panel · corrodedCORROSION AT SETTLEMENT AREA OF FUEL TANK PANEL 1303C. FUEL ACCESS DOOR 1303C WAS REPLACED IAW IPC 57-30-00 ITEM 147.SDR DALA2016011300238Access Panel · corrodedCORROSION AT COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1311C. DOOR IS OUT LIMITS AND IT WAS REPLACED IAW IPC 57-30-00 AND SRM 51-22-2A.SDR DALA2016011300237Membrane · crackedCRACK ON MEMBRANE BS 216, X=-42 AT CABIN FLOOR STRUCTURE. MEMBRANE WAS REPLACED IAW SRM 51-30-2, SRM 53-14-1, FIG 11, SRM 51-10-4, SRM 51-10-3 PAR 14 & 21, SRM 51-30-5, AND SRM 51-30-8.SDR DALA2016011300236Guide Vane · wornWEAR ON PREVIOUS REPAIR DOUBLER OF INBD GUIDE VANE BS XFLS 152 AT RT OTBD FLAP. INBD GUIDE VANE BS XFLS 152 AT RT OTBD FLAP WAS REPAIRED IAW SRM 57-03-11-D AND CARD 2000-8149-06, JOB 000-0014. GUIDE VANE WAS REMOVED TO FACILITATE. IT'S REPAIR AND REINSTALLSDR DALA2016011300235Access Panel · corrodedCORROSION AT COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1409C. ACCESS DOOR 1409C WAS REPLACED IAW IPC 57-30-00, ITEM 147.SDR DALA2016011300234Skin · dentedE/E DOOR OUTER SKIN WITH 2 DENTS BS 137 BETWEEN 29-30R AND BS 141 BETWEEN 29-30L. BOTH AREA IN CONDITION 1B THEREFORE THOSE AREA WITHIN LIMITS IAW SRM 53-04-1 IAW 7E.SDR DALA2016011300233Access Panel · corrodedCORROSION ON COUNTERSKIN AND SEATING AREA OF FUEL ACCESS PLATE NR 1303C. FUEL ACCESS DOOR NR 1303 WAS REPLACED IAW SRM 51-22-2A AND WILL BE INSTALLED UNDER CARD 2800-0120 JOB 001-0451.SDR DALA2016011300232Cusp Web · crackedCRACKED RT CUSP WEB ON BS 807 BETWEEN X=-54 TO -60, CUSP WEB WAS REPAIRED IAW SRM 53-03, FIG 131A.SDR DALA2016011200207Girt Bar · detachedDURING A FORCASTED SLIDE DEPOYMENT, CVG MAINTENANCE FOUND THAT THE L1 DOOR EMERGENCY ESCAPE SLIDE DID NOT DEPLOY DUE TO THE VELCRO TABS AT THE GIRT BAR BEING UN-ATTACHED. A NEW SLIDE WAS INSTALLED AT POSITION L1; REF LOG SHEET 2305013.SDR WX0A201601213069Engine · stalledDURING CLIMB NR 2 ENGINE HAD COMPRESSOR STALLS. PERFORMED QRH 72.8, STALLS STOPPED, CONTINUED FLIGHT. NR 2 ENGINE HAD LOW EPR & N1W & HIGH EGT & EQUAL N2. R & R RT ENGINE.SDR DALA2016011200231Guide Vane · wornWEAR ON OTBD FLAP GUIDE VANE OUTER SKIN AT LT OTBD FLAP. OTBD FLAP GUIDE VANE OUTER SKIN AT LT OTBD FLAP WAS REPAIRED IAW SRM 57-03D, PAR 11 AND CARD 200-8149-07.SDR DALA2016011200210Beam · crackedCRACKED BEAM NR 2 ON FWD EDGE OF FWD MAIN ENTRANCE DOOR. BEAM NR 2 ON FWD EDGE OF FWD MAIN ENTRANCE DOOR WAS REPAIR IAW SRM 52-05. FIG. 99, SHEET 3.SDR DALA2016011200209Cusp Web · crackedCRACK CUSP WEB AT BS 199 X=-22 AT CABIN PASSENGER LIGHT. SUPPORT WAS REMOVED TO ATTEND WEB REPAIR THEN WEB WAS REPAIRED IAW SRM 53-01, FIG 4. FINALLY FLOOR SUPPORT WAS INSTALLED IAW SRM 51-30-2.SDR DALA2016011200208Access Panel · corrodedCORROSION AT SETTLEMENT AREA OF FUEL ACCESS PANEL 1367C. FUEL ACCESS DOOR WAS REPLACED. IAW SRM:51-22-2A AND IPC:57-30-00.SDR DALA2016011200204Access Panel · damagedELONGATED HOLES 2 EA AND PUNCTURE ON COUNTER SINK HOLE AT FUEL ACCESS PLATE 2301C. FUEL ACCESS DOOR 2301C WAS REPLACED IAW SRM 51-22-2A AND WILL BE INSTALLED UNDER CARD 5730-0655 JOB 001-0479.SDR DALA2016011200203Access Panel · corrodedCORROSION ON COUNTER SINK AND SEATING AREA OF FUEL ACCESS PLATE NR 1409C. FUEL ACCESS DOOR NR 1407C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016011200202Cusp Web · damagedPERFORATED CUSP WEB IN BS APPROXIMATELY 168.750 AND 200 X=58 RT. CUSP WEB WAS REPAIRED IAW SRM 51-30-2, SRM 53-01, FIG 4, SH 4, SRM 51-10-3, PAR 14, 21, SRM 51-30-5.SDR DALA2016011200201Longeron · crackedCRACKED LONGERON NR 16, LT BS Y=1437. LONGERON 16 LT WAS REPLACED IAW SRM 53-14-4, FIG 4.SDR DALA2016011200200Floorbeam · corrodedCORROSION ON FLOOR SUPPORT IN BS=1320 BETWEEN LONGERON 27 LT - 27 RT AT AFT CARGO COMPARTMENT. CORROSION WAS REMOVED DUE TO THE REWORKED AREAS WERE OUT OF LIMITS SUPPORT WAS REMOVED REPAIRED AND INSTALLED IAW SRM 51-10-3, PAR 26, 14 AND 21, 51-30-2, 51-30-5,SDR DALA2016011200199Cusp Web · crackedCRACKED LT CUSP WEB BS=266 AND X=58 AT PAX CABIN, REF: CARD 70 ZONE 201. CRACKED LT CUSP WEB BS=266 AND X=58 WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2016011100198Floorbeam · corrodedCORROSION ON FLOOR SUPPORT IN BS=1231 BETWEEN LONGERON 28, LT-28, RT AT AFT CARGO COMPARTMENT. SUPPORT WAS REMOVED, NEW SUPPORT WAS ADJUSTED DRILLED, TREATED AND PAINTED IAE. ER/A 413029-14MA, REV D.SDR DALA2016011100158Cusp Web · crackedCRACK ON CUSP WEB BS 218 TO BS 229 BETWEEN X=-54 TO X=-60 AT CABIN PASSENGER. CUSP WEB WAS REPLACED IAW SRM 51-10-3, PAR 14 & 21, 51-30-1, 51-30-2, 51-30-5.SDR DALA2016011300243Vane · debondedDISBONDED MATERIAL AND PUNCTURE ON RT INBD FLAP INBD VANE. DAMAGE ON RT INBD FLAP INBD VANE EXCEED FOR REPAIR LIMITS IAW SRM 57-03D, PARR II THEREFORE WAS REPLACED WITH REPAIRED RT INBD FLAP INBD VANE.SDR DALA2016011200206Frame · damagedELONGATED HOLES ON FRAME CLIP BS 1338 BETWEEN LONGERON 26LT TO 27LT AT AFT CARGO COMPARTMENT. THIS NRC WAS REPAIRED WITH ER/A 541598-14, REV ORIGINAL.SDR DALA2016011100161Pan · crackedCRACKS ON LT WINDOWS RING PAN AT LWR AFT CORNER BETWEEN ST 731-712, 769-788, 807-826, ST 886-905. RING PANS WAS REPAIRED IAW SRM 53-05, FIG 122, SRM 51-10-3, PAR 14, 24, SRM 51-30-2, 51-30-5, ERAS 487747-14MA, REV "A" AND 493645-14MA, REV "A".SDR DALA2016011100160Pan · crackedCRACK ON LT WINDOWS RING PAN AT LOWER FWD CORNER BETWEEN ST 1022-1041, ST 1041-1060. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122, SRM 51-10-3 PAR 14, 21, SRM 51-30-2, 51-30-5, ER/A 487747-14MA, REV "A" AND 493648-14MA, REV "A".
Back to Mcdonnell Douglas MD-88