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 AALA202507257942Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 14WL DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 14WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507252431Hydraulic System · lowAIRCRAFT WAS NOT GROUNDED: ON APPROACH, WHEN THE GEAR HANDLE WAS SELECTED DOWN, FLIGHT CREW RECEIVED THE 3 RED UNLOCKED INDICATORS BUT ACTUAL GEAR DEPLOYMENT WAS SEVERELY DELAYED, APPROXIMATELY 10 SECONDS. MAINTENANCE FOUND YELLOW HYDRAULIC QUANTITY LOW AND SESDR AALA202507251847Door · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO OPEN AND CLOSE. MAINTENANCE LUBRICATED FLIGHT DECK DOOR PER AMM 52-11-00.SDR AALA202507256066Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WILL NOT OPEN FROM INSIDE IF HANDLE IS TURNED CLOCKWISE. A CLOCKWISE TURN DOES NOT RETRACT THE UPPER LATCH. MAINTENANCE ADJUSTED DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-00.SDR AALA202507258661Skin · wornAIRCRAFT IN BASE MAINTENANCE: LEFT WING LEADING EDGE #2 SLAT LOWER SKIN WORN AT SLAT TRACK 5 INTERNAL SURFACE. REPLACED SLAT PER TASK CARD 26L00027011.SDR DALA2025072505605Door · cracked(LOG 1101514) L/H MLG MIDDLE DOOR ASSEMBLY HAS CRACK IN RIB NEAR LOWER L/E MOUNT. REPAIRED L/H MLG MIDDLE DOOR ASSEMBLY CRACK IN RIB NEAR LOWER L/E MOUNT IAW B737 SRM 52-80-02 REPAIR 3.SDR IXXA20250723035Ball Screw · shearedFIRST OFFICER'S R2 WINDOW WILL NOT CLOSE. UPON INSPECTION FOUND BALLSCREW SHAFT SHEARED AT FORWARD END. REMOVED AND REPLACED R2 WINDOW BALLSCREW ASSEMBLY AND REINSTALLED ORIGINAL LOWER R2 WINDOW TRACK AND R2 WINDOW IN ACCORDANCE WITH BOEING 767 AIRCRAFT MAINTSDR HYIA20250725002Rib · crackedDURING MAINTENANCE A CRACK WAS VISUALLY DISCOVERED ON THE RIGHT HAND CLOSEOUT RIB (P/N: 5122115-56) AT R.W.S. 106.79. THIS CRACK ORIGINATES FROM A HOLE IN THE FORWARD ROW OF FASTENERS COMMON TO THE AFT MAIN LANDING GEAR TRUNNION SUPPORT PLATE AND TRAVELS FORWASDR HYIA20250725001Fitting · crackedDURING SCHEDULED NONDESTRUCTIVE TESTING AS NOTED IN CESSNA SUPPLEMENTAL INSPECTION DOCUMENT (SID) 57-10-16, A CRACK WAS DISCOVERED ON THE RIGHT HAND INBOARD NACELLE FITTING (OEM P/N: 5292029-30) THIS CRACK MEASURES APPROXIMATELY .104 INCHES LONG ON THE LOWER OSDR UIEA2025072301009Flashlight · no testFIRST OFFICER EMERGENCY FLASHLIGHT LIGHT TESTING RED. R & R FO FLASHLIGHT IAW AMM 25-60-00 & TESTED OK.SDR AALA202507256736Bottle · no testAIRCRAFT IN BASE MAINTENANCE: DONT PASS OPERATIONAL TEST PASSENGER CREW DOOR 831 DAMPING FUNCTION OF THE DOOR DAMPER AND EMERGENCY OPERATION CYLINDER. MAINTENANCE REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER ON PASSENGER CREW DOOR 831 AT FWD GALLEY ARSDR AALA202507256588Bustle · dislodgedAIRCRAFT WAS NOT GROUNDED: DOOR L1 DOES NOT LOCK INTO PLACE WHEN OPEN. MAINTENANCE FOUND SLIDE COVER WAS DISLODGED NOT ALLOWING DOOR TO FULLY OPEN, SECURED SLIDE COVER, OPS GOOD. AMM 25-62-50.SDR AALA202507259928Light · dimAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS OVER SEAT 14 OVER HEAD ARE DIM ONLY AND NEEDS REPLACEMENT. MAINTENANCE REPLACED EMERGENCY EXIT LIGHTS OVER SEAT 14 OVER HEAD IAW AMM 25-60-00.SDR ABXA20250723166Inertia Reel · looseDURING POST FLIGHT INSPECTION, FOUND INERTIA REELS #4 AND #7 (SUPERNUMERARY) DROPPED TO FLOOR. DEFERRED #4 AND #7 INERTIA REELS IAW MEL 25-61-1-1. MAINTENANCE PROCEDURES C/W. PLACARDS INSTALLED. MBCB 08/02/2025. AIRCRAFT RETURNED TO SERVICE.SDR YEN202507250005Skin · crackedDURING HEAVY MAINTENANCE: WINGS / RH WING / WING MAIN BOX / LOWER TE SKIN / RIB 9-12 / CRACK – PERMANENT REPAIR (REINFORCEMENT); /1/ ETD2025-190-921573 REV.: A (ANAC FORM 1 INCLUDED) /2/ SRM 57-10-01 /REPAIR 54P. DURING CURRENT (MAY 2025) LEASE RETURN CHECK OFSDR YEN2025F00005Rib · crackedDURING HEAVY MAINTENANCE: WINGS / RH WING / WING MAIN BOX / LOWER TE SKIN / RIB 9-12 / CRACK – PERMANENT REPAIR (REINFORCEMENT); /1/ ETD2025-190-921573 REV.: A (ANAC FORM 1 INCLUDED) /2/ SRM 57-10-01 /REPAIR 54P. DURING CURRENT (MAY 2025) LEASE RETURN CHECK OFSDR CALA2025072506923Sensor · faultedLAV WASTE TANK INDICATION FLUCUATES WHEN AFT LH LAV FLUSHED CORRECTION BOTH AFT LAVS CAUSES FLUCTIOUATION ON INDICATION. BOTH LAVS FLUSH NORMAL, NO LEAKS NOTED TOMC APPROVED IAW MEL 3802F PLACARD INSTALLED *DM* SEE FIM 38-30 TASK 809, SEE M/L FOR CLS & SEALS ASDR CALA2025072506921Control Panel · faultedCABIN PRESSURE AUTO FAIL CLIMBING THROUGH 16900FT. HARD TO CONTR OL IN MANUAL MODE REPLACED CONTROL PANEL PER AMM 21-31-02-401.PERFORMED GRD TEST PER AMM 21-31-00 OK FOR SVC.SDR HALA20250724230Oil Filter · warning messageETOPS - ECAM: ENG 2 OIL SENSOR FAULT OCCURED DURING FLIGHT, NO ACTIONS GIVEN. PER TSM 79-35-00-810-808-A, INSPECTED THE MAGNETIC CHIP COLLECTORS AND WITHIN LIMITS. INSPECTED AND REPLACED MAIN OIL FILTER ELEMENT PER AMM 79-21-06-960-801-A, OPS CHECKED GOOD. IDLSDR QXEA2025072400282Throttle · malfunctionedFLIGHT 2171. DURING T/O REACHING 1000/ AGL THE #2 THRUST LEVER DECREASED TO THE POINT THAT THE A/T DISENGAGED. WE ADVANCED THE THRUST LEVER TO T/O POSTION & REENGAGED A/T. NO FURTHER PROBLEMS NOTED. REMOVED FROM SERVICE AND PLACED ON MEL. MEL CLEARED BY REMOVISDR SWIA2025072400023Wire Harness · faultedON CLIMB OUT ABOUT 6000 FEET MSL PASSENGER DOOR WARN MESSAGE PLUS PROX SYSTEM FAULT 1 STATUS MESSAGE CAME ON (FLIGHT 4818) MDC SHOWS AFT CARGO DOOR PROX SENSOR PX102 WENT OPEN, THEN SHORT. TWO MINUTES LATER, SEVERAL MCD PROX SENSORS FAILED OPEN. THIS WAS FSDR GTIA2025072439013Hinge Fitting · corrodedCORROSION WAS FOUND ON INNER BORE HINGE FITTING N1 AT RH ELEVATOR RAF-01 3550343-01 GENERATED-REPAIRED BORES AND INSTALLED BUSHINGS (2EA) ON HINGE FITTING #1 RH ELEVATOR P/N: D5528000200300, S/N: IC8098, I.A.W A320 SRM 55-26-41-300-004. THIS REPAIR MUST BE INSSDR SWAA2025072494390Seat · out of adjustEMERGENCY EXIT ROW PASSENGER SEAT BACK NOT FULLY LOCKED OUT AT SEAT 13D. RELOCKED SEAT BACK FULLY AT SEAT 13D PER AMM 25-22-00.SDR SWAA2025072494543Flashlight · inoperativeAFT LEFT EMERGENCY FLASHLIGHT INOP. R & R THE LT REAR EMERGENCY FLASHLIGHT IAW MM 25-64-00.SDR SWAA2025072494559Battery Pack · inoperativeAFT FLIGHT ATTENDANT FLASHLIGHT FO SIDE NOT CHARGING. REPLACED FLASHLIGHT BATTERY AND SEAL IAW AMM 25-64-00.SDR GTIA2025072439012Hinge Fitting · corrodedCORROSION WAS FOUND ON INNER BORE HINGE FITTING N4 AT RH ELEVATOR RAF-01 3550343-02 GENERATED-REPAIRED AND INSTALLED BUSHINGS (2EA) ON HINGE FITTING #4 AT RH ELEVATOR P/N: D5528000200300, S/N: IC8098 I.A.W A320 SRM 55-26-41-300-005. THIS REPAIR IS CATEGORY B. SDR GTIA2025072439011Hinge Fitting · corrodedCORROSION WAS FOUND ON INNER BORE HINGE FITTING N6 AT RH ELEVATOR RAF-01 3550342-02 GENERATED-REPAIRED BORES AND INSTALLED BUSHINGS (2EA) ON HINGE FITTING #6 RH ELEVATOR P/N: D5528000200300, S/N: IC8098 I.A.W A320 SRM 55-26-41-300-006. THIS REPAIR IS CATEGORY SDR GTIA2025072439010Hinge Fitting · corrodedCORROSION WAS FOUND ON INNER BORE HINGE FITTING N1 AT LH ELEVATOR RAF-01 3550342-01 GENERATED-REPAIRED BOTH BORES AND REPLACED BUSHING (2EA) ON HINGE FITTING #1 LH ELEVATOR IAW SRM 55-26-41-300-004 P/N: D5528000200200 S/N: 1C814 THIS REPAIR MUST BE INSPECTED TSDR GTIA2025072439009Hinge Fitting · corrodedCORROSION WAS FOUND ON INNER BORE HINGE FITTING N4 AT LH ELEVATOR RAF-01 3550341-02 GENERATED-REPAIRED BOTH BORES AND REPLACED BUSHING (2EA) ON HINGE FITTING #4 LH ELEVATOR P/N: D5528000200200 S/N: 1C8114 IAW SRM 55-26-41-300-005, THIS REPAIR IS CATEGORY B. THSDR GTIA2025072439008Hinge Fitting · corrodedCORROSION WAS FOUND ON INNER BORE HINGE FITTING N6 AT LH ELEVATOR RAF-01 3550341-01 GENERATED-REPAIRED BOTH BORES AND REPLACED BUSHING (2EA) ON HINGE FITTING#6 LH ELEVATOR P/N: D5528000200200 S/N: 1C8114 IAW SRM 55-26-41-300-006, THIS REPAIR IS CATEGORY B MUSTSDR DALA2025072405585Battery Pack · inoperativeSHIP 9577 DURING SVC CHECK FOUND EMERGENCY LIGHT ABOVE R1 WOULD COME ON THEN IMMEDIATELY EXTINGUISH. CORRECTIVE ACTION: REMOVED AND REPLACED BATTERY ASSY B5-259. REF B717 AMM 33-51-04. OPS CHECK GOOD (7321200)SDR DALA2025072405583Cover · damagedSHIP 9504 AFT DOOR ARMING LEVER COVER DAMAGED / POOR CONDITION (B717 ONLY) / LOCATIONS:606. CORRECTIVE ACTION: ADJUSTED LATCH ON AFT BULKHEAD DOOR COVER ASSY (1101257)SDR DALA2025072405582Hinge · corrodedSHIP 9572 AFTER MIDLE FLAP HINGE , CORROSION ON HINGE FITTING HOLES AT LH FLAP. ALSO SCRATCHES HINGE BOLTS (3EA). CORRECTIVE ACTION: HINGE FITTING HOLES AT LH FLAP WERE REPAIRED PER PRI 626829-14 (1101699)SDR AALA202507248406Oven · odorAIRCRAFT WAS NOT GROUNDED: LEFT OVEN FORWARD GALLEY HAS A BURNT SMELL EMANATING FROM IT. CONFIRMED NUMBER 1 OVEN HAS BURNT SMELL. (OPEN).SDR AALA202507248910Lock · bindingAIRCRAFT IN BASE MAINTENANCE: REPEAT ISSUE, LAVATORY-D DOOR LOCK DIFFICULT TO LOCK AND UNLOCK. (OPEN).SDR AALA202507240024Fuel Sys · out of balanceAIRCRAFT WAS NOT GROUNDED: FUEL IMBALANCE THE CENTER TANK HAS MORE THAN 1000 LBS AND WINGS TANKS ARE NOT FULL. (OPEN).SDR AALA202507241211Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATOR- DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY-A DOOR HANDLE, DOOR CLOSES AND OPEN CORRECTLY. PER CMM 25-46-96.SDR DALA2025072405575Seal · leakingAIRCRAFT 5048, ON DESCENT NOTICED INTERMITTENT SMELL SIMILAR TO BURNING RUBBER. CORRECTIVE ACTION: FOUND NOSE SPINNER SEAL LEAKING. REPLACED SEAL PER PW1500G EMM 72-11. (LP 7561494)SDR DALA2025072405574Oxygen Mask · unwanted deploySHIP 3309 LAV C O2 MASK DROPPED TOWARDS END OF FLIGHT. CORRECTIVE ACTION: REPACKED MASKS PER A330 AMM 35-21. OK FOR SERVICE. (7442273)SDR DALA2025072405573Wire · damagedSHIP 3311 EMERGENCY PATHWAY LIGHT AT SEAT 30AB INOP. CORRECTIVE ACTION: REPAIRED WIRING AND CONNECTOR PER A330 AMM 33-51. (7327202)SDR DALA2025072405572Stringer · damagedSHIP 3360 TOOLING DAMAGE ON STR-S4R/FR 61- FR62. CORRECTIVE ACTION: REPAIRED PER ERA 627761-14. (1101951)SDR DALA2025072405571Stringer · damagedSHIP 3360 DTE REQUIRED. ERA 627771-14 ISSUED FOR FUSELAGE / STR-2R / FR59 -64 / TOOLING DAMAGE REPAIRS. REPAIR IS CONSIDERED MAJOR. CORRECTIVE ACTION: INSPECTED OK TO CONTINUE. (1101862)SDR DALA2025072405570Stringer Splice · not reportedSHIP 3360 DTE REQUIRED. ERA 627785-14 ISSUED FOR FUSELAGE / STR-2L / FR60- 64 / SPLICE REPAIRS. THESE REPAIRS ARE CONSIDERED MAJOR. CORRECTIVE ACTION: PERFORMED INSP OK TO CONTINUE PER ERA 627785-14. (1101752)SDR DALA2025072405569Reinforcement · damagedSHIP 3416 TOOLING DAMAGE ON REINFORCEMENT FR63 BETWEEN STR 2R AND STR 3R. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1101322)SDR DALA2025072405568Bracket · damagedSHIP 3416 L-BRACKET HAS TOOLING DAMAGE. CABIN FR62 STR1L, AFT SIDE OF FRAME. CORRECTIVE ACTION: REPLACED BRACKET PER ERA 627461-14 REV ORIG. (1101320)SDR DALA2025072405567Frame · damagedSHIP 3416 DAMAGE ON FRAME 62 ON AFT SIDE OF FRAME IN BETWEEN STR 2R. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1101825)SDR DALA2025072405566Support · damagedSHIP 3416 SUPPORT F5349190920900 DAMAGED FWD SIDE OF FR 62 STR 3R. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1101324)SDR DALA2025072405564Frame · gouged(LOG 1102242) GOUGE ON LWR HOLE OF LH STA 727 FRAME INNER CHORD AT S-18A. HOLE OF LH STA 727 FRAME INNER CHORD AT S-18A WAS DRILLED TO NEXT OVERSIZE PER B737-800 SRM 51-40-05-0G, AND (ET) (HFEC) OPEN HOLE INSPECTION WAS ACCOMPLISHED ON LWR HOLE OF LH STA 727 FSDR DALA2025072405555Oxygen Mask · unwanted deploySHIP 3160 ON TAKEOFF OXYGEN MASK AT 3CD FELL OUT. CORRECTIVE ACTION: CLOSED 3CD OXYGEN GEN CONTAINER REF A319 AMM 35-21. (77408748).SDR DALA2025072405554Skin · corrodedSHIP 3136 CORROSION INDICATION WAS FOUND IN TOP SKIN PANEL 2, TRAILING EDGE OVERHANG AREA, LH WING. CORRECTIVE ACTION: COMPLIED WITH ER/A 621980-14. (1101703).