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 DALA2016121509878Longeron · corrodedCORROSION ON LONGERON 29L BETWEEN BS 1271 - 1309. REPAIRED IAW SRM. 53-02, FIG 18.SDR DALA2016121409850Door · crackedRT WING HAS A CRACKED INBD FLIGHT SPOILER BUTTE DOOR XRS 184. REPAIR THE DOOR IAW SRM 51-70-4 FIG.1 (SHEET 1).SDR DALA2016122310044Longeron · crackedCRACKED LONGERON 23, BS 218. REPAIRED IAW PRI 553592-14 REV 0 AND SRM 53-02 FIG. 18.SDR DALA2016121409849Frame · crackedAFT ACCESORIES BAY HAS A CRACK ON THE FRAME LOWER CAP BS 1431 LONGERONS 11 & 12R. THE FRAME WAS REPAIRED IAW ER/A 552832-14 REV. ORIGINAL AND ETI-88-16-460 REV. 2.SDR DALA2016121409848Skin · corrodedCORROSION ON INNER SKIN BS 1170, LONGERON 18 - 19L. REPAIRED IAW ETI-88-16-453 REV. 2 AND ER/A 552819-14 REV. ORIG.SDR DALA2016121409847Cargo Track · corrodedAFT CARGO BAY HAS CORROSION ON THE LT CARGO TRACK BS 1007 - 1322. REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016121409846Pan · crackedCRACKED MAIN ENTRANCE DOOR PAN ON FWD UPPER CORNER PAN ON FWD UPPER CORNER OF MAIN L1 DOOR. REPAIRED IAW SRM 52-05 FIG. 18A.SDR DALA2016121409845Doubler · corrodedFWD CARGO BAY HAS CORROSION ON A PREVIOUS REPAIR DOUBLER AT LOWER DOOR FRAME PAN BS 370 TO 427. THE REPAIR DOUBLERS WAS REPLACED IAW ER/A 526949-14 REV.ORIG. AND ER/A 383732-14 REV.ORIG.SDR DALA2016121309797Computer · malfunctionedNUMBERS 3 AND 4 MAIN TIRES BLEW ON LANDING. MAINTENANCE NOTED PRIOR ANTI-SKID COMPUTER ISSUE AND REPLACED. REPLACED ALL MAIN TIRES.SDR DALA2016121309796Cable · frayedTAIL CONE KEVLAR CABLE FRAYING. A NEW KEVLAR CABLE WAS INSTALLED IAW AMM 53-53-00.SDR DALA2016121309795Frame · crackedAFT ACCESORY COMPARTMENT, HAS A CRACK ON FRAME BS 1510. REPLACED IAW SRM 51-30-2 AND DWG 9911843-5 REV AC.SDR DALA2016121309794Frame · corrodedAFT ACCESORIES COMPARTMENT, CORROSION ON FRAME BS 1393 LBL 3 TO LBL 10, BETWEEN LONGERONS 25 - 28L. AREA WAS REPAIRED IAW SRM 51-70-5 FIG 1.SDR DALA2016121309852A/C Pack · failedTHE RIGHT PACK CYCLED TWICE AND SHUTDOWN AND THEN SMOKE WAS REPORTED IN THE AFT CABIN. THE COCKPIT AND CABIN TEMPERATURE SELECTORS WHERE BOTH FOUND IN THE MANUAL FULL HOT POSITION. OVERHEATING OF THE RIGHT PACK WAS SUSPECTED. VERIFICATION OF THE RIGHT ACM'S ASDR DALA2016121209793Packing · damagedUNIDENTIFIED SMOKE/BURNING SMELL IN COCKPIT AND AFT CABIN ON ARRIVAL. AFT LAV SMOKE DETECTOR ACTIVATED INTERMITTENTLY. CREW VERBAL ACFT FLEW THRU YELLOW HAZE PRIOR TO ODOR EVENT. TROUBLE SHOT PER ODI CHECK LIST. FOUND HYD LEAK AT FWD ENGINE FILTER MODULE DPI.SDR DALA2016121209791Lanyard · brokenPAX CABIN, BROKEN WIRES ON L2 SLIDE LANYARD. LANYARD WAS REPLACED PER AMM 25-62-00 PARAGRAPH D-4.SDR DALA2016121209788Battery · dischargedEMER CEILING LIGHTS ROW 17-19 INOP. REPLACED BATTERIES FOR B5-102 EMER LIGHTS REF AMM 33-53. OPS CHECK GOOD.SDR DALA2016121209784Latch · corrodedCORROSION AROUND OF INTERNAL SIDE ON LATCHES AND CLIP AT AFT SERVICE PANEL DOOR AMDS 5300-2960. SERVICE PANEL DOOR WAS REPLACED PER SRM 51-30-5.SDR DALA2016121209783Pan · crackedDOOR, CRACK ON FWD PAN BTW NR 3 AND 4 BEAMS AT R1 DOOR. PAN BTW BEAMS NR 3 AND 4 WAS REPAIRED PER SRM 52-03 D FIG 3.SDR DALA2016121209782Support Fitting · corrodedHIDDEN DAMAGE. AFTER NUT REMOVAL ON RT MLG SUPPORT FITTING INBD LOWER STUD CORROSION WAS FOUND. LOWER STUD ON RT MLG SUPPORT FITTING WAS REMOVED AND INSTALLED PER AMM 20-30-01 AND 20-10-14, AFTER STUD REMOVAL CORROSION WAS FOUND ON FITTING BORE AND WAS ATTENDESDR DALA2016121209787Skin · not reportedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND (SEVEN DIFFERENT FASTENERS OF PSE) ON LOWER SKIN REAR SPAR BTW XRS=163 TO 168 AT LT WING. ATTENDED WITH ER/A NR 552817-14AD REV ORIGINAL.SDR DALA2016121209786Skin · not reportedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND (SEVEN DIFFERENT FASTENERS OF PSE) ON LOWER SKIN REAR SPAR BTW XRS=163 TO 168 AT RT WING. ATTENDED WITH ER/A NR 552817-14AD REV ORIGINAL.SDR DALA2016121109781Frame · crackedAFT ACCESSORIES COMPARTMENT, CRACK ON WEB OF FRAME STA Y= 1380 LONG 21 LT. WEB OF FRAME STA Y= 1380 LONG 21 WAS REPAIRED PER SRM 51-70-4 FIG 2 (SHEET 2).SDR DALA2016121009779Wire · brokenEMERGENCY LIGHTS AT SEAT 23DEF INOP. FOUND BROKEN WIRE AT SEAT TRACK. RE-SPLICED SAME PER WDM 33-51-14, AND AMM 20-50. CHECKS GOOD.SDR DALA2016121209790Light · inoperativeEMER CEILING LIGHTS FROM ROW 23 THRU 25 INOP. REPLACED EMER LIGHTS BATTERIES NO HELP. R&R BO B5104.SDR DALA2016121209789Battery Pack · dischargedBOTH LEFT AND RIGHT FWD OVERWING UPPER EMER EXIT LIGHTS INOP. REPLACED EMER LIGHT BATTERIES, NO HELP. R&R BP B5103. CKS OK.SDR DALA2016121009780Longeron · crackedPAX CABIN CRACKED LONGERON 3 LT ON STA Y=180. FASTENER WAS REMOVED AND INSTALLED PER SRM 51-30-5 AND HFEC INSPECTION WAS ACCOMPLISHED PER NDT SPM 06-10-01.001 AND NO CRACKS WERE FOUND.SDR DALA2016121009778Beam · corrodedAFT CARGO COMPARTMENT, CORROSION ON DOOR JAMB BEAM BTW STA Y=1155 TO 1212 LONG 27R TO 28R. DOOR JAMB BEAM BTW STA Y=1155 TO 1212 LONG 27R TO 28R WAS REPAIRED PER SRM 51-30-5 AND SRM 53-05 FIG 123.SDR DALA2016121009777Floor Support · corrodedCORROSION ON FLOOR SUPPORT OF STA Y 427 BTW LONG 28L TO 28R. FLOOR SUPPORT OF STA Y 427 BTW LONG 28L TO 28R WAS REPLACED PER SRM 51-10-4 AND 51-10-1 FIG 33 (SHEET 9).SDR DALA2016121009776Cusp Web · corrodedCORROSION ON UPPER AND LOWER CUSP WEBS FROM STA Y=1150 TO Y=1174 BTW X= 60 TO X=44. CUSP WEB WAS REPAIRED PER SRM 53-05 FIG 131A-21.SDR DALA2016121009775Angle · crackedDOORS, CRACK ON ANGLES AT STA Y=389 AND BEAM 1, 2 AND 5 FWD CARGO COMPARTMENT INNER STRUCTURE. NO CRACKS WERE FOUND ON ANGLES STA Y=389 BEAM 1 AND 2. CRACK ANGLE ON STA 389 BEAM 5 WAS REPLACED PER DWG 9957664 REV N AND SRM 51-30-5.SDR DALA2016120909773Battery Pack · dischargedCABIN CEILING EMERGENCY STANDBY LIGHT INOP FROM ROW 22 TO 26. REPLACED BATTERY PACK IN THE OVERHEAD BIN 24 RT. LIGHT CHECKS NORMAL.SDR DALA2016120909711Door Frame · corrodedAFT CARGO COMPARTMENT, CORROSION ON DOOR JAMB WEB BTW STA Y=1150 TO Y=1270 BTW LONG 30 TO 24R. FITTINGS STA-Y: 1255, Y: 1212, STRAPS STA Y: 1220, Y: 1245 AND WEB WERE REMOVED AND INSTALL NEW WEB PER SRM 51-30-2, 51-30-5 AND DWG 5936442 REV A.SDR DALA2018112326746Spar Cap · damagedHORIZONTAL STAB RHS UPPER, AFT SPAR CAP FASTENER HOLE OVERSIZE ER/A 549705-14AD. LEVEL OF ER/A 549705-14AD IS REV. B. LOGPAGE IS OKAY TO TERMINATE. RESULTS OF DTA/DTE HAVE BEEN INCORPORATED. INSPECTION REQUIREMENTS ARE NOW BEING TRACKED VIA 0834658 AND 0834662SDR DALA2016120909772Support · crackedDOOR, CRACKED SUPPORT ON LT INBD MLG DOOR STA Y=962-970 AND X=30. LANDING GEAR DOOR WAS REPLACED.SDR DALA2016120909710Access Door · corrodedCORROSION ON COUNTERSINKS AND SETTLING SURFACE OF FUEL ACCESS PLATES 1335C AND 1311C. FUEL ACCESS DOORS WAS REPLACED PER SRM 51-22-2A PAR 6.SDR DALA2016120909709Frame · crackedCRACK WAS FOUND ON UPPER RADIUS OF THE FRAME TAB AT RT OVERWING FRAME STA Y=864 STA: 00441. FRAME WAS REPLACED PER SRM 51-10-4, SRM 51-30-5, SRM 51-30-2 AND CARD REPLACE SECTION OVERWING FRAME 5310-01415-0302.SDR WX0A201612273208Bleed Valve · malfunctionedRIGHT ENGINE COMPRESSOR STALLED, EPR & N1 SURGING IN FLIGHT. INSTALLED 10 C1 FAN BLADES IN OVERHAULED CONDITION. PERFORMED VIBRATION SURVEY AND LEAK CHECK. ENGINE FOUND SERVICEABLE. R & R 2 PRESSURE RATIO BLEED CONTROL VALVES.SDR DALA2016120909774Battery · dischargedSEVERAL CELLING STANDBY LIGHTS INOP. FOUND BATTERY PACKS B5-100 AND B5-102 BAD. SWAPPED IN KNOWN GOOD BATTERIES. OPS NORMAL. REMOVED AND REPLACED BATTERIES IN PACK B5-100. STILL NEEDS BATTERIES FOR POWER PACK B5-105. REPLACED BATTERIES IN POWER PACK B5-102. OSDR DALA2016120809686Skin · corrodedCORROSION ON THE RT HORIZONTAL STABILIZER SKIN BARREL NUT HOLE 14 AND 16. REPAIRED IAW ETI-88-16-438 REV. 1 AND ER/A 551763-14 REV ORIG.SDR DALA2016120809685Intercostal · corrodedCORROSION ON INTERCOSTAL BS 1309 - 1322 AND LONGERONS 27 - 28R. THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-2, 51-30-5 AND DWG 9936718 REV. N.SDR DALA2016120809684Longeron · crackedCRACKED LONGERON 3L, BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG 18.SDR DALA2016120809683Skin · damagedVERTICAL STABILIZER LEADING EDGE HAD LOOSE FASTENERS ABOVE THE SPLICE. FOUND TO BE OUT OF LIMITS. REPAIRED IAW SRM 55-03 PAR 27 FIG 29 (SHEET 1 AND 2).SDR DALA2016120809682Frame · crackedWEAR AND A CRACK ON TITANIUM FRAME BS 1346, LONGERONS 28L TO 28R. REPAIRED IAW ER/A 094719-14MA REV. A.SDR DALA2016120809679Longeron · crackedAFT ACCESORY BAY HAS A CRACKED LONGERON 5R BS 1437. THE LONGERON WAS REPAIRD IAW SRM 53-02 FIG 18.SDR DALA2016120809678Vane · damagedLEFT WING HAD SEVERAL NICKS AND DENTS ON THE INBD FLAP INBD GUIDE VANE PREVIOUS REPAIR DOUBLER. REPAIRED IAW SRM 57-03 D PAR.11.SDR DALA2016120709677Jackscrew · wornHORIZONTAL STAB JACKSCREW THREADS HAVE STEP WEAR. REPAIRED IAW PRI 553056-14AD REV 0 AND COMPLIED WITH ERA 553056-14AD REV ORIG.SDR DALA2016120709676Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE AT FORWARD GALLEY AND OVERHEAD AT ENTRY DOOR. INSTALLED A NEW BULB IN THE FWD GALLEY RED LIGHT AND CHARGED THE BATTERIES.SDR DALA2016120709675Frame · crackedCRACKED FRAME BS 1322 LONGERON 17R. THE FRAME WAS REPAIRED IAW ER/A 493697-14MA REV. B.SDR DALA2016120709674Frame · crackedCRACKED FRAME ON BS 1322 LONGERON 17L. THE FRAME WAS REPAIRED IAW ER/A 493697-14MA REV. B.SDR DALA2016120709673Skin · delaminatedRIGHT WING HAD A DELAMINATED OTBD TE PANEL XA=429-434. REPAIRED IAW ERA 551768-14 REV ORIGINAL.
Back to Mcdonnell Douglas MD-88