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 AALA202507185241Wire Harness · damagedAIRCRAFT WAS GROUNDED: 22C WHITE SEAT MOUNTED EMERGENCY AISLE LIGHT INOP. MAINTENANCE REPLACED HARNESS 5409VB AT SEAT 22C IAW AWM 33-51-08.Jul 16, 2025 · N655AW · Airbus A320232 · Light System WiringSDR CALA2025071806737Access Panel · missingNUMBER 2 ENGINE INBD PYLON MISSING ACCESS PANEL 443 CL. INSPECTED INSIDE PYLON, NO DAMAGE NOTED. ALL DUCTS SECURE. ONE STRUT PRESSURE RELIEF DOOR MISSING.Jul 16, 2025 · N775UA · Boeing 777222 · Nacelle/Pylon, Plate/SkinSDR CALA2025071806711Lamp · inoperativeAFT RIGHT EMERGENCY LIGHT INOPERATIVE ON OVERHEAD BIN. RELAMPED IAW AMM 33-51-05-002-001. OPS TEST GOOD.Jul 16, 2025 · N12109 · Boeing 757224 · Emergency LightingSDR CALA2025071806710A/C Pack · inoperativeLT FWD EMERGENCY LIGHT BULB INOPERATIVE. REPLACED BULB.Jul 16, 2025 · N37434 · Boeing 737924ER · Emergency LightingSDR CALA2025071806703Skin · dentedREMOVE AND REPLACE AFT CARGO DOOR EXTERNAL SKIN. REMOVED AND REPLACED AFT CARGO EXTERAL DOOR SKIN IAW SRM 52-30-01-2R-3 AND 51-40-02-0G-0.Jul 16, 2025 · N73283 · Boeing 737824 · Cargo/Baggage DoorsSDR CALA2025071806702Strap · corrodedMAIN CABIN FWD WET AREA CORROSION AT RT INNER CHORD BETWEEN STA 294.5 - 328. INSTALLED NEW INNER CHORD AT R/H R-1 DOOR LOWER SILL IAW SRM 51-40-02-0G-0, DWG: 141A8310.Jul 16, 2025 · N17244 · Boeing 737824 · Fuselage Miscellaneous StructureSDR CALA2025071806701Strap · crackedMAIN CABIN FWD WET AREA CRACK AT LH INNER CHORD STA 309. REMOVED AND REPLACED L-1 INNER CHORD REF SRM 51-40-02 DWG 141A8110.Jul 16, 2025 · N17244 · Boeing 737824 · Fuselage Miscellaneous StructureSDR CALA2025071806700Strap · corrodedMAIN CABIN FWD WET AREA CRACKED AT RT INNER CHORD STRAP BS 294.5+3. REMOVED AND REPLACED MAIN CABIN FWD WET AREA RH INNER CHORD STRAP AT STA 294.5+3". REF: SRM 51-40-02-0G-0. DWG# 141A310 R-1.Jul 16, 2025 · N17244 · Boeing 737824 · Fuselage Miscellaneous StructureSDR CALA2025071806699Floor Support · crackedMAIN CABIN FWD WET AREA CRACKED AT FLOOR SUPPORT LBL 47, BS 344-328. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0 & DWG #141A5400.Jul 16, 2025 · N17244 · Boeing 737824 · Fuselage Miscellaneous StructureSDR DALA2025071705411Stringer · damagedSHIP 3412 FOUND MULTIPLE HOLES IN STRINGERS L1, L2, R1, R2 AT FR C64 UNINSPECTABLE. COMPLIED WITH E/RA 627660-14. (1086960).Jul 16, 2025 · N412DX · Airbus A330941 · DoorsSDR DALA2025071705406Stringer · damagedSHIP 3412 VIASAT OVERSIZED HOLE REPAIR OF STR 1L NEAR FR 64 WITH REINFORCEMENT STRAP. COMPLIED WITH ER/A 627660-14. (1085946).Jul 16, 2025 · N412DX · Airbus A330941 · Fuselage Main, Longeron/StringerSDR SWAA2025071792185Bustle · out of positionAFT ENTRY DOOR SLIDE LOOSE IN BUSTLE REPACKED AFT ENTRY DOOR SLIDE PER MT 725-61-06<[01] REPOSITIONED AFT ENTRY DOOR SLIDE PER MT 725-61-06.Jul 16, 2025 · N436WN · Boeing 7377H4 · Escape SlideSDR SWAA2025071791574Battery · failedTHE OUTBOARD FLASHLIGHT INSTALLED AT THE RIGHT; AFT FLIGHT ATTENDANTS SEAT FAILED ITS CHECK. THE OUTBOARD FLASHLIGHT INSTALLED AT THE RIGHT AFT FLIGHT ATTENDANTS SEAT FAILED ITS CHECK.<[01] REMOVED AND REPLACED THE BATTERY IN THE OUTBOARD FLASHLIGHT INSTALLED Jul 16, 2025 · N8696E · Boeing 7378H4 · Emergency EquipmentSDR SWAA2025071791668Isolation Mount · brokenAFT ENTRY DOOR FORWARD SLIDE ATTACH BRACKET HAS TWO BROKEN MOUNT ISOLATORS. R & R IAW SRM 51-40-02.Jul 16, 2025 · N216WR · Boeing 7377H4 · Emergency EquipmentSDR SWAA2025071792021Battery Pack · inoperativeEMERGENCY LIGHTS ON ROW 6 - 14 OVERHEAD BINS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK M1676 AND PERFORMED GOOD OPS CHECK IAW AMM 33-51-06. REMOVED AND REPLACED BATTERY PACK M1676 AND PERFORMED GOOD OPS CHECK IAW AMM 33-51-06.Jul 16, 2025 · N8541W · Boeing 7378H4 · Emergency LightingSDR SWAA2025071792156Battery Pack · inoperativeLEFT & RIGHT OVERWING FWD DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED IAW AMM 33-51-06-960-805-NG (POWER SUPPLY - BATTERY PACK REPLACEMENT - PERMANENT).Jul 16, 2025 · N8541W · Boeing 7378H4 · Emergency LightingSDR SWAA2025071792025Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED 1 EA L1 DOOR EMERGENCY LIGHTS BATTERY PACK AND OPS CHECK GOOD IAW SWA AMM 33-51-06-960-805.Jul 16, 2025 · N8664J · Boeing 7378H4 · Emergency LightingSDR SWAA2025071791642Handle · looseFWD ENTRY DOOR UPPER ASSIST HANDLE LOOSE. SECURED FWD ENTRY DOOR UPPER ASSIST HANDLE IAW AMM 20-50-11.Jul 16, 2025 · N483WN · Boeing 7377H4 · Passenger/Crew DoorsSDR SWAA2025071792178Bracket · looseENTRY GIRT BAR ATTACHMENT LOOSE. ADJUSTED GIRT BAR ATTACH BRACKET PER SIP; OPS CK GOOD.Jul 16, 2025 · N7852A · Boeing 73771B · Emergency EquipmentSDR SWAA2025071791627Handle · looseFWD ENTRY DOOR UPPER ASSIST HANDLE LOOSE. SECURED FWD ENTRY DOOR L1 UPPER ASSIST HANDLE REF AMM 20-50-11.Jul 16, 2025 · N8736J · Boeing 7378 · Passenger/Crew DoorsSDR SWAA2025071791643Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. SECURED FWD GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.Jul 16, 2025 · N483WN · Boeing 7377H4 · Service DoorsSDR SWAA2025071791626Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. SECURED FWD GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.Jul 16, 2025 · N8736J · Boeing 7378 · Service DoorsSDR SWAA2025071791628Handle · looseAFT GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. SECURED AFT GALLEY SERVICE DOOR R2 ASSIST HANDLE REF AMM 20-50-11.Jul 16, 2025 · N8736J · Boeing 7378 · Service DoorsSDR SWAA2025071791658Skin · delaminatedON POST DOCK WALK AROUND FOUND LOWER SURFACE OF RIGHT WING OUTBOARD AFT FLAP HAS EVIDENCE OF DELAMINATION MEASURING 10 BY 16 AT INBOARD AFT CORNER. REMOVED RH WING; OTBD FLAP IAW AMM 27-51-22. REMOVED AND REPLACED RIGHT WING OUTBOARD AFT FLAP IAW AMM 27-51-2Jul 16, 2025 · N8631A · Boeing 7378H4 · Trailing Edge FlapsSDR SWAA2025071791919Fairing · missingNR 6 FLAP CANOE AFT FARING HAS MULTIPLE MISSING ;LOOSE AND PULLED FASTENERS. REMOVED AND REPLACED #6 CANOE AFT FAIRING PER AMM 27-51-18 AND REPLACED DAMAGED FASTENERS AS REQUIRED PER SOPM 20-50-02.Jul 16, 2025 · N8640D · Boeing 7378H4 · Trailing Edge FlapsSDR DALA2025071705396Unknown · odorSHIP 3128 ODOR IN COCKPIT ON DESCENT. T/S AND C/W A319 WORKCARD 0550-2002. (7281732).Jul 16, 2025 · N328NB · Airbus A319114 · Air Distribution SystemSDR DALA2025071705395Flap Track · corrodedSHIP 3130 CORROSION FITTING SUPPORT FLAP ON SPHERICAL BEARING TRACK 3 O/B FLAP RT WING. COMPLIED WITH ER/A 627155-14. (1086470).Jul 16, 2025 · N330NB · Airbus A319114 · Trailing Edge FlapsSDR DALA2025071705394Stop Pad · brokenSHIP 3155 BROKEN DOOR STOP PASSENGER CREW DOOR 831 LOCATED AT LEVEL BEAM 1 AND FWD POSITION AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED DOOR STOP 1 FWD SIDE ON PASSENGER CREW DOOR 831 AS PER A320 FAM AMM 52-11-31-000-002-A AND AS PER A320 FAM AMM 52-11- 31Jul 16, 2025 · N355NB · Airbus A319114 · Passenger/Crew DoorsSDR DALA2025071705393Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND ON FRAME 16 LH DOUBLE JOGGLE AREA HOLE C DOOR STOP FITTING 7. CORRECTIVE ACTION: COMPLIED WITH ER/A 626760-14AD. (1085935).Jul 16, 2025 · N330NB · Airbus A319114 · Fuselage Main, StructureSDR DALA2025071705392Door Frame · crackedSHIP 3130 CRACK INDICATION ON FRAME 16 AT FWD GALLEY AREA (LH DOUBLE JOGGLE ARE A HOLE 6 DOOR STOP FITTING 7. COMPLIED WITH ER/A 626760-14AD. (1085926).Jul 16, 2025 · N330NB · Airbus A319114 · Fuselage Main, StructureSDR DALA2025071705390Skin · dentedSHIP 3130 DENT EXTERNAL SKIN LOCATED AT FR 66 BTW STR 41R TO STR 42R AT LOWER FUSELAGE. CORRECTIVE ACTION: COMPLIED ER/A 627650-14AD. (1087796).Jul 16, 2025 · N330NB · Airbus A319114 · Fuselage Main, Plate/SkinSDR DALA2025071705389Receptacle · corrodedSHIP 3146 PYLON NUMBER 2 PYLON SPIGOT RECEPTACLE FITTING BORE WITH CORROSION. REPLACED SPIGOT FITTING AT PYLON NUMBER 2 IAW A319 SRM TASK 54-51-12-300-001. (1086556).Jul 16, 2025 · N346NB · Airbus A319114 · Nacelle/Pylon, Main FrameSDR DALA2025071705388Ball Joint · scratchedSHIP 3146 ENGINE PYLON #1 UPPER SURFACE SPIGOT BALL JOINT WITH SCRATCH AND LOWER SPIGOT FITTING WITH CORROSION. REPLACED SPIGOT FITTING AT PYLON NUMBER 1 IAW A319 SRM TASK 54-51-12-300-001. (1086356).Jul 16, 2025 · N346NB · Airbus A319114 · Nacelle/Pylon, Main FrameSDR AALA202507179007Carriage · crackedAIRCRAFT WAS GROUNDED: F/O SLIDING WINDOW CARRIAGE IS CRACKED AND REQUIRES REPLACEMENT. MAINTENANCE REMOVED AND REPLACED F/O SLIDING CARRIAGE IAW CMM 56-11-17Jul 16, 2025 · N773AN · Boeing 777223 · Flight Compartment WindowsSDR AALA202507170042Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: DURING EMERGENCY LIGHTS PS CHECK FOUND ROWS 37 HGED-40 HGED EMERGENCY LIGHTS INOP. MAINTENANCE FOUND EMERGENCY LIGHT J1 CONNECTOR DISCONNECTED UNDER SEAT 37 HGED. RE-CONNECTED IAW WDM 33-51-58.Jul 16, 2025 · N758AN · Boeing 777223 · Light System WiringSDR AALA202507174356Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 5 RH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #5 RH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.Jul 16, 2025 · N826AW · Airbus A319132 · Elevator StructureSDR AALA202507176566Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 6 RH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #6 RH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.Jul 16, 2025 · N826AW · Airbus A319132 · Elevator StructureSDR AALA202507170746Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FWD EMERGENCY BULLHORN INOP. BATTERY DEAD. MAINTENANCE REPLACED FWD BULLHORN AS REQUIRED IAW 25-00.Jul 16, 2025 · N749US · Airbus A319112 · Emergency EquipmentSDR GTIA2025071738993Vent · inoperativeVENT AVNCS SYS FAULT-ACCOMPLISHED FAULT ISOLATION IAW TSM 21-26-00-810-853-A DO TO HISTORY AND PRIOR CORRECTIVE ACTION R&R AEVC 10HQ IAW AMM 21-26-34 PB401 OPERATIONAL TEST SATISFACTORY NO FAULTS NOTEDJul 16, 2025 · N672NK · Airbus A321231 · Air Distribution SystemSDR AALA202507177880Relay · inoperativeAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS THAT MULTIPLE CABIN AND EMERGENCY EXITLIGHTS ARE NOT WORKING. ACCOMPLISHED TROUBLESHOOTING, PER WDM 33-21-11. REMOVED AND REPLACED RELAY R120, PER AMM 20-10-07-201. ACCOMPLISHED OPERATIONAL TEST, PER AMM 33-21-00Jul 16, 2025 · N927NN · Boeing 737823 · Emergency LightingSDR AALA202507177401Unknown · odorAIRCRAFT WAS GROUNDED: STRONG FISH LIKE ODOR AROUND THE MIDDLE OF CABIN. ALSO PREVALENT AS WHEN YOU APPROACH AIRCRAFT FROM JETBRIDGE. (OPEN).Jul 16, 2025 · N343SY · Boeing 7378 · Air Distribution SystemSDR AALA202507177323Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN, THE LAVATORY-D DOOR HINGE IS BINDING. LUBED DOOR HINGES, OPERATIONAL CHECK NORMAL. PER AMM 25-40-14.Jul 16, 2025 · N919AN · Boeing 737823 · Fixed Inner DoorsSDR AALA202507174387Slide · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORT THAT R1 DOOR SLIDE IS SHOWING PART OF THE SLIDE OUT OF THE SLIDE COVER AROUND THE BOTTOM PART. SECURED R1 DOOR SLIDE. PER AMM 25-66-01.Jul 16, 2025 · N806NN · Boeing 737823 · Escape SlideSDR AALA202507170353Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS ADVISED LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. READJUSTED AFT LAVATORY-D TOP DOOR RAIL SCREW IN POSITION. OPERATIONAL CHECKED GOOD. PER CMM 26-40-64.Jul 16, 2025 · N803NN · Boeing 737823 · Fixed Inner DoorsSDR AALA202507175806Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR GIRT BAR STOWED BRACKETS ARE REPORTED TO TIGHT TO DETACH GIRT BAR. LUBED GIRT BAR. PER AMM 25-66-01. OPERATIONAL CHECK GOOD.Jul 16, 2025 · N966AN · Boeing 737823 · Emergency EquipmentSDR AALA202507177332Sill Drain · odorAIRCRAFT WAS GROUNDED: AFTER LANDING FLIGHT ATTENDANTS IN THE AFT CABIN REPORTED A STINKY DIRTY DIAPER OR SULPHUR LIKE SMELL UPON LANDING AND SAID NOTICED IT SLIGHTLY DURING TAKEOFF AS WELL. SWITCHED AIRFLOW FROM ENGINE BLEEDS TO APU BLEED AND REMAINED UNTIL Jul 16, 2025 · N339PL · Boeing 737823 · Fuselage Main, StructureSDR AALA202507170509Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER RAISING THE GEAR HANDLE, RIGHT MAIN GEAR LIGHT STAYED RED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. (OPEN).Jul 16, 2025 · N941AN · Boeing 737823 · Landing Gear Retraction/Extension SystemSDR HALA20250717219Pdu · inoperativeETOPS - FOUND PDUS 21R, 22R, + 32R IN MCD INOP. REMOVED & REPLACED PDUS 21R,22R & 32K IAW A330 AMM 25-56-62. OPS CHECK OF 21R, 22R, 32K. GOOD.Jul 16, 2025 · N5869K · Airbus A330343 · Cargo CompartmentsSDR HALA20250717218Liner · tornETOPS - AFT BULK CARGO LINER TORN TYPE A WITH SCREEN. REMOVED & REPLACED AFT CARGO LINER IAW A330 25-53-00 + 25-54-00.Jul 16, 2025 · N5869K · Airbus A330343 · Fuselage Miscellaneous StructureSDR HALA20250717217Bmc · faultedETOPS - BTB DUE TO BLEED AIR RIGHT WING LEAK. REMOVED AND REPLACED THE BMC 2 PER AMM 36-11-34. SYS TEST OK. A/C OK FOR SVC.Jul 16, 2025 · N386HA · Airbus A330243 · Engine Bleed Air System