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 DALA2025072005443Power Supply · inoperativeAIRCRAFT 5812, MULTIPLE EMERGENCY LIGHTS INOP. REPLACED POWER SUPPLY M11612 BATTERY PACK. (LP 7322864)SDR JR2R20250720786Floorbeam · corrodedFLOORBEAM, FRAME 17 BETWEEN LBL 12 AND RBL 42 HAS MULTIPLE CORRODED AREAS. OUT OF LIMITS. REPAIREDSDR JR2R20250720816Floor Support · corrodedRH FLOOR SILL (DOUBLER) BETWEEN FRAMES 17 TO 20, AT RBL 48, IS CORRODED OUT OF LIMTS. REPLACEDSDR JR2R20250720770Lug · chafedLEFT HAND PYLON, AFT FAIRING, MOUNTING LUGS AT FRAME 5 ARE CHAFED. REPAIREDSDR JR2R20250720766Lug · chafedRIGHT HAND PYLON, AFT FAIRING, MOUNTING LUGS AT FRAME 5 ARE CHAFED. REPAIREDSDR JR2R20250720722Hinge · gougedRIGHT HAND ELEVATOR, #2 HINGE HAS GOUGES NEAR BOLT HOLE. REPAIRED.SDR JR2R20250720721Hinge · gougedRIGHT HAND ELEVATOR, #2 HINGE HAS A DEEP GOUGE NEAR TOGGLE LINK BOLT HOLE. REPAIRED.SDR REXA2026072901304Fitting · corrodedCORROSION ON FLOOR FITTING FRONT LEFT CORNER AT FWD LAV FLOOR FITTING FRONT LEFT CORNER AT FWD LAV. WAS REPLACED PER SAFRAN CMM 25-40-76SDR REXA2026072901303Fitting · corrodedCORROSION ON FLOOR FITTING OF ACCESS 306 (2EAS) AT GALLEY 3 FLOOR FITTING OF ACCESS 306 (2EAS) AT GALLEY 3. WERE REPLACED PER ZODIAC AEROSPACE CMM 25-33-18SDR REXA2026072901302Fitting · corrodedCORROSION ON FLOOR FITTING FRONT LEFT CORNER ACCESS 205 AT GALLEY 2, FLOOR FITTING FRONT LEFT CORNER ACCESS 205 AT GALLEY 2 WAS REPLACED IAW CMM 25-32-84.SDR SWIA2025071975145Beam · groovedLEFT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR BEAM HAS A LATERAL GROOVE, FLS140.40. (MARKED & FLAGGED) (C-CHECK RO 02/01/2026)REMOVED DAMAGE FROM THE LEFT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR BEAM AT FLS140.40 IAW CRJ900 SRM 51-12-00-001-001-A01.SDR SWIA2025071975144Beam · groovedLEFT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR BEAM HAS A LATERAL GROOVE,FLS65.50. (MARKED & FLAGGED) (C-CHECK RO 02/01/2026)REMOVED DAMAGE FROM THE LEFT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR BEAM AT FLS65.50 IAW CRJ900 SRM 51-12-00-001-001-A01. COMSDR SWIA2025071975143Beam · groovedLEFT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR BEAM HAS A LATERAL GROOVE, FLS102.90. (MARKED & FLAGGED) (C-CHECK RO 02/01/2026)COMPLIED WITH REO 670-57-52-257 REV -B DATED 2024-10-17 REPARE OF LH WING IB FLAP IB FLAP VAIN ACTUATOR BEAM GROVE AT FLS 102.90SDR SWIA2025071975127Beam · groovedLEFT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR BEAM HAS A LATERAL GROOVE, FLS24.00. (MARKED & FLAGGED) (C-CHECK RO 02/01/2026)REMOVED DAMAGE FROM THE LEFT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR BEAM AT FLS24.00 AS PER CRJ900 SRM 51-12-00-001-001-A01.SDR SWI2025F01790Floorbeam · corrodedRBL 9 FLOORBEAM IS CORRODED AT BS 661, ON THE UPPER INBD FLANGE. COMPLIED WITH REO 670-53-31-1067, REV -.SDR SWI2025F01789Floor Support · corrodedRBL 9 FLOOR SUPPORT IS CORRODED BETWEEN BS 469 & 485 ON THE UPPER INBD FLANGE. COMPLIED WITH REO 670-53-31-1066 REV-.SDR SWIA20250719Floor Support · corrodedLBL 9 FLOOR SUPPORT IS CORRODED ON THE UPPER INBD FLANGE BETWEEN BS 645 & 693. REPAIRED THE FLOOR SUPPORT ON THE UPPER FLANGE IAW REO 670-53-31-1068 REV-. COMPLETED TASK CARD 51-900-1003-SKY.SDR SWI2025F01482Roller · failed inspL/H SLAT TRACK 1-2 SIDE ROLLERS AT FWD I/B AND FWD O/B FAILED INSPECTION. (S/N 00770) (C-CHECK RO 11/01/2025)REPLACED SIDE ROLLERS WITH NEW AT L/H SLAT TRACK 1-2 SIDE ROLLERS AT FWD I/B AND FWD O/B REF CRJ900 AMM 27-81-44-400-801-A01,REF CRJ900 AMM 27-81-SDR SWI2025F01481Roller · failed inspL/H SLAT TRACK 3-2 SIDE ROLLERS AT FWD I/B, FWD O/B AND AFT O/B FAILED INSPECTION. (S/N 00769) (C-CHECK RO 11/01/2025)REMOVED AND INSTALLED L/H SLAT TRACK 3-2 SIDE ROLLERS AT FWD I/B, FWD O/B AND AFT O/B.(3EA NEW ROLLERS) REF CRJ-900 AMM 27-81-44-400-803-A0SDR SWI2025F01480Roller · failed inspL/H SLAT TRACK 2-2 SIDE ROLLERS AT FWD I/B, FWD O/B AND AFT O/B FAILED INSPECTION. (S/N 00768) (C-CHECK RO 11/01/2025)REPLACED SIDE ROLLERS PN: CC670-12027-3 1(EA) AND PN: CC670-12048-3 2(EA) WITH NEW REF CRJ900 AMM 27-81-44-400-802-A01,REF CRJ900 AMM 27-81SDR SWIA2025110300719Roller · failed inspL/H SLAT TRACK SIDE ROLLERS AT FWD I/B AND FWD O/B FAILED INSPECTION. (S/N 00767) (C-CHECK RO 11/01/2025)DEFECT DESCRIPTION MISSING SLAT TRACK LOCATION OF FAULTY ROLLERS. PLEASE SEE CAMP 30516910 (HN00253759)SDR VNAA20251015001Web · crackedCRACK ON ELECTRICAL BAY FLOOR WEB RIGHT SIDE (BELOW ADG SUPPORT DOUBLER) FS193.00. ELECTRICAL BAY FLOOR WEB RIGHT SIDE (BELOW ADG SUPPORT DOUBLER) FS193.00 WAS REPAIRED PER CRJ-900 SRM 53-11-43-201-001-A01.SDR SWIA2025F01418Skin · damagedFOUND THROUGH HOLES ELONGATED AT RH ELEVATOR WING TIP STRUCTURE 30515409 (C-CHECK RO 10/06/2025)COMPLIED WITH REPAIR TO RH H-STAB TIP FAIRING ATTACHMENT HOLES REF REO 601R-55-11-800 REV -- DATED: 2025-09-04. COMPLIED WITH SKYWEST TASK CARD: 51-900-1003-SKY.SDR SWIA2025100700719Floor Support · corrodedLH PRESSURE FLOOR SILL ANGLE HAS AN EXISTING REPAIR BETWEEN FS 449.85 AND FS 461.50 AT LBL 42 WHERE TWO AREAS OF CORROSION WERE BLENDED OUT REQUIRING REPLACEMENT OF REPAIR DOUBLER. (CAMP# 30512586) (C-CHECK RO 10/06/2025)REMOVED AND REPLACED -1 DOUBLER OF EXSDR AALA202510069966Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23 R BTW FR69 AND FR70 AT AFT GALLEY AREA MEASURE IS L= 0.895. MAINTENANCE REPLACED SHEAR PLATE LOCATED BTW FR69 TO FR70 AT LEVEL STGR 23 RH SIDE AT AFT GALLEY AREA I.A.W A319 SRM 51-42-11-801, A319 SRM 51-7SDR AALA202509296658Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23 L LOC. BTW FR69 AND FR70 AT AFT GALLEY AREA MEASURES OF CRACK, L= 1.030 INCH. MAINTENANCE REPLACED SHEAR PLATE STR 23 L LOC. BTW FR69 AND FR70 AT AFT GALLEY AREA I.A.W A319 SRM 51-42-11-801 AND A319 SRM 51SDR AALA202509198874Dummy Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION RAIL DUMMY Y503.2 LOC. AT LEVEL FR16 AT FWD GALLEY AREA, MEASURE CORROSION ARE L=1.103 INCH W=0.973 INCH D=0.013 INCH. MAINTENANCE REPLACED RAIL DUMMY Y503.2 LOC. AT LEVEL FR16 AT FWD GALLEY AREA. IAW A319 SRM 51-42-11-8SDR K11A2025091800343Stringer · corrodedEVIDENCE OF CORROSION ON STRINGER 22R AT STA 880.SDR AALA202509020592Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM +Y1292 LOC AT LEVEL FR16 AT FWD GALLEY AREA L= 1.574 IN W= 1.240 IN D= 0.077 IN. MAINTENANCE REPLACED FLOOR BEAM Y1292 LOC AT LEVEL FR12 TO FR24 FWD GALLEY AREA IAW A319 SRM 51-42-11-801, A319 SRM 51-72-11-911SDR AALA202509022612Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SEAT TRACK +Y765 LOC. AT LEVEL FR16 AT FWD GALLEY AREA L= 1.112 IN W= 1.002 IN D=0.009 IN. MAINTENANCE REPLACED FLOOR BEAM Y1292 LOC AT LEVEL FR12 TO FR24 FWD GALLEY AREA IAW A319 SRM 51-42-11-801, A319 SRM 51-72-11-911SDR SWAA2025082793173Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED AT LEVEL ORSS 279 AT RT WING. REPLACED ANGLE TRAILING EDGE LOCATED AT LEVEL ORSS 279 AT RT WING IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG: 115A6200; SHEET: 9; REV: A. MEASURE OF CRACK IS L: 1.631.SDR SWAA2025082793169Floorbeam · crackedCRACK BREAK PANEL ASSY FLOOR STRUCTURE LOCATED STA 540 AND BTW RBL 24.75 TO RBL 45.5. REPLACED BREAK PANEL ASSY FLOOR STRUCTURE IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG: 143A0060, SHEET 64, REV -.SDR SWAA2025082793171Rib · crackedCRACK ON DEFLECTION CONTROL RIB TRAILING EDGE AT LT WING . PERFORMED PERMANENT REPAIR LOCATED FIXED TRAILING EDGE DEFLECTION CONTROL RIB AT LT WING IAW SRM 57-51-02-2R-3 REPAIR 3 AND SRM 51-40-02.SDR SWAA2025082793174Rib · crackedCRACK ON DEFLECTION CONTROL RIB TRAILING EDGE AT RT WING. REJECT STEP 2 ITEM 5, PROPERLY INSTALLED BOLTS IAW SRM 57-51-02-2R-3, REPAIR 3, STEP 4(T), AND SRM 51-40-02. PERFORMED PERMANENT REPAIR LOCATED FIXED TRAILING EDGE DEFLECTION CONTROL RIB AT RT WINSDR SWAA2025082793168Floorbeam · crackedCRACK BREAK PANEL ASSY ON FLOOR STRUCTURE LOCATED STA 540 AND BTW BL 0 TO LBL 24.75 AT PASSENGER CABIN. REPLACED BREAK PANEL AND FASTENERS LOC. ON STA 540 AND BTW BL 0 TO LBL 24.75 AT PASSENGER CABIN IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 143A0060 SHEESDR SWAA2025082293059Tie Clip · crackedCRACK TIE CLIP LOCATED BS259.5 AND S-8L PASSENGER CABIN 2025-448204<[01] REPLACED TIE CLIP LOCATED BS 259.5 AND STRINGER 8L AT PASSENGER CABIN. IAW B737-700 SRM 51-40-02 AND DWG# 141A0720; SHEET 46 AND REV -. SEE INDIVIDUAL SIGNOFF BELOW.;[02] RII<BR>REPLACED SDR SWAA2025082193060Stringer · crackedCRACKED STRINGER 16L, BS 294.5. PERFORMED PERMANENT REPAIR ON STRINGER 16L BETWEEN BS 277 - 303.9 IAW SRM 53-00-03-2R-1, REPAIR 1.SDR AALA202508200255Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SEAT TRACK +Y1162.5 SECTION CONNECTION I/B SIDE UPPER POSITION AT LEVEL FR68 AT AFT GALLEY AREA, MEASURES ARE: L=1.118 IN; W=0.872 IN; D=0.020 IN. MAINTENANCE REPLACED SECTION CONNECTION LOCATED SEAT TRACK BEAM +Y1162.5 SDR SWAA2025081893064Fan Cowl · crackedNUMBER 1 ENGINE IB FAN COWL OIL DOOR SHIELD CRACKED. REMOVED AND INSTALLED A NEW FAN COWL ON CARD #TTG8Q00S5G98 STEP 4.SDR SIMA20250719002Seal Rest · corrodedFWD CARGO DOOR FUSELAGE CUT-OUT LWR AFT CORNER SEAL REST IS CORRODED. (MAJOR REPAIR) (LEVEL 2 CORROSION). REMOVED AND REPLACED FWD CARGO DOOR FUSELAGE CUT-OUT LWR AFT CORNER SEAL REST IAW ERJ 170 AMM 20-10-01 AND SRM 51-40-08.SDR SIMA20250719001Seal Rest · corrodedFWD CARGO DOOR FUSELAGE CUT-OUT LWR CENTER SEAL REST IS CORRODED. (MAJOR REPAIR) (LEVEL 2 CORROSION). REMOVED AND REPLACED FWD CARGO DOOR FUSELAGE CUT-OUT LWR CENTER SEAL REST IAW ERJ 170 SRM 51-40-08.SDR REXA2025081800816Seat Track · corrodedCORROSION ON SEAT TRACK LOCATED BTW FS364.00 AND LBL27.00 AT CPAX. DUE TO EXCESSIVE CORROSION ON SEAT TRACK LOCATED BTW FS364.00 TO FS478.00 AND LBL27.00 AT CPAX AT CPAX WAS REPLACED PER CRJ900 SRM 53-21-49-101-001-A01 AND AMM 53-00-49 (CONFIG A11)SDR REXA2025081800815Seat Track · corrodedCORROSION ON SEAT TRACK LOCATED BTW FS379.00 AND LBL9.00 AT CPAX. DUE TO EXCESSIVE CORROSION ON SEAT TRACKS AT PASSENGER FLOOR STRUCTURE BTW FS379.00 TO 493:00 LBL9.00 AT CPAX. WAS REPLACED PER CRJ900 SRM 53-21-49-101-001-A01 AND AMM 53-00-49 (CONFIG A11)SDR REXA2025081800814Seat Track · corrodedCORROSION ON SEAT TRACK LOCATED BTW FS349.00 TO FS379.00 AND RBL9.00 AT CPAX DUE TO EXCESSIVE CORROSION SEAT TRACK LOCATED BTW FS349.00 TO FS463.00 AND RBL9.00 AT CPAX WAS REPLACED PER CRJ900 SRM 53-21-49-101-001-A01 AND AMM 53-00-49 (CONFIG A11)SDR ASAA2025071960094Floorbeam · corrodedFLT COMPARTMENT FLOOR PANEL 211AF STRUCTURE CUTOUT AFT EDGE HAS CORROSION. GROUNDED - YES. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, REPAIRED FLOOR STRUCTUER IAW ASA EA 800-53EA-29091W= 1.0 O= .050 R= .039 L= 1.75 D= .011.SDR SWAA2025081493143Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED IRSS 141 AT LT WING. REPLACED ANGLE TRAILING EDGE LOCATED IRSS 141 AT LT WING IAW SRM 51-40-02, AND SRM 51-10-02, PARAGRAPH 9, AND DWG 115A2000, SHEET 21, REV -. LENGTH OF CRACK IS L: 0.841 INCHES.SDR SWAA2025081493140Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED IRSS 217 AT LT WING. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED IRSS 217 AT LT WING IAW SRM 51-40-02; SRM 51-10-02 AND DWG 115A2001, SHEET 30, REV A.SDR SWAA2025081393153Light · brokenBROKEN GALLEY 1 EMERGENCY EXIT BASE AT FWD GALLEY AREA . REPLACED GALLEY 1 EMERGENCY EXIT BASE AT FWD GALLEY AREAI.A.W. BOEING 737-700 AMM 33-51-01-960-802. TEST IS OK.;SDR IPXA2025081314120Cam · damagedCREW DOOR LOWER LATCH CAM HAS A GOUGE ON OUTER SIDE. ACCOMPLISHED JOB IN SREO-14721-REQ001 ((APPX A) CREW ENTRY DOOR UPPER AND LOWER LATCH CAMS REWORK INSTRUCTIONS (SREO))SDR IPXA2025081112145Skin · dentedL/H LWR FUSELAGE SKIN PROTRUDING AT STA 1400. INSTALLED -1 DOUBLER REPAIR AND -2 REPLACEMENT SPLICE STRAP SEGMENT AT STA 1400 BTW S-27L AND 28L IAW EA 757-5360-01-B0545 REV. P2 PAR.D STEP 18. ACCOMPLISH REPAIR PER EO-94648-REQ1 AND VT-SAA EA 757-5360-01-B054