Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; 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' 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' 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 DALA2025112608633Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y1552.5 BETWEEN FR 33 AND FR 34. REPLACED SEAT TRACK PER A330 SRM 51-72-11. (1322597)SDR DALA2025112608632Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-C1 BETWEEN FR 73 AND FR 74. SEAT TRACK REPLACED PER A330 SRM 51-72-11. (1322567)SDR DALA2025112608645Rod End · excess playLEFT AILERON WITH PLAY AT PCA ROD ENDS. CORRECTIVE ACTION: R/R LT INBD AND LT OTBD SERVO CONTROL ACTUATORS PER WC 2714-4001. (7652718).SDR FDEA202511262208Aileron Sys · abnormalDURING THE BEFORE TAKEOFF CHECKLIST ON THE FLIGHT CONTROL CHECK, THE AILERONS TOOK ABNORMALLY EXCESSIVE FORCE TO ACTIVATE THE SYSTEM ON BOTH CA & FO YOKE. PERFORMED TROUBLESHOOTING OF AILERONS. PERFORMED GVI OF ALL ACCESSIBLE PULLYS AND CABLES. MEASURED FOSDR FDEA202511262207Floor Panel · damagedMAIN CARGO DECK R/H SIDE FLOORBOARD # 242VFF STA 984.95 HAS (2) PUNCTURES, (1) DAMAGED CORE EDGE. MARKED IN RED. FABRICATED NEW FLOOR PANEL 242VFF, MPN: 145T5876-114, RBL 74.25- RBL 86.25, STA 984.95-1087 IN REF. TO BOEING DWG 145T5876-114. SEE JPF FOR ASDR AALA202511263384Battery · no testAIRCRAFT WAS NOT GROUNDED: DURING LEFT AFT SLIDE CHANGE, EPSU SYS TEST FAILED. FAULT: BAT/EPSU(13WL) AFT L. MAINTENANCE REPLACED BATTERY OF EPSU IAW AMM 33-51-38.SDR JR2R20251126745Seat Track · corrodedEXISTING SEAT TRACK REPAIR DOUBLER AT FR84 RBL11 IS CORRODED. REPLACEDSDR 2025F00273Support · corrodedDURING A PREFLIGHT WALKAROUND, SURFACE CORROSION WAS OBSERVED ON THE VERTICAL STABILIZER AFT SECTION. AFTER CLOSER INSPECTION SEVERE DELAMINATION WAS SEEN ON THE AFT VERTICAL SUPPORT ANGLES AND AFT STAB BULKHEAD SECTION. THE RUDDER TRIM TAB BRACKET ALSO HAD SISDR SWIA2025112576582Stiffener · damagedAFT PRESSURE BULKHEAD VERTICAL STIFFENER AT BL 0, DAMAGED AT THE BOTTOM, FROM THE FLOATATION VALVE HINGE PIN BORING A HOLE. REPAIRED AFT PRESSURE BULKHEAD VERTICAL STIFFENER AT BL 0, BOTTOM, FROM THE FLOATATION VALVE HINGE PIN IAW REO 690-53-61-1711 REV -. COSDR SWIA2025112576574Intercostal · corrodedPAX DOOR FWD DD4 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR FWD DD4 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2025112576555Stand Off · crackedLEFT UPPER TRANSCOWL OTBD A, BRACKET IS CRACKED. REMOVED CRACKED OTBD A BRACKET STANDOFF FROM LT UPPER TRANSCOWL AND INSTALLED 1 EA NEW OTBD A BRACKET STANDOFF ON LT UPPER TRANSCOWL, REF.GREO 670-54-21-971 REV (-B), STEPS 1-3. COMPLIED WITH SKY CARD #51-900-SDR SWIA2026070676550Stiffener · damagedAFT PRESSURE BULKHEAD VERTICAL STIFFENER AT LBL 9, DAMAGED AT THE BOTTOM, FROM THE FLOATATION VALVE HINGE PIN BORING A HOLE (MARKED) (C-CHECK RO 07/02/2026)REPAIRED AFT PRESSURE BULKHEAD VERTICAL STIFFENER AT LBL 9, DAMAGED AT THE BOTTOM, FROM THE FLOATATIONSDR SWIA2025112576538Intercostal · corrodedPAX DOOR FWD DD7 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR FWD DD7 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. COMPLIED WITH SKYTRACK TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD AT THIS TIME.SDR SWIA2026070676519Drag Angle · crackedLH VERTICAL STAB - TO - FUSELAGE AFT DRAG ANGLE POSSIBLE CRACK. REMOVED, CRACKED LEFT, AFT DRAG ANGLE ON THE VERTICAL STAB., AND INSTALLED SERVICABLE DRAG ANGLE. IAW SRM 51-42-21-001-001-A01, REV. 38, SRM 51-42-13-001-001-A01 REV. 38, SRM 51-42-22-001-001SDR SWIA2025112576503Rivet · looseRIGHT UPPER TRANSCOWL Z STIFFENER RIVETS ARE PULLED LOOSE. REPAIRED FASTENER HOLES COMMON TO ZED STIFFENER ON INNER SKIN OF RT UPPER TRANSCOWL, IAW REO 690-54-21-620, REV. A, 2026-01-20.COMPLIED WITH TASK CARD 51-900-1002-SKYSDR SWIA2026070676501Intercostal · corrodedPAX DOOR FWD DD6 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR FWD DD6 INTERCOSTAL SRM 51-42-06-001-001-A01 AND DWG 601R31702, REV N. COMPLIED WITH SKY TRACK TASK CARD 51-900-1002-SKY. LEAK CHECKED GOOD.SDR SWIA2025112576494Drag Angle · crackedRIGHT VERTICAL STAB - TO - FUSELAGE FWD DRAG ANGLE POSSIBLE CRACK. REMOVED DAMAGE FROM THE RIGHT FORWARD VERTICAL STAB. DRAG ANGLE, FABRICATED AND INSTALLED REPAIR PARTS. REF. SRM 55-31-00-201-001-A01. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025112576491Hinge · wornFLOATATION VALVE IN THE AEB, HINGE IS WORN AND HINGE PIN HAS MIGRATED. REPLACED AND INSTALLED NEW HINGE, WATER ACTIVATED CHECK VALVE IAW DWG.BA690-95100, REV-B, AND SRM.51-42-06-001-001-A01 REV. 38 . LEAK CHECK GOOD. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025112576489Bracket · crackedRIGHT LWR TRANSCOWL INBD A BRACKET IS CRACKED. RT LWR TRANSCOWL I/B A BRACKET HAS BEEN REPLACED WITH A NEW BRACKET IAW REO# 670-54-21-971, REV B. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025112576483Stand Off · crackedLEFT UPPER TRANSCOWL INBD A BRACKET IS CRACKED. REMOVED CRACKED INBD A BRACKET STANDOFF FROM LT UPPER TRANSCOWL AND INSTALLED 1 EA NEW INBD A BRACKET STANDOFF ON L/H UPPER TRANSCOWL, REF. MHIRJ GREO #670-54-21-971 REV (-B) DATED 2023-11-28 STEPS 1-3. COMPLIED SDR SWIA2025112576471Rivet · shearedRIGHT LWR TRANSCOWL Z STIFFENER RIVETS ARE SHEARED. RT LWR TRANSCOWL ZEE STIFFENER HAS BEEN REPAIRED REF REO 690-54-21-612, REV --. COMPLIED FULLY W/SKYCARD 51-900-1002-SKY.SDR SWIA2025112576467Retainer · crackedPAX DOOR TOP CORNER AFT SEAL RETAINER CRACK. PERFORMED LOCATE AND DRILL NEW PAX DOOR TOP CORNER AFT SEAL RETAINER. IAW SRM 51-42-06-001-001-A01AND DWG 601R31871 REV. D. INSTALLED PAX DOOR TOP CORNER AFT SEAL RETAINER IAW SRM 51-42-06-001-001-A01. AND DWG 60SDR REXA2026052600655Rib · crackedCRACK ON WING RIB LEADING EDGE SS27.16 AT RIGHT WING. CRACK ON WING RIB LEADING EDGE SS27.16 AT RIGHT WING. WAS REPAIRED PER CRJ957-20951 REV IRSDR SWIA2025112575841Trunnion · crackedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA26772-601R-57-21-2287 959SW-PR - COMPLY WITH PERMANENT REPAIR ON RA ID: 267723 EA. FASTENER HOLES WERE FOUND CRACKED ON R/H MLG TRUNNION. REPAIRED REF REO 601R-57-21-2287. TRUNNION FITTING LIFE LIMIT/DISCARD TIME DUE SDR SWIA2025112575756Web · crackedLEFT FORWARD EQUIPMENT COMPARTMENT FLOOR WEBBING IS CRACKED AT THE BRAKE ACCUMULATOR GAGE FITTING AREA. REPAIRED LT FORWARD EQUIPMENT COMPARTMENT FLOOR WEBBING AT THE BRAKE ACCUMULATOR GAGE FITTING AREA PER REO 601R-53-11-4045 REV.--. COMPLIED WITH SKYWEST SDR DALA2026031101716Skin · corrodedSHIP 3315 CORROSION ON EXTERNAL FUSELAGE SKIN AT FR76-77, STR41L. CORRECTIVE ACTION: CORRECTED PER A330 SRM 53-41-11-205-037. (1320804)SDR SWIA2026031075495Web · crackedFWD EQUIPMENT BAY FLOOR WEB CRACKED ON R/H SIDE. REMOVED AND REPLACED PREVIOUS REPAIR AT FWD EQUIPMENT BAY FLOOR WEB IAW CRJ700 AMM 20-70-00, SRM 51-42-06, 51-25-16, BOMBARDIER REO 670-53-11-509, REV-E,SDR SWIA2025112575494Web · crackedFWD EQUIPMENT BAY FLOOR WEB CRACKED ON L/H SIDE. PERFORMED REPAIR ON FWD EQUIPMENT BAY FLOOR WEB LH SIDE IAW AMM 52-45-56 20-70-00, SRM 51-42-06, 51-21-11, 51-25-06, 51-25-16, BOMBARDIER REO 670-53-11-509 REV-E DATED: 2018-02-08.SDR SWIA2025112575424Frame · crackedAFT COMPARTMENT, FRAME FS 640.00 HAS A CRACK STRG 8,9 L/H (C-CHECK RO 03/04/2026)REMOVED AND REPLACED FOR NEW FRAME P/N: 601R350094-1 ON FS 640.00 AFT COMPARTMENT IAW CRJ200 SRM 51-42-06,51-42-20,51-40-11,51-42-06,51-23-00,SDR SWIA2025112575418Angle · crackedAFT CARGO DOOR, FWD RAIL, UPPER ANGLE HAS A CRACK (C-CHECK RO 03/04/2026)REPAIRED FWD RAIL UPPER ANGLE FROM AFT CARGO DOOR IAW REO: 601R-53-61-8453SDR KISA202602050001Angle · corrodedDURING A PREFLIGHT WALK AROUND CORROSION WAS OBSERVED ON THE AFT SPAR ANGLE CHANNEL OF THE VERTICAL STABILIZER. UPON FURTHER INVESTIGATION SIGNIFICANT INTERGRANULAR CORROSION WAS FOUND RESULTING IN EXFOLIATION OF THE SURFACE OT THE SPAR ANGLE. THIS RESULTED INSDR SWAA2025123039871Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727B, S5L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1102, SHEET 15, REV-.SDR SWAA2025123039868Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727C, S6L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1103, SHEET 11, REV-.SDR SWAA2025123039873Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727C, S7L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1103, SHEET 11, REV-.SDR SWAA2025123039869Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727D, S6L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1111, SHEET 11, REV-.SDR SWAA2025123039877Stringer Clip · crackedCRACKED STRINGER CLIP BS 727D, S3L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1111, SHEET 11, REV-.SDR SWAA2025123039875Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727E, S5L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1112, SHEET 09, REV-.SDR SWAA2025123039878Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727B, S6R. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1102, SHEET 15, REV-.SDR SWAA2025123039876Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727E, S6L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1112, SHEET 09, REV -.SDR SWAA2025123039879Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727A, S3R. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1101, SHEET 15, REV -.SDR SWAA2025123039870Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727A, S6R. REMOVED AND REPLACED STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1101, SHEET 15, REV -.SDR SWAA2025123039880Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727A S4R. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0 AND DWG 146A1101, SHEET 15, REV -.SDR SWAA2025123039874Stringer Clip · crackedCRACKED STRINGER CLIP AT PAX CABIN BS 727D, S7L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1111, SHEET 11, REV -.SDR SWAA2025123039872Stringer Clip · crackedCRACKED STRINGER CLIP AT PAX CABIN BS 727C, S5L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0 AND DWG 146A1103, SHEET 11, REV -.SDR SWAA2025123039496Panel · crackedPANEL 344GB UPPER SURFACE CRACKED. REMOVED AND REINSTALLED PANEL 344GB IAW AMM 20-50-11.SDR SWAA2025123039863Plate · crackedLEFT WING T/E WIGGLE PLATE COMMON TO PANEL 551EB ON THE INBD SIDE IS CRACKED. REMOVED AND INSTALLED NEW WIGGLE PLATE COMMON TO PANEL 551EB ON THE INBD SIDE IAW SRM 51-40-02, AND DWG 115A2001 REV A..SDR SWAA2025122939647Tie Clip · crackedCRACKED TIE CLIP, BS 277, STRINGER 10R. REPLACED THE TIE CLIP AND FASTENERS IAW SRM 51-40-02, AND DRAWING 141A1110, SHEET 55, REV -.SDR AALA202512200913Bulkhead · canningAIRCRAFT IN BASE MAINTENANCE: OIL CAN CONDITION TO AFT PRESSURE BULKHEAD AT BS 1016, AT LBL 9, BELOW S2L. ACCOMPLISHED BULKHEAD REPAIR PER SRM 53-80-08-2R-7 AND EA 369134.SDR SWAA2025121839903Skin · crackedCRACK ON LOWER SURFACE OF LEADING EDGE LOCATED SLAT 1 AT ACTUATOR AROUND FASTENERS LT WING. REMOVED AND REPLACED LEADING EDGE SLAT 1 ASSY IAW AMM 27-81-21-401. TESTED OK.SDR SWAA2025121739670Support Beam · crackedCRACK ON SUPPORT BEAM LOCATED TRAILING EDGE ORSS 280 ON THE RT WING. REPLACED THE SUPPORT BEAM IAW SRM 51-40-02-0G-0, AND DWG 115A3712, SHEET 6, REV B.