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 SWAA2025102226015Handle · looseFO SIDE OVER WING EMERGENCY EXIT DOOR HANDLE LOOSE. REINSTALLED STRAP COVER ON FO SIDE EMERGENCY EXIT DOOR IAW AMM 52-22-00.SDR SWAA2025102225627None · smokeDUE TO PASSENGER LI-ION BATTERY HIGH CAPACITY DISCHARGE IN FLIGHT. PERFORMED CONDITIONAL INSPECTION PER AMM 05-51-56 . NO SMOKE OR FUMES NOTED .SDR SWAA2025102225760Battery · no testAFT CAPTAIN SIDE FLIGHT ATTENDANT FLASHLIGHT TEST FAILED. REMOVED AND REPLACED AFT LT OTBD FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECK GOOD AT THIS TIME.SDR SWAA2025102225753Megaphone · unsecureFWD MEGAPHONE CLASP UNHOOKED. SECURRED MEGAPHONE IN FWD GALLEY. REF AMM 25-64-00.SDR SWAA2025102225647Flashlight · inoperativeAFT RT INBD EMERGENCY FLASHLIGHT NOT TESTING. REMOVED AND REPLACED AFT R/H I/B EMERGENCY FLASHLIGHT PER AMM 25-64-00.SDR SWAA2025102225700Flashlight · no discrepancyONE FWD FLIGHT ATT FLASHLIGHT IS INOPERATIVE. PERFORMED FWD FLASHLIGHT TEST AMM 25-64-00 AND OPS CHK GOOD.SDR SWAA2025102226033Flashlight Assy · inoperativeAFT FLT ATN FLASHLIGHT WILL NOT TEST. REPLACED AFT FLASHLIGHT ASSY AND BATTERY REF AMM 25-64-00.SDR SWAA2025102226896Battery · inoperativeAFT FLT ATN FLASHLIGHT WILL NOT TEST. REPLACED AFT FLASHLIGHT ASSY AND BATTERY REF AMM 25-64-00.SDR CALA2025102210418Cradle · inoperativeAFT CABIN FLASHLIGHT INOP AFT AC LEFT INBOARD FLASHLIGHT HOLDER TESTER IS INOP. REQUEST MEL 2512A. MEL 2512A APPROVED BY TOMC. DDP CW MEL APPLIED COULD NOT DUPLICATE, AFT FLASHLIGHT OPS CHKS GOOD.SDR CALA2025102210417Unknown · odorFA AND PAX SMELLED SOMETHING LIKE BURNING RUBBER APPEARED TO BE STRONGER IN AFT CABIN DEBRIEFED THE CREW. CREW STATED THAT INITIALLY SMELLED BURNING RUBBER SMELL IN FLIGHT DECK AND THEN AFTER COUPLE MINUTES IN THE AFT GALLEY AFTER TAKE-OFF. ENGINE BLEEDS WERE SDR DALA2025102207748Power Supply · no testEMERGENCY LIGHTS DISPATCH MSG. PERFORMED BITE OF EPSU, FAULTING POWER SUPPLIES UNITS 102WL3 AND 102WL4, R/R BOTH UNITS PER A350 AMM 33-51, TESTS OK, DISPATCH MSG CLEARED, OK FOR SVC. (LP# 7606668)SDR DALA2025102207719Sensor · faultedRETURNED TO AGS DUE TO A LEFT GEAR UNSAFE INDICATION. MAINTENANCE REPLACED THE LEFT DOOR UP AND LATCHED SENSOR. CYCLED GEAR OPS CHECK NORMAL.(7707452)SDR DALA2025102007649Shear Tie · corrodedSHIP 1813 AFT CARGO SHEAR TIE FOUND CORROSION AT STA1307 S-37L TO S-38L. CORRECTIVE ACTION: THE DAMAGED SHEAR TIE REMOVED AND REPLCAED AS PER B767-400 SRM 51-40-02 (1260057)SDR DALA2025102007648Skin · damagedSECTION 48 LH FUSELAGE SKIN AT STA1736 WL200 FOUND ABRASION. THE DAMAGED SKIN REPAIRED AS PER B767-400 SRM 53-80- 01 (1260037)SDR DALA2025102007647Strut · out of limitsSHIP 171 RT MLG UPPER PISTON TORSION LINK ATTACHMENT POINT FOUND OUT OF LIMITS. CORRECTIVE ACTION: REPAIRED DIA II A+B PER LGCMM 32-00-00 (1259603)SDR DXTA2025102205369Adapter · defectiveLEFT AND RIGHT BRAKES. ON LANDING BRAKES PULSING WHEN PRESSURE APPLIED. FROM LANDING SPEED TO SLOW TAXI SPEED. REPLACED BRAKE SCREW ADAPTER. OPS CHECK GOOD. IAW AMM CH 32-40-00.SDR DALA2025102207704Oxygen Mask · unwanted deployOXYGEN PANEL MASK DEPLOYED AFT OUTBOARD LAVATORY. STOWED PAX O2 MASKS AT AFT RT LAVATORY. OKAY TO CONT. IN SVC. (LP: 1260451)SDR DALA2025102107698Inverter · odorDIV/DE- TO SLC DUE TO ELECTRICAL SMELL IN THE FLIGHT DECK AND STANDBY INVERTER MESSAGE. REPLACED STANDBY INVERTER.SDR DALA2025102107697Guide Arm · faultedL2 DOOR IS VERY DIFFICULT TO OPEN. REMOVED L2 DOOR HINGE COVER PANEL TO FACILITATE MAINT. REMOVED SLIDE COVER, R & R 2 LT DOOR GUIDE ARM IAW AMM 52-11-4-402- 037 SUB TASK 822-054. FINISHED INSTALLATION OF 2LT DOOR GUIDE ARM IAW AMM 52-11/ REINSTALLED COVERSDR AALA202510217268Hydraulic Line · damagedAIRCRAFT WAS NOT GROUNDED: AIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 ENGINE HYDRAULIC LOW PRESSURE ILLUMINATED IN FLIGHT. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. FOUND NUMBER 2 EDP PRESSURE LINE DAMAGED AND DISCONNECTSDR AALA202510218901Processor · faultyAIRCRAFT WAS GROUNDED: LEFT FUEL TANK READINGS ARE ERRATIC. IT SHOWS FUEL CONTENTS INCREASING AND DECREASING RAPIDLY CONTINUOUSLY. AFTER ONE HOUR OF RAPID INDICATION FLUCTUATIONS, THE LEFT FUEL GAUGE GAVE UP AND BLANKED OUT COMPLETELY. REMOVED AND REPLACED FUESDR KCSA2025101956Lock · warning messageDOOR UPPER DECK FLIGHT LOCK MESSAGE. BOTH DOORS FLIGHT LOCK ACTUATORS OPERATIONAL CHECKS NORMAL IAW B747-400 AMM 52-23-00.SDR AALA202510218113Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510217044Door Latch · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR EXTREMELY HARD TO OPEN, OPENING LATCH DOESN'T OPEN FAR ENOUGH TO CLEAR THE LOCK. MAINTENANCE ADJUSTED FLIGHT DECK DOOR LATCH MECHANISM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-21.SDR AALA202510212285Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR YENA2025102101050Warning Message · false activationFLT#353, YHZ-DUB. (ETOPS) "MX AIR BLEED STATUS MSG ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY AIR BLEED ); PERFORMED GROUND SCANNING AND BITE TEST PER AMM 36-11-00. NO FAULTS NOTED. CAN NOT DSDR YENA2025102101047Unknown · odorFLT#1498, DEN-JFK. "INFLIGHT REPORTED ELECTRICAL SMOKE SMELL IN AFT LAV AREA; ACCOMPLISHED FIM FAULT ISOLATION PROCEDURES FOR FUMES / SMOKE IN CABIN. NO ELECTRICAL SMOKE SMELL NOTED. IAW FIM J21-22-00. A/C OK FOR CONT SVC."SDR R61A2025101900479Slide · partial deployL1 DOOR SLIDE PARTIALLY DEPLOYED WHEN ATTEMPTING TO OPEN. REMOVED AND REPLACED THE L1 DOOR SLIDE.SDR R61A2025101900476Pressure Switch · faultedPARKING BRAKE NOT RELEASED EICAS MSG AT CRUISE, PERSISTED UNTIL LANDING. NORMAL LANDING AND BRAKES APPEARED NORMALLY. AFTER TOUCHDOWN MSG CLEARED AND EMERGENCY BRAKE FAULT MSG APPEARED UNTIL PARKING BRAKE WAS SET AT GATE. DECLARED EMERGENCY, LANDED WITHOUT INCSDR CALA2025102110364Elec Connector · disconnectedEMERGENCY ISLE LIGHT AT SEAT 11F INOP FOUND WELS ISLE LIGHT CONNECTOR D11J BEHIND SEAT 11F DISCONNECTED. CONNECTED WELS LIGHTS. OPS CHECKED GOODSDR CALA2025102110362Light · looseROW 10 FLOOR SEAT MOUNTED EXIT LIGHT NEEDS RESECURED. - EMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. REMOVED AND REPLACED LIGHT ASSY IAW AMM 33-51-11, LIGHTS OPS CHECK GOOD.SDR CALA2025102110361Light · no discrepancyEMERGENCY LIGHTS REMAINED ON AFTER 10000 DOUBLEING NO PFR, NO ECAM MSGS, NO LAST LEG REPORT. OPS CHECK OF E LIGHTS VIA FAP, OPS CHECK OK,OPERATIONAL TEST OF THE EMERGENCY LIGHTING IN THE CABIN WITH THE 'LIGHT EMER' PUSHBUTTON SWITCH,AMM REFERENCE: TASK 33-51-0SDR CALA2025102110360Lamp · inoperativeEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. EXTERIOR RT AFT OVERWING BOTH LIGHTS NOT WORKING REPLACED R/H AFT SLIDE OVERWING LAMP, OPS CHECK GOOD REF AMM 33-51-04SDR CALA2025102110358Rivet · missingMISSING RIVET ON NO2 ENG INLET OUTSIDE 11 OCLOCK POS FACING AFT REQUEST CARRY FOR MISSING FASTNER. ONLY 1 MISSING AT THIS TIME. PER SRM DAMAGE IS ZONE K2 AND MAY BE CARRIED FOR 600FH 750FC OR 100 DAYS.SDR CALA2025102110354Structure · no discrepancyBIRD STRIKE ON ROTATION IN KMKE. ABOVE FLIGHT DECK. CLEANED BIRDSTRIKE IN REFERENCE TO AMM 12-40-04. PERFORMED BIRD STRIKE INSPECTION IN REFERENCE TO AMM 05-51-18. ONLY SINGLE IMPACT OCCURED APPROXIMATELY 2 FEET ABOVE CAPTAINS WINDOW. NO OTHER IMPACTS FOUND ONSDR CALA2025102110345Fire Loop · faultedMULTIPLE INTERMITTENT RT ENGINE FIRE WARNINGS DURING CLIMB/CRUISE. RT ENGINE FIRE LOOP 2 INITIALLY INOPERATIVE IAW MEL, FIRE WARN WOULD HAVE WENT OFF DUE TO FAULT IN LOOP 1. FOUND POSITIVE FIX FOR RT ENG. FIRE LOOP 2. MEL CLEARED. NO FAULTS NOTED FOR RT ENG SDR CALA2025102110344Lens · missingSEAT 2D FLOOR PROXIMITY LIGHT MISSING. CONFIRMED PROXIMITY LIGHT PROBABLY TAKEN DOWN HIT BY LUGGAGE. REMAINS OF MISSING LIGHT (WIRE/CONNECTORS) REMOVED AND REPLACED WITH A NEW LIGHT ASSY PER AMM DMC-B787-A-33-51-06-00A-520A-A (REMOVAL) AND AMM DMC-B787-A-33-51SDR CALA2025102110343Slide · dislodgedMAIN CABIN DOOR SLIDE COMING OUT OF BUSTLE. DOOR 1L SLIDE CAME OUT OF CONTAINER, DID NOT DEPLOY. COMPLIED WITH RENDER SAFE CHECKLIST FORM 46-0035. REMOVED DOOR 1 LEFT SLIDE PACK ASSLY REF AMM 25-66-01. INSTALLED NEW SLIDE ASSLY AT DOOR 1L, REF AMM 25-66-01 SDR UIEA2025101801269Skin · brokenEXTERNAL FUSELAGE SKIN SECTION 48 HAS BROKEN PANEL AT RH SIDE BTWN STATION 2618 & 2638(<P>R/R AIR INTAKE LIP PER SRM 51-40-02 PAR. 5. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025101801270Skin · brokenEXTERNAL FUSELAGE SKIN SECTION 48 HAS BROKEN PANEL AS RH SIDE BTWN STATION 2618 & 2638(<P>R/R AIR INTAKE LIP PER SRM 51-40-02 PAR. 5. NO FURHTER DEFECTS NOTED</P>)SDR UIEA2025101801271Skin · brokenEXTERNAL FUSELAGE SKIN SECTION 48 HAS BROKEN PANEL AT RH SIDE BTWN STATION 2618 & 2638(<P>R/R AIR INTAKE LIP PER SRM 51-40-02 PAR. 5. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025101801272Skin · brokenEXTERNAL FUSELAGE SKIN SECTION 48 HAS BROKEN PANEL AT RH SIDE BTWN STATION 2618 & 2638(<P>R/R AIR INTAKE LIP PER SRM 51-40-02 PAR. 5. NO FURTHER DEFECTS NOTED</P>)SDR UIEA2025101901273Slide · low pressureLOW PRESSURE ON SLIDE BOTTLES ON UPPER RIGHT DOOR (18332AP) SLIDE PN: 7A1323-114 SN G2230(<P>R/R SLIDE & OPS CHK OK PER AMM 25-68-00.</P>)SDR UIEA2025101901274Slide · low pressureLOW PRESSURE ON SLIDE BOTTLES ON UPPER LEFT DOOR (18332AP)(<P>R/R SLIDE & OPS CHK OK IAW AMM 25-68-00.</P>)SDR HALA20251020324Fuel Filter · cloggedETOPS - APPROX 2 HOURS INTO FLIGHT, FL 360 ECAM ENG 1 FUEL FILTER CLOG MAINTENANCE NOTIFIED. REMOVED AND REPLACED ENG 1 LP FUEL FILTER PER AMM 73-11-41. OPS CHECK AND LEAK CHECK GOOD. OK FOR SERVICE.SDR ASAA2025101961726Light · missing3 INCH STRIP OF EMERGENCY EXIT LIGHTING IS MISSING FROM FLOOR. GROUNDED - YES. REMOVED DEFECTIVE 3'' PIECE OF PHOTOLUMINESCENT STRIP AT 16 DEF. ALSO REMOVED ADJACENT STRIP FROM 13 DEF TO 16 DEF. REPLACED W/ NEW SOLID RUN OF PHOTOLUMINESCENT FLOOR PROXY LIGHT SSDR QXEA2025102000326Brake · overtempFLIGHT 2066. RTO APROX 80KTS. HARD BRAKING CAUSED #2 BRAKE TO GO YELLOW NO EICAS MESSAGE. REMOVED FROM SERVICE. PERFORMED GVI OF LH&RH MLG WHEELS AND BRAKES. NO DEFECTS NOTED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR SWIA2025102000019Ballast · failedON DECENT PASSENGERS MENTIONED A BURNT ORDER. CONFIRMED BY THE FLIGHT ATTENDANT. PASSENGERS IN ROW 16 COMPLAINED THAT THE FLOOR WAS €ŒREALLY HOT€? AT THE SAME TIME. AFTER DEPLANING THE SMELL REMAINED. (FLIGHT 6468) APON ARRIVAL TO ACFT COULD SMELL A SLIGHTSDR DALA2025102007666Bracket · damagedTOOLING DAMAGE ON BRACKET AT FASTENERS FWD SIDE OF FRAME 26.1 @ P'4. REPAIRED PER ERA 628177-14 REV ORIG. (1260106)SDR DALA2025102007664Frame · damagedFRAME 57.4 RT FWD SIDE AT P'4 CLIP FOR BRACKET TOOLING DAMAGE. REPAIRED PER ERA 628177-14 REV. ORIG. (1259609)