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 CALA2025120811909Skin · damagedWHILE WALKING AIRCRAFT NOTICED NUMEROUS CREASES ON FWD CARGO DOOR NEED TO BE EVALUATED FOR SERVICEABILITY. REMOVED SKIN, LOCATED DRILLED NEW SKIN DOOR FWD CARGO & INSTALLED SKIN IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0 & 52-30-01-2R-3.SDR CALA2025120811907Floor Support · crackedCABIN FLOOR INTERCOSTAL BS 344-360, LBL 11 UPPER SURFACE CRACKED. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-40-02-0G-0, AND DWG 141A5400.SDR CALA2025120811905Floor Support · crackedCABIN FLOOR INTERCOSTAL BS 344 - 360, BL 0 UPPER SURFACE CRACKED AREA. REMOVED AND REPLACED UPPER CHORD IAW SRM 51-40-02-0G-0 AND DWG 141A5400.SDR CALA2025120811903Drag Fitting · crackedLEFT UPPER WING SKIN AND DRAG FITTING NR 4 HOLE HAS A CRACK INDICATION ONLY ON DRAG FITTING LAYER. COMPLIED WITH EC/RA 5720-03590, REV-, AND EA 757-5720-13-A4 213 REV- .SDR CALA2025120811901Light · inoperativeFOUND EMERGENCY PATHWAY LIGHTS INOPERATIVE, ROWS 14 & 26. REMOVED AND REPLACED EMERGENCY PATHWAY LIGHTS AT SEAT 26 AND 14 IAW CMM 25-23-55, OPS CHECKED GOOD.SDR CALA2025120811899Duct · crackedBELOW 50 PERCENT THRUST LT ENG ANTI ICE VALVE CAME ON A FEW TIMES THEN RESOLVED PERFORMED L ENG IDLE RUN FOUND LT ENG ANTI-ICE VALVE LIGHT INTERMITTENTLY ILLUMINATED, C/W AMM 36-11-00-715-149, ASPCU OPERATIONAL TEST. FOUND ASPCU SHOWING LT HPSOV FAULT. FOUSDR CALA2025120811825Light · brokenFLOOR LEVEL EMERGENCY EX IT LIGHT ON 24C DISCONNECTED FROM SEAT FOUND BROKEN ON LIGHT HOUSING BROKEN. NO OTHER EMERGENCY AISLE LIGHT INOPERATIVE. PLACING 24C EMERGENCY AISLE LIGHT ON MEL. MEL 3315A REJECT FOR SIGNOFF REPLACED 24C EMERGENCY LIGHT HOUSING. OPS CSDR CALA2025120711821Oven · dirtyAFT OVENS 411 AND 412 PRODUCED EXCESSIVE SMOKE OR STEAM MID COOK ING CYCLE CONFIRMED WITH CREW, VERIFIED AFT GLLY OVENS SMOKED DUE EXCESS WATER AND PLASTIC. CLEANED 412 OK, 411 SMOKES, MEL L/P 7197105 CHECKED COFFEEMAKERS, CB'S, GLLY EQUIP ALL OK. AIRED OUT GASDR DALA2025120808925Condenser · odorFA REPORTED FIRE ALARM IN CABIN. FA REPORTED SMELL OF SMOKE. PILOTS SMELLED SMOKE, BUT NO VISIBLE SMOKE. RETURNED TO GATE. C/A: LOUD SQUEAL AROUND ROW 30-31, NOISE WENT AWAY WHEN PACKS TURNED OFF. R & R LT PACK CONDENSOR REF A320 AMM 21-52. OPS NORMAL AT THIS SDR ABXA2025126322Fire Loop · fault messageRIGHT ENGINE FIRE LOOP 2 STAUS MESSAGE, MTX GROUNDED A/C AND DEFERRED RT ENGINE FIRE LOOP 2 IAW MEL ABX-26-11-1-1. A/C REMAINS NO ETOPS . AND RETURNED A/C TO SERVICE.SDR JR2R20251206654Beam · chafedWHILE PERFORMING LOWER DRAIN MAST SEAL REPLACEMENT ON NR 1 ENGINE INBD CORE COWL, FOUND DEEP CHAFE ON LOWER BEAM STRUCTURE. REPAIRED IAW ETD & TECHNICAL INSTRUCTION.SDR QMLA2025120620123Extension · crackedDURING INSPECTIONS, THE LT FORWARD LANDING GEAR EXTENSION WAS FOUND TO BE CRACKED AT THE BOLT HOLE.SDR 2026FA0000623Cylinder · scoredTHIS IS A NEW AIRCRAFT. LESS THAN 50HRS HAD BEEN FLOWN BEFORE WE FOUND ISSUES. LOGBOOK ENTRY, AIRCRAFT HAD A HARD STARTING CONDITION. FOUND STUCK INTAKE VALVES ON CYLINDERS 2, 4 & 5 WHILE DOING A COLD COMPRESSION CHECK. UPON FURTHER INSPECTION ALL THE EXHAUSTSDR SWIA2025120576568Stringer · corrodedMAIN AVIONICS STRINGER 22R HAS CORROSION BETWEEN BS 333 - 349 . INSTALLED NEW MAIN AVIONICS STRINGER 22R BETWEEN BS 333 - 349. IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG SH690-31350 REV. M. LEAK CHECK GOOD. COMPLIED WITH SKYWEST TASK CARSDR SWIA2025120576544Stringer Splice · corrodedMAIN AVIONICS STRINGER SPLICE 21R HAS CORROSION AT FS333. INSTALLED NEW SPLICE STGR 21R FS333.00. IAW SRM 51-42-06-001-001-A01 AND DWG SH670-32420 REV. E. LEAK CHECK GOOD COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2026070676497Stringer · corrodedMAIN AVIONICS STRINGER 21R HAS CORROSION BETWEEN BS 310 - 319. INSTALLED NEW STRINGER 21R BS 280 TO 333 IAW SRM 51-42-06-001-001A01.AND DWG SH670-31630, REV. K. LEAK CHECK GOOD. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKYSDR SWIA2025120576450Intercostal · corrodedMAIN AVIONICS INTERCOSTALS 20R HAS CORROSION BETWEEN BS 319 - 333. MAIN AVIONICS INTERCOSTAL S20R, BS 310 - 319 HAS EXFOLIATED CORROSION AT FASTENERS LOCATION. DAMAGE IS NOT ALLOWED WITHIN A 2D RADIUS OF A FASTENER THEREFORE FOUIND TO BE OUT OF LIMITS IAW SRMSDR 2026FA0000499Access Door · misalignedPILOTS L/H FWD DOOR LATCH DOES NOT CONTACT STRIKER PLATE. SHIMMED PILOTS L/H FWRD DOOR LATCH STRIKE PLATE. CONTACT ACCEPTABLE. NO DEFECT NOTED.SDR 2026FA0000498Access Door · misalignedFORWARD COCKPIT R/H DOOR LOWER FORWARD LATCH DOES NOT MAKE FULL ENGAGEMENT WITH STRIKE PLATE. SHIMMED FORWARD COCKPIT R/H LOWER FORWARD LATCH TO INCREASE LATCH ENGAGEMENT.SDR 2026FA0000497Access Door · misalignedAFT COCKPIT R/H DOOR UPPER LATCH HAS LIMITED ENGAGEMENT WITH STRIKE PLATE. SHIMMED AFT COCKPIT R/H UPPER LATCH TO INCREASE LATCH ENGAGEMENT.SDR 2026FA0000496Access Door · misalignedPILOTS L/H DOOR UPPER LATCH DOES NOT CONTACT STRIKER PLATE. SHIMMED PILOT L/H DOOR UPPER LATCH STRIKE PLATE TO INCREASE LATCH ENGAGEMENT. OPS CHECK GOOD. NO DEFECTS NOTED AT THIS TIME.SDR 2026FA0000495Access Door · misalignedAFT COCKPIT R/H FORWARD LOWER DOOR LATCH DOES NOT FULLY CONTACT STRIKE PLATE. SHIMMED AFT COCKPIT R/H FORWARD DOOR LATCH STRIKE PLATE. CONTACT ACCEPTABLE. NO DEFECTS NOTED.SDR 2026FA0000494Access Door · misalignedFORWARD COCKPIT R/H DOOR LOWER LATCH DOES NOT CONTACT STRIKER PLATE. SHIMMED PILOT R/H FWD COCKPIT LATCH STRIKE PLATE. CONTACT ACCEPTABLE. NO DEFECTS NOTED.SDR 2026FA0000493Access Door · bentFORWARD COCKPIT LEFT DOOR HANDLE PUSH ROD ASSY IS BENT. DOES NOT AFFECT DOOR OPERATION.SDR 2026FA0000485Door Latch · misalignedCO PILOTS (AFT COCKPIT) R/H FWRD DOOR LATCH DOES NOT CONTACT STRIKER PLATE. SHIMMED R/H FWD COPILOTS DOOR LATCH STRIKER PLATE. CONTACT ACCEPTABLE. NO DEFECTS NOTED.SDR 2026FA0000482Door Latch · unlatchedFORWARD COCKPIT R/H DOOR LOWER LATCH DOES NOT MAKE CONTACT WITH STRIKE PLATE. COMMENTS: WUC:11AE0 FWD COCKPIT R/H DOOR LOWER LATCH STRIKER PLATE SHIMMED FOR POSITIVE CONTACT. OPS CHECK GOOD REF A/C 43.13 1B SECTION 4 1-36SDR 2026FA0000479Striker · looseFORWARD COCKPIT R/H DOOR LOWER LATCH DOES NOT MAKE CONTACT WITH THE STRIKER PLATE.SDR REXA2026052700778Bracket · corrodedCORROSION ON BRACKET MACHINED (10 E/AS) AT FWD CARGO COMPARTMENT BRACKETS MACHINED ON FS.517.00 (2 EAS), FS560.00 (1 EA), FS660.00(1 EA),FS661.00+1 6.00 (2 EAS) WERE CLEANED PER CRJ900 SRM 51-26-00-001-001-A01 AND CORROSION NOT WAS FOUND. ALSO CORROSION ON BRSDR REXA2026052700776Seat Track · corrodedCORROSION ON SEAT RAIL RBL=9 BTW FS477 TO 669 AT CPAX. CORROSION ON SEAT RAIL RBL=9 BTW FS661+46 TO 669 AT CPAX WAS EVALUATED OUT OFF LIMITS PER CRJ/900 SRM 53-31-49-101-001-A02 AND IT WAS REPLACED PER CRJ900 SRM 51-40-11-001-001-A01 AND CRJ900 AMM 53-00-49 ANSDR REXA2026052700775Seat Track · corrodedCORROSION ON SIDE SEAT RAILS BTW FS 472.00, 566.00, 661+100, 698.00, 712.00, 744.00, 785.00 TO 811.00 AND OVER FS 962.00 AT RH SIDE PASSENGER CABIN CORROSION ON SIDE SEAT RAILS BTW FS 472.00, 566.00, 661+100, 698.00, 712.00, 744.00, 785.00 TO 811.00 AND OVER FSDR REXA2026052700767Seat Track · crackedCORROSION ON SEAT RAILS ON LBL 9 BTW FS 379.00, 613.00 TO 661+16, 661+46 TO 661+62, ON RBL BTW FS 349.00, 421.00, 453.00 TO 469.00, 495.00 TO 661+26, ON LBL27 BTW FS 465.00, 495.00 TO 581.00. SEAT RAILS ON LBL 9 BTW FS 379.00, 613.00 TO 661+16, 661+46 TO 661+6SDR REXA2026052700766Seat Track · corrodedCORROSION ON SEAT RAIL LBL=27 BTW FS477 TO 570 AT CPAX. SEAT RAIL (1EA) LBL=27 BTW FS477 TO 501 AT CPAX WERE CLEANED AND NOT CORROSION WAS FOUND PER CRJ/900 SRM 51-26-00 001-001-A01 AND SEAT RAIL (1EA) LBL=27 BTW FS501 TO 588 AT CPAX WAS EVALUATED OUT OF LIMSDR REXA2026052700765Seat Track · corrodedCORROSION ON SIDE SEAT RAILS BTW FS 409.00, 473.00, 485.00 TO 545.00, 661.00, 661+32 TO 661+46, 700.00, 744.00, 785.00 TO 840.00, AND OVER FS 847+32 AT LH SIDE PASSENGER CABIN. CORROSION ON SIDE SEAT RAILS BTW FS 409.00, 473.00, 485.00 TO 545.00, 661.00, 661+3SDR REXA2026052700758Intercostal · corrodedCORROSION ON INTERCOSTAL OVER S26L BTW BS 865 - 913 AT INTERNAL FUSELAGE STRUCTURE. CORROSION ON INTERCOSTAL OVER S26L BTW BS 865 - 881 AT INTERNAL FUSELAGE STRUCTURE WAS REMOVED PER SRM 51-21-06-001-001-A01 AND EVALUATED ORIGINAL THICKNESS: 0.063 IN AND MINIMSDR REXA2026052700757Floor Support · corrodedCORROSION ON LONGITUDINAL BEAM UPPER FACE AT LBL 9.00. AND BTW FS=977.00 TO FS=1098.00 AT PAX CABIN AREA FS 977 BTW FS 1000 AND FS 1076 BTW FS 1098 WAS CLEANED PER CRJ900 SRM 51-26-00-001-001-A01 AND NOT COROSION WAS FOUND ALSO DUE TO EXCESSIVE CORROSION ON SESDR REXA2026052700756Stringer · corrodedCORROSION ON SGTR 20L BTW FS=847.00+16 AND 847.00 +32 BELOW FLOOR STRUCTURE. CORROSION ON SGTR 20L BTW FS=847.00+16 AND 847.00 +32 BELOW FLOOR STRUCTURE WAS REPAIRED PER EA. NO. CRJ953-21177 REV. ASDR REXA2026052700755Frame · corrodedCORROSION ON FRAME BELOW FLOOR STRUCTURE OVER FS 969.00 AND STGR 25L TO 25R. CORROSION ON FRAME BELOW FLOOR STRUCTURE OVER FS 969.00 AND STGR 25L TO 25R WAS REPAIRED PER EA NO. CRJ953-21134 REV IR.SDR REXA2026052700733Stringer Splice · corrodedCORROSION ON SPLICES (4 E/AS) AS FOLOW FS 517, FS 565, FS 661+15 APROX AND FS 629 ALL ON STGR 24LH/25LH OVER WEBS OF LOWER JAMB AT FWD CARGO COMPARTMENT SPLICES (2 E/AS) AS FOLOW FS 517 AND FS 629) WAS REPAIRED PER EA NO: CRJ953-21101 REV IR AND EA NO: CRJ953SDR REXA2026052700732Floor Support · corrodedCORROSION ON LONGITUDINAL BEAM UPPER FACE AT LBL 27.00. AND BTW FS=977.00 TO FS=1098.00 AT PAX CABIN FLOOR STRUCTURE. AREA FLOOR BEAM BTW FS 977 AND FS 1059 WAS CLEANED PER CRJ900 SRM 51-26-00-001-001-A01 AND NOT CORROSIÏ¿½N WAS FOUND AND REPAIR PREVIOUS 27LBLSDR REXA2026052700731Seat Track · corrodedCORROSION ON SEVERAL AREAS OF SEAT TRACKS RAILS BTW FS 847.00 TO 1000.00 RBL 9 AND LBL9 AND OVER RBL AND LBL 27 BTW FS 927.00 TO 1000.00. CORROSION ON SEVERAL AREAS OF SEAT TRACKS RAILS BTW FS 847.00 TO 1000.00 RBL 9 AND LBL9 AND OVER RBL AND LBL 27 BTW FS 92SDR SWIA2025120575823Windshield · crackedPILOT'S WINDSHILED CRACKED BEYOND LIMITS. REMOVED PILOT'S WINDSHIELD AND INSTALLED SERVICEABLE WINDSHIELD. REF. AMM 56-11-01-400-801. OPS CHECK GOOD. LEAK CHECK GOOD.SDR N6WA2025120503Frame · corrodedCORROSION FOUND ON FRAME BS 1000 BTWN S26L-26R. PERFORMED FALSE FLANGE REPAIR AT FRAME BS 1000 S26L-26R IAW EO C550-53MR-033, EIRTECH SSR, 22551, & SRM 53-00-06-201-001.SDR N6WA202602190502Frame · corrodedCORROSION FOUND ON FRAME AT BS 1031 BETWEEN S27-26R. PERFORMED FALSE FLANGE REPAIR ON FRAME AT BS 1031, S27-26R IAW EO C550-53MR-033, EIRTECH SSR, 22551-001, SRM 53-00-06-201.SDR N6WA202602190501Frame · contaminatedCORROSION FOUND ON FRAME BS 1015 BETWEEN S26L -26R. PREFORMED FALSE FLANGE REPAIR AT FRAME STA 1015 BETWEEN STGR26L -STGR26R IAW EO C550-53MR-033/EIRTECH SSR/22551-001/ SRM 53-00-06-201SDR VNAA20260205005Floorbeam · corrodedAFTER REMOVAL ANGLE FLOOR SUPPORT CORROSION WAS FOUND AT CROSSBEAM BETWEEN BL 0 TO LBL 9 ON FUSELAGE STA 280. CROSSBEAM BETWEEN BL 0 TO LBL 9 ON FUSELAGE STA 280.0 WAS REPLACED PER SRM 51-42-06-001-001-A01, SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01SDR VNAA20260203009Drag Angle · crackedCRACK ON RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.00). RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACSDR VNAA20260203008Hinge Fitting · excess playFREE PLAY ON TWO BEARINGS OF CENTER HINGES NR 2 & 3 OF THE RUDDER AT VERTICAL STABILIZER REAR SPAR. THE HINGE FITTINGS WERE REPLACED IAW RIL#2103 REV. B.SDR VNAA20260203007Beam · damagedCORROSION ON UPPER SKIN OF LONGITUDINAL BEAM LBL 9 BTW BS 1069 - 1031IN THE AFT CARGO BAY, PAINT LONGITUDINAL BEAMS WAS REMOVED IAW SRM 51-26-01-001-001-A01, AND THE DAMAGE WAS NOT FOUND AND WAS PAINTED IAW SRM 51-21-11-001-001-A01, SRM 51-25-06-001-001-A01,SDR VNAA20260203006Seat Track · corrodedNICKS , WEAR, AND CORROSION ON RT SIDE SEAT TRACKS, STGR 15R BS 379 - 669 IN THE PAX CABIN. THE SEAT TRACKS DUE EXCESSIVE DAMAGE WERE EVALUATE IAW SRM 53-51-49-101-001-A01. AND REPLACED IAW AMM 53-00-49-400-801.SDR VNAA20260203005Seat Track · corrodedNICKS , WEAR AND CORROSION ON LT SEAT TRACKS AT STGR 15L (SECTION) BS 379 - 483, SEAT TRACK BS 483 - 573, SEAT TRACK BS 573 - 669 IN THE PAX CABIN. THE SEAT TRACKS BS 379 - 669 WERE REMOVED IAW AMM 53-00-49-000-801-A03 , & REPLACED IAW AMM 53-00-49-400-801.