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 UIEA2025093001247Door Frame · crackedCRACK (1 EA) IS DETECTED AT L1 FWD ENTRY DOOR AFT LWR CORNER DURING OPEN HOLE HFEC INSPECTION IAW EO 6753A937(<P>REPAIRED WITH 2 EA OF FILLER AND 3 EA OF DOUBLER AS PER SRM 53-10-01-2R-1 REPAIR 1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025093001248Fitting · crackedFUSELAGE SECTION 48 BODY STATION 1809.5 BULK HEAD LH TENSTION FITTING CRACK(<P>REAMED FASTENER HOLE TO A DIAMETER OF 0.3120" AS PER SRM 51-40-05 & SP1-TLS-25-0031-038. PERFORMED OPEN HOLE HFEC INSPECTION PER NDTM 51-00-16 PART 6, RESULT NORMAL. R/R FASTENER PESDR UIEA2025093001249Skin · damagedREQUIRED TO PERFORM SURFACE HFEC INSPECTION AT REPAIRED AREA (REF EO 6755A032)(<P>ACCOMPLISHED SURFACE HFEC INSPECTION AT RH HORIZONTAL STAB. REPAIRED AREA PER NDTM 51-00-19 PART 6, RESULT NORMAL. INSPECTED THE BLIND RIVETS LOCATED AT THE HORIZONTAL STAB RH UPSDR UIEA2025093001250Door · crackedCRACKS (2 EA) ARE DETECTED AT R1 FWD ENTRY DOOR AFT LWR CORNER DURING OPEN HOLE HFEC INSPECTION IAW EO 6753A937(<P>REPAIRED WITH 2 EA OF REPAIR FILLER & 3 EA OF DOUBLER AS PER SRM 53-10-01-2R-1 REPAIR 1. NO FURTHER DEFECTS NOTED</P>)SDR FDEA202509301855Panel · dentedLH HORIZONTAL STAB LE PANEL 332EL FOUND PREVIOUS DENT REPAIR AT AS STA 482. PERFORMED DVI FOUND SURFACE CRACK AS PER B777 SRM51-10-02-0G REV:47.6. PERFORMED HFEC INSPECTION FOUND CRACK LENGTH APPROX 0.315" AS MARK AS PER B777 NDTM PART6 51-00-01 REV:94. THSDR SWIA2025092976095Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 3-2 900 RH - RH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12459-4 DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-630-816 (MRB 27-81-43-702), PART NUMBER: - , SERISDR SWIA2025092976094Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 3-2 900 LH - LH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12459-3 DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-530-816 (MRB 27-81-43-702), PART NUMBER: - , SERISDR SWIA2025092976093Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 2-2 900 RH - RH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12027-3 (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK PN CC670-12048-3 (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WSDR SWIA2025092976092Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 2-2 900 LH - LH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12027-3 (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK PN CC670-12048-3 (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WSDR SWIA2025092976091Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 1-2 900 RH - RH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12027-3 (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK PN CC670-12048-3 (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WSDR SWIA2025092976090Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 1-2 900 LH - LH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12027-3 (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK PN CC670-12048-3 (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WSDR SWIA2025092976074Hinge · gougedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA26889-670-53-21-582 899SK-DTI - COMPLY WITH DAMAGE TOLERANCE INSPECTION ON RA ID: 26889GOUGE ON PASSENGER DOOR PIANO HINGE FUSELAGE SIDE. NEAR VERY AFT LUG FOR SPRING PIN INSTALL. REPAIRED IAW REO 670-53-21-582 REV -B SDR SWIA20251201929Frame · damagedREMOVE AND PERFORM SRM FRAME SPLICE REPAIR ON FRAME FS333 TO FOM (C-CHECK RO 11/30/2025)REMOVED AND INSTALLED NEW FRAME SECTOR AT FS333 FROM STGR21L TO STGR25L REF-CRJ-700 DWG SH670-32420 REV E, SRM 51-42-06-001-001 A01 AND SRM 53-00-06-201-006 A01, LEAK CHESDR SWIA2025112400929Angle · bentANGLE AT BS 1031, S18 FOUND BENT WITH A RIVET SHEARED. FOUND TO BE BENT AND CRACKED, REMOVED AND INSTALLED A NEW ANGLE IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 REVISION 38, AND DWG MM670-36023, REV B. COMPLIED WITH ALL STEPS OF TASK CARD 51-900-1SDR SWAA2025110519408Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986.5 RBL 42 WL 208.1. REPAIRED FLOORBEAM IAW SRM 53-70-51-2R-6 REPAIR 6.SDR SWAA2025110519259Support Angle · corrodedCORROSION ANGLE - SUPPORT LOCATED STA 500I BTW STR 24L TO STR 26L AND WL 156 AT FWD CARGO. REMOVED DAMAGE AND EVALUATED REWORK AREA (3 EA) ON ANGLE - SUPPORT LOCATED STA 500I BTW STR 24L TO STR 26L AND WL 156 IAW SRM 53-30-08-1A-1 ALLOWABLE DAMAGE 1 PARAGRAPHSDR SWAA2025110519250Access Panel · crackedCRACK ANTENNA ACCESS PANEL 192F WING TO BODY FAIRING AT FUSELAGE EXTERIOR. REMOVED AND REPLACED MARKER BEACON ANTENNA ON ACCESS PANEL 192F WING TO BODY FAIRING AT FUSELAGE EXTERIOR IAW AMM 34-32-11-400-802 TESTED OK.SDR SWAA2025110519254Floorbeam · crackedCRACKED FLOORBEAM, BS 540, BL 0 - LBL 24.75, WL 208.1. REPLACED THE FLOORBEAM IAW SRM 51-10-02 ITEM 9, SRM 51-40-02-0G, & DWG143A0060, SHEET 64, REV-.SDR SWAA2025110519413Support Angle · crackedCRACK CARGO LINER SUPPORT ANGLE, CEILING AREA, BS 727J, LBL 50. REPAIRED THE SUPPORT ANGLE IAW SRM 51-70-11-2R-0.SDR SWAA2025110519256Gusset · crackedCRACK GUSSET ANGLE, BS 500I, STRINGER 21L. REPLACED THE GUSSET ANGLE IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 143A7902, SHEET 256, REV B.SDR SWAA2025110519411Floor Support · corrodedCORROSION ON FLOOR SUPPORT BTW BS 947.5 - 967, RBL 48, WL 208.1. REPLACED THE FLOOR SUPPORT AND FASTENERS IAW SRM 51-40-02, SRM 51-40-02, ITEM 9, & DWG 147A5650, SHEET 71, REV A.SDR SWAA2025110519412Floor Support · corrodedCORROSION ON FLOOR SUPPORT BTW BS 947.5 - 967, LBL 49, WL 208.1. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02-0G-0, ITEM 9, AND DWG 147A5660, SHEET 55, REV A.SDR SWAA2025110519255Floorbeam · crackedCRACK FLOORBEAM LOCATED BS 540 BTW BL 0 TO RBL 24.75 WL 208.1 AT PASSENGER CABIN. REPLACED THE FLOORBEAM BS 540 BTW BL 0 TO RBL 24.75 WL 208.1 AT PASSENGER CABIN IAW SRM 51-10-02, ITEM 9, SRM 51-40-02-0G, AND DWG 143A0060, SHEET 64, REV-.SDR SWAA2025110319524Angle · crackedCRACKED ANGLE, BS 695, BL 0. REPLACED ANGLE AND FASTENERS IAW SRM 51-40-02-0G-0, SRM 51-10-02, ITEM 9, AND DWG 273A9110, SHEET 6, REV A.SDR SWAA2025110331274Angle · crackedCRACKED ANGLE, FLOOR STRUCTURE, BS 695, BL 0. REPLACED ANGLE AND FASTENERS IAW SRM 51-40-02-0G-0 SRM 51-10-02 ITEM 9 AND DWG 273A9110, SHEET 6, REV.A.SDR SWAA2025110319520Angle · crackedCRACKED ANGLE, FLOOR STRUCTURE. BS 695, RBL 24.75. REPLACED THE ANGLE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, DWG 273A9110, REV A, & DWG 111A6000, SHEET 302, REV-.SDR SWAA2025110319521Angle · crackedCRACKED ANGLE FLOOR STRUCTURE LOCATED STA695 AND LBL24.75. REPLACED ANGLE LOCATED STA695 AND LBL24.75 CENTER SECTION IAW SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG 273A9110 REV A.SDR SWAA2025103019299Handle · deterioratedDETERIORATED HANDLE ON FWD ENTRY DOOR AT FWD GALLEY AREA (2 E/A). REPLACED HANDLE ON FWD ENTRY DOOR AT FWD GALLEY AREA (2 E/A) IAW AMM 52-11-31-400-802 STEP 3.G.(2).SDR SWAA2025103019286Rib · crackedCRACK LEADING EDGE RIB LE STA 95.96 RT HORIZONTAL STAB. REPLACED RIB IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 186A1001, SHEET 19, REV -.SDR SWAA2025103019287Rib · crackedCRACK LEADING EDGE RIB LE STA 105.26 RT HORIZONTAL STAB. REPLACED LEADING EDGE RIB IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 186A1001, SHEET 19 REV -.SDR AALA202510302796Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN FROM EMERGENCY EXIT ROW 17ABC FELL OFF. **SUPPLEMENTAL REPORT FOR (AALA202510012796): EXIT SIGN FROM EMERGENCY EXIT ROW 17 ABC WAS REPAIRED. PER CMM 25-00-00. OPERATIONAL CHECKED GOOD**(CLOSED).SDR SWAA2025102719219Rivet · looseFSD FWD LOWER SLIDE BAR BRACKET LOOSE RIVETS. FSD FWD LOWER SLIDE BAR BRACKET; RIVETS REPLACED IAW SRM 51-40-02-0G-0.SDR CALA2025102610516Skin · damagedDURING AAI INSPECTION NO RECORDS OR INSPECTION REQUIREMENTS WERE FOUND FOR THE EXTERNAL DOUBLER REPAIR ON THE FUSELAGE BETWEEN STA 727G - 727H AT STR 21L. REMOVED EXISTING DOUBLER ON FUSELAGE SKIN BETWEEN STA727G TO 727H AT STR 21L. FABRICATED AND INSTALLED NSDR CALA2025102610514Floor Support · crackedMAIN CABIN FLOOR SUPPORT INTERCOSTAL HAS 2EA CRACKS BETWEEN STA 277 AND 294.5 AT BLO IN THE UPPER SURFACE COMMON TO THE FLOOR BOARD FASTENER HOLES. CLEANED INTERCOSTAL, FOUND 100% OUT OF LIMITS. LOCATED AND DRILLED AND INSTALLED NEW INTERCOSTAL IAW BDWG 141ASDR CALA2025102610511Floor Support · cracked(B737-53-3-0711) MAIN CABIN FLOOR SUPPORT INTERCOSTAL UPPER SURFACE IS CRACKED AT THE FLOOR BOARD FASTENER HOLE STA 312 AND 328 AT APPROX LBL46. BLENDED OUT INTERCOSTAL, FOUND 100% OUT OF LIMITS. REMOVED, LOCATED AND DRILLED NEW INTERCOSTAL AND INSTALLED AT SDR SWAA2025102423042Scuff Plate · crackedFED LOWER FWD KICKPLATE CRACKED NEAR FASTENER HOLE. REMOVED AND REPLACED SCUFF PLATE FED LOWER FWD IAW AMM 53-11-01-000/420-801.SDR SWI2025F01457Seat Track · corrodedFORWARD FUSELAGE FLOOR STRUCTURE SEAT TRACK, RIGHT UPPER SURFACE HAS CORROSION ON UPPER SURFACE AT FR 16. REPAIRED FORWARD FUSELAGE FLOOR STRUCTURE SEAT TRACK, RIGHT UPPER SURFACE AT FR 16. BY REMOVING DAMAGE AND INSTALLING A FABRICATED FILLER PLUG/DOUBLER RESDR SWIA2025102400929Floorbeam · corrodedFORWARD FUSELAGE FLOOR STRUCTURE CROSSBEAM FR 17 CENTER HAS TWO AREAS OF CORROSION ON THE UPPER SURFACE. (C-CHECK RO 10/23/2025)REPAIRED FR17 RH CROSSBEAM REF EMB SRM 53-00-10 REPAIR 03PSDR 3EJA202510240008Pressure Switch · failedCOULD NOT CONTROL AIRCRAFT CABIN PRESSURE DURING CLIMB IN MANUAL MODE AND DUMP SWITCH ON USING THE CABIN ALTITUDE UP AND DOWN SWITCH. R&R DOOR SEAL DIFFERENTIAL PRESSURE SWITCH.SDR IPXA2025102300439Floor Panel · damagedMDC FLOOR PANEL 251 LJ IS DAMAGED. FABRICATION OF PANEL 251LJ IS COMPLETE IAW SREO-16407-REQ001((APPX B) A300 MAIN DECK CARGO COMPARTMENT FLOOR PANEL FABRICATION (SREO)). VERIFIED FABRICATION 251LJSDR 3EJA2025102400006Sensor · failedAMBER "STAB A/I HOT R" CAS MSG AFTER T/O. WITH A/I ALL OFF. MSG REMAINED UNTIL ENGINE SHUT DOWN. REMOVED FAILED RH STAB ANTI ICE SENSOR TH006 AND REPLACED WITH NEW. OPS CHECK GOODSDR R61A2025101900480Crossbeam · gougedDURING HEAVY CHECK INSP - R/H CROSS BEAM AT FR 17 HAS GOUGES. PERFORMED REPAIR OF DAMAGED AREA ON RH CROSSBEAM 17 REF EMB SRM 53-00-10 REPAIR 03PSDR SWAA2025102019449Handle · looseFORWARD ENTRY DOOR LINING UPPER AND LOWER ASSIST HANDLE ARE LOOSE. TIGHTENED FORWARD ENTRY DOOR LINING UPPER AND LOWER ASSIST HANDLES IAW AMM 52-11-31-400-802 STEP G. (2).SDR SWAA2025102019450Floorbeam · crackedFLOORBEAM AT BS540 FROM BL0-LBL24; WL208 IS CRACKED. REMOVED AND REPLACED IAW SRM 51-40-02-0G-0 AND DWG 143A0060 REV: -.SDR SWAA2025102019451Floorbeam · crackedFLOORBEAM AT BS540 FROM BL0-RBL24; WL208 IS CRACKED<[01] REMOVED AND REPLACED IAW SRM 51-40-02-0G-0 AND DWG 143A0060 REV: -.SDR SWAA2025102019291Skin · delaminatedRT WING OTBD AFT FLAP HAS DELAMINATION ON THE UPPER SURFACE 4' FROM THE INBOARD END NEAR THE TRAILING EDGE. RT OTBD AFT FLAP WAS REMOVED ALONG WITH FLAP ASSY AND SERVICABLE RT OTBD AFT FLAP WITH FLAP ASSY WAS INSTALLED ON FAULT TTG8Q015LVFW.SDR IPXA2025101600754Floor Panel · damagedFLOOR PANEL 252 PG IS DAMAGED. FLOOR PANEL 252PG FABRICATION COMPLETED IAW SREO-16407-REQ001.SDR R61A2025101900472Skin · scratchedDURING HEAVY CHECK LT WING UNDER SLAT NR 1 MULTIPLE GOUGES FOUND ON FIXED LEADING EDGE. REPAIRED GOUGES IAW EMB ETD 2025-170-929888SDR IPXA2025101389818Bracket · gougedLH WING, UPPER SURFACE, WTB, THROUGH FAIRING 577DT, CLOSE TO FALSE REAR SPAR, BRACKET SUPPORT HAS GOUGE. REMOVED BRACKET SUPPORT AT LH WING, UPPER SURFACE, WTB IAW A300-600 SRM 51-40-21. ++INSTALLED NEW BRACKET IAW A300-600 SRM 51-40-21.SDR SIMA20250929001Floor Support · corrodedSSI 53-23-005, SPLICE ON RH FLOOR SUPPORT AT FRAME 90 HAS CORROSION MARKED. RAR SPLICE ON RH FLOOR SUPPORT AT FR 90 IAW ERJ 175 SRM 51-40-08.