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 SWAA2025120442320Girt Bar · looseRIGHT SLIDE GIRT BAR BRACKET LOOSE. REMOVED AND REPLACED FASTENERS IAW SRM 51-40-02 ON GIRT BAR FOR RT EVAC SLIDE.SDR SWAA2025120442045Angle · crackedLEFT WING OTBD ANGLE UNDER UPPER INBD FIXED TRAILING EDGE PANEL CRACKED. REMOVED AND REPLACED ANGLE IAW SRM 51-40-02-0G-0-B00069.SDR SWAA2025120442290Boot · crackedNOSE RADOME BOOT CRACKED. REPLACED NOSE RADOME BOOT IAW AMM 53-52-00.SDR SWI2025F01718Landing Gear · warning messageGEAR DISAGREE WARNING MESSAGE. RAN QRH. THREE GREEN INDICATION, LANDED AND TAXIED TO GATE. MEL 32-30-1CAT A DUE ONE FLIGHT DAY 12/04/25 CAT II DOWNGRADED, ODI EVENT, SMOD APPROVAL REQUIRED FOR RTS. RUNWAY AND WX CONDITIONS WERE: MINOR BLOWING SNOW FROM CROSDR SWI2025F01717Landing Gear · warning messageGEAR DISAGREE WITHIN 8 SECONDS AFTER GEAR UP AFTER TAKEOFF. QRH HAD US PUT GEAR BACK DOWN, NO FURTHER ISSUES OPENSDR SWIA2025120400003Idg · faultedDURING THE APPROACH WE GOT THE RECEIVED SLATS/FLAPS DISAGREEMENT CAUTION MESSAGE FOLLOWED BY THE IDG 2 OFF BUS MESSAGE. AFTER ACCOMPLISHING THE DISCONTINUE PROCEDURE WE DID THE IDG 2 OFF BUS QRH. AND IT CLEARED ALL THE MESSAGES. DETERMINED IDG2/GCU2 (FREQ MODSDR P6VA20251204001Throttle · dirtyDURING CRUISE FLIGHT LEFT ENGINE THROTTLE STUCK AT 95% N2 WITH NO ABILITY TO ADJUST. LEFT ENGINE THROTTLE CUTOFF ALSO LOCKED IN ON POSITION. PILOTS WERE ABLE TO FREE THE ENGINE CONTROL AND MANIPULATE POWER AS REQUIRED. UPON INSPECTION OF THE AIRCRAFT AT KMDT ISDR AALA202512044762Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND PYLON SPIGOT RECEPTACLE FITTING BETWEEN PYLON RIBS 4 AND 5. REPLACED SPIGOT FITTING PER SRM 51-51-12.SDR AALA202512043325Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH CHORD INBOARD SIDE IN LEFT HAND ECS BAY AT BS 663 BETWEEN LBL 5 AND LBL 15.. ACCOMPLISHED REPAIR PER SRM 57-10-10-2R-2 REPAIR 2.SDR AALA202512049707Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AT AFT LAVATORY VENT CUTOUT AT BS 907, S21L. REPAIRED SKIN PER SRM 53-70-01-2R-3-REPAIR 3.SDR FDEA202512032218Lamp · failedCHECKED FOUND EMERGENCY DOME LIGHT INOP. RELAMPED EMERGENCY DOME LIGHT AND PERFORMED TEST PER AMM 33-51-07-2,TEST NORMAL.A/C OK FOR SVC.SDR DALA2025120408871Frame · damagedTOOLING DAMAGE ON FRAME ON AFT SIDE OF FRAME 62@ P'1. REPAIRED PER A330 SRM 51-73-00. (1334225)SDR DALA2025120408870Frame · damagedTOOLING DAMAGE ON BRACKET BACKSIDE OF 64 @ P'4/P'5. REPAIRED PER ERA 628248-14 REV ORIG. (1333554)SDR DALA2025120408869Frame · damagedTOOLING DAMAGE ON FRAME ON AFT SIDE OF FRAME 62@ P1. REPAIRED PER ERA 628248-14 REV ORIG. OK FOR SERVICE. (1333552)SDR DALA2025120408868Floor Support · corrodedCABIN FLOOR NAT INTERCOSTAL UPPER SURFACE FOUND CORROSION AT FR74, -Y794. REPAIRED ER/A 630360-14 REV ORIGINAL. (1333056)SDR DALA2025120408867Floor Support · corrodedCABIN FLOOR NAT INTERCOSTAL UPPER SURFACE FOUND CORROSION AT FR74, -Y1137. REPAIRED PER ERA 630361-14 REV ORIGINAL. (1333051)SDR DALA2025120408866Floor Support · corrodedCABIN FLOOR NAT INTERCOSTAL UPPER SURFACE FOUND CORROSION AT FR75-FR76, Y794. REPAIRED PER ERA 630359-14 REV ORIGINAL. (1333047)SDR DALA2025120408863Roller · wornRIGHT WING OTBD FLAP OTBD UPLOCK ROLLER FOUND WORN. REMOVED AND REPLACED RH WING O/B FLAP O/B UPLOCK ROLLER IAW AMM 27-54-73. (1333153)SDR DALA2025120408874Floor Support · corrodedCABIN FLOOR NAT INTERCOSTAL UPPER SURFACE FOUND CORROSION AT FR74, Y1137. REPAIRED PER ERA 630362-14 REV ORIGINAL. (1333044)SDR DALA2025120408860Sensor · inoperativeDECLARED EMERGENCY INTO ORD DUE TO LEADING EDGE TRANSIT INDICATION. REPLACED FSEU AND CHECKED PERFORMED WIRING CHECKS. OPS CHECK GOOD.SDR DALA2025120408858Skin · damagedLIGHTNING STRIKE DAMAGE TO FASTENER 1 INCH FWD OF STA 312 AND 1.5 INCHES BELOW STR26R. REPAIRED PER ERA 630781-14 REV A.SDR DALA2025120408862Battery Pack · no testON PREDEPARTURE F/C EMERGENCY LIGHTS WOULD COME ON AND OFF. T/S PER B737 WDM 33-51 AMD FOUND PACK M1674 CAUSING PROBLEM. REPLACED PACK AND ALL CKS NML PER B737 AMM 33-51.SDR U0GA2025120418345Unknown · odorAFTER LEVELING OFF FROM TAKEOFF WE STARTED NOTICING THE SMELL OF FUEL WHICH SEEMED TO BE COMING FROM THE CABIN AREA OF THE AIRCRAFT. INITIALLY WE TURNED OFF THE HEAT AND SELECTED OUTSIDE AIR FOR THE CABIN AND COCKPIT. WE TRIED DIFFERENT COMBINATIONS OF BLEED ASDR AALA202512048591Gust Lock · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THAT THE 4L DOOR WON'T LOCK INTO THE OPEN POSITION. MAINTENANCE LUBRICATED 4L DOOR GUST LOCK MECHANISM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202512045784Bottle · low pressureAIRCRAFT WAS GROUNDED: CIDS PANEL CAUTION LIGHT ON. MAINTENANCE SERVICED L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER AMM 52-10-00.SDR YENA2025120401173Slide · failedFLT 932, IAH-BOS. THE RT OVERWING EXIT DOOR SLIDE AT 12DEF WAS ACCIDENTALLY DEPLOYED WHILE WORKING ON THE DOOR WINDOW SHADE REMOVED & REPLACED RT OWEED REF AMP 25-63-02.SDR N6WA2025120405Stringer Splice · corrodedSTRINGER 25L SPLICE AT BS 333 CORRODED. REMOVED AND REPLACED STRINGER 25L SPLICE AT BS 333 IAW SRM 51-42-06.SDR N6WA2025120404Floorbeam · crackedFLOORBEAM BS 280 RT AND LT SIDE CRACKED AT TOP FLANGE BL12.00. REMOVED AND REPLACED THE FLOORBEAM BS 280 RT AND LT SIDES IAW GOJET EO-C550-53MR-111.SDR N6WA2025120403Floor Support · corrodedRH FLOOR SUPPORT AT BS 280 - 319.70 CORRODED. REMOVED AND REPLACED THE RT FLOOR SUPPORT AT BS 280 - 319.70 IAW SRM 51-42-06SDR N6WA2025120402Support Angle · corrodedCORROSION ON LT MLG TIRE BURST COVER SUPPORT ANGLE. REMOVED AND REPLACED LT MLG TIRE BURST SUPPORT ANGLE IAW SRM 51-42-21.SDR N6WA2025120401Support Angle · corrodedCORROSION ON RT TIRE BURST COVER SUPPORT ANGLE. REMOVED AND REPLACED RT MLG TIRE BURST COVER SUPPORT ANGLE IAW SRM 51-42-21.SDR DXTA2025120405953Light · inoperativeDURING PREFLIGHT THE EMERGENCY EXIT (TOE KICK) FLOOR LEVEL LIGHT AT SEAT 3 DOES NOT ILLUMINATE. ALL OTHER LIGHTS WORK NORMALLY. REMOVED AND REPLACED SEAT NR 3 CABIN LIGHT ELEMENT. OPS CHECKED GOOD , REINSTALLED UNDER SEAT DRAWER ASSEMBLY, AFT AND UPPER SEAT SDR DXTA2025120405959Battery Pack · faultedEMERGENCY LIGHTS REMAINED ON AFTER AIRCRAFT POWER DOWN, EMER LIGHT SWITCH IS IN OFF POSITION, G SWITCH RESET WAS ALSO ATTEMPTED. POWERED UP AIRCRAFT WITH APU POWER. FOUND AFT LT CABIN SEAT OVERHEAD LIGHT AND EXIT SIGN LIGHT ABOVE LAV REMAINED ILLUMINATED WITSDR DALA2025120408855Engine · odorDIRTY SOCK SMELL ON DESCENT. BECAME WORSE WITH APU BLEED ON IN GATE AREA. REMOVED AND REPLACED THE NR 2 ENGINE IAW AMM 7101. (8080650)SDR DALA2025120408854Strut · wornWEAR INTERCONNECTING STRUT INBD FLAP ON RT WING (1EA). REPLACED INTERCONNECTING STRUT INBD FLAP ON RT WING (1 EA) AS PER FAM AMM 27-51-44-000-001-A. (1333800).SDR DALA2025120408852Support · corrodedCORROSION LOWER SILL LOCATED AT LEVEL FR68 AND S23L AT AFT GALLEY AREA. PERFORMED REPAIR INSTRUCTIONS LOC. ON LOWER SILL AT FR68 AND AT LEVEL STR 23L AT AFT GALLEY AREA IAW SRM53-41-14-300-001. (1333823).SDR AALA202512043814Elec Connector · disconnectedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ANTI-SKID INOPERATIVE LIGHT ILLUMINATED ON INFLIGHT. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CLT. T/S PER FIM 32-42-00-810-829 FOUND NUMBER 2 WHEEL SPEED TRANSDUCER ELEC CONNECTOR DISCONNECTED. RECONNESDR AALA202512043155Liner · frayedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE GIRT IS WORN AND FRAYED ON BOTTOM SIDE. REMOVED AND REPLACED SLIDE PACK. PER 08L22125001.SDR AALA202512044783Door · stickingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKING. ADJUSTED DOOR LATCH. OPERATIONAL CHECK NORMAI. IAW AMM 52-50-00.SDR AALA202512049570Slide · out of positionAIRCRAFT WAS GROUNDED: L1 DOOR SLIDE SHOWS SLIGHTLY OFF ITS HOUSING. REPLACED SLIDE FITTING BARREL. PER PER AMM 52-11-00. REINSTALLED L1 DOOR SLIDE PER AMM 25-66-01 AND JOB CARD 08L22125001.SDR AALA202512045891Software · installedAIRCRAFT WAS NOT GROUNDED: SEAT 16A EMERGENCY EXIT LIGHT DOES NOT EXTINGUISH. LOAD PHASE 2 SOFTWARE AND OPERATIONAL CHECKED GOOD. PER AMM 33-21-00.SDR VNAA2025120411101Bpsu · unserviceableFLAPS FAIL AT 20 DURING APPROACH. REMOVED AND REPLACED LT BPSU UP TO CLOSE OUT 5.C. IAW AMM 27-52-03-000/400-801. ELECTRICAL RIGGING OF FLAP BPSU PASSED. SELF TEST OF SFECUS GOOD, OPS CHECKED GOOD.SDR DALA2025120408848Light · detachedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED AND INOPERATIVE. HANGING DOWN, WIRE STILL ATTACHED. RESECURED EMERGENCY SEAT MOUNTED LIGHT AS REQUIRED. OK FOR SVC SEAT ROW 30D. (LP: 1333983)SDR HNAA2025120400851Ahrs · faultedON DESCENT, INTERMITTENT ELECT BURNING ODOR BY FA JUMPSEAT. ELECT ODOR AT GATE WITH A/C IN EMERG POWER MODE AFTER ENG SHUTDOWN. LT DIST BOX RT, DIST BOX LT AND RT COCKPIT RELAY SUPPORTS NO DEFECTS NOTED. PERFORMED POWER OPS CHECK IAW AMM 24-60-00, PERFORMESDR CALA2025120411775Valve · faultedOVERWEIGHT LANDING. ESTIMAETED LDG WEIGHT 167.3. NO HARD TOUCH DOWN OR LANDING ROLL ISSUES. AFTER TAKEOFF, GEAR HANDLE WOULD NOT GO UP. CREW PULLED OVERRIDE LEVER & GEAR RETRACTED WITH NO WARNINGS. CREW CONT CLIMB & AS ACFT ACCELERATED FLAPS RETRACTED. AT FSDR CALA2025120411773Channel · corrodedL1 DOOR LOWER CUTOUT ATTACHED INTERCOSTAL CORRODED. REMOVED AND REPLACED TWO EA CHANNELS AT L1 DOOR LOWER CUTOUT IAW SRM 51-40-02-0G-0.SDR CALA2025120411770Wire · chafedOPERATIONAL CHECK OF EMERGENCY LIGHTS, ROW 2 AB FWD EMERGENCY LIGHT INOPERATIVE, CHAFED WIRE. REMOVED AND REPLACED EPL IAW DWG 998525, AND CMM 25-23-52, OPS CHKD GOOD.SDR CALA2025120411763Battery Pack · faultedEMERGENCY EXIT LIGHTS AT ALL OVERWING EXITS ARE FLASHING ON AND OFF. REPLACED BATTERY PACK AT ROW 20F IAW AMM 33-51-06-960-806, LIGHT AT RIGHT SIDE EMERGENCY LIGHTS CHECK GOOD.SDR CALA2025120411762Battery Pack · inoperativeEPSU BATTERY. REMOVED AND REPLACED THE RT EPSU BATTERY PACK IAW AMM 33-51-38/401, OPS TESTED GOOD.SDR CALA2025120411758A/C Pack · odorNUMBER 2 A/C PACK ODOR & LOW AIR FLOW. PERFORMED VISUAL INSPECTION OF THE RT A/C PACK, NO OBSTRUCTIONS IN THE INTAKE, PERFOMED A/C PACK FLOW CONTROL VALVE OPS TESTED IAW AMM 21-51-00-700-802, OPS CHECKED OK, RAN PACK & AIR CONDITIONING FOR SEVERAL MINUTES, N