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 FDEA202508061379Floor Panel · puncturedPUNCTURE AND CRACK ON SURFACE OF FLOOR PANEL 231LFF, SEC 43 OF MDC FLOOR PANEL 231LFF, SEC 43 OF MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15 2025SDR FDEA202508061378Floor Panel · crackedMDC FLOOR PANEL 241GFF WITH CRACK MDC FLOOR PANEL 241GFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025SDR FDEA202508061376Floor Panel · dentedMAIN DECK COMP. AT APOX. STA 350 & RBL11 TO RBL33 FLOORBOARD PANEL 222AFF ABOVE SURFACE SKIN HAS INDENTATION (MARKED) FABRICATED NEW FLOOR PANEL (PNL# 222AFF MPN: 141T5856-107) AT STA. 285 412 BETWEEN RBL11 RBL33 IN REF. TO DRW# 141T5856-107. THIS IS ASDR R61A2025080600344Bracket · corrodedDURING HEAVY CHECK FOUND AFT CARGO DOOR CUTOUT BRACKET AT FR80 STR 26 FOUND CORRODED. REPLACED BRACKET IAW SRM 51-41-01SDR KCSA2025080643Seal · leakingL1 DOOR SEAL - HIGH PITCH SQUEAL DURING FLIGHT. DAMAGE FOUND ON UPPER RIGHT OF DOOR SEAL. TYPE 2 REPAIR COMPLETED IAW B777 52-09-00 ON CUTOUT SEAL OF L1 DOOR BROKE. CABIN HOLDING PRESSURE NO NOISE PRESENT IAW B777 05-51-24.SDR R61A2025080600343Attach Bracket · corrodedDURING HEAVY CHECK FOUND FWD CARGO DOOR CUTOUT LOWER TRIM ATTACH BRACKETS (6) FOUND CORRODED. REPLACED BRACKETS IAW SRM 51-41-01SDR R61A2025080600342Beam · corrodedDURING HEAVY CHECK FOUND AFT CARGO DOOR CUTOUT LOWER BEAM PLATE FR 77-80 STR 27 CORRODED. REPLACED LOWER BEAM IAW AMM 20-10-01-410-801-A00.SDR R61A2025080600341Support · corrodedDURING HEAVY CHECK FOUND FWD FUSELAGE SUPPORT AT FR16 LBL45 FOUND CORRODED. REPLACED SUPPORT IAW SRM 51-43-03SDR R61A2025080600340Seat Track · corrodedDURING HEAVY CHECK FOUND FWD FUSELAGE RH INBD SEAT TRACK CORROSION FOUND FR 16-20. REPLACED SEAT TRACK IAW SRM 51-43-03SDR R61A2025080600339Seal Rest · corrodedDURING HEAVY CHECK FOUND AFT SERVICE DOOR R2 LOWER SEAL REST FR 85-87 CORRODED. REPLACED SEAL REST IAW SRM 51-41-01SDR R61A2025080600338Crossbeam · corrodedDURING HEAVY CHECK FOUND CFIII CROSSBEAM UPPER FLANGE AT FR 84 RBL 17-24 FOUND CORRODED. REPAIRED IAW ETD2025-770-925238SDR R61A2025080600337Splice · corrodedDURING HEAVY CHECK FOUND CFIII INTERCOSTAL SPLICE AT FR84 RBL26 FOUND CORRODED. REPLACED SPLICE IAW SRM 51-43-01SDR R61A2025080600336Plate · corrodedDURING HEAVY CHECK FOUND CFIII GUSSET PLATE FOUND CORRODED FR 90 RBL 24. REPLACED GUSSET PLATE IAW SM 51-41-02SDR R61A2025080600335Splice · corrodedDURING HEAVY CHECK FOUND CFIII FLOOR SUPPORT SPLICE CORRODED FR90 RBL1 - LBL5. REPLACED SPLICE IAW SRM 51-43-03SDR R61A202508060334Splice · corrodedDURING HEAVY CHECK FOUND CFIII FLOOR SUPPORT SPLICE CORRODED FR90 RBL1 - LBL5. REPLACED SPLICE IAW SRM 51-43-03SDR AALA202508073026Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS STICKING AND HARD TO OPEN. FOUND FIRST CLASS LAVATORY DOOR LATCH LOOSE, SECURED LATCH SCREW. DOOR OPERATIONAL CHECK GOOD.SDR AALA202508074415Control Unit · faultedAIRCRAFT WAS GROUNDED: DURING THE LANDING ROLL AND AGAIN DURING THE TAXI, THE ANTI-SKID AND BRAKING SYSTEM HAD A TENDENCY TO SKIP AND STUTTER. PERFORMED (AACU)-ANTISKID AUTOBRAKE CONTROL UNIT BITE PER FIM 32-42-00-810-801. FOUND MULTIPLE FAULTS. REMOVE AND REPSDR AALA202508076314Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE FROM THE OUTSIDE. FLIGHT ATTENDANT ADVISES YELLOW GUST LOCK INSIDE IS DIFFICULT TO PRESS. INSPECTED MAIN CABIN DOOR, PER AMM TASK 52-13-51-200-801. FOUND GUST LOCK NEEDED TO BE LUBED, OPERASDR R61A2025080600334Strap · corrodedDURING HEAVY CHECK FOUND CFIII LOWER SKIN WING TO FUSELAGE FAIRING STRAP FOUND CORRODED FR74 STRINGER 29R-24R. STRAP WAS REPLACED IAW SRM 51-42-02SDR R61A2025080600333Skin · corrodedDURING HEAVY CHECK FOUND CFII EXTERNAL SKIN BET FR59-60 STR 3R-4R FOUND LIGHTNING STRIKE DAMAGE. PERFORMED REPAIR IAW ETD2025-170-925417SDR YENA2025080700808Unknown · odorFLT#2924, STI-BOS. (AIRCRAFT PERFORMED AN AIR RETURN TO STI) DIRTY COCK ODOR EVENT SHORTLY AFTER TAKE OFF. STRONG IN BOTH CABIN AND COCKPIT. RAN ODOR ISOLATION PROCEDURE. DID NOT HELP, BOTH PACKS APPEAR TO BE CONTAMINATED. SUSPECT APU BLEED AS SOURCE. AIRCRAFSDR R61A2025080600332Support · corrodedDURING HEAVY CHECK FOUND FWD CARGO CENTER FLOOR PANEL NET SUPPORT CORRODED. REPLACED SUPPORT IAW AMM 20-10-01-910-801-A00 TABLE 206SDR R61A2025080600331Door · corrodedDURING HEAVY CHECK FOUND CFIII WASTE SERVICE DOOR FOUND CORROSION ON HINGE AND STIFFENER. REMOVED AND REPLACED DOOR ASSEMBLY IAW AMM 53-03-60-040-800.SDR SIMA20250806001Light · inoperativeEMERGENCY PHOTOLUMINESCENT STRIP LIGHT AT ROWS 1 AND 2DF INOP. EMERGENCY R & R PHOTOLUMINESCENT STRIP LIGHT AT ROWS 1 AND 2DF IAW ERJ-175 AMM 33-50-21/400. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR DALA2025080705911Oxygen Mask · unwanted deployOXYGEN PANEL MASK DEPLOYED BUNK 5. RE-PACKED MASKS PER A330 AMM 35-21. OK FOR SERVICE.SDR DALA2025080705910Light · inoperative32H EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSY PER A330 AMM 33-51.SDR CALA2025080707446Lens · missingSPACE 712 EMER EXIT LIGHT COVER MISSING REPLACED LEFT CLOSET FLOOR LIGHT MISSING LENS REF IPC 33-51-01-01 AND DWG 3350DD15295D. LIGHT OPERATES NORMALLY AT THIS TIME.SDR CALA2025080707445Light · missingTHERE IS A HOLE WHERE EMERGENCY LIGHT SHOULD BE. FLOOR PROXIMITY LIGHT ASSEMBLY REPLACED. OPS CHECK OK. EMERGENCY LIGHTS OPS TESTED IAW 33-51-00-720-801.SDR CALA2025080707444Connector · malfunctionedASILE PATHWAY LIGHT INOP ON 14 ABC. RELAMPED NO HELP. ALL OTHER EEL LIGHTS WORK AND IS NOT AT AN OVERWING EXIT. FOUND NO VOLTAGE AT SEAT MOUNTED FLOOR LIGHT. DISCONNECTED CONNECTOR AT SEAT AT FLOOR TRACK. HAS POWER. RECONNECTED AND OPS CHECKS GOOD IAW AMM 33-5SDR CALA2025080707443Bracket · crackedRIGHT HYD SYSTEM FILTER MODULE AT RT MLG WW OTBD SIDE AREA, SUPPORT BRACKET IS CRACKED. REMOVED AND REPLACED RT HYD SYSTEM FILTER MODULE PER TRAVELER #T25/1823669 IAW SRM 51-40-02.SDR CALA2025080707442Filter · odorSTINKY SOCK SMELL WHEN A/C PACKS WERE PUT ON ENGINE BLEED SOURCE . DEBRIEF CREW: DIRTY SOCK SMELL APPEARED AFTER BOTH ENGINE RUNNING WITH APU OFF. ODOR WAS ONLY PRESENT AT IDLE SETTING AND CLEARD UP WHEN THROTTLES ADVANCED. ODOR WAS NOT PRESENT DURING FLIGHTSDR CALA2025080707441Lens · missingEMERGENCY EXIT LIGHT LENS MISSING, FWD COAT CLOSET. REPLACED THE LENS, OPS CHECK EMERGENCY LIGHT OK.SDR CALA2025080707440Light · damagedEMERGENCY LIGHTING SYSTEM OPS CHECK, 21C EMERGENCY LIIGHT MISSING, FOUND ONE LAMP BROKEN OFF & THE OTHER LAMP BURNED OUT. ALSO FOUND LENS WAS BROKEN OFF. RELAMPED AND REPLACED LENS. OPS CHECK GOOD IAW 33-51-11-960-801.SDR CALA2025080707439Bracket · corrodedAPU DOOR HAS CORROSION ON BRACKETS THAT HOLD FIRE SENSING ELEMENT. REMOVED AND REPLACED FOUR FIRE SENSING ELEMENT BRACKETS AND FWD FAME AASY FROM APU DOOR IAW SRM 51-40-02-0G-0 & DWG 148A6350.SDR CALA2025080707438Strut · crackedRIGHT MLG MID (STRUT) DOOR CRACKED. ACCOMPLISHED REPAIR AT R/H MAIN LANDING GEAR DOOR IAW SRM 52-80-02-2R-3 REPAIR 3.SDR CALA2025080707437Strut · crackedLEFT MAIN LANDING GEAR MID (STRUT) DOOR CRACKED. ACCOMPLISHED REPAIR AT LT MAIN LANDING GEAR DOOR IAW SRM 52-80-02-2R-3 REPAIR 3.SDR CALA2025080707436Battery Pack · no testEPSU BATTERY AFT LT FAILED CAP CHECK. REMOVED AND REPLACED EPSU BATTERY PER AMM 33-51-38-000-002-A. OP CHECK OKSDR CALA2025080707426Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1668 FAILED CAPACITY CHECK. REPLACED EMERGENCY BATTERY AT M1668, OPS CHK GOOD PER MM #33-51-06-960-805.SDR CALA2025080707425Light · brokenSEAT 9C EMERGENCY LIGHT BROKEN. R & R LIGHT ASSY PER AMM 33-51-11. OPS CHECK GOOD.SDR CALA2025080707422Retainer · out of positionDOOR 1R GIRT BAR IS TOUGH TO SEAT IN CLIPS TO DISARM DOOR ADJUSTED DOOR 1R RETAINER CLIPS TO CONFORM WITH DIMENSIONS REF AMM TASK 25-66-01-200-802 FIGURE 602.SDR CALA2025080707421Slide · out of positionDOOR 2R SLIDE PACK NOT STOWED PROPERLY, DOOR 2R BEZEL CABLE ENDS BENT PREVENTING BEZEL FROM SITTING FLUSH TO DOOR. ADJUSTED CABLE ENDS AND REINSTALLED SLIDE REF AMM 25-66-01-400-801 ADD EMP:US427823U172407 VERIFIED P/N , WITNESSED INSTALLATION, SAFETY SECURITYSDR CALA2025080707420Collar · looseDOOR 2R GIRT BAR COLLAR IS LOOSE. DOOR 2R SLIDE GIRT BAR STOP RELEASE DAMAGED. REPLACED GIRT BAR QUICK RELEASE STOP PER IPC 25-66-00-08 ITEM 400 , AND OPERATED GIRT BAR .SDR CALA2025080707419Slide · unsecureDOOR 1R ESCAPE SLIDE APPEARS TO BE FALLING OUT OF PACK. SECURED SLIDE PACK AT DOOR 1R MM REF25-66-01SDR 7C7A2025080600022Switch · brokenDURING INSTALLATING AFT 3 LH DOOR LINNERS FJOUND SLIDE LIGHT INDICATIO SWITCH BROKENSDR DALA2025080605906Light · malfunctionedEMERGENCY LIGHTS ON CEILING BY ROW 10 & ROW 23-24 CAME ON DURING FLIGHT. PERFORMED OPS CHECK OF EMERGENCY LIGHTING SYSTEM PER A319 AMM 33 -51-00.SDR DALA2025080605901Structure · damagedFOUND LAMINATE DAMAGED IN FWD GALLEY. REPLACED LAMINATE IN FWD GALLEY PER P.S. 900-9-1-11.SDR AALA202508069853Gust Lock · dirtyAIRCRAFT WAS NOT GROUNDED: THE GUST LOCK ON THE MAIN CABIN DOOR IS NOT WORKING. MANITENANCE CLEANED GUST LOCK HOOK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-10-00.SDR IPXA2025080620222Slide · no testESCAPE SLIDE LIGHT DOES NOT TEST. FOUND BROKEN WIRE ON POSITION 2 ON WARNING LIGHT. PERFORMED WIRE REPAIR IAW ESPM 20-48-25-01-0025-0001 AND AWM 52-73-01 PAGE 1. REINSTALLED LIGHT IAW AMM 52-73-11/401, OPS CHECK GOOD. THIS CLEARS MEL 52-73-01-1, PLACARD REMOVESDR 2025F00174Spar · corrodedRH WING AFT SPAR HAS 1 AREA OF CORROSION AROUND HI-LOK ON LOWER CLIP BEHIND PANEL 720DR. MECHANICALLY REMOVED CORROSION FROM RH WING AFT SPAR. FOUND CORROSION BLENDS TO BE BEYOND LIMITS IAW C680 SRM 51-70-02 EXCEEDING .002" OF MATERIAL REMOVED FROM NOMINAL THISDR QR9R2025080600001Reu · failedLEFT FRONT ICS CORD FAILED ON FINAL. NO COMMUNICATION COULD BE HEARD COMING IN BUT ICS OUT COULD BE HEARD. A/C PL'D AT STAGEFIELD. REMOVED AND REPLACED REU, MOC SUCCESSFULLY COMPLETED IAW 145MMS-023.