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 JJBA20250630023Power Supply · no testEMERGENCY LIGHTS THROUGHOUT CABIN INOPERATIVE. REMOVED AND REPLACED FWD ELPU #1 (PNL 227 BLC). VERIFIED A FEW LIGHTS DID COME ON. REMOVED AND REPLACED AFT OUTBOARD AND AFT INBOARD OPS CHECK SAT.SDR FDEA202506281076Support Beam · corrodedCARGO COMPARTMENT SUPPORT BEAM LOWER CHORD BS 1360 BETWEEN RBL 24.75 AND RBL 45.50 NUTS PLATE WITH CORROSION.SDR FDEA202506281075Shear Tie · corrodedAFT CARGO MCOMPARTMENT SHEAR TIE CORRODED AT BS 1480 BETWEEN STRINGER 28R - STR29R.SDR FDEA202506281074Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 1500 BETWEEN STR 28R - STR 29R.SDR FDEA202506281073Gust Lock · stuckLEFT MAIN AIRCRAFT DOOR GUST LOCK STUCK. CANNOT CLOSE THE DOOR. REPLACED L1 DOOR HOLD OPEN LOCK PER ABOVE REF. OPS CHECKS GOOD.SDR FDEA202506281072Spar · crackedNDT INSP - RT WING FUEL TANK RIB9 REAR SPAR LOWER BOOM OUTBD HOLE W FOUND CRACK SIGNAL. COMPLIED WITH EA 6-5710-T0383952 P1 TO REPAIR RH WING REAR SPAR BOTTOM FLANGE HOLE W/558 BETWEEN RIB9 AND 10 CRACKS. THIS EA DEVIATES FROM EO 6-5710-7-5001.THIS IS A CATSDR FDEA202506281071Fitting · damagedCOMPLY WITH EO 6-5230-E0378588 B P5. COMPLIED WITH EO 6-5230-E0378588 B P5. TITLE: DOORS - CARGO DOOR/HYD SYS - DETAILED VISUAL INSPECTION OF THE MAIN DECK CARGO DOOR (MDCD) ACTUATOR BEARING FITTINGS AT FRAME 23 AND 24 - AOT A52W016-24. REPLACED THE MAINSDR ABXA20250628138Skin · corroded"DURING THE ACCOMPLISHMENT OF APU REPLACEMENT AT CVG/FEAM, CORROSION WAS DISCOVERED IN THE APU COMPARTMENT. ONE OF THE AFFECTED COMPONENTS IS SKIN PANEL PIN I 48T3280-2. THE CORROSION ON THIS ITEM WENT OUT OF I IM ITS. THE SKIN PANEL IS A BONDED UNIT MADE OF 2SDR DALA2025063004822Brake · damagedSHIP 3404 - TIRE - DUE TO #8 TIRE DEFLATED AND DAMAGED AFTER LANDING. REPLACED #8 BRAKE ASSEMBLY, DAMAGED BRAKE LINE, BRAKE LINE HOSE GUIDES, AND MAIN TIRES #7 AND #8. PLACED A/C BACK IN SERVICE. (7506661)SDR CALA2025063006074Skin · crackedCRACK FOUND AT LOWER SKIN OF RIGHT HORIZONTAL STABILIZER AT STAB STA 92.70, 12" FROM REAR SPAR, I/B ROW. CRACK LENGTH : 0.468". REPAIRED CRACK FOUND AT LOWER SKIN OF RIGHT HORIZONTAL STABILIZER AT STAB STA 92.70, 12" FROM REAR SPAR, I/B ROW. IN REF SRM 55-10-SDR CALA2025063006073Access Door · corroded(SDR) EXFOLIATION CORROSION ON PANEL 121AL (LAVATORY SERVICE) LW R NEAR LATCHES. REMOVED AND REPLACED PANEL ASSY DOOR 121AL P/N 143N3411U126 ON L AVATORY SERVICE IAW B757-200 SRM 51-40-02-06-0 AND DWG 143N3411 CLEANED AREA PAN IAW SOPM 20-30-03 AND RESTORED SDR CALA2025063006072Connector · disconnectedEMERGENCY EXIT ROW LIGHT AT SEAT 38C INOP REF AMM 33-51-18/401 CONFIG 00, REPLACED SEAT 38C EMERGENCY PATH LIGHT MONUMENT, NO HELP. REF WDM 33-51-08 PAGE 278A, FOUND 7260VC CONNECTOR DISCONNECTED. RECONNECTED CONNECTOR AND ACP OPS CHECK REF AMM TASK 33-51-00-7SDR CALA2025063006035Unknown · odorHYD FLUID SMELL ON FLT DECK DESCNDING THROUGH 10500 FEET FLIGHT CREW FILLED OUT SMOKE / FUMES IN THE COCKPIT/ CABIN FORM. CHECKING FOR HYDRAULIC LEAKS, SMELLED HYDRAULIC FUMES WITH BOTH PACKS RUNNING, SMALL WET AREA UNDER KEEL BEAM IN THE BELLY BEACON AND INSSDR DALA2025062904821Shaft · shearedDECLARED EMERGENCY DUE TO HYDRAULIC G OVERHEAT WITH NO RESTORATION OF HYD G SYSTEM. REQUIRED USE OF L/G GRAVITY GEAR EXTN HANDCRANK. VERIFIED FREE FALL EXTENSION. REFERENCE ODI EVENT LOG 1050057. GREEN EDP SHAFT FOUND SHEARED. R/R SAME AND FILTERS. LK/OPS CK SDR 2025FA0000432Beam · corrodedLONGITUDINAL BEAM LEVEL 2 CORROSION AT FR 75-76 (-Y381).SDR R61A2025062800273Floor Panel · corrodedDURING HEAVY CHECK CFIII FR84 RBL44 FOUND CORRODED FLOOR SUPPORT PANEL. PANEL WAS REPLACED IAW SRM 51-41-02SDR R61A2025062800272Crossbeam · corrodedDURING HEAVY CHECK CF III FR84 RBL30 FOUND CORRODED CROSSBEAM UPPER FLANGE. FLANGE WAS REPAIRED IAW ETD 2025-170-922676SDR R61A2025062800271Bracket · corrodedDURING HEAVY CHECK FWD. CARGO DOOR LOWER CUT OUT FOUND CORRODED TRIM BRACKET. REPLACED BRACKET IAW SRM 51-41-01SDR R61A2025062800270Shear Tie · corrodedDURING HEAVY CHECK CF III FR 86 STR27L-28L FOUND CORRODED SHEAR CLIP. REPLACED SHEAR CLIP IAW SRM 51-41-02SDR R61A2025062800269Beam · corrodedDURING HEAVY CHECK AFT PASSENGER DOOR L2 CUTOUT LOWER BEAM CORRODED. LOWER BEAM WAS REPLACED IAW SRM 51-40-08SDR R61A2025062800268Beam · corrodedDURING HEAVY CHECK AFT SERVICE DOOR CUTOUT LOWER BEAM FOUND CORRODED. LOWER BEAM REPLACED IAW SRM 51-40-08SDR R61A2025062800267Web · corrodedDURING HEAVY CHECK FWD. WET AREA RH WEB FOUND CORRODED. REPLACED WEB IAW SRM 51-40-08SDR R61A2025062800266Floor Support · corrodedDURING HEAVY CHECK FWD WET AREA LH SIDE FR16 AND IBL44 SUPPORT FLOOR FOUND CORRODED. REPLACED SUPPORT IAW SRM 51-43-03SDR R61A2025062800265Access Door · corrodedDURING HEAVY CHECK WASTE ACCESS DOOR FOUND CORRODED. REPLACED DOOR IAW AMM 20-10-01-910-801-ASDR 2025F00148Skin · bentRIGHT HORIZONTAL STABILIZER UPPER SKIN TRAILING EDGE DAMAGE BETWEEN BL: 96.26 - BL:102.25. REPAIRED I/A/W/ MHI RJ REO 601R-55-11-793 REV. -- DATED: 2025-06-19.SDR X2ZR403508Drive Shaft · wornFUEL CONTROL UNIT P/N 897801-2 S/N: 2481460, WAS RECEIVED FOR REPORTED LOW FUEL FLOW DURING ENGINE OPERATION. THE FUEL CONTROL UNIT WAS INSPECTED IN ACCORDANCE WITH COMPONENT MAINTENANCE MANUAL WG60183. DISASSEMBLY REVEALED SEVERELY WORN STUB SHAFT P/N 3499-09SDR X2ZR2026072903548Drive Shaft · wornFUEL CONTROL UNIT WAS RECEIVED FOR REPORTED LOW FUEL FLOW DURING ENGINE OPERATION. THE FUEL CONTROL UNIT WAS INSPECTED IN ACCORDANCE WITH COMPONENT MAINTENANCE MANUAL WG60183. DISASSEMBLY REVEALED SEVERELY WORN STUB SHAFT. THE SEVERITY OF THE STUB SHAFT WEAR SDR COEA2025110410919Strip · corrodedWO 264878 NR 600027 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: R/H WING AFT SPAR UPPER STRIP SLAT RIB 0-4 UPPER AND LOWER SURFACE HAS LEVEL 2 CORROSION. CORRECTIVE ACTION: REPAIRED PER SRAS S571R0077...01615 ISSUE D, DATED 10/7/2025.SDR SWIA20251002627Skin · crackedTRANSFER FROM EAML 1639970 : TRANSFERRED FROM CAMP 30382930. REFERENCE CP 30339577 "DURING REQUESTED EDDY CURRENT OF THE LH WING PLANK (SEE CP 30339238-1), FOUND CRACK INDICATION IN FASTENER HOLE FORWARD OF THE LH MLG TEMINATING AFT IN THE MIDDLE LAYER.THIS NESDR 3EJA2025091801925Switch · out of adjustSTAB MIS COMPARE AT AROUND 215-230KTS. RE-ADJUSTED CONTROL SWITCHSDR JJBA20250806001Gusset · corrodedMIDDLE GUSSET BTW FR 18-23 FOUND CORRODED. AT CF1 MIDDLE GUSSET BTW FR 18-23 GUSSET FOUND CORRODED OUT OF LIMIT. GUSSET REMOVED. MIDDLE GUSSET BTW FR 18-23 REPLACED.SDR ASAA2025062759739Rib · crackedLEFT HORIZ STAB, APPROX STAB HSS 101.5, RIB #5 APPEARS CRACKED IN RADIUS AND CRACK EMINATING FROM FASTER HOLE. GROUNDED - YES. REPAIRED LT HORZ STAB AT HSS 101 RIB #5 IAW B737-800 SRM 55-10-09-2R-4.SDR SIMA20250627004Floorbeam · corrodedSSI 53-23-005 RH FLOOR CROSS BEAM IS CORRODED AT FR 84 (MAJOR REPAIR) (LEVEL 2 CORROSION). ACCOMPLISHED A PERMANENT REINFORCEMENT REPAIR ON RH FLOOR CROSS BEAM AT FR84 IAW ERS-EJ-53MR-5236SDR SWAA2025072986189Stiffener · crackedCRACKED LOWER SIDE STIFFENER 3 AT INSPAR RIB 3 (STAB STA 111.10) - L/H HORIZONTAL STABILIZER. REPAIRED LOWER SIDE OF STIFFENER #3 AT INSPAR RIB #3(STAB STA 111.10) L/H HORIZONTAL STABILIZER IAW SRM 55-10-09-2R-4.SDR SWAA2025072993051Flap Track · wornRIGHT WING I/B AFT FLAP O/B TRACK WORN ON LOWER FLANGE. REMOVED AND RE-INSTALLED RIGHT WING I/B AFT FLAP TO REPLACE WORN O/B TRACK IAW AMM 27-51-12-000-801; AMM 27-51-16-400-801 AND AMM 27-51-12-400-801.SDR SWAA2025072986191Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241VF UPPER SKIN HAS AREAS OF DELAMINATION. REPLACED DAMAGED 241VF FLOOR PANEL WITH A NEW FLOOR PANEL IAW SRM 51-40-02-0G-0 PARA 9 AND AIPC 53-21-00-22 ITEM #161.SDR SWAA2025072386269Bracket · crackedCRACK TRAILING EDGE BRACKET LOCATED DEFLECTION RIB AREA ORSS 261 PLUS 7 INCHES AT LT WING. REPLACED TRAILING EDGE BRACKET LOCATED DEFLECTION RIB AREA ORSS 261 PLUS 7 INCHES AT LT WING IAW SRM 51-10-02 ITEM 9, SRM 51-40-02 AND DWG 115A2930; SHEET 8; REV - . MSDR SWAA2025071686107Bracket · crackedG1 BRACKET ASSY IS CRACKED.SDR SIMA20250627003Floorbeam · corrodedSSI 53-23-005 ? RH FLOOR SILL AT FR 84 TO CROSS BEAM IS CORRODED (LEVEL 2 CORROSION) RAR RH FLOOR SILL AT FR84 TO CROSS BEAM IAW ERJ 170 SRM 51-40-08SDR SWAA2025071586199Web · corrodedCORROSION ON UPPER WEB LOCATED BTW BS460 TO BS480 RBL70 WL197 AT FWD CARGO COMPARTMENT. REPLACED UPPER SILL WEB LOCATED BTW BS440 TO BS494 AT LEVEL STR18R RBL70 WL197 AT FWD CARGO COMPARTMENT I.A.W B737-700 SRM 41-40-02 AND DWG 143A8111 SHEET 12 REV-A. 143A00SDR AALA202507151920Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: NOSE LANDING GEAR LEFT HAND AFT DOOR AFT HINGE FITTING HAS EXCESSIVE PLAY. REPLACED HINGE FITTING PER CMM 52-82-32.SDR AALA202507159185Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: NOSE LANDING GEAR RIGHT HAND AFT DOOR AFT HINGE FITTING HAS EXCESSIVE PLAY. REPLACED HINGE FITTING PER CMM 52-82-32.SDR AALA202507156848Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: NOSE LANDING GEAR LEFT HAND AFT DOOR FORWARD HINGE FITTING HAS EXCESSIVE PLAY. REPLACED HINGE FITTING PER CMM 52-82-32.SDR AALA202507154490Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: NOSE LANDING GEAR RIGHT HAND AFT DOOR FORWARD HINGE FITTING HAS EXCESSIVE PLAY. REPLACED HINGE FITTING PER CMM 52-82-32.SDR REXA2025071500737Bracket · corrodedINITIAL INSPECTION': CORROSION ON HYDRAULIC LINES SUPPORT PLATES 3EA (IN BK, LG EXT, LG RET), TWO LOCATED ON 45RBL/45LBL AND THE OTHER LOCATED ON 35LBL AT RH/LH WHEEL WELL AREA CORROSION ON SUPPORT PLATE LBL35 WAS REMOVED AND EVALUATED WITHIN LIMITS, PER CRJSDR REXA2025071500730Bracket · corrodedINITIAL INSPECTION': CORROSION ON HYDRAULIC LINES SUPPORT PLATES 3EA (IN BK, LG EXT, LG RET), TWO LOCATED ON 45RBL/45LBL AND THE OTHER LOCATED ON 35LBL AT RH/LH WHEEL WELL AREA CORROSION ON SUPPORT PLATE LBL35 WAS REMOVED AND EVALUATED WITHIN LIMITS, PER CRJSDR JJBA20250715049Shear Tie · crackedRH FR 71 BTW STR 6R-10R, SHEAR CLIP FOUND CRACKED. RH FR 71 BTW STR 6R-10R, SHEAR CLIP REMOVED AND INSTALLEDSDR AALA202507144032Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.9, 17 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR SWAA2025071186088Panel · delaminated#1 ENGINE PANEL 434AR HAS IMPACT DAMAGE AND IS DELAMINATED AT THE UPPER AFT CORNER. REPAIRED IAW SRM 51-70-05-2R-10 REPAIR 10; SEALED REPAIR IAW SRM 51-70-08-0G-0. RESTORED FINISH IAW AMM 51-21-81.SDR JJBA20250711025Floorbeam · corrodedAT FRAME 19 MIDDLE FLOOR SUPPORT CAP IS CORRODED. REMOVED CORROSION AT FRAME 19 MIDDLE FLOOR SUPPORT CAP. REMOVED AND LOCATED AND DRILLED AND INSTALLED NEW PART