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 IPXA2026021042028Skin · crackedMAJOR REPAIR, LT WING, CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK INDICATION NOTED AT RIB 26.SDR VNAA20260303004Seat Track · corrodedCORROSION ON THE RT SIDE SEAT TRACK, BS 669.40 - 720.85, & BS 744.15 - 761.85 IN THE PAX CABIN. THE SEAT TRACK EVALUATED OUT OF LIMITS IAW 53-41-51-101-001-A02, AND WERE REPLACED IAW AMM 53-00-49, CONFIG. A12.SDR VNAA20260303003Seat Track · corrodedCORRODED LT SIDE SEAT TRACK, BS 744.15 - 761.85, AND BS 785.15 - 847+16 IN THE PAX CABIN. THE SEAT TRACK WAS EVALUATED OUT OF LIMITS IAW SRM 53-41-51-101-001-A02, AND WAS REPLACED IAW AMM 53-00-49, CONFIG. A12.SDR AALA202602277222Actuator · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN LANDING GEAR WHEEL WELL ALTERNATE EXTENSION MECHANISM ROD ENDS PRESENT CORROSION. REMOVED AND REPLACED LEFT HAND MLG WHEEL ALTERNATE EXTENSION MECHANISM ACTUATOR ROD ASSEMBLY AND CONDUCTED SATISFACTORY LANDING GEAR SDR IPXA2026020630367Cargo Track · crackedMAJOR REPAIR FWD CARGO COMPARTMENT SEAT TRACK CRACK AT STA 968 RBL45. (REPAIR) 1. ACCOMPLISH THE REPAIR I.A.W SRM 53-00-52-2R-10 REV. 64 AND EGAT WORK SHEET NO: 60024 2. REFER TO DAMAGE REPORT FOR THE ORIGINAL MATERIAL & THICKNESS, REPAIR MATERIAL & THICKNESSSDR IPXA2026022330508Support Fitting · cracked***MAJOR REPAIR*** FAULT - FOUND #6 SPOILER ACTUATOR SUPPORT FITTING L/H LOWER CRACK. (REPAIR) CUT OUT THE DAMAGED AREA AS SHOWN IN FIGURE 202 INSTALL THE REPAIR PARTS WITH BMS 5-95 SEALANT BETWEEN THE MATING SURFACES. .ACCOMPLISHED REPAIR I.A.W EO-96614-RESDR AALA202602262052Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD GALLEY FLOOR STRUCTURE WEB AT FR 16 AND S23L. REPLACED WEB PER SRM 51-42-11-801.SDR 2026FA0000138Retainer · brokenON 1/16/26 AT APPROX 2030Z 2NM NE OF THE LAKE MURRAY DAM, ON A FLT FROM KCUB - KEOE AT 2000' MSL, ENGINE BEGAN EXPERIENCING SEVERE VIBRATION & RPM LOSS. ENG BEGAN SPUTTERING & SHUT OFF. MIXTURE WAS FULLY ENRICHED & THROTTLE MOVED TO THE FULL POSITION, ENG THESDR AALA202602226542Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM +Y1292 LOC. AT LEVEL FR16 AT FWD GALLEY AREA MEASURES ARE: L=1.402 IN. W=0.911 IN. D=0.020 IN. MAINTENANCE REPLACED FLOOR BEAM Y1292 LOCATED BTW FR 12 TO FR 24 FWD GALLEY AREA IAW A319 SRM 51-42-11-801 AND DRSDR AALA202602220192Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM +Y765 AT LEVEL FR16 AT FWD GALLEY AREA. THE MEASUREMENTS OF CORROSION ARE L=1.108 IN. W=0.871 IN. D=0.051 IN. MAINTENANCE REPLACED FLOOR BEAM Y765 LOCATED BTW FR 12 TO FR 24 FWD GALLEY AREA IAW A319 SRM 51-42-SDR AALA202602207262Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202602198302Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR SUPPORT HAS CORROSION ON UPPER SURFACE AT BS 950 AND LBL 26, PER CPCP 53-380-00. REMOVED AND REPLACED MAIN CABIN FLOOR SUPPORT. PER B737-NGSRM 51-40-02.SDR SWAA2026021862168Floorbeam · corrodedCORRODED FLOORBEAM, BS 986.5, LBL 44, WL 208.1. PERFORMED A REPAIR ON THE FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6.SDR SWAA2026021862169Floorbeam · corrodedCORRODED FLOORBEAM BS 986.5, RBL 44, WL 208.1. PERFORMED A REPAIR ON THE FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6.SDR SWAA2026021862072Rib · crackedCRACK LEADING EDGE RIB LOCATED LE HSS 105.26, LT HORIZONTAL STAB. REPLACED RIB IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 186A1001, SHEET 19, REV -.SDR SWAA2026021862073Rib · crackedCRACKED ACCESS PANEL 331B RIB LOCATED LE HSS 114.55 AT LT HORIZONTAL STAB. REPLACED THE RIB IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 186A1001, SHEET 19, REV -.SDR ASAA2026011664388Floorbeam · corrodedAFT WET AREA FLOOR BEAM STA 986 LBL 50 TO RBL 50 CORRODED. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REPAIRED FLOOR BEAM IAW B737-800 SRM 53-70-51-2R-0W: 1" O: .150 R: .073 L: 1.5" D: .077.SDR SWAA2026021761897Scuff Plate · crackedCRACK ON GALLEY DOOR SCUFF PLATE AT FWD GALLEY AREA. REPAIRED GALLEY DOOR SCUFF PLATE AT FWD GALLEY AREA IAW SRM 53-10-15-2R-2, REPAIR 2, PARAGRAPH 4.B, AND BAC 5975.SDR AALA202602166738Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING BTW FR16 AND FR20 AT LEVEL STR23R AT FWD GALLEY AREA MEASURES OF CORROSION ARE: L=2.220 IN, W=1.200 IN, D=0.020 IN. MAINTENANCE REPLACED CENTER FITTING LOCATED BTW FR 16 TO FR 20 AT LEVEL STRG 23 R,FWD GASDR AALA202602161536Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING BTW FR16 AND FR20 AT LEVEL STR23L AT FWD GALLEY AREA MEASURES OF CORRODED AREA ARE: L=2.661 INCH W=1.126 INCH D=0.005 INCH. MAINTENANCE REPLACED CENTER FITTING LOCATED BTW FR 16 AND FR 20 AT LEVEL STRG 2SDR AALA202602160804Dummy Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION RAIL DUMMY Y503.2 AT LEVEL FR16 AT FWD GALLEY AREA. THE MEASURE OF CORROSION LOC ON RAIL DUMMY Y503.2. P1 ARE: L=0.608 IN, W=0.203 IN, D= 0.036 IN, P2: L=0.665 IN, W=0.208 IN, D=0.002 IN. MAINTENANCE REPLACED RAIL DUMMY SDR HNAA2026021600124Floor Support · corrodedLAV CENTER FLOOR GUSSET CORRODED AROUND NUT PLATE HOLES. REMOVED CORRODED AND INSTALLED NEW LAV CENTER FLOOR GUSSET IAW EMB-145 SRM 51-40-02.SDR HNAA2026021600123Floor Support · corrodedLAV RT FLOOR GUSSET CORRODED AROUND WATER NIPPLES REMOVED AND INSTALLED NEW SERVICEABLE LAV RT FLOOR GUSSET IAW SRM 51-40-02.SDR HNAA2026021600122Pin · corrodedCORROSION ON RH WING OTBD LOWER FLAP SHROUD CENTER SPRING ATTACHMENT PIN. REMOVED AND REPLACED RH WING OTBD LOWER FLAP SHROUD CENTER SPRING ATTACHMENT PIN IAW EMB 145 AMM 57-56-01SDR ASAA2026011664292Web · corrodedAFT CARGO SCUFF PLATE SILL WEB HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED AFT CARGO SILL WEB IAW B737-700 SRM 51-40-02-0G-0, REMOVED DAMAGE FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-60-15-1A-1 W= 1" O= 0.045" R= 0.036" L= 1" D= 0.009".SDR SWAA2026021262079Support · corrodedCORROSION SUPPORT ZEE, BS 727 - 767, RBL 21, WL 156 IN THE AFT CARGO BAY. MANUFACTURED & DRILLED A NEW SUPPORT ZEE IAW SRM 51-40-05, AND DWG 146A7502, SHEET 26, REV-. REPLACED THE SUPPORT ZEE & FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, DWG 146A7500,SDR SWAA2026021262175Floor Support · corrodedCORRODED FLOOR SUPPORT, BS 706 - 716, LBL 65, WL 202. REPLACED FLOOR SUPPORT IAW SRM 51-40-02, SRM 51-10-02, DWG 144A7700, SHEET 144, REV B, & DWG 144A7730, SHEET 7, REV -.SDR SWAA2026021262177Floor Support · corrodedCORRODED FLOOR SUPPORT BTWN BS 706 - 716, RBL 65, WL 202. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02, SRM 51-10-02, DWG 144A7700, SHEET 144, REV B, & DWG 144A7730, SHEET 7, REV -.SDR SWAA2026021262078Support · corrodedCORRODED SUPPORT ZEE, BS 727 - 847, LBL 21, WL 156 IN THE AFT CARGO BAY. REPLACED THE SUPPORT ZEE IAW SRM 51-10-02, SRM 51-40-02, DWG 146A7502, SHEET 27, REV -, & DWG 145A7500, SHEET 85, REV A.SDR SWAA2026021262178Door · corrodedCORRODED WASTE SERVICE DOOR 145AL. PERFORMED A PERMANENT REPAIR ON THE WASTE SERVICE DOOR IAW SRM 52-40-01-2R-8, REPAIR 8.SDR SWAA2026021262082Strap · corrodedCORRODED STRAP, BS 887, RBL 10, WL 156 IN THE AFT CARGO BAY. REPLACED THE STRAP IAW SRM 51-10-02, SRM 51-40-02, AND DWG 14YA7500, SHEET 85, REV A.SDR ASAA2026011664273Web · corrodedAFT WET AREA R/H WEB SUPPORT STA 990 RBL 40 TO 45 CORRODED. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED WEB SUPPORT IAW B737-800 SRM 51-40-02-0G-0 & 51-40-05-0G-0W: 1" O: .050 R: .035 L: 3" D: .015.SDR ASAA2026011664272Floorbeam · corrodedAFT WET AREA INTERCOSTAL STA 950 RBL 30 TO RBL 48 CORRODED. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED INTERCOSTAL IAW B737-800 SRM 51-40-02-0G-0 & 51-40-05-0G-0W: 1 O: .074" R: .062 L: 1 D: .012.SDR ASAA2026011664250Floor Support · corrodedAFT WET AREA MACHINED FLOOR SUPPORT BS 967 - 947, RBL 30 CORRODED. GROUNDED - YES. REMOVED CORROSION, & FOUND TO BE OUT OF LIMITS, R & R THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0, & 51-40-05-0G-0.SDR ASAA2026011664249Sill Drain · corrodedAFT WET AREA LEFT SILL DRAIN BS 986 - 947 CORRODED. GROUNDED - YES. REMOVED DAMAGE, & FOUND TO BE OUT LIMITS IAW SRM 53-70-15-01-1. R & R SILL DRAIN IAW SRM 51-40-02-0G-0, AND SRM 51-40-05-0G-0.SDR ASAA2026011664248Floor Support · corrodedAFT WET AREA MACHINED FLOOR SUPPORT, BS 967 - 947, RBL 48 CORRODED. GROUNDED - YES. REMOVED CORROSION, & FOUND TO BE OUT OF LIMITS. R & R THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0, & 51-40-05-0G-0.SDR ASAA2026011664247Floor Support · corrodedAFT WET AREA MACHINED FLOOR SUPPORT BS 947 - 967, LBL 30 CORRODED. GROUNDED - YES. REMOVED CORROSION, & FOUND TO BE OUT OF LIMITS. R & R THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0, & 51-40-05-0G-0.SDR ASAA2026011664246Sill Drain · corrodedAFT WET AREA RT SILL DRAIN, BS 947 - 986 CORRODED. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS IAW SRM 53-70-15-1A-1, R & R THE SILL IAW SRM 51-40-02-0G-0.SDR ASAA2026011664244Web · corrodedAFT WET AREA RT WEB SUPPORT BS 986 - 1016, RBL 40 CORRODED. GROUNDED - YES. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS, R & R WEB SUPPORT IAW SRM 51-40-02-0G-0, & 51-40-05-0G-0.SDR ASAA2026011664173Transition Panel · corrodedAFT CARGO LT TRANSITION PANEL BS 727D+4 - 847 CORRODED. GROUNDED - YES. REMOVED AND REPAIRED THE LT TRANSITION PANEL IAW SRM 51-40-02-0G-0.SDR SWAA2026020962230Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK ON TOP OF CROWN BS 480 - 484, LBL 25, WL 208. THE SEAT TRACK REPLACED ON CC TTG8Q019XDP9.SDR SWAA2026020962232Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK ON TOP OF CROWN BS 500C+8, LBL 25, WL 208. THE SEAT TRACK BS 480 - 520 REPLACED ON CC TTG8Q019XDP9.SDR AALA202602063560Spigot · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND PYLON SPIGOT FITTING RECEPTACLE BETWEEN PYLON RIBS 4 AND 5. REPLACED SPIGOT FITTING PER SRM 54-51-12-300-002.SDR AALA202602064323Spigot · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND PYLON SPIGOT FITTING RECEPTACLE BETWEEN PYLON RIBS 4 AND 5. REPLACED SPIGOT FITTING PER SRM 54-51-12-300-002.SDR SWAA2026020662223Crossbeam · crackedCRACKED CROSSBEAM, BS 540 BL 0 - RBL 25, WL 207. REMOVED AND REPLACED THE CROSSBEAM IAW SRM 51-40-02-0G.SDR SWAA2026020662234Scuff Plate · crackedFWD CARGO BAY, FWD DOOR SURROUND SCUFFPLATE IS CRACKED. REPAIRED FWD DOOR SURROUND SCUFFPLATE IAW AMM SRM 53-30-15-2R-1, STEP 4.B.(2), SOPM 20-30-02, SRM 51-20-01-0G-0.SDR SWAA2026020662233Web · corrodedCORROSION ON AFT CARGO BAY LOWER SILL SUB THRESHOLD WEB BTWN BS 807 - 847, WL 156. RESOLVED ON CUSTOMER CARD TTG8Q019Y4AA.SDR ASAA2026011664159Transition Panel · corrodedAFT CARGO R/H TRANSITION AT STA 727+4 TO 767 HAS CORROSION. GROUNDED - YES. REMOVED AND REPAIRED AFT CARGO R/H TRANSITION AT STA 727+4 TO 767, IAW B737-700 SRM 51-40-02-06-0. W= 1.25 O= .040 R= .030 L= 3.75 D= .010.SDR ASAA2026011664158Transition Panel · corrodedAFT CARGO LT TRANSITION AT BS 727+4 TO 727D+2 HAS CORROSION. GROUNDED - YES. REMOVED AND REPAIRED AFT CARGO L/H TRANSITION AT STA 727+4 TO 727D+2 IAW B737-700 SRM 51-40-02-0G-0. W= 2" O= 0.040" R= 0.031" D= 0.009" L= 2".SDR AALA202602042478Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 951, RBL 34. REPLACED FLOOR SUPPORT PER AARD 51-00- 05-1.