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 CALA2025110410867Sensor · out of adjustSENSOR ON TOP OF FLIGHT DECK DOOR NEEDS ADJUSTMENT. CAUSES DIFFICULTY OPE NING AND CLOSING. ADJUSTED MAGNETIC SENSOR TRAGET AND VERIFIED FWD ENTRY LIGHT CHECK GOOD, REF AMM 52-52-01-800-801-C10.SDR CALA2025110410866Track · dirtyFWD ENTRY DOOR LIGHT ILLUMINATED AFTER LANDNG INDICATION ONLY INOP. DOOR OPERATION IS GOOD. PERFORMED ENTRY DOOR SWITCH TEST REF AMM 52-71-1-710-802, DOOR INDICATION WORKED AS IT SHOULD. WHILE OPENING/CLOSING FWD ENTRY ADD EMP:U437449 DOOR LATCH, NOTICED IT TSDR YENA2025110401086Coupler · damagedFLT#20, LHR-JFK. (ETOPS) "HF 1 IS VERY GARBLED WHEN RECEIVING. ATC CAN HEAR US, BUT WE CANNOT HEAR THEM. WE TRIED MULTIPLE FREQUENCIES, AND THEY WERE ALL VERY GARBLED; REMOVED AND REPLACED HF 1 COUPLER W/ REF TO 23-11-36. REF LP 4446964 ITEM 1 FOR GROUND VERIFSDR UIEA2025110201290Oxygen Bottle · low pressurePORTABLE OXYGEN BOTTLE SHOWS LOW PRESSURE AT SUPERNUMERARY SEATS(<P>R/R PORTABLE O2 BOTTLE IAW AMM 35-31-01. THIS CLOSES DMI 241303. OPS & LK CHK OK. PLACARD REMOVED.</P>)SDR ASAA2025110261561Socket · failedSEVERAL EMERGENCY LIGHTS INOPERATIVE AT ROW 17. GROUNDED - YES. REMOVED AND REPLACED BATTERY AND POWER SUPPLY AT ROW 17. CONDITION SAME 5742. 11/02/2025. NS 23-51-03. REPAIRED SOCKET AND CONNECTOR P1-6738 PER SWPM 20-31-01. OPS CHECK GOOD. ACFT OK TO CONTINUE SDR AALA202511034844Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L2 DOOR ASSIST BOTTLE LOW PRESSURE.MAINTENANCE PERFORMED CHARGING OF THE L2 DOOR ASSIST BOTTLE, IAW AMM 52-10-00-614-001-A,STEP 01: AND D. AND STEP 4.B.(1) THRU STEP 5.B.SDR QXEA2025110300337Arming Lever · no discrepancyFLIGHT 2290. ARMING LEVER AT L1 DOOR IS DIFFICULT TO OPERATE. REQURIES EXTRA FORCE. REMOVED FROM SERVICE. PERFORMED FUNCTIONAL CHECK OF L1 ARMING DOOR IAW AMM 52-11-40-720-802-A. FUNCTIONAL CHECK WITHIN LIMITS. NO DEFECTS NOTED. RETURNED TO SERVICE. NO PARTS RSDR AALA202511033306Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR VERY DIFFICULT TO OPEN. LAVATORY-D DOOR ADJUSTED AND LUBRICATED. PER AMM 52-50.SDR AALA202511036223Fitting · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT DOOR AIRCRAFT RIGHT GIRT FLAP NOT PROPERLY PLACED INSIDE SLIDE COMPARTMENT HARD TO ARM DISARM DOOR. ADJUSTED GIRT BAR RETAINER CLIPS ON 2R PASSENGER DOOR. PER AMM 25-66-01.SDR DALA2025110308035Control Unit · failedRIGHT FWD WINDOW HEAT INOPERATIVE. ON CLIMB OUT, GOT EICAS MESSAGE AND BURNING ODOR. SHUTOFF RT FWD WINDOW HEAT AND ODOR WENT AWAY. REMOVED RT FWD WINDOW IAW AMM 56-11. PERFORMED WIRE INSPECTION. FOUND NO BURNED WIRES OR SIGNS OF BURNED CONTACTORS. REPLACED SDR WX0A2025110332622Battery Pack · inoperative(AIRCRAFT NOT GROUNDED) L2 FA FLASHLIGHT NOT FLASHING / REPLACED L2 FA FLASHLIGHT BATTERY IAW CMM 25-60-02."SDR DALA2025110308025Stringer · corrodedCORROSION FOUND AT STRINGER S-34L STA 1342. C/W STRINGER REPAIR PER ERA 629918-14 REV B SECTION II PERMANENT REPAIR. (1284645)SDR ABXA20251102287Anti-Ice Valve · defectiveDURIING TEST FLIGHT, RT WING ANTI-ICE VALVE WOULD NOT OPEN. AIRCRAFT DIVERTED TO DFW. REMOVED AND REPLACED R WING ANTI-ICE VALVE. OPS TEST GOOD IAW AMM 30-11-02. AIRCRAFT RETURNED TO SERVICE.SDR A6WA202511028869Windshield · crackedREQUEST INSPECTION FOR F/O'S WINDSHIELD CRACKS. INSPECTED AND FOUND F/O WINDSHIELD TO BE OUT OF LIMITS IAW AWAC SUPP 14-201D REQUIRES REPLACEMENT. AIRCRAFT REMOVED FROM SERVICE.SDR ABXA20251102286Warning Message · false activationDURING TAXI, CTR RIGHT FUEL PUMP EICAS ILLUMINATED. AIRCRAFT RETURNED TO BLOCKS (BTB). DEFERRED IAW ABX-28-22-2AT/S CTR R FUEL PUMP EICAS MESSAGE AND BLED PRESSURE SENSE LINE FOR R AUX OVERRIDE PUMP PER B767 FIM 28-22 FT 805. PERFORMED TEST OF OVERRIDE PUMPSDR DALA2025110308018Wire · damagedSHIP 3301 EMERGENCY LIGHTS AT SEATS 43B, 46B, 45B, 36B, 44B, ARE INOP. CORRECTIVE ACTION: REPAIRED WIRING PER A330 AMM 33-51. OK FOR SERVICE. (7953256)SDR DALA2025110308017Wire · damagedSHIP 3312 BOTH EMERGENCY LIGHTS @ DOOR 2L SIDE GALLEY INOP. CORRECTIVE ACTION: REPAIRED WIRING PER A330 AMM 33-51. OK FOR SERVICE. (7940975)SDR IPXA2025110279653Battery · inoperativeDURING PREFLIGHT EMERGENCY 1 LT BAT LOW ALERT APPEARED DURING THE EMERGENCY LIGHT TEST. RAN QRH. REMOVED AND REPLACED EMERGENCY POWER BATTERY PER AMM 33-51-01. OPS CHECK GOOD AT THIS TIME. MEL CLEARED, PLACARD REMOVED.SDR DALA2025110308007Door Frame · crackedCRACK INDICATION FOUND IN HOLE 1 OF THE DOOR STOP FITTING 7 AT FRAME 1 6 RH SIDE. REPLACED INTERCOSTAL AND FASTENERS LOCATED AT LEVEL DOOR STOP FITTING 7 AT FR 15 TO FR16 RH SIDE AND FASTENERS AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1283977).SDR DALA2025110308006Stop Fitting · crackedCRACK INDICATION FOUND IN HOLE 1 OF THE DOOR STOP FITTING 7 AT FRAME 1 6 LH SIDE. REPLACED INTERCOSTAL AND FASTENERS FASTENERS AS PER A319 SRM 51- 42-11 AND A319 SRM 51-72-11. (1283974).SDR DALA2025110308005Stringer · wornWEAR ON STRINGER 39R LOCATED BTW FR 47 / 51 TO FR 52 IN AFT CARGO COMPARTMENT. REPLACED STRINGER AND FASTENERS LOC.STR39 R/H BTW FR 47 / 51 TO FR 54 IN AFT CARGO COMPARTMENT AS PER A319 SRM 51-42-11 AND A319 SRM51-72-11. (1283932).SDR UIEA2025110101289Unknown · vibrationHIGH VIBRATION FROM NOSE GEAR AFTER ROTATION AND RETRACTION. PERFORMED CONDITIONAL INSPECTION ON NOSE LANDING GEAR IAW AMM 05-51-38. BOTH LH & RH TPC GOOD, RE-TORQUED BOTH LH & RH NOSE WHEEL IAW AMM 32-45-02, NO DAMAGE OR LOOSE PARTS FOUND. A/C OK FOR SVC.SDR SCNA20251103428Glowstrip · damagedSELF ILLUMINATING FLOOR PATH AT 20 DEF DAMAGED REMOVED AND REPLACED SELF ILLUMINATING FLOOR PATH AT 20 DEF REF AMM 33-51-16SDR SCNA20251103427View Port · out of positionR1 DOOR SLIDE VIEWING GLASS OUT OF PLACE. REPOSITIONED AND SECURED DOOR SLIDE VIEWING GLASS IAW AMM 20-30-11SDR AALA202511039391Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE, LOCATED IN RIGHT ECS BAY, AT BS 663, RBL 20. REPLACED THE ATTACH ANGLE IAW SRM 57-10-10-2R-5.SDR 1SMA2025F00255O-Ring · cutAFTER TAKEOFF, LANDING GEAR FAILED TO RETRACT (STUCK IN TRANSIT). RECYCLING LEVER TO DOWN ALSO FAILED; NO GREEN LIGHTS ILLUMINATED. VISUAL CHECK SHOWED NOSE GEAR STUCK IN A HALFWAY POSITION. PILOT EXECUTED EMERGENCY GEAR EXTENSION CHECKLIST AND SUCCESSFULLY DESDR JR2R20251102537Floorbeam · corrodedL1 DOOR, FLOORBEAM CORRODED OUT OF LIMTS. REPLACEDSDR SWIA2025110175307Skin · dentedSMALL DENT ON FUSELAGE SKIN BETWEEN BS 581 & 597, S19R - 18R. REPAIRED THE DENT IAW REO 670-53-31-1119 REV--. ENSURED DRESS BACK PERFORMED IAW REO 670-51-00-085, REV A. CP 31112613 FOR EDDY CURRENT INSPECTION.SDR KY72026F00004Brake · failedLH BRAKE UNRESPONSIVE. R&R #1 BRAKE IAW SA227 MM 32-40-00 BRAKE CHECK GOODSDR 2026FA0000024Kit · wrong partKIT OBTAINED FROM MFG. FOR OPTIONAL TN11REV2. KIT CONSISTED OF DWGS./INSTRUCTIONS/PARTS/HARDWARE FOR SECOND PAIR OF AIRBRAKE PANELS. IT WAS IMMEDIATELY APPARENT THAT INSTRUCTIONS WERE FROM AN EARLIER VERSION, AS DWGS./PARTS/HARDWARE SUPPLIED WERE DIFFERENT FROSDR SWAA2025121030757Pressure Deck · crackedCRACK INDICATION ON THE HORIZONTAL PRESSURE DECK WEB, LBL 31, BS 663 IN MAIN WHEEL WELL. CRACK LENGTH: 0.312 IN. PERFORMED REPAIR ON HORIZONTAL PRESSURE DECK WEB IAW SRM 53-40-51-2R-2, REPAIR 2, FIGURE 203, AND EA 25-153-03155.SDR SWAA2025121030762Skin · corrodedCORROSION ON INTERNAL SKIN TOILET SERVICE DOOR 145AL, LOWER FUSELAGE. PERFORMED REPAIR ON TOILET SERVICE DOOR 145AL AT LOWER FUSELAGE IAW SRM 52-40-01-2R-8, REPAIR 8, FIGURE 202.SDR SWAA2025121030756Stub Frame · crackedCRACK INDICATION ON STUB FRAME, BETWEEN BS 294.5 - 296.5, S8R - 9R AT THE FWD GALLEY DOOR AREA. CRACK LENGTH: 1.187 IN. REPLACED THE STUB FRAME IAW SRM 51-40-02-0G-0, AND DWG 141A8370, SHEET 10, REV D.SDR SWAA2025121030758Access Panel · crackedCRACKED ACCESS PANEL 193AR AT FUSELAGE EXTERIOR. REPAIRED THE ACCESS PANEL 193AR IAW SRM 51-70-05-2R-2, REPAIR 2.SDR SWAA2025121050826Access Panel · crackedCRACKED ACCESS PANEL 193AL, BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED THE ACCESS PANEL 193AL BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-05-2R-2, REPAIR 2.SDR SWAA2025120430768Web · crackedCRACKED WEB, BTW BS 500D - 520, STRINGER 28L, FWD CARGO BAY. REPLACED THE WEB AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A7902, SHEET 126, REV A.SDR SWAA2025120430916Support Angle · crackedCRACKED SUPPORT ANGLE AT AUXILIARY TRACK SLAT 8, INBD, RT WING. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 114A5010, SHEET 6, REV D. MEASUREMENT OF CRACK: 2.022.SDR SWAA2025120433606Tee Angle · perforatedPERFORATION ON TEE ANGLE, BTW BS540 - 559, RBL 40 IN THE AIR CONDITIONING BAY. PERFORMED REPAIR ON THE TEE ANGLE IAW SRM 57-10-13-2R-3, REPAIR 3.SDR SWAA2025120430765Stringer · corrodedCORROSION ON STRINGER 24R, BS 540, RBL 40, WL 160, IN FWD CARGO . PERFORMED PERMANENT REPAIR ON THE STRINGER IAW SRM 53-00-03-2R-1, REPAIR 1.SDR SWAA2025120430767Angle · crackedCRACK ANGLE, BS 663.75 BTW LBL 6.15 & LBL 15.54. IN AIR CONDITIONING BAY. REPLACED THE ANGLEIAW SRM 51-40-02, AND DWG 111A1000, SHEET 190, REV-, AND DWG 111A1000, SHEET 192, REV-.SDR SWAA2025120430766Angle · crackedCRACKED ANGLE AFT FACE, BS 500D, STR 28L, FWD CARGO BAY, REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7902, SHEET 126, REV A.SDR SWAA2025120430914Support Bracket · crackedCRACKED SUPPORT BRACKET ON PNEUMATIC DUCT LOCATED BS 540, LBL 6 IN AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET ON PNEUMATIC DUCT IAW SOPM 20-50-01, REV 39, AND DWG 212A1101, SHEET 3.SDR SWAA2025120430899Support Angle · crackedCRACKED SUPPORT ANGLE, BS 695, RBL 24.75, WL208.1 IN PASSENGER CABIN. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, DWG 111A6000, SHEET 304, REV -, AND DWG 273A9110, SHEET 6, REV A.SDR VNAA20251204017Door Frame · corrodedCORROSION ON BAY DOOR CUTOUT BELOW FLOOR BTW FS1047 TO FS1031 STGR18L ON AFT CARGO DOOR SURROUND STRUCTURE. INNER SHORD ON BAY DOOR CUTOUT BELOW FLOOR BTW FS1047 TO FS1031 STGR18L ON AFT CARGO DOOR SURROUND STRUCTURE WAS REPLACED PER CRJ 900 SRM 51-42-06-001-SDR VNAA20251204009Seat Track · corrodedCORROSION ON LT SIDE, S15L SEAT TRACKS (1E/A) FROM FS379 TO FS469, (4E/A) FROM FS483 TO FS720, (1E/A) FROM FS744 TO FS761, (4E/A) FROM FS785 TO FS969 AT PAX CABIN. DUE TO EXCESSIVE DAMAGE ON LH SIDE (STGR15LH) SEAT RAILS; (1E/A) FROM FS379 TO FS469, (4E/A) FSDR VNAA20251204003Seat Track · corrodedCORROSION ON RH SIDE SEAT RAILS (STGR15RH); (4E/A) FROM FS379 TO FS661+90; (1E/A) FROM FS669 TO FS720; (1E/A) FROM FS744 TO FS761 AND (5E/A) FROM FS780 TO FS969 AT PAX CABIN. EVALUATED, DUE TO EXCESSIVE DAMAGE ON LH SIDE SEAT RAILS (STGR15RH); (4E/A) FROM FS37SDR VNAA20251204002Seat Track · corrodedCORROSION ON SEAT RAILS RBL9; (1E/A) FROM FS349 TO FS480, (4E/A) FROM FS492 TO FS685 AND (2E/A) FROM FS685 TO 977 AT PAX CABIN. DUE TO EXCESSIVE DAMAGE ON SEAT RAILS RBL9; (1E/A) FROM FS349 TO FS480, (4E/A) FROM FS492 TO FS685 AND (2E/A) FROM FS685 TO 977 AT SDR VNAA20251204001Seat Track · corrodedCORROSION ON SEAT RAILS LBL27 (1E/A) FROM FS364 TO FS480; ON LBL9 (1E/A) FROM FS375 TO FS485, (2E/A) FROM FS581 TO FS669 AND (2E/A). FROM FS685 TO FS977 AT PAX CABIN. WERE EVALUATED, DUE TO EXCESSIVE DAMAGE ON SEAT RAILS LBL27 (1E/A) FROM FS364 TO FS480; ONSDR SIMA202512041001Light · damagedLH EMERGENCY LIGHT STRIP #1 3, AND 5 IS FADED DAMAGED BEYOND LIMITS REQUIRING REPLACEMENT. COMPLETE: INSTALLED NEW LH EMERGENCY LIGHT STRIP #1. 3 AND 5 IAW AMM 33-50-21/400SDR CALA2025120111603Channel · corrodedAFT CARGO, FOUND MULTIPLE POINTS OF CORROSION ON RH ZEE CHANNEL, BTW 727B TO 767, REQUIRE REPAIR. REMOVED AND REPLACED NEW ZEE CHANNEL ON AFT CARGO COMPATMENT BTW BS 727B TO 767 RH SIDE IAW SRM 53-00-53-2R-5 FIG. 202.