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 SWAA2025111130181Attach Angle · crackedBS 663 RT VAPOR BARRIER UPPER ATTACH ANGLE AT RBL 13 COMMON TO FUEL TANK SHOWS A CRACK INDICATION.SDR CALA2025111011088Web · corrodedFWD CARGO BAY MAIN SILL WEB HAS CORROSION AND SCRATCHES. REMOVED AND REPLACED DAMAGE MAIN SILL WEB BS 440 - 492.4 IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, 51-40-08-0G-0, .AMM 51-21-41-370-802, AMM 51-21-72-370-804, AND DWG 143A8122, REV D.SDR ASMF2025297Engine · warning lightNR 2 ENGINE, ABORTED ENGINE START DUE TO MAINT LIGHT. PERFORMED IFIM TASK G73-20-00-810-862.SDR SWAA2025110730174Battery Pack · inoperativeALL EMERGENCY LIGHTS RELATED TO BATTERY PACK M1675 WERE INOPERATIVE. R & R THE BATTERY PACK M1675 AND PERFORMED GOOD OPS TEST IAW AMM 33-51-06-960-805.SDR WX0A2025110732628Unknown · odor(AIRCRAFT NOT GROUNDED) MUSTY DIRTY SOCK SMELL-DURING CLIMB OUT JUST AFTER STERILE COCKPIT SIGNAL (10,000FT) FA 1 CALLED AND REPORTED MUSTY DIRTY SOCK SMELL IN AFT GALLEY AREA.SMELL INITALLY WAS MODRATLY STRONG DISIPATING TO ZERO SMELL WITH IN 10-15 MINUTES / SDR DALA2025110708133Skin · delaminatedSHIP 6813 BOTTOM OF LEFT WING LEADING EDGE JUST BEHIND SLAT DELAMINATED/ MISSING COMPOSITE. CORRECTIVE ACTION: C/W ER/A 630248-14 REV. -ORG- SEC 1 TIME LIMITED REPAIR. CLEAN, REMOVED DAMAGE AREA AND REPARE DAMAGE AREA, USING MATERIAL ID BMX8-79-3-120 PREP ROC.SDR COEA2025110616759Link · corrodedWO 271980 NR 5 MINOR REPAIR/DISCREPANCY: RT ENGINE AFT DOOR LINK ASSY FRETTED AROUND CHAMBERED AREA. REPLACED RT AFT INERTIAL SEPERATOR DOOR LINK ASSY REF IPC 30-20-05 FIG 1-5.SDR COEA2025110615759Link · corrodedWO 271980 NR 3 MINOR REPAIR/DISCREPANCY: LT ENGINE AFT DOOR LINK ASSY FRETTED AROUND CHAMBERED AREA. CORRECTIVE ACTION: REPLACED L/H AFT INERTIAL SEPERATOR DOOR LINK ASSY. REF IPC 30-20-05 FIG 1-5.SDR COEA2025110614759Link · crackedWO 271980 NR 2 MINOR REPAIR/DISCREPANCY: R/H ENGINE FWD DOOR LINK ASSY IS CRACKED. REPLACED FWD INERTIAL SEPERATOR DOOR LINK ASSY REF C408 IPC 30-20-05 FIG 1-5.SDR SWAA2025110630856Stringer · corrodedPAINT BUBBLING ON FUSELAGE AT BS 887, STRINGER L25 +3'. REPAIRED PER EA 25-153-02998.SDR SWAA2025110631289Tie Down · crackedFCD FWD TIEDOWN PLATE IS CRACKED. INSTALLED NEW FCD FWD TIEDOWN PLATE ASSY IAW AMM 20-50-11-201; AIPC 25-52-10-01; SRM 51-40-02 AND AMM 25-52-10-400-801.SDR CALA2025110610952Angle · crackedRIGHT AIR CONDITIONER BAY BS 663 UPPER ANGLE CRACKED AT INBD SIDE. REPAIRED THE ANGLE IAW ESR -WI 2-13046 AND EC/RA 5710-02944.SDR K11A2025103000358Window · crackedCRACKED L1 WINDOW IN FLIGHT. REMOVED AND REPLACED L1 WINDOW IAW AMM 56-11-11 REF AOG RO AOG4060253 AND KAIR WO 940600962.SDR QXEA2025110400338Fuel Tank · leakingFUEL LEAK UNDER RIGHT WING, OTBD OF ENGINE. REMOVED FROM SERVICE. TRANSFERED FUEL TO RT WING IAW AMM 28-20-00-910-801-A TO VERIFY FUEL LEAK. LEAK FOUND AND CONFIRMED OTBD OF RT ENGINE. TRANSFERED FUEL FROM RT WING TO LT WING IAW AMM 28-20-00-910-801-A FOR TANSDR AALA202511044780Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE DETECTOR INOPERATIVE AT NUMBER 4 LAVATORY AT DOOR 2. ACCOMPLISHED SMOKE DETECTOR OPERATIONAL TEST, NO FAULT FOUND. PER AMM 26-13-01.SDR DALA2025110408059Oxygen Mask · dislodgedOXYGEN MASKS PANEL FELL AT ROW 12DEF. DEFER O2 MASKS AT SEAT ROW 12DEF TO MEL 35-21-01A, M PROCEDURE C/W, INSTALLED PLACARD, A/C OK TO CONTINUE ON MEL. RE-SECURED PANEL DOOR OK FOR SVC PER A320 AMM 25-25. MEL CLEARED / PLACARD REMOVED M PROC REVERSED. (LP: 79SDR VNAA2025110411102Relief Valve · inoperativeGEAR DISAGREE WARNING IN FLIGHT. / REMOVED AND REPLACED MLG SELECTOR VALVE IAW CRJ 900 AMM 32-32-10-000/400-801. REMOVED AND REPLACED #3 BALANCE RELIEF VALVE IAW CRJ 900 AMM 29-12-05-000/400-802. LEAK CHECK AND OPS CHECK GOOD. THIS CLEARS MELSDR JJBA20251104006Shear Tie · crackedLH FR 71 BTW STR 17L-18L SHEAR CLIP FOUND CRACKED. CRACKED SHEAR CLIP AT LH FR 71 BTW STR 17L-18L REMOVED AND REPLACED.SDR ASAA2025103062030Lamp · inoperativeWHILE PERFORMING T.C. #7823001, A/C LH AFT EXTERIOR EMERGENCY EXIT LIGHT IS INOPERATIVE. GROUNDED - YES. RELAMPED AFT LT EXTERIRO EMERGENCY LIGHT IAW AMM 33-51-04-960-801. NEW LAMP CHECKS GOOD.SDR SWAA2025110329964Pan · buckledFUSELAGE TOILET SERVICE DOOR PAN, AFT LOWER CORNER IS BUCKLED. REMOVED FUSELAGE TOILET SERVICE DOOR PAN IAW SRM 51-40-02. AFTER REMOVAL OF FUSELAGE TOILET SERVICE DOOR PAN FOUND CORROSION ON THE MATING SKIN OF SERVICE DOOR PAN. REMOVED CORROSION IAW SRM 53-SDR SWAA2025110329972Light · inoperativeR/H EMERGENCY EXIT LIGHT LIGHT INOPERATIVE. R & R OVERWING EXIT LIGHT AND LENS IAW AMM 33-51-04.SDR SWAA2025110331270Light · inoperativeR/H EMERGENCY EXIT LIGHT LIGHT INOPERATIVE. R & R CABIN OVERWING EXIT LIGHT AND LENS IAW AMM 33-51-04.SDR SWAA2025110330438Light · unsecureF/A REPORTS 4 INCH TRIPPING HAZARD, THE PHOTO LUMINESCENT STRIP IS STICKING UP ABOUT 4 INCHES AND IS A POTENTIAL TRIPPING HAZARD. ATTACHED AS NECESSARY IAW AMM 33-51-400-899. FLOOR PROXIMITY LIGHT IAW AMM 33-51-15.SDR SWAA2025110330275Light · inoperativeINOPERATIVE EXTERNAL EMERGENCY LIGHT AFT SERVICE DOOR AT UPPER FUSELAGE. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-04-960-801, STEP 2.F. 1, 2, 3, A, B, D, 4. TESTED OK.SDR SWAA2025110330477Handle · looseFA REPORTED AFTER ENTRY DOOR HANDLE LOOSE. TORQUED AND SAFETIED AFT ENTRY DOOR INTERIOR HANDLE IAW AMM 52-13-00.SDR SWAA2025110330688Fire Warning · faultyCAPTAIN`S FIRE WARNING BELL CUTOUT DOES NOT SILENCE. RELAMPED CAPT SIDE FIRE WARNING CUTOUT PER SWPM 20-83-11.SDR YENA2025110301080Computer · failedFLT#1230, CUN-EWR. (AIRCRAFT DIVERTED TO TPA) "F/CTL ELAC 2 PITCH FAULT AIRCRAFT PITCHED DOWN UNCOMMANDED IN CRUISE FLIGHT. AUTOPILOT STAYED ON; PERFORMED INTEROGGATION OF FCDC SYS #2 IAW TSM 27-00-00-810-801-A. ACCORDING TO DFDR REPORTS, TECH SUPPORT IDENTIFISDR DALA2025110308034Skin · dentedA DENT IN THE AREA OF AN EXISTING REPAIR DOUBLER. THE DENT IS LOCATED AT STA 634, BETWEEN STRINGERS 17L AND 18L. REF ERA 630239-14 AND ERA 511579-14AD. (1279808)SDR DALA2025110308028Coaming · crackedNUMBER 1 PYLON CRACK ON INBOARD SIDE OF PYLON COMING FROM AFT UPPER CORNER OF PYLON ACCESS PANEL 416BR. CORRECTIVE ACTION: REPAIRED PER ER/A 628915-14. (1279528)SDR ABXA20251030285Smoke Detector · defectiveDURIING MAINT. PRE-FLIGHT, MAIN CARGO FIRE TEST PNL, A2 AMBER LED LIGHT DID NOT RESET. DEFERRED IAW MEL 26-16-2-2 MBCB 11-09-25. REMOVED AND REPLACED A2 SMOKE DETECTOR IAW B767 IAI SUPPLEMENTAL AMM 26-14-01. OPS CHECK GOOD. DI CLEARED. A/C REMAINS NO ETOPSSDR GTIA2025110339163Unknown · odorDURING DESCENT BELOW 10000FT FAS REPORTED A STRONG DIRTY SOCK SMELL. DESCRIPTION OF ODOR/FUMES: CONTINOUS AND DISCOMFORTABLE, DIRTY SOCKS/ ACRID/ PUNGENT/ IRRITATING/ BURNING EYE SMELL. SOURCE: CABIN AIR SUPPLY VENTS. FWD CABIN AND MID CABIN. NO VISIBLE SMOKESDR GTIA2025110339162Unknown · odorFWD FA REPORT AIR QUALITY EVENT. DESCRIPTION OF ODOR/FUMES: PERSISTENT, DIRTY SOCKS/ OTHER SMELL DURING DESCENT. FWD CABIN. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-PER TSM 05-50-00-810-831A DECONTAMINATION PROCEDURE OF ECS LEVAL A IAW AMM 21-00-0SDR GTI2025F00009Unknown · odorDURING DESCENT BELOW 10000FT FAS REPORTED A STRONG DIRTY SOCK SMELL. DESCRIPTION OF ODOR/FUMES: CONTINOUS AND DISCOMFORTABLE, DIRTY SOCKS/ ACRID/ PUNGENT/ IRRITATING/ BURNING EYE SMELL. SOURCE: CABIN AIR SUPPLY VENTS. FWD CABIN AND MID CABIN. NO VISIBLE SMOKESDR CALA2025110310848Collar · brokenL1 & R1 DOORS GIRT BAR COLLARS BROKEN. REPLACED PLASTIC COLLAR FOR L1 GIRT BAR. NO DEFECTS NOTED FOR R1 GIRT BAR REF AMM 25-62-44. A/C OKAY FOR SERVICESDR CALA2025110310841Battery Pack · no testOVERWING EMERGENCY SEAT LIGHTS INOP. EMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. REMOVED AND REPLACED EMERGENCY BATTERY PACK AT ROW 20A OPS CHECK GOOD REF 33-51-06.SDR CALA2025110310840Light · inoperativeEPSU BATTERY AFT LIGHT MESSAGE POPULATED WHEN PERFORMING EMERGENCY LIGHT TEST VIA PTP. NO SYS OK. REMOVED AND REPLACED EPSU BATTERY AFT LIGHT PER PTP IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A . PERFORMED OPS CHECK OF THE EMERGENCY POWER SUPPLY UNITS,SDR CALA2025110310835Limiter · brokenHYD SYS B FAILURE, T/S SYSTEM B FAILURE. FOUND TRAILING EDGE FLAP FLOW LIMITER BROKEN. REMOVED AND REPLACED TRAILING EDGE FLAP FLOW LIMITER REF MM 27-51-61-000-801. PERFORMED FLAP OPERATIONAL TEST, TEST PASSED. SERVICED SYSTEM B HYD. TO FULL. OPS AND LEAKCHESDR CALA2025110310833Unknown · odorPLANE SMELLS LIKE A URINAL AND CHEMICALS AFT OF ROW 30 TO THE PO INT THAT EYES ARE BURNING UNIFI PERFORMED DEEP CLEANING ON THE CARPET AND AFT GALLEY.SDR CALA2025110310832Engine · no discrepancySUSPECTED BIRDSTRIKE DURING CLMB AROUND 800 FT. SMALL BIRD LEFT ENGINE. BRIEF ODOR, ON CLIMB NOTICED SMALL BIRD PASS ON LT SIDE OF ACFT, A BURNT ODOR WAS NOTICED BY CA/FO WHICH WAS ALSO REPORTED BY FA, NO ADVERSE ENGINE PARAMETERS NOTICED. PERFORMED BIRD STRSDR CALA2025110210803Floor Support · corrodedFOUND CORROSION AT AFT WET AREA FLOOR SUPPORT LBL 50 BS 947.5. REMOVED AND REINSTALLED NEW FLOOR SUPPORT FROM BS 947.5 - 967 IAW SRM 51-40-02-0G-0 AND DWG 147A5650.SDR CALA2025110210801Battery Pack · no testCABIN L2 DOOR EXIT LIGHT AND EMERGENCY LIGHT INOPERATIVE. REPLACED THE CABIN L2 DOOR AREA M33096 EMERGENCY BATTERY PACK AND CARRIED OUT INSTALLATION TEST FOUND TEST NORMAL.SDR AALA202510318811Heat Shrink · missingAIRCRAFT WAS NOT GROUNDED: R2 DOOR GIRT BAR RED HEAT SHRINK MISSING ON ONE SIDE. INSTALLED RED HEATSHRINK ON R2 DOOR GIRT BAR.SDR AALA202510316294Switch · inoperativeAIRCRAFT WAS GROUNDED: GEAR DOORS WILL NOT OPEN USING GROUND OPERATION ARM AND OPEN SWITCHES. "ALT GEAR EXTEND" STATUS MESSAGE ON EICAS. REMOVED AND REPLACED GROUND OPERATION ARM OPEN SWITCHES. PER AMM32-00-40-860-802. OPERATIONAL CHECKED GOOD.SDR AALA202510315548Fuel Filter · cloggedAIRCRAFT WAS NOT GROUNDED: LEFT FUEL FILTER BYPASS LIGHT CAME ON AFTER TAKEOFF. REMOVED AND REPLACED LEFT ENGINE FUEL FILTER. PER MM 73-11-02. OPERATIONAL AND LEAK CHECK GOOD.SDR AALA202510315994Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. INSPECTED LAVATORY-D BIFOLD DOOR, ADJUSTED LATCH, LUBED TRACKS, OPERATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202510310255Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR EXTREMELY DIFFICULT TO OPEN. PERFORMED LUBRICATION OF FLIGHT DECK DOOR ELECTRIC STRIKE. PER AMM 52-51-03. OPERATIONAL CHECK GOOD.SDR AALA202510311054Light · misinstalledAIRCRAFT IN BASE MAINTENANCE: CABIN M1 GALLEY RIGHT HAND EMERGENCY LIGHT FOUND NOT INSTALL PROPERLY. RESECURED LIGHT AND CHECKED FOUND NORMAL. PER AMM 33-51-05 REV 250.SDR AALA202510319363Door · looseAIRCRAFT WAS NOT GROUNDED: DOOR IS VERY DIFFICULT TO OPEN AND CLOSE IN LAVATORY-D IN REAR OF AIRCRAFT. FOUND TOP DOOR TRACK SCREWS LOOSE RESECURED AS REQUIRED.SDR AALA202510312883Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLIGHT ATTENDANTS IN THE AFT CABIN REPORTED A STRONG BURNING SMELL OF A BURNING ELECTRICAL CABLE JUST AFTER TAKEOFF. THIS WAS ALSO REPORTED BY PASSENGERS IN THE LAST 6 ROWS OF THE CABIN. AIRCRAFT AIR INTSDR DALA2025103107994Floor Panel · damagedAFT CARGO FLOOR PANEL 140AF HAS SUSPECTED OXIDATION. FABRICATED NEW AFT CARGO FLOOR PANEL AND APPLIED TREAT AND PRIME IAW B737- 900 SRM 53-00-53, 51-40-05-0G, 51-20-07-0G. (LP 1280378)