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 SCNA20250707247Web · corrodedCORROSION ON TRUSS WEB ON STA 616 APROX AT LOWER SURFACE KEEL BEAM. TRUSS WEB ON STA 616 APROX AT LOWER SURFACE KEEL BEAM WAS REPAIRED PER ETI-737-25-079 REVISION 4 AND ENGINEERING TASK CARD ENG-53SCA-11692 AND MM4-SCA-25-0014SDR 5FGA2025070300159B-Nut · looseFOLLOWING A NORMAL LANDING AT KFOK. AIRCRAFT CLEARED THE RUNWAY AND BEGAN “AFTER LANDING” CHECKLIST. THE FO PLACED THE FLAP SELECTOR IN THE UP POSITION AND BEGAN HIS FLOW TO COMPLETE THE ITEMS. AFTER A FEW SECONDS CREW HEARD THE MESSAGE CHIME AND GOT AN AMBER SDR TLLA205070200139Engine · making metal#1 ENGINE CHIP LIGHT ILLUMINATED DURING FLIGHT. PILOT LANDED AT FIRST SAFEST SPOT AT SOUTHWEST WYOMING REGIONAL AIRPORT WITH NO INCIDENT. GROUNDED AC. SENT MECHANIC OUT AND FOUND CHIPS ON UPPER MAG. PLUG ON GEARBOXSDR AALA202507021874Tee Angle · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT ECS BAY "T" ANGLE CRACKED AT STA 650 AFT OUTBOARD CORNER OF ECS DOOR 192CL SURROUND STRUCTURE. REMOVED AND REPLACED "T" ANGLE. PER SRM 51-10-02, SRM 51-40-02, AND IPC53-42-00.SDR AALA202507022029Plate · brokenAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 832 GIRT BAR FITTING BLANKING PLATE BROKEN. REPLACED BLANKING PLATE PER TASK CARD 26C26053014.SDR AALA202507019558O-Ring · misriggedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBING, THERE WAS A LARGE POP FROM THE FRONT SERVICE DOOR. AT THAT POINT, THERE WAS A LARGE NOISE FROM THE DOOR, AND A PIECE OF THE HANDLE WAS VISIBLE FROM THE WINDOW. PRESSURIZATION WAS HOLDINGSDR AALA202507013977Spring · out of rigAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBING, THERE WAS A LARGE POP FROM THE FRONT SERVICE DOOR. AT THAT POINT, THERE WAS A LARGE NOISE FROM THE DOOR, AND A PIECE OF THE HANDLE WAS VISIBLE FROM THE WINDOW. PRESSURIZATION WAS HOLDINGSDR AALA202507014784Door · out of rigAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBING, THERE WAS A LARGE POP FROM THE FRONT SERVICE DOOR. AT THAT POINT, THERE WAS A LARGE NOISE FROM THE DOOR, AND A PIECE OF THE HANDLE WAS VISIBLE FROM THE WINDOW. PRESSURIZATION WAS HOLDINGSDR DALA2025070104903Slide · no discrepancyLH OWEED SLIDE REQUIRES DEPLOYMENT REF AMDS 2561-9101. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0402:2561-9101/001 00003 DEPLOYED SLIDE PER AMDS 2561-9005 STEP 1-4. SLIDE INSTALL WILL BE COMPLETED ON THE REMAINDSDR DALA2025070104895Slide · no discrepancyRH OWEED SLIDE REQUIRES DEPLOYMENT REF AMDS 2561-9101. DEPLOYED SLIDE PER AMDS 2561-9006 STEP 1-4. SLIDE INSTALL WILL BE COMPLETED ON THE REMAINDER OF AMDS 2561-9006. (LP# 1047913)SDR DALA2025070104892Attach Bracket · corrodedAFT FUSELAGE GALLEY FLOOR SUPPORT BEAM GALLEY ATTACH BRACKET AT FR79 AND RBL23 HAS CORROSION ON UPPER SURFACE AND OXIDATION IN BORE. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0583:5300-2016/003 00359 CORROSION COSDR JIKA2025070101Motor · shortedTHE FLIGHT CREW REPORTED THAT WHEN THE LANDING GEAR HANDLE WAS SELECTED TO THE DOWN POSITION THE LANDING GEAR RELAY CIRCUIT BREAKER POPPED OPEN AND WOULD NOT RESET. A MANUAL GEAR EXTENSION WAS PERFORMED IN ACCORDANCE WITH EMERGENCY PROCEDURES AND THE AIRCRAFT SDR AALA202507013227Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FRAME 35 RH SIDE IN OPEN FASTENER HOLE LOWER AFT AT STGR 30 LEVEL.CRACK DIRECTION IS 5 OCLOCK, CRACK DEPTH IS 0.105 INC H, IN FWD CARGO COMPARTMENT. MAINTENANCE PERFORMED TIME LIMITED REPAIR HOLE #2 AT CENTER FSDR CALA2025070106106Crease Beam · corrodedAFT WET AREA RH DOOR CREASE BEAM HAS MULTIOPLE SPOTS OF CORROSION. REMOVED CORROSION ORG THICKNESS .180 REMOVED .105 REMAINING .075 AND FOUND TO BE OUT OF LIMITS PER EC/RA 5321-01330 REV A AND SRM 53-70-15-1A-1. REMOVED CREASE BEAM PER B737-800 SRM 51-40-02. SDR CALA2025070106105Floor Support · corrodedMAIN CABIN STA 946 RBL 50 SUPPORT HAS CORROSION, WITH 100% MATERIAL LOSS ON UPPER SURFACE. REMOVED AND REPLACED INTERCOSTAL AT ST STA.949 - STA 967 RBL50 PER B737-800 SRM 51-40-02 AND BAC DWG 147A5762SDR QXEA2025063000269Latch · dirtyFLIGHT 2012. FLIGHT DECK DOOR DIFFICULT TO OPEN.. REMOVED FROM SERVICE. CLEANED FLIGHT DECK DOOR LATCH, OPS CHECK GOOD. RETURNED TO SERVICE. NO PARTS REPLACED.SDR SWAA2025063086118Pump · low pressureSYSTEM B ENGINE DRIVEN HYDRAULIC PUMP LOW PRESSURE LIGHT ILLUMINATED DURING CLIMBOUT<[01] REMOVED AND REPLACED #2 ENGINE EDP PER AMM 29-11-11. REF TTG8Q013DU57 FOR PARTS TRANSACTION AND FINAL ACTION.NO FURTHER DEFECTS NOTED.SDR SWAA2025063085969Floor Panel · crackedFWD CARGO BIN HAS FWD CRACK ON FLOOR <[01]. OK TO CONTINUE AS PER MEL 25-16-01 SP1B AUTH NO 263657; [02] PERFORMED REPAIR ON FWD CARGO PIT AFT FLOOR PANEL 120CF PER SRM 53-00-53 SEE NON-ROUTINE TTG8Q013EBJT FOR CORRECTIVE ACTION AND TLD.SDR SWAA2025063085509Isolator · crackedFWD GALLEY SERVICE DOOR AFT SLIDE MOUNT ISOLATOR CRACKED <[01]. R&R FWD GALLEY SERVICE DOOR AFT SLIDE MOUNT ISOLATOR IAW SRM 51-40-02.; [02] C/W.SDR SWAA2025063085706Battery Pack · inoperativeEMERGENCY LIGHTS AT R1 DOOR INOP. <[01] R&R BATTERY PACK FOR R1 DOOR EMERGENCY LIGHTS PER AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2025063085513Seal · crackedRIGHT HORIZONTAL STABILIZER UPPER FORWARD SLIDER SEAL CRACKED. REMOVED AND REPLACED RIGHT HORIZONTAL STABILIZER UPPER SLIDER SEAL IAW AMM 53-31-31SDR SWAA2025063085472Seal · crackedHORIZONTAL STABILIZER R/H UPPER FWD SPAR SLIDING SEAL CRACKED.<[01] REMOVED R/H UPPER FWD SPAR SLIDING SEAL. IAW 53-31-31;[02] REINSTALLED R/H UPPER SPAR SLIDING SEAL. IAW AMM 53-31-31SDR SWAA2025063085471Seal · crackedHORIZONTAL STABILIZER L/H UPPER FWD SPAR SLIDING SEAL CRACKED.<[01] REMOVED AND REPLACED HORIZONTAL STABILIZER L/H UPPER FWD SPAR SLIDING SEAL IN ACCORDANCE WITH AMM 53-31-31. OPS CHECK GOOD.SDR SWAA2025063085533Panel · delaminatedPANEL 191FL DELAMINATED AT FWD UPPER EDGE. C/W EA 25-153-01706 REF TTG8Q013DJ06SDR SWAA2025063085654Handle · looseFWD ENTRY DOOR UPPER ASSIST HANDLE IS LOOSE. RE SECURED FWD ENTRY DOOR UPPER ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025063085948Handle · looseCUSTOMER WALK ITEM: L1 DOOR AFT AIRFRAME ASSIST HANDLE NEEDS SECURED. SECURED L1 DOOR AFT ASSIST HANDLE IAW B737-800 AMM 25-21-31-420-802.SDR SWAA2025063085583Handle · brokenAFT ENTRY DOOR ASSIST HANDLE BROKEN. INSTALLED NEW DOOR ASSIST HANDLE. REF AMM 52-13-31SDR SWAA2025063085971Battery Pack · inoperativeLEFT AFT OWE LIGHT AND 16ABC THRU 23ABC BULLNOSE EMERGENCY LIGHTS ARE ALL INOP<[01] REMOVED; REPLACED AND ACCOMPLISHED OPS CHECK FOR M1670 BATTERY PACK IAW AMM 33-51-06-960-805. TEST GOOD.SDR SWAA2025063085972Battery Pack · inoperativeRIGHT AFT OWE LIGHT AND 17DEF AND 21DEF BULLNOSE EMERGENCY LIGHTS ARE ALL INOP<[01] REMOVED; REPLACED AND ACCOMPLISHED OPS CHECK FOR M1671 BATTERY PACK IAW AMM 33-51-06-960-805. TEST GOOD.<BR><BR>ATAG: WN51030<BR>BN:617872;[02] AUDIT C/WSDR AALA202506303427Slide · low pressureAIRCRAFT WAS NOT GROUNDED: WHILE WORKING A-CHECK 024 JOB CARD 08C20025006 DVI EMERGANCY ESCAPE SLIDE AND PRESSURE BOTTLE, FOUND AFT RIGHT DOOR SLIDE INFLATION CYLINDER PRESSURE GAGE IN THE RED. REMOVE AND REPLACE R2 SLIDE.PER W/C 08L22125001.SDR DALA2025063004864Cover · detachedSHIP 676 EXIT SIGN IN EXIT ROW OVER WING FELL. SECURED EXIT SIGN COVER. (7498766)SDR DALA2025063004863Skin · corrodedSHIP 6807 DURING LCK, CORROSION WAS NOTED ON THE WING CENTER SECTION UPPER SKIN, STA 1000-1040. ER/A 626574-14AD SECT. I REPAIR WAS ACCOMPLISHED. CORRECTIVE ACTION: REF ERA 626574-14. (1048406)SDR DALA2025063004861Floorbeam · corrodedSHIP 6807 CORRIOSION FOUND AT STA 1000 L/H SIDE UNDER FLOOR BEAM. CORRECTIVE ACTION: REPAIRED CORROSION ON LTR TANK UPPER SKIN AT STA 1000 L/H UNDER STUB BEAM PER ER/A 626574-14. (1047165)SDR DALA2025063004852Brace · not reportedSHIP 9575 LH WING BRACE FITTING BEING REPLACED. CORRECTIVE ACTION: BRACE FITTING INSTALLED ON ERA622844-14AD (1047886)SDR DALA2025063004851Skin · corrodedSHIP 9572 CORROSION ON WING UPPER TRAILING EDGE SKIN APROX. BTW XRS=353 - XRS=383 AT LH WING. CORRECTIVE ACTION: CORROSION LEVEL 2. AREA ON WING UPPER TRAILING EDGE SKIN APROX. BTW XRS=353 - XRS=383 AT LH WING WAS REPAIRED PER ERA 626626-14 REV ORIGINAL (10478SDR GTIA2025063038971Unknown · odorFUME EVENT IN DESCENT STRONG DIRTY SOCK ODOR. PERSISTENT, DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. AFT CABIN/GALLEY(LAV). NO VISIBLE SMOKE/HAZE. MEDICAL ATTENTION REQUIRED, EMS.-PERFORMED INSPECTION OF FUMES EVENT IAW TSM 05-50-00-810-SDR AALA202506307815Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: AFT PASSENGER/CREW DOOR EMERGENCY CYLINDER ACCUMULATOR SHOW LOW PRESSURE. MAINTENANCE SERVICED AFT PASSENGER/CREW DOOR EMERGENCY CYLINDER ACCUMULATORS IAW AMM 52-10-00-614-001-ASDR AALA202506309170Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 4 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING 4 ON RHHORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202506303455Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 6 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACE HINGE ARM ENDFITTING 6 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202506300277Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: FWD PASSENGER/CREW DOOR EMERGENCY CYLINDER ACCUMULATOR SHOW LOW PRESSURE. MAINTENANCE SERVICED FWD PASSENGER/CREW DOOR EMERGENCY CYLINDER ACCUMULATORS IAW AMM 52-10-00-614-001-ASDR AALA202506303701Handle · bindingAIRCRAFT WAS NOT GROUNDED: 2L DOOR JAMMED UPON CLOSING. MAINTENANCE REPOSITIONED INTERNAL HANDLE IAW AMM 52-12-00.SDR AALA202506305723Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 1L DOOR SHOWS CHECK DOOR PRESSURE ERROR MESSAGE. MAINTENANCE SERVICED DOOR ASSIST BOTTLE IAW AMM 52-11-00.SDR IPXA2025063037463Smoke Warning · false activationAVIONICS SMOKE ECAM ON CLIMB OUT. NO SMOKE DETECTED. ECAM OCCURED TWO MORE TIMES ON DESCENT. NO SMOKE DETECTED THROUGHOUT THE FLIGHT TROUBLESHOT IAW A300 TSM 26-15-00 FIG. 102 SHEET 1. REMOVED AND REPLACED SMOKE DETECTORS 11WA AND 13WA IAW A300 AMM 26-15-1SDR DALA2025063004842Floor Support · corroded(LOG 1046337) CORROSION ON FLOOR SUPPORT STA 294 RBL14 AT CPAX. FLOOR SUPPORT STA 294 RBL14 AT CPAX WAS REPLACED AND INSTALLED PER B737-800 SRM 51-40-02-0G.SDR AALA202506303573Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION EXTERNAL SKIN LOC. BTW FR65/FR66 AND BTW STR31R/STR32R LOWER FUSELAGE. MAINTENANCE PERFORMED TIME LIMITED REPAIR LOC.BTW FR65 TO FR66 AND BTW STR31R TO STR32R. IAW EA 364966.SDR DXTA2025063004050Squat Switch · defectiveLANDING GEAR HANDLE: AFTER TAKE OFF SELECTED GEAR UP, HANDLE FROZEN IN DOWN POSITION. AMBER CAS, "GROUND DETECT FAULT". FOLLOWED QRH PROCEDURE AND RETURNED FOR NORMAL LANDING. CORRECTIVE ACTION; REPLACED NLG WOW SWITCH IAW CE 700 MM 32-60-10. OPS CHECK GOOD.SDR DXTA2025063004051Spring · defectiveMAIN ENTRY DOOR TENSIONER NEEDS A TIGHTENING ADJUSTMENT. WHEN OPENING, THE DOOR ALMOST FREE FALLS AND BOUNCES AT BOTTOM. ANY INITIAL MOMENTUM WHEN INITIALLY OPENING WILL HAVE THE DOOR SIGNIFICANTLY BOUNCE. REPLACED BOTH OF THE MED SPRINGS IAW AMM 52-10-50. OPSDR DXTA2025063004055Control Valve · defectivePARKING BRAKE: PARKING BRAKE NOT ENGAGING WHEN SET. NO ILLUMINATION ON PARKING BRAKE INDICATOR ON DASH WHILE IN THE ENGAGED POSITION. REPLACED EMERGENCY/PARKING BRAKE VALVE IAW PHENOM 300 AMM 32-43-02. OPS CHECK GOOD.SDR DXTA2025063004058Battery Pack · no testFLOOR EMERG EXIT LIGHT: UNDER SEATS 5&8 AND SEAT 7- OVERHEAD EMER LIGHTS INOP WHEN TESTED. FULLY ACCOMPLISHED ABNORMAL CHECKLIST, 2 ATTEMPTS, TO RECHARGE BUT DID NOT WORK. CORRECTIVE ACTION; REPLACED ALL 4 EMERGENCY LIGHTING BATTERY PACKS IAW CE 680A AMM 33-50SDR DXTA2025063004060Warning Light · false activationDURING CLIMB OUT, THE GEAR WARNING HORN ACTIVATED WITH THE ASSOCIATED RED GEAR INDICATOR LIGHTS. THE GEAR INDICATION DID NOT EXTINGUISH. WE CYCLED THE GEAR AND THE GEAR INDICATION AND HORN EXTINGUISHED. CORRECTIVE ACTION; PERFORMED GEAR SWING OF THE LANDING