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 DALA2015082705244Finger Doubler · corrodedCORROSION ON FINGER DOUBLER LONGERON 26LT AT BS 587 TO 613. FINGER DOUBLER WAS REPLACED IAW SRM 53-34-0 AND 51-10-1. CORROSION WAS REMOVED AND REWORKED AREA WAS TREATED AND PAINTED.SDR DALA2015082705243Cusp Web · puncturedPUNCTURED CUSP WEB BS 1199 LBL 52. REPAIRED IAW SRM 53-05, FIG 134A-17.SDR WX0A2015082772835Battery · dischargedROW 15 - 20 EMER EXIT LIGHTS INOPERATIVE. R & R BATTERIES IAW AMM 33-53-00. OPERATIONS CHECKED GOOD.SDR DALA2015082605224Hinge · damagedACFT HAS ELONGATED HOLE ON FWD HINGE OF FWD CARGO DOOR. HINGE REPAIRED IAW ER/A 497387-14 MA, REV B.SDR DALA2015082605223Torque Tube · corrodedCORROSION ON RUDDER DRIVE TORQUE TUBE. RUDDER DRIVE TORQUE WAS REPLACED IAW AMM 27-00-00 .SDR DALA2015082605220Longeron · crackedACFT HAS CRACKS ON LONGERON 4L BS 541. THE LONGERON WAS REPLACED IAW SRM 53-02, FIG 18, 51-30-2 AND 51-30-5.SDR DALA2015082605219Access Panel · damagedACFT HAS ELONGATED HOLE ON FUEL ACCESS PANEL 1367C. ACCESS PANEL WAS REPLACED.SDR DALA2015082605218Trunnion · corrodedACFT CORROSION ON RT MLG SUPPORT BUSHING BORE. DAMAGE ON BUSHING BORE WAS REPAIRED IAW CARD 5740-01139-04B, DWG SR09570087, NOTE 11, REV B.SDR DALA2015082605217Skin · damagedACFT HAS EXPOSED COMPOSITE MATERIAL ON RUDDER CONTROL TAB. RUDDER CONTROL TAB WAS REPAIRED IAW SRM 51-70-1AD PARR 23A. BALANCE AND WEIGHT CHECKS WILL BE ATTENDED WITH CARD 18 ACFT ZONE 65, W/O 20000077129.SDR DALA2015082605216Doubler · delaminatedDELAMINATED DOUBLER ON INTRADOSE OF INBD FLAP INBD GUIDE VANE AT RT WING. INBD FLAP, INBD GUIDE VANE AT RT WING WAS REPAIRED IAW SRM 57-03D, PAR 11.SDR DALA2015082605215Skin · crackedCRACK ON OUTER SKIN NEAR BEAM NR 4 IN LT LOWER AFT CORNER AT VENTRAL DOOR. REPAIR WAS ACCOMPLISHED IAW ERA 537757-14, REV ORIGINAL AND ETI-88-15-300.SDR DALA2015082605214Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015082605213Skin · crackedTWO CRACKS WERE FOUND ON FUSELAGE SKIN AND DOUBLER AT THE AFT LOWER CORNER OF: 0.250", FUSELAGE SKIN AND 1.593", DOUBLER AT BS 423.750 AND BETWEEN LONGERON 26 AND 27 RT. CRACKS ON FUSELAGE SKIN WERE REPAIRED IAW SRM 53-05, FIG 105.SDR DALA2015082605211Intercom · crackedACFT HAS CRACKED INTERCOSTAL, BS 1338-1350 AND RBL 18 AT RT AFT LAVATORY AREA. THE INTERCOSTAL WAS REPAIRED IAW SRM 53-1 FIG. 2.SDR DALA2015082605210Skin · nickedSEVERAL NICKS ON INBD FLAP LOWER SKIN ON RT WING. REPAIRED IAW SRM 57-03D FIG 8.SDR DALA2015082605209Doubler · corrodedCORROSION ON PRODUCTION DOUBLER BS 200-218 BTW LONGERONS 29 AND 30R. THE DOUBLER WAS REPLACED IAW DWG 9911520-147 REV. W.SDR DALA2015082505201Fairing · crackedCRACKED REPAIR DOUBLER ON RT HORIZONTAL STABILIZER FAIRING 3806A. REPAIR WAS ACCOMPLISHED IAW ER/A 464895-14MA, REV F, SRM 51-30-2, 51-10-2, 51-10-3 PAR 14/21, CARD 2000.SDR DALA2015082505199Fairing · crackedCRACK ON LOWER FAIRING 3703A AFT SECTION. DAMAGE AREA WAS CUT OUT IAW SRM 55-03, D FIG 17 AND ERA 464895-14MA, REV F AND WAS REPAIR IAW SRM 55-03-D, FIG 17 AND ERA 464895-14MA, REV F.SDR DALA2015082505197Frame · corrodedCORROSION ON FRAME LOWER SECTION BS 1380 AT ACCESSORY COMPARTMENT. FRAME SECTION REPLACED IAW SRM 51-30-2 AND 51-30-5 AND DWG 9912246, REV CE.SDR DALA2015082505194Doubler · corrodedCORROSION ON DOUBLER AT RADIO ALTIMETER CUT OUT BS 674 - 693. THE DOUBLER WAS REPLACED IAW SRM 51-30-2, 51-30-5 , 51-30-3 P.26, 21, 14, 53-01 FIG 1, AND DWG 5911412, REV DV.SDR DALA2016111109133Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN RBL 54 TO 60, BS 667 - 672. REPAIRED IAW SRM 53-05 FIG 131A -12.SDR DALA2015091405618Structure · corrodedCORROSION AT RT MLG FIXED DOOR, AREA COVERED BY RUB STRIP. MLG FIXED DOOR WAS REPLACED IAW AMM 32-12-01.SDR DALA2015082805267Tab · dentedSEVERAL DENTS FOUND ON THE CONTROL TAB UPPER SURFACE OF THE RIGHT ELEVATOR. REPAIRED IAW SRM 55-04, PAR 2.SDR DALA2015082605212Skin · damagedACFT HAS DAMAGED METALIZED ON RUDDER SKIN BOTH SIDE. METALLIZED ON RUDDER SKIN BOTH SIDE WAS REPAIRED IAW SRM 51-70-1A AND JIC 9818779 CARD 200-8149-05.SDR DALA2015082505198Slat Track · damagedELONGATED HOLES ON SLAT TRACK DOOR NR 1 AT LT WING. SLAT TRACK DOOR NR 1 LT WAS REPLACED IAW ERA: 512356-14MA, REV ORIG SEC II.SDR DALA2015082505195Web · damagedTOOL DAMAGE ON MEMBRANE BS 194 AND X=41 ALSO ON BS 198 AND X=23. MEMBRANE WAS REPAIRED IAW SRM 51-70-4, FIG 2, SRM 51-10-3, PAR 14, 21 SRM 51-30-2, SRM 51-30-5.SDR DALA2015082405188Floor Panel · delaminatedDELAMINATED FLOOR PANEL 389C IN PAX CABIN. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015082405186Battery Pack · inoperativeMAINTENANCE FOUND CABIN SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE FROM ROWS 17-24DE. THE BATTERIES WERE REPLACED.SDR DALA2015082405185Guide Vane · damagedNICKS AND WEAR ON REPAIR DOUBLER ON INBD FLAP, GUIDE VANE LT WING. REPAIR DOUBLER WAS REPLACED IAW SRM 57-03D, PAR 11.SDR DALA2015082405184Skin · damagedDAMAGED METALLIZATED COAT OF RUDDER. METALLIZATED COAT OF RUDDER WAS REPAIRED IAW SRM 51-70-1A, PAR 23.SDR DALA2015082405183Door Frame · corrodedCORROSION ON LOWER DOOR FRAME IN THE MID CARGO BAY, BS 636 - 693. DOOR FRAME WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-3 PAR. 14 - 21 AND DWG 5936038, REV. A.SDR DALA2015082405182Longeron · crackedCRACK ON LONGERON 4R, BS 541 AT PAX CABIN. THE LONGERON WAS REPAIRED IAW IAW SRM 53-02, FIG 18.SDR DALA2015082405181Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 1183 - 1185 AND RBL 54 TO 60. DAMAGE WAS REMOVED IAW SRM 53-05, FIG 131A-13. REPAIR WAS FABRICATED, TREATED, PAINTED AND INSTALLED IAW SRM 53-05, FIG 131A-13, 57-10-3, 51-30-2 AND 51-30-5.SDR DALA2015082405180Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN LOWER EDGE AND BS 389 . THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-2.SDR DALA2015082405178Longeron · corrodedCORROSION ON LONGERON 23L BS 1174. THE LONGERON WAS REPAIRED IAW SRM 51-10-3, PAR 14, 21, 53-02 PAR 12 FIG 18.SDR DALA2015082405177Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN LBL 54 - 60, BS 636 - 648. THE CUSP WEB WAS REPAIR IAW SRM 51-30-5 AND 53-05, FG 131A-7.SDR DALA2015082605221Skin · dentedACFT HAS SEVERAL DENTS ON OUTER SKIN OF MID CARGO COMPARTMENT DOOR. THE CARGO DOOR WAS REPLACED.SDR DALA2015082405189Cusp Web · corrodedCORROSION OUT LIMITS ON RT CUSP WEB LBL 54 - 60 BETWEEN BS 262-264 AND 452-465. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-14 AND 51-10-3 PAR 21 AND 14.SDR DALA2015082405179Guide Vane · wornWEAR ON OTBD FLAP, OTBD FLAP VANE UPPER AND LOWER SKIN INBD EDGE AT LT WING. REPAIRED IAW SRM 57-03, PAR II AND OPN 1031.SDR DALA2015082305176Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN, BS 827 BETWEEN LONGERONS 1 - 2R. THE SKIN WAS REPAIRED IAW SRM 53-04-2, PAR 3.C 2, A, 1, A.SDR DALA2015082305175Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BS 681 BETWEEN LONGERONS 2-3R. SKIN REPAIRED IAW SRM 53-04-2, PAR 3.C, 2, A,1,A.SDR DALA2015082305174Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER ON LT CUSP WEB BETWEEN RBL 54 - 60 AND BS 827 - 840. THE DOUBLER WAS REMOVED, A NEW DOUBLER FABRICATE, TREATED. PAINTED, AND INSTALLED IAW SRM 51-30-2, 53-05, FIG 131, 51-10-3, PAR 21, 14.SDR DALA2015082305173Cusp Web · corrodedCORROSION ON CUSP WEB REPAIR DOUBLER BETWEEN BS 1174 - 1193 BETWEEN LBL 54-60. DOUBLER WAS REPLACED IAW SRM 53-05, FIG 131A-5, 51-30-2, 51-10-3 PAR 21, 14, 38 AND 51-30-1.SDR DALA2015082305172Cusp Web · corrodedCORROSION ON RT CUSP WEB REPAIR DOUBLER LBL 54 - 60 BETWEEN BS 237 - 241 AND 484 - 503. DOUBLERS WERE REPLACED IAW SRM 53-05, FIG 131A- 7, 51-30-2 AND 51-30-5.SDR DALA2015082305171Web · crackedCRACKED WEB NEXT TO PULLEY BRACKET BS 1352, RBL 18. WEB WAS REPAIRED IAW SRM 53-01, FIG 2, SHT. 4 AND SRM 51-10-3, PAR 14 AND 21, SRM 51-30-5.SDR DALA2015082305170Skin · delaminatedRT WING T/E, UPPER SURFACE PANEL DELAMINATED JUST OTBD OF FUSELAGE. R & R THE PANEL IAW DWG 9936821.SDR DALA2015082805273Door · corrodedCORROSION FOUND ON LT OTBD MLG DOOR, AREA COVERED BY RUB STRIP. OTBD MLG DOOR WAS REPLACED IAW AMM 32-12-01.SDR DALA2015082605225Cover · damagedAFT TAILCONE SLIDE COVER FWD HOLDDOWN STRAP WAS FOUND DAMAGED. MAINTENANCE REPLACED HOLDOWN STRAP.SDR DALA2015082505200Tab · delaminatedDELAMINATED LT ELEVATOR ANTI-FLOAT TAB. DUE TO EXCESSIVE DAMAGE, FOUND THE ANTI-FLOAT TAB WAS REPLACED IAW SRM 55-04 P.2.SDR DALA2015082405190Bulkhead · corrodedCORROSION ON BULKHEAD AT VENTRAL STAIRWAY STRUCTURE BS 1439. THE BULKHEAD WAS REPLACED IAW SRM 51-30-2, 51-10-2, 51-10-3 PAR 14-21.
Back to Mcdonnell Douglas MD-88