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.

SDR VNAA20251015049Attach Angle · corrodedDISCREPANCY: INTERCOSTAL ATTACH ANGLES AT F.S 517-533 STR 26L ARE CORRODED AND HAVE OVERSIZE HOLES CORRECTIVE ACTION: INSTALLED NEW PN: SH670-33399-951 AND PN: SH670-33600-983 BETWEEN FS 517 - FS 533, STR 27 - STR 26L (LBL 2.6) IAW CRJ-700 SRM 51-42-06-001-001Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, Attach FittingsSDR VNAA20251015048Fitting · corrodedFITTING P/N SH670-33389-1 @ F.S 533 STR 25L IS CORRODED. INSTALLED NEW FITTING P/N SH670-33389-1 IAW CRJ 700 SRM 51-42-21-001-001-A01 & CRJ 700 SRM 51-45-00-001-001-A01 SH670-33389-1Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, StructureSDR VNAA20251015047Frame · corrodedINTERCOSTAL FOR ACCESS TO FRAME CORROSION @ STR 25L F.S 517-F.S533 FOUND IT HAS INCOMING OVERSIZE RIVET HOLES. INSTALLED NEW INTERCOSTAL PN SH670-33568-5 IAW CRJ 700 SRM 51-42-06-001-001-A01 & CRJ 700 SRM 51-42-21-001-001-A01.Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, FrameSDR VNAA20251015046Angle · corrodedFS280 J ANGLE IS CORRODED. NEW SERVICEABLE ANGLE DRILLED UP AND INSTALLED IAW CRJ 700 SRM TASK 51-42-21-001-001-A01, AND SRM TASK 51-42-06-001-001-A01.Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Miscellaneous StructureSDR DALA2025101607565Floor Support · corrodedCORROSION ON FLOOR SUPPORTS RBL=10.45, RBL= 7.55, RBL=2.90, LBL=2.90, LBL=7.55, LBL=10.45 ON BSTA=1510, ALSO RBL=16.10 RBL=10.45, RBL=7.55, RBL=2.90, LBL=2.90, LBL=7.55, LBL=10.45, LBL=16.10 ON BS 1470 AT AFT CARGO COMPARTMENT. FLOOR SUPPORTS IN CARGO COMPARTOct 16, 2025 · N6713Y · Boeing 757232 · Fuselage Miscellaneous StructureSDR KCSA202510161210Seat Track · corrodedMAIN DECK SEAT TRACK @ STA 403 RBL 5, HAS SEVERAL AREAS WITH EVIDENCE OF CORROSIONOct 16, 2025 · N772CK · Boeing 777F1H · Fuselage, Seat/Cargo Attach FittingsSDR VNAA20251015045Window Frame · chafedPILOT AND COPILOT'S WINDOW UPPER SILL IS GOUGED ABOVE THE LH AND RH WINDSHIELD SIDE POST. REPAIRED UPPER SILL IAW MHIRJ REO 670-53-11-2088 REV-.Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, StructureSDR VNAA20251015044Beam · chafedRH IB FLAP MOVABLE VANE BEAMS (ALL 4) HAVE SIGNS OF WEAR/CHAFING FROM ROLLER CONTACT. PERFORMED MAJOR REPAIR BY COMPLYING WITH MHIRJ REO 670-57-52-257 REV -A DATED 2024-08-20. REPAIR HAS SDIR IMPLICATIONS THAT NEED CAPTURED-VERIFIED REQUIREMENTS ARE BEING TROct 16, 2025 · N501BG · Cndair CL6002C10 · Trailing Edge FlapsSDR VNAA20251015043Tie Down · corrodedAFT CARGO FWD CARGO TIE DOWN IS CORRODED BETWEEN F.S. 1000 TO F.S. 1015. REMOVED CORRODED TIE DOWN ASSEMBLY PLATE IAW CRJ 700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. LOCATED, DRILLED AND INSTALLED NEW SERVICEABLE TIE DOWN ASSEMBLY PLATE (PN:MM670-Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage, Seat/Cargo Attach FittingsSDR VNAA20251015042Seat Track · corrodedRBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 985 TO F.S. 1000. REMOVED AND REPLACED SEAT TRACK IAW MHIRJ REO 670-53-00-767 REV-- DATED 2025-01-22. BA670-45073-3Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage, Seat/Cargo Attach FittingsSDR VNAA20251015041Frame · corrodedFS 661 FRAME IS CORRODED BETWEEN STGR 26L AND STGR 26R. COMPLIED WITH MHIRJ REO 670-53-31-1014 REV--P1.Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, FrameSDR KCSA202510161209Shear Web · corrodedMAIN DECK SHEAR WEB PANEL # 152W1209-19, HAS SEVERAL AREAS WITH EVIDENCE OF CORROSIONOct 16, 2025 · N772CK · Boeing 777F1H · Fuselage Miscellaneous StructureSDR VNAA20251015040Frame · corrodedFS 645 FRAME IS CORRODED BETWEEN STR26R AND STR26L. CORROSION IS ON BOTH SIDES OF THE FRAME AND ON THE FRAME FLANGE. REPAIRED FS 645 FRAME IAW MHIRJ REO 670-53-31-1010 REV-- DATED 2025-03-04.Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, FrameSDR VNAA20251015039Frame · corrodedFRAME FLANGE AT FS597 BETWEEN STR26R AND ST27 HAS MINOR CORROSION. FABRICATED REPAIR ANGLE FROM 7075-0 .071" PO# 5-43729 IAW CRJ 700 SRM 51-24-21-001-001-A01. REF. REO 670-53-31-0308 REV. -- DATED 2013-12-03. INSTALLED FS 597 FRAME FLANGE REPAIR ANGLE BETWEEOct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, FrameSDR VNAA20251015038Intercostal · corrodedAVI DOOR R/H FWD INTERCOSTAL IS CORRODED BETWEEN STGR 27 TO STGR 26R. REMOVED AND REPLACED AVI DOOR R/H INTERCOSTAL BETWEEN STGR 27 TO STGR 26R IAW CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01.Oct 16, 2025 · N501BG · Cndair CL6002C10 · Electrical/Electronic Compartment DoorsSDR VNAA20251015037Stringer · corrodedSTRINGER 19 R IS CORRODED BETWEEN F.S. 280 TO F.S. 295. REMOVED STGR 19R FROM FS280 TO FS310 IAW CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. LOCATED, DRILLED, AND DEBURRED STGR 19R PN: SH670-31632-1 BETWEEN F.S. 280 TO F.S. 310 IAW CRJ700 SRM 5Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, Longeron/StringerSDR VNAA20251015036Stringer · corrodedSTRINGER 22L IS CORRODED BETWEEN F.S. 280 TO F.S. 295. REMOVED STGR 22 L IS BETWEEN F.S. 280 TO F.S. 333 IAW CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. LOCATED, DRILLED, AND DEBURRED STGR 22 L PN: SH670-31210-1U BETWEEN F.S. 280 TO F.S. 333 IAOct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, Longeron/StringerSDR VNAA20251015035Stringer · corrodedSTRINGER 20L IS CORRODED BETWEEN F.S. 280 TO F.S. 295. REMOVED AND REPLACED STRINGER 20L BETWEEN FS 295 AND FS 310 IAW CRJ-700 SRM’S 51-42-06-001-001-A01, 51-42-21-001-001-A01, AND 51-40-11-001-001-A01.Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, Longeron/StringerSDR VNAA20251015034Frame Angle · corrodedFRAME FLANGE AT FS501 STR27 HAS MINOR CORROSION. REPAIRED FS501 FRAME SECTOR PN:SH670-33209-1 BETWEEN STGR26L AND STGR26R IAW MHIRJ REO 670-53-31-998 REV--DATED 2025-02-13Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, FrameSDR VNAA20251015033Floorbeam · corrodedFLOORBEAM AT FS333.00 RBL 9.00 IS CORRODED. REPAIRED IAW MHIRJ REO 670-53-21-25485 REV-- .Oct 16, 2025 · N501BG · Cndair CL6002C10 · Fuselage Main, Floor BeamSDR JR2R20251016319Access Panel · crackedAPU ACCESS PANEL 351BZ IS CRACKED. REPAIREDOct 16, 2025 · N88301 · Emb ERJ170200LL · Fuselage Main, Plate/SkinSDR JR2R20251016451Floorbeam · crackedANGLE CLIP ON THE FWD SIDE OF FLOOR CROSS BEAM 12 AT BL 0 IS CRACKED. REPLACEDOct 16, 2025 · N88301 · Emb ERJ170200LL · Fuselage Main, Floor BeamSDR JR2R20251016450Floorbeam · crackedANGLE ON THE FWD SIDE OF FLOOR CROSS BEAM 12 AT ABOUT LBL 36 IS CRACKED. REPLACEDOct 16, 2025 · N88301 · Emb ERJ170200LL · Fuselage Main, Floor BeamSDR KCSA202510161208Rib · crackedRIGHT WING L/E RIB AT APPROX ISS 356 CRACKED.Oct 16, 2025 · N772CK · Boeing 777F1H · Wing, Rib/BulkheadSDR KCSA202510161207Floor Support · corrodedFLOOR SUPPORT FITTING AT BS 1790, APPROX RBL 92 HAS EVIDENCE OF CORROSION.Oct 16, 2025 · N772CK · Boeing 777F1H · Fuselage Miscellaneous StructureSDR HALA2025FA0000718Frame · corroded(MSN 1615 ) SECTION LONGITUDINAL FR 66 TO 67 RH FOUND CORROSION AT FR 67Oct 16, 2025 · N378HA · Airbus A330243 · Fuselage Main, FrameSDR SWIA2025101575784Roller · wornRH SLAT TRACK 3-2 FWD IB AND FWD OB SIDE ROLLERS WORN OUT OF LIMITS. REMOVED AND REPLACED RH SLAT TRACK 3-2 FWD OB ROLLER PER CRJ 900 AMM 27-81-44-400-803 (CONFIG A01) AND REEVALUATED RH SLAT TRACK 3-2 FWD IB ROLLER FOUND TO BE WITHIN LIMITS PER CRJ 900 AMM 2Oct 15, 2025 · N246LR · Cndair CL6002D24 · Leading Edge DevicesSDR SWIA2025101575783Roller · wornRH SLAT TRACK 2-2 AFT IB SIDE ROLLER WORN OUT OF LIMITS. REEVALUEATED RH SLAT TRACK 2-2 AFT SIDE ROLLER FOUND TO BE WITHIN LIMITS PER CRJ 900 AMM 27-81-43-220-801 (CONFIG A01) STEP 4. E. (1) - (7) AND REINSTALLED PER CRJ 900 AMM 27-81-44-400-802 (CONFIG A01)Oct 15, 2025 · N246LR · Cndair CL6002D24 · Leading Edge DevicesSDR SWIA2025101575782Roller · wornRH SLAT TRACK 1-2 FWD AND AFT IB SIDE ROLLERS AND AFT OB SIDE ROLLER WORN OUT OF LIMITS (C-CHECK RO 04/17/2026)REMOVED AND REPLACED RH SLAT TRACK 1-2 FWD IB ROLLER PER CRJ 900 AMM 27-81-44-400-801 (CONFIG A01) AND REEVALUATED RH SLAT TRACK 1-2 AFT OB ROLLER AOct 15, 2025 · N246LR · Cndair CL6002D24 · Leading Edge DevicesSDR SWIA2025101575781Roller · wornLH SLAT TRACK 3-2 FWD OB SIDE ROLLER AND AFT IB SIDE ROLLER WORN OT OF LIMITS. REEVALUATED LH SLAT TRACK 3-2 FWD OB SIDE ROLLER AND AFT IB SIDE ROLLER AND FOUND TO BE IN LIMITS PER CRJ 900 AMM 27-81-43-220-801 STEP 4. E. (1) - (7) REINSTALLED PER CRJ 900 AMM Oct 15, 2025 · N246LR · Cndair CL6002D24 · Leading Edge DevicesSDR SWIA2025101575780Roller · wornLH SLAT TRACK 2-2 FWD AND AFT IB SIDE ROLLERS AND FWD OB SIDE ROLLER WORN OUT OF LIMITS. REMOVED AND REPLACE LH SLAT TRACK 2-2 FWD IB AND OB ROLLERS PER AMM 27-81-44-400-802 (CONFIG A01) AND REEVALUATED AFT IB ROLLER FOUND TO WITHIN LIMMITS PER AMM 27-81-43-2Oct 15, 2025 · N246LR · Cndair CL6002D24 · Leading Edge DevicesSDR SWIA2025101575779Roller · wornLH SLAT TRACK 1-2 FWD AND AFT OB SIDE ROLLERS AND FWD IB SIDE ROLLER WORN OUT OF LIMITS. REMOVED AND REPLACED LH SLAT TRACK 1-2 IB AND OB FWD ROLLERS PER AMM 27-81-44-400-801 (CONFIG A01) REEVALUATED LH SLAT TRACK 1-2 AFT OB SIDE ROLLER FOUND TO BE WITHIN LIMOct 15, 2025 · N246LR · Cndair CL6002D24 · Leading Edge DevicesSDR DALA2026031101710Seat Track · corrodedFWD FUSELAGE SEAT TRACK CORROSION LBL 23.0 AT FRAME 22. SSI: 53- 21-43-01. NO EVIDENCE OF PREVIOUS RE-WORK OR REPAIR NOTED. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0571:5321-2021/004 00306 ACCOMPLISHED PRI 629312-14 REV 0, REV 1, REV 2, AND ERA 629321-14Oct 15, 2025 · N131DU · Airbus BD5001A10 · Wing, Attach FittingsSDR SWIA2026022575332Skin · dentedRH INBOARD FLAP LOWER SKIN HAS 4 DENTS LOCATED 14" FROM INBD EDGE AND 4" FROM TRAILING EDGE, 32" FROM INBD EDGE AND 2" FROM TRAILING EDGE, 20.5" FROM INBD EDGE AND 24" FROM TRAILING EDGE, 26" FROM INBD EDGE AND 24" FROM TRAILING EDGE. (C-CHECK RO 02/22/2026)Oct 15, 2025 · N613SK · Cndair CL6002C10 · Trailing Edge FlapsSDR SWIA2026022575322Skin · dentedLH INBOARD FLAP LOWER SKIN HAS 5 DENTS LOCATED 19" FROM INBD EDGE AND 2.5" FROM TRAILING EDGE, 16" FROM INBD EDGE AND 13" FROM TRAILING EDGE, 18" FROM INBD AND 15" FROM TRAILING EDGE, 17.5" FROM INBD EDGE AND 16.5" FROM TRAILING EDGE, 19" FROM INBD EDGE AND 24Oct 15, 2025 · N613SK · Cndair CL6002C10 · Trailing Edge FlapsSDR 3EJA202601091525Signal Cond Unit · failedAFTER TAKEOFF, WE HAD A FUEL GAUGE LEFT ANNUNCIATOR, AND THE FUEL GAUGE HAD GONE DOWN TO 10 POUNDS. R & R FUEL QUANTITY SIGNAL CONDITIONER, OPS CHECK GOOD.Oct 15, 2025 · N782JS · Cessna 525B · Fuel System WiringSDR 3EJA2026010900025Control Valve · failedAFTER DEPARTURE OF 27L OUT OF KPHL I FELT MY EARS POP. LOOKED DOWN AND THE PRESSURE CONTROLLER WAS BLANK. THIS WAS ABOUT 1500 AGL.Oct 15, 2025 · N780JS · Cessna 525B · Cabin Pressure Control SystemSDR SWI2026F00043Floor Support · corrodedRIGHT PRESSURE FLOOR SILL HAS MULTIPLE AREAS OF CORROSION BETWEEN FS409+128 AND FS559. REMOVED CORROSION ON RT FLOOR SILL BETWEEN FS409+128 AND FS559 AND FOUND TO BE WITHIN LIMITS. REF. GREO 601R-53-41-666, REV. C, DISPOSITION 1.2. COMPLIED WITH TASK CARD 5Oct 15, 2025 · N454SW · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR SWIA20260105001Floor Support · corrodedLEFT HAND PRESSURE FLOOR SILL HAS MULTIPLE AREAS OF CORROSION BETWEEN FS409 +128 AND FS559. REMOVED CORROSION ON LT FLOOR SILL BETWEEN FS409+128 AND FS559.00 AND FOUND TO BE WITHIN LIMITS. REF. GREO 601R-53-41-666, REV. -C, DISPOSITION 1.2. COMPLIED WITH TASOct 15, 2025 · N454SW · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR SWIA2025121901015Drain · misrepairedWHILE WORKING SB 601R-57-054 INADVERTENTLY REAMED SATELLITE HOLES FOR WATER DRAINS AT BL 0 ON LT & RT SIDES BETWEEN STRINGERS 14-15. REPAIRED SATELLITE HOLES FOR WATER DRAINS AT BL 0 ON LT AND RT SIDE BETWEEN STRS 14-15 IAW REO 601R-57-21-3982 REV -.Oct 15, 2025 · N910EV · Cndair CL6002B19 · Fuselage Main, StructureSDR HNAA2025112000772Beam · crackedF078457 LH ESCAPE HATCH BEAM 3 HAS A POSSIBLE CRACK AT AFT EDGE. REMOVED AND REPLACED LH ESCAPE HATCH BEAM 3 IAW EMB 145 SRM 51-40-02.Oct 15, 2025 · N900AE · Emb EMB145LR · Emergency ExitsSDR SWAA2025111931677Support Bracket · corrodedCORROSION REAR SPAR FUEL BOOST PUMP UPPER BONDING JUMPER SUPPORT BRACKET AT LT WING. R & R THE UPPER BONDING JUMPER AND UPPER BONDING CLIP OF THE AFT FUEL BOOST PUMP TANK 1 IAW AMM 28-22-41-000-801 STEP 2.H.(8), AND AMM 28-22-41-400-801 STEP 3.H.(22) TO 3.H.Oct 15, 2025 · N910WN · Boeing 7377H4 · Wing Miscellaneous StructureSDR SWAA2025111924775Access Panel · crackedCRACK ACCESS PANEL 561AB TRAILING EDGE AROUND HOLES LT WING. REPAIRED ACCESS PANEL 561AB TRAILING EDGE LT WING IAW SRM 51-70-04-2R-10 REPAIR 10.Oct 15, 2025 · N910WN · Boeing 7377H4 · Wing, Plate/SkinSDR SWAA2025111924776Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661BB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661BB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-10, REPAIR 10.Oct 15, 2025 · N910WN · Boeing 7377H4 · Wing, Plate/SkinSDR SWAA2025111924777Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661CB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661CB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-10, REPAIR 10.Oct 15, 2025 · N910WN · Boeing 7377H4 · Wing, Plate/SkinSDR SWAA2025111924778Angle · crackedCRACK ON ANGLE LOCATED BTW BS291.5 TO BS294.5 AND STR17R AT FWD GALLEY AND LAVATORY. REPLACED ANGLE AND FASTENERS LOCATED BTW BS291.5 TO BS294.5 AND STR17R AT FWD GALLEY AND LAVATORY IAW B737-700 SRM 51-40-02-0G AND DWG 141A8310 SHEET 25 REV-.Oct 15, 2025 · N910WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025111924780Access Panel · crackedCRACK ACCESS PANEL 561BB TRAILING EDGE AROUND HOLES LT WING. REPAIRED ACCESS PANEL 561BB TRAILING EDGE LT WING IAW SRM 51-70-04-2R-10, REPAIR 10.Oct 15, 2025 · N910WN · Boeing 7377H4 · Wing, Plate/SkinSDR SWAA2025111924781Access Panel · crackedCRACK ACCESS PANEL 561CB TRAILING EDGE LOCATED AROUND HOLES LT WING. REPAIRED ACCESS PANEL 561CB TRAILING EDGE LT WING IAW SRM 51-70-04-2R-10 REPAIR 10.Oct 15, 2025 · N910WN · Boeing 7377H4 · Wing, Plate/SkinSDR SWAA2025111924783Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986.5, WL 208.1 AND LBL 42 AFT GALLEY AREA. REPAIRED FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6, FIGURE 205, ALTERNATIVE 4, SHEET 1, DETAIL A-A.Oct 15, 2025 · N910WN · Boeing 7377H4 · Fuselage Main, Floor BeamSDR SWAA2025111924784Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661AB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661AB TRAILING EDGE AT RT WING IAW B737-700 SRM 51-70-04-2R-10 REPAIR 10.Oct 15, 2025 · N910WN · Boeing 7377H4 · Wing, Plate/Skin