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 SWIA2025102000811Floor Support · corrodedWHILE PERFORMING REINSPECT OF R/H PRESSURE FLOOR SILL, F.S. 409.00+128 TO F.S. 559.00, FOUND (2EA) PREVIOUS BLEND LOCATIONS THAT ARE CORRODED AROUND NUTPLATES. ONE DAMAGE LOCATION AT F.S. 535.00 APPROX. AND ONE DAMAGE LOCATION AT F.S. 555.00 APPROX. DAMAGE AT SDR VNAA20251016017Skin · damagedIN REFERENCE TO CARD TRFKE00EZBN9': 670-53-00-045-SEC 3 B1-8000FH PERM REPAIR - FUSELAGE SKIN LIGHTNING STRIKE DAMAGE REPAIR AROUND FASTENER COUNTERSINK WITHIN 8000FH, ACCOMPLISH PERMANENT REPAIR OF TEMP REPAIR PER 670-53-00-045 SECTION 3 PARAGRAPH B2. SEE ATSDR VNAA20251016016Access Panel · crackedIN REFERENCE TO TRFKE00EZAVR': REO 690-53-82-173-A-5250FH PERM REPAIR - TEMPORARY DISPOSITION FOR DRESS-BACK OF BENT OVERWING ACCESS PANELS, LHS & RHS (172CL & 172CR) BETWEEN FS 768.75 - FS 801.22 THE SUBJECT REWORKED CONDITION IS STRUCTURALLY ACCEPTABLE FOR 5SDR VNAA202509260019Floorbeam · corrodedAFTER REMOVAL OF FLOOR PANEL SUPPORT ANGLE, CORROSION WAS FOUND ON RH CROSSBEAM AT FS 280.00. CORROSIÓN ON RH CROSSBEAM AT FS 280 ITS OUT OF LIMITS PER CRJ-700 SRM 53-00-01-101-001-A01 AND WAS REPLACED PER CRJ-700 SRM 51-42-06-001-001-A01 SRM 51-42-10-001-0SDR VNAA202509260017Seat Track · corrodedCORROSION ON SEAT RAIL AT RBL9 (02) SEGMENTS: (01) FS679 - FS863. (02) FS863 - FS1005. OF THE PAX CABIN. SEAT RAILS (2EAS) AT RBL9 FS=679 TO FS=1005. OF THE PAX CABIN WERE EVALUATE OUT LIMITS PER CRJ 700 SRM 53-41-49-101-001-A01 AND CRJ 700 SRM 53-51-49-101-0SDR SWAA2025092303058Web · corrodedCORROSION WEB INDICATORS FUEL LOCATED INTERNAL CAVITY LEADING EDGE AT RT WING. PERFORMED PERMANENT REPAIR ON WEB INDICATION OF FUEL SYSTEM PANEL IAW EA 25-157-02404.SDR SWAA2025092303340Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE IN AFT CARGO BAY. REPAIRED AFT CORNER SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, PARAGRAPH 4. B, STEPS 2 AND 4 - 7.SDR AALA202509231643Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER BOLT SLAT TRACK 7 ON SLAT 3 RH WING L=0.084 INCH, W=0.062 INCH AND D=0.003 INCH. MAINTENANCE REPLACED SLAT BOLT IAW AMM 27-84-65-000-001-A AND AMM 27-84-65-400-002-A.SDR SWAA2025091603353Bracket · crackedRIGHT WING T/E PANEL 651FB HAS CRACKED L ANGLE AT FWD EDGE 27' FROM O/B END. REMOVED AND REPLACED RIGHT WING T/E PANEL 651FB BRACKET AT FWD EDGE 27' FROM O/B END IAW SRM 51-10-02-0G-0 PAR. 9; C. AND AIPC 57-50-00-38.SDR SWAA2025091503088Bulkhead Web · crackedCRACKED LOWER L/H COMPOSITE BULKHEAD AT BS 663, LBL 37, WL 165. CRACKED LOWER LT COMPOSITE BULKHEAD AT BS 663, LBL 37, WL 165 WAS REPAIRED IAW SRM 51-70-04-2R-10.SDR SWAA2025091503090Attach Angle · crackedBS 663 VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT RBL 8, WL 167. REPAIRED IAW SRM 57-10-10-2R-5, REPAIR 5.SDR SWAA2025091503084Rib · crackedLEFT HORIZONTAL STAB REMOVABLE L/E PANEL 331A RIB NR 3 IS CRACKED. REMOVED AND REPLACED RIB 3 IAW SRM 51-40-02 & DWG 186A1001.SDR SWAA2025091503085Rib · crackedLEFT HORIZONTAL STAB REMOVABLE L/E 331B RIB NR 4 IS CRACKED. REMOVED AND REPLACED RIB #4; IAW SRM 51-40-02 & DWG 186A1001.SDR AALA202509157112Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD LOCATED FROM BS 767 TO BS 787 AT RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR SWAA2025091203119Attach Angle · crackedB.S. 663 LOWER COMPOSITE BULKHEAD UPPER ATTACH ANGLE IS CRACKED AT L.B.L. 45; W.L. 167.<[01] REMOVED AND INSTALLED NEW UPPER ATTACH ANGLE AT BS 663 L.B.L. 45; W.L. 167 PER SRM 51-40-02-0G-0; DWG 111A1000 REV. B AND DWG 111A700 REV.A.SDR SWAA2025091103388Handle · damagedFED AFT SURROUND SIDEWALL LINING PANEL ASSIST HANDLE ASSY AND YELLOW SAFETY STRAP DAMAGED. REMOVED AND REPLACED ASSIST HANDLE ASSY AND YELLOW SAFETY ON THE FED AFT SURROUND SIDEWALL LINING PANEL IAW IPC 25-21-25-22 ITEM 20;25-66-10-02 ITEM 30;25-21-25-22 ITESDR SWAA2025090903062Intercostal · crackedFED CUTOUT SURROUND STRUCTURE; INTERCOSTAL IS CRACK AT BS 312 S-6L REPAIR PER EA#M-22-153-01244 REV: B.SDR SWAA2025090803067Skin · crackedCRACK FOUND ON LT HORIZONTAL STABILIZER LOWER SKIN AT HSS 203.10, 24 INCHES FROM FWD EDGE, .08 INCH IN LENGTH. REPAIRED IAW EA 25-155-02188 WITH REPETITIVE INSPECTION PROGRAM DEFINED IN EA 25-155-02188.SDR SWAA2025090803345Scuff Plate · crackedAFT CARGO BAY FWD CORNER SCUFF PLATE IS CRACKED. WELDED THE CORNER SCUFF PLATE PER SRM 53-60-15-2R-1 STEP 4.B.(4). REFERRED TO BAC 5975.SDR SWAA2025090803346Scuff Plate · crackedACB AFT CORNERR SCUFF PLATE IS CRACKED. WELDED THE CORNER SCUFF PLATE PER SRM 53-60-15-2R-1 STEP 4.B.(4). REFERRED TO BAC 5975.SDR JJBA20250904006Channel · corrodedCF1, SERVICE DOOR CUTOUT, ENTRANCE CHANNEL FOUND CORRODED. CF1, SERVICE DOOR CUT OUT, ENTRANCE CHANNEL BLENDED OUT OF LIMIT. CF1, SERVICE DOOR CUTOUT, ENTRANCE CHANNEL REMOVED FOR REPLACEMENT. CF1, SERVICE DOOR CUT-OUT, ENTRANCE CHANNEL REPLACED.SDR SCNA20250903354Frame · crackedCRACK ON FRAME STA 312 & S-6L AT PASSENGER CABIN. FRAME STA 312 & S-6L AT PASSENGER CABIN WAS REPAIRED PER SRM 53-10-07-2R-1 REPAIR 1SDR SCNA20250903353Crossbeam · crackedCRACK IN FLOOR TRANSVERSAL BEAM AT STA 294 & RBL 56, W1. FLOOR TRANSVERSAL BEAM AT STA 294 BTW RBL 25 & RBL 56, W1 WAS REPAIRED PER SRM 53-10-51-2R-16 REPAIR 16SDR IPXA2025090214639Web · corrodedEVIDENCE OF CORROSION ON WEB LOWER SECTION STA 1180 TO STA 1240 R/H. INSTALLED WEB LOWER SECTION STA 1180 TO STA 1240 R/H IAW B757-200 SRM 51-40-02. FASTENERS INSTALLED.SDR IPXA2025083014616Tee Angle · corrodedEVIDENCE OF CORROSION ON TEE ANGLE UPPER SECTION STA 1220 RT. INSTALLED TEE ANGLE UPPER BS 1220 RT SIDE UPPER SECTION IAW B757-200 SRM 51-40-02.SDR 2025FA0000596Servo · contaminatedMOMENTARY ENGINE ROUGHNESS/VIBRATION WHILE IN THE PATTERN TURNING FROM CROSSWIND TO DOWNWIND, LOSS OF RPM. ENGINE INDICATIONS OTHERWISE NORMAL. NORMAL RUNUP. LANDED AND DID ANOTHER RUNUP WHICH WAS ALSO NORMAL. FUEL SERVO REPLACED.SDR CALA2025090108317Skin · damagedFWD DOOR 1L - FUSELAGE, SCRIBE LINES, GOUGES & DAMAGED FASTENER HOLES. . PERFORMED INTERIM REPAIR IAW EC/RA 5310-08669SDR CALA2025090108316Failsafe · corrodedFAIL-SAFE STRAP LOWER SURFACE CORROSION BETWEEN BS 1241 & 1263 MAJOR REPAIR AS PER GMM 03-20-20. PERFORMED INTERIM REPAIR AS PER EC/RA: 5360-01995. ALL THE STEPS OF THE EC/RA 5360-01995 HAVE BEEN INSPECTED. THIS REPAIR IS A PERMANENT SOLUTION WITH INSPECTIONSDR 2025FA0000585Fuel Tank · crackedDURING ACFT ANNUAL INSPECTION, WINGS ARE REMOVED AS PART OF 1000 HR ITEMS CHECK. WING FUEL TANKS ARE REMOVED FOR INSPECTION AS PART OF 1000 HR CHECK. EACH WING HAS (3) FUEL TANKS INLINE CONNECTED BY HOSE SECTIONS, FOUND MULTIPLE INBD TANKS LEAKING SMALL AMOUNTSDR JJBA20250827058Gusset · corrodedCENTER FUSELAGE IV, CENTER GUSSET BTW FRAME 59-61 CORRODED OUT OF LIMITS CENTER FUSELAGE IV, CENTER GUSSET BTW FR59-61 REPLACED.SDR JJBA20250827057Gusset · corrodedCENTER FUSELAGE IV, RH GUSSET BTW FRAME 59-61 CORRODED. R/H GUSSET BLENDED OUT OF LIMITS. TH GUSSET BTW FR59-61 REMOVED FOR REPLACEMENT. CENTER FUSELAGE IV, R/H GUSSET BTW FR 59-61 REPLACED.SDR IPXA2025082315088Tee Fitting · corrodedEVIDENCE OF CORROSION ON VERTICA LT-CHORD STA 1220 RT. INSTALLED NEW T-CHORD IN STA 1200 R/H IAW B757-200 SRM 51-40-02-0GSDR AALA202508273563Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO RIGHT HAND TRANSITION PANEL CORRODED HAS LOOSE RIVET BS 727E. INSTALLED NEW RIGHT HAND TRANSITION PANEL ON TASK CARD NUMBER: 08C14053016/001.SDR CALA2025082608119Intercostal · corrodedMAIN E&E COMP LT CORROSION AT INTERCOSTAL BETWEEN BS 294.5-312 STR 23L. COMPLETED INSTALLATION NEW WEB BETWEEN BS 294.5 & 312 S23L IAW SRM 51-40-02-G-0 AND DWG# 141A8131.SDR CALA2025082608118Intercostal · corrodedMAIN E&E COMP LT CORROSION AT INTERCOSTAL BETWEEN BS 344-3" S23L. INSTALLED NEW WEB AT E&E COMP LT BETWEEN BS 330 & 344, S23L IAW SRM 51-40-02-0G-0 AND DWG# 141A8131.SDR SWI2025F01117Flap Track · out of limitsR/H WING FLAP TRACK #1A UPPER FLANGE HAS THICKNESS REDUCTION OF .040" WITH FLAPS EXTENDED. ASSET TC2-7654 CAL DUE 01/15/26 (C-CHECK RO 08/26/2025)REMOVED AND REPLACED R/H WING FLAP TRACK #1A REF EMB 175 AMM 57-54-25. ASSET #TC1-601 CAL DUE 7/17/26.SDR SWI2025F01116Flap Track · out of limitsL/H WING FLAP TRACK #1A I/B UPPER FLANGE HAS THICKNESS REDUCTION OF .030" WITH FLAPS EXTENDED. ASSET TC2-7654 CAL DUE 01/15/26 (C-CHECK RO 08/26/2025)REMOVED AND REPLACED L/H WING FLAP TRACK #1A I/B. REF ERJ175 AMM 57-54-25. TW ID# HG4-50096 CAL DUE 3-20-26.SDR SWIA2025082500011Window · crackedLH PILOTS SIDE WINDSHIELD CRACKED DURING APU PRESSURIZATION RUNS (C-CHECK RO 8/21/2025) INSTALLED NEW LH SIDE WINDOW (PN:NP139322-13 SN: 25170H8031) REF CRJ900 AMM 56-12-01-400-801-A01 (OPS TEST AND LEAK TEST GOOD AT THIS TIME)SDR AALA202508257886Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EXIT DOOR AFT UPPER STOP PAD ROTATS. REMOVED AND REPLACED AFT UPPER STOP PAD, PER AMM 52-22-01. PERFORMED SATISFACTORY ADJUSTMENT CHECKAND SYSTEM TEST, PER B737/NG AMM 52-22-00 ALL CHECKS GOOD.SDR ASAA2025081160263Transition Panel · corrodedAFT CARGO LT TRANSITION PANEL HAS CORROSION BS 727 TO 787. GROUNDED - YES. REMOVED DAMAGE TRANSITION PANEL FOUND TO BE OUT LIMITS. REMOVED AND REPLACED TRANSITION PANEL IAW SRM 53-00-53-2R-5 W= 2 O= 0.3040 R= 0 L= 2 D= 0.040.SDR SWAA2025082103108Doubler · crackedEGPR DOOR CUT OUT LOWER DOUBLER IS CRACKED. ACCOMPLISHED REPAIR IAW SRM 53-10-15-2R-4, PARAGRAPH E, FIGURE 204, AND EA 25-153-02159-WIP 2.SDR AALA202508205326Pad · wornAIRCRAFT IN BASE MAINTENANCE: OVERWING EXIT DOOR ARM PAD ARE WORN OUT 4EA. REMOVED AND REPLACED OVERWING EXIT DOOR ARM PAD. PER B737NG AMM 52-22-51.SDR COEA2025081904734Support · crackedCAPTAIN SEAT L/H BOTTOM SUPPORT CRACKED. REPLACED WITH NEW SEAT REF. C408 MM 25-10-05.SDR COEA2025081903708Pan · crackedCAPTAIN SEAT SUPPORT PAN CRACKED. MAINTENANCE REPLACED THE CREW SEAT IAW 408 MM 25-10-05.SDR SWIA2025081800011Skin · corrodedCORROSION ON THE EXTERIOR BELLY SKIN BETWEEN FS 559.00+80 AND FS 559.00+112 AND STR 26L - 26R. (C-CHECK RO 08/16/2025)COMPLIED WITH REO 601R-53-51-716 DATED: 2025-08-14 PERMANENT DISPOSITION FOR BLENDED CORROSION DAMAGE ON FUSELAGE SKIN PANEL BETWEEN FS559.SDR HNAA2025081800574Light · inoperativeEMERGENCY LIGHTING FLOOR STRIP AT SEATS 34-5A NOT ILLUMINATING. R & R FLOOR PROXIMITY LIGHT IAW AMM 33-50-12 ON STRIP FLOOR PROXIMITY 1013194 NSN PN OFF STRIP FLOOR PROXIMITY 1013194 NSNSDR DXTA2025081404571Acm · failedDURING DESCENT AROUND 10,000' WE SMELLED AN ODOR SIMILAR TO OZONE OR SLIGHT ELECTRICAL IN THE COCKPIT AND CABIN. THE SMELL CONTINUED ALL THE WAY UNTIL LANDING. AFTER TAXI IN THE SMELL DISSIPATED. REMOVED FAILED LH COOLING TURBINE AND REPLACED WITH REPAIREDSDR CALA2025081807879Magnet · out of adjustAFTER ARMING DOORS FOR DEPARTURE, FA WORK AND 1L ENTRY LIGHTS WOULD NO LONGER WORK. DR 1L ENTRY LIGHT AND WORK LIGHT EXTINGUISHES WHEN DR 1L IN ARMED POSITION. HAS HISTORY. REQUESTING MEL 3321B. SUSPECT RELAY K10257. REF SSM. 33-22-01-104 VERIFIED 75% OF NIGSDR AALA202508189162Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT VACUUM WASTE TANK ENCLOSURE VERTICAL SUPPORT BRACKET LOCATED AT BS 867, LBL 20. REPLACED BRACKET PER AARD 51-00-05-1.SDR AALA202508164942Window · scratchedAIRCRAFT IN BASE MAINTENANCE: CABIN LEFT HAND FORWARD OVERWING EXIT DOOR OUTER AND INNER WINDOW PANES SCRATCHED. REMOVED AND REPLACED LEFT HAND FORWARD OVERWING EXIT DOOR WINDOW. PER B737-NG AMM 56-22-00.