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 SIMA20250622001Torque Tube · malfunctionedFLAP FAIL AFTER TAKEOFF WITH SLATS 3 FLAPS 1 EMERGENCY DERCLARED."TRANSFERRED TO NRWC 037-DFW-04924" RE-INSTALLED FLAP TORQUE TUBE AT RH WING FLAP ACTUATOR NUMBER TWO IAW AMM 27-51-03. COMPLIED WITH MECHANICAL RIGGING OF FLAPS IAW AMM 27-50-00-820-801-A. COMPLSDR AALA202506241647Warning Light · false activationAIRCRAFT WAS NOT GROUNDED: AT THE GATE, THE ECAM MESSAGE DOOR LEFT OVERWING EXIT REPEATEDLY APPEARS. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202506246395Strap · out of positionAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT NOTIFIED FLIGHT DECK OF PRESSURE LEAK COMING FROM DOOR 4L. AC 33K FT, CABIN ALT 6K FT, 7.8 DELTA P. MAINTENANCE FOUND THE SLIDE STRAP PINCHED IN THE DOOR AND ROUTED AROUND THE GIRT ASSEMBLY. MAINTENANCE RE-ROUTED STRAP ASDR AALA202506240131Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR IXXA20250624025Proximity Sensor · out of limitsPOST FLIGHT CREW REPORTED, RH FORWARD EMERGENCY DOOR DISCRETE LIGHT INTERMITTENT. DISPLAY COMES AND DISAPPEARS. LINE MAINTENANCE TRANSFERRED FAULT TO DEFERRAL MAINTENACE ITEM 63509 IAW ATI MINIMUM EQUIPMENT LIST 52-71-01-01. FOLLOWING A WIRING CHECK PER IAI WSDR HNAA2025062400458Unknown · odorSMELL OF BURNING RUBBER AROUND 18K. RAN ENGINES W APU ON AIR GROUNDS OPEN HYDRAULICS AND PACKS RUNNING INSPECTED MAIN BATT 1,2 & BACKUP RELAY BOX. INSPECTED RIGHT & LEFT HAND RELAY SUPPORT AND RIGHT & LEFT POWER CONTROL DIST BOXES INSPECTED BOTH PACK 1 & 2 NOSDR DALA2025062404703Battery Pack · inoperative(LOG 5653964) EMERGENCY LIGHTS FROM SEAT ROW 11-17 INOP. R/R EMER LT BATT AT SEAT 11 DEF PER B737 AMM 33-51.SDR AALA202506230435Engine · overtempAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE NUMBER 1 INCREASED TO RED LINE ON N1 WITH THRUST LEVERS BACK, WHILE DESCENDING, THRUST LEVER WENT TO IDLE BUT N1 STAYED AT MAX POWER AND INCREASING, HAD TO SHUTDOWN THE NUMBER 1 ENGINE. AIRCRAFT ESDR AALA202506236217Engine · power lossAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: SHORTLY AFTER TURNING OFF LEFT PACK FOR BLEED, THE TRIP NUMBER 1 ENGINE ROLLED BACK WITH ACCOMPANYING THUMPING AND CLUNKING SOUND. WITH ENGINE AT IDLE, ENGINE INDICATIONS WERE NORMAL. WHEN POWER IS ADDEDSDR AALA202506233171Drain Valve · odorAIRCRAFT WAS GROUNDED: A YELLOW PUNGENT SMELLING FLUID WAS COMING FROM THE LEFT AFT CABIN DOOR SCUPPER DRAINS. REPLACED AFT SILL DRAIN FLOAT VALVE. PER AMM 38-31-06. OPERATIONAL CHECK GOOD.SDR AALA202506236919Switchpack · failedAIRCRAFT WAS NOT GROUNDED: AUTO BRAKE DISARM LIGHT PRESENT IN RTO SETTING. REMOVE AND REPLACE LEFT-HAND AUTO THROTTLE SWITCH PACK. PER W/C #08L11276001. OPERATIONAL CHECK GOOD.SDR AALA202506236130Autobrake Sys · warning lightAIRCRAFT WAS NOT GROUNDED: REPEAT ITEM: AUTO BRAKE DISARM ILLUMINATED REPATED 3 TIMES NOW. (OPEN).SDR AALA202506236025Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR REQUIRES ADJUSTMENT. IT IS DIFFICULT TO OPEN. ADJUSTED AND LUBED LAVATORY DOOR. PER AMM 25-40-11.SDR AALA202506239455Door · stuckAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR BECOMES STUCK IN THE CLOSED POSITION, CAUSING THE PASSENGER TO BE LOCKED IN THE LAVATORY. ACCOMPLISHED AARD 25-40-10-10 REPAIR 10. DOOR OPERATIONAL CHECK GOOD.SDR QXEA2025062300265Sensor · dirtyFLIGHT 2117. BOTH LAVS WOULD NOT FLUSH DURING FLIGHT. LAV TANK LIGHT INDICATES FULL. DIVERTED AND MADE A UNEVENTFUL LANDING. REMOVED WASTE TANK FULL-LEVEL SENSOR. INSPECTED AND FOUND WASTE-TANK "FULL" LEVEL SENSOR TO BE DIRTY. CLEANED AND REINSTALLED SENSOR IASDR SWIA2025062300022Windshield · crackedL WINDSHIELD INSIDE CRACKED (FLIGHT 6516 - FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR SWI2025F00747Landing Gear · warning messageD:GEAR DISAGREE ON FINAL APPROACH INTO IAD, QRH CLEARED MESSAGEC: MEL 32-30-1CAT A DUE WITHIN 1 FLIGHT DAY FROM 06/22/2025CAT II DOWNGRADEGEAR DISAGREE ON FINAL APPROACH INTO IAD, QRH CLEARED MESSAGE (FLIGHT 5062 - FILED OPEN)JUN 22, 2025 STATION: IAD--DEFERSDR SWAA2025062384550Strip · inoperativeAFT LAV; CAPTAIN SIDE; BURNING ELECTRICAL SMELL INCIDENT SUMMARY FLIGHT 443 FLIGHT 443 DEPARTED LAX EN ROUTE TO AUS AND WAS CRUISING AT 37000 FEET WHEN THE FLIGHT ATTENDANT REPORTED A STRONG ELECTRICAL ODOR NEAR THE AFT LEFT SIDE OF THE LAVATORY. AS A PRECAUTISDR GTIA2025062338966Megaphone · inoperativeFWD MEGAPHONE INOP -R/R FWD MEGAPHONE IAW DWG A320 EMER EQUP REV 6 OPS CHECK GOODSDR HALA20250623194Fmc · faultedETOPS - FMGEC2 FAULT ON ECAM. REMOVED AND REPLACED FMGEC 2 COMPUTER PER AMM 22-83-34-00/400-802-A. PERFORMED CROSS LOAD OF FMGEC2 PER AMM 22-70-00-610-807-B. AFS BITE TEST GOOD OK FOR SVCSDR YENA2025062300643Fire Loop · faultedFLT#215, JFK-SFO. (ETOPS) ENG 2 FIRE LOOP B FAULT INTERMITTENT ( ENGINE FIRE DETECTION SYSTEMS 2) LOOP B); REF LP # 4324107 ITEM #2 FOR R/R OF ABG ENG 2 FIRE LOOP B. NO FAULT NOTED SINCE REPLACEMENT. BITE TEST OF FDU 2 CARRIED OUT IAW AMM 26-12-00. NO FAULTS SDR WX0A2025062332473Battery Pack · no test(AIRCRAFT NOT GROUNDED) EPSU FAILED CAPACITY CHECK / REMOVE AND REPLACE 4EA EPSU BATTERIES IAW AMM 33-51-38-400-002-A. OPS CHECK GOOD.ITEM: 1REMOVE AND REPLACED 4EA EPSU BATTERIES IAW AMM 33-51-38-400-002-A. OPS CHECK GOOD. "SDR WX0A2025062332470Slide · deployed(AIRCRAFT GROUNDED) R2 SLIDE BLOWN. REPLACED R2 BLOWN SLIDE IAW AMM 25-62-44-400-802-A. REPLACED R2 DOOR DAMPER DIAPHRAGM IAW AMM 52-10-00-610-001-A. OPS CHECKS GOOD. NO DEFECTS NOTED AT THIS TIME."SDR HALA20250623192Filter · not reportedETOPS - INTERMITTENT STATUS MESSAGE: FWD CARGO VENT, BULK VENT NUMEROUS TIMES; LASTING A FEW SECS. REMOVED AND REPLACED CABIN TEMP SENSOR FILTERS PER AMM 21-63-17-920-802. PERFORMED VC SYSTEM TEST PER AMM 21-28-00-710-807-A. TEST OK. OK FOR SVCSDR DALA2025062304693Stringer · corrodedSHIP 3135 CORROSION STRINGER 43L BTW FR64 TOFR65 IN AFT CARGO COMPARTMENT. CORRECTIVE ACTION: PERFORMED PERMANENT REPAIR ON STRINGER STR43L BTW FR64 TO FR66 AS PER A319 SRM 53-41-13-300-004. (1039732).SDR DALA2025062304692Stringer · corrodedSHIP 3135 CORROSION STRINGER 41R BTW FR61 AND FR62 IN AFT CARGO. CORRECTIVE ACTION: PERFORMED PERMANENT REPAIR ON STRINGER 41R BTW FR61 TO FR63 AS PER A319 SRM 53-00-13-300-001. (1039725).SDR DALA2025062304691Seat Track · corrodedSHIP 3130 CORROSION SEAT TRACK -Y1292 LOCATED AT FR 66 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK -Y1292 LOCATED BTW FR 66 TO FR 70 AT AFT GALLEY AREA AS PER A319 SRM 51-42-11, A319 SRM 51-72-11. (1039630).SDR DALA2025062304690Seat Track · corrodedSHIP 3130 CORROSION SEAT TRACK -Y765 AT FR20 FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK -Y765 AND FASTENERS LOC FR12 TO FR24 FWD GALLEY AREA, AS PER A319 SRM 51-42-11, A319 SRM 51-72-11. (1039612).SDR DALA2025062304689Floor Support · corrodedSHIP 3130 CORROSION FLOOR SUPPORT Y1292-1162.5 LOCATED BETWEEN FR67 TO FR68 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR SUPPORT Y1292-1162.5 LOC. BTW. FR67 TO FR68 AT AFT GALLEY AREA AS PER A319 SRM 51-42-11, A319 SRM 51-72-11. (1039599).SDR DALA2025062304688Floor Support · corrodedSHIP 3130 CORROSION FLOOR SUPPORT -Y1162.5 LOCATED BTW FR 68 TO FR 69 AT AFT GALL EY AREA. CORRECTIVE ACTION: REPLACED FLOOR SUPPORT -Y1162.5 LOC. ON FR68 TO FR69 AT AFT GALLEY AREA AS PER A319 SRM 51-42-11, A319 SRM 51-72-11. (1039540).SDR DALA2025062304687Floor Support · corrodedSHIP 3130 CORROSION FLOOR BEAM +Y1162.5 AT FR68 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM Y1162.5, LOC. ON FR68 TO FR69 AT AFT GALLEY AREA AS PER A319 SRM 51-42-11, A319 SRM 51-72-11. (1039519).SDR DALA2025062304686Fitting · corrodedSHIP 3130 CORROSION CENTER FITTING LOCATED BETWEEN FR16 TO FR20 AND STR23L FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED CENTER FITTING LOCATED BETWEEN FR16 TO FR20 AND STR 23L FWD GALLEY AREA AS PER A319 SRM 51-72-11. (1039509).SDR ABXA2025622134Pitot Head · defectiveDURING TAXI, F/O'S PITOT LIGHT PROBE NOT WORKING. AIRCRAFT RETURNED TO BLOCKS. (BTB). REMOVED AND REPLACED THE F/O'S PITOT PROBE IAW B767 AMM 54-11-01. OPS CHECK GOOD. PERFORMED LEAK CHECK OF SYS IAW B767 AMM 34-11-00. OPS AND LEAK CHECK GOOD. AIRCRAFT RSDR IPXA2025062264991Fmc · faultedATB FMC LOCKED UP WITH STBY ONE MSG PRESENT (FULL WRITEUP IN FAULT DESCRIPTION). + PERFORMED TROUBLE SHOOTING REF B767 FIM 34-61 FAULT TREE 854,NO FAULTS FOUND.REMOVED AND REPLACED L/H FMC REFB767AMM 34-61-01 9 (PRECAUTIONARY) OPS CHECK GOOD ATT.SDR AALA202506235746Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: ENGINE 2 FUEL FILTER CLOG MESSAGE ASSOCIATED WITH MEL 73-09 CONTINUOUSLY CYCLES ON AND OFF PRODUCING ECAM WITH MASTER CAUTION. TOO DISTRACTING FOR SAFE FLIGHT. GOING OFF DURING CRITICAL PHASES OF FLIGHT TAKEOFF AND CONTINUOUSLY DURINSDR AALA202506230216Strap · out of positionAIRCRAFT WAS NOT GROUNDED: EXIT DOOR 4L DIFFICULT TO ARM. MAINTENANCE CLEANED DOOR SILL AREA AND SECURED DOOR RAFT COVER STRAP PER AMM 25-62-44. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED OF THE DOOR ARMING SYSTEM.SDR AALA202506239368Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202506239480Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED ARM / DISARM HANDLE LOOSE ON 3L DOOR. MAINTENANCE TIGHTENED LOOSE 3L ARM/DISARM HANDLE PER AMM 52-21-00.SDR DALA2025062304681Circuit Breaker · faultedSHIP 0193 DURING SQUIP TEST ON P61 L/H EMERGENCY EXIT LIGHT NOT ILLUMINATED. CORRECTIVE ACTION: C/B RESET P11 PANEL P35/P36 IAW B767-300 AMM 25-65. (7317444).SDR DALA2025062304680Module · inoperativeSHIP 0174 1R SLIDE ARM LIGHT INOP. CORRECTIVE ACTION: R/R DOOR 1R ALARM SIGNAL MODULE AS PER B767-300 AMM 52-73. (1040051).SDR DALA2025062304674Power Supply · inoperativeSHIP 3322 ESCAPE PATH LIGHTING AT ROW 34-36 A/B INOP. CORRECTIVE ACTION: R/R EPSU 16WL AT DOOR 3L PER A330 AMM 33-51. OK FOR SERVICE. (7067436)SDR DALA2025062304667Fitting · shearedSHIP 3236 - MISC/DE - DUE TO L/G DOORS NOT CLOSED ECAM WARNING AT GEAR EXTENSION. FOUND LH FORWARD GEAR DOOR ACTUATOR FITTING ON THE KEEL BEAM WITH SHEARED FASTENERS. MAINTENANCE STILL IN PROGRESS. (LP: 7474401)SDR DALA2025062304666Power Supply · inoperativeAIRCRAFT 3004, DURING SERVICE CHECK FOUND EMERGENCY LIGHTS I IN ROW 37, 36, 32, 31, 30, 24, 23, 20, 19, 16 AND 15 INOP. CORRECTIVE ACTION: REPLACED 11WL EPSU. (LP 7169283)SDR DALA2025062304665Engine · odorSHIP 3235 DISC: AR 2500' ON DEPARTURE DIRTY SOCK ODOR IN COCKPIT. FA DID NOT SMELL ANYTHING. QRH COMPLETED AND IN CONJUNCTION WITH MCC ISOLATED SMELL TO PACK #1. CONTINUED TO DESTINATION WITH PACK 1 OFF. AFTER LANDING TURNED PACK 1 ON AND DIRTY SOCK ODOR CAME SDR REXA2025062300675Stringer · corrodedJOINT PIECE SPLICE (P/N:SH670-32429-2) AT FS333 STR 22R FOUND TO BE CORRODED REMOVED UNSERVICEABLE JOINT PIECE SPLICE (P/N:SH670-32429-2) AT FS333 STGR 22R IAW CRJ-700 SRM 51-42-06-001-001-A01 AND CRJ-700 SRM 51-42-21-001-001-A01. INSTALLED NEW SERVICEABLE JOSDR REXA2025062300674Stringer · corrodedSTRINGER AT 22R IS CORRODED BETWEEN FS 333.00 AND 349.00. REMOVED UNSERVICEABLE STR 22R (P/N:SH670-31379-1) BETWEEN FS333-FS349 IAW CRJ-700 SRM 51-42-06-001-001-A01 AND CRJ-700 SRM 51-42-21-001-001-A01. INSTALLED NEW SERVICEABLE STR 22R (P/N:SH670-31379-1) BESDR JJBA20250623017Lamp · inoperativeMCD EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EXTERNAL EMERGENCY LIGHT. OPS CHECK SAT.SDR SCNA20250623223Light · inoperativeDEFECT 701451: R/H BULLNOSE EMER LIGHTS 1, 2, AND 4 INOP ( INTERIOR EMERGENCY EXIT LIGHTING SYSTEM; EMERGENCY AISLE LIGHTS ) . REMOVED AND REPLACED RH BULLNOSE LIGHT ASSY'S AT POSITIONS 1,2 AND 4 EMERGENCY LIGHTS OPS CHECK GOOD. REF AMM 33-51-03.SDR CALA2025062305825Slide · partial deployR1 DOOR SLIDE PARTIALLY DEPLOYED. DID NOT INFLATE FOUND INSTALLED SLIDE IN SERVICABLE CONDITION. REMOVED, REPACKED AND REINSTALLED PER AMM 25-66-01-400-803. VERIFIED REPACKING AND REINSTALLATION OF THE R-1 DOOR SLIDE PER AMM 25-66-01-400-803.SDR CALA2025062305823Skin · corrodedLEFT WING LOWER SKIN FWD AND AFT OF FUEL PANEL 534BB BETWEEN RIB 26 AND RIB 27 HAS CORROSION. REPAIRED LT LOWER SKIN CORROSION AFT AND O/B OF FUEL PANEL 534BB BETWEEN RIB 26 & 27 AT REAR SPAR IAW EC/RA 5720-03540 REV A.