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 SWAA2025121649072Battery Pack · inoperativeRIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED ONE BATTERY PACK M1695 AND OPS CHECKED GOOD IAW AMM 33-51-06-960-805.SDR AALA202512154031Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 16 AND FR 20 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-42-11.SDR CALA2025121512080Skin · crackedAPU COMPARTMENT UPPER FIREWALL CRACKS FROM FROM H-LOK LOCATED FWD, MID SECTION OF SKIN PANEL. REF AAG DEFECT CARD 2001210360-0 010 ESFR ENTRY REPAIRED AS PER ECRA 5380-01436 AND EA B757 53-20970-00-FINAL AN D BOEING REPAIR SKETCH UAL -25-0012-10C.SDR DALA2025121209088Light · inoperativeFOUND ONE RED LADDER LIGHT IN CREW REST INOP WHEN FOLLOWING SERVICE CHK STEP 18. R & R LED STRIP ON CREW REST LADDER. IAW CMM 25-29-02. (8053590)SDR CALA2025121212054Structure · corrodedCORROSION AFT WET AREA INNER CHORD LT SIDE BETWEEN BS 927+13 AND 986.5. R & R L2 INNER CHORD IAW DWG 147A8501 AND SRM 51-40-02, PENDING ESFR ENTRY, REMOVED AND REPLACED L2 INNER CHORD AS PER B737-700 DWG 147A8501 AND SRM 51-40-02.SDR AALA202512111393Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING AT FR 16 AND S23L. REPLACED CENTER SHAPE FITTING PER SRM 51-42-11.SDR DALA2025121009037Seal · failedDIV TO LAX DUE TO A "L PACK LEAK". FOUND FAULT CODE 3621F0024. FOUND LEAK ON LT UROSEAL UNDER BLUE INSULATION OVER FORWARD END OF SEAL. R/R LT DUCT UROSEAL, ITEM J PER A220 AMP 36-16-05-02. C/W LEAK CHECK. (LP# 8084381, 7823376)SDR DALA2025121009034Gear · damagedLT WING SLAT TRACK #4 RACK TOOTH #1(AFT) HAS EVIDENCE OF CORROSION WITH PREVIOUS REWORK REF 620530-14AD REV B. LIAISON ENGINEERING WILL BE REQUIRED BEFORE FURTHER FLIGHT. C/W ERA 620530-14AD REV SECTION VI AND PRI 620530-14AD REV O MATCHES. (LP# 1335109)SDR DALA2025121009033Pinion Gear · damagedLEFT WING SLAT TRACK NR 4 PINION TOOTH NR 1 (LWR) HAS EVIDENCE OF CORROSION WITH PREVIOUS REWORK REF 620530-14AD REV B LIAISON ENGINEERING WILL BE REQUIRED BEFORE FURTHER FLIGHT. C/W ERA 620530-14AD REV C SECTION VI AND PRI 620530-14AD REV 0 MATCHES ASSOCIATEDSDR DALA2025121009018Doubler · corrodedAFT CARGO CORROSION - INTERNAL DOUBLER STR 23R STA 1022 CORRODED. REPAIRED COMPLIED WITH ER/A 630153-14 REV. ORIG. (1335432)SDR DALA2025121009014Light · no discrepancyONCE AIRBORNE, ALL EMERGENCY LIGHTS CAME OM AND WOULD NOT RESET ROW 25/22 EMER LIGHTS ARE OUT & EXIT LIGHT OUT AT EMER EXIT. EMER LIGHTD WENT OUT WHEN LDG GEAR CAME DOWN, CAME BACK ON AFTER LAND. PERFORMED EMERGENCY LIGHTING SYSTEM OPS CHK. OPS CHK GOOD. OK SDR DALA2025121009008Skin · crackedTWO CRACKS ON FUSELAGE SKIN PANEL APPROX ON BS 1076 & 1095, L14R. DAMAGED AREA WERE REPAIRED IAW ER/A 630576-14. (1335394)SDR SIMA20251204001Regulator · failedBLEED 2 FAIL AT ALTITUDE. ENG BLEED SYS - XBLD OPERATIVE - M1 BLEED 1 PRESSURE UNSTABLE IN CRUISE 6-47 PSI AND RATE CHANGES OF -250/200 MSG EVENTUALLY CLEARED VIA QRH PROCEDURE INFO TO MTX. INFO NOTED TO MTX MOC 230070. RAR LH ENGINE NAPRSOV HIGH STAGE BLEED VSDR CALA2025121012006Frame · dentedTWO DENTS ON BS 700 FRAME LEFT SIDE, STRINGER 23L & BETWEEN S24L TO S25L. ACCOMPLISHED A REPAIR ON FRAME IAW EA 757-5330-13-A42.SDR CALA2025121011972Floor Support · crackedMAIN CABIN FLOOR SUPPORT UPPER ATTACH FLANGE, CRACKED IN MULTIPLE LOCATIONS BETWEEN BS 380 & 400, RBL 9. REMOVED & REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02 & DWG 143A5400, REV A. .SDR DALA2025120908992Light · damagedEMERGENCY SEAT MOUNTED LIGHT DAMAGED AT SEAT:35F. REPLACED LIGHT ASSY OPS CHECKED NORMAL. (1335983)SDR DALA2025120908991Lens · missing6A EMERGENCY LIGHT LENS ON SEAT MISSING. REPLACED 06A EMERGENCY LIGHT LENS IAW CMM 25-25-09. (8053591)SDR DALA2025120908988Spar · crackedCRACKS WERE FOUND ON THE NR 1 PYLON FWD UPPER SPAR WEB. ACCOMPLISH ER/A 630407-14AD. (1335822)SDR DALA2025120908987Elec Connector · disconnected46AB EMERGENCY LIGHT ON AISLE SEAT INOPERATIVE. RECONNECTED CONNECTOR ON SIDEWALL AND OPS CHECKED. (8053589)SDR DALA2025120908984Stiffener · crackedMFEC INSPECTION FOUND ONE CRACK AT NOSE WHEEL WELL RT VERTICAL STIFFENER BS 287, BL 25 AND WL 172. PEFORMED REPAIR ON NOSE WHEEL WELL RT VERTICAL STIFFENER AT BS 287, BL 25, AND WL 172 CRACKED AREA, REFER TO W/C 5312-01186-02B. (1334592)SDR DALA2025120908993Fuse · inoperativeL2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R ASSOCIATED FUSE ON POWER SUPPLY M738 IAW AMM 33-51 AND WDM 33-51-21. (8053585)SDR DALA2025120908981Light · inoperative4R EMERGENCY LIGHT INOPERATIVE. EXTERIOR OF DOOR. REMOVED & REPLACED LIGHT 152WL41 ON R4 DOOR, OPS CHECKED GOOD IAW AMM 33-51. ACFT OK FOR SVC.SDR R61A2025120400522Ace · failedAP FAIL IN FLIGHT ON APPROACH. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. PERFORMED OPS CHECK OF AUTOPILOT. PITCH TRIM FAIL IN FLIGHT ON APPROACH. DECLARED EMERGENCY. LANDED WITHOUT INCIDENT. REMOVED AND REPLACED HS-ACE.SDR SWAA2025120842731Slide · missingFWD. ENTRY ESCAPE SLIDE IS NOT INSTALLED. R & R FWD ENTRY DOOR ESCAPE SLIDE PER MT 725-61-06-FE, OK FOR SERVICE.SDR SWAA2025120842628Start Valve · failedNUMBER 2 ENGINE FAILED TO START. ( REPEAT WRITE UP) R & R THE NR 2 ENGINE STARTER AIR VALVE IAW AMM 80-11-02, RAN NR 2 ENGINE & OPS CHECKED OKAY. EV E052364.SDR SWAA2025120842707Web · crackedLT CENTER GEAR DOOR HAS CRACK ON WEB AT FWD. LOWER MOUNT POINT. OK TO CONTINUE PER CDL 32-10-3. COMPLIED WITH SP 1B, PLACARDING OF UNIQUE ITEMS. AUTHORIZATION NUMBER: 296028..SDR SWAA2025120843094Lens · detachedOVERWING EXIT SIGN LIGHT LENS FELL OFF AT CEILING AREA. INSTALLED LIGHT LENS IAW AMM 33-51-01.SDR SWAA2025120842643Lamp · inoperativeL-1 DOOR EMERGENCY EXTERIOR LIGHT INOPERATIVE. REPLACED THE LAMPS AND PERFORMED GOOD OPS CHECK OF L1 EMERGENCY EXTERIOR LIGHT IAW AMM 33-51-04-960-801.SDR S9BA202512080003Fire Detector · out of toleranceFLT/CREW REPORTED - UPON LEVELING OUT ON FLIGHT NR BB-136 SSP / SSB RT ENGINE FIRE WARNING LIGHT CAME ON WITH AURAL FIRE BELL WARNING CAME ON ALSO. POWER LEVER / TQ WAS REDUCE AND BOTH FIRE WARNING EXTINGUSHED, F/O VISUALLY CONFIRMED NO FIRE OR SMOKE WAS COMINSDR AALA202512082978Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY AREA LIGHT ABOVE SEAT 4E INOPERATIVE. PERFORMED DEEP CYCLE PROCEDURE ON EMERGENCY BATTERY. PER AMM 33-51-06.SDR AALA202512088412Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD RIGHT EXTERIOR OVERWING EXIT LIGHT IS INOPERATIVE. PERFORMED DEEP CYCLE PROCEDURE ON EMERGENCY BATTERY. PER AMM 33-51-06.SDR AALA202512083170Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY AREA LIGHT ABOVE SEAT 16DEF INOPERATIVE. PERFORMED DEEP CYCLE PROCEDURE ON EMERGENCY BATTERIES. PER AMM 33-51-06.SDR AALA202512087622Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY AREA LIGHT ABOVE SEAT 12DEF INOPERATIVE. PERFORMED DEEP CYCLE PROCEDURE ON EMERGENCY BATTERIES. PER AMM 33-51-06.SDR AALA202512088196Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT FLOOR PROXIMITY LIGHTS FROM ROWS 8-14ABC ARE INOPERATIVE. PERFORMED DEEP CYCLE PROCEDURE ON EMERGENCY BATTERIES. PER AMM 33-51-06.SDR GTIA2025120839195Megaphone · inoperativeAFT MEGAPHONE INOP-R&R AFTE MEGAPHONE IAW AMM 25-64-00. OPS CK OKSDR DXTA2025120805965Drain · ventingENROUTE IT WAS NOTED THAT THE ACFT KEPT BALANCING FUEL & FMS POSTED A FUEL QTY DISAGREE. STARTED WITH AN OVERAGE OF 1500 LBS, DEGRADED TO 3500LB DEFICIT. LT TANK HIGHER LOSS THAN RT TANK. RATE OF LOSS INCREASING. POST FLT, FUEL DRIPPING ALL ALONG AFT FUSE. SDR DXTA2025120805968Bellcrank · wornMAIN CABIN DOOR REQUIRES EXCESSIVE FORCE TO OPEN AND CLOSE AND SEEMS TO BE BINDING INTERNALLY. OPERATION IS NOT NORMAL COMPARED TO OTHER MAIN CABIN DOORS ON XLS FLEET. REMOVED WORN UPPER BELLCRANK. INSTALLED SUPPLIED NEW BELL CRANK. REMOVED WORN LOWER BELLCRSDR DXTA2025120805976Pin · faultedMAIN DOOR WILL NOT LATCH CLOSED. HANDLE WILL NOT MOVE. TOP RIGHT SIDE DOOR PIN WHEN THE DOOR IS OPEN IS PROTRUDING. SCUFFS ON RIGHT SIDE DOOR SEAL. SUSPECT WORN LATCH PIN LINK HARDWARE IS CAUSING EXCESSIVE PLAY & PREVENTING PIN FROM FULLY RETRACTING. INSTALLSDR YENA2025120801178Actuator · faultedFLT#1189, JFK-SAN. (ETOPS) FUEL ACT XFR FAULT QRH PROCEDURE APPLIED ALL SYS ARE NORMAL ( CAUTION ON ECAM 5) ACT XFR FAULT (ACT) ).SDR AALA202512087650Life Line · misinstalledAIRCRAFT IN BASE MAINTENANCE: R1 SLIDE ARM INTERMITTENT. MAINTENANCE FOUND THE MOORING LINE INCORRECTLY INSTALLED ON THE GIRT BAR, REINSTALLED MOORING LINE ON GIRT BAR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-62-44.SDR SCNA20251208463Fitting · unsecureFWD ENTRY THRESHOLD GALLEY MAT/GIRT BAR FITTING RETAINING PLATE CENTER 2 SCREWS STICKING UP AFT SCREW OF CENTER SECTION INSERT LOOSE FROM FLOORBOARD. TIGHTENED SCREWS IAW AMM 25-27-21 OK FOR SERIVCE.SDR 4EZF2025120800001Electronic Unit · corrodedRIGHT ACP NOT WORKING AND STUCK MIC DURING CRUISE, FLIGHT CREW RETURNED TO BASE. R & R REMOTE ELECTRONIC UNIT IAW WITH SAAB 340 AMM 23-50-05-04, OPS TEST SATISFACTORY.SDR CALA2025120811925Structure · damagedBIRD STRIKE ON RIGHT SIDE OF AIRCRAFT ALT-1000. 190KTS. PERFORMED BIRD STRIKE INSPECTION IAW AMM 05-51-18, FOUND DAMAGE TO NR 7 LEADING EDGE SLAT. INSPECTED ALL ATTACHMENT POINTS AND HARDWARE FOR SLAT NR 7, NO DEFECTS NOTED. INSTALLED NR 7 LEADING EDGE SLATSDR CALA2025120811923Module · faultedLANDING GEAR FAILED TO RETRACT ON T/O. MANUAL GEAR EXT DOOR SWITCH DID NOT FIX ISSUE DEBREIFED FLIGHT CREW AND THEY REPORTED THAT ALL LANDING GEAR INDICATORS GREEN/RED WERE ILLUMINATED AFTER FIRST GEAR RETRACTION ATTEMPT. FOLLOWING EMERGENCY PROCEDURE THE GESDR CALA2025120811859Skin · corrodedFOUND CORROSION AT FWD CARGO BILGE SKIN ANTENNA DOUBLER BL 0 BETWEEN BS 500 AND 500A. FABRICATED AND INSTALLED NEW DOUBLER PLATE AT STA 500 AND 500A BL 0, AS PER GTE AIRFONE DRAWING AFP42-0044-00 AND SRM 51-40-02-0G-0.SDR CALA2025120811857Warning Message · illuminatedDUE TO FLIGHT CREW DECLARING EMERGENCY ON APPROACH AT ORD. CREW STATED THEY GOT AN AMBER F/CTL FLAP SYS 2 FAULT 1000 FEET AFTER TAKE OFF DURING CLIMB OUT. MESSAGE REMAINED UNTIL FLAP DEPLOYMENT, MESSAGE WENT AWAY. HYDRAULICS WERE GOOD, NO FURTHER ISSUES NOTESDR CALA2025120811855Fan · seizedPER VERBAL FROM THE CAPTAIN, ELECTRICAL, ACRID ODOR IN CABIN AND FLT DECK. NO VISIBLE SMOKE NOTED. CONDITIONAL INSPECTION CARRIED OUT IAW AMM 05-51-58-800-801-C3, UP TO & INCLUDING BLOCK 1. B. NO DEFECTS NOTED BY CREW IN DE-BRIEFING, RECIRC FAN STATUS MESSASDR CALA2025120811853Frame · dentedAFT CARGO BAY, BS 1340, S25L FRAME HAS A DENT. REPAIRED IAW EC/RA:5 360-02068, AND VTMAE EA 757-5360-13-A4205 REV-.SDR CALA2025120811851Frame · dentedFWD CARGO BAY, BS 700, LT SIDE, NEAR S23L AND S24-25L, FRAME HAS TWO DENTS. REPAIRED IAW EC/RA 5330-07664 AND VT MAE EA 757-5330-13-A 4210 REV-.SDR CALA2025120811826Bottle · no discrepancyF/A REPORTED RT DOOR PRESSURE IN RED. PRESSURE NEEDLE IS STILL WITHIN GREEN BAND AT THIS TIME. BUSTLE VIEWPORT IS NOT CENTERED ON GUAGE AND DIFFICULT TO SEE WITHOUT SUFFICIENT LUMINATION. NO MAINT ACTION TAKEN.