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 CALA2025110310851Slide · no discrepancyR1 DOOR SLIDE TAB EXCESS MATERIAL STICKING OUT. INSPECTED R1 SLIDE TAB FOR EXCESS, INSPECTION FOUND TO BE WITHIN THE LIMITS IAW AMM 25-66-01. NO OTHER DEFECTS NOTED.SDR CALA2025110310850Bustle · damagedESCAPE SLIDE PACK BUSTLE DAMAGED 2R GIRT BAR IS UNABLE TO BE STOWED. ESCAPE SIDE PACK CHECK REF AMM 25-66-01-200-802. OK TO CONTINUE.SDR CALA2025110310849Slide · partial deployON OPERATION OF L1 DOOR INTERRIOR HANDLE, TO INSTALL THE GIRT SAFETY RELEASE PIN. L1 SLIDE MATERIAL INADVERTENLY DEPLOYED. NO INFLATION. R & R L1 DOOR SLIDE PACK IAW MM 25-66-01-400-801. ACCOMPLISHED EMERGENCY POWER ASSIST SYSTEM (EPAS) RESERVOIR PRESSURE LSDR CALA2025110310847Valve · stuckALL LAVS OUT OF SERVICE. FOUND LAV D GATE VALVE STUCK OPEN, DEPLETING VACUUM FROM OTHER TOILETS. AFTER MANUALLY CLOSING LAV D GATE VALVE ALL OTHER TOILETS OPS NORMAL ON GROUND. REF LOG PG 6790548 FOR WORK ACCOMPLISHED. OPS CHECK GOOD. NO LEAKS NOTED. NO FURTSDR CALA2025110310845Lamp · inoperativeEMERGENCY LIGHTS OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - DOOR 1R EMERGENCY SLIDE LIGHT FOUND INOP RELAMPED 1R DOOR EMERGENCY SLIDE LIGHT IRW AMM TASK 33-51-04-960-801 OPS CHECK GOOD.SDR CALA2025110310844Power Supply · no testOPERATIONAL CHECK OF THE EMERGENCY POWER SUPPLY UNITS BY BITE-CHECK IAW EA2500-03960 AND EA2500-08031. R & R EPSU BATTERY AT AFT L LOCATION. REF: AMM 33-51-38/401 CONFIG 00. OP CHECK GOOD.SDR CALA2025110310843Power Supply · no testOPERATIONAL CHECK OF THE EMERGENCY POWER SUPPLY UNITS BY BITE-CHECK IAW EA2500-03960 AND EA2500-08031. R & R RT EMERGENCY EXIT EPSU, IAW AMM 33-51-38/401 CONFIG 00. OP CHECK IS GOOD.SDR CALA2025110310842Elec Connector · damagedEMERGENCY FLOOR PROXIMITY LIGHTS INOP AT SEATS 28A AND 29A. FOUND WIRE DISCONNECTED FROM PLUG CONNECTOR, REPINNED, INSTALLED AND RECONNECT PLUG PER ESPM 20-48-27 OPS. CHECK GOOD ON CABIN EMERGENCY LIGHTING SYS. PER A.M.M. 33-51-00-710-805-ASDR CALA2025110310836Unknown · odorUNKNOWN LIQUID LEAKING FROM L1 DOOR, SULFUR ODOR. OPERATED L1 DOOR MULTIPLE TIMES. NO LEAK FOUND & NO SULFUR ODOR DETECTED AT THIS TIME. NO EVIDENCE OF ANY TYPE OF LEAK FOUND.SDR CALA2025110310834Unknown · odorON TAKE OFF ROLL ABOVE 100KT, SMELLED STRONG OIL ODOR WITH HYD LEVELS WELL BLOW 100% AFT FLAP UP PERFORMED SMOKE/ODOR INSPECTION IAW AMM TASK 05-51-26-800-801-C1 UP TO STEP C SUBSTEPS (2)(E)(4) WITH APU RUNNING. NO ODOR NOTED. CONTINUED AMM TASK 05-51-26-80SDR CALA2025110210816Skin · damagedRIGHT WING, OTBD FLAP, AFT FLAP, INBD END, LOWER SKIN DISBONDED AREAS 6X 3.5 INCHES AND 3X3.75 INCHES. CUT, REMOVED DAMAGED SKIN, MOISTURE REMOVED, FABRICATED THE REPAIR PARTS, APPLIED PRE-BOUND ON REPAIR PART, REPAIR AREA AND RESTORED FINISH ON RT WING, OTSDR CALA2025110210814Skin · delaminatedRIGHT WING, OTBD FLAP, AFT FLAP, INBD END, UPPER SKIN WITH DISBONDED AREAS 2 X 2.25 INCHES AND 1 X 1 INCHE. REMOVED THE DAMAGED SKIN, CLEANED, PREPPED, FABRICATED NEW REPAIR PARTS, APPLIED PRE-BOND ON NEW REPAIR PARTS, REPAIR AREA AND RESTORED FINISH ON RT WSDR CALA2025110210813Light · detachedCEILING EMERGENCY LIGHT HANGING, ROW 25 SECURED CEILING LIGHT ASSY AT ROW. 25. OK TO CONTINUE..SDR CALA2025110210811Skin · crackedINSPECTING THE FASTENER HOLES ON LEFT WING INBD L/E, UPPER SPAR ATTACH, ON N/R 5000-0108, EA 5720-02922, FOUND 2 EXISTING HOLES OF 0.250" DIAMETER WITH CRACKS IN SKIN ONLY. ACCOMPLISHED REPAIR OF LTT WING INBD LEADING EDGE SKIN IAW SRM 57-41-01-2R-8.SDR CALA2025110210809Wire Harness · damagedEMERGENCY LIGHT WIRE HARNESS DAMAGED. REMOVED AND REPLACED THE DAMAGED SECTION OF WIRE HARNESS IAW DRAWING 40N018 10, REV ORIG. SHEET 2, PAGE 11, SWPM 20-90-14, AND AIPC 25-27-31-47A.SDR CALA2025110210807Wire Harness · damagedEMERGENCY LIGHT HARNESS AT BS 570 LT HAS A DAMAGED SECTION WIRING. REMOVED AND REPLACED DAMAGED SECTION WIRE HARNESS AT BS 570 IAW DRAWING 40N01810, REV ORIG. SHEET 2, PAGE 8, SWPM 20-90-14, AND AIPC 25-27-3 1-47A.SDR CALA2025110210805Service Door · missingLAVATORY SERVICE DOOR MISSING. REPLACED LAVATORY SERVICE DOOR IAW AMM 52-42-11-400-001-A AND ECRA 52-42-01073. OPS CHECK OF LIMIT SWITCH GOOD.SDR SCNA20251103425Oil System · emptyAFTER TAKEOFF ENG 2 OIL QTY WENT TO ZERO THEN ENG OIL PRESSURE DECREASED TO RED RANGE THEN TO ZERO PRECAUTIONARY SHUT DOWN NR 2 ENG. REMOVED AND REPLACED #2 ENGINE ON W/O 990509 TASK CARD 7100000000. OPS CHECKS GOOD REF 71-00-02SDR SCNA20251103424Carpet · unsecureAFT EDGE OF CARPET LH ISLE IS A TRIP HAZARD AT FWD SIDE OF LAV. AFT EDGE OF CARPET LT AISLE CARPET STRIP AT FWD SIDE OF LAV WAS REALIGNED AND SECURED IAW CARPET INSTALLATION AMM 25-27-15. FAS#9436. AFT GALLEY SEAL RBL 24-30 AT CEILING WAS ADJUSTED IAW B-737 SDR SCNA20251103423Smoke Detector · malfunctionedSMOKE ALARM WENT OFF WHEN WE WERE ON BASE TO FINAL LAVATORY SMOKE DETECTION SYSTEMS. REPLACED LAVATORY SMOKE DETECTOR IAW AMM 26-14-01, OPS CHECK GOOD,SDR SCNA20251103422Slide · no discrepancyL1 MAIN DOOR SLIDE NEEDS REPACKING. THE SLIDE PACK CHECKED IAW AMM 25-66-01-200-802. NO FAULTS NOTED, OK FOR SVC.SDR DALA2025110308000Unknown · odorDIV - INTO DUB DUE TO NAIL POLISH ODOR IN THE CABIN. ALL SURROUNDING AREA WAS INSPECTED WITH NO FINDINGS. OK FOR SERVICE. (6804730)SDR AALA202510315693Gust Lock · brokenAIRCRAFT WAS GROUNDED: L1 DOOR WILL NOT OPEN. FOUND GUST LOCK LICK BROKEN. REMOVED AND REPLACED L1 ENTRY DOOR HINGE PIN. PER AARD 52-10-00-4 REPAIR 4.SDR 2025F00254A/C Pack · trippedFLIGHT 393 HVN-ATL. OCT. 31, 2025. RIGHT PACK OVERHEAT THEN TRIP OFF AND SMOKE ODOR IN THE FLIGHT DECK AND CABIN. AIR RETURN TO BDL.SDR AALA202510312497Bottle · 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 AALA202510314924Bottle · 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 AALA202510317202Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR UIEA2025103101288Flashlight · inoperativeFLASHLIGHT AT L1 DOOR INOP(<P>R/R FLASHLIGHT PER ATLAS AIR DOCUMENT 777F-25-EEL AND OPS CHECK GOOD IAW AMM 25-64-01.SDR SWAA2025103130280Light · burned outLEFT EMERGENCY EXIT LATCH; EMERGENCY EXIT LIGHT BURNED OUT. REPLACED EMERGENCY EXIT LIGHT, LT EMERGENCY EXIT LATCH IAW AMM 33-51-04-960-801 STEP 2.F.(1)(2)(3)(A)(B)(D).SDR JR2R20251031402Floor Support · corrodedFLOOR BEAM RBL11 CORRODED FROM FR12 THRU FR17. REPLACED.SDR 2025FA0000738Support Beam · corrodedSVO 0146-SUPPORT BEAM ON THE BAGGAGE DOOR AT FS669.75 WAS FOUND CORRODED- LEVEL 2 CORROSIONSDR 2025FA0000737Support Beam · corrodedSVO 0146-SUPPORT BEAM ON THE BAGGAGE DOOR AT FS669.75 WAS FOUND CORRODED- LEVEL 2 CORROSIONSDR 2025FA0000736Bracket · corrodedSVO 0145- SUPPORT BRACKETS ON FUSELAGE EXTERIOR FAIRING SUPPORT STRUCTURE AT FS 575 BL 3LH AND RH SIDE WERE FOUND TO BE CORRODED- LEVEL 2 CORROSIONSDR 2025FA0000735Skin · corrodedRH WING PLANK FUEL ACCESS OPENING 631FB CORRODED- LEVEL 2 CORROSIONSDR DALA2025103107977Anti-Ice Valve · faultedDIV - TO ORD DUE TO AIR R WING LEAK ECAM WARNING. FOUND TAPPING SEALS IN FLEXIBLE CONNECTOR UPSTREAM OF THE RH WING ANTI-ICE VALVE LEAKING, REPLACED SAME. OPS CHECK GOOD. (LP 8025046)SDR EE4Y2025103123400Spar · crackedDURING ACCOMPLISHMENT OF ALLEGIANT TASK A32X-54-481-002 , NACELLES/PYLON AFT FIXED FAIRING RHS UPPER SPAR AT SEALING RIB 15 O/B AREA WITH CRACK INDICATION.AFT FIXED FAIRING UPPER SPAR WAS REPARED FOLLOW REPAIR INSTRUCTIONS PER ALLEGIANT ENGINEERING ORDER A32X-SDR EE4Y2025103123399Window Frame · crackedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-53-212-020, UPPER FUSELAGE COCKPIT LATERAL WINDOW FRAME AT FR4 RH VERTICAL STIFFENER WITH CRACK WAS FOUND.STIFFENER WAS REPAIRED FOLLOW REPAIR INSTRUCTIONS PER ALLEGIANT ENGINEERING ENGINEERING ORDER A32X-STR-53SDR DALA2025103107976Bottle · low pressureR2 DOOR ASSIST LOW. SERVICED BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (8148865)SDR DALA2025103107974Frame · damagedRT SIDE FRAME 26.1 DAMAGED. ON FWD SIDE, NEAR STR 5. REPAIRED PER ERA 628200-14 REV ORIG. (1281447)SDR DALA2025103107973Frame · damagedFRAME 40.2 RT SIDE TOOLING DAMAGE ON FRAME. REPAIRED PER SRM 51-21-11 AND DRAWING F53938001. (1281081)SDR DALA2025103107972Frame · damagedMISDRILLED HOLE SUSPECT TOOLING DAMAGE UNDER RIVET HEAD. LT SIDE C26.4. CORRECTED PER ERA 628200-14 REV ORIGINAL. (1281500)SDR FDEA202510312117Skin · corrodedRIGHT INBD AILERON UPPER SURFACE OUTBOARD SIDE TRAILING EDGE AREA FOUND CORRODED. RIGHT HAND INBOARD AILERON ASSEMBLY REMOVED AND REPLACED AS PER AMM 27-10-20-4. NEUTRAL POSITION ADJUSTMENT AND TEST CARRIED OUT FOUND SATISFACTORY AS PER AMM 27-10-00-5. RSDR CALA2025103110788Elec Connector · disconnectedEMERGENCY LIGHTS OPS TEST WITH THE TEST SWITCH PROCEDURE. ROW 9 FLOOR EMERGENCY LIGHT INOPERATIVE, FOUND CONNECTOR BETWEEN SEAT ROW FLOOR AND SEAT ASSY DISCONNECTED, RECONNECTED. OPS CHECKED GOOD IAW AMM 33-51-00-715-003.SDR CALA2025103110775Light · inoperative39D AND 41D EMERGENCY EXIT LIGHTS HANGING UNDER THE SEAT 39D. ESCAPE LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS, OK FOR SERVICE.SDR KCSA202510311223Battery · inoperativePIREP LP# 100273983 R1 DOOR EPAS BATTERY SAFETY ARM STUCK IN DISARMED POSITIONSDR REXA2026072701133Skin · crackedCRACK ON AFT UPPER BRACKET AT LH FWD AND AFT OVER WING EMERGENCY-EXIT STRUCTURE. AFT UPPER BRACKET AT LH FWD AND AFT OVERWING EMERGENCY-EXIT STRUCTURE WERE REPAIRED REO 670-52-21-103 REV: --SDR REXA2026072701132Bracket · crackedCRACK ON AFT UPPER BRACKET AT LH FWD AND AFT OVER WING EMERGENCY-EXIT STRUCTURE. AFT UPPER BRACKET AT LH FWD AND AFT OVERWING EMERGENCY-EXIT STRUCTURE WERE REPAIRED REO 670-52-21-103 REV: --SDR REXA202601134Bracket · crackedCRACK ON AFT UPPER BRACKET AT RH AFT OVERWING EMERGENCY-EXIT STRUCTURE AFT UPPER BRACKET AT RH AFT OVERWING EMERGENCY-EXIT STRUCTURE WERE REPAIRED PER REO 670-52-21-103 REV: REV: --SDR 2026FA0000564Antenna · vibrationVHF 2 BELLY MOUNTED ANTENNA VIBRATIONS FELT BY FLIGHT CREW. EXTENDED NOSE (KIT 130-4050) AND EXTENDED NOSE EO/IR LIFT (KIT 130-4051) INSTALLED. THE VHF 2 ANTENNA VIBRATES DURING FLIGHT WITH THE EO/IR TURRET IN THE EXTENDED POSITION. THE VIBRATION IS BELIEVED SDR 2026FA0000563Door · improper stowNOSE LANDING GEAR DOORS PARTIALLY OPEN DURING FLIGHT WITH GEAR RETRACTED. TEXTRON AVIATION INC. B300 EQUIPPED WITH TEXTRON AVIATION INC. EXTENDED NOSE (KIT 130-4050) AND EXTENDED NOSE EO/IR LIFT (KIT 130-4051). NOSE LANDING GEAR DOORS PARTIALLY OPEN DURING FLI