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 VNAA20260205013Cowl Door · dentedDENT ON LOWER FAN COWL DOOR APPOX 6 O'CLOCK POSITION AL LH ENGINE. DRESSED BACK IAW 670-54-14-1012 REV. B AND REO 670-54-14-1332 REV. - -SDR VNAA20260205012Hinge Bracket · corrodedCORROSION ON BOTH HINGE UPR/LWR (2 EA), AS WELL ON HINGE BRACKET OUTBD (1 EA) OF THE AFT LAVATORY SERVICE DOOR 196ER. EVALUATED WITH EXCEEDED ALLOWABLE DAMAGE PER CRJ700 SRM 52-00-01-101-001-A01 AND WAS REPLACED PER CRJ700 SRM 51-41-02-001-001-A01SDR HNAA2026012100047Shear Tie · crackedSHEAR CLIP IS CRACKED AT FRAME 15 BETWEEN STRINGERS 15R-16R. R & R SHEAR CLIP AT FRAME 15 BETWEEN STRINGERS 15R-16R. IAW EMB 145 SRM 51-40-02 AND PDT EO1-53-25-0454SDR HNAA2026012100035Floorbeam · corrodedCORROSION ON SIDE OF STEP-UP CROSS FLOORBEAM AT FRAME 23 BETWEEN STRINGERS 21R-21L. R & R STEP-UP CROSS FLOORBEAM AT FR23 BTWN STGRS 21R-21L IAW EMB 145 SRM 51-40-02SDR HNAA2026012100034Gusset · corrodedCORROSION ON LH NR 1 BEAM GUSSET. R & R L/H # 1 BEAM GUSSET IAW EMB-145 SRM 51-40-02SDR HNAA2026012100033Floor Support · corrodedCORROSION ON LT OTBD NR 1 FLOOR SILL. R & R L/H OUTBD # 1 FLOOR SILL IAW EMB145 SRM 51-40-02.SDR HNAA2026012100032Door Sill · corrodedCORROSION ON SERVICE DOOR CUT-OUT FWD SILL. R & R THE SERVICE DOOR CUTOUT FWD SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100031Gusset · corrodedCORROSION IN GALLEY AREA ON RT FLOORBEAM GUSSET AT FRAME 18. REMOVED AND REPLACED GUSSET ON GALLEY AREA RT FLOORBEAM GUSSET AT FRAME 18 IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100030Floor Support · corrodedCORROSION IN GALLEY AREA ON FWD DIGITAL. REPAIRED WITH DOUBLER IAW EMB-145 SRM 53-21-10SDR HNAA2026012100029Floorbeam · corrodedCORROSION IN GALLEY AREA ON LT CROSS FLOORBEAM AT FRAME 18. R & R LT CROSS FLOORBEAM AT FRAME 18 IAW EMB145 SRM 51-40-02SDR HNAA2026012100028Floor Support · corrodedCORROSION ON PASSENGER DOOR ENTRY AFT FLOORBOARD SUPPORT. RAR SUPPORT IAW SRM 51-40-02SDR HNAA2026012100027Structure · corrodedLAV WASTE BUCKET IS CORRODED AT AFT OF THE WASTE DRAIN VALVE. REMOVED AND REPLACED LAV WASTE BUCKET IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100026Seat Track · corrodedCORROSION ON RT OTBD NR 2 SEAT TRACK. REMOVED AND REPLACED RT NR 2 OTBD SEAT TRACK IAW EMB 145 AMM 53-01-06.SDR SWAA2026011340729Nut · deterioratedDETERIORATED ENTRY DOOR NUT, ASSIST HANDLE IN THE FWD GALLEY (4 EA). REPLACED ENTRY DOOR HANDLE NUT IAW AMM 52-11-31-400-802, STEP 3 G, ITEM 2.SDR SWAA2026011340900Plate · crackedCRACK ON SEAL PLATE OF ACCESS PANEL 343AB ON RT HORIZONTAL STAB. REPLACED SEAL PLATE IAW SRM 51-40-02, AND SRM 51-10-02, ITEM 9. CRACK LENGTH: 0.420 INCH.SDR SWAA2026011340736Doubler · elongatedELONGATED HOLE ON DOUBLER UNDER ACCESS PANEL 422AB NR 2 ENGINE. REPLACED THE DOUBLER BELOW COWL INLET 6 CLOCK ENGINE 2 & FASTENERS IAW SRM 51-40-02, AND CMM 71-11-22.SDR SWAA2026011340728Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 422AB ENGINE 2. REPLACED ACCESS PANEL 422AB ENGINE 2 IAW SRM 51-10-02, ITEM 9, AND CMM 71-11-22.SDR SWIA2026011209Vane · gougedLEFT INBD FLAP, FLAP VANE LEADING EDGE SKIN PANEL IS GOUGED. REPLACED LT INBD FLAP VANE MID LE IAW CRJ 200 SRM 51-42-13. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORM 337. NOW WEIGHT CHANGE NOTEDSDR SWAA2026011240735Floorbeam · corrodedCORROSION ON FLOORBEAM EXISTING REPAIR LOCATED BS 947.5 BTW LBL 65 TO RBL 65. PERFORMED REPAIR CATEGORY A ON FLOOR BEAM LOCATED BS 947.5 BTW LBL 65 TO RBL 65 IAW EA 25-153-03366 AND SRM 53-70-51-2R-5 REPAIR 5.SDR SWAA2026010940625Scuff Plate · crackedCRACK CENTER SCUFF PLATE AT FWD CARGO BAY. REPAIRED CENTER SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1.SDR SWAA2026010940624Scuff Plate · crackedCRACKED CENTER SCUFF PLATE IN THE AFT CARGO BAY. REPAIRED THE SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1.SDR SWIA20251222129Fitting · wornALL EMERGENCY EVAC SLIDE FLOOR FITTING HARDWARE WORN AND/OR CORRODED (C-CHECK RO 12/19/2025)REMOVED AND REPLACED ALL EMERGENCY EVACUATION SLIDE FITTING HARDWARE PER ERJ 175 AMM 53-23-25. REF CONTINUATION CARD FOR WORK PERFORMED.SDR SWAA2025121940740Floorbeam · crackedCRACKED FLOORBEAM, BS 540, RBL 1. REPLACED THE FLOORBEAM IAW SRM 51-10-02, ITEM 9, AND INSTALLED FASTENERS IAW SRM 51-40-02, & DWG 143A5240, SHEET 14. MEASUREMENT OF CRACK: L, 0.850 INCH;SDR SWAA2025121940907Access Panel · delaminatedDELAMINATED ACCESS PANEL 344AB ON RT HORIZONTAL STAB. REPLACED ACCESS PANEL 344AB AT RT HORIZONTAL STAB IAW AMM 27-31-11-400-801, STEP 3.G (19), (H), AND SRM 51-10-02, ITEM 9, AND INSTALLED.SDR SWAA2025121840747Support Bracket · crackedCRACKED SUPPORT BRACKET LOCATED BS 867 BTW S2 - 3R. REPLACED THE SUPPORT BRACKET IAW SRM 51-10-02-0G, ITEM 9, SRM 51-40-02-0G, AND DWG 146A7901, SHEET 58, REV -. MEASUREMENT OF CRACK: 0.306 INCH.SDR SWAA2025121740602Scuff Plate · crackedCRACK ON FWD CORNER SCUFF PLATE LOCATED ON FWD CARGO BAY. REPAIRED THE FWD CORNER SCUFF PLATE LOCATED ON FWD CARGO COMPARTMENT IAW SRM 53-30-15-2R-1 REPAIR 1.SDR SWAA2025121740603Scuff Plate · crackedCRACK ON FWD CORNER SCUFF PLATE LOCATED IN THE AFT CARGO BAY. REPAIRED THE FWD CORNER SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1.SDR SWAA2025121640746Frame · crackedCRACK ON THE FRAME, BS 747, S8 - 9L. REPAIRED THE FRAME IAW EA 1-A53-12114 REV B.SDR UIEA2025112901330Elec Connector · faultedON DEPARTURE AT 1000' AGL, HYD QTY LOW 4 EICAS ADVISORY MESSAGE, RAN NNC 13.29, SECURED NR 4 HYDRAULIC SYSTEM OFF. T/S PER WDM 29-33-12-2 TO PERFORM WIRING CHKS BTWN HYQUIM D7848CA TO #4 HYD SYS TRANSMITTER DT404, CHKS GOOD & INSULATION RESISTANCE CHCKS NORMSDR AALA202512116434Solenoid Valve · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON FINAL APROACH INTO TPA DUE TO THE FLIGHT CREW REPORTING THAT SHORTLY AFTER LEVEL OF AT FL 320, AN ENGINE 1 COMPRESSOR VANE FAULT ECAM MESSAGE DISPLAYED, SKYWISE SHOWED EEC CHANNEL B FAULT. THE FLIGHT CREW FOLSDR AALA202512111000Bleed Valve · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON FINAL APROACH INTO TPA DUE TO THE FLIGHT CREW REPORTING THAT SHORTLY AFTER LEVEL OF AT FL 320, AN ENGINE 1 COMPRESSOR VANE FAULT ECAM MESSAGE DISPLAYED, SKYWISE SHOWED EEC CHANNEL B FAULT. THE FLIGHT CREW FOLSDR AALA202512112981Solenoid Valve · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON FINAL APROACH INTO TPA DUE TO THE FLIGHT CREW REPORTING THAT SHORTLY AFTER LEVEL OF AT FL 320, AN ENGINE 1 COMPRESSOR VANE FAULT ECAM MESSAGE DISPLAYED, SKYWISE SHOWED EEC CHANNEL B FAULT. THE FLIGHT CREW FOLSDR AALA202512111964Bleed Valve · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON FINAL APROACH INTO TPA DUE TO THE FLIGHT CREW REPORTING THAT SHORTLY AFTER LEVEL OF AT FL 320, AN ENGINE 1 COMPRESSOR VANE FAULT ECAM MESSAGE DISPLAYED, SKYWISE SHOWED EEC CHANNEL B FAULT. THE FLIGHT CREW FOLSDR AALA202512113366Solenoid Valve · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON FINAL APROACH INTO TPA DUE TO THE FLIGHT CREW REPORTING THAT SHORTLY AFTER LEVEL OF AT FL 320, AN ENGINE 1 COMPRESSOR VANE FAULT ECAM MESSAGE DISPLAYED, SKYWISE SHOWED EEC CHANNEL B FAULT. THE FLIGHT CREW FOLSDR AALA202512112186Bleed Valve · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON FINAL APROACH INTO TPA DUE TO THE FLIGHT CREW REPORTING THAT SHORTLY AFTER LEVEL OF AT FL 320, AN ENGINE 1 COMPRESSOR VANE FAULT ECAM MESSAGE DISPLAYED, SKYWISE SHOWED EEC CHANNEL B FAULT. THE FLIGHT CREW FOLSDR AALA202512118179Solenoid Valve · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON FINAL APROACH INTO TPA DUE TO THE FLIGHT CREW REPORTING THAT SHORTLY AFTER LEVEL OF AT FL 320, AN ENGINE 1 COMPRESSOR VANE FAULT ECAM MESSAGE DISPLAYED, SKYWISE SHOWED EEC CHANNEL B FAULT. THE FLIGHT CREW FOLSDR UATA2025121100501Skin · crackedRIGHT HORIZONTAL STAB TOP SKIN CRACKED JUST OTBD OF AFT ATTACH FITTING HSS 740. REMOVED TOP REAR SKIN FROM STAB ROOT TO WS 1200. ELEVATOR COVE SKIN WAS DE-RIVITED TO WS 1500 FOR ACCESS. FABRICATED NEW SKIN AND PATTER AS ORIGINAL INSTALLATION. ACID ETCHED, ALSDR DALA2025121008995Flap System · lockedATB DUE TO FLT CTL FLAPS LOCKED MESSAGE. REPLACED RT APPU, SFCC 1, SFCC 2, PROX SENSOR 40CV, AND PROX SENSOR 38CV. ADJUSTED INTERCONNECTING STRUT DUE TO OUT OF RIG. (LP 8049502)SDR CALA2025121012002Frame · dentedAFT CARGO COMPARTMENT FRAME BS 1320, S25R DENTED. ACCOMPLISHED FRAME REPAIR AT BS 1320, S26R IAW EA 757-5360-13-A4203 AND ECRA 5360-02063.SDR DALA2025120808964Scuff Plate · crackedAFT CARGO SCUFF PLATE CRACKED. REPLACED JAMB PAN ON NR 408 IAW LOG 1325090. (1327367)SDR AALA202512082698Latch · missingAIRCRAFT IN BASE MAINTENANCE: R1 DOOR ESCAPE SLIDE NYLON GIRT BAR LATCH MISSING ON THE OUTER SLEEVE. INSTALLED NEW NYLON GIRT BAR LATCH ON R1 DOOR ESCAPE SLIDE. PER AMM 25-66-01.SDR CALA2025120511787Unknown · malfunctionedLEVEL 2 CHRONIC OF DOOR 4L ARM/DISARM ISSUE. PERFORMED FIM 52-11 TASK 813 AND FOUND NO DEFECTS. REMOVED SLIDE AND PERFORM INSPECTION OF ALL ARMING LEVERS AND ASSOCIATED LINKAGES, PUSHRODS AND CRANKS FOR LOOSE HARDWARE, BENDS, OR BINDING RODS REF AMM 52-11-20.SDR SWAA2025120440922Scuff Plate · crackedFSD SCUFF PLATE CRACKED. REPLACED FSD SCUFF PLATE AND PERFORMED A GOOD LEAK CHECK IAW AMM 53-11-01, AND AMM 05-51-91-790-801.SDR DALA2025120408872Bottle · low pressure3L DOOR PRESSURE INDICATION ILLUMINATED. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7911430)SDR ASAA2025112962660Battery Pack · inoperativeEMERGENCY LIGHTS IN FORWARD GALLEY INOP. GROUNDED - YES. REPLACED BATTERY PACK FOR M1874 IAW AMM 33-51-06-960-805. OPS CHECK GOOD.SDR SWAA2025120340600Battery Pack · inoperativeFWD CABIN OVERHEAD BIN LT EMERGENCY EXIST LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK M1675 AND PERFORMED GOOD FWD CABIN OVERHEAD EMERGENCY EXIST LIGHTS L1086; L1067 AND L273 IAW WDM 33-51-12, & AMM 33-51-06-960-802.SDR SWAA2025120340739Battery Pack · inoperativeFWD 2 LT EMERGENCY COVE LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK M2335; PERFORMED A GOOD TEST IAW AMM 33-51-06-960-802.SDR AALA202512030405Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: INTERNAL LOAD FAULT MESSAGE FOR AFT LEFT EMERGENCY POWER SUPPLY UNIT DISPLAYED DURING SYSTEM TEST. REPLACED AFT LEFT EMERGENCY POWER SUPPLY UNIT AND ACCOMPLISHED A SATISFACTORY OPEWRATIONAL CHECK PER AMM 33-51-38.SDR AALA202512032916Battery · no testAIRCRAFT WAS NOT GROUNDED: LEFT AFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY PER AMM 25-00-00.SDR AALA202512035283Power Supply · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 10WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 335-51-38.