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 DALA2025080605890Plate · corrodedRIGHT FLOOR SIDE PLATE FROM STA 767 TO STA 793 AT AFT CARGO COMPARTMENT HAS CORROSION. SIDE PLATE FROM STA 767 TO STA 793 AT AFT CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR MASA2025080500066Light · inoperative2A AND 3C PHOTILLUMINECIENT STRIPS INOP - PLACED ON MELSDR MASA2025080500065Battery Pack · no testEMERGENCY LIGHT IN FD NOT ILLUMINATED. - R&R FWD RT EMER LIGHT BATTERY IAW EMB 175 AMM 33-50-01. OPS CK GOOD.SDR DXTA2025080604480Light · misinstalledEMERGENCY LIGHTS AT SEAT 3R ARE BACKWARDS. RED LIGHT IS FORWARD WHITE IS CLOSES TO EMERGENCY EXIT. I NSPECTED EMERGENCY LIGHTS AT SEAT 3R AREA. POWERED UP AIRCRAFT AND TURNED ON EMERGENCY LIGHTS AND VERIFIED LIGHTS ARE BACKWARDS.TURNED EMERGENCY LIGHTS OFF, POSDR DXTA2025080604491Light · disconnectedAFT EMERGENCY EXIT LIGHT OVER LAVATORY TOILET NOT ILLUMINATING DURING AIRCRAFT POWER ON CHECKLIST. (AOG) AFT EMERGENCY EXIT LIGHT OVER LAVATORY TOILET NOT ILLUMINATING DURING AIRCRAFT POWER ON CHECKLIST FOUND AFT EMERGENCY EXIT LIGHT OVER LAVATORY TOILET NOT CSDR AALA202508062240Lock · brokenAIRCRAFT WAS NOT GROUNDED: LAVATORY-D LOCK BROKEN, GETS JAMMED WITH OCCUPANTS UNABLE TO UNLOCK. (OPEN).SDR AALA202508061918Girt Bar · faultyAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR HARD TO REMOVE FROM SLIDE CONTAINER HOOKS. REPOSITIONED FORWARD R1 DOOR GIRT BAR. PER AMM 25-66-00. OPERATIONAL CHECK GOOD.SDR AALA202508065977Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT AFT CABIN JUMP SEAT STATION INOPERINOPERATIVE. INSTALLED NEW BATTERY IN FLASHLIGHT AFT GALLEY. PER AMM 25-60-00.SDR AALA202508068650Lock · stuckAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK KEEPS GETTING STUCK IN THE CLOSED POSITION. PEOPLE ARE HAVING TROUBLE GETTING OUT OF THE LAVATORY. CLEANED OBSTRUCTION FROM LOCKING MECHANISM ON AFT LEFT LAVATORY OPERATIONAL CHECK NORMAL.SDR AALA202508065312Fastener · looseAIRCRAFT WAS NOT GROUNDED: LAVATORY-A DOOR IS STICKING WHEN OPENING AND CLOSING. TIGHTENED LOOSE FASTENERS ON THRESHOLD DOOR. PER CMM25-48-48. OPERATIONAL CHECK GOOD.SDR AALA202508067657Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLIGHT ATTENDANT IN AFT GALLEY HAD SMELLED SMOKE LIKE A BURNING CLOTHING SMELL, IMMEDIATELY AFTER TAKEOFF. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CLT. ACCOMPLISHED J/C 08L00021001 TROUBLESHOOTING SMOKSDR REXA2025080600796Lamp · inoperativeOVERWING DOOR RH AFT EXTERNAL EMER LIGHT INOP. REPLACED BULB AT RH AFT OVERWING DOOR EXT EMER LIGHT, OPS TEST GOOD PER AMM 33-51-15. PN: 8GH005123-06.SDR DALA2025080605888Power Supply · inoperativeSEATS 22D-33D EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY. ALL OPS CHECK GOOD.SDR DALA2025080605887Plate · corrodedCORROSION ON UPPER A LOWER LH SIDEPLATE AT STA 727 TO STA 727F OF AFT CARGO. SIDE PLATE AT STA 727 TO 727F WAS REPLACED PER B737-800 SRM 51-40-02-0G PAR. 4.B AND 7.A AND SRM 51-40-03-0G.SDR DALA2025080605886Plate · corrodedCORROSION ON UPPER AND LOWER RH SIDEPLATE AT STA 727 TO STA 727F OF AFT CARGO. RH SIDEPLATE AT STA 727 TO STA 727F OF AFT CARGO WAS REPLACED WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025080605884Engine · vibrationSHIP 3022 - ATB - RETURNED TO MSP DUE TO #2 ENGINE HIGH VIBRATIONS WITH AUDIBLE RUMBLE. CORRECTIVE ACTION: FOUND DAMAGE TO FAN BLADES FROM BIRD STRIKE. REPLACED BLADES NBR 2, 20 AND 3, 21. (LP 7827314)SDR SIMA20250805002Roller · dirtyL1 DOOR DIFFICULT TO OPEN FROM OUTSIDE. MULTIPLE GATE AGENTS HAD TROUBLE OPENING IT. FOUND FWD AND AFT ROLLERS ON L1 DOOR DIRTY AND BINDING. CLAENED AND LUBED ROLLERS AND PERFORMED A FUNCTIONAL CHECK IAW 52-11-20-720-801-A. OP CHECKS GOOD.SDR SIMA20250805001Skin · corrodedINNER REINFORCEMENT SKIN AT LAV SERVICE PANEL CORRODED. (MAJOR REPAIR) (LEVEL 2 CORROSION). COMPLIED WITH FABRICATION, ALODINE PRIMED AND INSTALLED FILLER AND EXTERNAL DOUBLER IAW SRM 53-23-60.SDR AALA202508069298Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 963, RBL 18. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR CALA2025080607390Battery · faultedEMERGENCY POWER SUPPLY AND BATTERY FOUND MALFUNCTIONED. REPLACED THE EMERGENCY POWER SUPPLY AND BATTERY PACK. PERFORMED THE NEW POWER SUPPLY AND BATTERY PACK TEST, THE TEST RESULT NORMAL IAW AMM 33-51-06-960-802 AND AMM 33-51-06-960-803 REV 104.SDR CALA2025080607389Charger · inoperativeEMERGENCY POWER SUPPLY AND BATTERY FOUND MALFUNCTIONED. REPLACED THE R4 DOOR EMERGENCY POWER SUPPLY AND BATTERY PACK. PERFORMED THE NEW POWER SUPPLY AND BATTERY PACK TEST. THE TEST RESULT NORMAL IAW AMM 33-51-06-960-802 AND AMM 33-51-06-960-803 REV 104.SDR CALA2025080607388Floorbeam · damagedMAIN CABIN FLOORBEAM STA 540 BETWEEN BL 0 TO LBL24. SEVERAL RIVETS PULLED. REMOVED AND REPLACED MAIN CABIN FLOORBEAM IAW SRM 51-40-02-0G-0.SDR CALA2025080607387Battery · no testEMERGENCY EPSU BATTERY FAILED CAPACITY CHECK. REMOVED AND REPLACED RT EMERGENCY EPSU BATTERY IAW AMM 33-51-38-000-002-A. OPS CHECKED GOODSDR CALA2025080607386Charger · faultedBATTERY FAULT LIGHT ILLUMINATED ON EMERGENCY POWER SUPPLY UNIT. 10WL REMOVED AND REPLACED FWD EPSU BATTERY CHARGER FIN 10WL IAW AMM 31-55-00. OPS CHECK GOOD.SDR CALA2025080607365Battery · inoperativeEMERGENCY POWER ASSIST SYSTEM (EPAS) RESERVOIR PRESSURE LEVEL CHECK PROCEDURE. UPON INSPECTION FOUND EPAS BATTERIES INOPERATIVE. NO GREEN LIGHT. R & R #1 R/H EPAS BATTERY MODULE AND BATTERY IAW AMM 52-11-20-400-813. OP CHECKED PASSED IAW AMM 52-11-20-700-8SDR CALA2025080607364Light · no testROW 29ABC AISLE EMERGENCY LIGHT INOP DURING TEST, REPLACED THE LAMP, WHITE EMERGENCY LIGHT, LIGHT STILL NOT OPERATIVE, NEEDS FURTHER TROUBLE SHOOTING.SDR CALA2025080607363Light · unknownFOWARD LT AND RT OVERWING EMERGENCY ESCAPE DOOR LOWER EMERGENCY EXIT SIGN INOP. DURING TEST, FWD LEFT AND RIGHT OVERWING EMERGENCY ESCAPE DOOR LOWER LIGHTS OPS CK GOOD,,SDR 2025FA0000536Engine · fireFOLLOWING A REPAIR CARRIED OUT, THE ENG WAS SENT FOR TESTING. ENGINE UNDERGOING TESTING (TEST 003) , & FLAME COMING OUT OF UPPER LT UNDERCOWLING OBSERVED. ITP THROTTLE OPERATOR DECELERATED & ACTIVATED THE FIRE EXTINGUISHER BOTTLE. AFTER THE INCIDENT, ENG WASSDR AALA202508054668Slide · misinstalledAIRCRAFT IN BASE MAINTENANCE: R2 DOOR SLIDE INSTALLED INCORRECTLY. NEEDS TO BE RE-SEATED AGAINST THE DOOR MAINTENANCE REMOVED SLIDE PACK FROM DOOR AND REINSTALLED PER AMM 25-66-01-400-803 STEP E.SDR AALA202508058982Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508051038Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 25-62-00.SDR FDEA202508051370Skin · dentedDENT IN LOWER SURFACE AT OTEF STA 232.69 AND 9" OF LEADING EDGE ON LH OUTBOARD FLAP LEADING EDGE ON LH OUTBOARD FLAP WAS REPAIRED IAW B767 SRM 57-53-01-2R FIG 201 REP 1 SHEET 3 REV 92 APR 15.2025 AND SRM 51-70-10-2R REV 92 APR 15.2025SDR FDEA202508051369Spoiler · damagedPOST FLIGHT WALK AROUND FOUND SPOILER NR 5 DAMAGED ON RIGHT WING. R & R'D RH O/B #5 SPOILER OPS & FUNCTION CHK GOOD. A/C OK FOR SERVICE IAW AMM 27-60-30-4 ANN: 27-60-30-6.SDR FDEA202508051368Skin · puncturedRIGHT HAND WING: LOCATED ALONG OUTBOARD SIDE OF #12 SLAT TRACK, RIGHT HAND LEADING EDGE SKIN AREA FOUND PUNCTURED AND DENTED, ALONG XOS 780. REPAIR CARRIED OUT AT RIGHT HAND WING: LOCATED ALONG OUTBOARD SIDE OF #12 SLAT TRACK RIGHT HAND LEADING EDGE SKIN ASDR IXXA20250805002Skin · gougedLEFT WING INBD FWD FLAP UPPER SURFACE HAS BARE METAL AND A GOUGE IN THE PREVIOUS REPAIR.SDR AALA202508051342Battery Pack · abnormalAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE LIGHTING INOPERATIVE AT ROWS 8-14. REMOVE AND REPLACED EMERGENCY LIGHT BATTERY PACK AT ROW 10. PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR DALA2025080505868Frame · damagedFRAME 40.3 BETWEEN STRINGER 5-6 NOTED TOOLING DAMAGE OUT OF LIMITS. REPAIRED PER ERA 628205-14 REV ORIG.SDR DALA2025080505867Door · out of adjustMAIN CABIN L1 DOOR DIFFICULT TO OPEN FROM OUTSIDE. ADJUSTED Z AXIS REF AMM 52-11. CKS GOOD.SDR IXX2025F00013Shear Tie · crackedLEFT ENGINE PLYON AFT BULKHEAD INBOARD SIDE BELOW MID-SPAR FITTING CLIP CRACKED.SDR IXXA20250805001Skin · corrodedCORROSION ON LEFT WING UPPER SURFACE LOCATED AT WSTA 456.50SDR ABXA20250805172Elevator System · faultedDRUING TAXI OUT, LEFT SIDE ELEVATOR DID NOT MOVE ON STATUS PAGE. ACFT RETURNED TO THE GATE. MTX GROUNDED ACFT AND DEFERRED ELEVATOR INDICATION FOR DEPARTURE IAW MEL ABX-27-08-01. MTX RETURNED AC TO SERVICE.SDR ABXA20250805171Indication Sys · malfunctionedFUEL QUANTITY CHANNEL STATUS MSG ON TAXI OUT A/C RETURNED TO THE GATE (BTB) MTX GROUNDED AC AND DEFERRED FUEL QTY FOR DEPARTURE IAW MEL ABX-28-41-1-3-1. MTX RETURNED AC TO SERVICE.SDR MTNA20250805001Microphone · no testPILOT OXYGEN MASK MICROPHONE HAS NO SOUND. INSTALLED REPLACEMENT CAPTAINS O2 MASK IAW IAW STC STO1444SE DOCUMENT 3510-1 OPS CHECK GOOD.SDR 2025FA0000535Nut Plate · corrodedUPON REMOVAL OF 316CBC AND 316DBC FOR L5 INSTALLATION, FOUND CORROSION UNDER MULTIPLE NUTPLATES. REMOVED NUTPLATES AND BLENDED CORROSION FROM AFFECTED AREA ON APROX. F.S. 500-570 INSIDE PANEL 316CBC AND 316DBC ON STRINGERS IAW CESSNA 680A SRM 51-10-01 & 51-40-SDR I5PA2025080568801Window · crackedFLT NR MGE 300, L1 WINDOW CRACKED FLT 340, AIR RETURN HNL. R & R L1 WINDOW IAW AMM 56-11-01. ACFT RETURN TO SERVICE.SDR DALA2026062603800Turbine Wheel · damagedDURING ROUTINE DISASSEMBLY TWO (2) FASTENERS WERE FOUND LIBERATED IN THE SAME FASHION AS NOTED IN THE QUALITY ALERT. DAMAGE WAS SUBSEQUENTLY OBSERVED ON (BUT NOT LIMITED TO) THE HPT DISK, IPT DISK, IPT SHAFT, LPT DISKS STAGES 1 THROUGH 4 AND THE LPT SHAFT. TSDR REXA2026052700722Beam · chafedWEAR ON BEAM ON FWD AND AFT AREA ON AFT BAGGAGE BAY STRUCTURE BTW FS 1000.00 TO 10047.00. BEAM ON FWD AT AFT BAGGAGE BAY STRUCTURE BTW FS 1000.00 TO 1047.00 WAS REPAIRED PER EA CRJ953-19979 REV IRSDR REXA2026052700721Web · crackedCRACK ON WEB BELOW OF ADG RESTOW PUMP AT FWD EQUIPMENT COMPARTMENT WEB BELOW OF ADG RESTOW PUMP AT FWD EQUIPMENT COMPARTMENT WAS REPAIRED PER CRJ900 SRM 53-11-43-201-001-A01 AND EA CRJ953-20015 REV BSDR SWIA2025080475159Slat Track · wornRH 3-3 SLAT TRACK HAS WEAR MARKS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON RH SLAT TRACK 3-3 IAW CRJ 900 SRM 51-12-00-001-001-A01BLENDS FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE DAMAGE REMOVAL LIMITS IN CRJ900 SRMPERFSDR SWIA2025080475158Slat Track · damagedRH 2-2 SLAT TRACK HAS PITTING IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON R/H SLAT TRACK 2-2 IAW CRJ 900 SRM 51-12-00-001-001-A01FOUND TO BE OUT OF LIMITS NO ALLOWABLE LIMITS FOUND IN THE CRJ 900 SRMREPAIRED IAW REO 690-57-