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 ASMF202508040001Shutoff Valve · faultyDUCT PRESSURE INDICATION LOW DURING TAKEOFF, CLIMB AND CRUISE, ENGINE IS THE BLEED SOURCE. FRM 361 040 00SDR CALA2025080407231Floorbeam · corrodedMAIN CABIN FWD WET AREA CORROSION AT FLOOR BEAM FASTENER HOLES STA 328 BETWEEN RBL 21"-50". INSTALLED STRAP ON FWD MAIN CABIN WET AREA STA 328 FLOOR BEAM WITH BMS 5-95 SEALEANT, SEALANT WAS MIXED AT 11: 30 A.M , SQUEEZE OUT TIME WAS AT 11:33 A.M, CURE TIME ISDR DALA2025080105793Oil System · leakingDIRTY SOCK SMELL IN CABIN/COCKPIT. NO EXTERNAL OIL LEAKS FOUND. SUSPECT INTERNAL OIL LEAK. MEL/PLACARD 49-10-01A.SDR DALA2025080205799Fan · odorSMOKE & FUMES, THE CREW REPORTED ELECTRICAL SMELL IN THE CABIN DURING PUSHBACK AND START OF NR 2 ENGINE. MAINTENANCE REPLACED GASPER BOOSTER FAN.SDR DALA2025080205796Fuel Cell · corrodedCORROSION ON CENTER FUEL TANK UPPER SKIN AFT FLANGE STA 747 X=-55 TO X=-59. REPAIRED PER PRI 626998-14.SDR DALA2025080205795Skin · ground damageGSE TOW TRUCK CAME IN CONTACT OF LH, OUTBOARD UNDER WING. C/W ER/A 628016-14.SDR SWAA2025080195924Acm · frozenAFTER ROTATION ON A BLEED OFF T/O WE RETURNED THE PACKS TO NORMAL AND IMMEDIATELY SMELLED A BURNING, HEARD A LOUD HUMMING AND THE FLT DECK TEMP WENT FULL HOT. FOUND LEFT ACM FROZEN (LOCKED UP). REMOVED AND REPLACED LEFT ACM REF AMM 21-51-04; NEEDS OPS AND SDR SWAA2025080195839Screw · missingFWD AND AFT MEGAPHONES ARE MISSING SET SCREWS. R&R FWD AND AFT MEGAPHONES PER AMM 25-64-00. OPS CHECKS GOOD.SDR SWAA2025080197127Screw · missingFWD AND AFT MEGAPHONES ARE MISSING SET SCREWS. R&R FWD AND AFT MEGAPHONES PER AMM 25-64-00. OPS CHECKS GOOD.SDR SWAA2025080195942Flashlight · no testCAPT SIDE AFT GALLEY EMERGENCY FLASHLIGHT DOES NOT TEST. CAPT SIDE AFT GALLEY EMERGENCY FLASHLIGHT DOES NOT TEST. REMOVED AND REPLACED AFT CAPTS SIDE RT FLASHLIGHT; IAW AMM 25-64-00.SDR SWAA2025080196015Slide · looseFWD SERVICE DOOR SLIDE SCREW CAME LOOSE. SECURED LOOSE SCREW IAW MT 725-61-06. SECURED LOOSE SCREW IAW MT 725-61-06 AND SIP.SDR SWAA2025080196013Slide · dislodgedFORWARD ENTRY DOOR EMERGENGY EXIT SLIDE FELL OUT DURING OPENING OF DOOR. REINSTALLED FWD ENTRY SLIDE PER AMM 25-66-06.SDR SWAA2025080196261Sensor · faultedAPU OVERSPEED FAULT CODE 49-31014. OK TO CONT PER MEL 49-11-01. R & R APU SPEED SENSOR REF AMM 49-61-21.SDR AALA202508011995Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: OUT OF LIMITS HOLES (9.60MM) IN FORWARD-FITTINGASSEMBLY ON RH MLG DOOR. PERFORMED PERMANENT REPAIR IN HOLE COMMON TOFORWARD-FITTING ASSEMBLY AND REPLACED HINGE FITTING ON RH MLG DOOR IAWA319 SRM 52-81-14-300-140. HFEC INSPECTISDR DALA2025080105773Shear Tie · corrodedFWD CARGO COMPARTMENT FOUND 01EA SHEAR TIE CORROSION AT STA742,BETWEEN S-33R AND S-34R. DAMAGED AREA REPAIRED PER B767-400 SRM 51-40-02.SDR DALA2025080105772Shear Tie · corrodedBULK CARGO COMPARTMENT FOUND 01EA SHEAR TIE CORROSION AT STA1540,BETWEEN S-38L AND S-39L. DAMAGED AREA REPAIRED PER SRM 53-00-07.SDR ASMF20250801204Warning Light · false activationRETURN TO BLOCK DUE TO ENGINE CONTROL LIGHT ON FOR ENG 2. IAW IFIM 73-21-00-810-826 PERFORMED TEST TO REC. MESSAGE UNCATCHED AND ERASED , MAINT LIGHT EXTINGUISHED.SDR R61A2025072800328Heater · failedWINDSHIELD HEATER 2 FAIL, WINDSHIELD SHATTERED APPROXIMATELY AT FL200. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED FO WINDSHIELD.SDR CALA2025080107183Bottle · faultedCIDS CAUTION LIGHT. DEFERRED PER MEL, VERFIED LT EMERGENCY BOTTLE PRESSURE, NEEDLE IS EXACTLY ON THE BORDER BETWEEN GREEN AND RED, REF TSM 25-62-00-810-805 IS OK. INSTALLED INOP STICKER ADJ TO PTP PANEL. DEFERRED PER MEL. REMOVED AND REPLACED LT OVERWING SSDR AALA202507317695Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT OUTSIDE AND AFT OF THE RIGHT AFT SERVICE DOOR WILL NOT ILLUMINATE. REMOVE AND REPLACED EXTERIOR LAMP OF R4 DOOR. PER AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA202507317184Hydraulic Line · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: REPEAT ITEM, AFTER TAKEOFF UPON RAISING OF GEAR ENGINE NUMBER ONE HYDRAULIC LOW PRESSURE AND ELECTRICAL 2 HYDRAULIC LOW PRESSURE LIGHTS ILLUMINATED. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IAD. REMOVESDR AALA202507312993Hydraulic Line · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: REPEAT ITEM, AFTER TAKEOFF UPON RAISING OF GEAR ENGINE NUMBER ONE HYDRAULIC LOW PRESSURE AND ELECTRICAL 2 HYDRAULIC LOW PRESSURE LIGHTS ILLUMINATED. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IAD. REMOVESDR AALA202507313572Module · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: REPEAT ITEM, AFTER TAKEOFF UPON RAISING OF GEAR ENGINE NUMBER ONE HYDRAULIC LOW PRESSURE AND ELECTRICAL 2 HYDRAULIC LOW PRESSURE LIGHTS ILLUMINATED. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IAD. REMOVESDR AALA202507315656Reservoir · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: REPEAT ITEM, AFTER TAKEOFF UPON RAISING OF GEAR ENGINE NUMBER ONE HYDRAULIC LOW PRESSURE AND ELECTRICAL 2 HYDRAULIC LOW PRESSURE LIGHTS ILLUMINATED. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IAD. REMOVSDR AALA202507310354Transfer Valve · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: REPEAT ITEM, AFTER TAKEOFF UPON RAISING OF GEAR ENGINE NUMBER ONE HYDRAULIC LOW PRESSURE AND ELECTRICAL 2 HYDRAULIC LOW PRESSURE LIGHTS ILLUMINATED. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IAD. REMOVSDR JJBA20250731125Shear Tie · corrodedCF3, SHEAR CLIP AT FR 52 BTW STR 21L-21R FOUND CORRODED. CF3, SHEAR CLIP ON FR52 BTW STR 21L-21R BOTH SHEAR CLIPS BLENDED AND FOUND OUT OF LIMIT. CF3, SHEAR CLIPS ON FR52 BTW STR 21-21R REMOVED AND INSTALLED.SDR SWAA2025073195923Strut · low pressureON TAKEOFF OUT OF DENVER THE NOSE WHEEL SHIMMIED EXCESSIVELY, POSSIBLE BLOWN TIRE SUSPECTED. INSPECTED NOSE WHEEL AND GEAR IAW AMM 32-51-00. CHANGED BOTH NOSE TIRES AND SERVICED NOSE GEAR STRUT. REF TTG8Q0148US8 AND TTG8Q0148VW1. NO OTHER DEFECTS NOTED.SDR GTIA2025073139024Unknown · odorDESCENDING THROUGH FL260 STATR TO SMELL ON ODOR IN FLIGHT DECK. POSSIBLE AQE EVENT. TURNED OFF PACK 1 ODOR WENT AWAY.-PERFORMED TROUBLSHOOTING OF THE CAUSE FOR CABIN ODOR, SMOKE OR FUME IAW TSM 05-50-00-810-831-A. PERFORMED PACK BURN OUT IAW AMM 21-00-00-615-8SDR CALA2025073107148Seal · unsecureCLIMBING THRU FL200, LOUD RUMBLING WITH STRONG VIBRATION IN COCKPIT FLOOR. PRESSURIZED ACFT IAW AMM 05-53-00-780-003-A, CHECKED L1 DOOR, NO LEAKS NOTED. UPON ARRIVAL AT LCQ FOUND L1 DOOR SEAL LOOSE FROM RETAINER, REMOVED SEAL AND REINSTALLED L1 DOOR SEAL SDR CALA2025073107141Seal · missingUPON REMOVAL OF PANEL 191DT FOUND BOTTOM SEAL MISSING, WILL BE REPLACING BOTTOM SEAL WHEN PANEL GETS REPLACED.SDR CALA2025073107129Web · corrodedCORROSION AT AFT CABIN WET AREA WEB PLATE BETWEEN BS 986.5 TO 1006 LBL 26 UPPER FLANGE. REMOVED AND REPLACED WEB PLATE LOCATED FROM STA 986.5 TO STA 1006 AND BETWEEN LBL24 TO LBL45,AFT WET AREA IAW SRM 51-10-02-0G-0, AND DRAWING 147A5701.SDR CALA2025073107120Exhaust Cone · crackedENG1 HAS GASH TEAR ON EXHAUST. LIGHT SMOKE OBSERVED FROM FRONT & BACK. OIL OR FUEL ODOR NOTICED. INSPECTED WELDED DOUBLER TO ENSURED NO ADDITIONAL DAMAGE PRESENT. TWO CRACKS MEASURING 2 & 4 INCHES. VERIFIED CRACK OUTSIDE OF WELDED DOUBLER IAW ECRA 7811-01SDR CALA2025073107112Fuse · blownEMERGENCY LIGHTS OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - L2 DOOR EXTERIOR EMERGENCY EGRESS LIGHT INOP. INTERIOR EMERGENCY EGRESS SEAT LIGHTS 22ABC-39ABC ARE INOP. OVERHEAD EMERGENCY EGRESS LIGHT INOP AT OVERHEAD BIN 31ABC. L2 DOOR EMER LT. ONE OSDR SWIA202507300028Windshield · smokeCAPT SIDE LOWER COVER FOR THE WINDSHIELD HEAT STARTED SMOKING WHITE SMOKE. WENT AWAY DURING CRUISE AND ARRIVAL (FLIGHT 3897) REFERENCE CP 30571493 FOR CAPT SIDE WINDSHIELD REPLACEMENT.SDR YENA2025073000781Unknown · odorFLT#1785, BOS-PIT. STRONG CHEMICAL SMELL DEPARTING BOS FROM TO TO ABOUT 5000'SMELL WAS NOTICEABLE ON THE FLIGHT DECK AS WELL AS THE REAR OF THE CABIN. FORWARD FA'S DID NOT SMELL ANYTHING UNUSUAL; PERFORMED FAULT ISOLATION PROCEDURE IAW FIM21-22-00.NO ODOR PRESSDR CALA2025073007094Unknown · odorSTRONG SMELL OF ELECTRIC BURNING FUMES AFTER LANDING/APU ON BUSS AND BLEEDS . PERFORMED T/S AS PER FIM 21-00 TASK 830, NO FAULTS, C/W ENG RUNS ALSO NO FAULTS, SUSPECT THEY IN TOOK SOME BAD AIR WHEN ON THE GRD IN PUJ.SDR CALA2025073007090Handle · improper stowAFT ENTRY DOOR LIGHT ILLUMINATED ON DESCENT AT 3000MSL UPON INITIAL EVALUATION FOUND AFT ENTRY DOOR HANDLE NOT ALL THE WAY DOWN. CYCLED HANDLE FROM THE INSIDE AND THEN CYCLED HANDLE FROM THE OUTSIDE. THE DOOR HANDLE AND DOOR ENTRY LIGHT OPS TESTED GOOD. PESDR CALA2025073007089Rope · out of positionDOOR 1R SLIDE ARMED LIGHT WILL NOT ILLUMINATE WHILE ARMING DOOR. REMOVED SLIDE COVER TO VIEW, GIRT BAR.FOUND FORWARD GIRT BAR SLIDER INCHES AWAY FROM ENGAGEMENT AND TANGLED WITH ROPING FROM SLIDE. INSERTED SAFETY PIN AS REQUIRED FOUND ONE SIDE OF GIRT BAR USDR CALA2025073007088Bottle · low pressureCREW REPORTS - DOOR L2 SIDE PRESSUE IN RED ZONE. FOUND PRESSURE TO BE LOW PER AMM 25-62-00. REMOVED SLIDE IAW AMM 25-62-44-000-002-A AND EC/RA 2562-01143, INSTALLED SLIDE IAW AMM 25-62-44-400-006-A AND EC/RA 2562-01142. PERFORMED RII INSPECTION OF DOOR 2L ESDR CALA2025073007087Bottle · low pressure2L SLIDE PRESSURE IN THE RED GAS CYLINDER GAUGE CHECK REFERENCE: TASK 25-66-99-702-001. (D) IN SERVICE, OBSERVE THE RELATIVE POSITION OF THE NEEDLE TO THE BACKGROUND COLOR. IF THE YELLOW NEEDLE IS OVER GREEN OR ABOVE GREEN, THE BOTTLE IS STILL PROPERLY CHARGEDSDR CALA2025073007086Slide · no discrepancyFLIGHT ATT SAYS SLIDE AT DOOR 1L LOOKS NON NORMAL IN REF TO FLIGHT CREW; SLIDE AT 1L LOOKS VERY NORMAL GOOD TO CONTINUE, REF AMM 25-66-01SDR CALA2025073007085Flap · unsecureL2 DOOR GIRT BAR FLAP HANGS LOW. FA CONCERNED IT MAY DRAG AND CATCH ON EDGE WHEN DOOR OPENED L2 GIRT BAR COVER FLAP ADJUSTED REF AMM 25-66-01-400-803SDR AALA202507301449Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR ACCUMULATOR NEEDS SERVECING. MAINTENANCE SERVICED R2 DOOR ACCUMULATOR IAW AMM 52-10-00.SDR AALA202507306358Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR ACCUMULATOR NEEDS SERVICING. MAINTENANCE SERVICED R1 DOOR ACCUMULATOR IAW AMM 52-10-00.SDR AALA202507307377Bulb · missingAIRCRAFT WAS NOT GROUNDED: OVERWING EXIT LIGHT HANDLE LIGHT BULB MISSING. MAINTENANCE INSTALLED LIGHT BULB OVERWING EXIT LIGHT HANDLE IAW AMM 33-50-00.SDR AALA202507304067Elt · no testAIRCRAFT WAS NOT GROUNDED: FWD ELT SHOWS BATT MEMORY FAULT ON SELF TEST. MAINTENANCE REPLACED AND REGISTERED ELT IAW J/C 99L20025003.SDR AALA202507304356Power Supply · no testAIRCRAFT WAS NOT GROUNDED: PERFORMED EMERGENCY LIGHT TEST ON PTP PANEL 110 RH AND RECEIVEDNMESSAGE ATA 33-51-38 EPSU BATTERY AFT L. MAINTENANCE REPLACED AFT EPSU BATTERY IAW AMM 33-51-38.SDR JJBA20250730109Angle · crackedRH WING TO BODY FAIRING, ANGLE #3 FOUND CRACKED. RH WING TO BODY FAIRING, ANGLE #3 REPLACED.SDR DXTA2025073004395Door Seal · leakingDURING CLIMBOUT PRESSURIZATION, THERE IS A NOTICABLE MAIN DOOR SQUEAL LEADING TO A THUNK NEAR 12000 FEET. DURING DESCENT AND DEPRESSURIZATION THERE IS A THUNK AND THEN A NOTICABLE DOOR SQUEAL BEGINNING SOMEWHERE BELOW 10000 FEET. CLEANED AND INSPECTED MAIN DOOSDR DALA2025072905707Tachometer · failedRTO AT 70KTS DUE TO A BRAKES RELEASED ECAM MESSAGE WITH A TACH 1 FAILURE MESSAGE. FAILED TACH 1 SPIN-UP TEST. BRAKE COOLING FAN ALSO HAD THE SHROUD, IMPELLER, GUARD, & FAN SUPPORT LOOSE. REPLACED BSCU, TACH GENERATOR 1 AND FAN ASSEMBLY.