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 CALA2026020113466Seat Track · lack of lubeFIRST OFFICER SEAT DIFFICULT TO SLIDE ON TRACK. FROM 5 INDICATOR FORWARD SEAT NEEDS NON-NORMAL FORCE TO MOVE FORWARD. SEAT ALSO DIFFICULT TO MOVE IN THE TURN/CURVED PORTION OF THE TRACK. SPRAYED SEAT TRACK WITH FOOD GRADE LUBRICANT. OPS CHKD GOOD, SEAT MOVESSDR CALA2026020113465Oxygen Bottle · expiredMID CABIN LEFT POB PRESSURE LOW REMOVED AND REPLACED POB MID CABIN FWD IAW 35-32-42-400-001-A.SDR CALA2026020113461Sign · inoperativePASSENGER EMERGENCY SIGN AT 20CBA INOPERATIVE. R & R PASSENGER EMERGENCY SIGN AT 20CBA IAW AMM 33-51-00. OPS CHECKED GOOD.SDR CALA2026020113456A/C Pack · overtempCREW NOTED ODOR IN CABIN BEFORE PACK OVERHEAT. REQUIRES TSM 05-50-00-810-831-A CONFIRMATION CREW STATED ODOR NOT PRESENT AFTER PACK SHUT OFF. REF L/P 7768776 FOR PACK 1 OK TO CONTINUE.SDR I5PA2026020168804Outflow Valve · faultedOUTFLOW REQUIRES MANUAL OPERATION TO OPEN ON THE GROUND. R & R OUTFLOW VALVE ACTUATOR IAW AMM 21-31-04.SDR I5PA2026013068803Pilot Valve · faultedDEFERRED RT ENG HPSOV IAW MEL 36-11-02. R & R RT ENG HIGH STAGE PILOT PER AMM 36-11-08.SDR DALA2026013000719Floorbeam · corrodedFOUND AFT CARGO FLOORBEAM CORROSION AT C57.1 -Y1470. REPLACED THE FLOORBEAM AT AFT CARGO C57.1 AREA IAW SRM 51-72-11-901-001. (1426823)SDR DALA2026013000718Skin · damagedDAMAGE ON LT WING SLAT NR 2 INBD LEADING EDGE. REPAIRED LT WING SLAT NR 2 INBD LEADING EDGE. OK FOR SERVICE. (1426624)SDR WX0A2026013032720Megaphone · no discrepancy(AIRCRAFT NOT GROUNDED) FA REPORTS THAT THE FWD MEGAPHONE NOT PREFLIGHTING PROPERLY. REMOVED MEGAPHONE AND OPS CHECKED THE SIREN AND MADE SURE BATTERIES WERE CHARGED IAW AMM 25-65-51-710-002-A. NO DEFECTS NOTED AT THIS TIME.SDR IPXA2026013038362Charger · no testEMERGENCY EXIT LIGHT WILL NOT TEST REMOVED AND REPLACED EMERGANCY LIGHT BATTERY ASSY AND BATTERY CHARGER REF 757MM 33-51-07-902-001 33-51-07-862-054 TEST OK. OK FOR SERVICESDR AALA202601307475Cabin Air Sys · abnormalAIRCRAFT WAS GROUNDED: CREW NOTICED STRONG WET SUCK ODOR BEGAN AT 9000K ON DESCENT FROM REAR TO FRONT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR IXXA20260130001Skin · delaminatedPERFORM PERMANENT HOT-BOND REPAIRS UNDER VACUUM ON THE THREE DAMAGED AREAS OF THE RIGHT-WING OUTBOARD TRAILING EDGE FLAP LOWER SURFACESDR ABXA20260130039Start Valve · defectiveDURING TAXI OUT, UPON START ATTEMPT FOR LH ENG, ENG START VALVE WOULD NOT OPEN. AIRCRAFT RETURNED TO BLOCKS (BTB). DEFERRED LT ENG START VALVE PER MEL 80-00-2-1. PLACARDS INSTALLED. MBCB 02/09/26. REPLACED LT ENGINE START VALVE PER B767 AMM 80-11-02. SYSTEMSDR ABXA20260130038Pneumatic System · failedDURING TAXI OUT, APU PNEUMATICS INOP. A/C RETURNED TO BLOCKS (BTB). MAINTENANCE DEFERRED PER MEL 49-11-1-1. PLACARD INSTALLED, CAT C DUE DATE 2/9/26. MAINT. PROCEDURES 36-11-4 C/W. AIRCRAFT RETURNED TO SERVICE.SDR AALA202601301090Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR SCNA20260130048Girt Bar · unsecureTHE HOLDER FOR THE GIRT BAR ON THE L1 DOOR IS LOOSE AND THE GIRT BAR FALLS OUT. REINSTALLED ESCAPE SLIDE GIRT BAR IAW AMM 25-66-01 AC OK FOR SERVICE.SDR REXA2026052700703Hinge · corrodedCORROSION AT INNER LUG BORES OF RH AILERON, CENTER HINGE FITTING AILS R1,R2,R5 AND R6 WAS FOUND LUGS BORES R1, R5 AND R6 RH AILERON WERE CLEANED PER CRJ 900 SRM 51-26-00-001-001-A01 CLEANING AND NOT FOUND CORROSION & R2 WERE REPAIRED PER REO 670-57-61-107 REV SDR SWIA2026012975758Skin Panel · damagedPERFORM REPAIR TO LOWER WING PLANK, LOWER SKIN PANEL, AND BATT RIB AT WS53.6 REF. REO 601R-57-21-4021. COMPLIED WITH ALL STEPS OF REO601R-57-4021 REV -- DATED 2026-02-16, DWG 601R10203 REV. G. NO FUEL LEAKS NOTED AT THIS TIMECOMPLIED WITH SKYWEST TASK CARD SDR SWIA2026012975720Window Post · dentedWINDSHIELD CENTER POST LOWER LH FITTING IS DENTED. (C-CHECK RO 04/16/2026)REMOVED AND REPLACED WINDSHIELD CENTER POST LH LOWER FITTING IAW SRM 51-42-21 COMPLETED TASK CARD 51-900-1003-SKY.SDR AALA202604144692Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FRAME 68LH SIDE, AT AFT GALLEY AREA, DOOR STOP 1, LOWER INBOARD HOLE, CRACK POSITION 7 OCLOCK VIEW LOOKING AFT, CRACK DEPTH: 0.100 INCHES APROX. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR LOC FRAME 68 LH SIDESDR IPXA2026033132792Support Angle · gougedUNLOAD CREW REPORTED DAMAGE TO LOWER FWD CARGO DOOR FRAME UPPER AFT CORNER. REMOVED DAMAGE SUPPORT ANGLE I.A.W SRM 51-40-02-0G REV.94. INSTALL NEW SUPPORT ANGLEI.A.W SRM 51-40-02-0G REV.94 AND BOEING DWG NO. 143T8514 SH 5 REV: A, SH 7 REV: B.SDR SWIA2026012975619Hinge Arm · chafedLEFT INBOARD FLAP OUTBOARD HINGE ARM BOTH FAIRING PLATES CHAFED. REMOVED AND REPLACE LEFT INBOARD FLAP OUTBOARD HINGE ARM, IB FAIRING AND OB (2EA.) FAIRING PLATES WITH NEW REF. CRJ700 SRM 51-42-06-001-001-A01 AND CRJ 700 SRM 51-45-00-001-001-A01.SDR SWIA2026012975618Plate · chafedLEFT INBOARD FLAP INBOARD HINGE ARM BOTH FAIRING PLATES CHAFED REMOVED AND REPLACED LEFT INBOARD FLAP INBOARD HINGE ARM BOTH FAIRING PLATES P/N: CC670-14138-1 AND CC670-14138-2 REF. CRJ-700 SRM 51-42-06-001-001-A01 AND SRM 51-42-15-001-001-A01.SDR SWIA2026012975601Angle · corrodedPASSENGER DOOR SURROUND STRUCTURE KICK PLATE ANGLE (STGR 17L TO 18L) HAS CORROSION (C-CHECK RO 03/28/2026)REMOVED AND REPLACED CORRODED KICKPLATE ANGLE WITH NEW KICK PLATE ANGLE (P/N: SH670-31875-3) USING NEW FASTENERS, REF CRJ700 SRM 51-42-21-001-001-A01, SRSDR VNAA20260329018Crossbeam · corrodedCORROSION WAS FOUND ON CROSSBEAM WEB FS 349.0 BTW STGR17 LH TO STGR18 LH AT PASSENGER CABIN. CROSSBEAM WEB FS 349.0 BTW STGR17 LH TO STGR18 LH AT PASSENGER CABIN WAS REPAIRED PER REO 690-53-21-2094 REV -.SDR VNAA20260329017Floor Support · crackedCRACK ON FLOOR SUPPORT, RBL 12.0 BTW FS 221.73 TO FS229.00 AT FWD FUSELAGE INTERNAL STRUCTURE (BELOW FLIGHT COMPARTMENT FLOOR). FLOOR SUPPORT RBL 12.0 BTW FS 221.73 TO FS229.00 AT FWD FUSELAGE INTERNAL STRUCTURE (BELOW FLIGHT COMPARTMENT FLOOR) WAS REPAIRED RSDR SWAA2026030565866Web · crackedCRACKED WEB, BS 344 - 360, BL 0. REPLACED THE WEB IAW SRM 51-10-02, ITEM 9, & DWG 141A5400, SHEET 32, REV -.SDR SWIA2026030475413Flap Track · wornRIGHT FLAP NR 1 AFT TRACK HAS HEIGHT REDUCTION. REMOVED AND REPLACED RT INBD FLAP AFT TRACK IAW AMM 57-54-25-400-801-A.SDR SWIA2026030475412Flap Track · wornLEFT FLAP NR 1 OTBD AFT TRACK HAS HEIGHT REDUCTION. REMOVED AND REPLACED LT OTBD FLAP AFT TRACK RAIL IAW AMM 57-54-25-400-801-A.SDR VNAA20260304027Hinge Fitting · excess playFREE PLAY ON SELF-ALIGN SELF-LUBE BEARING PLAIN ON HINGE FITTING NR 3 ON THE VERTICAL STAB REAR SPAR MIDDLE SECTION. HINGE FITTING NR 3 AT VERTICAL STAB WAS REPLACED IAW SRM 51-42-21-001-001-A01, AND RIL 2103, REV B.SDR VNAA20260304020Door · missingFORWARD LAVATORY SERVICE DOOR MISSING. FORWARD LAV SERVICE DOOR INSTALLED IAW SRM 51-42-06-001-001-A01, AND AMM 52-45-17-400-801,CONFIG A02.SDR VNAA20260304011Hinge Fitting · corrodedCORROSION ON HINGE FITTING AND HINGE ARM ACCESS 196ER. CORROSION ON HINGE ARM WAS REMOVED IAW SRM 51-21-06-001-A01 HINGE FITTING WAS REPLACEDSDR VNAA20260304010Floor Support · crackedCRACK ON FLOOR BEAM RBL 12 FS BTW FS 221.73 TO FS 229.0 AT FWD FUSELAGE INTERNAL STRUCTURE (FLIGHT COMPARTMENT FLOOR STRUCTURE BELOW WL 79.50. CRACK ON FLOOR BEAM RBL 12 FS BTW FS 221.73 TO FS 229.0 AT FWD FUSELAGE INTERNAL STRUCTURE (FLIGHT COMPARTMENT FLOORSDR HNAA2026030400188Bracket · crackedAFT CARGO FRAME MOUNTING BRACKET AT FR 61 RH, STR 5R, IS CRACKED. REMOVED AND REPLACED AFT CARGO FRAME MOUNTING BRACKET P/N 145-40575-603 AT FR 61 RH STR 5R PER EMB 145 SRM 51-40-02-PR.SDR HNAA2026030400171Gusset · corrodedSIGNS OF CORROSION ON THE LT GUSSET AT MULTIPLE PLACES FROM FR 52 - 60. REMOVED AND REPLACED WITH NEW IAW SRM 51-40-02-PR.SDR HNAA2026030400170Floorbeam · corrodedFWD WET AREA FLOORBEAM FR 20, HAD CORROSION. REMOVED THE FLOORBEAM AND INSTALLED NEW IAW SRM 51-40-02-PRSDR SWAA2026030365541Vapor Barrier · crackedCRACKED VAPOR BARRIER, BS 663, LBL 40. REPAIRED THE VAPOR BARRIER IAW SRM 51-70-04-2R-10, REPAIR 10.SDR AALA202603038688Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 56 AND FR 57 AT S42L. REPAIRED STRINGER PER EA 372262.SDR SWAA2026030265786Plate · crackedLEFT WING WAFFLE PLATE CRACKED I/B OF NR 3 FLAP TRACK. REMOVED CRACKED WAFFLE PLATE IAW SRM 51-40-02. LOCATED AND DRILLED FASTENER HOLES IN A NEW WAFFLE PLATE IAW SRM 51-40-05. REMOVED AND INSTALLED THE NEW WAFFLE PLATE WITH FASTENERS IAW SRM 51-40-02.SDR SWAA2026030265785Plate · crackedRIGHT WING INBD OF NR 6 FLAP TRACK, WAFFLE PLATE CRACKED. REMOVED CRACKED WAFFLE PLATE IAW SRM 51-40-02. LOCATED & DRILLED FASTENER HOLES IN NEW WAFFLE PLATE IAW SRM 51-40-05. REMOVED AND INSTALLED A NEW WAFFLE PLATE WITH FASTENERS IAW SRM 51-40-02.SDR SWIA2026022705387Frame · damagedREMOVED SUB-FRAME BS 317 REFERENCE SRM 53-21-23 ITEM 34. INSTALLED SUB-FRAME BS 317 WITH REFERENCE TO SRM 51-42-06 AND SRM 51-42-21. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA202602275377Stringer · fomREMOVED STRINGER 2L FORWARD (REFERENCE SRM 53-21-03 ITEM 6) TO FOM. INSTALLED STR 2L FORWARD (REFERENCE SRM 53-21-03 ITEM 6) WITH REFERENCE TO SRM 51-42-06. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2026012975361Fitting · fomREMOVED PAX DOOR FWD LATCH BACKUP FITTING LINTEL IAW DWG SH670-31270 TO FOM. INSTALLED PAX DOOR FWD LATCH BACKUP FITTING LINTEL IAW DWG SH670-31270 WITH REFERENCE TO SRM 51-42-21. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR ASAA2026012964576Frame Splice · corrodedAFT CARGO BS 727D FRAME SPLICE CORRODED AT RBL-21. GROUNDED - YES. REMOVED & REPLACED NEW SPLICE PN 146A1300U8 ON AFT CARGO BS 727D, RBL 21 IAW SRM 51-40-02-0G-0. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A-1. W 1, O .07, R .054, L 1, D .SDR IPXA2026021021755Skin · crackedMAJOR REPAIR. FUSELAGE SKIN CRACK AT BS 560 S-23L - S-24L. (REPAIR) . ACCOMPLISH THE REPAIR I.A.W SRM 53-00-01-2R-13 REV.64 AND EGAT WORK SHEET NO.60081 REVIEWED TASK PER GMM-MTX 09.05.01.09.SDR SWIA2026022375299Beam · corrodedCORROSION IN RT BEAM FR.87-88. REMOVED AND REPLACED RT BEAM IAW SRM 51-40-08.SDR SWIA2026022375298Beam · corrodedCORROSION IN LT BEAM FR.87-88. REMOVED AND REPLACED LT BEAM IAW SRM 51-40-08.SDR SWIA2026012975297Seat Track · corrodedRIGHT INBD SEAT TRACK CORRODED AT FR 17. REMOVED AND REPLACED RT INBD SEAT TRACK FR 12-20, REF SRM 51-40-08.SDR IPXA2026022021669Bracket · gougedGOUGED BRACKET, BULK CGO APU PNEUMATIC DUCT SUPPORT UPPER BEAM LOWER SIDE AT STA 2280. REMOVED DAMAGE BRACKET IAW SRM 51-40-02-0G REV.64 2. INSTALLED NEW BRACKET IAW SRM 51-40-02-0G REV.64 , AND DWG 65B07693 SH 7 REV.SDR SIMA202602239002Floorbeam · corrodedCORROSION ON AFT WET AREA LH "FLOOR BEAM" AT FR 87 Y= -12" (MAJOR REPAIR) (LEVEL 2 CORROSION). BLENDED AREA ON AFT LH FLOOR BEAM AT FR87 AND Y= -12? PER EMB 175 SRM 51-10-03. LARGEST BLENDED AREA MEASURES (L: 1.20" W: .60" D: .050") BLENDED AREA FOUND TO BE OU