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 AALA202603069689Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND FSDR AALA202603061448Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND SDR AALA202603065061Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND FSDR AALA202603064734Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND FSDR AALA202603065951Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND SDR AALA202603063263Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND SDR AALA202603067347Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND FSDR AALA202603069474Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND FSDR AALA202603069141Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND FSDR AALA202603068293Probe · faultedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. REPLACED RIGHT WING FUEL QUANTITY COMPENSATOR (AALA202512179117) AND FSDR AALA202603069117Compensator · failedAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. **SUPPLEMENTAL REPORT FOR (AALA202512179117) SUBMITTED 12/17/2025 BY DFSDR VNAA20260201006Drag Angle · crackedCRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD/AFT DRAG ANGLE BTW 55.62% STGR DATUM TO STGR DATUM TO 67.5% REAR SPAR DATUMS. CRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD/AFT DRAG ANGLE BTW 55.62% STGR DATUM TO STGR DATUM TO 67.5%SDR VNAA20260201005Drag Angle · crackedCRACK ON RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD/AFT DRAG ANGLE BTW 55.62% STGR DATUM TO STGR DATUM TO 67.5% REAR SPAR DATUM. RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.62% STGR DATUM TO STGR DATUM TO 67.5% REAR SPARSDR VNAA20260201004Hinge · corrodedCORROSION ON HINGE OF AFT LAVATORY SERVICE DOOR AT EXTERNAL FUSELAGE. HINGE OF AFT LAVATORY SERVICE DOOR AT EXTERNAL FUSELAGE WAS REPLACED PER CRJ/900 SRM 51-41-02-001-001-A01 AND CRJ/900 AMM 52-45-01.SDR JJBA20260130061Thrust Reverser · damagedNUMBER 2 ENGINE LOWER THRUST REVERSER IB LOWER CORNER HAS DAMAGED COMPOSITE. REPAIRED DAMAGE TO #2 ENGINE LOWER CORNER ON LOWER THRUST REVERSER REPAIREDSDR HNAA2026012900103Shear Tie · crackedRIGHT SHEAR TIE CRACKED AT FR 80 BTW S3-5R. R & R SHEAR TIE IAW SRM 51-40-02SDR SWAA2026012853009Angle · crackedCRACKED ANGLE, BS 400, LBL 21, IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 143A7505,SHEET 137, REV-.SDR SWAA2026012853010Angle · crackedCRACKED ANGLE, BS 500H, LBL 21 IN THE FWD CARGO BAY. REPLACED THE ANGLE & FASTENERS IAW SRM 51-40-02, DWG 143A7505, SHEET 138, REV -.SDR SWAA2026012853011Angle · crackedCRACKED ANGLE, BS 440, LBL 21. IN THE CARGO BAY. REPLACED THE ANGLE IAW SRM 51-40-02-0G-0, & DWG 143A7505, SHEET 138, REV -.SDR SWAA2026012853013Angle · crackedCRACKED ANGLE, BS 500G, RBL 21, IN THE CARGO BAY. REPLACED THE ANGLE & FASTENERS IAW SRM 51-40-02-0G-0, & DWG 143A7505, SHEET 137, REV-.SDR SWAA2026012853016Angle · crackedCRACKED ANGLE, BS 500G, RBL 21 AFT SIDE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02-0G-0, ITEM 9, & DWG 143A7505, SHEET 137, 138, & 139, REV-.SDR SWAA2026012853014Gusset Angle · crackedCRACKED GUSSET ANGLE, BS 500I, S19R. REPLACED THE GUSSET & FASTENERS IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, & DWG 143A7902, SHEET 256, REV B.SDR HNAA2026012800093Profile · crackedBOTTOM OF VERTICAL STAB, AFT OF REAR SPAR 3, RT PROFILE CRACKED AT LWR END. REPAIRED IAW ETD 2026-145-934573 AND EO1-55-26-0011SDR SWAA2026012753015Angle · crackedCRACKED ANGLE, BS 500H, RBL 21 FWD SIDE IN THE FWD CARGO BAY. REPLACED THE ANGLE & FASTENERS IAW SRM 51-40-02-0G-0, & DWG 143A7505, SHEET 137, REV-.SDR SWAA2026012753012Angle · crackedCRACKED ANGLE, BS 500H, RBL 21 AFT SIDE IN THEFWD CARGO BAY. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-10-02-0G, SRM 51-40-02-0G-0, & DWG 143A7505, SHEET 137, REV-.SDR SWAA2026012652972Angle · crackedCRACK INNER ANGLE LOCATED BS 303.9, LBL 55 FWD GALLEY AND LAVATORY. REPLACED THE ANGLE BTWN BS 270 - 360, LBL 55, WL 208.1 IAW SRM 51-40-02-0G-0, DWG 142A0050, SHEET 15, REV-.SDR SWAA2026012652955Floor Support · corrodedCORRODED FLOOR SUPPORT, BTW BS 328 - 344, LBL 45.5, WL 208.1 IN FWD GALLEY AREA. REPLACED FLOOR SUPPORT IAW SRM 51-40-02 AND SRM 51-10-02-0G-0, ITEM 9, DWG 141A5730, SHEET 30, REV A.SDR SWAA2026012652971Floor Support · corrodedCORRODED FLOOR SUPPORT BTW BS 328 - 344, LBL 24.75, WL 208.1. REPLACED FLOOR SUPPORT IAW SRM 51-40-02 AND DWG 141A5730, SHEET 30, REV A.SDR SWAA2026012652954Floorbeam · corrodedCORRODED FLOORBEAM, BS 328, RBL 24.75 - 45.5, WL 208.1. PERFORMED A PERMANENT REPAIR ON THE FLOORBEAM IAW SRM 53-10-51-2R-7, REPAIR 7.SDR SWAA2026012652951Floorbeam · corrodedCORRODED FLOORBEAM, BS 986.5 RBL 28 - 44, WL 208.1. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6, ALTERNATIVE 4.SDR SWAA2026012653102Nut Plate · corrodedCORROSION ON THE OTBD FRONT SPAR RAIL NUT PLATE, BETWEEN OFSS 430 TO OFSS 444, RT WING. REPLACED THE OTBD FRONT SPAR RAIL NUT PLATE IAW SRM 51-10-02-0G, ITEM 9, SRM 51-40-02-0G, & DWG 112A4402, SHEET 40, REV A. EVALUATED CORROSION ON THE RAIL NUT PLATE ANDSDR SWAA2026012652976Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE, BETWEEN OFSS 297 - OFSS 301, RT WING. REPLACED THE NUT PLATE IAW SRM 51-10-02-0G, ITEM 9, SRM 51-40-02-0G, & DWG 112A4402, SHEET 40, REV A. EVALUATED CORROSION ON RAIL NUT PLATE AND NOT FOUND ALLOWABLE DAMAGE FOR CORSDR SWAA2026012653100Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE, BETWEEN OFSS 413 - OFSS 416, RT WING. REPLACED THE NUT PLATE IAW SRM 51-40-02-0G, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026012653105Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE, OFSS 543 - OFSS 545, RT WING. REPLACED NUT PLATE IAW SRM 51-40-02-0G, & DWG 112A4402, SHEET 40, REV A.SDR SWAA2026012653108Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE, BETWEEN OFSS 563 - OFSS 579, RT WING. REPLACED THE NUT PLATE IAW SRM 51-40-02-0G, SRM-51-10-02-0G-0, ITEM 9, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026012653103Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE, BETWEEN OFSS 533 - OFSS 540, RT WING. REPLACED THE NUT PLATE IAW SRM 51-40-02-0G, SRM-51-10-02-0G-0, ITEM 9, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026012653106Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE, BETWEEN OFSS 520 - OFSS 527, RT WING. REPLACED NUT PLATE IAW SRM 51-40-02-0G, SRM-51-10-02-0G-0, ITEM 9, & DWG 112A4402, SHEET 40, REV A.SDR SWAA2026012653101Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE, OFSS 419 - OFSS 423, RT WING. REPLACED NUT PLATE IAW SRM-51-10-02-0G-0, ITEM 9, SRM-51-40-02-0G, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026012652967Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE BETWEEN OFSS 406 - OFSS 409, RT WING. REPLACED THE NUT PLATE IAW SRM 51-40-02-0G, SRM-51-10-02-0G-0, ITEM 9, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026012652986Nut Plate · corrodedCORRODED OTBD FRONT SPAR RAIL NUT PLATE. BETWEEN OFSS 306 - OFSS 310, RT WING. REPLACED OTBD SPAR RAIL NUT PLATE IAW SRM 51-40-02-0G, SRM-51-10-02-0G-0, ITEM 9, AND DWG 112A4402, SHEET 40, REV A.SDR VNAA20260125020Fitting · corrodedCORRODED FLOOR FITTING ACCESS 107, AISLE SIDE AND BEHIND ACCESS 108 ON GALLEY 1. FLOOR FITTING ACCESS 107 AISLE SIDE AND BEHIND ACCESS 108 PN, CDSP2019-7C-760 WERE REPLACED IAW CMM 25-33-21.SDR SWAA2026012352973Web · crackedCRACKED WEB - INTERCOSTAL FLOOR STRUCTURE BTW BS 312 TO 328, LBL 46. REPLACED THE WEB - INTERCOSTAL AND FASTENERS IAW SRM 51-40-02, AND DWG 141A5400, SHEET 26, REV -.SDR SWAA2026012353104Floor Panel · corrodedCORRODED FLOOR PANEL 140DF AT AFT CARGO BAY. REPLACED FLOOR PANEL 140DF IAW SRM 51-10-02, ITEM 9.SDR SWAA2026012252948Floor Support · no discrepancyCORRODED INTERCOSTAL BETWEEN BS 947.5 & 967, LBL 26, WL 208.1 IN THE AFT GALLEY. PERFORMED VISUAL INSPECTION OF THE INTERCOSTAL, AND NO CORROSION OR OTHER DAMAGE FOUND IAW SRM 51-10-02-0G.SDR SWAA2026012252974Angle · crackedCRACKED ANGLE, BTW BS 291 & 294, RBL 53, IN THE FWD GALLEY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 141A8310, SHEET 33, REV-.SDR SWAA2026012252946Floor Support · corrodedCORRODED INTERCOSTAL, BTW BS 947.5 - 967, RBL 43, WL 208.1 IN THE AFT GALLEY. REPLACED THE INTERCOSTAL IAW SRM 51-40-02-0G, SRM-51-10-02-0G-0, ITEM 9, & DWG 147A5650, SHEET 71, REV A.SDR HNAA2026012000017Spar · crackedBTM OF VRT STA, AFT OF REAR SPAR 3, LWR LH PROFILE CRACKED IN 2 PLACES. RAR PROFILE IAW SRM 51-40-02SDR 3EJA202601150004Bracket · wornON RETRACTING THE MLG WE FELT AND HEARD A LOUD VIBRATION THAT SEEMED TO BE COMING FROM THE NOSE GEAR. IT WAS ACCOMPANIED BY THE GEAR UNSAFE LIGHT FLASHING IN RHYTHM WITH THE SOUND THAT EVENTUALLY EXTINGUISHED WITH THE HYDRAULIC ANNUNCIATOR. REPLACED NLG UPLOSDR AALA202601153652Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO FLOOR SUPPORT AT BS 867 AT S25L. REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-1 AND EA 370720.SDR SWAA2026011453062Panel · debondedDEBOND ON OUTER SKIN OF PANEL 193AR. REPAIRED IAW SRM 51-70-05-2R-1-A00732, REPAIR 1.