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 QXEA2026010900005Manifold · malfunctionedFLIGHT 2267. ON TAXI OUT AIRCRAFT KEPT VEERING TO THE LEFT. ON TAKE OFF AIRCRAFT VEERED LEFT AND FO HAD FULL RIGHT RUDDER THE CAPTAIN MADE A CORRECTION WITH THE TILLER BACK TO THE RIGHT AFTER LETTING GO OF THE TILLER THE AIRCRAFT VEERED TO THE LEFT AGAIN WE ABSDR AALA202601094879Processor · false indicationAIRCRAFT WAS GROUNDED: LEFT FUEL TANK INDICATOR PERIODICALLY SHOWS A QUANTITY VALUE IT FLAGS A FUEL IMBALANCE AND MULTIPLE MESSAGES IN THE FMS. GROUND TEST OF FQIS SYSTEM FAULTED WITH MSG # 28-41115 (ARINC OUTPUT BUS FAIL). ACCOMPLISHED TEST OF REFUEL QUANTITYSDR AALA202601094957Fuel Filter · cloggedAIRCRAFT WAS NOT GROUNDED: SHORTLY AFTER TAKEOFF ENGINE NUMBER 1 FUEL FILTER BYPASS LIGHT ILLUMINATED. REMOVED AND REPALCED FUEL FILTER ON ENGINE NUMBER 1 FUEL FIRTER. PER AMM 73-11-02.SDR AALA202601090353Transmitter · leakingAIRCRAFT WAS NOT GROUNDED: LEFT ENGINE FUEL FLOW TRANSMITTER LEAKING AT THE COMPONENT SPLIT LINE AND RUNNING DOWN LEFT SIDE OF ENGINE. REMOVED AND REPLACED ENGINE NUMBER 1 FUEL FLOW TRANSMITTER. PER MM 73-73-01.SDR AALA202601091983Girt Bar · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT EXIT DOOR GIRT BAR DIFFICULT TO ARM AND DISARM. (OPEN).SDR AALA202601095335Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH IS STICKING MAKING PASSENGERS GETTING LOCKED IN. CLEAN AND LUBRICATED DOOR LOCK. PER CMM 25-40-58.SDR IPXA2026010909847Flap System · faultedDIVERSION, EMERGENCY DECLARED, TE FLAP DISAGREE EICAS ON APPROACH PERFORMED CHECKLIST AND UNABLE TO EXTEND FLAPS TO EVEN 1 DEGREE. PERFORMED FSEU BITE FIM 27-51 FT 805. CODE 305 / 328 DISPLAYED ON FAULT HISTORY LAG 0. PER FT 805 FIG 104B, CONTINUE T/S PER FISDR IPXA20260109449Door · bindingCREW ENTRY DOOR DIFFICULT TO CLOSE FROM OUTSIDE LUBRICATED OUTER HANDLE ASSY PER AMM 12-22-52/001. OPS CHECK OKSDR IPXA2026010909964Light · inoperativeLAV EMERGENCY LIGHT INOP REMOVED AND REPLACED LAV LIGHT ASSY OPS GO OK FOR SERVICE REF COMMS 33-24-05SDR AALA202601094466Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601096451Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601097844Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601095785Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601097441Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601093901Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202601099672Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: CABIN DOOR PRESSURE NOTIFICATION IN AMBER FOR DOOR 1L. MAINTENANCE SERVICED THE L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202601090363Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR DALA2026010900239Channel · damagedFORWARD SIDE OF FRAME 64 TOOLING DAMAGE ON STIFFENER CHANNEL SUPPORT JUST INBOARD OF P1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392511)SDR DALA2026010900238Doubler · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE IN DOUBLER UPPER EDGE @ P4. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392509)SDR DALA2026010900237Frame · damagedSHIP 3420 AFT SIDE OF FRAME 61 TOOLING DAMAGE IN DOUBLER UPPER EDGE @ P2. CORRECTIVE ACTION: REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392507)SDR DALA2026010900236Skin · damagedFORWARD SIDE OF FRAME 64 TOOLING DAMAGE ON FUSELAGE SKIN JUST INBOARD OF P'1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392504)SDR DALA2026010900235Frame · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE IN DOUBLER UPPER EDGE @ P3. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392502)SDR DALA2026010900234Frame · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE IN DOUBLER UPPER EDGE @ P2.5. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392499)SDR DALA2026010900233Doubler · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE IN DOUBLER UPPER EDGE @ P5. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392496)SDR DALA2026010900232Frame · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE ON FRAME AT P1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392489)SDR DALA2026010900231Skin · damagedFORWARD SIDE OF FRAME 64 TOOLING DAMAGE ON FUSELAGE SKIN IN 2 PLACES JUST INBOARD OF P1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392488)SDR DALA2026010900230Frame · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE ON FRAME AT P1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392483)SDR DALA2026010900229Support Bracket · damagedFORWARD SIDE OF FRAME 64 TOOLING DAMAGE ON CHANNEL SUPPORT BRACKET AT P'1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392482)SDR DALA2026010900228Channel · damagedFORWARD SIDE OF FRAME 61 TOOLING DAMAGE IN CHANNEL UPPER EDGE @ P2. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392475)SDR DALA2026010900227Shear Tie · damagedFORWARD SIDE OF FRAME 64 TOOLING DAMAGE ON SKIN FRAME CLIP EDGE AT P2. CORRECTIVE ACTION: REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392470)SDR DALA2026010900226Frame · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE ON FRAME AT P'1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392457)SDR DALA2026010900225Channel · damagedFORWARD SIDE OF FRAME 61 TOOLING DAMAGE IN CHANNEL UPPER EDGE @ P1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392455)SDR DALA2026010900224Doubler · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE ON DOUBLER AT P'5. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392454)SDR DALA2026010900223Bracket · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE ON BRACKET AT P'4. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392452)SDR DALA2026010900222Stiffener · damagedAFT SIDE OF FRAME 61 TOOLING DAMAGE ON STIFFENER AT P'3 BETWEEN 61/62. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392449)SDR DALA2026010900221Channel · damagedFORWARD SIDE OF FRAME 61 TOOLING DAMAGE IN CHANNEL @ P'3. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392442)SDR DALA2026010900220Frame · damagedFORWARD SIDE OF FRAME 61 TOOLING DAMAGE ON FRAME @ P1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1392441)SDR DALA2026010900219Support Bracket · damagedTOOLING DAMAGE ON SUPPORT BRACKET AND SUPPORT BRACKET ATTACH FASTENER. AFT SIDE OF FRAME C30, P'5. REPAIRED PER ERA 631298-14 REV. ORIG. (1392335)SDR DALA2026010900218Shear Tie · damagedFR60 SHEAR TIE BETWEEN STR4 AND 5R GOUGED IN 2 PLACES. REPAIRED PER A330 SRM 51-73-11. (1391049)SDR DALA2026010900214Bushing · migratedENTRY DOOR HARD TO OPEN OR CLOSE / LOCATIONS:603. ACTION: FOUND LOWER GATE PUSHROD ATTACH BOLT AND BUSHING MIGRATED. REINSTALLED BOLT AND BUSHING, SECURED. OP CKS GOOD B757 AMM 52- 11. (1392257)SDR DALA2026010900212Deck Plate · damagedIN REFERENCE TO NRC 437 WIP 7, (UT) MEASUREMENT THICKNESS WAS ACCOMPLISHED ON WEB SURFACE (DECK PLATE) BTW STA 1681.8 AND RBL 47 AT W4, THEREFORE IT'S OUT OF LIMITS PER B757-200 SRM 53-60-51-1A PROCEDURE 2 ALLOWABLE DAMAGE 2. PAR. 2. C. TABLE 101. DETAIL III. SDR VNAA2026010911101Light · odorFO MAP LIGHT BURING SMELL. REMOVED & REPLACED FO MAP LIGHT IAW CRJ 700 AMM 33-13-03-000/400-801. OPS CHECK GOOD AT THIS TIME.SDR SIMA20260108001Flashlight · inoperativeFLIGHT ATTENDANT 1 EMERGENCY FLASHLIGHT INOP NEED REPLACEMENT FOUND FA 1 EMERGENCY FLASHLIGHT TO BE INOP. DEFERRED FWD FLASHLIGHT PER MEL 25-51 AUTH 010459D-C EXP 1-18-26. PERFORMED AN OPERATIONAL TEST ON FLIGHT ATTENDANT 1 FLASHLIGHT IAW AMM 33-51-00. OPC GOSDR DXTA2026010906483Pcb · faultedUPON LANDING AND TAXIING IN, WE TRIED TO OPEN THE DOOR TO LET THE OWNERS OUT AND THE DOOR WOULD NOT OPEN. THE SILVER LIFT HANDLE WAS STUCK IN PLACE. WE SHUT THE PLANE DOWN AND WAITED A FEW MINUTES AND WERE THEN ABLE TO OPEN THE DOOR WITH NO POWER ON THE AIRPLASDR DXTA2026010906485Light · faultyDURING PREFLIGHT TEST THE EMER LTS FAILED TO ILLUMINATE IN THE ARM POSITION, RAN THE CHARGE PROCEDURE TWICE AND THEY STILL FAILED TO ILLUMINATE IN THE ARM POSITION. PERFORMED TC-FLT-33-1001 AS REQUIRED. REFERENCE STEVENS WO 25892 ITEM 2.4 IAW TC-FLT-33-1001 SDR CALA2026010912833Battery Pack · inoperativeWHEN SET THE EMERGENCY LIGHT SWITCH TO THE ON MODE,FND M33094 POWER PACK CAN NOT STAY ON FOR 15 MINUTES REFER HAECO NON-ROUTIN E LOG PAGE:9492061,ORIGINATED BY EMP:V903529 ORIGINATING CARD:23 -3350-1-0001. REPLACED M33904 POWER SUPPLY BATTERY AND CARRY OUT OPSDR CALA2026010912832Sign · inoperativeMULTIPLE EMERGENCY EXIT SIGNS AT 1L AND 1R, 2L AND 2R INOP. FOUND DOOR 2L OVERHEAD INOP, ALL OTHER EMERGENCY LIGHTS WORK NORMAL. REPLACED EXIT SIGN 45WL AT DOOR 2L, NO HELP. NOTICED, WHEN EMERGENCY LIGHTS SWITCH IS SELECTED TO ON POSITION, ALL EMERGENCY LIGHTSSDR CALA2026010912831Elec Connector · damagedSTART VALVE ILUMINATED, NR 1 ENGINE. PILOTS REPORT NR 1 ENGINE START VALVE INDICATION SHOWED OPEN AFTER TAKE OFF. ELECTRICAL CONNECTOR PINS & CONTACTS INSPECTED. NO DAMAGE FOUND. MANUALLY ACTUATED START VALVE & OPS OK. SLAVED NEW START VALVE & INDICATION SDR FDEA202601080014Skin · dentedRIGHT INBD TE FLAP AFT FLAP IS DAMAGED ON THE UPPER SURFACE. REPAIRED RT INBD TE FLAP AFT FLAP TOP UPPER SURFACE AT WS STA. 287.4 IAW SRM 57-53-01-2R, FIG 201, SHEET 4, REPAIR 1, & SRM 51-70- 10-2R. MAJOR REPAIR. SEE JPF STEPS FOR OTHER WORK ACCOMPLISHED.SDR DALA2026010900207Seat Track · corrodedCORROSION SEAT TRACK +Y1225, FR 66 TO 68 LT SIDE AT AFT GALLEY AREA. REPLACED THE SEAT TRACK Y1225 & FASTENERS IAW SRM 51-42-11, SRM 51-72-11, AND DWG D53472780, ISSUE K, DWG D53474250 ISSUE V . MEASUREMENT OF CORROSION ARE L:0.508 INCHES W:0.249 INCHES D:0.