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 DALA2015090105364Cusp Web · corrodedFOUND CORRODED REPAIR DOUBLER ON CUSP WEB AT BS 882-889 X 53-57. THE DOUBLER WAS REMOVED, FABRICATED, TREATED AND PAINTED IAW SRM 53-05, FIG 131A-1, 51-10-3, PAR 21, 14 AND IAW SRM 51-30-2. THE DOUBLER WAS INSTALLED IAW SRM 51-30-2, 51-30-5.SDR DALA2015090105363Beam · corrodedFOUND CORROSION ON REPAIR DOUBLER OF THE LOWER DOOR FRAME BEAM BETWEEN BS 1155 - 1212. SPACER WAS REPLACED IAW SRM 53-05, FIG 123, 51-30-5 AND 51-10-3 PAR.14, 21 AND 38.SDR DALA2015090105362Cargo Track · corrodedFOUND CORROSION ON LT CARGO TRACK BETWEEN BS 1222 - 1322, UPPER AND LOWER SURFACES. THE CARGO TRACK WAS REPLACED IAW SRM 53-24-0D, DWG 5936660 REV B2, AND SRM 51-30-1.SDR DALA2015090105361Cargo Track · corrodedFOUND CORROSION ON LT CARGO TRACK BETWEEN BS 1003 - 1098, UPPER AND LOWER SURFACES,. THE CARGO TRACK WAS REPLACED IAW SRM 51-30-1, 51-30-5, SRM 53-24-0D AND DWG DWGS936660, REV B2.SDR DALA2015090105360Stop Fitting · crackedHAS CRACKED FWD STOP FITTING OF BEAM 3 ACTUATOR 1 DOOR. STOP FITTING WAS REPLACED IAW SRM 51-30-5, AND 51-10-4.SDR DALA2015090105359Pin · missingMAINTENANCE FOUND RELEASE PIN ON L1 SLIDE FOLDING FLAP COVER LEFT OUT. SLIDE WAS REPLACED.SDR DALA2015090105358Frame · crackedACFT HAS A CRACK ON FRAME BS 1510. THE FRAME WAS R & R IAW SRM 51-30-2, 51-10-4 AND 51-10-3.SDR DALA2015090105357Longeron · crackedACFT HAS A CRACK ON LONGERON 3R BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015090105356Longeron · crackedACFT HAS CRACK ON LONGERON 4R BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015090105355Longeron · crackedACFT HAS A CRACK ON LONGERON 4L BS 1437 IN AFT ACCESSORIES COMPARTMENT. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18, 51-10-3, 51-30-5, AND 51-10-4.SDR DALA2016082910214Skin · crackedER/A 538941-14 SECTION 1 ACCOMPLISHED AND CLASSIFIED AS A MAJOR REPAIR. CRACK IN THE FUSELAGE SKIN NEAR THE AFT LAV SERVICE DOOR CUTOUT.SDR DALA2015090705469Angle · crackedCRACKED LT AND RT INTERNAL DORSAL ANGLES BETWEEN JOIN OF VERTICAL STABILIZER L/E AND FUSELAGE SKIN BS 1418. THE ANGLE WAS REPLACED IAW SRM 51-30-2 AND DWG 5912188, REV BD.SDR DALA2015090805462Skin · damagedACFT HAS A LIGHTNING STRIKE ON FWD, UPPER CORNER WINDOW BELT RT SIDE BS 989. LIGHTNING STRIKE WAS ATTENDED WITH SRM 53-05, FIG 111.SDR DALA2015090105375Pan · crackedFOUND A CRACK ON PAN BETWEEN BS 426 AND BEAM 5. REPAIRED IAW ER/A 537772-14, REV: ORIGINAL.SDR DALA2015090105370Structure · corrodedACFT HAS CORROSION ON RT BARREL NUT HOLES ON HORIZONTAL STABILIZER. REPAIRED IAW ER/A 537764-14, REV ORIG.SDR DALA2015090105367Floor Panel · brokenACFT HAS A BROKEN FLOOR PANEL. FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2015083105342Floor Panel · corrodedCORROSION FOUND ON COCKPIT FLOOR PANEL. THE FLOOR PANEL WAS REMOVED IAW SRM 51-30-1. THE FLOOR PANEL WAS REPLACED.SDR DALA2015083105341Structure · corrodedCORROSION FOUND ON THE HORIZONTAL STAB. REPAIRED IAW ERA 537766-14, REV ORIGINAL.SDR DALA2015083105340Door · no testLEFT AFT OVERWING EMERGENCY EXIT DOOR FAILED EXTERIOR DOOR HANDLE RELEASE TEST IAW W/C 5200-2643. DOOR RELEASES AS SOON AS EXTERIOR HANDLE TAB PRESSED WHILE HANDLE WAS IN THE STOWED POSITION. REPLACED AND RIGGED THE DOOR IAW AMM 52-21-00.SDR DALA2015083105339Container · crackedDURING INSPECTION, MAINTENANCE FOUND TAILCONE EVACUATION SLIDE BASE PLATE CRACKED AT COVER ATTACH POINTS. THE CONTAINER ASSY WAS REPLACED IAW AMDS WORKCARD 2561-4001.SDR DALA2015083105336Cusp Web · crackedA CRACK WAS FOUND ON CUSP WEB AT BS 1228, LBL 49. A REPAIR WAS FABRICATED IAW SRM 53-05, FIG 131A-13 AND INSTALLED IAW SRM 53-05, FIG 131A-13.SDR DALA2015083105334Seat Track · corrodedCORROSION FOUND ON THE SEAT TRACK FROM BS 795 - 797 AND LBL 54. THE SEAT TRACK WAS REPAIRED IAW SRM 53-05 FIG 4F.SDR DALA2015083005314Cargo Track · corrodedCORROSION FOUND ON RT CARGO TRACK BETWEEN BS 1212 - 1322. THE CARGO TRACK WAS REPLACED IAW SRM 51-30-1.SDR DALA2015083005313Frame · crackedCRACKED FRAME BETWEEN LONGERONS 1 - 2L BS 1437. THE FRAME WAS REPLACED IAW SRM 51-30-5.SDR DALA2015083005312Cap · crackedCRACKED UPPER CAP BETWEEN LONGERONS 1 - 2L BS 1437. CAP WAS REPLACED IAW SRM 51-30-5.SDR DALA2015083005311Channel · crackedCRACKED CHANNEL ON FLOOR PANEL. CHANNEL REPAIRED IAW SRM 53-05, FIG 131B AND 51-70-1.SDR DALA2015092805841Scoop · crackedA CRACK FOUN ON WELD OF VERTICAL STABILIZER INTAKE AIR SCOOP APPROXIMATELY BS ZFS=11.562. CRACKS ON VERTICAL STAB INTAKE AIR SCOPP APPROXIMATELY STA ZFS 11.562 WERE WELDED AND FPI WAS ACCOMPLISHED ON WELDED AREAS AND NO CRACK WERE FOUND IAW MD SRM 55-05 PAR 4CSDR DALA2015092805840Scoop · crackedA CRACK WAS FOUN ON WELD OF VERTICAL STAB INTAKE AIR SCOOP APPROXIMATELY BS ZFS=4.75 UPPER/ AFT EDGE. CRACKS ON VERTICAL STAB. INTAKE AIR SCOOP APPROXIMATELY BS ZFS 4.75 AFT EDGE WERE WELDED AND FPI WAS ACCOMPLISHED ON WELDED AREAS AND NO CRACKS WERE FOUND IASDR DALA2015083105333Structure · corrodedCORROSION FOUND ON HORIZONTAL STABILIZER. HORIZONTAL STABILIZER WAS REPAIRED IAW ERA 537754-14, REV ORIGINAL AND SRM 55-03, PAR 30.SDR DALA2015083105327Stud · corrodedCORROSION WAS FOUND ON THE UPPER STUDS OF RT WING OTBD FLAP HINGE XW 333. THE STUDS WERE REPLACED IAW AMM 57-40-01-201.SDR DALA2015083005326Seat Track · corrodedCORROSION WAS FOUND ON THE SEAT TRACK REPAIR PLUG LBL 54, BS 486 - 489 . THE REPAIR WAS REMOVED AND REPLACED IAW SRM 51-30-1, 53-05, FIG 1A, 51-10-3, PAR 14 AND 21.SDR DALA2015083005325Seat Track · corrodedCORROSION WAS FOUND ON THE SEAT TRACK REPAIR PLUG LBL 54, BS 454 - 457 . THE REPAIR WAS REMOVED, ADJUSTED, TREATED, PAINTED AND INSTALLED IAW SRM 51-30-1, 53-05, FIG 1A, AND 51-10-3 PAR 21 - 14.SDR DALA2015083005324Cusp Web · puncturedPERFORATION ON THE RT CUSP WEB BS 788 - 807. DAMAGE WAS REMOVED, DOUBLER WAS FABRICATED, TREATED, PAINTED AND INSTALLED IAW SRM 53-01, FIG 4, 51-10-3 PAR 14 AND 21 AND 51-30-2.SDR DALA2015083005322Longeron · crackedCRACKED LONGERON 13L, BS 1338, LONGERON REPLACED IAW SRM 53-14-3, 51-30-5 AND 51-10-3 PAR. 21 AND 14.SDR DALA2015083005321Seat Track · corrodedCORROSION FOUND ON REPAIR PLUG ON SEAT TRACK LBL 22 FROM BS 858-862. THE REPAIR WAS REMOVED AND REPLACED IAW SRM 51-30-1, 53-05, FIG 4A, AND51-10-3, PAR 14, 21 - 38.SDR DALA2015083005320Scuff Plate · crackedCRACKED SCUFF PLATE AT CARGO DOOR. THE SCUFF PLATE WAS REPAIRED IAW ER/A 491023-14MA, REV A.SDR DALA2015083005317Floor Panel · brokenDAMAGED FERRULE AND BROKEN FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015083005316Pin · disengagedMAINTENANCE FOUND THE L1 DOOR SLIDE PARACHUTE PIN DISENGAGED. THE DOOR SLIDE WAS REPLACED.SDR DALA2015083005310Floor Panel · crackedCRACKED FLOOR PANEL. THE FLOOR PANEL WAS REPAIRED IAW SRM 51-70-4.SDR DALA2015083005309Floor Panel · wornWEAR FOUND ON FERRULE OF FLOOR PANEL. THE FLOOR PANEL WAS REPLACED IAW AMM 53-20-01-201, PAR 7.C.SDR DALA2015083005308Intercostal · crackedCRACKED INTERCOSTAL BS 1476 AND LONGERON 20L. THE INTERCOSTAL WAS REPAIRED IAW SRM 53-01, FIG 2, SHEET 3, 51-30-2, 51-30-5.SDR DALA2015083005307Attach Angle · crackedCRACKED ANGLE TO ATTACH RT PYLON T/E LOWER SURFACE. ANGLE REPAIRED IAW SRM 54-04 FIG 10A SHEET 2 AND 3 NOTE 15 AND 51-30-5.SDR DALA2015083005306Doubler · corrodedCORROSION FOUND ON PRODUCTION DOUBLER LOWER AND UPPER CUT OUT AT AFT LAVATORY SERVICE PANEL. REPAIRED IAW ER/A 537752-14, REV ORIGINAL.SDR DALA2015083005305Skin · damagedDAMAGE METALLIZED ON FAIRING OF RUDDER. FAIRING OF RUDDER WAS REPAIRED IAW SRM 51-70-1A, PAR 23.SDR DALA2015083005304Seat Track · corrodedHAS CORROSION ON REPAIR PLUG PM SEAT TRACK X-22 AND BS 728 - 729. PLUG WAS REMOVED AND REPLACED IAW SRM 51-30-1, 53-05 FIG 4B-1, 51-10-3, PAR 14, 21 AND 38.SDR DALA2015083005303Stiffener · crackedCRACK FOUND ON STIFFENER END BETWEEN LONGERONS 16 - 17L PRESSURE BULKHEAD BS 1338. STIFFENER WAS REPLACED IAW SRM 51-30-1, 51-30-5, 51-30-4, 51-10-3 PAR 14 AND 21 AND DWG 9915558, REV BA.SDR DALA2015083005302Longeron · corrodedSURFACE CORROSION FOUND ON LONGERON 30, BETWEEN BS 237 - 256. LONGERON SECTION WAS REPAIRED IAW SRM 53-14-1, FIG 3, 51-10-4, 51-30-2, 51-10-3 AND 53-02, FIG 18.SDR DALA2015083005301Doubler · corrodedSEVERAL CORRODED POINTS ON INNER FUSELAGE SKIN DOUBLER BETWEEN BS 446 - 484 AND LONGERON 25-26L. THE DOUBLER WAS REPLACED IAW SRM 53-04-5, FIG 9 51-30-2, AND 51-10-3, PAR 14-21.SDR DALA2015083005300Pan · crackedCRACKED FWD UPPER CORNER OF WINDOW PAN, BS 845. REPAIRED IAW SRM 53-05, FIG 122; ER/A 493648-14MA, REV A, AND ER/A 487747-14MA, REV A.SDR DALA2015083005299Cusp Web · corrodedCORROSION FOUND ON CUSP WEB BETWEEN BS 1060 - 1066 AND X-44 TO X-60. DAMAGE WAS REMOVED, REPAIR FABRICATED AND TREATED AND PAINTED, AND INSTALLED IAW SRM 51-30-1, 53-05 FIG 131A-7, 51-10-3 PAR 14, 21, 38, AND 51-30-5.
Back to Mcdonnell Douglas MD-88