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 AALA202511051334Sensor · wornAIRCRAFT WAS GROUNDED: AFTER TAKEOFF ECAM L/G SHOCK ABSORBER FAULT, FOLLOWED BY NUMEROUS OTHER ECAMS. DECESAION MADE TO RETURN TO CLT LANDED OVERWIGHT WITHOUT INCIDENT. MAINTENANCE FOUND GROUND SENSING MECHANISM WORN AND REPLACED GROUND SENSING MECHANISM IAW ASDR AALA202511057544Battery Pack · missingAIRCRAFT WAS NOT GROUNDED: NEW POWER SUPPLY BATTERY NEEDED. INSTALLED AND CHARGED SERVICEABLE BATTERY. PER 33-51-06.SDR DALA2025110508072Wire Harness · failedFA REPORTED BURNING ELECTRICAL SMELL IN FORWARD CABIN WHILE AT CRUISE FLIGHT. R & R HARNESS FROM J14 TO SDU'S IAW PAC AMM 23-32-00. R & R SEB AT 2C IAW PAC AMM 23-32-07. (8034104).SDR IXXA20251103072Escape Reel · unraveled#1 INERTIA ESCAPE REEL UNRAVELED. PLACED ON DEFERRAL 67562 MINIMUM EQUIPMENT LIST 25-61-01-01 CATEGORY C. DUE 13 NOVEMBER 2025. REMOVED AND REPLACED INERTIA ESCAPE REEL IN #1 POSITION IN ACCORDANCE WITH B767 IAI SUPPLEMENTAL MAINTENANCE MANUAL 25-61-03. DEFERRSDR AALA202511059486Rod · out of adjustAIRCRAFT WAS GROUNDED: 4R DOOR SHOWING NOT ARMED ON STATUS PAGE IN FLIGHT. FLIGHT ATTENDANT STATES THAT VISUALLY IT IS ARMED. MAINTENANCE FOUND THE R4 SLIDE ARM LEVER NOT FULLY STOWING, ADJUSTED THE TRIPLE LEVER ROD AND ACCOMPLISHED A SATISFACTORY OPERATIONAL SDR DALA2025110508065Skin · damagedEXTERNAL POWER PANEL CUT OUT DAMAGED. REMOVED INTERNAL CRACK INTERCOSTAL IAW DWG 141A0640. C/W PRI 630191-14 REV ORIG PRI REV 0. ERA 630191-14 HAS BEEN CANCELLED AND NOW WORKING OUT OF THE SRM IAW SRM 53-10 -15-2R, PROCEDURE 5 REPAIR. REMOVED EXISTING FASTSDR SWI2025F01504Proximity Sensor · faultedAT FL340 RECEIVED A ROOT CAUSE CAUTION MESSAGE LG WOW SYS FAIL. ASSOCIATED WARNING MESSAGES DOOR SERV AFT OPEN, DOOR CRG AFT OPEN, DOOR PAX AFT OPEN, AND ADVISORY MESSAGE BRAKE CONTROL FAULT. QRH REQUIRED LAND AT NEAREST SUITABLE AIRPORT. DUE TO NOTES IN QRH FSDR SWIA2025110400003Windshield · crackedRIGHT WINDSHIELD FOUND TO HAVE CRACKS UPON ARRIVAL, REQUIRES REPLACEMENT (OPEN)SDR N6WA2025110406Floor Support · corrodedCORROSION ON LEFT FLOOR SUPPORT BETWEEN BS 280 - 310, LBL 27. REMOVED AND REPLACED THE FLOOR SUPPORT BETWEEN BS 280 - 310, LBL 27 IAW SRM 51-42-06.SDR N6WA2025110405Intercostal · corrodedCORROSION ON ITERCOSTAL AT STGR27R BETWEEN BS 364 - 364. REMOVED AND REPLACED THE INTERCOSTAL AT S27R BETWEEN BS 349 - 364 IAW SRM 51-42-06.SDR N6WA2025110404Intercostal · corrodedCORROSION ON INTERCOSTAL AT STGR27L BETWEEN BS 349 - 364. REMOVED AND REPLACED INTERCOSTAL AT S27L BETWEEN BS 349 - 364 IAW SRM 51-42-06.SDR AALA202511041624Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT ROW EXIT SIGN ON OVER HEAD WAS KNOCKED OFF BY PASSENGER. REINSTALLED EXIT SIGN ON OVERHEAD IN CABIN. OPERATIONAL CHECKS NORMAL. PER AMM 33-51-01-960-802.SDR AALA202511040417Pump · low pressureAIRCRAFT WAS NOT GROUNDED: DURING CRUISE NUMBER 2 FUEL TANK AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED AND REMAINED ILLUMINATED. VERIFIED NUMBER 2 AFT FUEL BOOST PUMP INOPERATIVE. (OPEN).SDR AALA202511047059Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ATTACHMENT UNSECURE AT SEAT 15C. RESECURED SEAT MOUNTED LIGHT AT 15C. PER AMM 33-51-11.SDR AALA202511041333Flashlight · not seatedAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY FLASHLIGHTS ON THE RIGHT SIDE IN THE AFT GALLEY ARE INOPERATIVE. RESET CONTACTS ON OUTBOARD FLASHLIGHT (AALA202511041333), OPERATIONAL CHECKS GOOD. ADDITIONALLY, REMOVED AND REPLACED INBOARD FLASHLIGHT (AALA20251104SDR AALA202511047047Coffeemaker · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORT BURNING SMELL IN AFT GALLEY. TROUBLESHOT AND FOUND AFT GALLEY UPPER COFFEE MAKER LEAKING ON HEATING PAD. REMOVE AND REPLACED AFT GALLEY UPPER COFFEE MAKER. PER AMM 25-32-00. GROUND OPERATIONAL CHECK GOOD ATTHIS TISDR AALA202511041627Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY FLASHLIGHTS ON THE RIGHT SIDE IN THE AFT GALLEY ARE INOPERATIVE. RESET CONTACTS ON OUTBOARD FLASHLIGHT (AALA202511041333), OPERATIONAL CHECKS GOOD. ADDITIONALLY, REMOVED AND REPLACED INBOARD FLASHLIGHT (AALA20251104SDR AALA202511048793Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: R1 EMERGENCY EXIT LIGHT OVERHEAD INOPERATIVE. REPLACED BATTERY AT PSU M02816 IN FORWARD GALLEY. PER 33-51-06.SDR AALA202511047544Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: NEW POWER SUPPLY BATTERY NEEDED. (OPEN).SDR IPXA2025110387420Door · malfunctionedCOCKPIT LIFE RAFT STOWAGE COMPARTMENT DOOR WILL NOT STAY OPEN. DEFERRED PER SREO-52198.SDR VNAA2025110411101Actuator · inoperativeGEAR DISAGREE WARNING MSG ON TAKEOFF, NLG WOULD NOT RETRACT. / REMOVED AND REPLACED NLG RETRACT ACTUATOR. IAW AMM 32-32-09-000/400-801-A01. OPS CHECK GOOD.SDR N6WA2025110403Floorbeam · crackedRH SIDE 280 CROSSBEAM IS CRACKED. REMOVED AND REPLACED RH 280 CROSSBEAM IAW CRJ SRM 51-42-10, CRJ SRM 51-42-06 AND CRJ SRM 51-42-21.SDR N6WA2025110402Floorbeam · cracked280.00 CROSSBEAM LH SIDE IS CRACKED. REMOVED AND REPLACED LH 280 CROSSBEAM IAW CRJ SRM 51-42-10, CRJ SRM 51-42-06 AND CRJ SRM 51-42-21SDR DALA2025110408055O-Ring · leakingATB- RETURNED TO FLL FOR MUSTY SMELL IN COCKPIT AFTER TAKEOFF. FOUND OIL BEHIND #2 ENGINE NOSE SPINNER, REPLACED NBR 2 ENGINE LPT SHAFT PLUG O'RINGS. COMPLIED WITH ENGINE 2 DECONTAMINATION OF BLEED AIR DUCTING SYSTEM PER A321 AMM 36-11-00-615-801-A01 AND ECSSDR DALA2025110408054Packing · leakingAIRCRAFT 5049, AFTER LANDING ON LT + RT ENG BLEED AIR, DIRTY SOCK SMELL IN FLIGHT DECK. CORRECTIVE ACTION: FOUND OIL WETTING IN BACK OF SPINNER OF #2 ENG. #1 ENG AND APU INSPECTIONS NORMAL. REPLACED PACKING AND FAN SHAFT COVER. PERFORMED LEVEL B DECONTAMINATIOSDR DALA2025110408046Seat Track · corrodedCORROSION ON INBOARD SEAT TRACK RH SIDE STA 365 TO 418 AT PAX CABIN IS OUT LIMITS IAW SRM 53-00-52-1A PROCEDURE 1, ALLOWABLE DAMAGE 1, FIG 101, DETAIL 1. CORROSION LEVEL 2. INBOARD SEAT TRACK RT SIDE BS 365 TO 418 AT PAX CABIN WAS REPLACED IAW SRM 51-40-02-0GSDR DALA2025110408045Seat Track · corrodedCORROSION ON OTBD SEAT TRACK RT SIDE BS 365 TO 418 AT PAX CABIN IS OUT LIMITS IAW SRM 53-00-52-1A, PROCEDURE 1, ALLOWABLE DAMAAGE 1, FIG 101, DETAIL 1. CORROSION LEVEL 2 OTBD SEAT TRACK RT SIDE BTW BS 365 TO 418 WAS REPLACED IAW SRM 51-40-02- 0G, PARA 7, AND SDR FDEA202511032120Cover · missingTHE EXIT LIGHT COVER MISSING ON LEFT SIDE OF L1 DOOR. DISCOVERED DURING PREFLIGHT. RELEASED FOR SERVICE PER MEL : 33-51-01. REINSTALLED COVER ASSY PER AMM 33-51-01-2. NEED TO PERFORM TEST OF LIGHT. EMERGENCY LIGHTS TESTED SATIS AS PER AMM 33-51-01-710-00SDR DALA2025110408042Indicator · corrodedCORROSION BASE RESERVOIR INDICATOR LOCATED BTW FR47/51 TO FR52 LH SID E AT LOWER FUSELAGE. REMOVED THE QUANTITY INDICATOR AS PER A320 FAM AMM 29-31-21-000-001-A. (1286334).SDR DALA2025110408041Unknown · odorELECTRICAL SMELL IN FWD CABIN. C/W AMDS WORK CARD 0550-2002. PERFORMED AN INSPECTION OF THE FWD CABIN AREA NO FURTHER DEFECT NOTED AT THIS TIME. (12867850).SDR DALA2025110408040Dummy Rail · corrodedCORROSION FLOOR STRUCTURE RAIL DUMMY LOCATED BTW FR 12 TO FR 16 AND Y 503.2 FWD GALLEY AREA. REPLACED FLOOR STRUCTURE RAIL DUMMY LOCATED BTW FR 12 TO FR 16 AND Y 503.2 FWD GALLEY AREA AS PER A319 SRM 51-42-11 AND A319 SRM51 -72-11. (1286505).SDR CALA2025110410880Drain · leakingOILY FLUID ON LEFT NOSE TIRE. UNKNOWN SOURCE. FOUND NOSE STRUT FLUID ON STRUT AND TIRE, NO HYDRAULIC FLUID FOUND AS FOR PREVIOUS DEF CLEANED NOSE STRUT, NO HYDRAULIC LEAK ON NOSE STRUT TURN ACTUATOR. NO STRUT FLUID LEAK FOUND. FOUND FLUID FROM FORWARD LEFT DSDR CALA2025110410879Bezel · brokenROW32L EMERGENCY LIGHT AISLE ILLUMINATION BEZEL BROKEN REMOVED AND REPLACE EMERGENCY LIGHT ASSEMBLY ON ROW 32L IN REFERENCE AMM 33-51-11 OPS CHECK GOODSDR CALA2025110410877Light · inoperativeEMER LIGHT 30F INOP CONFIRMED EMERGENCY LIGHTING ON SEAT 30F INOP . COMPLIED MEL REQUESTING FOR APPROVAL. MEL 3351V CONFIRMED LIGHT HOUSING DAMAGED. MEL IS ONLY FOR INOP. REMOVED AND REPLACED PATH LIGHTNING ASSEMBLY AT SEAT 30F , REF AMM 33-51-06. OPS CHECKKSDR CALA2025110410875Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN STA.277 AND 294.5 BL0 (REF AAR N/R 99971277) REMOVED AND INSTALLED NEW FLOOR SUPPORT BETWEEN STA.277 AND 294.5 BL0 REF B737-800 SRM 51-40-02-0G-0 & DWG 141A5400. REMOVED AND INSTALLED NEW FLOOR SUPPORT BETWEEN STA.277 AND 294.5 BSDR CALA2025110410873Slide · out of adjust1L AND 1R DOOR SLIDE COVER MATERIAL HANGING WAS ABLE TO PUSH THE EXCESS MATERIAL BACK UP NTO THE SLIDE COMPARTMENT. NO LONGER TOUCHING FLOOR ON DOOR 1R. 1L HAD SAME ISSUE. NABLE TO CHECK AS PASSENGERS WERE BOARDING.SDR CALA2025110410872Slide · unraveledSLIDE AT DOOR 1R SLIDE IS UNRAVELED AND BAR HANGING DOWN AND BAR HANGING DOWN CHK 1R SLIDE. GIRT FABRIC INPLACE WITH NORMAL FOLDS WITHIN LIMITS PER AMM 25-66-01. 1R DOOR OPERATES AND ARMS NORMALY, FABRIC NOT DRAGGING.AC OK TO CONTINUE.SDR CALA2025110410871None · noneINSTALLED EMERGENCY POWER RESERVOIR SAFETY PIN AND DOOR SLIDE SAFETY PIN ON DOOR R4 DUE TO MX. REMOVED EMERGENCY POWER RESEVOIR SAFETY PIN AND DOOR SLIDE SAFETY PIN ON DOOR R4 IDT C/WSDR CALA2025110410870Girt Bar · pulledDOOR 1L SLIDE GIRT BAR PULLED OUT REPORTED BY MOVE TEAM. RECLIPPED BAR FOR MOVE. FOUND GIRT BAR REINSTALLED, HOWEVER THE "Z" FOLD NEEDS TO BE TUCKED IN. READJUSTED Z FOLD REF AMM TASK 25-66-01-400-803. OPS CHK GOOD.SDR CALA2025110410865Smoke Detector · dirtyLAV G SMOKE DETECTOR WENT OFF NO PASSANGERS INSIDE LAV THERE WAS SMELL OF CIGARRETTES IN AFT OF AIRPLANE. SMOKE WARNING REPORT STATES ONLY WARNING IN LAV H (MID LAV). VERIFIED TRASH CAN SMOKE DETECTOR DID NOT BLOW ON ALL LAVS. VERIFIED OVERTEMP STICKER DID NOTSDR CALA2025110410863Angle · crackedCABIN FLOOR STRUCTURE WEB UPPER ANGLE CRACKED BL 0 STA 500C AND 500D. REMOVED CABIN FLOOR ANGLE CRACKED AS PER SRM 51-40-02-0G ,FABRICATED LOCATED AND DRILLED NEW ANGLE IAW ENGINNERING INFORMATION COMPONENT PART AND DWG # 143A5400 SH 263. INSTALLED NEW ANGLSDR CALA2025110410861Battery · no testDURING CABIN EMERGENCY LIGHTING TEST CIDS FAULTED 33-51-38. R & R EPSU BATT IAW AMM 33-51-00-710-812-A, OPS CHECK GOODSDR CALA2025110410858Battery Pack · no testDURING EMERGENCY LIGHTIMG CABIN TEST CIDS FAULTED 33-51-38. R & R EPSU BATTERY IAW AMM 33-51-00-710-812-A, OPS CHECK GOODSDR CALA2025110410857Fire Loop · out of positionNUMBER 2 ENG FIRE WARNING APPEARED TO ROLL 100 KTS. INDICATIONS CEASED CREW DEBRIEF: AFTER FIRE WARNING INDICATION, FO PULLED THROTTLES BACK AND WARNING STOPPED. GOT AN AVERAGE OF 1 TURN ON BOTH CLAMPS FOR THE 5TH STAGE CHECK VALVE, UPPER CLAMP ON THE PRSOV ANSDR DALA2025110408043Warning Message · false activationMISC/DE - DUE TO A F/CTL FLAPS LOCKED ECAM WARNING ON APPROACH. NO TROUBLE FOUND DURING INSPECTIONS OF THE TRANSMISSION SYSTEM. INTERCONNECTING STRUT SENSORS 38CV AND 40CV WILL BE REPLACED. (LP: 8016200)SDR DXTA2025110405569Elec Connector · damagedEMERGENCY LIGHT IN LAV INOPERATIVE. REPAIRED THE LIGHT CONNECTOR IAW SPM 20-30-20. RESTORED AIRCRAFT TO ORIGINAL CONFIGURATION EMERGENCY LIGHT OPS CHECK GOOD IAW AMM 33-50-00.SDR YENA2025110401084Ecs · contaminatedFLT#1638, SDQ-SJU. "AIRPACK 1 REG FAULT DIRTY SOCK SMELL IN COCK PIT CABIN OK NO SMELL; PERFORMED LEVEL A DECONTAMINATION OF ECS ENVIROMENTAL CONTROL SYS REF AMM 21-000-00-615-802 AIRPACK 1 REG FAULT TRANSFER TO LOGPAGE 4290803-1 (REPLACED CONTROLLER PACK 1 SDR YENA2025110401083Gate · malfunctionedFLT 1, JFK-FLL. (ETOPS) AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO JFK. RT OVERWING EMERGENCY EXIT DOOR MASTER CAUTION INDICATION IN-FLT 15000FT. CABIN PRESS INDICATING 1000FT NR 2 INFLT ANF NR 4 INFLT FEELING THEIR HANDS AND BODY TINGLING, RETURSDR AALA202511031724Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: WORKING J/C 09T20033001 FOUND R1 EMERGENCY LIGHT INOPERATIVE. REMOVE AND REPLACED BATTERY AT PSU M02816 IN FORWARD GALLEY. PER 33-51-06.SDR WX0A2025110332624Power Supply · no test(AIRCRAFT NOT GROUNDED) FAILED TEST/EPSU / REMOVED AND REPLACED EPSU REF WO535169"