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 YENA2025070100667Frame · ground damageDURING HEAVY MAINTENANCE: FUSELAGE / FWD FUSELAGE / FR 5-7 & LH LOWER STRINGER-CENTERLINE / TUG IMPACT. REPAIRED.Jun 28, 2025 · N531JL · Airbus A320232 · Fuselage Main, FrameSDR SCNA20250701237Lamp · inoperativeINOPERATIVE EMERGENCY EXIT LIGHT ON FWD RIGHT OVERWING EMERGENCY EXIT DOOR. REMOVED AND REPLACED LAMP IAW AMM 33-51-01. OPS CHECK GOOD.Jun 28, 2025 · N824SY · Boeing 737800* · Emergency LightingSDR DXTA2025070104077Battery Pack · inoperativeGALLEY FORWARD EMERGENCY EXIT SIGN AND FORWARD EMERGENCY LIGHT FLASH INTERMITTENTLY, AND AFT GALLEY EMERGENCY LIGHT INOP WHEN COCKPIT EMERGENCY LIGHT SWITCH IS IN ON POSITION. CORRECTIVE ACTION; REPLACED #1 & #2 ELPS INTERNAL BATTERY PACKS IAW GL6000 MM 33-51-Jun 28, 2025 · N164QS · Bombdr BD7001A10 · Emergency LightingSDR DXTA2025070104078Oxygen Mask · unwanted deployDURING DESCENT INTO KBZN CABIN LOST PRESSURIZATION AND PASSENGER OXYGEN MASKS DROPPED.AT APPROXIMATELY 11000FT ON APPROACH TO KBZN CABIN LOST PRESSURIZATION. CABIN CLIMBED TO 10000FT THEN DESCENDED TO 8500FT THEN CLIMBED AGAIN AND DESCENDED BACK TO APPROXIMATEJun 28, 2025 · N238QS · Cndair CL6002B16 · Passenger Oxygen SystemSDR DALA2025063004870Crossbeam · crackedSHIP 3169 FOUND CRACKS AT HOLES #2 #3 AND #4 OF CROSS BEAM JUNCTION AREA, FR16LH. CORRECTIVE ACTION: COMPLIED WITH ER/A 627149-14AD. (1051478).Jun 28, 2025 · N369NB · Airbus A319114 · Fuselage Main, StructureSDR DALA2025063004869Unknown · odorSHIP 3154 F/A REPORTS SMELLY SOCK ODOR. CORRECTIVE ACITON: PERFORMED VISUAL INSPECTION OF APU. FOUND NO SIGNS OF OIL CONTAMINATION. REMOVED BLEED SUPPLY VALVE AND INSPECTED DUCT. NO OIL CONTAMINATION PRESENT. CHECK COMPRESSOR BEARING DRAIN NO OIL PRESENT. WORKJun 28, 2025 · N354NB · Airbus A319114 · Air Distribution SystemSDR ASAA2025062859069Lens · detachedFA ADVISES EMER EXIT SIGN AT 16F COVER POPPED OFF. GROUNDED - YES. EXIT LIGHT ASSEMBLY REMOVED AND REPLACED OPS CHECK GOOD REF AMM 33-51-01.Jun 28, 2025 · N932AK · Boeing 7379 · Emergency LightingSDR ASAA2025062859068Power Supply · no testDURING TC 78233001 FOUND CAPACITANCE CHECKS FOR R2 DOR EMERGENCY INT & EXT LIGHTS AND LH OVERWING INT LIGHTS UNSATISFACTORY. GROUNDED - YES. REPLACED POWER SUPPLY L/H, FWD ESCAPE HATCH AND AFT GALLEY R2 EXIT SIGN PSU. REF AMM 35-51-06. OP CHK GOOD.Jun 28, 2025 · N565AS · Boeing 737890 · Emergency LightingSDR HALA20250630037Warning Message · false activationATB - LEFT GEAR INDICATION RED/UNSAFE WITH GEAR HANDLE UP AFTER TAKE OFF. JACKED UP THE AIRCRAFT PER AMM 07-00-582-811. PERFORMED FUNCTIONAL TEST OF MLG AND NLG EXTENSION AND RETRACTION PER AMM 32-30-00. NO DEFECTS NOTED. PERFORMED SENSOR READOUTS FOR LT AND RJun 28, 2025 · N478HA · Boeing 717200 · Landing Gear Position and WarningSDR QXEA2025063000270Pin · installedFLIGHT 2146. L2 (AFT PASSENGER DOOR) DOOR PNUEMATIC ASSEMBLY SAFETY PIN FOUND INSTALLED. REMOVED FROM SERVICE. REMOVED PIN FROM EMERGENCY OPENING SYSTEM ACCUMULATOR ON L2 DOOR AS PER AMM 52-00-23-900-801-A NO DAMAGE FOUND. STOWED PIN IN FLIGHT DECK LEFT AFT STJun 28, 2025 · N636QX · Emb ERJ170200LR · Passenger/Crew DoorsSDR AALA202506306224Oil System · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: INFLIGHT ENGINE SHUTDOWN DUE TO LOW OIL PRESSURE ON NUMBER 1 ENGINE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CHA. (OPEN).Jun 28, 2025 · N938NN · Boeing 737823 · Engine Oil PressureSDR SWAA2025063086288Flashlight · intermittentCAPT SIDE AFT I/B EMERGENCY FLASHLIGHT PUSH TO TEST INTERMITTENT.<[01] REMOVED AND REPLACED CAPTAINS SIDE AFT FA I/B EMERGENCY FLASHLIGHT IAW AMM 25-64-00.Jun 28, 2025 · N8503A · Boeing 7378H4 · Emergency EquipmentSDR SWAA2025063086503Flashlight · inoperativeLEFT AFT CABIN EMERGENCY FLASHLIGHT WILL NOT TEST.<[01] REMOVED ALL AFT FLASHLIGHTS REINSTALLED OPS CHECK GOOD REAPPLIED EMERGENCY SEAL REF AMM 25-64-00Jun 28, 2025 · N8558Z · Boeing 7378H4 · Emergency EquipmentSDR SWAA2025063086368Slide · dislodgedFORWARD ENTRY DOOR SLIDE FELL OUT OF BOX<[01] REINSTALLED FWD ENTRY DOOR ESCAPE SLIDE IN THE COMPARTMENT AND THE COMPARTMENT ASSEMBLY PER MT 725-61-06 & AMM 25-66-01.Jun 28, 2025 · N250WN · Boeing 7377H4 · Escape SlideSDR SWI2025F00771Valve · faultedPRKG BRK NOT RELEASED IN FLT, RAN QRH PROCEDURE MESSAGE EXTINGUISHED MESSAGE CAME BACK UP ON APPROACH & RAN PROCEDURE AGAIN MESSAGE EXTINGUISHED AGAIN PROCEDURE FOLLOWED FOR PRECAUTION (FLIGHT 5644) TROUBLESHOT PER FIM 32-41-00-810-863-A. R & R EMER PRKG BRK Jun 28, 2025 · N82366 · Emb ERJ170200LL · Landing Gear Brake SystemSDR SWI2025F00770Control Valve · faultedL BLEED DUCT WARNING AND CAUTION MESSAGE IN FLIGHT. PERFORMED QRH PROCEDURE SUCCESSFULLY. (FLIGHT 6447 - FILED CLOSED)THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30398967 WITH THE FOLLOWING CORRECTIVE ACTION: "INTERROGATED MDC, FOUND B1-349536, ALSO FOUND LJun 28, 2025 · N603SK · Cndair CL6002C10 · Cabin Cooling SystemSDR SWIA202506300028Skin · gouged3 GOUGES TO FUSELAGE SKIN BETWEEN FS589.00 - FS605.00 AND STR 23R-24R (FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSJun 28, 2025 · N963SW · Cndair CL6002B19 · Fuselage Main, Plate/SkinSDR AALA202506307142Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT INOP ABOVE 2G SEAT, CEILING AREA. MAINTENANCE REPLACED 2G EMERGENCY LIGHT SOCKET IAW AMM 33-51-03.Jun 28, 2025 · N723AN · Boeing 777323ER · Emergency LightingSDR AALA202506307149Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ROW 15 FELL OFF WALL. RESECURED OVERWING EMERGENCY EXIT SIGN LENS, PER AMM 33-51-01.Jun 28, 2025 · N966AN · Boeing 737823 · Emergency LightingSDR AALA202506301360Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT IN 30C IS BROKEN OFF THE SEAT. REINSTALLED EMERGENCY LIGHT ON SEAT 30C. PER AMM 33-51-03.Jun 28, 2025 · N306RC · Boeing 7378 · Emergency LightingSDR AALA202506304191Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR STICKS AND IS HARD TO OPEN. INSPECTED AND READJUSTED LAVATORY-D DOOR. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.Jun 28, 2025 · N965NN · Boeing 737823 · Fixed Inner DoorsSDR AALA202506307826Hinge · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR REPORTED HARD TO PULL OPEN OR CLOSED. SECURED LOOSE DOOR HINGE HARDWARE.Jun 28, 2025 · N338PK · Boeing 737823 · Fuselage, Door HingeSDR AALA202506307713Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: A PIECE OF EMERGENCY SLIDE IS COMING OUT OF THE BOARDING DOOR. ADJUSTED L1 DOOR GIRT BAR. PER AMM 25-61-00. OPERATIONAL CHECK GOOD.Jun 28, 2025 · N327SK · Boeing 7378 · Emergency EquipmentSDR UIEA2025062500802Skin · debondedSKIN, LOWER SURFACE OF L/H WING INBD AFT FLAP INBD SIDE. PERFORM PERMANENT REPAIR - UPGRADE THE EXISTING REPAIR ON LOWER PANEL OF LT WING INBD AFT FLAP IAW EGAT EI NR: T2025A57M-1065 REV 1. CONDITION CHECK IS SATISFACTORY.Jun 28, 2025 · N429MC · Boeing 747481 · Trailing Edge FlapsSDR UIEA2025062500803Repair · debondedRIGHT WING INBD FORE FLAP UPPER INBD PANEL EXISTING REPAIR DOUBLER DISBOND. PERFORM PERMANENT REPAIR - UPGRADE THE EXISTING REPAIR ON TOP PANEL OF RH WING INBD FORE FLAP IAW EGAT EI NR. T2025A57M-1096 REV 1. CONDITION CHECK IS SATISFACTORY.Jun 28, 2025 · N429MC · Boeing 747481 · Wing, Plate/SkinSDR UIEA2025062500804Skin · corrodedCORROSION ON R/H WING UPPER SKIN UPPER SURFACE NEAR WBL 1193. BLEND OUT THE CORROSION AREA IAW SRM 51-10-02-0G-0 REV 62. ACCOMPLISHED REPAIR AREA IAW EI NR: T2025A57M-1057 REV 2. COMPLETED JOB AND CONDITION CHECK NORMAL.Jun 28, 2025 · N429MC · Boeing 747481 · Wing, Plate/SkinSDR UIEA2025062500805Skin · corrodedCORROSION ON LT WING UPPER SKIN UPPER SURFACE NEAR WBL 1217.133. . REPAIRED CORROSION AREA IAW EI NR: T2025A57M-1060 REV 2. COMPLETED JOB AND CONDITION CHECK NORMAL.Jun 28, 2025 · N429MC · Boeing 747481 · Wing, Plate/SkinSDR UIEA2025062500807Skin · corrodedFOUND THE SKIN INSIDE CORROSION AT STA 1700 - 1720, S-42L. REMOVE EXIST SKIN REPAIR DOUBLER IAW SRM 51-10-02-0G-0 REV 62. ACCOMPLISH EI NO: T2025A53M-1083 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.Jun 28, 2025 · N429MC · Boeing 747481 · Fuselage Main, Plate/SkinSDR UIEA2025062500808Skin · dentedFOUND FUSELAGE LOWER LOBE SKIN DENT AT STA 1925, S-31R ~ S-32R. ACCOMPLISHED EI NR: T2025A53M-996 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.Jun 28, 2025 · N429MC · Boeing 747481 · Fuselage Main, Plate/SkinSDR UIEA2025062500809Skin · dentedDENT - FOUND FUSELAGE LOWER LOBE SKIN DENT AT STA 1935, S-31R ~ S-32R. ACCOMPLISHED EI NO: T2025A53M-996 REV 1 AND EI ATTACHED TO W/O NO: 11010065(002). JOB COMPLETED AND CONDITION CHECK NORMAL.Jun 28, 2025 · N429MC · Boeing 747481 · Fuselage Main, Plate/SkinSDR UIEA2025062500810Repair · out of dateUPGRADE THREE TEMPORARY FUSELAGE SKIN DOUBLER REPAIRS BETWEEN STA 1780 AND STA 1840, S-46L AND S-49L. REMOVED TIME LIMITED FUSELAGE SKIN REPAIR, TOTAL 3 AREA IAW SRM 51-40-02-0G-0 REV 62. ACCOMPLISHED EI NR T2025A53M-1055 REV 2. 3. JOB COMPLETED AND CONDITIJun 28, 2025 · N429MC · Boeing 747481 · Fuselage Main, Plate/SkinSDR UIEA2025062500811Spar · corrodedCORROSION ON RH WING FRONT SPAR OUTBOARD LOWER CHORD AT FSSO 1509.45. REMOVED THE AFFECTED FASTENERS IAW SRM 51-40-02-0G-0 REV 62. BLENDED OUT THE DAMAGE AREA IAW SRM 51-10-02-0G-0 REV 62. PERFORMED NDT INSPECTION REFER TO JOB CARD NO: 044869 AND DATA SHJun 28, 2025 · N429MC · Boeing 747481 · Wing SparSDR UIEA2025062500812Elt · no testFOUND ELT SYSTEM OPERATIONAL TEST FAIL. REPLACED ELT TRANSMITTER IAW AMM 23-24-01-020-801 & AMM 23-24-01-420-801 REV 113. PERFORMED ELT TEST IAW AMM 23-24-01-720-801 & AMM 23-24-01-720-802, & AMM 23-24-01-720-803 REV 113. TEST RESULT WAS SATISFACTORY.Jun 28, 2025 · N429MC · Boeing 747481 · Emergency Locator BeaconSDR UIEA2025062500813Battery · faultedFOUND CARTRIDGE RESISTANCE OUT OF LIMIT AT L/H, R/H UPPER DECK DOOR WHEN PERFORM BATTERY AND EMERGENCY OPENING OPERATATION. REPLACED L/H & R/H UPPER DECK DOOR EMERGENCY POWER RESERVOIR IAW AMM 52-23-13-004-001 & AMM 52-23-13-404-010 AND AMM 52-23-13-406-045 Jun 28, 2025 · N429MC · Boeing 747481 · Emergency ExitsSDR YENA2025063000663Apu · odorFLT#1075, MCO-PVD. "DURING DESCENT PILOTS AND FA'S EXPERIENCED A FUME EVENT. PILOTS NOTICED AN OIL SMELL AND FWD FA'S NOTICED BURNING RUBBER. A/C HAS FUME HISTORY. ( PACKS ); REF LP#4197860 ITEM #2, APU ODOR IDETIFIED & CORRECTED. NO SMELL PRESENT AFTER DECON/Jun 28, 2025 · N547JB · Airbus A320232 · Airborne Auxiliary Power Unit (APU) SystemSDR YENA2025063000662Oil System · leakingFLT#1434, SJU-MCO. "INFLIGHT CREW COMPLAINING OF A STRONG ODOR IN THE AFT OF THE AIRCRAFT FLIGHT ODOR SURVEY COMPLETED; COMPLIED WITH INFORMATION NOTICE 2017-T015 OIL B2 TYPE 1 APU OIL LEAK DECONTAMINATION LEVEL A WAS ACCOMPLISHED PER TSM 05-50-00-510-085-B."Jun 28, 2025 · N547JB · Airbus A320232 · APU Oil SystemSDR WX0A2025063032478Unknown · odor(AIRCRAFT NOT GROUNDED) ALL F/A'S COMPLAINED OF DIRTY SOCK SMELL DURING CRUISE AND ALSO DURING TAKEOFF AND LANDING. THE SMELL WAS REPORTED AS THE WORST DURING T/O AND LANDING / (RESOLVED ON W/O: 525105 TASKCARD: NR-00001) C/W A32X-21-000-002 NO LEAKAGE OR ODORJun 28, 2025 · N222NV · Airbus A320214 · Air Distribution SystemSDR AALA202506307130Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR AFT F/A FLASHLIGHT BATTERY INOP. MAINTENANCE REPLACED L2 DOOR AFT F/A FLASHLIGHT BATTERY IAW AMM 25-64-01.Jun 28, 2025 · N723AN · Boeing 777323ER · Emergency EquipmentSDR IPXA2025062866719Light · inoperativeDURING CRUISE, CREW SMELLED ELECTRICAL SMOKE. OBSERVED SMOKE SOURCE UNDER CAPT SEAT. FWD UNDER SEAT FLOODLIGHT LIGHT WAS VERY HOT AND APPEARED TO BE THE SOURCE. IMMED TURNED OFF CONSOLE FLOOD LIGHT SW PERFORMED INSPECTION. UNDER CAPT€™S SEAT, FOUND CAPT€™S FJun 28, 2025 · N129UP · Airbus A300F4622R · Flight Compartment LightingSDR AALA202506306755Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND PYLON OUTBOARD SIDE FORWARD HINGE FITTING FOR FAN COWL MOUNTING IS WORN, REPLACED HINGE FITTING PER SRM 51-42-11.Jun 28, 2025 · N178US · Airbus A321211 · Nacelle/Pylon, Main FrameSDR AALA202506305958Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.Jun 28, 2025 · N192UW · Airbus A321211 · Fuselage Miscellaneous StructureSDR AALA202506309135Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME AFT FACE WEB JOINT TO THE DOOR FRAME AT FR 68 AND S8R. REPAIRED FRAME PER SRM 51-41-12-300-012.Jun 28, 2025 · N180US · Airbus A321211 · Fuselage Main, FrameSDR AALA202506304238Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT BULKHEAD LEFT HAND CENTER VERTICAL STIFFENER CRACKED. AT FR 35.6 AND LBL 41. REPLACED VERTICAL STIFFENER PER SRM 53-24-14.Jun 28, 2025 · N400AN · Airbus A321253NX · Fuselage Miscellaneous StructureSDR DALA2025063004833Oxygen Mask · unwanted deploySHIP 3419 OXYGEN PANEL MASK DEPLOYED AT SEAT 52C. CORRECTIVE ACTION: RE-PACKED MASKS PER A330 AMM 35-23. OK FOR SERVICE. (1052008)Jun 28, 2025 · N419DX · Airbus A330941 · Passenger Oxygen SystemSDR AALA202506302673Lanyard · out of positionAIRCRAFT WAS GROUNDED: 4R DOOR HARD TO ARM AND DISARM. MAINTENANCE RE-ADJUSTED GRIT BAR (AALA202506292736) POSITION AND LANYARD STRAPS (AALA202506302673) PER AMM 25-62-44. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.Jun 28, 2025 · N951XV · Airbus A321253N · Emergency EquipmentSDR AALA202506308535Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 11WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL TEST PER AMM 33-51-38.Jun 28, 2025 · N558UW · Airbus A321231 · Emergency LightingSDR AALA202506302736Girt Bar · out of positionAIRCRAFT WAS GROUNDED: 4R DOOR HARD TO ARM AND DISARM. MAINTENANCE RE-ADJUSTED GRIT BAR (AALA202506292736) POSITION AND LANYARD STRAPS (AALA202506302673) PER AMM 25-62-44. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.Jun 28, 2025 · N951XV · Airbus A321253N · Emergency EquipmentSDR AALA202506309743Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.Jun 28, 2025 · N568UW · Airbus A321231 · Emergency LightingSDR DXTA2025063004075Battery Pack · no testSTANDBY EMERGENCY POWER: AFTER MOVING THE CABIN EMERGENCY LIGHT SWITCH FROM THE OFF POSITION TO ARM, A "EMER LIGHT NOT ARMED" CAS MESSAGE APPEARED. AFTER NUMEROUS TIMES OF RECYCLING THE SWITCH THE CAS MESSAGE DISAPPEARED. HOWEVER, WHILE IN ROUTE, WE NOTICED TJun 28, 2025 · N379QS · Emb EMB505 · Emergency LightingSDR JJBA20250630024Handle · unsecureMCD UNABLE TO OPEN FROM INSIDE CABIN. RESECURED INTERNAL MCD HANDLE. OPS CHECK SAT AT THIS TIME.Jun 28, 2025 · N31131 · Emb EMB145XR · Passenger/Crew Doors