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 AALA202511258459Pin · brokenAIRCRAFT WAS NOT GROUNDED: ROW 20ABC SEAT WALL EMERGENCY LIGHT NOT ILLUMINATING. MAINTENANCE FOUND WIRE BROKEN ON CONNECTOR OF HARNESS THAT CONNECTS TO 7260VC10. MAINTENANCE REPLACED PIN IAW ESPM 20-48-21 AND WDM 33-51-08.SDR AALA202511251507Light · no testAIRCRAFT WAS NOT GROUNDED: E-PATH EMERGENCY LIGHT ON SEAT 5H ARE INOP. MAINTENANCE REPLACED E-PATH EMERGENCY LIGHT ON SEAT 5H IAW AMM 33-51-05 AND IAW SSM 33-51-58.SDR AALA202511252082Elec Connector · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY PROXIMITY FLOOR LIGHTS INOP ROW 13DEGH TO 19DEGH. MAINTENANCE FOUND CONNECTOR AT 19DEGH DISCONNECTED AND BROKEN. MAINTENANCE REPLACED EMERGENCY LIGHT P1 CONNECTOR IAW SWPM 20-61-28.SDR DALA2025112508594Warning Message · illuminatedATB - A/C RETURNED TO ATL DUE TO LEFT ENGINE STATOR ANTI-ICE ECAM MESSAGE. UNABLE TO AVOID ENROUTE ICING CONDITIONS. REPLACED LEFT ENGINE EEC. (LP# 8042352)SDR DXTA2025112505808Indicator · inoperativeRIGHT MAIN LANDING GEAR INDICATOR BULB DID NOT ILLUMINATE WHEN EXTENDING GEAR. FOLLOWED CHECKLIST AND PERFORMED EMERGENCY GEAR EXTENSION BLOW DOWN WITH BOTTLE CORRECTIVE ACTION: POWERED AIRCRAFT AND FOUND RH MAIN LANDING GEAR INDICATOR NOT ILLUMINATED.TAPPED SDR DXTA2025112505813Door · lack of lubeMAIN CABIN DOOR EXTREMELY DIFFICULT TO OPEN. VERIFIED DISCREPANCY. DOOR WAS MOVING IN A JERKING MANNER. PULLED AND RESET PCB NC101, AND CLEANED AND LUBED DOOR SEAL REFER TO CE-680A AMM 24-60-40 AND 52-10-04. OP CHECKS SUCCESSFUL. NO DEFECTS NOTED AT THIS TIMSDR DALA2025112508590Longeron · crackedWORKING AMDS 5352-01038-01A W/P 2967182 STEP 10D FOUND LONGERON P/N C02383111-001 CRACKED MID LENGTH ADJ TO TIE ROD IN THE VICINITY OF LBL 40.0. REMOVED LONGERON P/N C2383111-001 VICINITY OF LBL 40.0 RH 177277. INSTALLED LONGERON, PER WORK CARD 5352-01038-07A.SDR YENA2025112501120Unknown · odorFLT#803, JFK-SJU. "DESCENT @ 6,000 STRONG DIRTY SOCK SMELL AND AGAIN @ GATE; COMPLIED WITH INFORMATION NOTICE 2017-T015L, SECTION A, ISOLATED FAULT TO TYPE 10 AMBIENT AIR, PER TSM 05-50-00-810-085-B/TSM / 05-50-00-810-085-D."SDR CALA2025112511466Wire · brokenSEAT 31 EMERGENCY PATHWAY, LIGHT INOPERATIVE FOUND WIRES BROKEN LEADING TO SEAT 31D EXIT PATH LIGHTING. PERFORMED WIRING REPAIR WITH TWO (2) BUTT SPLICES REF ESPM 20-43-11-01. OPS CHECKED GOOD .SDR CALA2025112511455Oven · dirtyFAS REPORTED FUMES IN REAR OF AIRCRAFT 10 MINS INTO FLIGHT. 4 6 PERSONNEL PUT ON O2CREW DEBRIEF CARRIED OUT, FORM 46-6020 ATTACHED AND SENT TO TOM-C. SMOKE/FUMES IN CABIN INSPECTIONS CARRIED OUT AS PER AMM 05-51-56-940-801-C1, STEP 1.A - 1.D.(8). UNABLE TO REPSDR CALA2025112511453Intercostal · faultyFWD WET AREA INTERCOSTAL BETWEEN STA 344 AND 360 AT LBL 11 IS CRACKED. (REF AAR NR 99975511) INSTALLED INTERCOASTAL AT FWD WET AREA BETWEEN STA 344 AND 360 LBL AS PER SRM 51-40-02-0G-0 DWG NO. 141A5400. REMOVED AND REPLACED INTERCOASTAL AT FWD WET AREA BETWEESDR CALA2025112511451Tire · separated05 MLG TIRE FOUND BEYOND AMM LIMITS. MUST BE REPLACED PRIOR TO T HE NEXT FLIGHT. TIRE DEFLATED IN FLIGHT AND BEAD BROKE OFF RIM UPON LANDING. SEE ATTACHED PICS. REMOVED AND REPLACED #5 MLG WHEEL ASSEMB IAW. 32-45-01, NO FURTHER DEFECT NOTED.SDR CALA2025112511449Power Supply · faultedEPSU INT LOAD FWD LEFT MSG WHILE RUNNING OPS CHECK OF EPSUS REF AMM 33-51-00-710-001-A. R&R FWD EPSU (10WL) REF AMM 33-51-38-000-001-A. RE-ACCOMPLISHED OPS CHECK OF EPSUS BY BITE-CHECK REF AMM 33-51-00-710-001-A AND OPS CHECK PASSED AT THIS TIME. SEE PICS. OK SDR DALA2025112508573A/C Pack · failedDUE TO BURNING OIL ODOR FOLLOWED BY THE APPEARANCE OF A WHITE HAZE. AFTER LANDING RECEIVED PACK 1 ECAM MESSAGE. CORRECTIVE ACTION: FOUND PACK 1 FAILED. PLACED ACM ON MEL AND THEN REPLACED ACM. OPS CHECK GOOD. MEL AND PLACARD REMOVED. (7933836)SDR AALA202511245682Slide · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SLIDE IS VISIBLE UNDER THE BUSTLE ONTHE FORWARD SERVICE DOOR. TUCKED FABRIC SLEEVE UNDER SLIDE BUSSEL. PER GPM 17-11-4.SDR FDEA202511232199Modulating Valve · failedDURING DESCENT, FLIGHT DECK TEMP EXCESSIVELY COLD. RAN ECL CABIN TEMP COLD CHECKLIST WITHOUT IMPROVEMENT. DESCENDED FOR MANUAL VENTILATION. FLIGHT DECK TEMP REACH 15C AND TRIM AIR/COCKPIT AIR STILL FULL COLD. AMM: 21-61-02-4 FIM: 21-22-00-2/803 NOTE THSDR SWIA202511240025Clamp · out of adjustANTI-ICE DUCT WARNING MESSAGE DURING APPROACH , WHILE IN ICING CONDITIONS. RIGHT FUSELAGE SECTION SHOWED RED ON EICAS PAGE. RAN QRH; MESSAGE EXTINGUISHED AFTER APPROXIMATELY 6 MINUTES. UPON ARRIVAL TO AIRCRAFT INTERROGATED MDC & FOUND B1 CODE 349543 & 349542.SDR WX0A2025112432647Battery Pack · no test(AIRCRAFT NOT GROUNDED) EMERGENCY LEFT BAT/EPSU 11WL & 10WL FAULT FROM EPSU CAP TEST / REMOVED AND REPLACED EPSU PER WO536709"SDR WX0A2025112432646Cover · detached(AIRCRAFT NOT GROUNDED) ON RIGHT SIDE MID EXIT DOOR, SLIDE COVER IS COMING OFF / RE- INSTALLED RH MID EXIT DOOR COVER REF AMM 52-23-03-400-801"SDR WX0A2025112432644Flashlight · no test(AIRCRAFT NOT GROUNDED) AFT FA FLASHLIGHT DID NOT PASS PRE FLIGHT CHECK / REPLACED AFT RIGHT FA FLASHLIGHT BATTERY IAW CMM 25-60-02. ALL CHECKS GOOD. THIS CLEARS MEL 25-60-08A CAT C MDDR 222767. M ACTIONS REVERSED. PLACARD REMOVED."SDR AALA202511244252Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEATS 14H INOP. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 14H REF AMM 33-51-05. LIGHTOPS CHK OK.SDR AALA202511240227Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEATS 15H INOP. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 15H REF AMM 33-51-05. LIGHTOPS CHK OK.SDR AALA202511248287Shade · stuckAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE IN 10F (EMERGENCY EXIT) IS STUCK IN THE DOWN POSITION. MAINTENANCE REMOVED AMD REPLACED THE SHADE.SDR AALA202511241266Bottle · no testAIRCRAFT IN BASE MAINTENANCE: DO NOT PASS OPERATIONAL TEST DOOR DAMPER DAMPING FUNCTION AT PASSENGERCREW DOOR 832. MAINTENANCE REPLACED DOOR DAMPER AT PASSENGER CREW DOOR 832 I.A.W A320 FAM AMM 52-13-14-000-001-B AND A320 FAM AMM 52-13-14-400-001-B.SDR AALA202511242560Bottle · no testAIRCRAFT IN BASE MAINTENANCE: DO NOT PASS OPERATIONAL TEST DOOR DAMPER DAMPING FUNCTION AT PASSENGERCREW DOOR 842. MAINTENANCE REPLACED DOOR DAMPER AT PASSENGER CREW DOOR 842 I.A.W A320 FAM AMM 52-13-14-000-001-B AND A320 FAM AMM 52-13-14-400-001-B.SDR VNAA2025112411102Light · sparksCA SIDE READING LIGHT SPARKED AND SMOKED. / REMOVED AND REPLACED CA SIDE MAP READING LIGHT IAW AMM 33-13-03-000/400-801. OPS TEST GOOD.SDR VNAA2025112411101Smoke Warning · no discrepancySMOKE AFT LAV WARNING MSG CAME ON APPX. 20SEC. ON FINAL / CONFIRMED PASSENGER SMOKING IN AFT LAV.SDR DALA2025112408544Bearing · excess playLEFT WING INTERCONNECT STRUT, FWD ROD BEARING WITH PLAY AND NUT WITH RUST. CORRECTIVE ACTION: REPLACED ROD END AND NUT PER A319 CMM TASK 57-52-17-000-801-A01. (1317794)SDR DALA2025112408543Rod · excess playRT WING INTERCONNECT STRUT, FWD ROD BEARING WITH PLAY. REPLACED ROD END IAW A319 CMM TASK 57-52-17. OK FOR SERVICE. (1317780)SDR DALA2025112408539Seat Track · corrodedCORROSION PASSENGER AFT UTILITY AREA AT Y=1162,5 BETWEEN FR66+120MM AND FR67+400MM BEAM WITH CORROSION AROUND THE HOLES. REPLACED FLOOR BEAM P/N: D5347217220400 IAW A319 SRM TASK 51-72-11-900-001. (1317769)SDR DALA2025112408538Floorbeam · corrodedPASSENGER AFT UTILITY AREA AT FR68, Y= 1162,5 BEAM WITH CORROSION. REPLACED FLOORBEAM AND SPLICES IAW SRM TASK 51-72-11-900-001. (1318068)SDR AALA202511240617Coffeemaker · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO IAH DUE TO THE FLIGHT CREW REPORTING THAT IN CRUISE AT FL320 A FLIGHT ATTENDANT REPORTED A STRONG PUNGENT, ACRID SMELL IN THE AFT GALLEY, COMING FROM THE AIR VENT BY THE COFFEE MAKERSDR AALA202511241495Bottle · 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 AALA202511241847Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 1R DOOR SHOWING CHECK DOOR PRESSURE ON FLIGHT ATTENDANTS CIDS PANEL. MAINTENANCE SERVICED 1R DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00 WHICH CLEARED THE CIDS MESSAGE.SDR AALA202511246790Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202511242620Handle · looseAIRCRAFT WAS NOT GROUNDED: DOOR 3L SLIDE ARMING LEVER IS LOOSE. MAINTENANCE RETIGHTENED L3 DOOR "ARMED" "DISARMED" GRIP PLATE HANDLE PER AMM 52-22-22.SDR AALA202511247244Wire · brokenAIRCRAFT WAS NOT GROUNDED: SEAT ROW 18ABC SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND BROKEN WIRE ON FLOOR BENEATH SEAT 18A, REPAIRED WIRE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO ISSUES NOTED.SDR AALA202511245656Battery · 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 PER AMM 33-51-38.SDR AALA202511245727Lever · looseAIRCRAFT WAS NOT GROUNDED: DOOR 3L ARMING LEVER LOOSE. MAINTENANCE TIGHTENED HARDWARE ON DOOR 3L ARMING LEVER PER AMM 52-22-22.SDR AALA202511245349Bottle · 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 DALA2025112408535Shuttle Valve · leakingFLT DIVERTED TO DEN DUE TO LT HYD SYS QTY DECREASED WITH TRANSFER TO RT HYD SYS DURING FLIGHT. R & R RT A/S SHUTTLE VALVE AND MAIN LANDING GEAR SELECTOR VALVE.SDR DALA2025112408532Girt Bar · out of limitsTHE ENGAGEMENT BETWEEN THE GIRT BAR SLIDER AND FWD FLOOR FITTING WERE FOUND OUT LIMITS AT R2 DOOR. GIRT BAR WAS REPLACED AND P/N WAS VERIFIED PER IPC 25-66-05 AND OPERATIONAL TEST WAS PERFORMED PER AMDS 2561-01257-01D STEP 10 AND 12 TEST OK. ALSO, GIRT BAR WASDR SIMA202511243001Door · malfunctionedL1 DOOR WOULD NOT OPEN FROM OUTSIDE. VENT FLAPS ARE FLUSHED WITH THE DOOR AND NOT MOVABLE. OPENED DOOR WITH NO ISSUE. PERFORMED FUNCTIONAL CHECK OF L1 DOOR VENT FLAP. VENT FLAP OPERATES AS REQUIRED IAW AMM 52-11-25. NO OTHER DEFECTS FOUND.SDR YENA2025112401118Fmc · faultedFLT 133, BOS-SFO. (ETOPS) ECAM FUEL ACT XFR FAULT ( CAUTION ON ECAM 5) ACT XFR FAULT (ACT) ); PER TECH SUPPORT REMOVED AND REPLACED AFMC (2QN) IAW AMM 28-51-35. OPS CHK GOOD. ACCOMPLISHED PRIMING OF ACT FUEL PUMPS & ACT FUEL TRANSFER IAW AMM 28-00-00. OPS CHKSDR JR2R20251123486Shear Tie · corrodedSHEAR TIE AT FR75 BETWEEN STR 28R AND STR 29R CORRODED. REPLACEDSDR JR2R20251123205Skin · erodedRIGHT WING SLAT 4 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251123204Skin · erodedRIGHT WING SLAT 3 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251123203Skin · erodedRIGHT WING SLAT 2 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251123202Skin · erodedRIGHT WING SLAT 1 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.SDR JR2R20251123201Skin · erodedLEFT WING SLAT 4 HAS SEVERAL AREAS OF EROSION DAMAGE ON LEADING EDGE.