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 AALA202602029592Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 39H EMERGENCY LIGHT INOPERATIVE. REMOVE AND REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 39H, LIGHT OPS CHECK GOOD. PER 33-51-00.SDR AALA202602020479Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LOWER AISLE LIGHT INOPERATIVE NEAR G3 STORAGE AND CLOSET FORWARD GALLEY NEAR FLIGHT ATTENDANT JUMP SEAT. REPLACED WALL MOUNTED FLOOR PROXIMITY LIGHT ASSEMBLY AT L1 CLOSET. PER AMM 33-51-05.SDR ASAA2026013164045Door · no discrepancyR2 DOOR FOUND AJAR AT TOP DURING PREFLIGHT. UNABLE TO OPEN DOOR FROM INSIDE. GROUNDED - YES. OPENED R2 DOOR FROM INTERIOR REF AMM: 52-41-00-860-803. PERFORMED INSPECTION OF SEALS TOP FITTINGS AND CENTERING GUIDE WITH NO DEFECTS NOTED. OPENED AND CLOSED R2 DOORSDR YENA2026020200112Apu · contaminatedFLT 461, LGA - PBI,. INFLIGHT CREW MEMBER REPORTS SMELLING FUMES UPON BOARDING ACFT. ACCOMPLISHED INFO NOTICE 2017-TO15M. ACCOMPLISHED TSM 05-50-00-810-831-A.VERIFIED NO 30 DAY HISTORY. FOUND APU TO BE CAUSE OF ODOR, TYPE1, APU.ACCOMPLISHED DECONTAMINATIN SDR GTIA2026020239264A/C Pack · odorWET DIRTY SOCKS ODOR IN CABIN BY FA . CAPT TURNED OFF PACK 2 ON APPROACH, AFTER LANDING CAPT TURNED PACK 2 BACK ON AND ODOR CAME BACK RIGHT AWAY. ACCOMPLISHED TSM 05-50-00-810-831-A . VERIFIED ENG AND APU OIL LEVELS . NO DEFECTS NOTED. ACCOMPLISHED ENGINE RUSDR GTIA2026020239263Lavatory · leakingSTRONG ODOR OF SEWAGE IN COCKPIT AND FWD LAV. BOTH IN FLIGHT AND ON GROUND. FOUND FWD LAV TOILET LEAKING.SDR AALA202602022834Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: SLIDE 4R INTERMITTENT DISARMED IN FLIGHT. FLIGHT ATTENDANT PUSHED HANDLE AND IT RE-ARMED. MAINTENANCE PROXIMITY SENSOR 17WV2 (AALA202602011678) AND ADJUSTED PROXIMITY SENSOR 7WN2 (AALA202602022834) PER AMM 52-71-11 AND 52-71-00. A SATISFSDR AALA202602026883Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202602028207Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO FAULTS NOTED PER AMM 33-51-38.SDR AALA202602026453Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202602021777Control Servo · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETUNED TO JFK DUE TO THE FLIGHT CREW REPORTING THAT ON TAKEOFF, AFTER FLAP RETRACTION, THEY RECEIVED THE FOLLOWING ECAM MESSAGES: F/CTL L AIL FAULT, AND F/CTL AIL SERVO FAULT.ON SD PAGE, LEFT ASDR AALA202602020117Proximity Sensor · faultedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PVR DUE TO THE FLIGHT CREW REPORTING THAT AFTER TAKEOFF AT 1500 FEET MSL AFT CARGO DOOR OPEN LIGHT CAME ON. THE FLIGHT CREW COMPLIED WITH ECAM AND REPORTED THAT THE DOOR WARNING SDR AALA202602021678Proximity Sensor · faultedAIRCRAFT WAS GROUNDED: SLIDE 4R INTERMITTENT DISARMED IN FLIGHT. FLIGHT ATTENDANT PUSHED HANDLE AND IT RE-ARMED. MAINTENANCE PROXIMITY SENSOR 17WV2 (AALA202602011678) AND ADJUSTED PROXIMITY SENSOR 7WN2 (AALA202602022834) PER AMM 52-71-11 AND 52-71-00. A SATISFSDR AALA202602028270Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR RIGHT EMERGENCY POWER SUPPLY UNIT DISPLAYED DURING SYSTEM TEST, REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202602025300Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO ORD DUE TO THE FLIGHT CREW REPORTING THAT AFTER TAKEOFF ENROUTE TO ORD FLT ATTENDANTS REPORTED THAT DURING TAXI OUT & TAKEOFF THEY SMELLED FUMES BUT THE ODOR DISSIPATED SHORTLY AFTER TAKEOFF. ALSO ASDR AALA202602020284Lamp · no testAIRCRAFT WAS NOT GROUNDED, R1 DOOR SIDE WALL LOWER EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-50-00.SDR YENA2026020200104Ignition Sys · faultedFLT 523, JFK - LAX (ETOPS) . ENG 2 IGN B FAULT, AFTER ENGINE STARTED ( IGNITION SYSTEMS B) SYSTEM B ). R & R IGN B IN ENG NR 2 IAW AMM 74-21-01. OPS TESTED GOOD.SDR YENA2026020200103Eec · faultedFLT 8605, JFK - SAL (ETOPS). NR 2 ENG MINOR FAULT, SENSOR FAULT MESSAGE SHOWN ON UPPER ECAM. REF AEROMAN NRC2026-39088, R & R ELECTRONIC ENGINE CONTROL (EEC) IAW AMM 73-21-01-000- 801-A , AMM 73-21-01-400-801-A, PERFORMED OPERATIONAL TEST EEC IAW AMM TASK SDR YENA2026020200102Seal · dirtyFLT 20, LHR - JFK (ETOPS). REPEAT WRITE UP FROM PREVIOUS LEGS IN CRUISE FLIGHT, STEADY LOUD NOISE COMING FROM AROUND VICINITY. SOUND IS CONSTANT, LOW-FREQUENCY HUM. ; PERFORMED THE VISUAL INSPECTION OF EMERGENCY EXIT DOOR SEALS IAW AMM 55-22-00-220-002-A. CLESDR DALA2026020200774Wire · damagedEMERGENCY LIGHTS OUT ON SEAT 20IH AND 21IH. REPAIRED WIRING PER A330 ESPM 20-43. OPS CK GOOD. (7113154)SDR DALA2026020200773Seat Track · corrodedSEAT TRACK CORRODED R/S BEHIND LAV FRAME 33 -Y1959 RBL. REPLACED SEAT TRACK PER A330 SRM 51-42-11 AND AIRBUS DWG F53276401. (1429614)SDR DALA2026020200772Seat Track · corrodedSEAT TRACK CORRODED R/S BEHIND LAV FRAME 35 -Y1959 RBL. REPLACED SEAT TRACK PER A330 SRM 51-72-11-911-001. (1429611)SDR DALA2026020200771Roller · looseRIGHT WING OTBD FLAP ASSY. OTBD GUIDE ROLLER LOOSE. REPLACED ROLLER IAW AMM 27-54-73. OK FOR SERVICE. (1428440)SDR DALA2026020200770Light · brokenSHIP 3314 LIGHT FRAME AT SEAT 41B BROKEN. CORRECTIVE ACTION: R/R 41B EMERGENCY LIGHT FRAME PER AMM A330-300 TASK 33-51. OK FOR SERVICE. (8019166)SDR DALA2026020200769Frame · damagedTOOLING DAMAGE ON FRAME BETWEEN STR 5R AND 6R. REPAIRED PER ERA 631753-14. (1429262)SDR DALA2026020200762Panel · faultedDUE TO FAINT ELECTRICAL SMELL. FOUND CAM CARD 115RH IN FAP (120RH) PANEL FAULTING AND WITH HIGHER SCENT OF ELECTRICAL ODOR. REPLACED CAM AND FAP. (LP 7725688)SDR YENA2026020200096Unknown · odorFLT 837, JFK- STI . A CABIN ODOR EVENT. THE FLT CREW REPORTED THAT A TRANSIENT FUME EVENT OCCURRED DURING FINAL DESCENT FROM 9,000 FT TO 5,000 FT INTO STI. FUMES SMELLED LIKE A MAGIC MARKER OR NAIL POLISH. FUMES WERE BRIEF & ONLY SMELLED IN FLT DECK. NO ODSDR YENA2026020200095Compressor · stalledFLT 1069, BOS-FLL, (EMERGENCY DECLARED). TURNING BASE TO FINAL AT 3000 FEET, WE FELT A VIBRATION AND STRONG BURN SMELL. NR 2 ENGINE WAS HAVING COMPRESSOR STALL AND EGT WAS HIGH AT 651 AT THAT POINT WE SHUTDOWN THE NR 2 ENGINE. REMOVED AND REPLACED NR 2 ENGSDR A6WA202601318875Selector Valve · faultedGEAR DISAGREE WARNING WITH TRIPLE CHIME AFTER TAKE OFF. C/W QRH, DECLARED EMERGENCY, AND RETURNED TO MSP. WARNING OCCURRED 28 SECONDS AFTER TAKE OFF, NO OTHER MSGS, NOSE GEAR RED, MANUAL RELEASE USED, HYD PUMPS AUTO, 160KTS, SMOOTH LANDING. REMOVED FLAGS FROM SDR FDEA202601310109Battery Pack · no testEMERGENCY LIGHT TEST SWITCH DOES NOT TEST. ENTRY AREA, RED EMER LT SWITCH DOES NOT ILLUMINATE EMERGENCY LIGHTS, SWITCH DOES ILLUMINATE RED. REMOVED & REPLACED THE EMERGENCY POWER SUPPLY BATTERY, OP TESTED GOOD.SDR ABXA2026020231043Start Valve · failedON TAXI OUT WHILE STARTING LEFT HAND ENGINE START VALVE DID NOT OPEN ,LEFT STARTER EICAS MESSAGE APEARED. AC RETURNED TO THE GATE AND MTX GROUNDED AC AND DEFERRED LH START VALVE FOR DEPATURE IAW MEL ABX-80-00-2-1.AND RETURNED AC TO SERVICE.SDR MASA2026013100006Valve · inoperativeBOTH BLEEDS INOP/R&R ENG 1 FAN AIR VALVE OPS CHECK GOOD NO FURTHER DEFECTS NOTEDSDR ABXA2026131042Lamp · inoperativeDURING TAXI OUT CREW REPORTS LH ENG BLEED OFF LIGHT INOP. ACFT RETURNED TO THE GATE (BTB) AND MTX GROUNDED AC. MTX RELAMPED LH BLEED OFF LIGHT IAW AMM 33-11-00, OPS CHECK GOOD AND RETURNED AC TO SERVICESDR DALA2026020200757Mmr · not reportedREMOVED MMR 2 IAW ER/A 625937-14. INSTALLED MMR 2 PER ER/A 625937-14 REV. B (1428881)SDR SCNA20260202051Bulb · inoperativeTWO EMERGENCY LIGHTS ABOVE R1 DOOR INOP. R & R THE TWO EMERGENCY LIGHT BULBS ABOVE R1 DOOR IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SCNA20260202050Glowstrip · detachedEMERGENCY GLOW LIGHT STRIP IN ISLE AT 12 DEF LOOSE ON FLOOR. REATTACHED FLOOR GLOW STRIPPING AT ROW 12 DEF IAW AMM 25-27-00SDR DALA2026020200752Unknown · odorDURING APPOACH OUT OF 12000', FA 1 REPORTED FUMES IN THE FWD GALLEY. SMELLED LIKE BURNING RUBBER. DEADHEAD CREW IN FIRST CLASS DID NOT SMELL. ODOR DISSIPATED AFTER TURNING OFF EXTRACT BLOWER, AND GALLEY AND PUSH BUTTONS ON OVERHEAD. EVENT LASTED 3-5 MINS. SDR DALA2026020200750Oxygen Mask · unwanted deployOXYGEN PANEL, MASK DEPLOYED DURING TAKEOFF, AT SEAT 23ABC. TRIED OUR BEST TO STOW THEM, BUT THEY WILL NEED TO BE PUT BACK TOGETHER CORRECTLY. STOWED PSU PANEL AT ROW 23 ABC REF AMM 35-21. (LP: 1429256)SDR DALA2026020200744Hinge Arm · wornWEAR ON HINGE ARM 5 ELEVATOR ON RH HORIZONTAL STABILIZER. C/A: REPLACED HINGE ARM 5 ELEVATOR ON RH HORIZONTAL STABILIZER IAWAMM 55-16-42-000-001-A, & AMM 55-16- 42-400-001-A. (LP: 1429575)SDR DALA2026020200743Fitting · wornWEAR ON HINGE ARM FITTING 2 AT HORIZONTAL STABILIZER RH SIDE ( 1E/A) (REFER TO AMDS CARD 2734-4001-RT RII). REPLACED HINGE ARM FITTING NR 2 AT HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A. (LP 1429561)SDR CALA2026020213480Battery · no testEMERGENCY LIGHTS - OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - AFT SECTION OF THE PASSENGER CABIN EMERGENCY SEAT LIGHTS ARE INOP REPLACED EMERGENCY POWER BATTERY PACK FOR AFT SEC OF EMERGENCY PROX LIGHTS ON SEATS WITH REF TO AMM TASK 33-51-06-960-80SDR CALA2026020113462Power Supply · no testEPSU UNIT FWD L FAULT DISPLAYED AFTER TESTING OF THE EMERGENCY LIGHTS. R & R EPSU IAW AMM 33-51-38/401, CONFIG 00. OPS CHECKED GOOD.SDR CALA2026020113460Oven · fodFLIGHT CREW REPORTED, FWD GALLEY HAS A STRONG ELECTICAL BURNING ODOR ON GALLEY CARTS ON BOARD. NO SIGNS OF SOURCE. UNABLE TO DUPLICATE, INSPECTED AND SUSPECT SOME PLASTIC MAY HAVE BEEN BURNED IN THE OVEN FAN ON PREVIOUS FLIGHT. CLEANED OUT OVEN. VERIFIED NO SDR CALA2026020113459Smoke Detector · false indicationFIRE ALARM WENT OFF IN LAV 2L. THERE WAS NO SMOKE OR FIRE ASSOCIATED WITH IT. INSPECTION OF AFT LT LAV SMOKE DETECTOR, NO AURAL TONE HEARD AND FOUND NO EVIDENCE OF SMOKE OR ANY BURNING ODOR IN THE LAV. PERFORMED OPS CHECK OF THE LAV SMOKE DETECTOR IAW AMMSDR CALA2026020113458Unknown · odorFWD GALLEY HAS A STRONG ELECTICAL BURNING ODOR ON GALLEY CARTS ON BOARD, NO SIGNS OF SOURCE. SECURED WINDOW TRIM OPS CHECK GOOD.SDR 2026FA0000071Tire · deflatedWHILE CONDUCTING A CHECK RIDE FOR A MULTI ENGINE ADD ON TO A COMMERCIAL RATING IN A DA-42, N42MV, WE EXPERIENCED A TIRE MALFUNCTION ON THE LANDING AT KBQK. INITIALLY CONCERNED HAD STRUCK FOD ON THE RUNWAY BUT AS WE CLEARED THE RUNWAY AND PARKED THE AIRCRAFT,SDR 2026FA0000070Power Supply · inoperativeR/H MID TO AFT EMERGENCY LIGHT POWER SUPPLY INOPSDR 2026FA0000069Power Supply · inoperativeR/H MID TO AFT EMERGENCY LIGHT POWER SUPPLY INOPSDR 2026FA0000068Brake Disc · separatedAPPROX. 12 MONTH OLD RIGHT MAIN GEAR BRAKE DISC, RAPCO PART #RA164-02504, SEPARATED DURING APPLICATION OF BRAKES DURING LANDING SEQUENCE. RESULTING DAMAGE REQUIRED REPLACEMENT OF INNER HUB AND PADS.SDR SWIA2026013075742Rib · corrodedLEFT WING BATTERY RIB AT WS58.88, FWD LOWER ANGLE IS CORRODED THROUGH (601R10205-7). REMOVED AND REPLACED FWD LOWER ANGLE ON WS 58.8 LT BATTERY RIB REF. SRM 51-42-21 AND DWG. 601R10205 REV. -F.