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 DALA2025120508894Floorbeam · corrodedCORROSION ON FLOOR BEAM STA 1640 RBL 2 TO LBL 3 AREA IT IS OUT LIMITS PER B757-200 SRM 53-00-51-1A FIG; 101, NOTE B, DETAIL III. AND B757 NDT MANUAL 51-00-10 PAR. 4 PROCEDURE 2. CORROSION LEVEL 2, FLOOR BEAM STA 1640 BTW RBL 7 TO LBL 33, WAS REPAIRED PER B75SDR KCSA202512051234Longeron Fitting · crackedAFTER NDT INSPECTION PER W/O 740037417 EO 5313-23-02 FOUND 1 EA FASTENER HOLE WITH CRACK INDICATION ON STA 2598 STR 11 LONGERON L/H SIDE UPPER FITTINGSDR KCSA202512051233Tension Tie · crackedAFTER TENSION TIE NDT INSPECTION FOUND 7 EA FASTENER HOLES WITH CRACK INDICATION ON STEEL PLATE STA 1180 R/HSDR DALA2025120508889Bracket · damagedTOOLING DAMAGE ON BRACKET IN UPPER AND LOWER RADIUS'S ON BACKSIDE OF FRAME 61 OUTBOARD OF P'2. REPAIRED PER ERA 628248-14 REV ORIG. (1336663)SDR DALA2025120508888Bracket · damagedTOOLING DAMAGE ON BRACKET IN UPPER AND LOWER RADIUS ON FORWARD SIDE OF FRAME 62@ P1- BETWEEN P2 AND P3. REPAIRED PER ERA 628248-14. (1336652)SDR DALA2025120508887Bracket · damagedTOOLING DAMAGE ON BRACKET IN LOWER RADIUS ON AFT SIDE OF FRAME 61 @ P1- BETWEEN P2 AND P3. CORRECTIVE ACTION: REPLACED PER ERA 628248-14. (1336651)SDR DALA2025120508886Skin · crackedCRACKS BETWEEN FR61 TO FR62 BETWEEN STRINGER 2L AND 3L. REPAIRED PER SRM 51-42-11. (1336650)SDR FDEA202512052223Lamp · no testPRE-FLT MX INSP, L1 DOOR OVRHD EMERGENCY LIGHT INOP. REPLACED THE LAMP, IAW AMM 33-50-00-2. EMERGENCY LIGHTS TEST SATIS, ITEM OK FOR SVC.SDR FDEA202512052222Floorboard · dentedFLOORBOARD 241WFF DELAMINATED IN SEVERAL PLACES REPAIRED DELAMINATION ON FLOOR PANEL 241WFF (MPN: 145T5876-51) AT STA 980 TO STA 1114.82, LBL11 - RBL11 IN REF TO B767 SRM 53-00-50-2R FIG 201, REPAIR 1, SHEET 2. THIS IS A MAJOR REPAIR. INSTALLATION OF FLOORSDR FDEA202512052221Smoke Detector · failedAVIONICS SMOKE WARNING ON TAKEOFF. WARNING CONTINUED UNTIL SHUTDOWN. EMERGENCY DECLARED. CONFIRMED NO OIL/HYDRAULIC ODOR IN FLIGHT DECK, AVIONICS COMPARTMENT. OPENED C/B 1WA (F25) AND NO ALERT MESSAGES OR FAULT LIGHT. SMOKE DETECTOR 13WA REQUIRES REPLACEMESDR FDEA202512052220Pin · missingR1 DOOR SLIDE DEACTIVATION PIN IS MISSING RED FLAG. AMM 52-10-00-03-02 NO MEL OR OIL RELIEF, DUE TO THIS FLAG BEING EMERGENCY EQUIPMENT A/C MAY NOT ENTER INTO SERVICE UNTIL FLAG AND PIN ASSY IS INSTALLED. IAW AMM 52-10-00-03-02 INSTALLED SERVICEABLE PIN SDR KCSA202512051232Plate · crackedAFTER TENSION TIE NDT INSPECTION FOUND 8 EA FASTENER HOLES WITH CRACK INDICATION ON STEEL PLATE BS 1140 RT.SDR KCSA202512051231Plate · crackedAFTER TENSION TIE NDT INSPECTION FOUND 7 EA FASTENER HOLES WITH CRACK INDICATION ON STEEL PLATE BS 1220 RT.SDR KCSA202512051230Plate · crackedAFTER TENSION TIE NDT INSPECTION FOUND 7 EA FASTENER HOLES WITH CRACK INDICATIONS ON STEEL PLATE BS 1180 LT.SDR DALA2025120508882Floor Support · corrodedUPON REMOVAL OF MAIN CABIN FLOOR PANEL 221BF IN THE FORWARD CABIN AREA, IDENTIFIED CORROSION ON INTERCOSTAL AT BS 312, LBL 12, WL 208. REMOVED AND REPLACED WITH NEW INTERCOSTAL PER DWG 141A5600 AND B737-900 SRM 51-40-02-0G.SDR KCSA202512051229Web · crackedSEVERAL CRACKED PANELS IN AREA INSIDE OF THE FUSELAGE FWD OF NOSE GEAR WELL STA 140-180 L/H AND R/H LOCATIONS. 4 EA. WEBSSDR VNAA202512020057Floorbeam · crackedRT FLIGHT COMPARTMENT FLOORBEAM CRACKED ON THE FWD SIDE OF THE BS 280SDR VNAA202512020056Stringer · corrodedSTRINGER 27 IS CORRODED BETWEEN BS 265 TO 250.SDR VNAA202512020055Beam · gougedLEFT UPPER C-DUCT LATCH BEAM NR 1 LUG IS GOUGED ON THE INBOARD SIDE.SDR VNAA202512020054Hinge · corrodedAFT CARGO COMPARTMENT STEP PLATE HAS CORRODED HINGE MARKED WITH RED TAPE. HEM670-35623-003 HINGESDR VNAA202512020053Stiffener · corrodedWHILE ACCESSING FOR REPAIR OF THE L/H FS280 LOWER BULKHEAD, FOUND THE STIFFENER AT LBL 26 TO BE CRACKED AT THE BOTTOM HOLE. DAMAGE IS OUT OF LIMITS IAW CRJ-700 SRM 53-00-00-101-001-A01. FS280 BULKHEAD FWD STIFFENER AT LBL 26.00 REQUIRES REPLACEMENT.SDR VNAA202512020052Floorbeam · corrodedWHILE ACCESSING FOR REPAIR OF LT FS280 LOWER WEB, FOUND THE LT BS 280 FLOORBEAM TO HAVE DEEP PITTING CORROSION WITH THE DEEPEST DAMAGE BEING .048 AT LBL12 WHICH IS OUT OF LIMITS IAW CRJ-700 SRM 53-00-00-101-001-A01. LT BS 280 FLOORBEAM REQUIRES REPLACEMENT.SDR VNAA202512020051Floorbeam · crackedLBL9 COCKPIT FLOOR BEAM PANEL SUPPORT ANGLE P/N: CC670-33199-3 HAS ONE EACH CRACK PROPOGATED FROM HOLE @ AFT END OF ANGLE. CC670-33199-3S PANEL SUPPORT BRACKETSDR VNAA202512020050Washer · corrodedF.S 280 LH LOWER BULKHEAD @ LBL 9 HAS SEVERE INTERGRANULAR CORROSION CAUSING LOWER WEB CLOSE OUT ANGLE TO BE PUSHED OUT. 670-53-11-594-1 WEBSDR VNAA202512020049Washer · damagedRFTS FOR AN EA TO FABRICATE PN CC670-10635-7 FOR HR00557371, SO# 400382749 AND FABRICATE AS INSTRUCTED. (THIS CARD IS FOR RFTS SUBMITTAL AND FABRICATION OF QTY 1 PN CC670-10635-7 WASHERSDR VNAA202512020048Washer · damagedPER CUSTOMER REQUEST, SUBMIT RFTS FOR AN EA TO FABRICATE PN CC670-10635-7 FOR HR00557370, SO# 400382748 AND FABRICATE AS INSTRUCTED. (THIS CARD IS FOR RFTS SUBMITTAL AND FABRICATION OF QTY 1 PN CC670-10635-7). CC670-10635-7 WASHERSDR VNAA202512020047Trunnion · corrodedFOUND FOUR TRUNNION BODIES CORRODED ON LT FLS 24.00, 65.50, 102.90, AND FLS 40.40 THAT REQUIRE FABRICATION. MHI601R14261-601R14261 REV NC.SDR VNAA202512020046Bracket · crackedFOUND CRACK ON MOUNTING BRACKET FOR HYDRAULIC ACCUMULATOR ON LT SIDE OF TRU BAY.SDR VNAA202512020045Bracket · damagedINDICATIONS NOTED AT THE REAR SPAR LATERAL BEAM SIDE STAY BRACKET LHS OUTBD. AFT BORE APPROX. .500" IN LENGTH AND 80% F.S.H FAILING NDT SH670-35627. WINDSHIELD FWD LOWER SILLSDR SCNA20251205462B-Nut · leakingDURING POST FLIGHT INSPECTION NR 2 WHEEL AND BRAKE ASSY WAS COATED WITH FLUID & WAS SMOKING. REQUEST INSPECTION OF NR 2 MLG. PERFORMED A HYDRAULIC SYSTEM EXTERNAL LEAKAGE CHECK IAW AMM 29-00-00, FOUND ALT BRAKE SELECTOR VALVE B-NUT LOOSE, TIGHTENED THE B-SDR KCSA202512051228Battery Pack · weakCENTER EMERGENCY LIGHTS ON UPPER DECK DO NOT STAY ILLUMINATED.SDR REXA2026052700754Access Panel · corrodedRUSTED COUNTERSINK HOLES ON RIGHT WING ACCESS PANEL 542AT. SUMMARY: PART NUMBER OF ACCESS PANEL 542AT WAS VERIFIED PER CRJ900 AIPC 57-20-32 ON ITEM 10 AND WAS REPLACED/INSTALLED PANEL UNDER JOBCARD CRJ900-500-OPEN/CLOSE.SDR REXA2026052700753Angle · corrodedCORROSION AT FWD WASTE SERVICE DOOR INTERNAL STRUCTURE, INCLUDING IMPACT ANGLE, FWD FRAME, AFT FRAME, UPPER & LOWER MEMBRANE.RMENT DOOR. CORROSION AT FWD WASTE SERVICE DOOR INTERNAL STRUCTURE, INCLUDING IMPACT ANGLE, FWD FRAME, AFT FRAME, UPPER & LOWER MEMBRANSDR REXA2026052700751Packer · corrodedCORROSION AROUND ON PRESSURE SEAL RETAINER AT E/E COMPARMENT DOOR. CORROSION IN SERVICE DOOR 142BR WAS REPAIRED PER EA NO. CRJ952-21062 REV IR AND DUE TO EXECESSIVE CORROSION ON PACKERS WERE REPLACED PER EA CRJ952-21063 REV: IR AND CRJ 900 SRM 51-42-02-001-001SDR REXA2026052700741Intercostal · corrodedCORROSION ON INTERCOSTALS (2 E/AS) LOWER FACE BTW FS 310 TO 349 & STRINGER 21L ALSO BENT CONNECTOR J393 SUPPORT. CORROSION ON INTERCOSTALS (2 E/AS) LOWER FACE BTW FS 310 TO 349 & STRINGER 21L WAS REMOVED PER CRJ 900 SRM 51-21-06-001-001-A01, WERE EVALUATED OUTSDR REXA2026052700740Intercostal · corrodedCORROSION ON INTERCOSTALS (2 E/AS) LOWER FACE BTW FS 310 TO 349 & STRINGER 21L ALSO BENT CONNECTOR J393 SUPPORT. CORROSION ON INTERCOSTALS (2 E/AS) LOWER FACE BTW FS 310 TO 349 & STRINGER 21L WAS REMOVED PER CRJ 900 SRM 51-21-06-001-001-A01, WERE EVALUATED OUTSDR SWIA2025120475813Skin · damagedADM# N941SW-6379 BETWEEN FS193 AND 202.75, AND BETWEEN STRINGER 21L AND STRINGER 23L. LENGTH 32", WIDTH 2.4", DEPTH .100". PLOT, MAP, AND EVALUATE DAMAGE IF WITHIN ACCEPTABLE LIMITS OR REWORKED, ELIMINATE EVIDENCE USING STANDARD ACFT PRACTICES. REPAIRED EXTESDR VNAA20260303013Seat Track · corrodedCORRODED SEAT TRACK, RBL 9, BS 881 - 897. THE SEAT TRACK WAS EVALUATED, AND FOUND TO EXCESS DAMAGE IAW SRM 53-51-51-101-001-A02, AND REPLACED IAW AMM 53-00-49-400-801.SDR SWIA2026020975232Frame · fomFS485.00 FRAME SEGMENT NEEDS REMOVED FROM STR 20R TO STR 25R TO FACILITATE STR 21R REPLACEMENT. REMOVED AND REPAIRED FS 485.00 FRAME SEGMENT IAW MHIRJ REO 670-53-31-1138 REV -- DATED 2025-12-04. REFERENCE CONTINUE CARD FOR WORK PERFORMED.SDR VNAA20260205011Strap · wornGOUGES ON UPPER STRAP OF PASSENGER DOOR SURROUND STRUCTURE FRAME 349.0 STGR 3LH AT PASSENGER CABIN. GOUGES ON UPPER STRAP OF PASSENGER DOOR SURROUND STRUCTURE FRAME 349.0 STGR 3LH AT PASSENGER CABIN WAS BLEND OUT PER SRM 51-12-00-001-001-A01 AND WAS REPAIRED SDR VNAA20260202006Mount · corrodedCORROSION ON MOUNTING ANGLE OF SERVICE DOOR SILL AT STGR 18R BETWEEN FS295.00 AND FS310.00. FOR EXCESSIVE DAMAGE ON MOUNTING ANGLE OF SERVICE DOOR SILL AT STGR 18R BETWEEN FS295.00 AND FS310.00 WAS REPLACED PER SRM 53-21-23-101-002-A01 AND PER SRM 51-42-06-SDR VNAA20260202005Frame · corrodedCORROSION ON FRAME FS364.00, STGR27, BEHIND THE PROXIMITY SWITCH BRACKET OF AVIONICS BAY DOOR. CORROSION ON FRAME FS364.00, STGR27, BEHIND THE PROXIMITY SWITCH BRACKET OF AVIONICS BAY DOOR WAS REMOVED PER SRM 51-21-06-001-001-A01, WAS MEASURED AND FOUNT OUT OSDR VNAA20260202004Seat Track · corrodedCORROSION ON SEAT TRACKS RBL 9 & LBL 9 BTW STA 485 - 677. THE SEAT TRACKS WERE EVALUATED IAW SRM 53-21-49-101-001-A01, AND SRM 53-31-49-101-001-A01, & REPLACED IAW AMM 53-00-49-400-801-A03.SDR VNAA20260202003Floorbeam · crackedCRACK ON FLOORBEAM, RBL 12, BS 220, BELOW WL79.50. THE FLOORBEAM WAS REPAIRED IAW REO 670-53-11-2238, REV-.SDR VNAA20260202001Roller · wornWEAR ON CAM ROLLER FITTING OF PASSENGER DOOR SURROUND STRUCTURE FS 349.0, STGR 5LH AT PASSENGER CABIN. NEW CAM ROLLER FITTING OF PASSENGER DOOR SURROUND STRUCTURE FS 349.0, STGR 5LH AT PASSENGER CABIN WAS REPLACED PER CRJ-700 SRM 51-42-21-001-001-A01SDR JJBA20260130050Frame · corrodedCORRODED FRAME 22 STR 17R. REMOVED AND INSTALLED NEW FROM STOCK GUSSET AT FRAME 22 STR 17RSDR JJBA20260130047Skin · dentedFUSELAGE EXTERNAL SKIN AT FR 25, RH, STR 20R, HAS PROTRUSION. RECONTOURED PROTRUSION ON FUSELAGE EXTERNAL SKIN AT FR 25, RH, STR 20RSDR CALA2026011412963Floor Support · crackedMAIN CABIN FLOOR SUPPORT UPPER CHORD FLOORBOARD ATTACH FLANGE IS CRACKED IN MULTIPLE LOCATIONS BETWEEN STA 380 AND 400 AT APPROX LBL13. TRANSCRIBED FROM AAR GSO NRC 9288635 ESFR COMPLETE. REMOVED AND REPLACED INTERCOSTAL UPPER CHORD P/N 143A5410-4174 PO# 113SDR AALA202601143734Shim · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT SERVICE DOOR CUTOUT SHIM AT BS 967, S16R. REPLACED SHIM PER SRM 53-70-15-2R.SDR AALA202601143901Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING OTBD T/E AFT FLAP LOWER SURFACE HAS A PREVIOUS REPAIR LOCATED AT THE CENTER OF THE FLAP THAT IS DELAMINATED. REPAIRED FLAP IAW SRM 57-53-00-300-093.