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 DALA2016062404899Door Frame · crackedCRACKED MLG DOOR JAMB FRAME, STA Y=937 RT WHEEL WELL. JAMB WAS REPLACED IAW SRM 51-30-2 AND 51-30-5, DWG 5930584, REV.SDR DALA2016062404898Pan · crackedCRACK ON PAN FORWARD EDGE BETWEEN BEAM 4 AND 5 AT AFT SERVICE DOOR, SN 00969. CRACK ON PAN WAS REPAIRED IAW ETI-88-16-231 REV 1 AND ER/A 541548-14, REV ORIGINAL.SDR DALA2016062704946Nose Cowl · crackedCRACKED LT NOSE COWLING LIP INTERNAL STRUCTURE. SERVICEABLE NOSE COWL WAS INSTALLED IAW AMM 71-10-01-201.SDR DALA2016062404897Strap · crackedCRACKED STRAP REPAIR ON LOWER DOOR JAMB BETWEEN STA Y=1193 TO Y=1212 AT AFT CARGO DOOR JAMB C3. STRAP WAS REPLACED IAW SRM 53-05, FIG 123, SHEET 3, -9.SDR DALA2016062304888Connector · damagedDURING LINE CHECK, FOUND CABIN EMERGENCY EXIT LIGHTS INOPERATIVE, ROW 15-23. REPAIRED CONNECTOR AT ROW 15. LIGHTS NOW OPERATE NORMAL.SDR DALA2016062304879Valve · wornWEARS ON CORNERS OF RT AIR CONDITIONING DIVERTER VALVE. WEARS ON CORNERS RT DIVERTER VALVE WERE REPAIRED, WELDED IAW ERA 547805-14, REV ORIGINAL REPAIR WERE TREATED AND PAINTED IAW SRM 51-10-3, PAR 14 AND 21.SDR DALA2016062304876Fitting · crackedCRACKED CLIPS ON AFT UPPER INTERNAL STRUCTURE AT AFT RT EMERGENCY EXIT DOOR. CLIPS WERE REPLACED IAW SRM 51-30-2 AND 51-30-5 AND DWG 9957735, REV G.SDR DALA2016062304875Beam · crackedCRACK ON BEAM NR 1 FWD EDGE AT R1 DOOR IN REF NRTC, SN 1600. BEAM WAS REPLACED IAW SRM 51-30-2 AND 51-30-5 AND DWG 9911579, REV L. BEAM WAS REPLACED IAW SRM 51-30-2 AND 51-30-5 AND DWG 9911579, REV L.SDR DALA2016062304874Beam · crackedCRACK ON BEAM NR 1 FWD AND AFT EDGE AT MAIN ENTRY PASSENGER DOOR. BEAM WAS REPAIRED IAW SRM 52-05D, FIG 81 AND 82.SDR DALA2016062304873Frame · crackedCRACKED FRAME STA Y=1510 CANT, POS 7 HRS AND 10 HRS AT AFT ACCESSORY COMPARTMENT. FRAMES UPPER SECTION AND LOWER SECTION LT SIDE WERE REPLACED IAW SRM 51-10-4, SRM 51-30-2, SRM 51-10-3 PAR 14.21 AND DWG 9911843, REV AC.SDR DALA2016062304872Skin · crackedCRACKED SKIN ON ELEVATOR ACCUMULATOR ACCESS CUTOUT, AFT UPPER CORNER LOCATED BETWEEN STA 1463 CANT AND 1474 CANT RT SIDE. SKIN DOUBLER WAS REPLACED IAW DWG 5917686-7, REV AA, SRM 51-30-5 AND 51-30-2.SDR DALA2016062304871Access Door · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS DOOR NR 1460C AT RT WING. FUEL ACCESS DOOR 1460C WAS REPLACED IAW SRM 51-22-2A. FUEL MEASURING MAGNETICS TICK WAS REPLACED UNDER CARD 311, ZONE 100.SDR DALA2016062304870Access Door · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS DOOR 1414 C AT RT WING. ACCESS PLATE 1414C WAS REPLACED AND ACCESS FUEL PROBE WAS INSTALLED IAW AMM 28-00-00.SDR DALA2016062304869Access Door · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS DOOR 1335C AT LT WING. ACCESS PLATE 1335C WAS REPLACED AND ACCESS FUEL PROBE WAS INSTALLED IAW AMM 28-00-00.SDR DALA2016062304868Skin · puncturedPUNCTURE ON AFT VENTRAL STAIR OUTER SKIN, STA Y=1474, CANT. DAMAGE WAS REPAIRED IAW SRM 53-04-2 FIG1.SDR DALA2016062204837Exhaust Duct · crackedCRACKED EXAHUST ON EXTERNAL FUSELAGE SKIN BETWEEN LONGERON 20 LT AND 21 LT STA Y=256 TO Y=275. CRACKS ON EXHAUST WAS REPAIRED WITH METHOD 1 POSTERILY WITH METHOD 2 OF ER/A 464964-14MA, REV C, ETI 88-14-237, REV ORIGINAL. FPI WAS ACCOMPLISHED ON WELDED AREAS,SDR DALA2016062304877Tab · debondedPART RACKS DISBONDED LOWER CUP AT RUDDER CONTROL TAB DUE TO WEIGHT AND BALANCE IS OUT OF LIMITS. THE RUDDER CONTROL TAB WAS REPLACED UNDER CARD SN 01633.SDR DALA2016062204836Doubler · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER BETWEEN Y=1287 AND Y=1309 AND LONGERON 29 RT AND 30 AT C3 COMPARTMENT. DOUBLER WAS REPLACED IAW SRM 53-04-2, FIG 2.SDR DALA2016062204834Skin · crackedCRACK ON DOOR SKIN BETWEEN BEAM NR 4 AND BEAM 5 AT FWD MAIN ENTRY DOOR. SKIN WAS REPAIRED IAW ERA 501106-14MA, REV C AND ETI-88-16-151, REV 2.SDR DALA2016062204832Doubler · dentedDENTS ON PREVIOUS REPAIR DOUBLER ON LT INBD FLAP INBD VANE LOWER SKIN. REPAIR DOUBLER ON LT WING INBD FLAP INBD VANE WAS REPLACED IAW SRM 57-03D, PAR 11.SDR DALA2016062204831Skin · damagedTOOLING MARKS ON UPPER SKIN AT LT WING OTBD FLAP INBD GUIDE VANE. UPPER SKIN AT LT WING OUTBD FLAP INBD GUIDE VANE WAS REPAIRED IAW SRM 57-03D, PAR 11.SDR DALA2016062204830Rib · crackedCRACK ON LT RIBS INTERNAL STRUCTURE FIXED L/E STA ZFS=17.656 AND ZFS=23.500 APPROXIMATELY AND ELONGATED HOLES ON FORMER STA ZFS=30.000 AT VERTICAL STABILIZER. RIBS AND FORMER WERE REPAIRED IAW SRM 55-02, FIG 27, 51-30-2, 51-30-5, 51-10-2, 51-10-3 OAR 21 AND 1SDR DALA2016062104805Battery Pack · dischargedSEAT 2B AND 34E OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTER PACKS PER AMM 33-53-00.SDR DALA2016062204833Skin · delaminatedDELAMINATION ON LOWER SKIN OTBD GUIDE VANE, OTBD FLAP AT RT WING. LOWER SKIN OTBD GUIDE VANE, OTBD FLAP AT RT WING WAS REPAIRED IAW SRM 57-03D, PAR 11.SDR DALA2016062204829Former · crackedCRACKED FORMERS ON STA ZFS=23 AND ZFS=43 AT VERTICAL STABILIZER L/E RT SIDE. RIBS WERE REPAIRED IAW SRM 55-02, FIG 27. HFEC WAS ACCOMPLISHED ON FORMERS ON STA ZFS=23 AND ZFS=43 AT VERTICAL STABILIZER L/E RT SIDE NO CRACKS WERE FOUND AFTER STOP DRILL IAW NDT SDR DALA2016062204828Fitting · crackedCRACKED CLIP ON FWD, UPPER INTERNAL STRUCTURE AT RT FWD EMERGENCY EXIT DOOR. CRACKED CLIP ON FWD, UPPER INTERNAL STRUCTURE WAS REPLACED IAW SRM 51-30-5 AND 51-30-2 AND DWG 9957735, REV G.SDR DALA2016062204827Deflector · crackedCRACKED DEBRIS DEFLECTOR AT LT WING T/E WING STA XCW=60. HFEC INSPECTION 1 CRACK WAS FOUND OF 2.064" IN LENGTH, CRACK STOPPED, HFEC WAS PERFORMED ON HOLES, NO CRACKS WERE FOUND AND DEBRIS DEFLECTOR WAS REPAIRED IAW NDTSPM 06-10-01.001, SRM 57-09D, FIG 42.SDR DALA2016062104813Access Door · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS DOOR 1436C AT RT WING. FUEL ACCESS DOOR 1436C WAS REPLACED.SDR DALA2016062104812Skin · crackedSEVERAL CRACKS ON OUTER SKIN OF THRUST REVERSER UPPER DOOR AT ENGINE NR 1. OUTER SKIN OF THRUST REVERSER WAS REPAIRED IAW AMM 78-30-07-801, FIG 803 AND SRM 51-10-3, PAR 14 AND 21.SDR DALA2016062104811Access Door · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS DOOR 1303C AT LT WING. FUEL ACCESS DOOR 1303C WAS REPLACED.SDR DALA2016062104810Skin · crackedCRACKED SKIN ON LT STA YV=160.688 APPROXIMATELY TIP FAIRING. AREA WAS REPAIRED IAW SRM 55-01, FIG 4, SHEET 2.SDR DALA2016062104809Cusp Web · crackedHIDDEN DISCREPANCY CRACK ON RT CUSP STA Y=1193 BETWEEN X= 54 TO X=60 AT FLOOR STRUCTURE CABIN. CUSP WAS REPAIRED IAW SRM 53-05, FIG 131A.SDR DALA2016062104808Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN X=54 TO X=60, STA Y=1108 TO Y=1131 AT FLOOR STRUCTURE CABIN. CUSP WEB BETWEEN STA Y=1108 TO 1131 WAS REPAIRED IAW SRM 53-05, FIG 131A-7.SDR DALA2016062104826Web · crackedCORROSION ON WEB FROM STA Y=1361 TO CANT 1485 AT VENTRAL STAIRWAY SHROUD ACCESSORY COMPARTMENT. THE MEASURES AFTER REMOVED CORROSION ON AREAS LOCATED AT STA 825.808, 905.902 + 11", MEASURE REMAINING THICKNESS AFTER REWORK IS 0.038" AND ORIGINAL THICKNESS IS 0SDR DALA2016062104825Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN Y=1231 AND Y=1212, ABOVE LONGERON 29 LT AT C3 COMPARTMENT. INTERCOSTAL WAS REPLACED IAW DWG 5936071, REV W, SRM 51-30-2, 51-10-3, PAR 21, 14.SDR DALA2016062004821Doubler · wornWORN LOWER FORWARD AFT OUTER SKIN DOUBLERS AT FORWARD CARGO COMPARTMENT DOOR. DOUBLERS WERE REPLACED IAW SRM 5I-30-2 AND ERA 486624-14, REV ORIGINAL.SDR DALA2016062004819Fitting · crackedCRACKED FRAME CLIP, STA Y=1437 BETWEEN LONGERON 2LT TO 3LT AT AFT ACCESSORY COMPARTMENT. FRAME CLIP WAS REPLACED IAW SRM 53-14-4; 51-30-5; 51-10-2 AND 51-10-4.SDR DALA2016062004818Fitting · crackedCRACKED FRAME CLIP, STA Y=1446 CANT BETWEEN LONGERON 17LT TO 18LT AT AFT ACCESSORY COMPARTMENT. DOUBLER REPAIR WAS INSTALLED IAW SRM 51-30-2, 53-03, FIG 3, DWG 9911859-85.SDR DALA2016062004817Pan · crackedCRACKED INNER PAN ON FWD EDGE AND BEAM NR 1 AT FWD CARGO COMPARTMENT DOOR. DAMAGE ON PAN, CRACKS 0.-906" AND 1.375" WERE STOPPED IAW SRM 51-01, PAR 21. NOTES: NEW DOUBLER WAS FABRICATED IAW SRM 52-03D, FIG 8 AND 51-10-2. WEIGHT REPAIR PARTS=0.992 LB, NEW DOSDR DALA2016062004816Angle · crackedCRACKED ANGLE ON BEAM, NR 1 FWD EDGE AT FWD GALLEY SERVICE DOOR. ANGLE WAS REPLACED IAW SRM 51-30-4, 51-30-5, 51-10-2, 51-10-3, PAR 14 AND 21 AND DWG 9911579, REV L.SDR DALA2016062104804Fuse · blown2L EMERGENCY DOOR EXIT LIGHT INOPERATIVE. FOUND PACK AT STA 1233R, B5-212 WITH BLOWN FUSE. REPLACED FUSE.SDR DALA2016062004807Doubler · corrodedCORROSION ON REPAIR DOUBLER AT LT CABIN FLOOR CUSP WEB X=54 TO X=60 BETWEEN Y=1174 AND T=1193. REPAIR DOUBLER WAS ATTENDED IAW SRM 53-05 FIG 131A-3 AND 51-10-3, PAR 14, 21.SDR DALA2016062004806Floor Panel · crackedCRACKED FIRST GENERATION FLOOR 313A, 1003A, 389A, 617A, 927E AND 541A. CRACK ON FLOOR PANELS WERE REPAIR 313A, 927E, AND 1003A IAW SRM 53-05, FIG 131C AND FLOOR PANELS 389A, 541A AND 617A WERE REPLACE IAW DWG 9952521, REV AZ.SDR DALA2016062104824Skin · delaminatedDELAMINATION ON UPPER SKIN AT INBD GUIDE VANE, STA XV2=169 OF RT OTBD FLAP. UPPER SKIN AT INBD GUIDE VANE STA XV2=169 OF RT OTBD FLAP WAS REPAIRED IAW SRM 57-03D, PAR 11 AND CARD 2000-8149-04.SDR DALA2016062104823Intercostal · crackedCRACK ON INTERCOSTAL NR 3 BETWEEN BEAM NR 4 AND 5 AT FORWARD MAIN ENTRY PASSENGER DOOR. INTERCOSTAL WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016062104822Stringer · crackedCRACK OF 0.750" APPROXIMATELY WAS FOUND ON STR 17 AT RT LOWER WING XCW=12. STRINGER WAS REPAIRED IAW ER/A 546524-14, REV ORIGINAL AND ER/A 546518-14, REV ORIGINAL.SDR DALA2016062004820Web · corrodedCORROSION ON WEB SURFACE STA Y=1218 BETWEEN LONGERONS 26 AND 25RT AT CARGO DOOR JAMB. REPAIRED IAW SRM 51-70-4, FIG 2.SDR DALA2016062004815Fitting · crackedCRACKED R1 DOOR AFT EDGE FITTING. FITTING WAS REPLACED IAW SRM 51-30-5, 51-10-3, PAR 14 AND 21, 51-10-1 AND DWG 9911579, REV L.SDR DALA2016062004787Doubler · wornWEAR ON FWD/AFT LOWER PRODUCTION DOUBLERS AT FWD CARGO COMPARTMENT DOOR, C1. LOWER DOUBLERS FWD/AFT ON CARGO DOOR, C1 WERE REPLACED IAW SRM 51-30-2 AND ER/A 486624-14MA.SDR DALA2016062004786Skin · dentedDENT ON RT ELEVATOR CONTROL TAB STA XHS=58. REPAIRED IAW SRM 55-04, PAR 2 AND 51-70-2 AND CARD 200-8149-02.
Back to Mcdonnell Douglas MD-88