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 DALA2015080804920Access Panel · corrodedCORROSION ON COUNTERSINK FUEL ACCESS PLATE 1355CT LT WING. CORROSION ON COUNTERSINK HOLES WAS REMOVED AND MEASURED. MAX DIAMETER ALLOWABLE IS 0.532" AND MAX DIAMETER MEASURED ON 3 ADJACENT HOLES IS 0.563", THEREFORE, IT IS OUT OF LIMITS IAW SRM 51-22-2A AND SDR DALA2015080804919Access Panel · corrodedCORROSION ON COUNTERSINK AT LT WING FUEL TANK ACCESS PLATE NR 1357C, MRB 57-083-02. CORROSION ON COUNTERSINK HOLES WAS REMOVED AND MEASURED. MAX DIAMETER ALLOWABLE IS 0.532" AND MAX DIAMETER MEASURED ON 3 ADJACENT HOLES IS 0.562". THEREFORE IT IS OUT OF LIMITSDR DALA2015080804918Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA ON FUEL ACCESS PLATE 1365C AT LT WING. CORROSION ON COUNTERSINK AND SETTLEMENT AREA WAS REMOVED AND COUNTERSINK HOLES WERE MEASURED, MAX DIAMETER ALLOWABLE IS 0.532" AND MAX DIAMETER MEASURED ON 3 ADJACENT HOLES IS SDR DALA2015080804917Access Panel · corrodedCORROSION ON COUNTERSINK AT RT WING FUEL TANK ACCESS PLATE NR 1464C, MRB 57-083-02. CORROSION ON COUNTERSINK HOLES AT ACCESS PLATE NR 1464C WAS REMOVED AND MEASURED MAX DIAMETER ALLOWABLE IS 0.532" AND MAX DIAMETER MEASURED ON 3 ADJACENT HOLES IS 0.586". THERSDR DALA2015080804886Access Panel · corrodedCORROSION ON COUNTERSINK AT RT WING FUEL TANK ACCESS PLATE 1456C. CORROSION ON COUNTERSINK HOLES AT ACCESS PLATE NR 1456C WAS REMOVED AND MEASURED. MAX DIAMETER ALLOWABLE IS 0.532" AND MAX DIAMETER MEASURED ON 3 ADJACENT HOLES IS 0.580". THEREFORE ITS OUT OF SDR DALA2015080804885Skin · crackedSIX CRACKS WERE FOUND ON FUSELAGE SKIN, FWD SERVICE DOOR JAMB, UPPER FWD CORNER BETWEEN BS 168 - 180. FUSELAGE SKIN FWD SERVICE DOOR JAMB WAS REPAIRED IAW ER/A 536494-14AD, REV ORIGINAL AND ETI-88-15-242, REV 3. MAJOR REPAIR.SDR DALA2015080804883Hinge · damagedELONGATED HOLE ON FWD/AFT HINGE AT MID CARGO COMPARTMENT DOOR. AFT HINGE AT MID CARGO DOOR WAS REPAIRED IAW ER/A 497387-14MA, REV B AND INSTALLED IAW AMM 52-31-02. FWD HINGE AT MID CARGO DOOR WAS REPLACED BY NEW PART AND INSTALLED IAW AMM 52-31-02, FINAL I.DSDR DALA2015080804882Floor Panel · brokenBROKEN CHANNEL AND FLOOR PANEL. FLOOR PANEL REPAIRED IAW SRM 51-20-0, 51-70-1, PARA 10.SDR DALA2015080704881Skin · corrodedAFT LAV SERVICE PANEL SKIN BULGING WITH FASTENER PULLED THROUGH. COMPLIED WITH ER/A 538259-14, REV "A". ASSOCIATED ER/A 14-538259, ADDED FOR AC 0993.SDR DALA2015080804884Frame · crackedCRACKED FRAME BS 1485. FRAME WAS REPAIRED IAW SRM 53-01, FIG 2. HFEC INSPECTION WAS ACCOMPLISHED, NO CRACKS WERE FOUND AFTER STOP DRILL,SDR DALA2015080704880Access Panel · corrodedCORROSION ON COUNTERSINK FUEL ACCESS PLATE NR 1303C AT LT WING, LW, SM, CARD 155, ZONE 010. CORROSION ON COUNTERSINK HOLES WERE MEASURED, MAX DIAMETER ALLOWABLE IS 0.532", AND MAX DIAMETER MEASURED ON 3 ADJACENT HOLES IS 0.592". THEREFORE ITS OUT OF LIMITS ISDR DALA2015080704879Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G. FILLER WAS REMOVED FROM PANEL IAW SRM 51-30-2 THEN NEW FILLER AND PANEL WERE FABRICATED IAW DWG 9957828 AND SRM 51-10-2. AFTER THAT, THE FABRICATED PARTS WERE TREATED AND PAINTED IAW SRM 51-10-3, PAR 21 AND 14. FINALLY FLOOR SDR DALA2015081004872Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTS IN ROWS 11-14 OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECK WAS GOOD.SDR DALA2015081004871Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGNS AT BOTH OF THE FWD OVERWING HATCHES WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECK WAS GOOD.SDR DALA2015080704867Frame · crackedCRACKED FRAME BS 1463. REPAIRED IAW SRM 51-30-2, DWG 9953015, REV CB-38 AND -40 AND 51-30-5.SDR DALA2015080704866Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BETWEEN BS 712 - 750 AND LONGERONS 28 - 29R. LIGHTNING STRIKE WAS BLENDED OUT IAW SRM 53-04-1, PAR 5B 1. REWORKED AREA WAS MEASURED IAW NDT SPM 04-00-07, PAR 5, FIG 3, SHEET 1 AND 2. FOUND OUT OF LIMITS IAW SRM 53-4-1, PAR SDR DALA2015080704865Fitting · crackedCRACK ON FWD CLIP OF INTERCOSTAL ZEE IN LT FWD OVERWING EMERGENCY EXIT DOOR. NEW CLIP AND INNER SKIN WERE INSTALLED IAW DWG 9957735, REV-G, SRM 51-10-2, 51-10-4, 51-30-1, 51-30-2, 51-30-5.SDR DALA2015080704864Skin · damagedLIGHTNING STRIKE ON WINDOW BELT BETWEEN BS 712 - 731, FWD LOWER CORNER AND AFT MID SECTION. WINDOW BELT WAS REPAIRED IAW MD-88, ER/A 537734-14AD REV ORIGINAL.SDR DALA2015080704862Longeron · crackedCRACKED LONGERON 2L BS 1401. DAMAGE LONGERON SECTION WAS REMOVED. NEW SECTION LONGERON AND REPAIR SPLICE WERE ADJUSTED AND DRILLED, NEW LONGERON SECTION AND REPAIR SPLICE WERE TREATED AND PAINTED, NEW LONGERON SECTION AND REPAIR SPLICE WERE INSTALLED IAW SSDR DALA2015091005541Strap · corrodedACFT AFT LAV SERVICE PANEL CUTOUT STRAP HAS CORROSION ON THE LOWER AFT CORNER. COMPLIED WITH STEPS 1-5 OF ERA 538253-14, REV ORIGINAL C/W HFEC INSPECTION OF CUTOUT AREAS IAW STEP 6 OF ERA 538253-14, REV ORIGINAL SECTION I TIME LIMITED REPAIR WITH NO ITEMS NOTESDR DALA2015080704878Frame · crackedCRACKED FRAME LOWER CAP BS 1437 LONGERON 2L. FRAME WAS REPAIRED IAW SRM 53-01, FIG 2, SHEET 4. HFEC INSPECTION WAS PERFORMED AFTER STOP DRILL, NO MORE CRACKS WERE FOUND IAW NDT SPM 06-10-01-001.SDR DALA2015080704870Pan · crackedCRACKED PAN BETWEEN BEAMS 7 AND 8 AT L1 DOOR FWD EDGE. CRACKED PAN REPAIRED IAW SRM 52-05-D, FIG 41.SDR DALA2015080704869Pan · crackedCRACKED RT UPPER AFT WING PAN CORNER ON BS 826. REPAIRED IAW SRM 53-05, FIG 122 AND 51-30-2, 51-30-5, 51-10-3, PARG 14 AND 21.SDR DALA2015080704868Pan · crackedCRACKED RT UPPER FWD RING PAN CORNER ON BS 927. REPAIRED IAW SRM 53-05, FIG 122 AND 51-30-2, 51-30-5, 51-10-3, PARA 14 AND 21.SDR DALA2015080704863Longeron · crackedCRACKED REPAIR ON LONGERON 2R BS 1418. DAMAGE SECTION WAS REMOVED, NEW SECTION LONGERON AND REPAIR SPLICE, NEW SECTION LONGERON AND SPLICE WERE TREATED AND PAINTED, NEW LONGERON AND SPLICE WERE INSTALLED IAW SRM 51-20-2, 53-02, FIG 18, 51-10-3, PAR 14 AND 21SDR DALA2015080604861Cargo Track · corrodedCORROSION ON RT TIE TRACK BETWEEN BS 1212 - 1322. THE TIE TRACK WAS REPLACED IAW SRM 51-10-3, PAR 14, 21, 26, 51-10-4, 51-30-1, AND 53-05 FIG 4C AND NDT SPM 0400-07, FIG 3, PAR 3, SHEET 1-2.SDR DALA2015080604860Cargo Track · corrodedCORROSION OUT LIMITS ON RT TIE TRACK BETWEEN BS 1110 - 1155 IN AFT CARGO COMPARTMENT. NEW SECTION TIE TRACK WAS REPLACED, TREATED, AND PAINTED IAW SRM 51-10-4, 53-05, FIG 4G, 51-10-3, PAR 21 AND 14, 51-30-5, AND 51-30-1.SDR DALA2015080604859Pan · crackedCRACKED PAN BEHIND STOP NR 1 AT RT FWD OVERWING EMERGENCY EXIT DOOR, CARD 321, ZONE 201. NEW DOUBLER WAS INSTALLED IAW SRM 52-05D, FIG 51, 51-30-1, 51-30-2, 51-10-2, 51-10-4, 51-30-5, 51-10-3, PARAGRAPH 14 AND 21. HFEC INSPECTION WAS ACCOMPLISHED ON PAN BEHISDR DALA2015080604858Angle · crackedCRACK ON ANGLE BEHIND STOP 1 IN RT AFT OVERWING EXIT DOOR. CARD 86, ZONE 201. NEW CLIP WAS INSTALLED IAW DOWN 9957735, REV G, SRM 51-30-1, 51-30-2, 51-30-5, 51-10-2, 51-10-4, 51-10-3, PARAGRAPH 14 AND 21.SDR DALA2015080604857Structure · crackedCRACKS ON UPPER FWD AND AFT CORNERS OF RT AFT OVERWING EMERGENCY EXIT DOOR. DOUBLERS WERE INSTALLED IAW SRM 52-05D, FIG 51, 51-10-2, 51-10-4, 51-30-1, 51-30-2, 51-30-5, 51-10-3 PARA 14 AND 21.SDR DALA2015080604856Unknown · crackedCRACK ON AFT FRAME AND BEAM NR 8 L1 DOOR. INTERCOSTAL AND PRODUCTION DOUBLER WERE REPLACED IAW SRM 51-30-2 CRACK LENGTH 0.250.SDR DALA2015080604855Cargo Track · corrodedSEVERAL CORROSION POINTS ON LT TIE TRACK FROM BS 1003 TO 1220. DAMAGED TIE TRACK WAS REMOVED IAW SRM 51-30-1. NEW TIE TRACK WAS DRILLED IAW SRM 51-10-4, AND TREATED AND PAINTED IAW SRM 51-10-3, PARA 21 AND 14, AND WAS INSTALLED IAW SRM 51-30-1 AND 51-30-2.SDR DALA2015080604854Hinge · corrodedCORROSION ON RT ELEVATOR NR 6 HINGE UPPER AND LOWER BORES. HOLES TO ATTACH EYEBOLT. IN REF OR NRC 16 ACFT ZONE 60. DAMAGE RT ELEVATOR NR 6 HINGE HOLES UPPER AND LOWER WERE REAMED WITH ID 0.626 AND 0.629. THEREFORE OUT LIMITS IAW CMM 27-30-2, TABLE FIG 601 SDR DALA2015080604853Longeron · crackedCRACKED LONGERON 13L BS 1380. DAMAGE LONGERON SECTION WAS REPLACED IAW SPM 53.14.4, FIG 2, ITEM 4, SRM 51.30.2, SRM 51.30.5, AND SRM 51.10.4, SRM 51.10.3 PAR 14. 21.SDR DALA2015080604851Shear Tie · corrodedCORROSION ON FRAME SHEAR TIE BS 732 BETWEEN LONGERONS 28 - 29L. AREA WAS REWORKED. REPAIR FABRICATED, REPAIR TREATED/PAINTED, AND INSTALLED IAW SRM 51-10-3, PAR 26, 21, 14, 53-01 AND 51-30-2.SDR DALA2015080504850Intercostal · brokenBROKEN INTERCOSTAL BETWEEN BEAMS NR 4 AND 5, AFT OF OPERATING MECHANISM AT L1 DOOR. INTERCOSTAL WAS REPLACED IAW SRM 51-30-2.SDR DALA2015080504849Frame · crackedCRACKED FRAME BS 1474 LONGERON 18L. CRACKED FRAME WAS REPAIRED IAW SRM 51-30-2, 53-01, FIG 2, SHEET 4 AND 51-01 PAR 21(A), 53-01, FIG 2, SHEET 4, 51-10-3 PAR 14 AND 21 AND 51-30-5.SDR DALA2015081004873Light · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 12DE IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE ILLUMINATOR FOR THE NOTED LIGHTED AREAS AND THE OPS CHECK WAS GOOD.SDR DALA2015080604852Tee Fitting · corrodedCORROSION ON TEE , LONGERON 23L IN BS 1383. TEE REMOVED, DOUBLER REPAIR FABRICATED, DOUBLER REPAIR TREATED, PAINTED, REPAIR INSTALLED, AND TEE INSTALLED IAW SRM 51-10-3, PAR 21.14 AND SRM 51-30-5.SDR DALA2015080504843Floor Panel · crackedCRACKED FLOOR PANEL. THE FLOOR PANEL WAS REPAIRED IAW SRM 53-01, FIG 4, 51-10-3, PAR 21 AND 14.SDR DALA2015080504842Doubler · damagedBENT LOWER EDGE ON EXTERNAL SKIN DOUBLER. THE DOUBLER WAS REMOVED IAW SRM 51-30-2 AND A NEW DOUBLER WAS FABRICATED IAW SRM 52-05D, FIG 37. THE NEW DOUBLER WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 14, 21 AND INSTALLED IAW SRM 51-30-2.SDR DALA2015081104950Tab · delaminatedDELAMINATION ON LWR & UPPER SURFACE OF LT ELEVATOR CONTROL TAB, VHS, SH-CP-SM, ZONE 2 CARD 65. LT ELEVATOR CONTROL TAB WAS REPAIRED IAW ER/A 537738-14, REV ORIGINAL AND CARD 2000-8149-06, CREW 02, JOB NR 000-0011. PERMANENT REPAIR WAS PERFORMED IAW ER/A 5377SDR DALA2015080704844Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS AT ROWS 31-35 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES IN THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR DALA2015080404841Frame · crackedCRACKED FRAME ANGLE BS 1437 LONGERON 2L. THE FRAME ANGLE WAS REMOVED, AND A NEW FRAME ANGLE WAS FABRICATED, TREATED AND PAINTED. THE NEW FRAME ANGLE WAS INSTALLED IAW SRM 51-30-5, 53-14-4, 51-10-3 PAR 14 AND 21 AND 51-30-2.SDR DALA2015080404840Doubler · crackedTWO CRACKS ON INTERNAL PRODUCTION DOUBLER WERE FOUND AT LWR AFT CORNER DOOR JAMB BS 425 BETWEEN LONGERON 26-27R. DAMAGE INTERNAL PRODUCTION DOUBLER WAS REMOVED IAW SRM 53-05, FIG 105. HFEC WAS PERFORMED IAW NDT SPM 06-10-01-001, AND NO CRACKS WERE FOUND AROUNSDR DALA2015080404839Seat Track · corrodedCORROSION ON LT SEAT TRACK REPAIR PLUGS X 54, BS 930-935 AND 1120-1125. PLUGS WERE REPLACED IAW SRM 51-10-3, PAR 14, 21, 53-05, 51-30-1.SDR DALA2015080404838Seat Track · corrodedCORROSION ON OF SEAT TRACK REPAIR X -54, BS 269-272, AND 662-666. PLUGS WERE REPLACED IAW SRM 51-10-3 PAR 14, 21, 53-05, 51-30-1.SDR DALA2015080404837Seat Track · corrodedCORROSION ON LT SEAT TRACK REPAIR PLUGS X 54, BS 480-484, AND 605-610. PLUGS WERE REPLACED IAW SRM 51-30-1, 53-05, FIG 4, 51-10-3, PAR 14, 21.SDR DALA2015080404836Seat Track · corrodedCORROSION ON LT SEAT TRACK REPAIR PLUGS X -54 BS 1245-1250 AND 1294-1298. PLUGS WERE REPLACED IAW SRM 51-10-3, PAR 14, 21, 53-05, 51-30-1.SDR DALA2015080404835Spar · damagedELONGATED HOLE WAS FOUND ON REAR SPAR. RT REAR SPAR CAP WAS REPLACED IAW DWG SR09550030, REV C AND SRM 51-10-3, AND 21, 51-30-2 / 51-30-5 AND 51-30-1.
Back to Mcdonnell Douglas MD-88