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.

SDR ASAA2025072859718Battery Pack · no testWHILE WORKING T/C 78233001, BATTERY PACKS M2627, M1671 FAILED TEST. GROUNDED - YES. REPLACED BATTERY PACKS M2627, AND M1671 REF AMM 33-51-06-960-805. OPS CHECK GOOD.Jul 28, 2025 · N270AK · Boeing 737924ER · Emergency LightingSDR AALA202507291271Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LOCK STICKS AND IS DIFFICULT TO UNLOCK. LUBRICATED LAVATORY-D DOOR LOCK MECHANISM. OPERATIONAL CHECKS GOOD.Jul 28, 2025 · N953NN · Boeing 737823 · Fixed Inner DoorsSDR AALA202507293746Bracket · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT FORWARD SERVICE DOOR GIRT BAR IS DIFFICULT TO CLIP INTO AND REMOVE FROM THE FLOOR BRACKETS, AND REQUIRE MORE FORCE THAN USUAL. LUBED BRACKETS FROM FLOOR AREA. REF AMM 25-66-02.Jul 28, 2025 · N849NN · Boeing 737823 · Emergency EquipmentSDR AALA202507296072Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR INOPERATIVE. ADJUSTED LAVATORY DOOR LOCK. PER AMM 25-40-00. OPERATIONAL CHECK GOOD.Jul 28, 2025 · N837NN · Boeing 737823 · Fixed Inner DoorsSDR AALA202507298866Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPERATE, STICKING ON BOTTOM SCUFFPLATE. ADJUSTED LAVATORY-A DOOR HINGE. PER CMM 25-46-96. OPERATIONAL CHECK GOOD.Jul 28, 2025 · N843NN · Boeing 737823 · Fixed Inner DoorsSDR AALA202507293450Light · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 22C PASSENGER SEAT EMERGENCY EXIT LIGHT HANGING FROM SEAT. RESECURED EMERGENCY LIGHT AT SEAT 22C AS REQUIRED.Jul 28, 2025 · N930AN · Boeing 737823 · Emergency LightingSDR AALA202507290607Fuel Line · leakingAIRCRAFT WAS GROUNDED: FUMES OF FUEL CAN BE SMELLED THROUGHOUT THE AIRCRAFT. ACCOMPLISHED JC 08L00021001, FOUND FUEL LEAK TO BE COMING FROM NGS SYSTEM TUBE. TIGHTENED TUBE, PER AMM 20-10-51. LEAK CHECK GOOD.Jul 28, 2025 · N944AN · Boeing 737823 · Fuel StorageSDR AALA202507293013Door · lack of lubeAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR WILL NOT OPEN CABIN SIDE. LUBRICATE COCKPIT DOOR STRIKE ASSEMBLY. PER AMM 52-51-00. OPERATIONAL CHECK GOOD.Jul 28, 2025 · N944AN · Boeing 737823 · Fixed Inner DoorsSDR AALA202507297184Hydraulic System · abnormalAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: REPEAT ITEM, AFTER TAKEOFF UPON RAISING OF GEAR ENGINE NUMBER ONE HYDRAULIC LOW PRESSURE AND ELECTRICAL 2 HYDRAULIC LOW PRESSURE LIGHTS ILLUMINATED. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IAD. **SUPPLJul 28, 2025 · N815NN · Boeing 737823 · Hydraulic System, MainSDR MTNA20250729001Oxygen Mask · no testFO'S OXYGEN MASK WOULD NOT TEST PROPERLY. MX: RAI #2 CREW OXTGEN MASK STOAGE COMPARTMENT IAW BE AEROSPACE MM 35-10-87.Jul 28, 2025 · N821FX · Aerosp ATR72212 · Crew Oxygen SystemSDR DALA2025072905704Oil System · leakingSHIP 3261 DIRTY SOCK ODOR DETECTED WHEN CATERING AIRCRAFT. BEGAN INSPECTION PER TASK CARD 4900-2001, STEPS 1 & 2 COMPLETED. COMPLIED WITH STEP A, DEBRIEF FLIGHT CREW & ENSURE THE LOD PAGE IN ACCURATE. COMPLIED STEP B. COMPLIED WITH STEP C; ENSURE THE ELEC SJul 28, 2025 · N361NW · Airbus A320212 · APU Oil SystemSDR AALA202507291348Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500B AND BS 500C AT S26L. REPLACED BAFFLE PER AARD 51-00-05-1.Jul 28, 2025 · N972AN · Boeing 737823 · Fuselage Miscellaneous StructureSDR AALA202507298868Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 943, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.Jul 28, 2025 · N972AN · Boeing 737823 · Fuselage Miscellaneous StructureSDR QXEA2025072900285Throttle · malfunctionedBOTH ENGINE THRUST LEVERS NOT MOVING TO IDLE REVERSE THRUST WITHOUT FORWARD LEVER PRESSURE. THRUST REVERSER FUNCTION APPERS NORMAL BASED ON TLA.. REMOVED FROM SERVICE. REMOVED AND REPLACED THROTTLE CONTROL QUADRANT ASSEMBLY IAW AMM 76-11-01-000-801-A, 76-11-01Jul 28, 2025 · N652MK · Emb ERJ170200LR · Auto Throttle SystemSDR QXEA2025072900284None · noneFLIGHT 2209. ENCOUNTRED WAKE TURBULENCE WITH SUBESEGUENT ROLLS LT & RT +/- 15 DEGREES - 20 DEGREES. LANDED UNEVENTFUL. REMOVED FROM SERVICE. PERFORMED EFOQA DOWNLOAD, REF AMM MCN E310015-01 ISSUE NR 2. PERFORMED PHASE 1 SEVERS TURBULANCE INSPECTION, IAW AMM 05Jul 28, 2025 · N631QX · Emb ERJ170200LR · Standard Practices/StructuresSDR HALA20250729236Bleed Valve · faultedETOPS - AIR ENG 1 BLEED FAULT AFTER TAKEOFF RESET SUCCESSFUL. REMOVED AND REPLACED #1 ENG PRV PER AMM 36-11-12. OPS & LEAK CHECK OK. OK FOR SERVICE.Jul 28, 2025 · N375HA · Airbus A330243 · Compressor Bleed ValveSDR DALA2025072905691Stringer · damagedSHIP 3416 TOOLING DAMAGE ON FITTING AND STRINGER 1L FORWARD SIDE OF 63. CORRECTIVE ACTION: REPAIRED PER ERA 627525-14 REV ORIG. (1111536)Jul 28, 2025 · N416DX · Airbus A330941 · Fuselage Main, Longeron/StringerSDR DALA2025072905690Frame · damagedSHIP 3416 AT FRAME C64, EVIDENCE OF TOOLING DAMAGE ON THE LH STRINGER P1 O/B SIDE. CORRECTIVE ACTION: STRINGER REPLACED PER ERA 627516-14 REV ORIG. (1111483)Jul 28, 2025 · N416DX · Airbus A330941 · Fuselage Main, FrameSDR DALA2025072905688Frame · damagedSHIP 3416 TOOLING DAMAGE ABOVE LAST FASTENERS IN STIFFENER ON FORWARD SIDE OF 62 @ STRINGER 1L. CORRECTIVE ACTION: STRINGER REPLACED PER ERA 627516-14 REV ORIG. (1111506)Jul 28, 2025 · N416DX · Airbus A330941 · Fuselage Main, FrameSDR DALA2025072905686Frame · damagedSHIP 3416 TOOLING DAMAGE ON AFT END IB SIDE OF STR L1 FORWARD SIDE OF FRAME 61. REPAIRED PER ERA 627516-14 REV ORIG. (1111445)Jul 28, 2025 · N416DX · Airbus A330941 · Fuselage Main, FrameSDR CALA2025072907047Control Switch · faultedENG 2 REV THRUST STICKY ON LANDING. PERFORM THE BITE TEST ON 2 ENGINE REV THE EAU FOUND ONLY ONE FAULT T/R DELOY FAULT DID THE NORMAL OPS TEST SYSTEM WORK UNTIL NOTICE AFTER YOU DELOYED THE HANDLE TO FULL DELOY THE T/R DOES NOT DELOY AND YOU GET THE REV LIGHTJul 28, 2025 · N36280 · Boeing 737824 · Engine Thrust ReverserSDR CALA2025072907046Floorbeam · corrodedMAIN CABIN FWD WET AREA CORROSION AT FLOOR BEAM PREVIOUS REPAIR STA 328 RBL 12" REF AAR N/R 97524617 ACCOMPLISHED INSTALLATION OF NEW REPAIR STRAP AT FLOOR BEAM REPAIR STA 328 RBL 12" AS PER EC/RA#: 5321-01454 AND SRM-51-40-02-0G-0.Jul 28, 2025 · N17244 · Boeing 737824 · Fuselage Main, Floor BeamSDR CALA2025072907045Web · corrodedMAIN CABIN AFT WET AREA CORROSION AT FLOOR WEB STA 986.5+2" RBL 35. REMOVED AND INSTALLED WEB AT FLOOR STA986.5+2, RBL 35" IAW 51-40-02.Jul 28, 2025 · N17244 · Boeing 737824 · Fuselage Miscellaneous StructureSDR CALA2025072907044Cover · detached20C EMERGENCY EXIT LIGHTING MISSING FOUND 20C RED EMERG LIGHT COVER MISSING. REPLACED REF MM 33-51-11. OPS CHECK GOOD.Jul 28, 2025 · N27239 · Boeing 737824 · Emergency LightingSDR CALA2025072907043Lamp · inoperativeLEFT WING AFT EMERGENCY LIGHT INOP. RELAMPED OVERWING EXTERIOR EMERGENCY EXIT LIGHT AND OPS CHECKED IAW AMM 33-51-00 OPS CHECK GOOD.Jul 28, 2025 · N57852 · Boeing 757324 · Emergency LightingSDR CALA2025072907042Flashlight · brokenFOUND DOOR 1L JUMP SEAT FLASHLIGHT BROKEN. REPLACED FLASHLIGHT ASSY AT DOOR 1L JUMP SEAT IAW AMM PER DMC-B787-A-25-64-00-00B-921A-A.Jul 28, 2025 · N29961 · Boeing 7879 · Emergency EquipmentSDR FDEA202507281332Floor Panel · damagedBROKEN MCC FLOOR PANEL 252DFF MCC FLOOR PANEL 252DFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR. 4.B. FIG. 201 SHEET 2 REV. 92, APR 15, 2025.Jul 28, 2025 · N181FE · Boeing 7673S2F · Fuselage Floor PanelSDR FDEA202507281329Floor Panel · damagedMAIN CARGO COMP. AT APROX STA. 350 & RBL11 TO RBL33 FLOORBOARD PANEL 222AFF, SURFACE SKIN HAS INDENTATIONS (MARKED). FABRICATED NEW FLOOR PANEL 222AFF, MPN:141T5856-107, RBL 11 LBL 11, STATION 285-412 IN REF TO BOEING DWG Ï¿½141T5856-107. SEE JPF FOR ALL WOJul 28, 2025 · N269FE · Boeing 7673S2F · Fuselage Floor PanelSDR SCNA20250729286Flap System · lockedON APPROACH FLAPS LOCKED OUT AT 8 WAS ABLE TO SET TO 15 WITH ALTERNATE FLAP EXTENTION - REPLACED FLAP POSITION INDICATOR FOR PRECAUTIONARY REASON. SYSTEM OPS CHECKS GOOD. REF AMM 27-58-02 (DECLARED EMERGENCY)Jul 28, 2025 · N846SY · Boeing 7378 · Trailing Edge Flap Control SystemSDR DXTR2025072901Cap Seal · fracturedWHILE ACCOMPLISHING LT MLG LUBRICATION TASK CARD AMM 12-20-10-612, AND WHILE LUBRICATING INBOARD END OF LT MLG ACTUATOR, FOUND THE END CAP ASSY P/N: 7441511-20 TO BE FRACTURED. THIS END CAP IS DESIGNED TO NOT ONLY RETAIN THE GREASE BUT ALSO CAPTURES THE PIN - Jul 28, 2025 · N830QS · Textrn TEXTRON700 · Main Landing GearSDR NACA20250728001Plug · corroded#4 WINDOW PLUG OF MCD HAS LARGE PIECE OF EXFOLIATED MATERIAL FALLING OFF AT ITS FORWARD LOWER CORNER. REMOVED AND REPLACED #4 WINDOW PLUG IN MCD PER ANCRA INTL WINDOW PLUG INSTALLATION KIT DWG 86734 REV KJul 28, 2025 · N303KH · Boeing 737319 · Fuselage Main, StructureSDR SWAA2025072895930Fuse · leakingAFTER GEAR RETRACTION LOSS OF HYD SYST. A; HYD A ENG1 AND ELEC2 LOW PRESSURE LIGHTS; FLT CTRL A LOW PRESSURE LIGHTS AND FEEL DIFF PRESS LIGHTS ALL ILLUMINATED AND HYDR A QRT WAS ZERO<[01] FOUND MAIN GEAR RETRACT PRESSURE FUSE LEAKING. R/R MAIN GEAR RETRACT FUSJul 28, 2025 · N7744A · Boeing 7377BD · Landing Gear Retraction/Extension SystemSDR 2025F00169Smoke Detector · false activationDURING DESCENT THE AFT BAGGAGE SMOKE DETECTOR ANNUNCIATOR ILLUMINATED.Jul 28, 2025 · N525CR · Cessna 525B · Smoke DetectionSDR GTIA2025072839023A/C Pack · odorFUME EVENT ON SHORT FINAL. DESCRIPTION OF ODOR/FUMES: PERSISTENT, DIRTY SOCKS/ MUSTY DRY/ OIL / OIL BURNING SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. DWD CABIN, MID CABIN, AND AFT CABIN/GALLEY(LAV). NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIJul 28, 2025 · N618NK · Airbus A320232 · Cabin Cooling SystemSDR WX0A2025072832515Cover · broken(AIRCRAFT NOT GROUNDED) WALL MOUNTED EMERGENCY EXIT LIGHT COVER AT L1 PASSENGER DOOR BROKEN. REMOVED AND REPLACED BROKEN DOOR EMERGENCY EXIT LENS IAW AIRBUS AMM 33-35-13-000-001-A AND 33-51-13-400-001-A.Jul 28, 2025 · N259NV · Airbus A320214 · Emergency LightingSDR IPXA2025072856371Acoustic Liner · brokenBROKEN ACOUSTIC LINER, NR 2 ENG FAN CASE MIDDLE 7:00 AREA. OK TO WORK.Jul 28, 2025 · N328UP · Boeing 76734AF · Engine (Turbine/Turboprop)SDR DALA2025072805665Oxygen Mask · unsecureSHIP 3415 4R LAV 02 MASK HANGING. CORRECTIVE ACTION: REPACKED MASKS PER A330 AMM 35-21. (7080054)Jul 28, 2025 · N415DX · Airbus A330941 · Passenger Oxygen SystemSDR DALA2025072805662Frame · damagedSHIP 3416 TOOLING DAMAGE ON FWD SIDE OF FRAM 41 BETWEEN STR 3R AND STR 4R. CORRECTIVE ACTION: REPAIRED PER ERA 627776-14MT REV. ORIG. (1110818)Jul 28, 2025 · N416DX · Airbus A330941 · Fuselage Main, FrameSDR QR9R2025072800001Recorder · over voltageOVERNIGHT BATTERY VOLTAGE DRAINED DOWN TO 22 VOLTS (BATTERY RECENTLY REPLACED). THE FA5001 CVFDR WAS FOUND TO HAVE CONSTANT DRAIN ON BATTERY. REMOVED AND REPLACED CVFDR IAW AMM 31-32-10, 4-1.Jul 28, 2025 · Bolkms BK117C2 · Data Recorders (Flight/Maintenance)SDR JJBA20250728102Rack · crackedREAR FUSELAGE I AVIONIC COMPARTMENT, AT FR 75 AND STR 14R SUPPORT ON ELECTRIC RACK CRACKED. REAR FUSE I AVIONIC COMPARTMENT AT FR 75 AND STR 14R SUPPORT ON ELECTRIC RACK REMOVED AND REPLACEDJul 28, 2025 · N16147 · Emb EMB145XR · Fuselage Main, StructureSDR JJBA20250728099Shear Tie · crackedLH FR 72 BTW STR 16L-17L SHEAR CLIP FOUND CRACKED. AT FR72 BTW STR 16L-17L SHEAR CLIP REMOVED FOR REPLACEMENT. AT FR72 BTW STR 16L-17L INSTALLED.Jul 28, 2025 · N16147 · Emb EMB145XR · Fuselage Internal Mounting StructureSDR UIEA2025072501022Skin · damagedRH INBD FLAP T/E FORE FLAP MIDSECTION UPPER SURFACE HAS A SMALL HOLE 0.250 DIAMETER. ACCOMPLISHED REINFORCING REPAIR ON RH INBD FLAP T/E FORE FLAP UPPER SURFACE PER SRM 51-70-03-0G-0. NO FURTHER DEFECTS NOTED.Jul 28, 2025 · N471MC · Boeing 747412 · Trailing Edge FlapsSDR UIEA2025072501024Skin · damagedRH INBD FLAP T/E FORE FLAP HAS DAMAGE NEAR THE INBD TOGGLE HOOK L/E LOWER SKIN. ACCOMPLISHED REINFORCING REPAIR ON RH INBD FLAP T/E FORE FLAP PER SRM 51-70-07-0G-0 PARG 5A, 4C, 4E & 4G. NO FURTHER DEFECTS NOTED.Jul 28, 2025 · N471MC · Boeing 747412 · Trailing Edge FlapsSDR CALA2025072806938Oven · smokeOVEN 708 SMOKE ON INITIAL CLIMB TURNED OFF PULLED CB NO SMOKE OR FIRE DETECT SMOKE/ODOR QUESTIONAIRE FORM ATTACHED. REMOVED AND REPLACED OVEN IAW AMM REF TASK 25-32-03-000-801.Jul 28, 2025 · N675UA · Boeing 767322 · Cabin Equipment/FurnishingsSDR JGVR2025072800528Manual · inaccurateTHE AMM PROCEDURE FOR THE GROUND SLATS DOES NOT SPECIFY IN THE PROCEDURE THE DIRECTION OF THE BOLT HEAD AND SPACER. THE ILLUSTRATION ASSOCIATED WITH THE TASK COVERS ONLY ONE SIDE OF THE AIRCRAFT AND IS NOT THE EASIEST TO READ PERTAINING TO THE BOLT ORIENTATIONJul 28, 2025 · N44GX · Bombdr BD7001A10 · Standard Practices/StructuresSDR 2025FA0000527Elec Connector · abnormalERRATIC ENGINE OIL PRESSURE INDICATION. REMOVED AND REPLACED ENGINE OIL PRESSURE TRANSDUCER ELECTRICAL CONNECTOR (JN004) P/N S2800-277 (KIT) AT THE TRANSDUCER.Jul 28, 2025 · N260SU · Cessna 172S · Engine Oil System WiringSDR 2025FA0000526Elec Connector · faultedERRATIC ENGINE OIL PRESSURE READINGS. REMOVED AND REPLACED ENGINE OIL PRESSURE TRANSDUCER ELECTRICAL CONNECTOR (JN004) P/N S2800-277 (KIT) AT THE TRANSDUCER.Jul 28, 2025 · N578CA · Cessna 172S · Engine Oil System WiringSDR 3J7R2025072800525Battery · dischargedWHEN THE EMERGENCY LIGHTS SWITCH IS SET TO ARM, THE LAVATORY SEAT OVERHEAD LIGHT, EXIT SIGN FOR THE BULKHEAD BEHIND SEAT SEVEN, EXIT SIGN BELOW THE LAVATORY SEAT, AND THE EVACUATION PATH LIGHTS UNDER THE LAVATORY SEAT DO NOT COME ON.Jul 28, 2025 · N952QS · Cessna 680A · Emergency LightingSDR JJBA20251024078Attach Bracket · crackedRH WING TO FUSELAGE FAIRING ATTACH BRACKET SECOND FROM FDW SIDE OF WING CRACKED. INSTALLED NEW RH WING FAIRING ATTACH BRACKET AND DOUBLER.Jul 27, 2025 · N12135 · Emb EMB145XR · Fuselage, Wing Attach FittingsSDR AALA202510067340Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON OPEN HOLE H1 FR16RH DOOR STOP 7. CRACK DIRECTION 6 AND 8 OCLOCK. CRACK DEPTH 0.100 INCH. MAINTENANCE REPLACED INTERCOSTAL FITTING #7 LOC. BTW FR15 RH AND FR16 RH IAW A319 SRM 51-72-11-911-001 AND DWG #53Jul 27, 2025 · N768US · Airbus A319112 · Fuselage Miscellaneous Structure