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 SWAA2025121853258Battery · inoperativeFA REPORTS FLASHLIGHT IS INOPERATIVE IN AFT GALLEY. REPLACED THE FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR VNAA202512186007Cap · corrodedCORROSION ON MIDCAP ON INTERNAL SURROUND STRUCTURE BTW FS349 TO FS310 ON THE PASSENGER DOOR. EVALUATED, DUE TO EXCESSI•VE DAMAGE ON MIDCAP ON INSTERNAL SURROUND STRUCTURE BTW BS 349 - BS 310 ON THE PASSENGER DOOR IAW SRM 53-00-00-101-001-A01 AND REPLACED IAW SDR VNAA202512186006Fitting · corrodedCORROSION FLOOR FITTING ACCESS 109 (1EA) , BEHIND ACCESS 108 (1EA) , IN FRONT ACCESS 107 (1EA) AND FWD CORNER OF AISLE SIDE (1EA) ON GALLEY 1. FLOOR FITTING ACCESS 109 (1EA PN:CDSP2019-7C620 ) , BEHIND ACCESS 108 (1EA PN:CDSP2019-7C620), IN FRONT ACCESS 107 SDR VNAA202512186005Fitting · corrodedCORROSION FLOOR FITTING UNDER THE WASTE AND AISLE SIDE ON FWD LAVATORY. THE FLOOR FITTINGS WERE REPLACED IAW CMM 25-40-40.SDR YENA2025121801234Unknown · odorFLT 1141, BDL-PBI. ACFT FUMES AFTER TAKE OFF AND AGAIN ON DECENT, THROUGH 5000 FT, COMPLIED WITH INFORMATION NOTICE 2017-T015, SECTION A. ISOLATED FAULT TO TYPE 10, C. AMBIENT AIR, TRANSIENT ACCOMPLISHED TSM 05-50-00-810-085B, TSM 05-50-00-810-085-D. AIRCRASDR VNAA202512186004Floor Support · crackedCRACKED FLOOR SUPPORT, RBL 12, BTW BS 221.73 - 229. THE FLOOR SUPPORT WAS REPAIRED IAW REO 690-53-11-2087, REV -.SDR VNAA202512186003Web · crackedCRACK ON ELECTRICAL BAY FLOOR WEB, RT SIDE. BELOW ADG SUPPORT DOUBLER, BS 193. THE FLOOR WEB WAS REPAIRED IAW REO 670-53-11-509, REV E, & REO 690-53-11-2093, REV -.SDR VNAA202512186002Floorbeam · crackedCRACKED CENTER COCKPIT FLOORBEAM, LBL 12, BS 280. THE FLOORBEAM WAS REPAIRED IAW REO 690-53-11-2085, REV-.SDR VNAA20251216001Skin · dentedDENT ON EXTERNAL FUSELAGE SKIN BTW BS 280 - 295 AND S23 - 24L. THE SKIN WAS REPAIRED IAW REO 690-53-21-2060, REV -.SDR AALA202512185081Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT AT SEAT 32DEF INOP. MAINTENANCE REPLACED EMERGENCY AISLE LIGHT ASSY IAW AMM 33-51-03.SDR ASAA2025121663157Snubber · faultedINBOUND CREW REPORTED THAT THE CATERERS WERE UNABLE TO OPEN L2 DOOR. GROUNDED - YES. CLEANED L2 DOOR SNUBBER, CYCLED L2 DOOR OPS OKS GOOD WITH NO DEFECTS AT THIS TIMEPER AMM 52-13-00SEAMC ANDY NOTIFIED.SDR ASAA2025121663146Battery Pack · inoperativeR1 DOOR EMERGENCY EXIT LIGHTS FAILED OPS CHECK. GROUNDED - YES. REMOVED AND REPLACED WITH SERVIEABLE BATTERY OPS CHECK GOOD IAW B737-700 AMM 33-51-06-960-805. (S/N 425489)SDR ASAA2025121663116Power Supply · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1672 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY M1672 IAW B737 AMM 33-51-06-960-806 OPERATIONAL TEST GOOD. (S/N 116827)SDR ASAA2025121663115Power Supply · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1694 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED POWER SUPPLY M1694 IAW B737 AMM 33-51-06-960-806. OPERATIONAL TEST GOOD. (S/N 116928)SDR ASAA2025121663114Power Supply · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M2335 ARE INOP. GROUNDED - YES. REMOVED, REPLACED AND OPERATIONAL TEST PERFORMED SUCCESSFULLY OF THE POWER SUPPLY M2335 IAW B737-900 AMM 33-51-06-960-806. (S/N 113637)SDR IPXA2025121861336Fuel Tank · inoperative**SUPPLEMENTAL SDR** DURING FLIGHT FUEL TRANSFERRED FROM RH TANK TO CENTER TANK. LOOKS ABOUT 200 LBS PER HOUR. REMOVED AND REPLACED RH DEFUEL VALVE REF. UPS B757 AMM 28-26-01-004-144 AND 28-26-01-404-145. COMPLETED DEFUEL VALUE INSTALLATION WITH ADJUSTMENT LSDR DALA2025121809236Oxygen Box · faultedAFT LEFT LAV PSU MASK DROPPED. R & R O2 CONTAINER HOUSING ASSY PER A330 AMM 35-21. OK FOR SERVICE. (8215322)SDR 1JAA2025121800016Flex Hose · blew outLOSS OF SYSTEM A HYDRAULICS RESULTING IN AN EMERGENCY LANDING. UPON LANDING INSPECTION REVEALED A 3000PSI HYDRAULIC LINE JUST AFT OF GEAR HAD BLOWN OUT AND DUMPED THE A SYSTEM HYDRAULIC FLUID.SDR DALA2025121809208Skin · ground damage(LOG 1354528) FUSELAGE / SKIN, FRAME, AND STRINGERS / STA 927 / STR 15L TO STR 17L / GROUND DAMAGE. REPAIRED DAMAGE PER ERA 460383-14AD.SDR DALA2025121809207Latch · no test(LOG 8082592) WHILE WORKING WORKCARD 2560-2653, L1 DOOR FAILED RELEASE TEST. REPLACED L1 DOOR SLIDE LATCH ASSY PER B737 AMM 25-66.SDR AALA202512180607Battery · weakAIRCRAFT WAS NOT GROUNDED: AFT FA FLASHLIGHT AT L2 DOOR DIM. MAINTENANCE REPLACED BATTERY AS REQUIRED, OPS TEST GOOD.SDR AALA202512180989Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: ROW 24 & 25 EMERGENCY PATH LIGHTING INOP. MAINTENANCE FOUND WIRES AT CONNECTOR 7260VC9_A BROKEN OFF AT CONNECTOR. RE-TERMINATED WIRES AND RE-PINNED CONNECTOR IAW ESPM 20-48-21-0101 AND ASM 33-51-04.SDR AALA202512186707Accumulator · low pressureAIRCRAFT IN BASE MAINTENANCE: R/H AFT PASSENGER/CREW DOOR ACCUMULATOR LOW. MAINTENANCE SERVICED THE R/H AFT PASSENGER/CREW DOOR ACCUMULATOR BOTTLE IAW AMM 52-10-00-614-001-A.SDR AALA202512185772Accumulator · low pressureAIRCRAFT IN BASE MAINTENANCE: L/H AFT PASSENGER/CREW DOOR ACCUMULATOR LOW. MAINTENANCE SERVICED THE L/H AFT PASSENGER/CREW DOOR ACCUMULATOR BOTTLE IAW AMM 52-10-00-614-001-A.SDR AALA202512185641Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: 1063-LH EMERGENCY DOOR SIDEWALL LIGHT OFF. MAINTENANCE REPLACED FLUORESCENT TUBE PER AMM 33-21-11SDR AALA202512186935Bottle · out of rigAIRCRAFT WAS GROUNDED: CATERING IS UNABLE TO GET THE FRONT RIGHT DOOR FULLY OPENED AND LOCKED IN PLACE. MAINTENANCE REPLACED R-1 DOOR DAMPER /EMERGENCY CYLINDER PER AMM 52-11-14-400-001B.SDR AALA202512183397Light · missingAIRCRAFT IN BASE MAINTENANCE: MISSING EMERGENCY LIGHT ASSY ON PASSENGER SEAT 7D. MAINTENANCE INSTALLED EMERGENCY LIGHT ASSY ON PASSENGER SEAT 7D IAW AMM 33-51-05-960-802 STEP C.(1).(F) THRU (J) AND STEP.3.SDR AALA202512181561Outflow Valve · faultedAIRCRAFT GROUNDED: AN EMERGENCY DECLARED AT INITIAL CRUISE, RECEIVED ECAM CABIN PRESSURE SYS 1 FAULT FOLLOWED SHORTLY BY ECAM CABIN PRESSURE SYS 1 & 2 FAULT. CREW REPORTED CABIN PRESSURIZATION OPS IN MANUAL MODE OKAY. FLT CREW REPORTED DURING INITIAL DESCENT ISDR REXA2025121801047Rod · inoperativeUNABLE TO OPEN PAX DOOR REPLACED PAX DOOR VENT FLAP ROD ASSYSDR SCNA20251218495Lamp · inoperativeNO SMOKING LIGHTS INOP AT THE FOLLOWING SEAT LOCATIONS: 6D, 11D, 29D, 10A, 19A RELAMPED NO SMOKING LIGHTS 6D, 11D, 29D,10A,AND 19A REF AMM 33-25-00. OK FOR SERVICESDR CALA2025121812232Girt Bar · out of adjustR1 DOOR GIRT BAR HAS EXCESS FABRIC GOING TO SLIDE BIN. ADJUSTED THE GIRT BAR AND SLIDE ON R1 DOOR. NO FURTHER DEFECTS NOTED.SDR CALA2025121812231Elec Connector · unsecureR4 DOOR EPAS SENSOR STATUS MSG FOLLOWING FIM 62-10-F1-T7A-421A-A. INSPECTED R4 DOOR ARM AND DISARM SENSOR. FOUND CONNECTOR LOOSE. CLEANED SENSOR. PERFORMED OPS CHECK IAW AMM DMC-B787-A-52-11-21-03A-320A-A. OPS CHECKED GOOD. SYNOPTIC PAGE SHOWS CORRECT INFO SDR CALA2025121812222Battery Pack · no testEMERGENCY LIGHT BATTERY M1672 FAILS CAPACITY CHECK AND REQUIRES REPLACEMENT. REPLACED THE BATTERY M1672, OPS CHECKED GOOD IAW MM #33-51-06-200-801.SDR CALA2025121812221Battery Pack · no testEMERGENCY LIGHT BATTERY M1669 FAILED A CAPACITY CHECK & REQUIRES REPLACEMENT. REPLACED EMERGENCY BATTERY M1669, OPS CHECKED GOOD IAW MM 33-51-06-200-801.SDR CALA2025121812220Light · detachedEMERGENCY EXIT LIGHT HANGING DOWN IN SEAT 34C. SECURED THE LIGHT ASSY TO SEAT 34C, IAW MM 33-51-11, OPS CHECKED GOOD.SDR CALA2025121812210Shear Web · damagedMAIN CABIN SHEAR WEB AFT OF L2 DOORWAY AT BS 986 - 1016, LBL 32 HAD MULTIPLE ELONGATED FASTENER HOLES. THE SHEAR WEB TO BE INSTALLED ON GSO NRC 9288447 LOCATED AND DRILLED IAW SRM 51-40-05-0G-0.SDR CALA2025121812208Crease Beam · corrodedMAIN CABIN CREASE BEAM INNER CHORD UPPER SURFACE IS CORRODED FROM BS 940 - 947, RBL 56. R & R THE CREASE BEAM IAW DWG 147A8501, REV T, AND SRM 51-40-02.SDR CALA2025121812206Fitting · chafedR2 DOOR CUT FWD INTERNAL FITTING HAS A DEEP CHAFE BY LWR AREA OF BODY TORQUE. R & R THE R2 DOOR FWD INTERNAL FITTING IAW SRM 51-40-02-0G-0, DWG 147A8901, DWG 147A8101, AND DWG 147A0010.SDR CALA2025121812204Floor Support · corrodedMAIN CABIN FLOOR SUPPORT, LBL 44 BETWEEN BS 328 - 344 WAS CORRODED ON UPPER SURFACE JUST IN FRONT OF SEAT TRACK. R & R THE FLOOR SUPPORT IAW DWG 141A5730, REV A.SDR DALA2025121709204Longeron · corrodedCORROSION ON STRINGER 30 STA 997. REMOVED AND REPLACED DISCREPENT LONGERON 30 IAW SRM 53-20-05 (1354315)SDR DALA2025121709203Longeron · corrodedFOUND CORROSION ON LONGERON 30, BS 900 TO 936. REMOVED AND REPLACED DISCREPENT LONGERON 30 FROM IAW SRM 53-20-05 (1354312)SDR DALA2025121709202Longeron · corrodedAFT CARGO LONGERON 30 AT APROX STATION 1005 AND FWD CORRODED. REPAIRED ON NR 450 IAW SRM 53-20-05-2R PRO. 1, & BAC DWG 5919707. (1354309)SDR DALA2025121709201Skin · crackedLEFT FLAP TRAILING EDGE CRACK AND DELAMINATION. REPAIRED PER ER/A 631162-14. (8401817)SDR DALA2025121709199Lanyard · frayedFRAYED LANDYARD CABLE FROM L1 SLIDE DOOR. LANYARD CABLE FROM L1 SLIDE DOOR WAS REPLACED AND PART NUMBER WAS VERIFIED PER AIPC 25-61-01 AND INSTALLATION IS ACCOMPLISHED UNDER AMDS 5211-4002. (1354881)SDR SWIA2025121700016Skin · damagedFOUND DAMAGE TO SKIN, LOWER-FWD FUSELAGE, SKIN,FWD RT LATL,FWD FUSESLAT, UPPER FOWARD FUSELAGE., JUNCTION UPPER FWD FUS ASSY.170-05355-401, MACHINED,FRAME BS610, FWD. FUS,.170-00820-413, PRESSURE BULKHEAD ASSY STRUCTURE. 170-00811-519, LOWER FORWARD FUSELAGESDR UIEA2025121601349Pdu · warning messageFLAP DRIVE EICAS MSG. R & R LE FLAP PDU IAW AMM 27-81-05 & IPC 27-81-03-01. OPS CHKD OK.SDR WX0A2025121732675Power Supply · no test(AIRCRAFT NOT GROUNDED) ESPU FAILED CAPACITY CHECK, REMOVED AND REPLACED EPSU REF WO538329"SDR WX0A2025121732671Slide · partial deploy(AIRCRAFT GROUNDED) DURING R & R OF R1 DOOR SLIDE DOOR ASSIST DEPLOYED, SLIDE CAME OUT OF PACK DID NOT INFLATE. R1 DOOR SLIDE AND DOOR DAMPER AND EMERGENCY OPERATION CYLINDER RESTORED. SEE WO 538641 FOR MX PERFORMED. A/C OK FOR SERVICE IAW AMM 52-10-00-610-SDR AALA202512173165Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN AT ROW 17 FELL OFF. RESECURED EMERGENCY EXIT SIGN AT ROW 17.SDR AALA202512179117Fuel Sys · out of balanceAIRCRAFT WAS NOT GROUNDED: 1500LB FUEL IMBALANCE (RIGHT TANK LOW) AFTER TAKEOFF WITH FUEL IN THE CENTER TANK AND CENTER PUMPS OPERATING. HAD TO CROSS FEED MULTIPLE TIMES TO REBALANCE FUEL. (OPEN).