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 IXXA20250703003Fairing · chafedLT O/B FLAP FAIRING 573BB SEAL RETAINER AND SEAL ARE CHAFEDSDR IXXA20250703002Beam · cracked#1 PYLON AFT STINGER FAIRING INTERNAL I/B I-BEAM BROKEN PIECESDR IXXA20250703001Skin · chafedLEFT WING AFT FLAP L\E CHAFED BEYOND LIMITSSDR REXA2026072901298Skin · wornSEVERAL NICKS AND WEAR ON LOWER SKIN OF RH INBOARD FLAP FLS 15.00 TO FLS 65.00 LOWER SKIN OF RH INBOARD FLAP FLS 48.00 TO FLS 65.00 WING WAS BLENDED OUT PER CRJ 900 SRM 51-12-00-001-001-A01 AND EVALUATED WITHIN LIMITS PER CRJ-900 SRM 57-52-01-101-001-A01 AND LSDR REXA2026072901293Skin · wornWEAR ON EXTERNAL FUSELAGE SKIN STR 27L, BTW BS 900 - 920 WEAR ON FUSELAGE SKIN WAS EVALUATED SKIN BTW BS 913 - 927, STR 27L, FOUND OUT LIMITS AND SKIN AT BS 900 IS WITHIN LIMITS IAW SRM 53-00-01-101-001-A01 AND AREA WAS REPAIRED IAW EA CRJ953-19697, REV IR.SDR SWIA202512090702Hinge Fitting · gougedLEFT OTBD FLAP, MID. HINGE AFT FLAP ATTACH FITTING, INBD LUG GOUGED. REMOVED DAMAGE FROM LT OTBD FLAP MID HINGE FLAP ATTACH FITTING IAW SRM 51-12-00-001-001-A01. PERFORMED HFEC OF LT OTBD FLAP ATTACH FITTING INBD LUG REWORKED AREA IAW PART 1 51-20-006-250-A01SDR SWIA20250702Landing · crackedRIGHT HAND TRU BAY, LAND HAS A SUSPECTED CRACK JUST ABOVE THE AFT LATCH RECEPTACLE. PERFORMED PERMANENT REPAIR (PART REPLACEMENT). COMPLIED WITH M-337. SEE CAMP 30869266 FOR RVSM MAPPING REFERRAL. REF. CRJ 900 SRM 51-40-11-001-001-A01.SDR SWI2025F01497Stand Off · crackedR/H UPPER TRANSCOWL OUTBD "A" BRACKET STANDOFF CRACKED. (C-CHECK RO 11/01/2025)REMOVED AND INSTALLED NEW R/H UPPER TRANSCOWL OUTBD "A" BRAKET (P/N CN624-2082-201) REF REO# 670-54-21-971, REV B, DATED 11/28/23, OPS TEST OF TRANSCOWL LATCHES GOOD. COMPLIED WISDR SWI2025F01496Support · corrodedNOSE GEAR JACK PAD LEFT HAND SUPPORT LOWER FLANGE IS CORRODED.(MARKED) (C-CHECK RO 11/01/2025)REMOVED AND INSTALLED NEW NOSE GEAR JACK PAD LH SUPPORT REF. DWG CC670-32050 REV-NC, CRJ900 SRM 51-42-06-001-001-A01 AND CRJ900 SRM 51-42-21-001-001-A01. COMPLIED WISDR SWIA202511030702Stand Off · crackedL/H LOWER TRANSCOWL INBD "A" BRACKET STANDOFF CRACKED. (C-CHECK RO 11/01/2025)L/H LWR TRANSCOWL I/B "A"BRACKET HAS BEEN REMOVED AND REPLACED (PN CN624-2082-201) REF REO# 670-54-21-971, REV B, DATED 11/28/23. COMPLIED FULLY W/SKYCARD 51-900-1002-SKY.SDR COEA2025103008919Panel · corrodedWO 264878 NR 600034 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: PANEL 622CT HAS LEVEL 2 CORROSION. CORRECTIVE ACTION: REPAIRED PER SRAS ES_00265302_01...25924 ISSUE A, DATED 8/6/2025.SDR COEA2025103004919Landing · corrodedWO 264878 NR 500045 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: L/H WING FWD SPAR UPPER STRIP SLAT HAS LEVEL 2 CORROSION ON LANDING FOR PANEL 513 RIBS 13-21. CORRECTIVE ACTION: REPAIRED PER SRAS S572K0048...25988 ISSUE A, DATED 9/24/2025.SDR SWIA20251002702Skin · crackedCOMPLY WITH LATEST REVISION SB NO. 601R-57-044 TITLE: WINGS - LOWER WING PLANK - COLD WORK OF FASTENER HOLES IN THE LOWER WING PLANK PART C LEFT SIDE AT BL45.00, PART D LEFT SIDE AT WS 65.75, PART F RIGHT SIDE AT BL45.00, AND PART G RIGHT SIDE AT WS65.75. (FISDR REXA2025092300874Angle · corrodedAFTER REMOVAL OF PASSENGER DOOR SURROUND MID CAP ANGLE FOUND KICK PLATE ANGLE TO BE CORRODED, REMOVED AND REPLACED KICKPLATE ANGLE IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01, LOCATED AND DRILLED UP A SERVICABLE KICKPLATE ANGLE IAW CRJ700 SRM 5SDR SWIA2025090900702Intercostal · corrodedPAX DOOR INTERCOSTAL DD1A FS338.00 - FS347.25 IS CORRODED (C-CHECK RO 09/07/2025) INSTALLED NEW PAX DOOR INTERCOSTAL DD1A. REF: CRJ-700 SRM 51-42-06-001-001-A01 AND DRAWING 601R31702 REV N. LEAK CHECK GOOD COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKYSDR SWI2025F01208Doubler · crackedPULL-IN CAM DOUBLER ON PAX DOOR FORMER FS338.00 IS CRACKED (C-CHECK RO 09/07/2025)REMOVED AND REPLACED PULL-IN CAM DOUBLER ON PAX DOOR FORMER FS338.00. REF: CRJ-700 SRM 51-42-06-001-001-A01,CRJ-700 SRM 51-42-21-001-001-A01,AND DRAWING 601R31702 REV N. COMPLISDR SWI2025F01207Channel · corrodedAFT CLEAT @ FS338.00 PAX DOOR FORMER AND LOWER CHANNEL IS CORRODED (C-CHECK RO 09/07/2025)REMOVED AND REPLACED W AFT CLEAT @ FS338.00 PAX DOOR FORMER AND LOWER CHANNEL . REF: CRJ-700 SRM 51-42-06-001-001-A01 AND DRAWING 601R31702 REV N. COMPLIED WITH 51-900-SDR SWI2025F01206Intercostal · corrodedPAX DOOR INTERCOSTAL DD5 FS338.00 - FS347.25 IS CORRODED (C-CHECK RO 09/07/2025)INSTALLED NEW PAX DOOR INTERCOSTAL DD5 FS338.00 - FS347.25 . REF: CRJ-700 SRM 51-42-06-001-001-A01 AND DRAWING 601R31702 REV N. LEAK CHECK GOOD . COMPLIED WITH SKYWEST TASK CARD 5SDR SWIA2025090200702Floor Panel · crackedCRACK FOUND IN ELECTRICAL BAY FLOOR PANEL (REF DWG 601R33101) AT FS 193.00 JUST BELOW AND OUTBOARD OF BRAKE ACCUMULATOR GUAGES. (C-CHECK RO 08/29/2025) REPAIRED CRACK IN ELECTRICAL BAY FLOOR PANEL AT FS 193.00 JUST BELOW AND OUTBOARD OF BRAKE ACCUMULATOR GUAGSDR IPXA2025072138048Rib · crackedMAJOR REPAIR, RH WING, CENTER FLAP, TOP SKIN RIB FLANGE, 2 CRACK INDICATION NOTED AT RIB 25. CIRCLED IN RED. VERIFIED PERMANENT REPAIR ACCOMPLISHED IAW EO-94347-REQ1 AND VT-MAE EA 300-5750-27-A4024, REV. -.SDR IPXA2025072138064Rib · crackedRH WING, CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK INDICATION NOTED AT RIB 19. CIRCLED IN RED. VERIFIED REPAIR WAS ACCOMPLISHED IAW E0-94347-REQ1 AND EA 300-5750-27-A4024.SDR IPXA2025072137992Rib · crackedRH WING, CENTER FLAP, TOP SKIN RIB FLANGE, 2 CRACK INDICATION NOTED AT RIB 26. CIRCLED IN RED. VERIFIED REPAIR HAS BEEN ACCOMPLISHED IAW VT-MAE EA 300-5720-27-A4024 REV- AND EO-94347-REQ1.SDR IPXA2025071230622Adapter · corrodedFOUND CORROSION AT CLS ADAPTER FR77 -Y1580.5 REMOVE AND REPLACE THE FR 78 CLS ADAPTER (P/N: A53275455204) LOCATED BETWEEN -Y1221.2 AND -Y1580.5 PER AIRBUS DRAWING A53278756 REQUIREMENTS AND A300-600F SRM CHAPTER 51 REQUIREMENTS. UPS CONSIDERS THIS A MINOR REPASDR IPXA2025080838089Rib · crackedRIGHT WING, CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK INDICATION NOTED AT RIB 13. CIRCLED IN RED. ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94347-REQ1 AND VT-MAE EA 300-5750-27-A4024, REV. -. REVIEWED.SDR SWAA2025081187638Support · corrodedCORROSION AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT PLATE HAS MULTIPLE AREAS AROUND NUT PLATE HOLES BS727B TO BS767 RBL22 WL156<[01] EVALUATED; LOCATED AND DRILLED; REMOVED AND REPRACED AFT CARGO BAY NEW R/H FLOOR TO SIDEWALL SUPPORT PLATE BS727 TO BS767 RBLSDR SWAA2025081187637Support · corrodedCORROSION AFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE MULTIPLE AREAS AROUND NUT PLATE HOLES BS727B TO BS767 LBL22 WL156<[01] EVALUATED; REMOVED; LOCATED; DRILLED AND REPLACED AFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE BS727 TO BS847 LBL22 WL156 IASDR SWAA2025081187635Splice Strap · corrodedCORROSION AFT CARGO BAY FLOOR SPLICE STRAP AROUND NUT PLATE HOLE BS887 RBL11.5 WL168<[01] EVALUATED; REMOVED; LOCATED; DRILLED AND INSTALLED FLOOR SPLICE STRAP BS887 LBL 8 TO RBL 22 WL 168 IAW SRM 51-40-02-0G-0 SRM 51-40-05-0G-0 AND DWG 149A8104 REV: B.;[02] CSDR SWAA2025081187636Shield · corrodedCORROSION AFT CARGO BAY SHIELD FWD OF CARGO DOOR AROUND MULTIPLE NUT PLATE HOLES BS767+3 TO BS794 RBL22 WL156<[01] EVALUATED; LOCATED AND DRILLED; REMOVED AND REPRACED AFT CARGO BAY NEW SHIELD BS767 TO BS794 RBL22 WL156 PER SRM 51-40-05-0G-0; SRM 51-40-02-0G-0SDR SWAA2025081187765Angle · crackedCRACK ON INBOARD AND OUTBOARD ANGLE LOCATED INBOARD AUXILIARY TRACK SLAT 1 AT LT WING (2E/A). REPLACED INBOARD AND OUTBOARD ANGLE LOCATED INBOARD AUXILIARY TRACK SLAT 1 AT LT WING (2E/A) IAW B737-700 CMM-57-43-01 PAGE 702 STEP 3 C ITEM (9).SDR SWAA2025081187758Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED BETWEEN STA927 TO STA947.5 AND BL0 AT AFT GALLEY AREA. REPLACED ANGLE LOCATED ON FLOOR STRUCTURE BETWEEN STA927 TO STA947.5 AND BL0 AT AFT GALLEY AREA IAW SRM 51-10-02-0G STEP 9 AND DWG 147A5400 SHEET 22 REV -.SDR IXXA20250809011Skin · corrodedLEFT WING, UPPER SURFACE SKIN IS CORRODED APPROX 7" OUTBD OF THE FUSELAGE STA 960SDR JJBA20250806003Floor Support · corrodedCF1 CENTER OMEGA BEAM BTW FR 18-20 FOUND CORRODED. AT CF1 CENTER OMEGA BEAM BTW FR 18-20 WIRES UNSECURED FOR ACCESS, CORROSION BLENDED OUT OF LIMIT. CF1 CENTER OMEGA BEAM BTW FR 19-24 REMOVED FOR REPLACEMENT. CF1 NEW CENTER OMEGA BEAM BTW FR 19-24 DRILLED. CF1SDR AALA202508014380Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING LH SIDE FWD GALLEY AREA, MEASURE OF CORROSION: L=0.494 INCH, W=0.423 INCH, D=0.020 INCH. MAINTENANCE REPLACED CENTER FITTING LOC BTW FR16 TO FR 20 STR 23 LH SIDE FWD GALLEY AREA I.A.W A319 SRM 51-42-11-80SDR SWAA2025073187674Seat Track · corrodedCORROSION FOUND ON PASSENGER SEAT TRACK AT LBL 45 BS 360+9, 360+14, 360+16, 380 , 400+1, 420+11, & 500A+4. WL 208. TASK TO BE ACCOMPLISHED ON CUSTOMER CARDS TTG8Q013JXQ1 AND TTG8Q013JWFT.SDR ASAA2025070259735Rib · crackedRIGHT HORIZONTAL STAB, UPON REMOVAL OF DOUBLER FOR CRACKED SKIN REPAIR, IT WAS FOUND THAT THE RIB AT HSS 101.9 HAS CRACKS. GROUNDED - YES. REPAIRED R/H HORIZONTAL STAB RIB AT STA 101 IAW B737-800 SRM 55-10-09-2R-5.SDR SWIA2025073000002Beam · crackedFOUND CRACKED BEAM (HOCKEY STICK) AFTER REMOVING PRESSURE FLOOR AT FS 847, RBL27. REMOVED AND INSTALLED NEW BULKHEAD BEAM AT RBL 27 FS 847 IAW DWG SH670-35920 REV M, SRM 51-42-06--001-001-A01 AND SRM 51-42-21-001-001-A01. NO LEAKS NOTED. COMPLIED WITH 51-900-SDR IPXA2025071131139Profile · crackedCRACK AT FR74 HOLE ON PROFILE-Z LH BTW FR72 AND FR75 INSTALLED NEW PROFILE Z LH FOR STRUCTURE BTW FR72 AND FR75 IAW A300-600 SRM 51-40-21.SDR SWAA2025072987675Doubler · crackedDURING OK TO INSTALL RT BS 663 RBL 6-32 LWR DOUBLER; FOUND DOUBLER CRACKED AT THE CORNER. REMOVED AND REPLACED ON FAULT TTG8Q013CQB6.SDR SWAA2025072987754Floorbeam · crackedCRACK ON FLOOR STRUCTURE SUPPORT LOCATED BS 540 AND BTW BL 0 TO RBL 24.75 AT MAIN CABIN. REPLACED BREAK PANEL AND FASTENERS LOCATED BS 540 AND BTW BL 0 TO RBL 24.75 AT MAIN CABIN IAW SRM 51-40-02, SRM 51-10-02 ITEM 9, AND DWG 143A0060 SHEET: 46 REV -.SDR SWAA2025072987671Seat Track · corrodedCORROSION FOUND ON PASSENGER SEAT TRACK AT RBL45 BS380+13 ON CROWN, BS400+10 ON CROWN, BS480+6 ON CROWN, BS500A+14 ON CROWN, BS520 ON WELL WL208. ACCOMPLISHED ON TASK CARDS TTG8Q013KMBX AND TTG8Q013KMB3.SDR SIMA20250702002Seat Track · corrodedGALLEY LH SEAT TRACK CORRODED AT FRAME 16. (MAJOR REPAIR) (LEVEL 2 CORROSION). INSTALLED FABRICATED REPAIR DOUBLER & FILLER ON FWD GALLEY LH SEAT TRACK BEAM AT FR.16 IAW ENVOY ERS-EJ-53MR-5227SDR REXA2025072900766Angle · crackedCRACK ON LEFT & RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD & AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.00). CRACK ON LEFT & RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 6SDR SWAA2025072887736Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45, BS 685+9.5 - 685+12 UPPER SIDE OF CROWN HAS EVIDENCE OF CORROSION. RESOLVED ON TTG8Q013HN6W.SDR IPXA2025072531021Profile · crackedCRACK ON PROFILES-T AT FR80/82 LH Y1580.5/RH -Y1580.5 INSTALLED PROFILES-T AT FR80/82 LH Y1580.5/RH -Y1580.5 IAW SRM 51-40-21SDR JJBA20250728097Support · crackedLH SILL BTW FR 61-65 FOUND CORRODED. LH SILL BTW FR 61-65 BLENDED FOUND OUT OF LIMIT. LH SILL BTW FR 61-65 REMOVED AND REPLACEDSDR JJBA20250728096Cable · out of limitsSTICK PUSHER CABLE CHAFED OUT OF LIMIT. STICK PUSHER ACTUATOR REMOVED. STICK PUSHER ACTUATOR INSTALLED.SDR SWAA2025072487403Stub Frame · crackedFWD GALLEY DOOR CUTOUT; FWD FRAME STA 294.5; UPPER STUB FRAME HAS APROX .4' CRACK AT TOP END OF SEAL DEPRESSOR. REF CARD TTG8Q00TSZYP CONTACT ENGINEERING FOR REPAIR INSTRUCTIONS<[01] REMOVED R1 DOOR UPPER STUB FRAME IAW SRM 51-40-02-G0-0 INSTALLED R1 DOOR STUBSDR SWAA2025072487718Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 500D+6' TO STA 520 LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. REPAIR OF SEAT TRACK COMPLETED IN TTG8Q013HMR6.SDR SWAA2025072487721Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 540+12' LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT IS RESOLVED ON FAULT TTG8Q013HN6W.SDR SWAA2025072487729Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 559+9.25' TO STA 559+11.5' LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT WAS RESOLVED ON FAULT TTG8Q013HN6W.