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 2025FA0000784Windscreen · crackedWHILE CRUISING AT APPROX. 32,000 FT, THE RH HEATED SIDE WINDSCREEN BASICALLY SHATTERED. NO PREVIOUS SCRATCHES KNOWN. NO IMPACT MADE, SUCH AS BIRD STRIKE. PILOTS REPORTED NOTHING OUT OF THE ORDINARY GOING ON. SIMPLY AND SUDDENLY SHATTERED. WINDOW STAYED INTACT.SDR JR2R20251125579Floorbeam · corrodedAFT WET AREA, EXISTING REPAIR DOUBLER ON BEAM AT FRAME 87, RBL 10, IS CORRODED OUT OF LIMITS. REPLACED.SDR YENA2025112501122Filter · odorFLT#321, BOS-PBI. ON DESCENT THROUGH 8,000 FT - LEVEL 1 DIRTY SOCK SMELL IN COCKPIT ONLY; COMPLIED WITH TSM 05-50-00-810-831-A, REPLACED RECIRCULATING FILTERS IAW AMM 21-21-41, COMPLIED WITH INFO NOTICED 2017-T015, ISOLATED FAULT TO TYPE 10, PER TSM 05-50-00-SDR DALA2025112508574Tube · unsecureDIVERTED TO JFK DUE TO RIGHT ENGINE OIL QUANTITY DROPPING TO ZERO AND OIL PRESSURE DECREASING. RE-TORQUED AFT BEARING OIL TUBES, R/R TWO SCAVENGE TUBES AND REPLACED GASKET, REPLACED O-RING ON REAR COVER AND LAST CHANCE FILTER STEM. ENGINE RUN OPS AND LEAK GOSDR SCNA20251125451Trash Bin · no discrepancyAFT LEFT LAVATORY HAS A SHARP EDGE ON WASTE BASKET OPENING. INSPECTED WASTE BASKET, NO DEFECTS NOTED, REF AMM 25-40-08.SDR 2025FA0000783Wire Harness · mismanufacturedWHILE CARRYING OUT WIRING CHKS BETWEEN APU OIL QTY TRANSMITTER & FLUID QTY INDICATOR, IT WAS NOTED THAT TWO WIRES (H347-22-6(WHT) & 347-22-6 (BLU)) HAVE BEEN INCORRECTLY PINNED AT FQI CONNECTOR (082M1P1). WIRE H347-22-6(WHT) IS LOCATED IN PIN 14 INSTEAD OF PINSDR 2025FA0000782Filler · corrodedAIRCRAFT REG: N396HA, AIRCRAFT MSN 1488. BULK CARGO DOOR ENTRANCE CUTOUT LOWER EDGE FILLER FOUND WITH 4 OFF LOCATION CORRODED. MEASURING 30X15MM, 25X10MM,20X20MM AND 10X10MM.SDR SWIA2025112476592Vane · wornRIGHT INBD FLAP VANE ACTUATOR BEAM WORN AT FLAP STATION 140.4. REPAIRED RIGHT INBD FLAP VANE ACTUATOR BEAM (OUTER TUBE) AT FLAP IAW REO 670-57-52-257, REV -B. COMPLIED WITH ALL STEPS OF REO 670-57-52-257 REV -B. OPS CHECK GOOD. COMPLIED WITH TASK CARD 51-9SDR SWIA2025112476579Bracket · corrodedFORWARD ECS COMPARTMENT, FS677 STGR19L HAS A BRACKET/CLIP WITH CORROSION, REMOVED AND REPLACED CORRODED CLEAT AT BS 677, S19L WITH NEW CLEAT IAW SRM 51-42-06-001-001-A01 REVISION 38 AND DWG SH690-35070 REV R. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2025112476577Frame · corrodedFS581.00 CORRODED AT STGR18L. INSTALLED NEW STUB FRAME AT FS581.00 AT STR18L IAW DWG SH690-33750 REV: AF AND SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2025112476532Stringer · corrodedMAIN AVIONICS BAY, FS364-FS379 STG21R HAS CORROSION, REMOVED CORRODED AND INSTALLED NEW MAIN AVIONICS STR 21R BETWEEN FS333 TO FS379. IAW SRM 51-42-06-001-001-A01 AND DWG SH690-31350 REV. M. LEAK CHECK GOOD COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2025112476510Beam · damagedRIGHT INBOARD FLAP VANE ACTUATOR BEAM (OUTER TUBE) HAS WEAR DAMAGE AT FLAP STATION 24.0. REPAIRED RIGHT WING INBOARD FLAP VANE ACTUATOR BEAM (OUTER TUBE) AT FLAP STATION 24.0 IAW REO 670-57-52-257 REV -B. COMPILED WITH ALL STEPS OF REO 670-57-52-257 REV -B. SDR SWIA2026070606499Angle · corrodedRIGHT WHEEL WELL FORWARD TIRE BURST ANGLE CORRODED. REMOVED AND INSTALLED NEW RT WHEEL WELL FWD TIRE BURST ANGLE IAW SRM 51-42-21-001-001-A01 AND DWG CC670-10320, REV -F. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025112476485Beam · damagedRIGHT INBOARD FLAP VANE ACTUATOR BEAM (OUTER TUBE) HAS WEAR DAMAGE AT FLAP STATION 102.9. REPAIRED RIGHT HAND INBOARD FLAP VANE ACTUATOR BEAM (OUTER TUBE) AT FLAP STATION 102.9 IAW REO 670-57-52-257 REV -B DATED 2024-10-17. COMPLIED WITH ALL STEPS OF REO 670SDR SWIA2025112476468Tube · wornRIGHT INBD FLAP VANE ACTUATOR BEAM (OUTER TUBE) HAS WEAR DAMAGE AT FLAP STATION 65.5. REPAIRED RIGHT HAND INBOARD FLAP VANE ACTUATOR BEAM (OUTER TUBE) AT FLAP STATION 65.5 IAW REO 670-57-52-257 REV -B. COMPLIED WITH ALL STEPS OF REO 670-57-52-257 REV -B, COSDR VNAA20260511036Seat Track · corrodedRT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 785 AND FS 863. REMOVED RH SIDE SEAT RAIL AT STGR 15R BETWEEN FS 785 AND FS 863, P/N SH670-36260-5, IAW CRJ 700 AMM 53-00-49-000-801-A03. INSTALLED NEW SERVICEABLE SIDE SEAT RAIL, P/N SH670-36260-5, AT STGSDR SWIA2025112475755Structure · damagedT/E OF THE RT PYLON IS DELAMINATED AND MISSING COMPOSITE MATERIAL REPLACED AND INSTALLED NEW TRAILING EDGE ASSY, PYLON RT, PER DWG.601-37012 REV B AND REF.CRJ/200 SRM.51-42-10-00, 51-74-00-00. COMPLIED WITH SKYWEST TASKCARD 51-900-1003-SKY.SDR SWIA2026031875525Frame · corrodedFRAME BS 589 FWD SIDE FROM STR 26R TO STR 25L HAS SEVERAL AREAS OF CORROSION. REMOVED AND REPLACED FRAME BS 589 BETWEEN STGR 20R AND 20L (PN 601R36025-61) IAW SRM 51-42-06, AND DRAWING 601R35005, REV AG, SHEET 1.SDR SWIA2026031075496Fitting · gougedRIGHT MLG SIDE STAY FITTING IS GOUGED ON OB SURFACE. PERFORMED BLENDED OUT AND EVALUATED AREA ON RH MLG SIDESTAY FITTING OB SURFACE,CONDITION IS STRUCTURALLY ACCEPTABLE IAW MHI RJ REO 670-57-11-244 REV-- DATED: 2026-01-23, CRJ700 SRM 51-12-00, 51-24-11, 51-21SDR SWIA2025112475489Skin · gougedFUSELAGE EXTERIOR LEFT SIDE BS 969 - 985, ABOVE STRINGER 27. SKIN GOUGED. REPAIRED DAMAGE TO FUSELAGE EXTERIOR BETWEEN BS 969 AND BS 985 STGR 27L IAW REO 670-53-00-290, REV-F AND REO 670-53-00-807, REV-A.SDR HNAA2026012100044Shear Tie · crackedSHEAR CLIP IS CRACKED AT FRAME 61 BETWEEN STRINGERS 6R-7R. REMOVED AND REPLACED SHEAR CLIP AT FRAME 61 BETWEEN STRINGERS 6R-7R IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100043Spar · crackedRIGHT WING SPAR I LOWER FLANGE AT RIB 9 IS CRACKED. PERFORMED REPAIR OF RH WING SPAR I AT RIB 9 REPAIR PARTS IAW EMB 145 SRM 57-20-05 ITEM3, ETD2025-145-934133 AND EO1-57-25-0455.SDR HNAA2026012100042Spar · crackedLEFT WING SPAR I LOWER FLANGE AT RIB 9 IS CRACKED. PERFORMED REPAIR ON LT WING SPAR I LOWER FLANGE AT RIB 9 IAW EMB 145 SRM 57-20-05 ITEM 3, ETD2025-145-933843 AND EO1-57-25-0446.SDR HNAA2026012100019Door Sill · corrodedCORROSION ON CARGO DOOR CUTOUT LOWER SILL. REMOVED AND REPLACED CARGO DOOR CUTOUT LOWER SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100018Shear Tie · corrodedCORROSION ON CARGO DOOR CUT-OUT SHEAR CLIP AT FRAME 65. PERFORMED SPLICE REPAIR OF SHEAR CLIP AROUND CARGO DOOR CUTOUT AT FRAME 65 IAW EMB 145 SRM 53-31-04 ITEM 4D FIG 212 AND EO1-53-25-0445.SDR KY7A2026011600038Cooling Turbine · fumesAIRCRAFT SMOKY WHEN IN FULL HOT. DRAINED 0IL OUT OF COOLING TURBINE REF SA227 MM CH 21-50-00SDR DALA2026010800160Filter · odorATB- RETURNED TO ATL DUE TO DIRTY SOCK SMELL IN CABIN. REPLACED RECIRCULATION FILTERS AND PERFORMED LEVEL A DECONTAMINATION. (LP 7672324)SDR SWAA2025122939375Baffle · crackedFWD CARGO BAY BAFFLE BS 460 - 480, WL 156, LBL 25 CRACKED. R & R BAFFLE BETWEEN BS 460 - 480, WL 156, LBL 25 IAW SRM 51-40-02, & DWG 143A7505 REV-.SDR SWAA2025122939376Baffle · crackedFWD CARGO BAY BAFFLE BS 500B - 500C, WL 156, LBL 25 CRACKED. R & R THE BAFFLE BETWEEN BS 500B - 500C, WL 156, LBL 25 IAW SRM 51-40-02, & DWG 143A7505, REV B.SDR SWAA2025121739500Retainer · missingMISSING CUT OUT DOOR RETAINER LOCATED ON UPPER SILL IN FWD CARGO BAY (2 EA). INSTALLED THE RETAINERS IAW SOPM 20-50-19.SDR SWAA2025121639378Scuff Plate · crackedCRACKED AFT CORNER SCUFF PLATE, AFT CARGO BAY DOOR CUTOUT. REPAIRED THE SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, & BAC 5975.SDR SWAA2025121639377Support Angle · crackedCRACKED DEFLECTION CONTROL RIB TRAILING EDGE SUPPORT ANGLE LOCATED AT ORSS 271, RT WING. REPLACED DEFLECTION CONTROL RIB TRAILING EDGE SUPPORT ANGLE IAW SRM 51-40-02-0G, AND SRM 51-10-02-0G, ITEM 9. CRACK MEASURED: L=0.550 INCH.SDR SWAA2025121639499Support Angle · crackedCRACKED DEFLECTION CONTROL RIB, TRAILING EDGE SUPPORT ANGLE LOCATED AT ORSS 270, LT WING. REPLACED THE DEFLECTION CONTROL RIB TRAILING EDGE SUPPORT ANGLE LOCATED ORSS 270 LT WING IAW SRM 51-40-02-0G, AND SRM 51-10-02-0G, ITEM 9. CRACK MEASUREMENT: L=0.550 INSDR JJBA20251209025Seat Track · corrodedRIGHT INBD SEAT TRACK NR 2, 4, 6, 10, 18, 20, 26, 28 FOUND CORRODED. RT INBD SEAT TRACK NR 2, 4, 6, 10, 18, 20, 26, 28 BLENDED. RT INBD SEAT TRACK NR 2, 4, 10, 18, 20, 26, 28 REPROTECTED. AT RT INBD SEAT TRACK NR 6 REMOVED AND INSTALLED.SDR JJBA20251209024Seat Track · corrodedLEFT INBD SEAT TRACK NR 2, 4, 5, 6, 7, 15, 20, 21, 29, 33 FOUND CORRODED. AT LT INBD SEAT TRACK NR 2, 4, 5, 6, 7, 15, 20, 21, 29, AND 33 REMOVED FOR INSPECTION. SEAT TRACKS BLENDED OUT OF LIMITS. AT LT INBD SEAT TRACK NR 15 NEW SEAT TRACK INSTALLED.SDR AALA202512091819Track · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER FORWARD SPAR SLIDER PANEL FORWARD GUIDE TRACK WORN. LOCATED AT BS 1090 RBL 27. REPLACED GUIDE TRACK FRAME ASSEMBLY PER ARD 51-00-05-1.SDR CALA2025120811835Stringer · corrodedSTRINGER 25L HAS CORROSION BETWEEN BS 360 & 380. CUT OUT DAMAGE FROM STR 25L IAW SRM 53-00-03-2R-1, STEP 4 A & B. PERFORMED HFEC INSPECTION OF CUT EDGE OF STRINGER IAW NDT MANUAL PART 6, 51-00-00 PROC 23, NO DEFECTS NOTED. FABRICATED, LOCATED, DRILLED, TRESDR CALA2025120811833Stringer · corrodedSTRINGER 26L HAS CORROSION BETWEEN BS 360 AND 380. REMOVED DAMAGED SECTION OF STR 26L IAW SRM 53-00-03-2R-1 STEP 4 A&B. HFEC REQUIRED AT CUT EDGE OF DMG REMOVAL IAW SRM 53-00-03-2R-1 STEP 4C. PERFORMED HFEC INSPECTION OF CUT EDGE OF STRINGER IAW NDT MANUAL SDR CALA2025120811831Stringer · corrodedSTRINGER 27L HAS CORROSION AT BS 360. REMOVED DAMAGED SECTION OF STRINGER 27L IAW SRM 51-10-02, STEP 4C. PERFORMED HFEC INSPECTION OF CUT EDGE OF STRINGER IAW NDT MANUAL PART 6, 51-00-00 PROC 23, NO DEFECTS NOTED. ACCOMPLISHED PART -A- STEP 6 OF AVO 721-25-SDR DALA2025120308832Button · damagedSLIDE INDICATOR LIGHT INOP OR DAMAGED. R&R SLIDE LIGHT BUTTON ASSY PER B767-400 AMM 52-73-01 OPS CK (1320112)SDR DALA2025120308829Switch · damagedFLIGHT CREW REPORTS 2R DOOR ARMED LIGHT ON FAP DAMAGED. R&R SWITCH PER B767 WDM 52-73-11. OPS CK GOOD. PLACARD REMOVED. (7972888)SDR DALA2025120308827Gas Spring · damagedL1 DOOR GAS SPRING DAMAGE. REMOVED AND INSTALLED NEW L1 DOOR GAS SPRING IAW-B767- AMM -25- 66-03. (1322926)SDR CALA2025120311737Skin · crackedTWO CRACKS SIGNAL NOTED AT STAB RT SIDE HSS 157.10, FIRST CRACK L=0.416 INCH LOCATED TO 9.356INCH FWD FROM AFT SPAR, SECOND CRACK L=0.381INCH LOCATED TO 16.500 INCH FWD FROM AFT SPAR. (PERFORMED PERMANENT REPAIR AT RH HORIZONTAL STAB AT STAB STA 157.10 AND 16.SDR AALA202512021304Module · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEVEL AT FL360 CABIN ALTITUDE LIGHT ILLUMINATED WITH A CABIN ALTITUDE HORN, ALSO AUTOPILOT DISCONNECTED. LIGHT STAYED ILLUMINATED UNTIL 10,000FT. MASKS DID NOT DEPLOY. AIRCRAFT DIVERTED TO AND LANDED SAFSDR AALA202512023183Indicator · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEVEL AT FL360 CABIN ALTITUDE LIGHT ILLUMINATED WITH A CABIN ALTITUDE HORN, ALSO AUTOPILOT DISCONNECTED. LIGHT STAYED ILLUMINATED UNTIL 10,000FT. MASKS DID NOT DEPLOY. AIRCRAFT DIVERTED TO AND LANDED SAFSDR AALA202512027046Indicator · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEVEL AT FL360 CABIN ALTITUDE LIGHT ILLUMINATED WITH A CABIN ALTITUDE HORN, ALSO AUTOPILOT DISCONNECTED. LIGHT STAYED ILLUMINATED UNTIL 10,000FT. MASKS DID NOT DEPLOY. AIRCRAFT DIVERTED TO AND LANDED SAFSDR AALA202512026742Switch · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEVEL AT FL360 CABIN ALTITUDE LIGHT ILLUMINATED WITH A CABIN ALTITUDE HORN, ALSO AUTOPILOT DISCONNECTED. LIGHT STAYED ILLUMINATED UNTIL 10,000FT. MASKS DID NOT DEPLOY. AIRCRAFT DIVERTED TO AND LANDED SAFSDR AALA202512028692Switch · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEVEL AT FL360 CABIN ALTITUDE LIGHT ILLUMINATED WITH A CABIN ALTITUDE HORN, ALSO AUTOPILOT DISCONNECTED. LIGHT STAYED ILLUMINATED UNTIL 10,000FT. MASKS DID NOT DEPLOY. AIRCRAFT DIVERTED TO AND LANDED SAFSDR 2025FA0000793Bushing · delaminatedTHE RIGHT LANDING GEAR LEG BUSHING WHICH SECURES THE LEG TIGHTLY TO THE AIRFRAME STRUCTURE HAD A DELAMINATED BUSHING LINER WHICH COMPLETELY WORKED ITSELF OUT OF THE BUSHING. THE LANDING GEAR LEG WAS FLOPPING AROUND INSIDE THIS BUSHING.SDR AALA202512024203Anti-Ice Valve · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: DURING DESCENT WITH ENGINE ANTI-ICE ON, THE LEFT ENGINE SHOWED AN AMBER TAI LIGHT, WITH A BRIGHT BLUE COWL VALVE OPEN LIGHT. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IND. REMOVED AND REPLACED NUMBE