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 DALA2015072804737Intercostal · crackedCRACKED INTERCOSTAL BS 1271 - 1287 BL 0. HREC INSPECTION ACCOMPLISHED FOUR CRACKS WERE FOUND IAW NDT SPM 06-10-01 .001, DAMAGE WAS CUTOUT AND STOP DRILLED IAW SRM 51-01, PAR 20 AND 53-01, FIG 4. A REPAIR WAS FABRICATED IAW SRM 53-01, FIG 4 AND INSTALLED ISDR DALA2015072804736Longeron · crackedCRACKED LONGERON 5L BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-2, FIG 18. MAJOR REPAIR.SDR DALA2015072804735Longeron · crackedCRACKED LONGERON 11R BS 1431. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18. HFEC WAS PERFORMED IAW NDT SPM 06-10-01-001.SDR DALA2015072804734Actuator · malfunctionedDURING CLIMBOUT AT ABOUT FL200, RT MAIN GEAR RED LIGHT ILLUMINATED. SEVERAL MINUTES LATER AMBER GEAR DOOR OPEN LIGHT ILLUMINATED INTERMITTENTLY. AT FL250 LEVELED OFF AND LIGHT CONTINUED. RAN QRH 14.19, THRU STEP 3. AUTO SPEEDBRAKE RESET ON ITS OWN. ALL LSDR DALA2015072804733Vane · damagedAFTER LANDING , WHEN FLAPS WERE RAISED TO 0 THE RT FLAP INDICATOR READS 5 AND LT FLAP INDICATOR READS 0, FELT SLIGHT BINDING WHEN ATTEMPTING TO RETRACT SLATS SO LT FLAPS OUT. INBD AND OTBD FLAP VANE GUIDE OF INBD FLAP WERE REPLACED FOR A SERVICIABLE FLAP VANSDR DALA2015072804732Rib · crackedCRACKED RIBS ON FIXED L/E OF VERTICAL STABILIZER. RIBS WERE R & R IAW SRM 55-02 D, FIG 27 AND 51-30-5 TO 51-30-2 AND DWGS 9911881, ID, 2 REV C. AND 9911882: ID 2, REV B.SDR DALA2015072804731Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN X 54 - 60 AND BS 560 - 579. THE CUSP WEB WAS REPLACED IAW SRM 53-05, FIG 131A-24, SHEET 1 AND SRM 51-30-1 AND 51-30-2.SDR DALA2015072804730Doubler · wornWORN INNER DOUBLER OF AFT LAVATORY SERVICE PANEL.SDR DALA2015072804729Doubler · wornWORN INNER DOUBLER OF AFT LAVATORY SERVICE PANEL. DOUBLER WAS BLENDED OUT AND FOUND TO BE OUT OF LIMITS IAW SRM 53-01, FIG 1. THE DOUBLER WAS REPLACED IAW DWG 5911423, ITEM 43, REV: CD, SRM 51-30-2 AND 51-30-5.SDR DALA2015072804728Tray · corrodedCORROSION ON AFT LAVATORY SERVICE PANEL TRAY. EXCESSIVE CORROSION ON PANEL TRAY WAS REPLACED IAW DWG 5914792, ITEM 3, REV: AG AND SRM 51-10-4, 51-30-2 AND 51-30-5.SDR DALA2015072704725Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN X 54 - X 60 AND BS 1220 - 1231. REMOVED CORROSION, AND REPAIRED IAW SRM 53-05, FIG 131A, 51-10-3 PAR 21, 14 , AND 53-14-3.SDR DALA2016111108826Cargo Track · corrodedCORROSION ON THE LEFT CARGO TRACK BETWEEN BS 1007 TO 1322 IN THE AFT CARGO COMPARTMENT. A NEW CARGO TRACK WAS INSTALLED IAW SRM.SDR DALA2015072704724Skin · wornWEAR AT UPPER SKIN OF OTBD GUIDE VANE OF OTBD FLAP LT WING. REPAIRED IAW SRM 57-03D, PAR. II .SDR DALA2015072704723Skin · damagedWEAR AT L/E DOUBLER ON INBD GUIDE VANE OF OTBD FLAP, LT WING. INBD GUIDE VANE OF OTBD FLAP LT WING WAS REPAIRED IAW SRM 57-03D, PAR II.SDR DALA2015072704720Finger Doubler · corrodedCORROSION FOUND ON THE FINGER DOUBLER BETWEEN LONGERONS 25-26L BS 1209 - 1212, 1228 - 1231. THE FINGER DOUBLER WAS REPAIRED IAW SRM 53-04, FIG 12E , 51-30-2 , 51-30-5 AND 51-10-3, PAR 38.SDR DALA2015072704719Finger Doubler · crackedCRACKED FINGER DOUBLER BETWEEN LONGERON 25-26L BS 1174 - 1193. THE FINGER DOUBLER WAS REPAIRED IAW SRM 53-04, FIG 12E, 51-30-2, 51-30-5 AND 51-10-3, PAR 38.SDR DALA2015072904741Frame · corrodedCORROSION ON FRAME ANGLE, BS 1418, BETWEEN LONGERONS 24-25L. THE FRAME ANGLE WAS REPLACED, TREATED AND PAINTED AND INSTALLED IAW SRM 53-14-4, 51-10-3, P. 14 AND 21, 51-30-2.SDR DALA2015072904740Skin · corrodedCORROSION BETWEEN DOUBLER AND SKIN AT AFT LAVATORY SERVICE PANEL, BETWEEN BS 1307 - 1322, LONGERONS 21-22L. REPAIRED IAW ETI 88-15-248, REV 2 AND ER/A 536500-14, REV:ORIG.SDR DALA2015072704722Skin · dentedDENTS FOUND ON REPAIR OF INBD GUIDE VANE LOWER SURFACE ON LT WING INBD FLAP. THE REPAIR WAS REPLACED IAW SRM 57-03D.SDR DALA2015072704721Frame · crackedCRACKS FOUND ON FRAME, BS 1510 . THE FRAME WAS REPLACED IAW DWG 9911843, REV SRM 51-30-2 , 51-10-4 , AND 51-10-3.SDR DALA2015072704718Hinge · crackedA CRACK WAS FOUND ON AFT VENTRAL DOOR UNDER UPPER HINGE FITTING. REPAIRED IAW SRM 51-30-2 AND 51-30-1, 51-10-3, PAR 14/21, 51-01, PAR 4 CAP 21 AND 52-05D, FIG 34.SDR DALA2015072604717Skin · dentedDENTS FOUND ON PREVIOUS REPAIR OF MID GUIDE VANE ON THE LT WING OTBD FLAP. A NEW DOUBLER WAS INSTALLED IAW SRM 57-03, PARR II.SDR DALA2015072604716Pan · crackedCRACKED INNER PAN BELOW STOP FITTING NR 3 IN FWD CARGO BAY AFT EDGE. REPAIR WAS ACCOMPLISHED IAW SRM 52-05D, FIG 50. CRACK LONG 0.150".SDR DALA2015072604715Longeron · corrodedCORROSION ON PREVIOUS REPAIR OF LONGERON 29L BETWEEN BS 1231 - 1250. THE REPAIR WAS REPLACED IAW SRM 51-30-5, PAR 13, SRM 53-02, FIG 19, AND SRM 51-10-3, PAR 21, 14 AND 38.SDR DALA2015072604714Intercostal · crackedA CRACK WAS FOUND ON THE INTERCOSTAL BETWEEN LONGERONS 27-28L. BS 1309 - 1322. THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-4, AND 51-10-3, PAR 14 AND 21.SDR DALA2015072604713Frame · crackedCRACKED FRAME BS 1451, BETWEEN LONGERONS 1-3L. THE FRAME WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-4, AND 51-10-3 PAR 14,21.SDR DALA2015072604712Cargo Track · corrodedCORROSION FOUND ON THE RT CARGO TRACK BETWEEN BS 1212 - 1322, UPPER AND LOWER SURFACES. THE CARGO TRACK WAS REMOVED AND REPLACED IAW IAW SRM 51-10-3, PAR 21, 14, AND 51-30-1.SDR DALA2015072604711Cargo Track · corrodedCORROSION ON RT CARGO TRACK BETWEEN BS 1007 - 1155, UPPER AND LOWER SURFACES. DAMAGE CARGO TRACK WAS REMOVED, AND A NEW CARGO TRACK WAS DRILLED, TREATED AND PAINTED. THE CARGO TRACK WAS INSTALLED IAW SRM 51-30-1,51-10-4, AND 51-10-3 PAR 21,14.SDR DALA2015072604710Longeron · crackedCRACKED LONGERON 4L BS 540. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18. MAJOR REPAIR.SDR DALA2015072604709Cusp Web · corrodedCORROSION ON RT CUSP WEB, X -54 TO -60 BETWEEN BS 1168 - 1174. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2015072704727Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING IN THE AFT CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES IN THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR DALA2015072504708Intercostal · crackedCRACKED INTERCOSTAL X 7, BS 938 AT KEELBEAM. THE INTERCOSTAL WAS REPLACED IAW DWG 9936368, REV AW AND SRM 51-30-1 AND 51-30-5.SDR DALA2015072504707Rib · crackedCRACKED RIBS ON FIXED L/E OF VERTICAL STABILIZER, THE RIBS WERE REPAIRED AND REPLACED IAW SRM 55-02D, FIG 27 AND 51-30-5 TO 51-30-2 AND DWG 9911881, ID, 2 REV. C AND 9911882. ID, 2, REV B.SDR DALA2015072504706Heater Blanket · corrodedCORROSION ON RT WING HEATER BLANKET AROUND FUEL ACCESS PANEL CUTOUT. THE HEATER BLANKET WAS REPLACED IAW AMM 30-80-02-401. TESTED THE HEATER BLANKET, FOUND OK IAW AMM 30-80-02-501.SDR DALA2015072504705Longeron · corrodedCORROSION ON LONGERON 22L BETWEEN BS 1287 - 1309 IN CARGO BAY. THE LONGERON WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-3, PAR 14 AND 21.SDR DALA2015072504704Skin · damagedDAMAGED METALLIZED SKIN ON RUDDER CONTROL TAB. METALLIZED SKIN WAS REPAIRED IAW SRM 51-70-1A, PAR 23 AND JIC 2000-8149-16.SDR DALA2016111108825Skin · corrodedTHE FUSELAGE SKIN & INTERNAL DOUBLER AT THE AFT LAV WASTE PANEL BS 1307-1322, L21 - 22L, WERE CORRODED AND REQUIRED REPAIR DOUBLERS.SDR DALA2015072404646Access Panel · corrodedCORROSION FOUND ON THE ACCESS PANEL 1357C COUNTERSINK. THE CORROSIONWAS REMOVED AND FOUND WITHIN LIMITS IAW SRM 51-22-2A, PAR 6, FIG 8. BUSHINGS WERE FABRICATED IAW SRM 51-22-2A, PARA 6, FIG 8. THE BUSHINGS AND AREA WERE TREATED AND THE BUSHINGS WERE INSTASDR DALA2015072404645Intercostal · crackedCRACKED REPAIR ON INTERCOSTAL BS 1041, X -0. INTERCOSTAL AND REPAIR WERE REMOVED, REPAIR WAS FABRICATED, TREATED, PAINTED AND INSTALLED, INTERCOSTAL WAS INSTALLED IAW SRM 51-30-2, 51-30-5, AND 51-10-3.SDR DALA2015072404644Access Panel · corrodedCORRSION ON FUEL ACCESS PANEL 1409C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015072404643Access Panel · corrodedCORROSION ON FUEL ACCESS PANEL. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015072404640Bushing · corrodedCORROSION ON REPAIR BUSHINGS AND ELONGATED BUSHINGS ON RT HEATER BLANKET T/E. DAMAGE BUSHINGS WERE REPLACED IAW ER/A 537709-14AD, REV "A" AND EA: 09-070683-03, AD REV L. MAJOR REPAIR.SDR DALA2015072404639Longeron · crackedCRACKED LONGERON 8R BS 1307. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015072404637Skin · corrodedCORROSION FOUND BETWEEN FUSELAGE SKIN AND INBD DOUBLER AT AFT WASTE LAVATORY SERVICE PANEL. CORROSION WAS REMOVED IAW ETI-88-15-224, REV 1 AND ER/A 536427-14, REV ORIGINAL.SDR DALA2015072404636Barrel Nut · corrodedCORROSION ON NR 1 BARREL NUT, XH 6-22, RT SIDE AT HORIZONTAL STABILIZER. REPAIRED IAW ETI- 88-15-256, REV 1, AND ER/A 536512-14, REV ORIGINAL.SDR DALA2015072404635Floor Panel · puncturedPUNCTURE ON FLOOR PANEL. THE FLOOR PANEL WAS FABRICATED, AND REPLACED IAW AMM 53-20-01-201.SDR DALA2015072404634Floor Panel · damagedDAMAGE FERRULE ON FLOOR PANEL. THE FLOOR PANEL WAS FABRICATED AND REPLACED IAW AMM 53-20-01-201.SDR DALA2015072404633Floor Panel · puncturedPUNCTURE ON FLOOR PANEL. THE FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2015072404632Skin · damagedDURING DECAL INSPECTION, FOUND SEVERAL SCRATCHES ON REPAIR DOUBLER OF LT HORIZONTAL STABILIZER L/E. AREA WAS REPAIRED IAW ER/A 531449-14, REV "C" SECTION 3.SDR DALA2015072404630Skin · crackedA 0.187 INCH CRACK ON FUSELAGE SKIN, BS 1418 BETWEEN LONGERONS 2 - 3L AND A CRACK OF 0.531" BETWEEN LONGERON 1 AND 2R. FUSELAGE SKIN WAS REPAIRED IAW ER/A 536455-14AD, REV ORIGINAL AND ETI 88-15-204, REV 2.
Back to Mcdonnell Douglas MD-88