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 LR7A2025071603773Skin · crackedDURING SCHEDULED INSPECTION FOUND CRACK IN LEFT HORIZONTAL STAB FS1095, HSS199L, WL265 / REPAIRED IAW LOCKHEED SMP583 55-20-06 MEA382-55-25-068SDR AALA202507170414Controller · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO LAS DUE TO THE FLIGHT CREW REPORTING THAT WHILE CLIMBING THROUGH FL260 AN EXCESS CABIN ALTITUDE ECAM WARNING DISPLAYED. THE AIRCRAFT LANDED SAFELY AT LAS WITHOUT FURTHER INCIDENT. MASDR AALA202507174560Controller · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO LAS DUE TO THE FLIGHT CREW REPORTING THAT WHILE CLIMBING THROUGH FL260 AN EXCESS CABIN ALTITUDE ECAM WARNING DISPLAYED. THE AIRCRAFT LANDED SAFELY AT LAS WITHOUT FURTHER INCIDENT. MASDR AALA202507178852Reservoir · low pressureAIRCRAFT WAS GROUNDED: 3R SLIDE PRESSURE IN THE RED. MAINTENANCE REPLACED DOOR 3R SLIDE INFLATION BOTTLE PER AMM 25-62-49.SDR AALA202507177684Light · no testAIRCRAFT IN BASE MAINTENANCE: R3 DOOR EMERGENCY LOWER LIGHT INOPERATIVE. REPLACED R3 DOOR EMERGENCY LOWER LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-16.SDR HNAA2025071700469Bleed Valve · abnormalBLD 1 LEAK WARNING MESSAGE APPEARED DURING CLIMB. AFTER RUNNING QRH INSCRIPTION MESSAGE WENT AWAY. REMOVED AND REPLACED PNEUMATIC CROSS BLEED VALVE IRT AMM 36-10-01-000/400-801-A OPS CHECK GOOD OK FOR SERVICESDR CALA2025071706675Start Valve · faultedNUMBER 2 START VALVE OPEN LIGHT FLASHING ON TAKEOFF REMOVED ENG #2 START VALVE & PULLED ASSOCIATED CB REF AMM TASK 80-11-03-000-801-F00 UPDATED LABOR AND GROUND TIME. REMOVED AND REPLACED THE NUMBER 2 ENGINE STARTER SHUTOFF VALVE IN REF TO AMM 80-11-03-400-801SDR CALA2025071706664Light · faultedEMERGENCY PROXIMTY LIGHTS FROM SEATS 6D AND 10D DID NOT TURN ON DURING TEST. REMOVED AND REPLACED EMERG PROXIMITY LIGHTS OF THE SEATS 6D AND 10D IN REF TO AMM 33-51-06.SDR CALA2025071706662Charger · smokeAS PER N786UA (2786) HANGAR NON-ROUTINE PICK-UP SHEET DURING CABIN SURVEILLANCE BY DOOR L2, SMOKE WAS NOTICED COMING FROM CEILING PANEL. FOUND EMERGNECY LIGHT BA TTERY PACK (M33099) EMITTING SMOKE, TECH RAN TO COCKPIT AND PULL ED C/B THEN REMOVED ELECTRICAL SDR CALA2025071706661Battery · smokeAS PER N786UA (2786) HANGAR NON-ROUTINE PICK-UP SHEET (DATED ON: 14 JUL 2025) ITEM 1: DURING CABIN SURVEILLANCE BY DOOR L2, SMOKE WAS NOTICED COMING FROM CEILING PANEL. FOUND EMERGNECY LIGHT BA TTERY PACK (M33099) EMITTING SMOKE, TECH RAN TO COCKPIT AND PULL ESDR CALA2025071706660Door Sill · corrodedCABIN R2 ENTRY FLOOR HAS CORROSION AROUND FWD AND AFT GIRT BAR F ITTING A3NB-53-3-6222 PER HAECO LCQ NON ROUTINE 9290675/40675. REMOVED AND REPLACED R2 DOOR SILL IAW A319 SRM 51-42-11.SDR CALA2025071706659Bracket · corrodedRH AFT WATER DRAIN FR69 HAS CORROSION ON TIP. REMOVED AND REPLACED LH AFT WATER DRAIN FR 69 IAW A319 SRM 51-72 -11.SDR CALA2025071706658Pitot Tube · bentAFTER ROTATION UNDER 1K FT. NAV AIR SPD CHANGED ADR 1 SPD FAULT . REST WERE RELIABLE. X ON CA REMOVED #1 PITOT PROBE IAW AMM 34-12-15-000-001-A. CAPTAINS SIDE UPPER PITOT PROBE HAS BEEN REPLACED REF LP 5572905 ACP BIRD STRIKE INSP REF MM TASK 05.51.14.200SDR UIEA2025071100911Lamp · inoperativeUPPER DECK TOP OF STAIRWELL EMERGENCY CEILING LIGHT INOPERATIVE. RELAMPED UPPER DECK EMERGENCY CEILING LIGHT AT THE TOP OF STAIRWELL IAW AMM 33-51-07-962-001. OPS CHK OK.SDR UIEA2025071100912Lamp · inoperativeL2 DOOR JAMB FWD ROOR LIGHT INOP. RELAMPED DOOR JAMB FWD DOOR LIGHT IAW AMM 33-51-05-962-031. OPS CHK OK.SDR UIEA2025071100913Lamp · inoperativeBOTH L5 DOOR JAMB EMERGENCY LIGHTS INOP. RELAMPED BOTH L5 DOOR JAMB EMERGENCY LIGHTS IAW AMM 33-51-05-962-031. OPS CHK OK. NO FURTHER DEFECTS NOTED.SDR UIEA2025071500955Battery Pack · inoperativeUPPER DECK LT GULL DOOR INSIDE LEVER EMER LIGHT INOPERATIVE. RELAMPED LH GULL DOOR EMERGENCY LIGHTS AND REMOVED AND REPLACED BATTERY PACK M5057 IAW AMM 33-51-06-962-009. OPS CHK OK. NO FURTHER DEFECTS NOTED.SDR UIEA2025071500956Battery Pack · inoperativeFWD AND MID LT EXTERIOR OVER WING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED LH EMERGENCY LIGHT POWER SUPPLY IAW 33-51-04-902-001-001. OPS CHK OK. NO FURTHER DEFECTS NOTED.SDR UIEA2025071500957Battery Pack · inoperativeRH EXTERIOR OVER WING AFT EMERGENCY LIGHT INOP. REMOVED AND REPLACED RH EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-04-902-001-001. OPS CHK OK. NO FURTHER DEFECTS NOTED.SDR UIEA2025071500958Light · inoperativeCREW REST EMERGENCY LIGHTS AT THE CEILING INOP. REMOVED AND REPLACED CREW REST EMERGENCY LIGHT AT THE CEILING IAW AMM 33-51-07-402-015. OPS CHK OK. NO FURTHER DEFECTS NOTED.SDR HK0Y2025071600503Blade · damagedESN42072 FAN BLADES (P/N: FW23741, SN: RGF22695) WAS REJECTED IN THE WATER COUPLED PHASED ARRAY INSPECTION IN-SERVICE. RR ENGINEERING ASSESSMENT HAS CONCLUDED THAT THE REPORTED DEVIATION IS EXTENSIVE AND CANNOT BE ACCEPTED OR REPAIRED. HENCE, THE PARTS ARE REJSDR HK0Y2025071600502Blade · damagedESN42306 FAN BLADES (P/N: FW23741, SN: RRWCFBRGF52232 AND RRWCFBRGF53140) WERE REJECTED IN THE WATER COUPLED PHASED ARRAY INSPECTION IN-SERVICE. RR ENGINEERING ASSESSMENT HAS CONCLUDED THAT THE REPORTED DEVIATION IS EXTENSIVE AND CANNOT BE ACCEPTED OR REPAIREDSDR N6WA2025071605Seat Track · corrodedRH SEAT TRACK BETWEEN FS374.00 - FS485.00 AT RBL9 HAS CORROSION. REMOVED AND REPLACED RH SEAT TRACK BETWEEN FS374.00 - FS485.00 AT RBL9 IAW CRJ AMM 53-00-49.SDR N6WA2025071604Seat Track · corrodedLH SEAT TRACK BETWEEN FS374.00 - FS485.00 AT LBL9 HAS CORROSION. REMOVED AND REPLACED LH SEAT TRACK BETWEEN FS374.00 - FS485 AT LBL9 IAW CRJ AMM 53-00-49.SDR N6WA2025071603Seat Track · corrodedCORROSION ON THE LH AND RH SIDE RAILS BETWEEN FS379.00 TO FS669.40 AT STRINGER 15L AND STRINGER 15R. REMOVED AND REPLACED THE LH AND RH SIDE RAILS BETWEEN FS379.00 TO FS669.40 AT STRINGERS 15L AND 15R IAW CRJ AMM 53-00-49.SDR N6WA2025071602Seat Track · corrodedCORROSION ON SEAT RAILS AT FS477.40 TO FS693.00. REMOVED AND REPLACED SEAT RAILS AT FS477.40 TO FS693.00 IAW CRJ AMM 53-00-49.SDR DALA2025071605367Frame · damagedSHIP 3415, FRAME 63 STR 2RT FWD SIDE OF FRAME 5 AREAS OF STRINGER NOTED WITH GOUGES AND DENTS. REPAIRED PER E/RA 627666-14.SDR DALA2025071605365Stringer · gougedSHIP 3415, STR 1RT JUST FWD OF FRAME 62 NOTED WITH GOUGE ON O/B SIDE FWD SIDE OF FRAME. COMPLIED WITH ER/A 627666-14.SDR DALA2025071605360Frame · bentSHIP 3415 FRAME 61 STR 2LT BENT AT JUNCTION OF FRAME AND STRINGER. COMPLIED WITH E/RA 627666-14.SDR DALA2025071605359Stringer · dentedSHIP 3415, FRAME 64 FWD SIDE STRINGER 2 LT DENTED 1 EACH LOCATION. COMPLIED WITH E/RA 627666-14.SDR DALA2025071605350Cable · shearedSHIP 3161-ATB-RETURNED TO BIS DUE TO RIGHT ENGINE EGT OVER LIMIT. EMERGENCY WAS DECLARED. EGT LIMIT WAS NOT REACHED. MTC FOUND VBV INTERCONNECTING CABLE SHEARED AT NUMBER 9 POSITION VBV DOOR. REPLACED MASTER ACTUATOR, STOP MECHANISM, MOTOR, AND SHAFT. MIP.SDR DALA2025071605348Door Frame · crackedSHIP 3130, CRACK INDICATION FOUND ON FRAME 16 RH DOUBLE JOGGLE AREA HOLE 5 DOOR STOP FITTING 7. COMPLIED WITH ER/A 626886-14AD.SDR DALA2025071605347Door Frame · crackedSHIP 3130, CRACK INDICATION FOUND ON FRAME 16 LH DOUBLE JOGGLE AREA HOLE C DOOR STOP FITTING 7. COMPLIED WITH ER/A 626760-14AD.SDR DALA2025071605346Door Frame · crackedSHIP 3130, CRACK INDICATION FOUND ON HOLE 3 OF THE DOOR STOP FITTING 1 AT FRAME 2 0 LH SIDE. COMPLIED WITH ER/A 626883-14AD.SDR DALA2025071605345Skin · wornSHIP 3130, WEAR ON EXTERNAL SKIN FR34 AND STRG43R LOWER FUSELAGE. COMPLIED WITH ER/A 626899-14AD.SDR EE4Y2025071622716Skin Panel · corrodedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-ZL-471-01-4-001, ENGINE # 1 AT PYLON CENTER I/B AREAS WIG SKIN WITH CORROSION. REPAIRED LOWER SKIN AREAS I/B AND O/B AT PYLON # 1 IAW COOPESA EO # COO-EO-2025-22586-R01 APPROVED BY AIRBUS RDAF 81612227/004/2025 SDR DALA2025071605341Indicator · inoperativeSHIP 668 KNUCKLE KNOCKER AT 3L DOOR DOES NOT EXTEND WHEN DOOR ARMED. KNUCKLE KNOCKER AT 3L IS REALLY 3R ADJUSTED DOOR TRIM. BOTH DOOR ARMED KNOCKERS WORK PER 757 AMM 52-12. (7329960)SDR EE4Y2025071622714Fitting · burredDURING ACCOMPLISHMENT OF THE ALLEGIANT WORK ORDER A32X-25-127-003, LOWER FUSELAGE REAR AVIONICS COMPARTMENT 80VU AVIONICS RACK LOWER LATERAL FITTING LH/RH WITH MATERIAL BURRED. THE REPAIR WAS ACCOMPLISHED IN ACCORDANCE WITH ALLEGIANT EO # A32X-STR-25EO-00203-RSDR EE4Y2025071622713Skin Panel · corrodedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-ZL-471-01-1-001, ENGINE # 1 PYLON OUTBOARD SIDE RIB 7A WITH CORROSION. PERFORMED PERMANENT BLEND OUT REPAIR ON LH WING LOWER SKIN PYLON OUT SIDE IAW COOPESA EO # COO-EO-2025-22665-R00 APPROVED AND DOCUMENTED ONSDR JR2R20250716747Doubler · corrodedFWD WET AREA, SHEAR WEB / DOUBLER CORRODED ON AFT I/B CORNER FWD OF FR16 APPROX RBL45. REPLACEDSDR QR9R2025071600001Headrest · brokenWHILE PERFORMING POST FLIGHT INSPECTION, MAINTENANCE FOUND PILOT HEADREST ASSY BROKEN AT SUPPORT BASE. REMOVED AND REPLACED HEADREST ASSY IAW CMM 25-10-17.SDR ABXA20250716159Elevator System · malfunctionedDURING TAXI, L ELEVATOR SHOWING NO MOVEMENT DURING BEFORE TAKEOFF CHECKLIST. AIRCRAFT RETURNED TO BLOCKS. (BTB) DEFERRED IAW MEL C ABX-27-08-1. AIRCRAFT RETURNED TO SERVICE.SDR FDEA202507161224Skin · damagedDURING ACCOMPLISH WITH WC E G-5710-E0376285E-P8 STEP 3.A, FOUND RH WING UPPER SKIN #6 HOLE DIAMETER SIZE IS 0.403". RH WING UPPER SKIN #6 HOLE REPAIRED AS PER B777 SRM 51-40-02-0G, SRM 51-40-04-0G REV 47.6 AND EA G-5730-T0384117 P1, TITLE:WING - PLATES ANDSDR FDEA202507161223Pitot Tube · cloggedRECEIVED ALT AND IAS ON TAKEOFF. ONCE AIRBORNE, IDENTIFIED #1 AIRSPEED/CADC WAS ERRONEOUS. COMPLETED CHECKLIST AND RETURNED FOR LANDING. PURGED CAPTAIN PITOT TUBE AND FOUND DEBRIS IN TUBE. LEAK CHECKED CAPTAIN AND STANDBY PITOT STATIC SYSTEM WITH NO LEAKSDR FDEA202507161222Trunnion · crackedDURING HIGH FREQUENCY EDDY CURRENT INSPECTION ON NOSE LANDING GEAR LEFT HAND TRUNNION FITTING AT STATION 595 EXISTING REPAIR SLOT OUT AREA FOUND 02 EACH CRACK WITH LENGTH APPROXIMATE 1/8". CRACK AREA ON NOSE LANDING GEAR LEFT HAND TRUNNION FITTING AT STATISDR AALA202507161325Bottle · 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 JJBA20250716057Door Frame · corrodedCARGO DOOR CUT-OUT BTW FR 65-68 LOWER BEAM FOUND CORRODED. ON CARGO DOOR CUT-OUT BTW FR 65-68 LOWER BEAM REMOVED AND REPLACEDSDR JR2R20250716785Floorbeam · corrodedCROSS BEAM BETWEEN LBL 10 AND RBL 10 AT FRAME 17 IS CORRODED. OUT OF LIMITS. REPAIREDSDR JR2R20250716932Shear Tie · corrodedSHEAR TIE AT FR78 BETWEEN STR21L AND STR22L CORRODED. REPLACED.SDR HK0Y2025071600500Shaft · corrodedHAESL REPORTED CORROSION PITTING ON LPC SHAFT OF ESN 21607, RROYCE INSTRUCTED TRIAL REPAIR BY DRESSING AND BLUE BED CHECK. HOWEVER, HAESL HAS NO CAPABILITY TO PERFORM THE BLUE BED CHECK. IN ACCORDANCE WITH TIME LIMITS MANUAL TASK 05-10-01-800-801, THE DECLARE