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 DALA2015061803860Stop Fitting · wornWEAR AND ELONGATE STOP PADS AROUND TAILCONE FRAME. PADS WERE REMOVED AND REPLACED IAW SRM 51-30- 2.SDR DALA2015061803859Longeron · corrodedCORROSION ON LONGERON 22L BS 1338. REPLACED IAW SRM 51-30-5, 51-10-4, 51-10-3.SDR DALA2015061803858Longeron · corrodedCORROSION ON LONGERON 22L BS 1287 - 1309. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18. MAJOR REPAIR.SDR DALA2015061803857Intercostal · wornWORN INTERCOSTAL BS 1322-1338 BETWEEN LONGERONS 21- 22L . INTERCOSTAL WAS REMOVED AND A NEW INTERCOSTAL FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2015061803856Floor Panel · delaminatedDELAMINATED FLOOR PANEL. A NEW FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015061803855Floor Panel · damagedMISSING AND DAMAGED FERRULE IN FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-0-201.SDR DALA2015061803854Longeron · crackedCRACKED LONGERON NR 16R AT AFT ACCY COMPARTMENT BS 1437. SM, ZONE 61. LONGERON WAS REPLACED IAW SRM 51-30-2, 51-30-5 AND 53-14-4, FIG 4, LONG CRACK .800".SDR DALA2016111008556Angle · corrodedCORROSION ON LOWER PRODUCTION ANGLE BS 1338, LONGERONS 28R & 28L. THE ANGLE WAS REPLACED IAW SRM 51-30-5, 51-30-2 AND DRAWING 9915561 REV CG.SDR DALA2015061703853Spar · damagedELONGATED HOLE ON UPPER REAR SPAR AT RT HORIZONTAL STABILIZER BS XHR=209, HINGE 6, VHS, SM, CARD 6, ZONE 034. DAMAGE ON HOLE, UPPER REAR SPAR WAS REPAIRED IAW ETI-88-15-190 REV ORIG AND ER/A 536434-14.SDR DALA2015061703852Longeron · crackedCRACKED LONGERON 16L BS 1437. THE LONGERON WAS REPLACED IAW SRM 51-30-2 & SRM 51-30-5 & SRM 53-14-4 FIG 4.SDR DALA2015061703851Longeron · crackedCRACKED LONGERON 13L AT AFT ACCESSORY COMPARTMENT BS 1380. THE LONGERON WAS REPLACED IAW SRM 51-30-2 AND 51-30-5 AND 53-14-4, ITEM 4.SDR DALA2015061703850Longeron · corrodedCORROSION ON TEE CAP BS 1338, PROJECTION LONGERON 28LT AT AFT CARGO COMPARTMENT, C3, SM, IN REF CARD 2, ZONE 57, MRB 53-139-05, CARD 11 ZONE 57. TEE CAP WAS FOUND WITH EXCESSIVE CORROSION THEREFORE TEE CAP STA Y=1338 WAS PREPARED IAW SRM 53-03, FIG 37 AND EXTSDR DALA2015061703849Longeron · crackedCRACK ON LONGERON END 17R, BS 1338 AT FUSELAGE CABIN STRUCTURE. LONGERON END REPLACED IAW SRM 53-14-3, 51-30-5.SDR DALA2015061703848Doubler · corrodedCORROSION ON AFT PRESSURE BULKHEAD PRODUCTION DOUBLER BETWEEN LONGERON 29 RT TO 29 LT AT AFT CARGO COMPARTMENT, C3, SM, MRB 53-139-05, CARD 3, ZONE 57. PRODUCTION DOUBLER WAS FOUND WITH EXTENSIVE CORROSION THEREFORE AFT PRESSURE BULKHEAD PRODUCTION DOUBLER WASDR DALA2015061703847Frame · crackedCRACKED FRAME BS 1451 LONGERON 1. REMOVED AND REPLACED THE FRAME IAW SRM 51-30-2, 51-30-5, SRM 51-10-4 , SRM 51-10-3 PAR. 21-14, AND SRM 51-30-2, 51-30-5.SDR DALA2015061703813Light · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 16D IN THE CABIN WAS BROKEN. MAINTENANCE REPLACED THE PIGTAIL AT THE LIGHT AND THE SYSTEM RETURNED TO NORMAL OPERATION.SDR DALA2015061703810Battery Pack · malfunctionedDURING LINE CHECK, MAINTENANCE FOUND THEY COULD NOT CONTROL THE EXTERIOR EMERGENCY LIGHTING AT THE OVERWING EXIT, IT WOULD REMAIN ON WHEN THE CONTROL SWITCH WAS TURNED OFF. MAINTENANCE REPLACED THE BATTERY PACK FOR THE NOTED LIGHT AND THE OPS CHECK WAS GOOD.SDR DALA2015061603846Skin · corrodedCORROSION ON RIB HOLES STA XOS=332 AT RT WING SLAT PANEL NR 3, RW,SH-CP-SM, CARD 5, ZONE 12. DAMAGE ON RIB HOLES STA XOS= 332 WAS REPAIRED. IT WAS IN AFT HOLES WITH FINAL DIMENTIONS: 1D= 0.938", THEREFORE WITHIN LIMITS IAW SRM 57-02, PAR 9 AND REPAIR BUSHINGSDR DALA2015061603845Stiffener · crackedCRACK ON UPPER OF AFT PRESSURE BULKHEAD STIFFENER 4 AND STA X=60. ANGLE WAS REPLACED IAW SRM 51-30-1, 51-30-5, 51-10-4.SDR DALA2015061603844Pan · crackedCRACKED INNER PAN AT AFT CARGO DOOR AFT END AND BEAM NR 5. CRACK ON INNER PAN WAS STOPPED IAW SRM 51-01. HFEC INSPECTION WAS ACCOMPLISHED AND NO CRACKS WERE FOUND AROUND STOP DRILL 51-01 (21) NEW DOUBLER WAS FABRICATED AND PAINTED IAW SRM 51-03D, FIG. 8 AND SDR DALA2015061603842Longeron · bentBENT LONGERON 17L BS 256. REMOVED AND REPLACED THE LONGERON SECTION IAW SRM 53-02, FIG 18.SDR DALA2015061603841Seat Track · corrodedCORROSION ON LT SEAT TRACK X=44 BETWEEN BS 1116-1121. DUE TO EXCESSIVE DAMAGE ORIG 0.100", MIN IS 0.040", SECTION SEAT TRACK WAS REPLACED IAW 51-30-1, 51-30-2, 51-30-5, 51-10-4, 51-10-3 PAR 14 AND 21, SRM 53-05, FIG 4F.SDR DALA2015061503840Fitting · corrodedCORROSION ON LT MLG SUPPORT FITTING BUSHING BORE . DAMAGE ON BUSHING BORE WAS REPAIRED WITH FINAL DIAMETER: 2.2885" THEREFORE WITHIN LIMITS IAW DWG SR09570087, REV BB.SDR DALA2015061603812Duct · contaminatedCREW REPORTED SMOKE, ODOR IN AFT CABIN ON DESCENT WITH AFT RIGHT LAVATORY SMOKE DETECTOR ALERTING MOMENTARILY. MAINTENANCE BOROSCOPED BOTH ENGINES LOOKING FOR SIGNS OF OIL RESIDUE, NONE FOUND. REQUEST MAINTENANCE REPLACED THE RECIRCULATION FAN AND FILTER. ESDR DALA2015061503837Skin · corrodedCORROSION ON BARREL NUT HOLES NR 10, 15 BS XH=27.34 AT LT HORIZONTAL STABILIZER. BARREL NUT HOLES NR 10, IS WERE ACCOMPLISHED IAW ERA 536433-14, REV ORIG. RII COMPLETED.SDR DALA2015061603843Doubler · wornWEAR ON AFT ACCESSORY TITANIUM DOUBLER AT AFT LAVATORY SERVICE PANEL AREA. DOUBLER WAS REMOVED, NEW DOUBLER WAS FABRICATED, TREATED, PAINTED AND INSTALLED IAW SRM 51-30-2, 51-30-5 AND DWG 5911423, REV CD.SDR DALA2015061503839Bearing · damagedCORROSION AND SCRATCHES ON RT MLG ACTUATOR SUPPORT FITTING BUSHING AND BEARINGS. ACTUATOR SUPPORT FITTING BUSHING AND BEARING ON RT MLG WERE R & R UNDER CARD 10, ZONE 18 AND CARD 5740-01139-04B. RII COMPLETED.SDR DALA2015061503835Bushing · damagedCORROSION AND SCRATCHES ON LT MLG ACTUATOR SUPPORT FITTING BUSHING AND BEARING. ACTUATOR SUPPORT FITTING BUSHING AND BEARING ON LT MLG INSTALLED UNDER CARD 5740-01139-04A, JOB 089-0001 AND CMM 20-10-7. BEARING AND BUSHING WERE REPLACED ON CARD 11, A/C ZONE 17SDR DALA2015061503834Longeron Splice · corrodedCORROSION ON LONGERON SPLICE NR 29L BETWEEN BS 1196-1209 . LONGERON SPLICE R & R IAW SRM 51-30-5.SDR DALA2015061503833Angle · crackedCRACKED ANGLES ON BS 237 BETWEEN LONGERON 27-28L AND 27-28R AT FWD CARGO COMPARTMENT. ANGLES WERE REPLACED IAW SRM 51-30-2, DWG 9915554, REV U, SRM 51-10-3 AND 51-30-5.SDR DALA2015061503832Skin · crackedCRACKED FWD CARGO DOOR SKIN AT AFT UPPER EDGE OF HANDLE CUT OUT. CRACKS WERE REMOVED IAW ER/A 486446-14MA, REV ORIGINAL, HFEC WAS PERFORMED IAW ER/A 486446-14, MA REV ORIGINAL.SDR DALA2015061503831Door Frame · crackedCRACKED INNER PANEL AT FWD CARGO DOOR AFT END AND BEAM NR 4. DAMAGES MEASURED WITHIN LIMITS IAW SRM 52-03D, FIG 10. TREATED AND PAINTED IAW SRM 51-10-3, PAR 14 AND 21, STOP FITTING NR 4 SEAL AND RETAINER WERE INSTALLED IAW SRM 51-10-3.SDR DALA2015061503830Access Panel · damagedCORROSION ON PREVIOUS REPAIR BUSHINGS AT LT WING SETTLEMENT AREA OF ACCESS PANEL 1357C. ACCESS PANEL WAS REPAIRED.SDR DALA2015061503829Access Panel · damagedMISSING REPAIR BUSHING ON CUTOUT FUEL ACCESS RT WING. BUSHING AND CUTOUT ACCESS PANEL WAS REPAIR IAW ETI-88-15-186, REV 1, ER/A 534394-14 REV ORIGINAL.SDR DALA2015061403828Light · no testLEFT AFT WING ANTI-COLLISION LIGHT INTENSITY TEST FAILED. R & R AFT LT WING ANTI-COLLISION LIGHT IAW AMM 33-43-01/201, OPS CHECK GOOD.SDR DALA2015061503772Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING IN THE TAIL COMPARTMENT WAS INOPERATIVE. REPLACED THE BATTERY PACKS AND THE OPS CHECKED GOOD.SDR DALA2015061403827Skin · corrodedCORROSION ON BARREL NUT HOLES NR 8, 10, 14, 16, 20, 21, 24 AND 25 AT RT HORIZONTAL STABILIZER. BARREL NUT HOLES NR 8, 10, 21, 24 AND 25 RT WERE ACCOMPLISHED IAW ERA 536425-14, REV, ORIGINAL BARREL NUT HOLES NR 16, 20 RT WERE ACCOMPLISHED IAW ERA 536433-14, RESDR DALA2015061403801Fitting · corrodedCORROSION WAS FOUND ON THE LT MLG ACTUATOR SUPPORT FITTING BEARING BORE. THE AREA WAS REPAIRED IAW ER/A 534421-14AD REV ORIGINAL AND A NEW BEARING WAS REPLACED.SDR DALA2015061403800Frame · crackedA CRACKED FRAME WAS FOUND AT BS 1485 JUST BELOW VENTRAL STAIR HYD ACTUATOR AT AFT ACCESSORY BAY. THE FRAME WAS REPAIRED IAW SRM 53-03, FIG 43.SDR DALA2015061403798Cusp Web · corrodedCORROSION FOUND ON THE LEFT CUSP WEB X 56 - 60 BETWEEN BS 1198 - 1212. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A -G.SDR DALA2015061403797Cusp Web · corrodedCORROSION FOUND ON THE RIGHT CUSP WEB BETWEEN X 54 TO X 60 AND BS 631, 636, 638, 648, 655, 657, 674 AND 693. THE CUSP WEB WAS REPLACED IAW DWG 9930538, REV 13F, SRM 51-30-2,51-30-5,51-30-1 AND 51-30-8.SDR DALA2015061503773Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS AT ROWS 31-36 WERE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR DALA2015071304328Frame · corrodedCORROSION FOUND ON A REPAIR DOUBLER ON FRAME BS 1309 BETWEEN LONGERONS 28L - 28R IN THE AFT CARGO BAY. THE DOUBLER WAS REPLACED IAW SRM 53-03, FIG 2A SRM 51-30-2, SRM 51-30-5, SRM 51-10-4, AND SRM 51-10-3, PAR 14-21-38.SDR DALA2015061303826Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN BS X=-54 TO -60 AND Y=1003 TO 1022, 1022 TO 1041, 1041 TO 1060, 1060 TO 1079. CUSP WEB WERE REMOVED AND FABRICATED IAW SRM 51-30-2, 51-10-4, 53-14-3, 51-10-3, PAR 26. REPAIR PARTS AND CUSP WEB WERE TREATED AND PAINTED IAW SRMSDR DALA2015061503811Unknown · smokeDURING DECENT FOR LANDING, THE CABIN CREW REPORTED VISIBLE SMOKE IN CABIN. MAINTENANCE REPLACED THE APU AFTER THE BLEED DUCT WAS FOUND DRY. EXTENDED THE DUCT BURNOUT.SDR DALA2015061303796Cusp Web · corrodedCORROSION FOUND ON LEFT CUSP WEB BETWEEN X=54 - 60 AND BS 684 - 693, 693, 712, 731 AND 750. THE CUSP WEB WAS REPLACED IAW SRM 51-30-2, SRM 51-30-5, SRM 51-30-1, SRM 51-10-3, SRM PAR 14-21 AND DWG 9930538, REV BF.SDR DALA2015061303795Skin · crackedTAIL INTERIOR CROWN SKIN IS CRACKED.SDR DALA2015061303794Skin · damagedLIGHTNING STRIKE ON SKIN BS 546.25 AND LONGERON 10L. REPAIRED IAW SRM 53-04-2, FIG 2.SDR DALA2015061303793Cusp Web · corrodedCORROSION FOUND ON LEFT CUSP WEB X=47 TO X=51 BS 846, 885, AND 906. THE CUSP WEB WAS REMOVED AND REPLACED IAW SRM 51-30-2, 51-30-1SDR DALA2015061303792Cusp Web · crackedCRACKED RT CUSP WEB BS 500 BETWEEN X-54 TO X-60. HFEC INSPECTION ACCOMPLISHED, TWO CRACKS OF 0.250" AND 0.370" WERE FOUND IAW NDT SRM 06-10-01.001. A REPAIR WAS FABRICATED IAW SRM 53-05 FIG. 131A-10. DAMAGE WAS REMOVED IAW SRM 53-05, FIG 131A-10. AREA AN
Back to Mcdonnell Douglas MD-88