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 YENA2025070100667Frame · ground damageDURING HEAVY MAINTENANCE: FUSELAGE / FWD FUSELAGE / FR 5-7 & LH LOWER STRINGER-CENTERLINE / TUG IMPACT. REPAIRED.SDR SCNA20250701237Lamp · inoperativeINOPERATIVE EMERGENCY EXIT LIGHT ON FWD RIGHT OVERWING EMERGENCY EXIT DOOR. REMOVED AND REPLACED LAMP IAW AMM 33-51-01. OPS CHECK GOOD.SDR 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-SDR 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 APPROXIMATESDR 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).SDR 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. WORKSDR 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.SDR 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.SDR 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 RSDR 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 STSDR 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).SDR 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.SDR 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-00SDR 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.SDR 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 SDR 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 LSDR SWIA202506300028Skin · gouged3 GOUGES TO FUSELAGE SKIN BETWEEN FS589.00 - FS605.00 AND STR 23R-24R (FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR AALA202506307142Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT INOP ABOVE 2G SEAT, CEILING AREA. MAINTENANCE REPLACED 2G EMERGENCY LIGHT SOCKET IAW AMM 33-51-03.SDR AALA202506307149Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ROW 15 FELL OFF WALL. RESECURED OVERWING EMERGENCY EXIT SIGN LENS, PER AMM 33-51-01.SDR 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.SDR 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.SDR AALA202506307826Hinge · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR REPORTED HARD TO PULL OPEN OR CLOSED. SECURED LOOSE DOOR HINGE HARDWARE.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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 CONDITISDR 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 SHSDR 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.SDR 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 SDR 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/SDR 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."SDR 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 ODORSDR 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.SDR 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 FSDR 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.SDR 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.SDR 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.SDR 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.SDR 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)SDR 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.SDR 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.SDR 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.SDR 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.SDR 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 TSDR JJBA20250630024Handle · unsecureMCD UNABLE TO OPEN FROM INSIDE CABIN. RESECURED INTERNAL MCD HANDLE. OPS CHECK SAT AT THIS TIME.