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 CALA2025102010281Battery Pack · no testPOWER SUPPLY - BATTERY PACK CAPACITY CHECK PROCEDURE - EMERGENCY BATTERY PACK FOR EMERGENCY POWER SUPPLY M33098 OVERDOOR 2R FAILED FUNCTIONAL TEST REPLACED BATTERY PACK AT POWER SUPPLY M33098 OVERDOOR 2R. OP CHECK GOOD REF AMM 33-51-06. OP CHECK GOODSDR CALA2025102010280Light · brokenSEAT 32C EXIT ROW EMER LITE BROKEN RESECURED SEAT MOUNTED EMERGENCY LIGHT ASSY OPS CHECKS GOOD NO DEFECTS NOTED AT THIS TIME REF TASK 33-51-11SDR CALA2025102010279Lens · brokenAFT LAV 2L. LOWER EMER LIGHT BROKEN. INSTALLED A NEW LENS COVER ON AFT LAV 2L WALL, LIGHT CKS OK. ACFT IS OK TO CONTINUE.SDR CALA2025102010278Sign · wrong partFA REPORTED AFT FACE OF EMERGENCY EXIT SIGN IN AFT GALLEY IS MISSING ARROWS POINTING TOWARDS EMERGENCY EXIT REMOVED AND REPLACED AFT EMERGENCY EXIT SIGN LENSE AT AFT GALLEY PER AMM 20-50-11. OK TO CONTINUE.SDR CALA2025102010277Light · inoperativeEMERGENCY LIGHT DOES NOT COME ON AT ROW 30-38 WHEN TURN ON THE SWITCH ON P5 OR AT FAP EITHERFULL GROUND TEST OF EMER LIGHTS FAILED FAULT CODE 33-11624. ONLY ROWS 30-32 ARE NOT WORKING AT THIS TIME. BREAKER RESET AND SUBSEQUENT GROUND TEST DID NOT CORRECT FAULSDR CALA2025102010276Potable Water · contaminatedWATER IN AFT GALLEY HAS METALLIC TASTE STRONG ENUOGH TO MAKE WAT ER UNSUITABLE TO BREW CFFEE POTABLE WATER DRAINED AND SERVICED MUTIPLE TIMES PER AMM 12-14-00-600-801& 802 WATER WAS RUN THROUGH GALLEY AND LAVS WATER NORMAL CLEAR IN COLOR WITH NO SMELLSSDR CALA2025102010275Unknown · odorSMELL OF POSSIBLE FUEL/OIL IN FLT DECK DEBRIEF FLIGH CREW SUSPECT AC CART. RAN PACKS FOR EXTENDED PERIOD OF TIME NO ODORS DETECTED.SDR CALA2025102010274Sink · odorSINK IN GALLEYSMELLS BAD G1 GALLEY BULK 116 NOTED SMELL IN SINK G1 GALLEY. RINSED WITH VINEGAR. OPS CHECK GOOD REF 38-31-00SDR CALA2025102010273Engine · bird ingestionBIRD STRIKE FOUND ON ENG #2. ACCOMPLISH BIRDSTRIKE INSPECTION AS PER AMM 72-00-00-210-808-N02 (601) AND CONDITIONAL INSPECTION AS PER AMM 05-51-18-210-801 (201). BIRDSTRIKE FOREIGN OBJECT DAMAGE INSPECTION CARRIED OUT PER AMM 72-00-210-808-NO2, BIRD REMAINSDR CALA2025102010272Lavatory · odorLAV E DOOR INSIDE DOOR NEEDS CLEANED FOUL SMELL LAV E WAS CLEANED BY CLEANERS NO MORE SMELL OK FOR SERVICESDR CALA2025102010271Oven · smokeOVEN SMOKING, NEEDS CLEANING COACH CLASS CABIN WHITE SMOKE BRIEFLY SMELLED LIKE FOOD. FAN BLACK.ENDED W OVEN OF F OVEN WITH INTENSIVE SMOKE WHEN OPERATES, TX AS PER NEF2520AV. C/B COLLAR APPLIED. REF NEF 2520AV OVEN WITH INTENSIVE SMOKE WHEN OPERATES, TX AS PESDR CALA2025102010270Cartridge · odorDIRTY SOCK SMELL ON DESC ENT CREW STATES SMELL WAS COMING FROM FWD CABIN/FLIGHT DECK...PACK 1 DID INSPECTION OF APU PER AMM TASK 49-00-00-200-812-A NO OIL, FUEL OR HYDRAULIC LEAKS FOUND ON GROUND WITH APU BLEED ON AND BOTH PACKS ON, NOTED AN OIL SMELL IN COCKPSDR CALA2025102010269Toilet · dirtyTOILET BOWL SMELLS BAD AFT RH LAV E CLEANED THE TOILET BOWL AT RH AFT LAV E REF AMM 38-32-01-100-801. OK TO CONTINUE.SDR CALA2025102010268Potable Water · contaminatedDRAIN AND REFILL THE POTABLE WATER SYSTEMS WITH FRESH WATER PER THE GMM COFFEE HAS CHEMICAL TAST E AND SMELL. REMADE COFF EE SAME RESULT . SUSPECT WATER TANK NEEDS FLUSH DRAIN AND REFILLED POTABLE WATER SYSTEM,SDR CALA2025102010267Oven · dirtyOVEN SMELLS BAD G2 GALLEY OVEN 205 DEBRIEFED CABIN CREW TO DETERMINE SOURCE OF ODOR IAW AMM 05-51-26. CREW REPORTED ODOR FROM OVEN 205 ONLY. SMELLED OF SPOILED FOOD. NO SMOKE ODOR, ONLY SPOILED FOOD. OVEN WAS NOT USED DURING FLIGHT. CABIN CREW COMPLETED QUESTISDR CALA2025102010266Potable Water · contaminatedWATER TAST REPORTED TO BE VERY CHLORINE UNUSABLE FOR COFFEE DRAIN PORTABLE WATER AND FULLY SERVICE PORTABLE. NO BAD SMELL. REFERENCED FIM REFERENCE: 38-10 TASK 803SDR CALA2025102010265Oven · dirtyOVEN 205 SMELLS LIKE ROTTEN FISH. CLEANED OVEN OK TO CONTINUE.SDR CALA2025102010264A/C Pack · odorPACK LIGHT COMES ON DURING FLIGHT LEFT PACK LIGHT SMELLED LIKE AN OVERHEAT RESET LIGHT CAME BACK ON RESET LEFT PACK .COMPLETED FIM 25-51 TASK 801 RAN PACKS FOR 25 MINUTES WITH NO FAULTSDR CALA2025102010263Potable Water · contaminatedWATER TASTES BAD, FORWARD GALLEY AND LAV COMPLEX DRAINED WATER TANK, RINSED WATER TANK AND OPS CHECKS ALL FWD WATER GALLEY AND LAV COMPONENTS PER AMM FIM TASK 38-10-00-810-803. WATER DOES NOT SMELL BAD AND THE WATER QUALITY IS GOOD.SDR CALA2025102010262Engine · inoperativeNUMBER 1 ENG WILL NOT START. OBSEVATION OF FLT CREW ATTEMPTING TO START NR 1 ENG. APU PRESSURE NORMAL. N2 INCREASED NORMALLY, N 1 INCREASED NORMALLY, FUEL FLOW STAYED AT 0.40 & NEVER INCREASED, EGT CLIMBED TO 500 DEGREES & REMAINED AT THAT TEMP. GROUND CREW SDR CALA2025102010261Unknown · odorON TAKEOFF, BURNING LUBRICANT SMELL. WAS NOT DURING TAXI/GROUND IDLE DEBRIEFED CREW. SMELL DISSAPTED SHORTLY AFTER TAKEOFF. FIRST FLIGHT AFTER #1 ENGINE WATER WASH COMPLETED OVERNIGHT. DEBRIEFED CREW. CREW STATED SMELL DISSIPATED VERY SHORTLY AFTER TAKEOFF ASDR CALA2025102010260Ceiling Panel · leakingWATER COMING FROM CEILING PANELS IN AFT CARGO PIT ADDING PIC. MOST AFT WALL IN AFT PIT CEILING PANEL ABOVE IT HAS WAYER DRIPPING FROM IT PARTIALLY REMOVED AFFECTED CEILING PANEL REF AMM 25-52-09, HARDWEAR IN PARTS BAG IN AFT PIT CLEANED ANY AND ALL RESIDUAL MOSDR CALA2025102010259Ceiling Panel · leakingMORE WATER DRIPPING FROM CEILING PANEL AT STA 849 IN AFT CARGO PIT PARTIALLY REMOVED PANEL REF AMM 25-52-09, HARDWEAR IN PARTS BAG IN AFT PIT CLEANED ANY AND ALL RESIDUAL MOISTURE AND SECURED AND TAPED PANEL AFTER ENSURING NO STANDING WATER, STAINS OR ANY SMELSDR CALA2025102010258Ceiling Panel · leakingFOUND MORE WATER DRIPPING FROM SECOND TO LAST CEILING PANEL IN AFT CARGO PIT PARTIALLY REMOVED PANEL REF AMM 25-52-09, CLEANED ANY AND ALL RESIDUAL MOISTURE AND SECURED AND TAPED PANEL AFTER ENSURING NO STANDING WATER, STAINS OR ANY SMELLS. THERE IS NO EVIDESDR CALA2025102010257Oven · odorOVEN711 MAKES AN ELECTRICAL FIRE LIKE SMELL RESET C/ B NO HELP REQUESTING DEFERA. COMPLIED WITH NEF 2500BR. NOC DESK: B787 NAME: MCKEEVER DATE: 16-OCT-25- OK TO DEFER GALLEY OVEN 711 PER NEF. CONFIRMED OVEN SOURCE OF SMELL. OVEN 711 PLACED ON DEFERAL.SDR CALA2025102010256Chiller · odorFORWARD GALLEY CHILLER NUMBER 1 WHEN ON MAKES A LOUD NOISE/ELEC ODOR NO. 1 CHILLER OPERATE WILL CAUSE BIG VIBRATION, NO TIME TO FIX, CB COLLARED AND INOP STICKER INSTALLED, AFFECT FOOD CART 112,113,114,115,116, NO ELECTRICAL ODOR, REQUEST PUT NO.1 CHILLER INOPSDR CALA2025102010255Unknown · stainedLARGE BLACK STREAKS ON UNDERSIDE OF AIRCRAFT, STREAKS ARE TACKY TO TOUCH AND HAVE NO NOTICABLE ODOR OR COLOR OF ANY AIRCRAFT FLUIDS. APPEAR TO ORIGINATE FROM WHEEL WELL AREA. OPERATED BOTH HYD. ACMP, FOUND NO ACTIVE LEAKS, DRIPS, PUDDLES, OR POOLING. HYD. SSDR CALA2025102010254Oven · smokeOVEN SMOKING OR SPARKING G9B GALLEY HALF CARRIER BOX 938R OVEN 606 SMOKING WHEN ON. OVEN 606 HAS STRONG SMELL OF BURNED FOOD. OVEN NEEDS DEEP CLEAN OR REPLACEMENT. DEFERRED OVEN 606 AS PER NEF 2520AV. M PROC C/W. REMOVED AND REPLACED 606 OVEN PER AMM 25-32-SDR CALA2025102010253Fuel Cap · missingFUEL CAP LANYARD MISSING. REQUEST MEL 2522HK FOR MISSING FUEL CAP LANYARD CAP IS NOT DAMGD ANDIS SECURE 2522HK APPROVED PLACED ON MEL.SDR CALA2025102010252Windshield · damagedR1 WINDSHIELD DAMAGED IN FLIGHT BY UNKNOW OBJECT. STARTED REMOVAL OF R1 WINDSHEILD COMPLETED UP TO AND STEP F, 7C. REFERENCE: TASK 56-11-11-000-801. COMPLETED INSTALATION OF R1 WINDSHIELD REF AMM 56-11-11-400-801, ALL OPS CHECKS GOOD.SDR CALA2025102010251Interphone · faultedINTERPHONE BETWEEN FLIGHT DECK AND CABIN INOPERATIVE PERFORMED OPS CHECK ON CABIN INTERPHONE SYSTEM IAW AMM REF. 23-42-00-710-801. COMMUNICATION BETWEEN FLIGHT DECK AND CABIN FUNCTIONS NORMALLY. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME. UPON THE SDR QXEA2025102000324Wheel · smokeWHITE SMOKE EMITTING FROM WHEEL FAIRING AREA OF THE RH OUTBOARD TIRE. TEMPERATURE RANGE ON EICAS IN GREEN NORMAL RANGE. REMOVED FROM SERVICE. INSPECTED #4 MLG WHEEL AREA IN REFERENCE TO E175 AMM 05-50-16-200-801-A AND 05-50-12-200-801-A. NO DAMAGE, LEAKS, OR DSDR DALA2025102007675Elec Connector · damagedEMERGENCY LIGHT AT 34AB OUT. REPAIRED CONNECTOR PER A330 AMM 33-51. (7929145)SDR DALA2025102007665Frame · damagedTOOLING DAMAGE ON FWD SIDE OF FRAME 29 AT P'7. REPAIRED PER ERA 628177-14 REV ORIG. (1261679)SDR DALA2025102007661Skin · gougedFUSELAGE SKIN FOUND GOUGE ON FR15A TO FR16 S-27L TO S-28L. REPAIRED PER ERA 629843-14 REV ORIGINAL. (1261234)SDR DALA2025102007660Beam · damagedREPAIR AT AFT CARGO DOOR FROM FR 61 TO FR 61A BETWEEN BEAM 4 AND BEAM 5 NEEDS RE-WORK. COMPLIED WITH ERA 629697-14 REV 0. (1261636)SDR DALA2025102007659Seat Track · corrodedSEAT TRACK - CABIN LONGERON UPPER SURFACE FOUND CORROSION AT FR11-FR11A, Y0. REPLACED BETWEEN FR11 AND FR19, Y0 PER A330 SRM 51-72-11-911-001. (1261610)SDR DALA2025102007658Seat Track · corrodedSEAT TRACK, CABIN LONGITUDINAL BEAM UPPER SURFACE FOUND CORROSION AT FR75 TO FR76, -Y440. REPLACED BEAM PER A330 SRM 51-72-11-911-001. (1261600)SDR DALA2025102007657Seat Track · corrodedSEAT TRACK - CABIN LONGITUDINAL BEAM UPPER SURFACE FOUND CORROSION AT FR75 TO FR76, Y440. REPLACED PER A330 SRM 51-72-11-911-001. (1261592)SDR DALA2025102007656Structure · damagedREPAIR AT AFT CARGO DOOR FROM FR 63 TO FR 63A BETWEEN BEAM 4 AND BEAM 5 NEEDS RE-REPAIR. COMPLIED WITH ERA 629696-14 REV 0. (1261482)SDR DALA2025102007655Seat Track · corrodedSEAT TRACK - CABIN LONGERON UPPER SURFACE FOUND CORROSION AT FR75 TO FR76, Y1447.8. REPLACED BETWEEN FR75 AND FR77, Y1447.8 AS PER A330 SRM 51-72-11-911-001. (1261291)SDR DALA2025102007654Slat · damagedNUMBER 4 SLAT DAMAGED. REPAIRED PER ERA 629693-14 REV ORIGINAL. (1261253)SDR AALA202510201061Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY ACCUMULATOR REQUIRES SERVICE. MAINTENANCE SERVICED R1 DOOR EMERGENCY ACCUMULATOR BOTTLE IAW AMM 52-10-00.SDR WX0A2025102032605Unknown · odor(AIRCRAFT NOT GROUNDED) FAS REPORTED EARTHY & MUSKY SMELL DURING CLIMB IN AFT 4 ROWS AND GALLEY THEN AFTER LANDING DESCRIBED SMELL WORSENED IN DESCENT AND DESCRIBED AS DIRTY SOCK SMELL. CLEANING AND DECONIMATION FO DIRTY SOCK /LOCKER ROOM/MUSTY SMELL REPORT RESDR GTIA2025102039144Flashlight · no testR4 JUMPSEAT FLASHLIGHT WILL NOT TEST-R/R R4 JUMSEAT FLASHLIGHT IAW DRAWING A321 CEO EMER EQUIP REV. 7. THIS CLEARS MDDR 121252 PLACARD REMOVED MOC NOTIFIEDSDR GTIA2025102039143A/C Pack · odorFUME EVENT ON APPROACH. DIRTY SOCKS SMELL. SOURCE, CABIN AIR SUPPLY VENTS. FWD CABIN/GALLEY(LAV), MID CABIN, AFT CABIN/GALLEY(LAV). NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-UPON TURNING ON AC AND PACKS 2 CONFIMRED SMELL. FOLLOWED TSM 05-50-00-810SDR GTIA2025102039142Megaphone · inoperativeFAA ITEM: FWD MEGAPHONE QC-12 ILLEGIBLE-R&R FWD MEGAPHONE IAW AMM 25-65-51 & SPIRIT A320 EMERGENCY EQUIPMENT LAYOUTSDR DALA2025102007634Engine · making metalSHIP 3832 - IFSD/ATB/DE - AIRCRAFT RETURNED TO EWR DUE TO LEFT ENGINE FAILURE. CORRECTIVE ACTION: METAL FOUND IN TAILPIPE, LEFT ENGINE REPLACED ON LOG PAGE 1260514.SDR AALA202510204678Skin · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON FUSELAGE SKIN AROUND AFT LAVATORY VENT LOCATED AT BS 917, BETWEEN S21L AND S22L. ACCOMPLISHED SKIN REPAIR PER EA 368982.SDR DALA2025102007628Clamp · leakingDIV - TO JFK DUE TO WING A.ICE SYS FAULT ECAM WARNING AND SHOWING ICING CONDITIONS AT DESTINATION. FOUND AIR LEAK AT PRV CLAMPS. REPLACED PRV SEALS. OPS CHECK GOOD. (LP 7966547, 7966546)