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 NACA2025081400002Relay · failedLEFT FWD BOOST PUMP GFI NEEDS REPLACED. REPLACED L FWD BOOST PUMP GFI RELAY PER 767 AMM 28-22-18, OPS CHECK GOOD. NO TIME INFO AVAILABLE IN TRAX.SDR ASAA2025081460148Cover · detachedEMERGENCY EXIT LIGHT COVER AT 16A FELL OFF. GROUNDED - YES. RE-INSTALLED ROW 16 LH EMERGENCY EXIT SIGN LENS - LIGHTS OPS CHECK GOOD PER AMM 33-51-01.SDR NACA2025081840001Fault Message · false activationLEFT PACK OFF EICAS MESSAGE, LEFT PACK TEMP ON DESCENT. FOLLOWED QRH, DID NOT CLEAR. PERFORMED LEFT PACK BITE TEST FIM 21-51 FT 814 PACK FAULT CLEARED OPS CHECK GOOD.SDR DALA2025081806166Oxygen Box · malfunctionedFORWARD LAV 02 MASKS TRIPPED. R & R LAV OXYGEN CONTAINER ASSY IAW AMM 35-21. OPS CHECK GOOD. (7741268)SDR DALA2025081806161Repair · out of positionEXISTING REPAIR FOUND THAT IMPACTS INSPECTION ACCOMPLISHMENT. REPAIR INVESTIGATION REQUIRED PRIOR TO FURTHER FLIGHT. FOUND AT RT WING REAR SPAR INSPECTION AREA DURING ACCOMPLISHMENT OF AA EM 5720-01103. REPAIR PER ER/A 624368-14AD (1143045)SDR DALA2025081806160Structure · chafedNUMBER 2 LT SLAT ATTACH POINT INSPECTION, SLAT DRIVE TRACK NR 5 CHAFED WING STRUCTURE ON INBD AT EDGE. REPAIRED ERA 628327-14 REV. (1143308)SDR SWAA2025081804438Flap System · faultedAS WE WERE ABOUT TO SELECT FLAPS 1 (210KTS) WE NOTICED THE FLAP GAUGE INDICATING ZERO - ONE ON RT SIDE. WHEN WE SELECTED F1 THE FLAPS/SLATS DID NOT EXTEND. SELECTED F5, SAME RESULT. RETURNED FLAP HANDLE TO ZERO CHECKED CIRCUIT BREAKERS, ALL IN, AND EXECUTSDR AALA202508188411Girt Bar · openAIRCRAFT IN BASE MAINTENANCE: 1L DOOR SLIDE ARMED INTERMITTENTLY WHEN ARMED SELECTED. MAINTENANCE PERFORMED VISUAL INSPECTION ON GIRT ASSEMBLY AND FOUND THE GIRT ASSEMBLY UNFOLDED. MAINTENANCE CORRECTLY FOLDED THE GIRT ASSEMBLY PER AND AND ACCOMPLISHED A SATISSDR AALA202508183891Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR DXTA2025081804625Control Unit · faultedLEFT & RIGHT MAIN GEAR BRAKES ARE INOPERATIVE. ON INITIAL BRAKE CHECK, BRIEFLY LOCKED. ON TAXI, THE BRAKES CHATTER LOUDLY & ARE INEFFECTIVE. BRAKES FULLY APPLIED GIVE VERY WEAK CHATTERING BRAKING. TECHS PERFORMED CMC AND CVDR DOWNLOAD ADDED ON THE SHARE POSDR IPXA2025081866036Spar · damagedDURING PERFORM EO-85445-JIC 1 , FOUND FASTENER HOLES (CODE G) WORN NEAR FRONT SPAR AREA AT ELEV STA 244.3. PERFORMED NDT/UT FOR REWORKED AREA PLUS 6" AROUND HEATED AREA I.A.W. B767 NTM PART1 51-01-01 REV: 141. RESULT: NO DEFECT FOUND.SDR DALA2025081806153Tailpipe · fireAFTER #2 ENGINE SHUT DOWN AND NO LONGER SPINNING NOTED TAIL PIPE FIRE IN TURBINE AREA. DRY MOTORED ENGINE AND FLAMES EXTINGUISHED. PERFORMED BOROSCOPE OF COMUSTION SECTION, HPT NOZZLE GUIDE VANES, HPT BLADES AND STAGE 2-4 LPT NOZZLE GUIDE VANES PER B737 AMM 72SDR DALA2025081806148Window Frame · damagedWINDOW FRAMES BETWEEN BS 500K AND 727A / LHS / LIGHTNING STRIKES. REPAIRED PER ERA 628222-14.SDR 2025FA0000548Compressor · damagedWILLIAMS INTERNATIONAL ENGINE MODEL FJ44-3A, SERIAL NUMBER 141761, FROM AIRCRAFT 525B-0362 (OK-KIN), WAS RETURNED TO THE REPAIR STATION FOR UNSCHEDULED REPAIR. AIRCRAFT OPERATOR’S ENGINEER REPORTED ELEVATED OIL CONSUMPTION OVER RECENT FLIGHTS AND ON A SUBSEQUSDR DALA2025081806137Latch · brokenL2 DOOR FLT ATT O2 STORAGE/OVERHEAD LATCH BROKEN. REPLACED O2 CONTAINER AT L2 DOOR (F/A JUMP SEAT) IAW A330-300 AMM 35-21-41. OK FOR SERVICE. (7491990)SDR AALA202508183711Skin · damagedAIRCRAFT WAS GROUNDED: HEAT DAMAGE TO FUSELAGE SKIN (SEE AALA202505290407) LOCATED FROM BS 727D TO BS 727G, FROM S22R TO S25R. ACCOMPLISHED DOUBLER REPAIR IAW EA 365033 AND BOEING WORK ORDER AAL-RE 2501866.SDR ECPR2025081833027Valve Guide · out of limitsDURING A SIMULATED ENGINE FAILURE FOR A CFIA LESSON, THE ENGINE EXPERIENCED ROUGHNESS AND PARTIAL POWER LOSS DURING THE PLANNED GO-AROUND AT 800 FEET. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. POST FLIGHT INSPECTION REVEALED SDR SCNA20250818322Bracket · damagedWORK ORDER 97646, NR00002: TCC: PLEASE EVALUATE THE L1 DOOR ESCAPE SLIDE COVER GIRT BAR RETAINER CLIPS AND FLOOR MOUNTED BRACKET FOR HISTORY OF BRACKET LOOSE/ DIFFICULT TO DISARM/ HARD TO OPERATE AND DISARM. REPLACE OR ORDER PARTS, AS NECESSARY. REFERENCE AMM SDR SCNA20250818321Door · out of adjustDEFECT 750237: L1 DOOR SLIDE NEEDS TO BE ADJUSTED. FOUND L1 DOOR SLIDE MISALIGNED. RESOLUTION: REINSTALLED L1 DOOR SLIDE IAW AMM 25-66-00. OK FOR SERVICE.SDR CALA2025081807907Battery Pack · inoperativeMULTIPLE EEPL LIGHTS OUT THROUGHOUT CABIN. SUPPORT TASK NSA EMX N/R 00262. SDR INFO ONLY REMOVED BATTERY PACKS M1694 AND M2335 IAWB737-800 AMM 33-51-06. INSTALLED BATTERY PACK M1694 P/N: AD-D717-01-100 S/N: 390459 A ND M2335 P/N:AD-D717-01-100. S/N:376904 IAWSDR CALA2025081807905Scuff Plate · corrodedFWD CARGO DOOR LOWER SCUFF PLATE AREA IS CORRODED. REF AAR N/R 97524634. REMOVED AND REPLACED FWD CARGO THESHOLD WEB PER SRM 51-40-02-0G-0 AND DWG#143A8120 ,SDR CALA2025081807903Gcu · inoperativeGROUND POWER DISCONNECTED, WOULD NOT TAKE APU POWER, EITHER TRANSFER BUSS OFF ILLUMINATED BOTH SIDES FOUND FAULT ON APU GENERATOR CONTROL UNIT FOR GCB/APB FAULT. CREW STATED: ELECTRICAL /RUBBER SMELL THROUGHTOUT CABIN AND FLIGHT DECK. APU GCU WILL NOT TEST SDR CALA2025081807897Pump · no discrepancyLOW PRESSURE LIGHT FOR THE FUEL PUMP LIGHT ON CENTER TANK, LEFT PUMP CREW DEBRIEF, 2 ATTEMPTS ON L CENTR PUMP NO GOOD. ACCOMPLISHED FIM 28-22 TASK 801 INITIAL EVALUATION. FOUND GFI R54 NORMAL, LEFT CENTER TANK BOOST PUMP C/B NORMAL. UNABLE TO DUPLICATE FAULT. SDR CALA2025081807895Blower · faultedAFTER T/O, VIBRATIONS BETWEEN ROWS 2 TO 11. DID NOT SUBSIDE WITH VARYING SPEEDS AT ALT. CREW STATES VIBRATION STARTED AT APPROX 10K FT IN FLT. INCREASED WITH SPEED. ON RETURN BELOW 10K FT VIBRATION IMPROVED BUT NEVER WENT AWAY. VIBRATION FELT IN FLOORBOARD. SDR CALA2025081807885Cable · disconnectedL1 DOOR ESCAPE SLIDE DEPLOYMENT CABLE FOUND DISCONNECTED FROM GIRT BAR. UPON FURTHER INVESTIGATION WITH SLIDE REMOVED FOUND GIRT BAR OUTSIDE OF GIRT BAR HOLDER. REMOVED AND INSPECTED SLIDE NO DAMAGE FOUND, REINSTALLED L1 DOOR SLIDE REF AMM 25-66-01-404-072. C/SDR CALA2025081807884Warning Light · false activationDOOR 4L ARM LIGHT EXTINGUSHED ON TAXI OUT. DOOR 4 LEFT ARM AND DISARME DGIRT BAR SLIDERS INDICATED WHEN LEVER SET TO ARM AND DISARM. DOOR SLIDE LIGHT INCONSITENT COMPLIED WITH MEL PROCEDURES. 2566N APPROVED COMPLIED WITH MEL. VERIFIED ARM LIGHT OPERATES NORMASDR CALA2025081807883Track · dirtyFWD ENTRY LIGHT AND ASSOCIATED CAUTION AT APROX V1. IT WENT OUT APROX 2000FT. OPS NORMAL. CLEANED DOOR TRACKS AND PERFORMED OPERATIONAL CHECK PER AMM 52-11-00, NO DEFECTS NOTED. OPENED AND CLOSED DOOR SEVERAL TIMES FROM INSIDE AND OUTSIDE WITH NO ISSUES.SDR CALA2025081807882Slide · unlacedDOOR 1R SLIDE MATERIAL TOUCHING FLOOR RETUCKED SMALL AMOUNT OF GIRT BACK INTO SLIDE PACK AND ACHIEVED APPROX 11 INCHES FROM GIRT BAR TO SLIDE PACK EDGE REF AMM 25-66-01. OK FOR SERVICE.SDR CALA2025081807881Slide · unlacedL2 SLIDE HAS EXCESS MATERIAL DRAGGING ON FLOOR AND GETTING CAUG HT HINDERING FA TUCKED EXCESS GIRT MATERIAL BACK INTO SLIDE COVER REF AMM 25-66-01.SDR CALA2025081807868Power Supply · faultedDURING EMERGENCY LIGHT TEST, EPSU AFT LEFT INT LOAD FAULT NOTED AND THREE AFT EXIT MARKERS DO NOT LIGHT UP. REMOVED AFT EPSU.INSTALLED SERVICEABLE CONDITION EPSU INTO AFT LOCATION. OPS CHECK SATISFACTORY AT THIS TIME. REF AIRBUS 319/320 AMM 33-51-38.SDR CALA2025081807859Strut · leakingFOUND LEAK FROM BACK SIDE OF STRUT HOUSING. A CONSTANT STREAM APPEARS TO BE COMING FROM BETWEEN BARREL & SWIVEL TUBE. NGL HAS HISTORY OF FLUID & NITROGEN SERVICE. ACCOMPLISHED CHECK OF NLG STEERING, HYD SYS HAS AN INTERNAL LEAK.. LEAKING FLUID SMELLS LIKE HYSDR AALA202508180558Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSEMBLY LOCATED AT BS 500A PLUS 10 INCHES, AT RBL 25. REPLACED BAFFLE ASSEMBLY PER AARD 51-00-05-1SDR AALA202508188026Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSEMBLY LOCATED AT BS 500B PLUS 10 INCHES, AT RBL 25. REPLACED BAFFLE ASSEMBLY PER AARD 51-00-05-1SDR AALA202508189017Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSEMBLY LOCATED AT BS 500C PLUS 10 INCHES, AT RBL 25. REPLACED BAFFLE ASSEMBLY PER AARD 51-00-05-1SDR AALA202508189685Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSEMBLY LOCATED AT BS 500D PLUS 10 INCHES, AT RBL 25. REPLACED BAFFLE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202508180663Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER, RIGHT HAND LOWER WHEEL WELL, AT BS 663.75, RBL 45.64. REPAIRED CRACK PER SRM 57-10-10-2R-2.SDR AALA202508188891Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER, RIGHT HAND LOWER WHEEL WELL, AT BS 663.75, RBL 40. REPAIRED CRACK PER SRM 57-10-10-2R-2.SDR HALA20250815248Gcu · faultedETOPS - APU GEN FAULT- RESET GEN PER ECAM. SUCCESSFUL RESET. REMOVED AND REPLACED GAPCU PER AMM 24-41-400-801-B. OPS CHK GOOD FAULT CLEARED OK FOR SVC.SDR CALA2025081507847Metering Valve · stuckNOSEWHEEL STEERING INOP IN NORMAL AND ALTERNATE MODES. ZERO STEERING WITH TILLER USING BOTH NORMAL AND ALTERNATE STEERING. REF FIM 32-51 TASK 806. THRU STEP E(10). CABLE AND SUMMING MECHANISM OPERATES NORMALLY. METERING VALVE APPEARS TO BE STUCK IN BYPASS MSDR CALA2025081507846Windshield · delaminatedFOUND POSSIBLE DELAMINATION ON CAPTAIN`S NR 1 WINDOW, WINDOW DELAM IS OUTSIDE OF PILOT FIELD OF VIEW. NO IDICATION OF ARCING IS OCCURING. NO BUBBLES NOTED. MOISTURE IS PRESENT AT BUSS BAR. OK TO CARRY PER AMM 56-11-11 FOR 15 DAYS.SDR CALA2025081507845Safety Wire · brokenCREW OXYGEN CYLINDER VALVE SAFTEY WIRE IS BROKEN, CHECK CORRECT VALVE POSITION AND RE-SAFTEYWIRE. CREW O2 BOTTLE FOUND IN AN UNSAFE CONDITION. RECTIFICATION OUTSTANDING VALVE POSITION CONFIRMED CORRECT, SAFETY WIRE RE APPLIED AND SECURED. WRT AMM 35-11-00-206-SDR CALA2025081507844Unknown · odorAS PER OUTBOUND FLIGHT CREW, AN ELECTRICAL / RUBBER ODOR IN FLT DECK & FRONT CABIN. VISUAL CHECK FOR ARCING AT RELAX BOX AND GRD RECEPTACLE AREA, NO DEFECTS NOTED, BATTERY CABLE NO DEFECTS NOTED. NO DEFECT NOTED.SDR CALA2025081507843Rib · crackedCRACK FOUND ON LT HORIZ STAB LEADING EDGE AT RIB OF HSS 309. REMOVED AND REPLACED LT HORIZ STAB LEADING EDGE PANEL RIB AT HSS 309 IAW SRM 51-40-02-0G-0 AND DWG 186A1001.SDR DALA2025081506126Warning Message · false activationCLIMBING OUT FROM MSP AT FL300 RECEIVED AN DOOR R EMERGENCY ECAM. PERFORMED A VISUAL INSPECTION, NO FAULTS/MALFUNCTIONS AT THIS TIME IAW AMM 52-21.SDR DALA2025081506124Plate · corrodedCORROSION WAS FOUND ON THE LT WING LOWER SURFACE PYLON REINFORCEMENT PLATE OTBD SIDE. COMPLIED WITH ER/A 627728-14. (1144222).SDR DALA2025081506122Plate · corrodedCORROSION WAS FOUND ON THE LT WING LOWER SURFACE PYLON REINFORCEMENT PLATE OTBD SIDE. COMPLIED WITH ER/A 627728-14. (1144192).SDR DALA2025081506121Bushing · excess playLEFT WING NR 4 SPOILER WITH PLAY, IT HAS 1.22 MM. REPLACED BAEARINGS SLEEVES AND BUSHINGS AT LT WING SPOILER NR 4 AND CENTER HINGE BRACKET IAW CMM 57-72-21 AND SRM 57- 72-12. (1143283).SDR DALA2025081506120Bushing · excess playRIGHT WING NR 3 SPOILER WITH PLAY. REPLACED BEARINGS SLEVES AND BUSHINGS AT RT WING SPOILER NR 3 CENTER HINGE BRACKET IAW CMM 57-72-21 AND SRM 57-72-12. (1143255).SDR DALA2025081506119Bushing · excess playRIGHT WING NR 5 SPOILER WITH PLAY, IT HAS 1.15 MM. REPLACED BEARINGS SLEEVES AND BUSHINGS AT RT WING SPOILER NR 5 AND CENTER HINGE BRACKET IAW CMM 57-72-21 AND SRM 57-72- 12.SDR DALA2025081506116Web · crackedCRACKED WEB FR20, S23R, FWD GALLEY. INSTALLED SPLICE 1(E/A) LOC. FR 24 AT LEVEL S23R AT FWD GALLEY AREA IAW SRM 51-42-11.