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 AALA202601133562Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM NR 5 ELEVATOR ON LT HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM 5 ELEVATOR ON LT HORIZONTAL STABILIZER IAW A320 FAM AMM 55-16-42-000-001-A AND FAM AMM 55-16-42-400-001-A.SDR AALA202601130764Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 2 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #2 RH ON HORIZONTAL STABILIZER IAW A320 FAM AMM 55-16-42-000-001-A AND A320 FAM AMM 55-16-42-400-001-A.SDR AALA202601138500Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM NR 6 ELEVATOR ON LT HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM #6 ELEVATOR ON LT HORIZONTAL STABILIZER IAW FAM AMM 55-16-42-000-001-A AND FAM AMM 55-16-42-400-001-A.SDR HNAA2026012000008Warning Message · false activationBLEED 1-2 VALVE CLOSED MSG ON EICAS & WOULD NOT RESET. PERFORMED OPS CHECK OF ENGINE BLEED VALVES IAW AMM 36-11-01. OPS CHECK GOOD. AIRCRAFT IS GOOD FOR SERVICE AT THIS TIME.RESET.SDR DALA2026011300313Proximity Switch · fod4R MAIN CABIN DOOR SHOWS OPEN WHEN CLOSED FOR PUSHBACK. FOUND FOD ON PROX SWITCH. REMOVED FOD AND CLOSED DOOR IAW A330 900 AMM 52-11. OPS NML, A/C OK FOR SVC. (7799486)SDR DALA2026011300311Lug · corrodedCORROSION WAS FOUND ON THE LT RIB 6 FITTING, FORWARD LUG. CORRECTIVE ACTION: REPAIRED PER ERA 631096-14. (1399019)SDR DALA2026011300310Lug · corrodedCORROSION WAS FOUND ON THE LT WING RIB 6 FITTING, FORWARD LUG. REPAIRED PER ERA 631096-14. (1399010)SDR DALA2026011300309Lug · corrodedCORROSION WAS FOUND IN THE LT WING RIB 6 FITTING FORWARD LUG. CORRECTIVE ACTION: REPAIRED PER ERA 631096-14. (1399002)SDR DALA2026011300306Spar · crackedTWO CRACKS IN A HOLE ON THE LEFT OUTER WING REAR SPAR AFT FACE BETWEEN RIBS 4 AND 5. REPAIRED PER ERA 631244-14 REV ORIGINAL. (1397928)SDR DALA2026011300302Skin · damagedFORWARD SIDE OF FRAME 64 TOOLING DAMAGE ON FUSELAGE SKIN JUST INBOARD OF P'1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1397651)SDR DALA2026011300301Light · inoperativeSEAT MOUNTED EMERGENCY LIGHTS INOP AT SEAT 43AB. R & R EMERGENCY LIGHT PER A330 AMM 33-51. OPS CK GOOD. (1398054)SDR DALA2026011300300Lug · corrodedRIGHT MLG RIB6 FWD LUG FWD SPOTFACE CORROSION. REPAIRED PER ERA 631097-14AD REV ORIGINAL. (1398062)SDR DALA2026011300299Lug · corrodedRIGHT MLG RIB 6 FWD LUG BORE CORRODED. REPAIRED PER ERA 631097-14AD REV ORIGINAL. (1397890)SDR DALA2026011300298Skin · damagedCABIN R4 DOOR EXTERNAL SURFACE LOWER EDGE NEED TO RE-DO EXISTING REINFORCING REPAIR. PERFORMED NEW REPAIR PER A330 SRM 52- 13-00-300-014. (1397682)SDR JJBA20260113026Flashlight Assy · inoperativeBURNING ELECTRICAL SMELL IN COCKPIT IMMEDIATELY AFTER TAKEOFF MOMENTAILY AND WHEN BACK AT GATE FOR 5-10 MINUTES. FOLLOWED FIM. STRONG ELECTRICAL SMELL COMING FROM FLIGHT DECK FLASHLIGHT. REMOVED AND REPLACED FLIGHT DECK AND FA FLAHSLIGHT ASSEMBLY. OPS CHECK SASDR CALA2026011312926Web · corrodedBS 1280-1300 CORROSION COMMON TO WEB. REMOVED AND REPLACED THE WEB 146N5425-27 IAW SRM 51-40-20-OG-0 REV 50.SDR CALA2026011312925Battery Pack · inoperativeAFT MOST RIGHT HAND EMERGENCY LIGHT NOT WORKING. REMOVED AND REPLACED R2 OVERWING EMERGENCY LIGHT BULB IAW AMM 33-51-04. PERFORMED OPS TEST IAW AMM 33-51-00. NO FIX, REQUIRES FURTHER TROUBLESHOOTING. REMOVED AND REPLACED BATTERY PACK M1671 IAW AMM 33-51-06-96SDR CALA2026011312924Battery Pack · inoperativeAFT GALLEY EXIT SIGN LIGHTS INOPERATIVE. REMOVED AND REPACED BATTERY PACK M1673 IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR CALA2026011312923Pin · brokenSEAT MOUNTED EMERGENCY LIGHT AT 24ABC INOPERATIVE. FOUND SEAT WIRE HARNESS AT CONNECTOR TO RACEWAY BROKEN. INSTALLED NEW PIN ON SEAT HARNESS CONNECTOR IAW SWPM 20-42-01. OPS CK OK.SDR CALA2026011312922Seal · missingFOUND LOWER INBD FLAP BULB SEAL MISSING. REPLACED THE BULB SEAL WITH NEW IAW IPC 27-51-11-01.SDR FDEA202601120026Battery Pack · failedAFTER WEEKEND LAYOVER, DURING MX PRE-FLIGHT CHECKS, FOUND EMERGENCY EXIT LIGHTS POWERED BY M730 INOP. AMM: 33-51-07-2 GMM: 12-7-600 REMOVED AND REPLACED BATTERY HOLDER ASSY. M730, MFR: RADIANT POWER CORP, MPN 2013-1A, S/N 118058, OPS CHECKS GOOD. A/C SDR FDEA202601120024Unknown · odorAFTER LANDING IN HAN, ON TAXI IN THE COCKPIT FILLED WITH INTENSE BURNING CHEMICAL ODOR NOSE AND EYES FELT BURNING SENSATION WE DONNED OUR OXYGEN MASKS COMPLETED OUR TAXI-IN SHUT DOWN THE ENGINES AND EXITED THE AIRCRAFT. SHGN 13JAN26 00:42 HAN AMM: 21-SDR FDEA202601120023Skin · wornWORN UPPER INSIDE SKIN TRAILING EDGE OF SLAT 5 (INBOARD). LH WING SLAT 5 T/E WEDGE UPPER INSIDE SKIN WAS REPAIRED IAW B767 SRM 57-43-02-2R FIG 201 (SHEET 1) AND SRM 51-70-10-2R REPAIR 4 FIG 202 (SHEET 8) REV 93 AUG 15/2025SDR SCNA20260113028Rivet · looseMAIN CARGO CABIN R1 FWD GALLEY DOOR ESCAPE SLIDE COVER FWD GIRT BAR RETAINER CLIP WITH SOLID RIVETS LOOSE. REPLACED SOLID RIVET IAW B737-800 BCF SR 51-40-02-06-0 PARAG 4 REV 25 DATED 11-10-2025 AND AIPC 25-66-00-14 REV 97 (12-15-2025)SDR SCNA20260113027Bracket · stuckMAIN CARGO CABIN, R1 FWD GALLEY DOOR ESCAPE SLIDE COVER LATCH BRACKET IS STUCK. REPLACED FWD GALLEY (R1) DOOR ESCAPE SLIDE COVER LATCH BRACKT IAW B737-800 AMM TASK 25-66-01-000-802 STEPS 4.D (K) AND TASK 25-66-01-400-801 STEPS 5.D (H) REV 88 DATED 10-15-2025 SDR YENA2026011300026Valve · failedFLT 133, BOS-SFO (ETOPS). COND TRIM AIR SYS FAULT - FWD CAB TRIM VALVE" ECAM MESSAGE DISPLAYED AFTER SHUTDOWN AT GATE. COCKPIT/CABIN TRIM AIR VALVES, FOLLOWED FIM TASK 21-63-00-810-803-A REMOVED AND REPLACED FWD CABIN TRIM AIR VALVE 12HK IAW AMM 21-63-51. LSDR YENA2026011300025Warning Message · illuminatedFLT 178, LAS- BOS (ETOPS). ACFT PROHIBITED FROM ETOPS OPS DUE TO CONDITION TRIM AIR FAULTS 3 FAULTS IN 10 DAYS. AIRPLANE PROHIBITED FROM ER OPERATIONS ETOPS. OPENSDR DALA2026011200266Light · inoperativeSEAT 54AB EMERGENCY LIGHT INOPERATIVE. R & R EMERGENCY LIGHT AT SEAT 54AB IAW AMM 33-51, OPS CHKD GOOD, OK FOR SVC. (1398058)SDR DALA2026011200264Lug · corrodedRIGHT MLG RIB 6 FWD LUG AFT SPOTFACE CORRODED. REPAIRED IAW ERA 631097-14AD, REV ORIGINAL. (1398032)SDR DALA2026011200261Computer · faultedF/CTRL SLATS LOCKED ON APPROACH - WING TIP BRAKE ON. PREVIOUS HISTORY OF F/CTRL FAILURES. T/S IAW TSM 27-81-00-810-810-A. INSPECTED SLAT ACTUATORS ON LT & RT WING & FOUND TO BE OK. RESET WING TIP BRAKE IAW AMM 27-80. PERFORMED STEP 4.C. OF TSM 27-81-810-810-A.SDR JR2R20260112964Panel · chafed419ML HAS MULTIPLE CHAFES AT SCREW HOLES ON INSIDE OF PANEL. REPAIREDSDR AALA202601127532Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR JR2R20260112953Panel · chafed429ML HAS MULTIPLE CHAFE MARKS AT SCREW HOLES. REPAIREDSDR JR2R2026011200054Panel · corroded419NR HAS MULTIPLE CHAFES AT SCREW HOLES ON INSIDE OF PANEL. REPAIREDSDR JR2R20260112054Crossbeam · corrodedFRAME 17 CROSSBEAM CORRODED FROM LBL12 TO RBL40. REPAIREDSDR JR2R20260112015Beam · corrodedBEAM RBL11 DOUBLER AT FR87 HAS CORROSION. REPLACEDSDR EE4Y2026120123745Frame · crackedDURING THE ALLEGIANT TASK CARD A32X-53-260-005 / TASK CARD A32X-53-260-003 INSPECTION RELATED TO AD 2022-15-05 AND A320-53-1491 REV 01 IN THE UPPER FUSELAGE PAX CABIN AREA, TOW CRACKS FOUND AT FR68, S22R (FASTENER HOLE NR1 ON STOP FITTING 1 AND HORIZONTAL FLANSDR 1Q2R2026071650087Cap · damagedDURING LIGHTNING STRIKE INSPECTION FOUND MULTIPLE EXITS AT FS893.00 AND FS953.00, ALSO FOUND DAMAGE EXIT ON TOP OF SKULL CAP AND THE END CAP HAS 3 EXIT POINTS.SDR SWIA2026011176635Floorbeam · crackedLBL 12 COCKPIT FLOORBEAM IS CRACKED AT BS 280 ATTACH POINT. PERFORMED REPAIR ON LBL 12 COCKPIT FLOORBEAM IAW REO 670-53-11-896, REV --, AMM 20-70-00, AND SRM 51-25-16.SDR REXA2026052700709Hinge · crackedINITIAL INSPECTION: CRACK ON HINGE OF THE BUTTER DOOR ACCESS PANEL 591LB AT LH WING. CRACK ON HINGE OF THE BUTTER DOOR ACCESS PANEL 591LB AT LH WING WAS REPAIRED PER EA NO: CRJ957-21363 REV. IRSDR REXA2026052700707Frame · crackedCRACK ON FUSELAGE FRAME FS 533.00 BTW STGR 0/ STGR 1R CRACK ON FUSELAGE FRAME FS 533.00 BTW STGR 0/ STGR 1R WAS REPAIRED PER EA CRJ953-19684 REV IRSDR REXA2026052700701Hinge · corrodedSECONDARY NRC FROM NRC 00129: AFTER REMOVAL OF FLAP STEP PLATE, CORROSION ON FLAP STEP PLATE HINGES (ALL) WAS FOUND. FLAP STEP PLATE HINGES (FWD,MID, AFT) WERE REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01 AND EA CRJ953-21415 REV, IR .SDR REXA2026052700700Hinge · corrodedSECONDARY NRC FROM NRC 00129: AFTER REMOVAL OF FLAP STEP PLATE, CORROSION ON FLAP STEP PLATE HINGES (ALL) WAS FOUND. FLAP STEP PLATE HINGES (FWD,MID, AFT) WERE REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01 AND EA CRJ953-21415 REV, IR .SDR REXA2026052700699Hinge · corrodedSECONDARY NRC FROM NRC 00129: AFTER REMOVAL OF FLAP STEP PLATE, CORROSION ON FLAP STEP PLATE HINGES (ALL) WAS FOUND. FLAP STEP PLATE HINGES (FWD,MID, AFT) WERE REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01 AND EA CRJ953-21415 REV, IR .SDR REXA2026052700696Seat Track · corrodedINITIAL INSPECTION: CORROSION ON SEAT TRACK LOCATED BTW FS349.00 TO FS379.00 AND RBL9.00. SEAT TRACK LOCATED BTW FS349.00 TO FS379.00 AND RBL9.00 WAS REPLACED PER CRJ-900 AMM 53-00-49-000-801-A07. AND AMM 53-00-49-400-801-A07.SDR REXA2026052700692Angle · crackedOUT OF SCOPE: CRACKED INTERNAL ANGLE OF EXTERNAL POWER RECEPTACLE. INTERNAL ANGLE OF EXTERNAL POWER RECEPTACLE. WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND SRM 51-42-13-001-001-A01.SDR REXA2026052700690Skin · chafedWEAR ON FUSELAGE SKIN BTW STA FS=910 TO FS=930 AND BTW STGR 24 LH AND 24 RH. WEAR ON FUSELAGE SKIN BTW STA FS=910 TO FS=930 AND BTW STGR 24 LH AND 24 RH WERE BLEND OUT AND EVALUATED WITHIN LIMITS BTW FS913 TO FS930 , STRG 24L/24R PER CRJ900 SRM 51-12-00-001-0SDR SWIA2026011175832Shroud · chafedRIGHT AILERON UPPER FIXED SHROUD IS CHAFED ALONG LEADING EDGE. REMOVED RIGHT AILERON UPPER LEADING EDGE SKIN IAW SRM 51-42-06 AND INSTALLED NEW RIGHT AILERON UPPER LEADING EDGE SKIN IAW SRM 51-42-06 & DWG PL601R13031 REV K AND REO 601R-57-61-894 REV -.SDR COEA2026041611801Access Panel · corrodedWO 269490 NR 500042 HEAVY CHECK COE/MAJOR REPAIR: UPPER WING ACCESS PANEL 522CT HAS FRETTING. LEVEL 2 CORRECTIVE ACTION: REPAIRED PER SRAS DO/TS-4809/07...04337 ISSUE I, DATED 3/2/2026.SDR SWIA2026040375659Cleat · crackedFRAME STATION 847, STRINGER 20R - CLEAT CRACKED. (C-CHECK RO 04/01/2026)FABRICATED NEW SERVICEABLE REPLACEMENT CLEAT IAW MHIRJ SNIEO SH670-35950. REMOVED CRACKED CLEAT AT FS847, STGR 20R AND INSTALLED NEWLY FABRICATED CLEAT IAW CRJ700 SRM 51-42-21-001-001-A01