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 AALA202507250586Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507251565Battery · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 13WL DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 13WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507253997Structure · out of positionAIRCRAFT WAS NOT GROUNDED: R4 DOOR HAS A PIECE OF CHORD COMING OUT OF SEAL. MAINTENANCE REPOSITIONED ESCAPE SLIDE LACING CHORD PER AMM 25-62-44.SDR AALA202507252820Power Supply · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY 15WL DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 15WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507254135Lock · stickingAIRCRAFT WAS NOT GROUNDED: MID LAVATORY DOOR LOCK STICKS RESULTING IN PASSENGER NEEDING FLIGHT ATTENDANT ASSISTANCE TO UNLOCK THE DOOR. MAINTENANCE CLEANED AND LUBRICATED MID LAVATORY BI FOLD DOOR PER AMM 25-40-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISDR AALA202507251121Connector · damagedAIRCRAFT WAS NOT GROUNDED: DURING P/S CHECK FOUND SEAT 25 AND 24 EMERGENCY ALLEY LIGHTS OUT, MAINTENANCE FOUND WIRES DISCONNECTED FROM CONNECTOR AND REPINNED CONNECTOR IAW AMM 20-00-00.SDR CALA2025072506922Computer · faultedALL CAPTS AIR DATA AND ANTI ICE PROBES FAILED ON DEPARTURE PILOTS REP MULTI ANTI-ICE CAPT PROBE MSGS ON ECAM. SW'ED AIR DATA SW TO POS 3. MSGS STOPPED. FOUND "NO PHC 1 DATA" FAIL MSG ON PFR. SEE PHOTO. R&R PHC 1. INSTALL TEST GOOD. REF AMM 30-31-34-400-002-A &SDR CALA2025072506919Door · out of adjustFWD ENTRY LGT ILLUM AIRB ORNE. FLT ATT RESECURED HANDLE LGT EXTINGUISHED DEBRIEFED CREW THEY STATED THAT THEY HAD A PROBLEM CLOSING THE DOOR TO PUT THE WARNING LIGHT OUT DURING TAKE OFF ROLE THE DOOR HANDLE POPPED UP AND THE WARNING LIGHT CAME ON PERFORMED PSESDR CALA2025072506918Door · out of adjustFWD ENTRY DOOR WARNING LIGHT STAYS DIM WHEN DOOR IS CLOSED. REQUEST MEL FOR THE FWD ENTRY DOOR WARNING LIGHT SYSTEM. MEL 5203E REJECTED BY TOMC. CHECKED FWD ENTRY DOOR S199 SWITCH RIG THROUGH PSEU IAW AMM 52-71-11-820-801 AND FOUND SWITCH TO BE IN PROPER RIG.SDR CALA2025072506911Hose · damagedHYD C QUAN LOW HEAVY HYDRAULIC LEAK FOUND AT CENTER SYSTEM C1 ELEC PUMP PRESSURE FLEX HOSE B-NUT SWAGING AT THE PUMP HOUSING. REQUIRED PART IAW IPC 29-11-02-02 ITEM 150 P/N AS115-06D0130 OR AS115-06K0130 PLEASE SHIP THE DAMAGED REMOVED HYDRAULIC HOSE. ACMP CESDR CALA2025072506910Blade · damagedREF L/P 5642792, DUE TO BLADE DAMAGE ON #1 ENGINE, PLEASE COMPLETE FOD INGESTION INSPECTION PER AMM 72-00-00-210-807-N02 ACP'D INSPECTION OF #1 ENG DUE TO #7 FAN BLADE BEING FOUND BENT. REF AMM INLET, EXHAUST, AND EXTERNALS INSPECTION REFERENCE: TASK 72-00-00-SDR ASAA2025072259648Cover · missingFA REPORTS 16DEF ROW IS MISSING EXIT ROW SMALL PLASTIC COVER. GROUNDED - YES. REPLACED RT FWD EMERGENCY EXIT LIGHT COVER. OPS CK NRML. REF 33-51-01-960-801.SDR SWAA2025072493920Seat · out of adjustSEAT 11F RECLINES INTO EXIT ROW. ADJUSTED SEAT RECLINE LOCK IN REF TO AMM 25-22-00.SDR SWAA2025072493866Battery · inoperativeFWD CABIN EMERGENCY FLASHLIGHTS REQ NEW BATTERYS. REMOVED AND REPLACED THE BATTERIES IAW AMM 25-64-00-900-806-NG.SDR SWAA2025072493612Light · faultyAFT RH EMER EXIT SIDE WALL LIGHT WILL NOT TURN OFF WHEN SELECTED FROM ATTENDANT. LOADED SOFTWARE; OPS CHECK NORMAL AFT RH EMER EXIT SIDE WALL LIGHT. PER AMM 33-21-00.SDR SWAA2025072493890Sign · detachedEXIT PLACARD CAPT SIDE OVER WING KNEE-LEVEL SIGN FELL OFF. INSTALLED NEW LH SIDE OVERWING EXIT SIGN IAW AMM 33-51-01.SDR SWAA2025072494406Lens · missingOVERHEAD IN AISLE NEAR ROW 2; LED LIGHT COVER IS MISSING. INSTALLED MISSING LENS COVER PER AMM 33-51-01.SDR GTIA2025072439007Unknown · odorDURING DESCENT AROUND 10000 FT A SMELL WAS DETECTED THROUGHT THE A/C - FA'S DESCRIBER IT AS MELTED CRAYON-MORE PREVELANT IN THE REAR. TURNED PACK 1 OFF IN THE TIME WE HAD AND THE SMELLED DISSIPATED. DESCRIPTION OF ODOR/FUMES: PRESISTENT, UNFAMILIAR CHEMICAL SSDR GTIA2025072439006Oil System · leakingDIRTY SOCK SMELL ON DESCENT AND WITH APU RUNING. CONTINUOUS AND DISCOMFORTABLE, DIRTY SOCK / MUSTY DRY SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-REF. TSM 05-50-00-810-831-A PERFORMESDR DALA2025072405584Cylinder · faultedSHIP 9536-FCNT-THE CREW RECEIVED A SLAT DISAGREE MESSAGE ON APPROACH WITH ASSOCIATED ROLL. CORRECTIVE ACTION: MAINTENANCE REPLACED THE LEFT INBOARD SLAT DRIVE CYLINDER.(7345922)SDR DALA2025072405581Skin · corrodedSHIP 9572 IN REF NRC 00308, CORROSION ON CENTER WING UPPER SKIN BTW STA Y= 715/720 X = -60 AT WING BOX. CORRECTIVE ACTION: CORROSION ON CENTER WING UPPER SKIN BTW STA Y= 715/720 X = -60 AT WING BOX WAS REPAIRED PER ERA 626657- 14 AD REV ORIGINAL SECTION I: PERSDR AALA202507246550Computer · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: TACAS FAILED ON TAKEOFF AND CLIMB WOULD NOT RESET. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED TCAS COMPUTER. PER AMM 34-45-01. OPERATIONAL CHECK GOOD.SDR AALA202507247796Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LOCK IS DIFFICULT TO MOVE. LUBED LAVATORY-D DOOR LOCK. PER MM 25-40-00. OPERATIONAL CHECK NORMAL.SDR AALA202507241307Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR INOPERATIVE, HARD TO OPEN. (OPEN).SDR AALA202507241612Slide · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY AND FORWARD SERVICE DOOR GIRT BAR DIFFICULT TO OPERATE. FLIGHT ATTANDENT WORRIED ABOUT DEPLOYMENT OF SLIDES. ADJUSTED DOOR SLIDE. PER AMM 25-66-00.SDR AALA202507247603Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: DOOR LATCH FOR LAVATORY-D IS DIFFICULT TO OPERATE. LUBED LAVATORY DOOR. PER GPM 17-11-4. OPERATIONAL CHECKS GOOD.SDR AALA202507244672Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STUCK CLOSED. UNJAMMED DOOR. OPERATIONAL CHECK GOOD.SDR AALA202507246122Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FORWARD OUTBOARD FLIGHT ATTENDANTS FLASHLIGHT DID NOT TEST. REPLACED FLASHLIGHT. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR DALA2025072405565Starter Gen · failed(LOG 7394804) AT GATE APU GEN DROPPED OFFLINE ACCOMPANIED WITH AN ACRID ODOR/ BURNING SMELL IN COCKPIT + CABIN. REPLACED APU STARTER GEN REF B737 AMM 49-41.SDR DALA2025072405563Transition Panel · corroded(LOG 1099307) FWD CARGO RH TRANSITION PANEL BS 500C+10 - 500I. CORRODED MULTIPLE AREAS. REMOVED AND REPLACED FWD CARGO TRANSITION PANEL R/H SIDE BS 500C +10''-500I IAW B 737 SRM 51-40-02.SDR DALA2025072405561Window Frame · cracked(LOG 1099012) CRACK OF 0.150IN ON INNER CORNER RADIUS OF NO. 1 LH WINDOW FRAME. FRAME WAS REPAIRED PER ER/A 619132-14ADTR REV. A.SDR DALA2025072405560Window Frame · cracked(LOG 1098988) CRACK ON LH/RH NO.3 WINDOW FRAME FWD LOWER CORNER AT FWD FUSELAGE. CRACK ON LH NO.3 WINDOW FRAME FWD LOWER CORNER AT FWD FUSELAGE WAS REPAIRED PER ER/A 627247-14AD REV. ORIGINAL SECTION I PERMANENT REPAIR AND PRI 627247-14 REV. 4, AND RH NO.3 WINSDR DALA2025072405559Skin · damaged(LOG 1098837) WHILE THE AIRCRAFT WAS BEING TOWED, A LIFELINE CAUSED DAMAGE TO IT, TWO DENTS ON VERTICAL STABILIZER LEFT INSPAR SKIN, BETWEEN LE STA 196.66-205.86. VERTICAL STABILIZER LEFT INSPAR SKIN, BETWEEN LE STA 196.66-205.86 WAS REPAIRED PER B737-800 SRM SDR DALA2025072405558Window Frame · cracked(LOG 1098678) CRACK OF 0.220IN ON INNER CORNER RADIUS OF NO. 1 RH WINDOW FRAME. FRAME WAS REPAIRED PER ER/A 619132-14ADTR REV. A.SDR MASA2025072200059Battery · dischargedFO FLASHLIGHT BATTERIES DEAD - REMOVED AND REPLACED BATTERY - OPS CK GOODSDR CALA2025072406884Lavatory · no discrepancyFWD LAV WORKED ON GND PR IOR TO DEPT BUT STOPPED WORKING ONCE IN FLIGHT FWD LAVATORY IS NOT HOLDING WATER. FILLED FWD LAVATORY, AND BLUE WATER STARTS COMING FROM BELLY OF AIRCRAFT. FWD FLUSH MOTOR INOP, VERIFIED TANK AND CHUTE EMPTY. NO LEAKS. LAV UNUSABLE, PSDR CALA2025072406876Lamp · no testEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. 3B SEAT HAS ONE EMERGENCY LAMP INOP. REPLACED LIGHT ASSY, OPS CHECK GOOD. REF AMM 33-51-00-710-801.SDR CALA2025072406875Lamp · no testEMERGENCY LIGHTS OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK. DOOR 1R SLIDE LIGHT INOP. ACCOMPLISHED SLIDE LIGHT LAMP REPLACEMENT PER MM33-51-04-960-801. OPS CK OK.SDR CALA2025072406873Battery Pack · no testEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. EMERGENCY LIGHTS NOT WORKING LEFT SIDE ON OVERWING EXIT ROWS. REMOVED AND REPLACED M1694 POWER SUPPLY BATTERY PACK AS REQUIRED IAW AMM 33-51-06-960-805, OPS CHECKED GOOD.SDR CALA2025072406872Housing · detachedUNDER SEAT 15C EMERG EXIT LIGHT DETACHED AND HANGING DOWN ON FLOOR. INTERIM REPAIR IAW ECRA 3350-01526, REPLACED HOUSING ASSY, OPS CHECK GOOD.SDR CALA2025072406871Light · no testEMERGENCY LIGHTS OPS TEST WITH THE TEST SWITCH PROCEDURE. EMERGENCY LIGHT OUTSIDE OF DOOR 4R INOPERATIVE. RELAMPED, OPS GOOD IAW AMM 33-51-06-001-002. ONE SPACER MISSING AND GASKET DAMAGED IAW IPC 33-51-06-51. SPACERS AND GASKETS REPLACED IAW IPC 33-51-06SDR HALA20250723229Transducer · faultedETOPS - RT PYLON BLEED PRESSURE ERRATIC IN ALL BLEED CONFIGURATIONS WITH LT AT CONSTANT PRESSURE. REMOVED AND REPLACED REG PRESSURE TRANSDUCER (8HAZ) IAW AMM 36-11-16. OPS CHECK AND LEAK CHECK GOOD.SDR N6WA2025072301Bulb · inoperativeLH EXTERIOR EMERG. LIGHT INOP. R/R LH EXTERIOR EMERGENCY LIGHT INOP CRJ AMM 33-51-15SDR SWIA20250723002A/C Pack · warning messageWHILE ENROUTE FROM LNK TO DEN AT FLIGHT LEVEL 240,RECEIVED A LEFT PACK OVERPRESS CAUTION MESSAGE AND AIRCRAFT STARTED TO DEPRESSURIZE. PERFORMED EMERGENCY DECENT AND DIVERTED TO EAR. CABIN ALT WARNING AND CAUTION ILLUMINATED. MEL 21-51-1, CAT C. (FLT 4648) SDR DALA2025072305546Bolt · corrodedSHIP 3146, LT WING NR 2 SLAT, INBD SLAT TRACK HAS ATTACHMENT BOLT CORRODED. REPLACED LT WING NR 2 SLAT, INBD SLAT TRACK ATTACHEMENT BOLT IAW AMM TASK 27-84-64-000-001-A.SDR DALA2025072305545Web · corrodedSHIP 3155, CORROSION SHEAR PLATE STR 23 L LOCATED BETWEEN FR 69 TO FR 70 AT AFT GALLEY AREA. REPLACED WEB (SHEAR PLATE) AND FASTENERS LOC ON FR 69 TO FR 0 AT LEVEL STR 23L AFT GALLEY AREA IAW SRM 51-42-11 SRM 51-72-11.SDR DALA2025072305544Floor Support · corrodedSHIP 3155, CORROSION FLOOR SUPPORT +Y765 AT FR68 AT AFT GALLEY AREA. REPLACED FLOOR SUPPORT Y765 LOC FR 66 TO FR 70 AT AFT GALLEY AREA AS PER SRM 51-72-11 AND SRM 51-42-11.SDR DALA2025072305543Floor Support · corrodedSHIP 3155, CORROSION FLOOR SUPPORT -Y464.8 AND FR 68 AT AFT GALLEY AREA. REPLACED FLOOR SUPPROT -Y464.8 LOC. BTW FR 68 TO FR 70 AT AFT GALLEY AREA IAW SRM 51-42-11 AND SRM 51-72-11.SDR IPXA2025072268082Floor Panel · delaminatedMAJOR REPAIR, MCD FLOOR PANEL231KJ IS DELAMINATING IN SEVERAL AREAS. FABRICATED FLOOR PANEL 231KJ, I.A.W. SREO-16407-REQ001 (APPX B).SDR YENA2025072300755Switch · faultedFLT NR 1488, LAX-BOS. (ETOPS) APU AUTO SHUTDOWN (AUPSYSTEM A321NEO ETOPS); (RESOLVED ON W/O: 1427370 TASKCARD: NR-00004) REPLACED OIL PUMP DELTA P SWITCH IAW AMM 49-91-00 OPS & LEAKS CHECKS GOOD. ETOPS RESTRICTION STATUS REMOVED DUE TO NO FAULT REPORTED WITH A