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 AALA202507082715Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 56 AND FR 57 AT S43L. REPAIRED STRINGER PER SRM 53-00-13-300-001.SDR AALA202507084547Mount · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT WING TRAILING EDGE PANEL #3 LOWER SURFACE PYLON MOUNTING PLATE SYSTEM FEED THRU HOLES WORN BETWEEN RIB 7 AND RIB 8. REPLACED MOUNTING PLATE PER SRM 57-21-11-300-005.SDR YENA2025070800709Fire Detector · failedFLT#778, LAS-BOS.(ETOPS) "ENG 1 FIRE LOOP B FAULT ( ENGINE FIRE DETECTION SYSTEMS 2) LOOP B ); (RESOLVED ON W/O: 1424411 TASKCARD: NR-00001) REMOVED AND REPLACED ENG #1 CORE LOOP B PER AMM 26-12-17. NO FAULTS NOTED. OPS TEST SATISFACTORY. THIS CLEARS MDDR 587SDR YENA2025070800708Smoke Warning · false activationFLT#1926, LGW-BOS, "SMOKE CLASS 2 MAINT MSG ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 2) FAULT(S) INDICATED BY SMOKE); (RESOLVED ON W/O: 1423668 TASKCARD: NR-00001) PERFORMED BITE TEST OF SDF. BITE TEST OKAY. REF AMM SDR AALA202507087961Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HARD TO OPEN AND CLOSE. ADJUSTED DOOR FOR FORWARD LAVATORY, OPERTIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202507089465Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON R1 DOOR SERVICE DOOR WAS HARD TO PUT ON POSITION AND REMOVE. REPOSITIONED GIRT BAR FOR DOOR 1R. PER AMM 25-66-01.SDR AALA202507083229Megaphone · no testAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING CARD 09C20025006, FOUND AFTER MEGAPHONE SPEAKER INOPERATIVE. REMOVED AND REPLACED AFT MEGAPHONE. PER 25-64-00 AMM, OPERATIONAL CHECK GOOD.SDR AALA202507089431Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTADNENTS FLASHLIGHT NOT SERVICEABLE. REMOVE AND REPLACED FLIGHT ATTANDENTS FLASHLIGHT BATTERY. PER AMM 25-64-00. NO FURTHER DEFECTS.SDR AALA202507085505Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT OVER WING EMERGENCY EXIT DOOR LIGHT AFT INOPERATIVE. RELAMP LEFT OVER WING EMERGENCY EXIT DOOR AFT LIGHT ASSEMBLY. PERFORMED OPERATIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202507082320Handle · malfunctionedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EMERGENCY EXIT DOOR PULL HANDLE IS MALFUNCTIONING. REMOVED AND INSTALLED A SERVICABLE RIGHT HAND FORWARD OVERWING EMERGENCY EXIT DOOR PULL HANDLE. PER AMM 52-22-51. OPERATIONAL CHECK IS GOOD.SDR YENA2025070800707Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 16 LH SIDE IN OPEN FASTENER HOLE H1 AT DOOR STOP FITTING 7 POSITION, CRACK DIRECTIONS ARE 6 AND 12 OCLOCK, CRACK D EPTH IS 0.115 INCH APPROX, AT FWD GALLEY AREA (2 EA); REF AEROMAN NR 2025-315768 WO 2025 177/SDR YENA2025070800706Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 16 LH SIDE IN OPEN FASTENER HOLE H3 AT DOOR STOP FITTING 7 POSITION, CRACK DIRECTION IS 3OCLOCK, CRACK DEPTH IS 0 .120 INCH APPROX, AT FWD GALLEY AREA (1 EA); REF AEROMAN NR 2025-315769 WO 2025 177/1 PERFORMESDR YENA2025070800705Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 16 RH SIDE IN OPEN FASTENER HOLE H1 AT DOOR STOP FITTING 7 POSITION, CRACK DIRECTION IS 7 OCLOCK, CRACK DEPTH IS 0.080 INCH APPROX, AT FWD GALLEY AREA (1 EA); REF AEROMAN NR 2025-315766 WO 2025 177/1 REMOVED SDR YENA2025070800704Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 16 RH SIDE IN OPEN FASTENER HOLE H3 AT DOOR STOP FITTING 7 POSITION, CRACK DIRECTIONS ARE 6 AND 9 OCLOCK, CRACK DEPTH IS 0.085 INCH APPROX, AT FWD GALLEY AREA (2 EA); REF AEROMAN NR 2025-315767 WO 177/1 REMOVSDR YENA2025070800703Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 16 LH SIDE IN OPEN FASTENER HOLE H2 AT CROS SBEAM SPLICING AREA, CRACK DIRECTION IS 12 OCLOCK, CRACK DEPTH IS 0.11 2 INCH, AT FWD GALLEY AREA (1 EA); PERFORMED PERMANENT REPAIR ON FRAME 16 LH SIDE HOLE H2 AT SDR YENA2025070800702Dummy Rail · corrodedDURING HEAVY MAINTENANCE: CORROSION RAIL DUMMY Y503.2 LOC. BTW FR12/FR16 FWD GALLEY AREA (1 EA) (CPCP FINDING); (RESOLVED ON W/O: 1381843 TASKCARD: NR-00038) REF AEROMAN NR 2025-315823 WO 2025 177/1 REMOVED AND REPLACED RAIL DUMMY Y503.2 LOC. BTW FR12/FR16 FWDSDR YENA2025070800701Floor Support · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR SUPPORT -Y1292 LOC. BTW FR12/FR24 FWD GALLEY AREA (1 EA) (CPCP FINDING); (RESOLVED ON W/O: 1381843 TASKCARD: NR-00039) REF AEROMAN NR 2025-315824 WO 2025 177/1 REMOVED AND REPLACED FLOOR BEAM -Y1292 AND FASTENERS LOCATSDR YENA2025070800700Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 68 RH SIDE IN OPEN FASTENER HOLE LOWER INBOARD AT DOOR STOP FITTING 1 POSITION, CRACK DIRECTION IS 1 OCLOCK, CRAC K DEPTH IS 0.110 INCH, AT AFT GALLEY AREA (1 EA); (RESOLVED ON W/O: 1381843 TASKCARD: NR-00040SDR YENA2025070800699Floor Support · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR BEAM +Y1292 LOC. BTW FR12/FR24 FWD GALLEY AREA (CPCP FINDING); (RESOLVED ON W/O: 1381843 TASKCARD: NR-00044) REF AEROMAN NR 2025-315816 WO 2025 177/1 INSTALLED NEW FLOOR BEAM Y1292, SPLICE (1E/A) AND FASTENERS LOC. BTWSDR YENA2025070800698Floor Support · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR BEAM +Y765 LOC. BTW FR12/FR24 AT FWD GALLEY AREA (1 E A) (CPCP FINDING ; (RESOLVED ON W/O: 1381843 TASKCARD: NR-00045) REF AEROMAN NR 2025-315817 WO 2025 177/1 REMOVED AND REPLACED FLOOR BEAM Y765 AND SPLICE (1E/A) LOCSDR YENA2025070800697Stringer · corrodedDURING HEAVY MAINTENANCE: CORROSION STRINGER 26R LOCATED FR64 TO FR 65 IN AFT CARGO COMPARTMENT; REF AEROMAN NR 2025-315986 WO 2025 177/1 REMOVED AND REPLACED STRINGER 26R LOC. BTW FR64 TO FR67 IN AFT CARGO COMPARTMENT I.A.W A320 SRM 51-42-11, A320 SRM 51-72-1SDR YENA2025070800696Hinge Fitting · corrodedDURING HEAVY MAINTENANCE: CORROSION FOUND ON BORE HINGE FITTING 1 OF VERTICAL STABILIZER; REF AEROMAN NR 2025-315970 WO 2025 177/1 REMOVED AND REPLACED HINGE FITTING #1 AND FASTENERS LOCATED VERTICAL STABILIZER IAW A320 SRM
55-3.SDR YENA2025070800695Hinge Fitting · corrodedDURING HEAVY MAINTENANCE: CORROSION FOUND ON BORE HINGE FITTING 3 OF VERTICAL STABILIZER; REF AEROMAN NR 2025-315971 WO 2025 177/1 REMOVED AND REPLACED HINGE FITTING #3 AND FASTENERS LOCATED VERTICAL STABILIZER IAW A320 SRM
55-36.SDR YENA2025070800694Hinge Fitting · corrodedDURING HEAVY MAINTENANCE: CORROSION FOUND ON BORE HINGE FITTING 4 OF VERTICAL STABILIZER; REF AEROMAN NR 2025-315972 WO 2025-177/1 REMOVED AND REPLACED HINGE FITTING #4 AND FASTENERS LOCATED VERTICAL STABILIZER IAW A320 SRM
55-3.SDR YENA2025070800693Hinge Fitting · corrodedDURING HEAVY MAINTENANCE: CORROSION FOUND ON BORE HINGE FITTING 5 OF VERTICAL STABILIZER; REF AEROMAN NR 2025-315973 WO 2025 177/1 REMOVED AND REPLACED HINGE FITTING #5 AND FASTENERS LOCATED VERTICAL STABILIZER IAW A320 SRM 55.SDR YENA2025070800692Hinge Fitting · corrodedDURING HEAVY MAINTENANCE: CORROSION FOUND ON BORE HINGE FITTING 7 OF VERTICAL STABILIZER; REF AEROMAN NR 2025-315974 WO 2025 177/1 REMOVED AND REPLACED HINGE FITTING #7 AND FASTENERS LOCATED VERTICAL STABILIZER IAW A320 SRM
55-36-4.SDR YENA2025070800691Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON EMERGENCY EXIT DOOR 833FRAME SEGMENTS(1), LONGEST CRACK LENGTH IS AT AFT FRAME SEGMENT, L=0.63INCH,IN PASSENGER CABIN (8); (RESOLVED ON W/O: 1381843 TASKCARD: NR-00047) REF AEROMAN WO 2025-177/1 NR 2025-315758. ACCSDR YENA2025070800690Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON EMERGENCY EXIT DOOR 834 FRAME SEGMENTS(1), LONGEST CRACK LENGTH IS AT FRAME SEGMENT, L=0.22INCH, IN PASSENGER CABIN (8EA); (RESOLVED ON W/O: 1381843 TASKCARD: NR-00048) REF AEROMAN WO 2025-177/1 NR 2025-315757. ACCSDR YENA2025070800689Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON EMERGENCY EXIT DOOR 843 FRAME SEGMENTS(1), LONGEST CRACK LENGTH IS AT AFT FRAME SEGMENT, L=1.33INCH,IN PASSENGER CABIN (11EA); (RESOLVED ON W/O: 1381843 TASKCARD: NR-00049) REF AEROMAN WO 2025-177/1 NR 2025-315759.SDR YENA2025070800688Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON EMERGENCY EXIT DOOR 844 FRAME SEGMENTS (1), LONGE ST CRACK LENGTH IS AT FWD FRAME SEGMENT, L=1.43 INCH, IN PASSENGER CAB IN (20 EA); ACCOMPLISHED THE REINFORCEMENT OF THE STRUCTURE ON EMERGENCY EXIT DOOR 844 IAW SDR YENA2025070800687Skin · corrodedDURING HEAVY MAINTENANCE: CORROSION LEADING EDGE UPPER SURFACE LOC. BTW RIB1 TO RIB 2 ON LH WING; ACCOMPLISHED REPAIR OF CORROSION DAMAGE ON THE LH WING TOP SKIN PANEL UPPER SURFACE AT LEVEL OF RIB 1-2 AND STRG 4 IAW AEROMAN EA 57-0048-25 REV 0 (COVER PLUS P-1SDR YENA2025070800686Skin · corrodedDURING HEAVY MAINTENANCE: CORROSION TRAILING EDGE ON TOP SKIN LOWER SURFACE OVERHANG AT LEVEL R IB 6 TO RIB 7 ON RH WING (CPCP FINDING ). REPAIR OF CORROSION ON THE RH WING TOP SKIN PANEL 2, LOWER SURFACE TEOH FALSE REAR SPAR BETWEEN WX3494.5 - WX4010.2 IN SDR KCSA20250708535Light · inoperativeRIGHT HAND UPPER DECK GROUND MODE LIGHT INOPERATIVE. TRANSFERRED TO DMI 100259027 IAW MEL 52-23-4-2 CATEGORY C DUE DATE 07/15/25 PLACARDS INSTALLED (M) PROCEDURES COMPLIED WITH.SDR CALA2025070806327Slide · out of adjust1R DOOR INSIDE SLIDE MATERIAL SHOWING. RE-POSITIONED 1R DOOR GIRT BAR AND BUSTLE/COVER ASSEMBLY REF AMM TASK 25-66-01-200-802. EXCESS SLIDE MATERIAL NO LONGER SHOWING OUTSIDE OF THE BUSTLE/COVER ASSEMBLY.SDR CALA2025070806326Cover · detachedPLASTIC COVER ON 21A EMERGENCY EXIT HANDLE CAME OFF AGAIN. REATTATCHED PLASTIC COVER ON 21A EMERGENCY EXIT HANDLE (COVER IS MEANT TO DETATCH). COULD NOT FIND ANY ISSUE AT THIS TIME.SDR CALA2025070806325Girt Bar · no discrepancyDOOR 1L FA HAS ISSUE W/ GIRT BAR. CREW CONCERN WITH RELEASE MECHANISM EXPOSED SLIGHTLY AS OPPOSED TO DOOR 1R. SLIDE SKIRT MATERIAL EXTENDS NORMALLY ABOUT A QUARTER INCH. OVER MECHANISM.SDR CALA2025070806316Connector · looseFLOOR PROXIMITY EMERGENCY ESCAPE PATH LIGHTING ON SEATS AT ROWS 24ABC-30ABC INOP. FOUND LOOSE CONNECTION AT WIRES IN SEAT TRACK. TIGHTENED CONNECTION. OPS CHECK GOOD AT THIS TIME.SDR CALA2025070806311Sensor · false indicationLAV E VACC WASTE GUAGE READS EMPTY, WHICH ISNT TRUE. ALSO SMELLS LIKE SEWAGE. VERIFIED WITH LAV SERVICES THAT TANK IS EMPTY AND HAS NO LEAKS TOILET OPS CHECK NORMAL, OK TO TOMC APPROVED COMPLIED WITH MEL PLACARD APPLIED. OK TO CONT. INSPECTED AFTER FLIGHT GUASDR CALA2025070806310Unknown · odorFA REPORTED FUEL SMELL IN CABIN UPON ARRIVAL AT GATE PERFORMED INSPECTION, CHECK OF AIRCRAFT EXTERIOR WITH NO EVIDENCE OF FUEL LEAKS. RAN APU, BLEED AND PACKS WITH NO ODORS. F/A'S REPORTED ODOR DISIPATED UPON GATE ARRIVAL. AMM REF 05-51-10-200-801-C-1. ACFT OKSDR DALA2025070805072Cooling Fan · leakingSHIP 3273 DISC: DURING PREFLIGHT, STARTED APU AND TURNED ON APU BLEED. NOTICEABLE DIRTY SOCK SMELL ON A/C. C/A: FOUND & REPLACED LEAKING APU COOLING FAN ON LOG#1063584. (LP: 7023078)SDR DXTA2025070804140Pressure Switch · faultedCOMING THROUGH 16,000 FEET ON OUR ARRIVAL THE EAGLE WE HAD WHAT APPEARED TO BE AN RAPID DECOMPRESSION. WE HAD A LOUD BANG, FOLLOWED BY CABIN ALTITUDE LIGHT. PASSENGER OXYGEN MASKS AUTO DEPLOYED, AND WERE USED BY PASSENGERS. CREW MASKS WERE USED AS WELL. OXYGSDR I5PA2025070575701Skin · corrodedMAJOR REPAIR: LEVEL 2 CORROSION FOUND AT BSTA 680-700 BETWEEN STRINGERS 26R/28R. REPAIRED CORROSION PER EO APA-0043-001 REV 1 DTD 28JUN2025 AND PER SRM 53-00-01 REPAIR 28.SDR SWAA2025070788684Fuel Filter · faultedFLYING APPROACH INTO SJC AND AT APPROX 2500 FT AUTOPILOT KICKED. OFF #2 ENG ROLLBACK WITH ENG FAIL INDICATION. NORMAL APPROACH AND NORMAL LANDING APPROX WT 1222 BRAKE COOLING WAS WITHIN LIMITS<[01] PERFORMED BORESCOPE INSPECTION OF THE HPC AND HPT ON TTG8Q013KSDR SWAA2025070788513Circuit Breaker · trippedCIRCUIT BREAKER P18-3 B10 FOUND POPPED ON PREFLIGHT LIGHTING EMERGENCY CHGR<[01] PERFORMED FILM 33-50 TASK 801 RESET C/B & EMERGENCY LIGHTS OPS CHECK OK @ THIS TIMESDR HALA20250707206Gasket · leakingATB - ATB DUE TO LOSS OF ENGINE 2 OIL. ADC MESSAGE CAME ON AT 4 QTS. OIL GOT DOWN TO .9 ON APPROACH. FOUND OIL LEAKING FROM TWO HP/IP TURBINE VENT OVERHEAT THERMOCOUPLES. REMOVED AND REPLACED GASKETS PER SB RB.211-72-AE302. OIL FOUND LEAKING. CLEANED AREA, PERSDR DALA2025070705060None · noneSHIP 3417 DTE - 627184-14. CORRECTIVE ACTION: COMPLIED WITH INSPECTION PER ERA 627184-14. (1065181)SDR DALA2025070705052Bracket · damagedSHIP 3417 FRAME 62 AFT SIDE BETWEEN STRINGERS 1L AND 2L - EXTERNAL ANTENNA BRACKETS HAVE MULTIPLE TOOLING DAMAGE MARKS. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065555)SDR DALA2025070705051Bracket · damagedSHIP 3417 L-BRACKET P/N: F539-70571-006 (ITEM 6) REF. AIRBUS DWG. 17 F534 79820 SHEET 47 HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065378)SDR DALA2025070705050Bracket · damagedSHIP 3417 BRACKET ITEM 77, PN: F5349190421500, HAS MULTIPLE AREAS OF TOOLING DAMAGE AND OBLONG HOLES. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065365)SDR DALA2025070705049Bracket · damagedSHIP 3417 AFT SIDE OF FRAME 62 BRACKET BETWEEN STRINGER 1R AND 1L HAS TOOLING DAMAGE AND IMPROPERLY INSTALLED FASTENER. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065349)