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 SWAA2026010658063Lock · looseSEAT 11D OVER RECLINES INTO EXIT ROW. SECURED RECLINE LOCK IAW CMM 25-21-42. NO FURTHER DEFECTS NOTED FOR SEAT 11D.SDR SWAA2026010658116Flashlight · inoperativeAFT GALLEY FLASHLIGHT (FO SIDE) INOPERATIVE. SECURED AFT GALLEY FO SIDE INBD FLASHLIGHT & PERFORMED FLASHLIGHT CHECK PER AMM 35-64-00. OPS CHECK GOOD.SDR DALA2026010600109Indicator · inoperativeL4 KNUCKLE KNOCKER WON'T EXTEND WHEN SLIDE ARMED. REMOVED DEBRIS FROM AROUND KNUCKLE KNOCKER. OPS OK. (8143184)SDR AALA202601062491Door · not openedAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR DRAGGING ON THE BOTTOM AND DIFFICULT TO OPEN. ADJUSTED FORWARD FIRST CLASS LAVATORY DOOR. PER AMM 25-40-00.SDR AALA202601060538Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LAVATORY-D BIFOLD DOOR VERY HARD TO OPEN AND CLOSE. LUBRICATED AFT LAVATORY-D BIFOLD DOOR ROLLER.SDR DALA2026010600102Battery Pack · inoperativeDISPATCH MSG- EMERGENCY EXIT LIGHT. INSPECTED AND FOUND FAULT CODE 3350F00Q. REMOVED AND REPLACED EMER BATTERY FOR EPSU 102WL2 IAW AMM A350-33-51-32. OPS CK GOOD. (LP# 8399754)SDR ASAA2026010463574Hinge · lack of lubeFA REPORTS L1 DOOR DIFICULT TO OPEN AND CLOSE. GROUNDED - YES. PERFORMED L1 FWD ENTRY DOOR SYSTEM TEST- OPEN/CLOSE TEST FAIL. REF AMM = AMM 52-11-00. BALVAREZ 1057044 01/03/2026FOUND UPPER L1 DOOR HINGE NEEDING LUBRICATION. GREASED UPPER HINGE. PERFORMED FORWASDR YENA2026010600014Filter · contaminatedFLT#1791, LGA-PBI. "ODOR EVENT ABOUT 15000 APU NOT ON VMC CONDITION; COMPLIED WITH INFORMATION NOTICE 2017-T015M, STEPS 1&2. IDENTIFIED ODOR TYPE 9 PER TSM 05-50-00-810-085-B. DECONTAMINATION A WAS ACCOMPLISHED 21-00-00-615-802. (HEPA FILTERS REPLACED). AIRCRASDR DALA2026010600099Oxygen Mask · no testFO'S STOWAGE BOX FOR OXYGEN MASK WILL NOT TEST PROPERLY. C/A: REPLACED FO'S OXYGEN MASK STOWAGE BOX PER A320 AMM 35-12. CKS OK. (LP: 8088495)SDR 2026FA0000002Gearbox · warning lightDURING FLIGHT MGB CHIP LIGHT ILLUMINATED. PILOT ATTEMPTED TWO ATTEMPTS AT BURNING THE CHIP. LIGHT REMAINED ON SO PILOT ELECTED TO MAKE AN UNSCHEDULED LANDING AT A NEARBY AIRPORT.SDR AALA202601060628Elt · inoperativeAIRCRAFT IN BASE MAINTENANCE: FWD ELT DOES NOT POWER ON DURING SELF TEST. MAINTENANCE REPLACED FWD PORTABLE ELT I.A.W. AMM DMC-B787-A-25-63-01-999-921A-A AND PERFORMED OPERATIONAL TEST OF PORTABLE EMERGENCY LOCATOR TRANSMITTER I.A.W. AMM DMC-B787-A-25-63-01-99SDR AALA202601064833Oven · odorAIRCRAFT WAS GROUNDED: SMELL OF MELTED PLASTIC NOTICED IN THE COCKPIT AS WELL AS AFT CABIN. #1 FA SHUT OFF OVEN IN FORWARD GALLEY AND SMELL DISSIPATED. NOTHING FURTHER NOTED. AFTER COMPLETING J/C 26L00021001 SOF TROUBLESHOOTING FOUND NUMBER ONE OVEN COULD BE TSDR QMLA2026010620001Relay · malfunctionedPRE-TAKEOFF, TAXI, & TAKEOFF NORMAL. AFTER LIFTING & CLIMBING, AUTOPILOT WOULD NOT ENGAGE WHEN TURNED ON. CONTINUED FLT. DURING CLIMB, DISPLAY 2 STARTED PULSING ON & OFF ABOUT A 2 SEC REP RATE. APPROACHING TARGET ALTITUDE, RUDDER TRIM OUT OF ALIGNMENT, RUSDR CALA2026010612708Anti-Ice Valve · faultedANTI ICE ENG R EICAS DISPLAYED WITH EAI PRSOV R STATUS ACCOMPLISHED FIM TASK DMC-B787-A-30-20-F1-05A-421A-A THRU STEP 1B(2)(D)3. FOUND ENGINE ANTI ICE VALVE FILTER COLLAPSED. SEE PIC. REMOVED AND REPLACED FILTER REF AMM 30-21-08. FOUND AIR SUPPLY LINE AT ANTSDR CALA2026010612700Channel · corrodedFWD CARGO RIGHT ZEE CHANNEL IS CORRODED FROM BS 500A TO 500I AT NUT PLATE HOLES AND OTHER AREAS. REMOVED AND REPLACED FWD CARGO RH ZEE CHANNEL FROM 500A TO 500I PER SRM 51-40-02-0G-0 AND DWG#143A7500SDR CALA2026010612699Smoke Detector · false activationFWD LAV A FIRE ALARM WENT OFF IN CRUISE FOR 2 -3 MINUTES. NO SMOKE/FIRE INDICATIONS. STOPPED. VERIFIED NO INDICATIONS OF FIRE ON LAV A TRASH WAHL TEMP PLATE RECORDER. REPLACED SMOKE DETECTOR PER AMM 26-14-01-400-801-003 INSTALLATION SEL TEST PASSED PARTS USED:SDR CALA2026010612691Switch · faultedLAV E EMERGENCY LIGHT STUCK ON UPON ARRIVAL TO AC FA REPORTS LAV E CALL LIGHT COULD NOT BE EXTINGUISHED. FOUND CALL SWITCH STICKING WHEN PRESSED. REPLACED LAV E CALL SWITCH. LIGHT AND SWITCH BOTH OPERATE NORMALLY AT THIS TIME. REF AMM 33-27-00-960-802SDR CALA2026010612689Spinner · leakingINBOUND CREW REPORTING OILY/WET SOCK SMELL ON DESCENT TO SAN, APU NOT RUNNING AT TIME OF EVENT. RAN APU FOR SEVERAL MINUTES AT SEVERAL TEMP LEVELS. NO SMELL NOTED IN COCKPIT. FOUND OIL DEBRIS IN ENGINE NR2 NOSE SPINNER CONE. REMOVED SPINNER CONE COVER IAW AMMSDR F3LA202601050346Battery Pack · no testAIRCRAFT WAS GROUNDED. DURING HEAVY CHECK EPSU BATTERY TEST FLAGGED BAT/EPSU (12WL) EMER R -AIRCRAFT REMOVED FROM SERVICE. REMOVED AND INSTALLED SERVICEABLE BATTERY IN POSITION 12WL. IAW AMM 33-51-38-400-002-A. OPS CHECK GOOD. /END/.SDR AALA202601057985Proximity Switch · out of adjustAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB TO 5000 FORWARD CARGO DOOR LIGHT ILLUMINATED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. PSEU BITE PREVIOUS FLIGHT FAULTS 52-72001. NO EXISTING FAULTS SHOWN. TROUBLESHOT PER SDR YENA2026010500008None · noneFLT # 872 SLC - JFK (ETOPS) CORRECT TOTAL TIME AND TOTAL CYCLES (SUPPLEMENTAL INFORMATION)SDR YENA2026010500012Cartridge · not reportedFLT 1408 CDG- JFK (ETOPS). " DUE TO REMOVAL AND REPLACEMENT OF CARGO FIRE BOTTLE 4010-WX, CARTRIDGE 4011-WX REQ. REPLACEMENT.; REMOVAL AND REPLACMENT OF CARTRIDGE 4011-WX IN REF W/ AMM 26-23-41. OPC GOOD. NO DEFECTS NOTED."SDR GTIA2025010539237Megaphone · no testL1 BULLHORN WILL NOT TEST-REMOVED AND REPLACED L1 MEGAPHONE IAW AMM 25-65-51 OPS CHECK GOOD MOC 120719SDR GTIA2025010539236Unknown · odorSTRONG HYD SMELL ON TAKEOFF. PACK 1 OFF ISOLATED SMELL. APPARENT CABIN SOURCE CABIN AIR SUPPLY VENTS, VISIBLE SMOKE / HAZE NO, MEDICAL ATTENTION REQUIRED NONESDR DALA2026010500080Elec Connector · broken31AB EPLS LIGHT INOP. REPAIRED BROKEN CONNECTOR PER A330 ESPM 20-44. OPS CHECKS GOOD. (8023704)SDR DALA2026010500079Bottle · low pressureDOOR 1L, 1R, 2L, 2R, 3R, 4L, & 4R ASSIST BOTTLES LOW. SERVICED DOOR BOTTLES PER A330 AMM 52-15. (8215585)SDR DALA2026010500077Shear Tie · damagedTOOLING DAMAGE ON SHEAR TIE AT FRAME 63, STRINGER 3R. REPLACED SHEAR TIE PER A330 SRM 53-11. (1385221)SDR GTIA2025010539235Megaphone · inoperativeAFT MEGAPHONE INOPERATIVE. R & R AFT MEGAPHONE IAW SPIRIT AIRLNES EMERGENCY EQUIMENT NK 320-233EQSDR YENA2026010500010Valve · inoperativeFLT # 289 JFK-SAN (ETOPS). HOT AIR VALVE CONCIDERED INOPERATIVE. HOT AIR PRESS REGULATING VLV - N703 AND UP CLOSED POSITION . OPENSDR YENA2026010500009Valve · inoperativeFLT 348 LAS-JFK. (ETOPS). " COCKPIT TRIM VALVE INOPERATIVE. REMOVED AND REPLACED TRIM AIR VALVE (12HK) IAW AMM 21-63-51. OPS CHK GOOD. NO FAULTS NOTED AT THIS TIME. GROUND VERIFICATION REQ FOR MDDR 605305 COCKPIT TRIM FAULT. OPS CHK OF THE COCKPIT & CABIN TESDR YENA2026010200008Relay · faultedFLT 872 SLC-JFK (ETOPS) PER TECH SUPPORT REQUEST REPLACE RELAY-APURV CMND (21HV).; REMOVED AND REPLACED RELAY APURV CMND (21HV) OPS CHECK GOOD.IAW ESPN-20-46-50. OPENSDR AALA202601050071Arming Lever · looseAIRCRAFT WAS NOT GROUNDED: ARMING LEVER ON L2 DOOR IS LOOSE. MAINTENANCE SECURED L2 DOOR ARMING LEVER PER AMM 20-21-11.SDR DALA2026010500075Power Supply · inoperative(LOG 7969968) FOUND AISLE OVERHEAD EMERGENCY EXIT LIGHT SIGN AT SEATS 18-21 INOP DURING SVC CHECK. REMOVED AND REPLACED THE EMERGENCY POWER SUPPLY ASSY M1695 IAW B737 AMM 33-51-06. OPS CHECK GOOD.SDR DALA2026010500073Lanyard · misinstalledR2 DOOR SURVIVAL KIT ATTACH LANYARD INSTALLED ON WRONG END OF GIRT BAR UNDER SLIDE COVER. REMOVED SLIDE FROM R2 DOOR AND ROUTED SURVIVAL LANYARD TO FWD GRIT BAR FITTING. INSTALLED R2 DOOR SLIDE IAW A321AMM 25-62. SYSTEM TEST GOOD. (LP 7617134)SDR DALA2026010500072Lanyard · misinstalledL2 DOOR SURVIVAL KIT ATTACH LANYARD INSTALLED ON WRONG END OF GIRT BAR UNDER SLIDE COVER. REMOVED SLIDE FROM L2 DOOR AND ROUTED SURVIVAL LANYARD TO FWD GRIT BAR FITTING. INSTALLED L2 DOOR SLIDE IAW A321AMM 25-62. SYSTEM TEST GOOD. (LP 7617133)SDR DALA2026010500061Floorbeam · damagedUT MEASUREMENT THICKNESS WAS ACCOMPLISHED ON PREVIOUS REPAIR UPPER AND LOWER FLANGE OF BEAM STA 1640 FROM LBL 33 TO RBL 10 AT W4 THEREFORE IT IS OUT LIMITS. BEAM STA 1640 FROM LBL 33 TO RBL 10 AT W4 WAS REPAIRED PER B757-200 SRM 53-00-51-2R PROCEDURE 10. REPASDR DALA2026010500060Floorbeam · damagedUT MEASUREMENT THICKNESS WAS ACCOMPLISHED ON UPPER AND LOWER FLANGE OF BEAM BS 1640 FROM LBL 33 TO LBL 56 THEREFORE IT IS OUT LIMITS. BEAM STA 1640 FROM LBL 33 TO LBL 56 WAS REPAIRED PER SRM 53-00-51-2R REPAIR 11. (1385192)SDR F3LA202601050345Battery · no testEPSU BATTERY FAILED EPSU CIDS TEST. REMOVED AND REPLACED EPSU BATTERY 10WL IN REF WITH AMM 33-51-38-400-002-A. CIDS TEST OPS CHECK GOOD.SDR F3LA202601050344Slide Raft · no testAFT ESCAPE SLIDE (7503MM) REMOVED DUE TO FAIL EPSU TEST. REMOVED AND REPLACED AFT ESCAPE SLIDE (7503MM) REF AMM 25-62-44-400-803-A. PERFORMED CIDES TEST OK.SDR F3LA202601050343Battery · no testEPSU BATTERY FAILED CIDES TEST. REMOVED AND REPLACED EPSU BATTERY 11WL IAW AMM 33-51-38-400-002-A. CIDES TEST OPS CHECK GOOD.SDR F3LA202601050342Battery · faultyEPSU BATTERY FAILED CIDS TEST. REMOVED AND REPLACED EPSU BATTERY 13WL IN REF WITH AMM 33-51-38-400-002-A. CIDES TEST OPS CHECK GOOD.SDR DALA2026010500056Tire · low pressureDUE TO NUMBER FOUR TIRE PRESSURE LOW ECAM MESSAGE. REPLACED TIRES 3 AND 4. (LP 8125096, 1384312)SDR SCNA20260105007Window · leakingLOUD NOISE ,AIR RUSHING ON THE CA SIDE WINDOW. AIRPLANE PRESSURIZATION NOT ASSURED. REMOVED & REPLACED L2 WINDOW ASSY IAW AMM 56-12-11. OPS & LEAK CHECKED GOOD.SDR AALA202601059753Bustle · unsecureAIRCRAFT WAS NOT GROUNDED: F/A REPORTS THEY ARE UNABLE TO ARM AFTER RIGHT CABIN DOOR. RESECURED SLIDE BUSTLE IN REFERENCE WITH AMM 25-62-50.SDR AALA202601059513Bulb · burned outAIRCRAFT WAS NOT GROUNDED: EPSU EXT LOAD EMER R FAULT (EXT LIGHTS FAULT). MAINTENANCE FOUND EXTERIOR BULBS BURNED OUT RE-LAMPED IAW AMM 33-51-15.SDR AALA202601057539Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: REPLACE HINGE ARM 6 ELEVATOR ON RH HORIZONTAL STABILIZER . MAINTENANCE REPLACED HINGE ARM #6 ON ELEVATOR RH IAW A320 FAM AMM-55-16-42-000-001-A AND IAW A320 FAM AMM-55-16-42-400-001-A.SDR AALA202601053101Proximity Switch · false indicationAIRCRAFT WAS GROUNDED: AFTER ONE HOUR AT CRUSE FLIGHT, DOOR 2L ARM INDICATIONS ON FLIGHT DECK DOOR/OXY PAGE INDICATE DISARMED. FLIGHT ATTENDANT PANEL IN FORWARD GALLEY HAS A FLASHING DISARMED INDICATION. DOOR 2L ARM LEVER IS IN THE ARMED POSITION. ALL INDICASDR AALA202601057185Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: REPLACE HINGE ARM 3 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM #3 ELEVATOR ON RH I.A.W A320 FAM AMM 55-16-42-000-001-A AND I.A.W A320 FAM AMM 55-16-42-400-001-A.SDR AALA202601050189Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 4 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM #4 ELEVATOR ON RH IAW A320 FAM AMM-55-16-42-000-001-A AND IAW A320 FAM AMM-55-16-42-400-001-A.SDR SCNA20260105004Battery Pack · inoperativeEMERGENCY EXIT LIGHT ON LEFT OVERWING ILLUMINATE EVEN THOUGH THE SWITCH IS OFF AND WE CAN NOT GET THE LIGHT SO TURN OFF. REPLACED LT OVERWING EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.