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 DALA2015102506471Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER ON RT CUSP WEB BETWEEN BS X -54 TO -60 AND BS 733 - 740 IN PAX CABIN. CORROSION WAS ATTENDED IAW SRM 53-05, FIG 131A-6, 51-30-2, 51-10-3 PAR 21, 14, AND 38.SDR DALA2015102506470Cargo Track · corrodedCORROSION ON LT CARGO TRACK BETWEEN BS 1003 - 1322. THE CARGO TRACK WAS REPLACED IAW SRM 51-30-1, 51-10-4, 51-10-3, AND 51-30-2.SDR DALA2015102506469Cargo Track · corrodedCORROSION ON RT CARGO TRACK BETWEEN BS 1212 - 1322. THE CARGO TRACK WAS REPLACED IAW SRM 51-30-1, 51-10-4, 51-30-2, AND 51-10-3, PAR 21, 14, AND 38.SDR DALA2015102506468Cusp Web · corrodedCORROSION ON LOWER AND UPPER SURFACE LT CUSP WEB BS 446 - 465, X 54 -X 60. CORROSION WAS FOUND EXCESSIVE THEREFORE AREA WAS REPAIRED IAW SRM 53-05, FIG 131A -13 SH 1.SDR DALA2015102506467Web · crackedCRACKED WEB BS 210, LONGERON 11L . DAMAGE WAS REMOVED AND AREA WAS REPAIRED IAW SRM 53-05, PAR 153.SDR DALA2015102506463Bolt · crackedCRACKING ON CHROME PLATING ON LT LOWER YOKE MOUNT BOLT. YOKE MOUNT BOLT WAS REPLACED AND INSTALLED.SDR DALA2015102506448Cargo Track · corrodedCORROSION ON SPLICE BETWEEN BS 1212-1236 AND LT TIE TRACK AT AFT CARGO COMPARTMENT. SPLICES WERE REPLACED IAW SRM 51-30-5 , 51-10-4 AND 51-10-3 PAR. 21,14 AND 38.SDR DALA2015102506447Frame · crackedCRACK ON FRAME AT BS 1322 AND LONGERON 17L. THE FRAME WAS REPAIRED IAW ER/A 493697-14MA, REV B.SDR DALA2015102506442Access Panel · corrodedCORROSION ON COUNTERSINK AT LT FUEL TANK NR 1371C. ACCESS WAS REPAIRED IAW SRM 51-22-2A AND COUNTERSINK HOLES WERE MEASURED AND MAX DIAMETER ALLOWABLE IS .532" AND MAX DIAMETER MEASURED IS .561" IN 3 HOLES THEREFORE IS WITHIN LIMITS AND WAS REPAIRED UNDER COSDR DALA2015102506441Access Panel · corrodedCORROSION ON COUNTERSINK ON LT WING ACCESS PANEL NR 1367C. ACCESS PANEL WAS REPLACED.SDR DALA2015102406440Frame · crackedTAIL INTERIOR - CANTED FRAME RT WEB IB EDGE HAS 1.2500" LONG CRACK AT HORIZONTAL "T" ANGLE, BS 1485, NEAR RUDDER TRIM CABLE DRUM. REPAIRED CANTED FRAME REF SRM 53-03D, FIG 49.SDR DALA2015102506466Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1373C. A BUSHING WAS INSTALLED IAW SRM 51-22-2A.SDR DALA2015102506465Cusp Web · corrodedCORROSION, OUT LIMITS, ON RT CUSP WEB BETWEEN BS X -54 TO -60 AND BS 1225 - 1237 IN PAX CABIN. THE CUSP WEB WAS REPAIRED IAW SRM 51-30-1, 51-30-2, 51-30-5, 53-05, FIG 131A AND 51-10-3, PAR 21, 14, AND 38.SDR DALA2015102506464Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCES PANEL 2302C. BUSHING WAS INSTALLED IAW SRM 51-22-2A.SDR DALA2015102506462Access Panel · corrodedCORROSION ON COUNTERSINK, OF ACCESS PANEL 1357C. BUSHING WAS INSTALLED IAW SRM 51-22-2A.SDR DALA2015102506461Skin · wornWEAR AT T/E LOWER SKIN OF INBD VANE OTBD RT WING TE FLAP . REPAIRED IAW ER/A 492663-14MA, REV ORIGINAL.SDR DALA2015102506460Access Panel · corrodedCORROSION ON COUNTERSINK OF ACCESS PANEL 1476C. REPAIRED AND FOUND WITHIN LIMITS. BUSHING WAS FABRICATED AND COUNTERSINK IAW SRM 51-22-2A. AREA AND BUSHING WERE TREATED AND PAINTED IAW SRM 51-10-3, PAR NR 14 AND NR 21. NEW BUSHING WAS INSTALLED IAW SRM 51SDR DALA2015102506445Skin · gougedVERTICAL STABILIZER TIP MID SECTION RT AFT SKIN HAS 2 DEEP 3" LONG GOUGES, ABOVE HORIZONTAL STABILIZER HINGE. REPAIRED IAW PRI 540664-14, REV 0 AND C/W ERA 540664-14, REV A.SDR DALA2015102406438Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER ON RT CUSP WEB BTW X=-54 TO -60 AND BS 770 -- 776. NEW REPAIR DOUBLER WAS FABRICATED REPAIR WERE TREATED AND PAINTED, REPAIR INSTALLED CIC WAS APPLIED IAW SRM 51-30-2, 51-10-3 PAR 14, 21, 38, 53-05 FIG. 131A-11.SDR DALA2015102406437Seat Track · corrodedCORROSION ON SEAT TRACK BS 231, X=44. SEAT TRACK WAS REPLACED IAW SRM 51-30-1; 51-30-5 AND 51-10-4.SDR DALA2015102406436Cusp Web · corrodedCORROSION ON REPAIR ON LT CUSP WEB X=44 TO X=54, STA 1164 - 1174. PREVIOUS REPAIR WAS REMOVED AND NEW DOUBLER REPAIR WAS INSTALLED IAW SRM. 51-30-2, 53-05, FIG 131A, 51-10-3, PAR 14 AND 21.SDR DALA2015102506446Skin · wornVERTICAL STABILIZER LT SIDE SKIN IS WORN AT HORIZONTAL STABILIZER SIDE LOAD ROLLER. REPAIRED IAW PRI 540677-14, REV 0 AND WAITING FOR FINAL ER/A.SDR DALA2015102406439Web · corrodedSEVERAL CORROSION POINTS ON MEMBRANE FROM BS 160 TO 200 AND FROM X=44 TO X=54. CORROSION WERE REMOVED DAMAGE WERE EVALUATED DUE TO EXCESIVE CORROSION WILL BE REPLACED MEMBRANE WAS FABRICATED, MEMBRANE AND PARTS TREATED, PAINTED AND INSTALLED IAW SRM 51-30-10SDR DALA2015102406435Access Panel · puncturedPUNCTURED FUEL ACCESS PANEL, RT WING. ACCESS PANEL WAS REPAIRED IAW ER/A ADMA.SDR DALA2015102406434Access Panel · puncturedPUNCTURES SECOND DUAL ACCESS PANEL, LT WING. ACCESS PANEL WAS REPAIRED IAW ERA 530866-14.SDR DALA2015102406433Longeron · corrodedCORROSION ON END LONGERON 12L BETWEEN BS 1446 TO 1463. LONGERON WAS REPLACED IAW SRM 51-30-2, 51-30-5,53-01 FIG 1,51-10-01, FIG 14.SDR DALA2015102406432Doubler · crackedCRACK LT MLG UPPER DOUBLER AT LT WING XCW 110. UPPER DOUBLER WAS REPAIRED IAW SRM 57-03, FIG 34 AND SRM 51-30-5, SRM 51-10-3, PAR 14, 21.SDR DALA2015102306403Valve · leakingFLIGHT CREW REPORTED THAT BOTH AFT LAVATORY SMOKE DETECTORS WERE SOUNDING AND CONFIRMED THERE WAS SMOKE AND FUMES PRESENT. THE ACFT RETURNED TO MSP. MAINTENANCE FOUND THAT THE APU INLET WAS CONTAMINATED WITH HYDRAULIC FLUID AND THAT THE RUDDER POWER-MAN VALVSDR DALA2015102306402Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING IN THE VENTRAL STAIRWAY ARE VERY DIM. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPS CHECK WAS GOOD.SDR DALA2015102306401Cusp Web · corrodedCRACKS ON LT CUSP WEB FROM BS 218 X=44 - X=54. CUSP WEB WAS REPAIRED IAW SRM 53-01, FIG 4 AND 51-30-5.SDR DALA2015102306398Cusp Web · corrodedCORROSION, OUT LIMITS, ON RT CUSP WEB BETWEEN BS X=-54 TO -60 BS 484 - 503 AT PAX CABIN FLOOR STRUCTURE. DAMAGE WAS REMOVED, REPAIR PARTS WERE FABRICATED, REPAIR PARTS WERE TREATED AND PAINTED, REPAIRED PARTS WERE INSTALLED, CIC WAS APPLIED IAW SRM 53-05, FSDR DALA2015102306397Support Fitting · corrodedAD/AA CORROSION AT BORE DIAMETER, INNER, OF RT MLG RETRACT ACTUATOR SUPPORT FITTING. CORROSION ON BORE WAS REMOVED WITH A INITIAL MEASURE OF DIAMETER 2.250" AND FINAL MEASURE AFTER REWORK OF 2.260" WITHIN LIMITS IAW DWG SR09570087, REV B FPI WAS PERFORMED AND SDR DALA2015102306396Access Panel · corrodedCORROSION AT SETTLEMENT AREA AND COUNTERSINK AREAS OF FUEL ACCESS PANEL 1462C. ACCESS PLATE 1462C WAS REPLACED AND WILL BE INSTALLED UNDERCARD 2800-0390, JOB NR 001-0402.SDR DALA2015102306395Access Panel · corrodedCORROSION AT COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1454C RT WING. ACCESS PLATE 1454C WAS REPLACED AND WILL BE INSTALLED UNDER CARD 2800-0390, JOB 001-0402.SDR DALA2015102306394Support Fitting · corrodedA CORROSION AROUND BORE INBD FACE OF RT MLG RETRACT ACTUATOR SUPPORT FITTING. CORROSION ON BOTH FACE OF BORE WAS REMOVED WITH A INITIAL MEASURE OF 1.237" AND A FINAL MEASURE AFTER REWORK OF 1.230". WITHIN LIMITS IAW DWG 5935812, REV BB FPI WAS PERFORMED AND SDR DALA2015102306382Skin · corrodedCORROSION ON SKIN BELOW OF LONG 26 LT BETWEEN BS 1180 - 1200 AT AFT CARGO COMPARTMENT. FINGER DOUBLER WAS REPAIRED IAW SRM 53-04, FIG 12D AND 12E.SDR DALA2015102306381Support · corrodedCORROSION ON AFT BULKHEAD PANEL SUPPORTS AT AFT CARGO COMPARTMENT UPPER, LT, RT AND CENTER SIDE. CORROSION ON LT AND RT SUPPORTS PANELS BULKHEAD WAS ATTENDED WITH MEASSURED AS FOLLOW: UT, WAS ACCOMPLISHED IAW NDT SPM 04-00-07, PAR 5, FIG 3, SHEET 1-2. ORIGISDR DALA2015102306379Longeron · crackedCRACK ON BS 160 AND LONGERON 4LT SIDE AT C PAX. DAMAGE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015102306378Cusp Web · corrodedCORROSION ON RT CUSP WEB MEMBRANE FROM BS 440 TO 503 UPPER AND LOWER SURFACES INCLUDING REPAIR DOUBLERS AT PAX CABIN BETWEEN X=-54 TO X=-60. AREA OUT OF LIMITS WAS ATTENDED IAW SRM 51-30-1, 51-30-2, 51-30-5, 51-30-3 PARR. 14, 21, 26, 53-05, FIG 131A-11.SDR DALA2015102306377Access Panel · corrodedCORROSION AT SETTLEMENT AND COUNTERSINK AREAS OF FUEL ACCESS PANEL 1470C. ACCESS WAS REPLACED IAW SRM 51-22-2A CONDITIONER II AND WILL BE INSTALLED UNDER CARD 28-0390, JOB 001-0402.SDR DALA2015102306376Access Panel · corrodedCORROSION AT SETTLEMENT AND COUNTERSKIN AREAOF FUEL ACCESS PANEL 1307C. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A CON II AND WILL BE INSTALLED UNDER CARD 2800-0120, JOB 001-0396.SDR DALA2015102306375Skin · crackedSKIN BENEATH DIAMOND DOUBLER CRACKED BS 1410 AT LONGERON 2L. REPAIRED IAW PRI 540097-14, REV 0 AND WAITING FOR FINAL ER/A.SDR DALA2015102306374Longeron · crackedCRACK ON BS 160 AND LONG 3L SIDE AT C. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015102306373Support Fitting · corrodedCORROSION AT BORE OF LT MLG RETRACT ACTUATOR SUPPORT FITTING. BORE WAS REPAIRED, CORROSION WAS REMOVED, WITH FINAL MEASURE: WITHIN LIMITS IAW DWG SR09570087, REV B.SDR DALA2015102306369Cusp Web · corrodedCORROSION OUT OF LIMITS ON LT CUSP WEB X=54 TO 60 BETWEEN BS 826 - 845 AT PAX CABIN FLOOR STRUCTURE. FASTENERS WERE REMOVED IAW SRM 51-30-2. REPAIR PARTS WERE FABRICATED IAW SRM 53-05, FIG 131-A-13. REPAIR PARTS WERE TREATED/PAINTED IAW SRM 51-10-3 PAR 14 ASDR DALA2015102306372Frame · crackedCRACKED FRAME ANGLE AT BS 1458 AT LONGERONS 2L AND 2R. FABRICATED AND INSTALLED IAW DWG 9911860, REV 2 AND SRM 51-10-3, PARTS 21, 14 AND 51-30-5.SDR DALA2015102306371Frame · corrodedCORROSION ON FRAME BS 1287 BETWEEN LONGERONS 29L TO 29R AT AFT CARGO COMPARTMENT. FRAME WAS REPAIRED IAW SRM 53-03, FIG 2A.SDR DALA2015102306370Former · crackedCRACKED FORMER BS 1458, BESIDE LONGERON 3L AT AFT ACCESSORIES COMPARTMENT. THE FORMER WAS REPAIRED IAW SRM 53-01, FIG 2.SDR DALA2015102206335Stop Fitting · crackedCRACK ON AFT OUTPAN BELOW STOP FITTING NR 5. AFT OUTPAN WAS REPAIRED IAW ER/A 539914-14, REV ORIGINAL.SDR DALA2015102206334Doubler · crackedTAIL INTERIOR - DIAMOND SHAPED ACFT SKIN DOUBLER AT BS 1410 IB OF L2L IS CRACKED 2 PLACES. SEE NR FOR ADDITIONAL INFORMATION 001-0279:5300-2551/018 00077, WORK TO BE ACCOMPLISHED ON NR 137 AND PRI/ERA 540097-14AD, REV ORIG.
Back to Mcdonnell Douglas MD-88