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 CALA2025102810637Skin · crackedCRACK INDICATION FOUND AND VERIFIED: R/H HORIZ STAB LOWER SKIN STA 120.30 MARKED #1 .900"L 17" AFT OF FRONT SPAR I/B OF I/B FASTENER ROW. EVALUATED CRACK ON LOWER SKIN AND CUT OUT DAMAGE AND REMOVED EXISTING DOUBLER AT STA 120 IAW SRM 55-10-01- 2R-11. FABRICSDR CALA2025102810635Skin · crackedCRACK INDICATION FOUND AND VERIFIED, R/H HORIZ ST AB LOWER SKIN STA 120.30 .800L 25.5" AFT OF FRONT SPAR I/B OF I/B FASTENER ROW. EVAL CRACK ON LOWER SKIN STA 120.30, 25.5 INCHES OF FRONT SPAR, CUTOUT DAMAGE AND REMOVED EXISTING DOUBLER AT STA 120 IAW SRM 5SDR ANCF2025102733Actuator · faultedAFTER TAKE OFF ENG 1 AND 2 BLEED FAULT ON THE OVERHEAD PANEL. RESET UNSUCCESFULLY. AFTER 5 MINUTES RESET SUCCESFULL BUT ON THE SD PAGE PRESS OUTFLOW VALVE DOES NOT REGULATE PRESS. THE VALVE ALWAYS WAS OPEN.SDR SWAA2025102726709Light · damagedPASSENGER CABIN SEAT ROW 24ABC TO GALLEY BALL MATE PHOTOLUMINESCENT STRIPS RIGHT AND LEFT SIDE WORN AND WATER DAMAGED<[01] R&R PHOTO LUMINESCENT STRIPS PER AMM 33-51-15;[02] INSPECTION C/W R&R PHOTO LUMINESCENT STRIPS PER AMM 33-51-15SDR SWAA2025102727408Lens · looseCENTER O'HEAD EMER EXIT SIGN LENS LOOSE. REINSTALLED LENS IAW MM 33-51-01.SDR SWAA2025102726831Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 7ABC AND AFT RH GALLEY. R & R EMERGENCY LIGHT BATTERY PACKS AT ROW 7ABC AND RH AFT GALLEY IAW AMM 33-51-06. OPS CHECK OK.;SDR SWAA2025102726581Nonskid · deterioratedPASSENGER CABIN FORWARD ENTRY DOOR SILL NONSKID DETERIORATED. R & R PASSENGER CABIN FORWARD ENTRY DOOR SILL NONSKID IAW SIP.SDR SWAA2025102726888Girt Bar · dirtyFWDD ENTRY GIRT BAR HARD TO DISABLE<[01] LUBRICATED PLATES AS REQ. PER S.I.P.SDR SWI2025F01461Skin · puncturedDAMAGE (PUNCTURE) BETWEEN FRAME 93 AND FRAME 94 AND S23R AND S21R FOUND TO BE OUT OF ALLOWABLE DAMAGE LIMITS. DAMAGE FOUND TO BE INSIDE 1 BAY AT LOCATION ABOVE. DAMAGE IS ONLY TO SKIN OF AIRCRAFT. DAMAGE DIMENSIONS ARE 2.123" LONG BY 1.733" WIDE. DAMAGE RESDR SWI2025F01460Skin · puncturedCOMPLY WITH REPAIR (ETD) TO DAMAGE (PUNCTURE) BETWEEN FRAME 93 AND FRAME 94 AND STRG 23RH AND STRG 21RH FOUND TO BE OUT OF ALLOWABLE DAMAGE LIMITS. DAMAGE FOUND TO BE INSIDE 1 BAY AT LOCATION ABOVE. DAMAGE IS ONLY TO SKIN OF AIRCRAFT. DAMAGE DIMENSIONS ARE SDR SWIA2025102700022Track · damagedCARGO DOOR UPPER FWD TRACK IS DAMAGED CAUSING CARGO DOOR ROLLER TO COME OUT OF TRACK. REMOVED AND REPLACED CARGO DOOR FWD TRACK ASSY IN REFERENCE TO AMM 52-31-00-400-801, SRM 51-40-11, SRM 51-42-06 & SRM 51-77-00 AND COMPLIED WITH RII TASK CARD 51-900-1003-SKSDR DALA2025102707877Light · inoperativeLEFT SEAT ROWS 34 AND 43 EEPL LIGHTS INOP. REPLACED LH SEATS ROWS 34 AND 43 EEPL LIGHTS IAW B767 AMM 33-51- 10-962-104. OP TEST GOOD. (1266172)SDR DALA2025102707838Transmitter · leaking(LOG 7403834) FAIRLY STRONG RAW FUEL ODOR IN THE FLIGHT DECK UPON SHUTDOWN OF #1 ENGINE. FOUND FUEL FLOW TRANSMITTER LEAKING. R/R TRANSMITTER PER B737 AMM 73-31. NO LEAKS OR FUEL SMELL PRESENT.SDR DALA2025102707844Battery · inoperative(LOG 7976721) FOUND ON SVC CHK EMERGENCY PATH LIGHTS FROM ROW 28-32 INOP. R/R EMERGENCY BATTERY (M2067) IAW B737 AMM 33-51. OPS CHK GOOD.SDR REXA2025102700964Lock · inoperativeCA WENT TO USE BATHROOM AND COMING BACK THE FLIGHT DECK DOOR WOULD NOT OPEN. CA TRIED TO SHIMMY THE DOOR AND IT DID NOT OPEN SO WE HAD TO TAKE THE HINGE PIN OUT. R/R COCKPIT DOOR LOCK ASSY IAW CMM 25-17-03 OPC GOODSDR DXTA2025102705400Unknown · odorNOTICED OIL/GREASE ODOR UPON TAKEOFF UNTIL LEVEL OFF (STRONG) AND THEN INTERMITTENTLY THE REST OF FLIGHT (FAINT). REPOSITIONED AIRCRAFT OUT OF HANGAR, RAN ENGINES AND VERIFIED NO OIL/ GREASE SMELL, WORK REF AMM 79-00-00 AND 21-61-00SDR DXTA2025102705410Flap System · out of rigON APPROACH, GOT A FLAPS FAIL AMBER CAS, WHEN SELECTING FLAPS 1. RAN QRC AND CAS EXTINGUISHED. SELECTED FLAPS 1 AND GOT THE FLAPS FAIL AMBER CAS AGAIN. DISCONNECTED FLAP POWER BOX CONNECTOR, DISCONNECTED LT & RT INBOARD FLEX SHAFTS FROM PCU'S, DISCONNECTED OBSDR SIMA20251022002Iru · faultedIRS 1 FAIL EMERGENCY DECLARED. RAR #1 MICRO IRU IAW ERJ AMM 34-26-01 OPS CHECK GOODSDR CALA2025102710574Channel · corrodedAFT CARGO, FOUND MULTIPLE POINTS OF CORROSION ON RT ZEE CHANNEL, BTW BS 867 TO 947. REMOVED AND REPLACED RT ZEE CHANNEL BTW BS 867 TO 947 IAW IAW SRM 53-00-53-2R-6, SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, AMM 51-21-41-370-80, AMM 51-21-72-37SDR CALA2025102710572Frame · corrodedFWD WET AREA RT, BS 328 RBL 27-53, FRAME HAS CORROSION AT FASTENER HOLES. REMOVED DAMAGE, FABRICATED, LOCATED, DRILLED REPAIR PARTS, HFEC AREA, NO CRACKS NOTED. INSTALLED REPAIR AND RESTORED COATING IAW SRM 53-10-51-2R-7, FIG 205, REPAIR 7, AND ECRA 5315-01SDR CALA2025102710568Skin · corrodedFOUND CORROSION R-1 DOOR ASSY UPPER GATE EXTERNAL SKIN AREAS WITH CORROSION. REMOVED AND REPLACED R1 DOOR UPPER GATE ASSEMBLY REF SRM 51-40-02-0G-0 AND DWG 141A6516.SDR CALA2025102710565Stub Beam · gougedR-1 DOOR HANDLE BOX CUTOUT UPPER TORQUE TUBE BUSHING STUB BEAM IS GOUGED. REMOVED STUB BEAM GOUGED IAW B737-900 SRM 51-40-02. INSTALLED NEW STUB BEAM IAW B737-900 SRM 51-40-02, BAC DWG 141A6523.SDR CALA2025102710560Oven · smokeFRONT GALLEY OVEN 204 STARTED TO SMOKE ELECTRIC PUNGENT SMELL LIGHTLY FILLED GALLEY. INSPECTED OVEN 204 AND OPS CHECKED IAW AMM 25-34-00-400-801-C4 STEP 8, COULD NOT RECREATE SMOKE OR BURNING SMELL AT THIS TIME. COULD NOT DUPLICATE ISSUES, OPS CHKD GOOD.SDR SWAA2025102426865Megaphone · inoperativeFWD GALLEY MEGAPHONE INOPERATIVE. REMOVED AND REPLACED FWD GALLED MEGAPHONE IAW SIP.SDR SWAA2025102427400Flashlight · inoperativeEMERGENCY FLASHLIGHT AFT GALLEY INOPERATIVE. REPLACED FLASHLIGHT BATTERY AFT GALLEY INBD POSITION PER AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025102426979Megaphone · inoperativeFORWARD MEGAPHONE INOPERATIVE. R & R FWD MEGAPHONE IAW AMM 25-64-00.SDR SWAA2025102426992Megaphone · inoperativeAFT F/A MEGAPHONE IS INOPERATIVE. REMOVED AND REPLACED MEGAPHONE IAW AMM 25-64-00.SDR SWAA2025102426711Skirt · wornAFT GALLEY SERVICE DOOR ESCAPE SLIDE SKIRT WORN AND FRAYED. REMOVED AND REPLACED PER AMM 25-66-01-401-NG.SDR SWAA2025102426718Girt Bar · out of adjustCABIN - FWD SERVICE DOOR SLIDE GIRT HANGS TOO LOW.<[01] ADJUSTED FWD SERVICE DOOR ESCAPE SLIDE GIRT BAR IAW AMM 25-66-01SDR SWAA2025102426713Girt Bar · out of adjustFWD ENTRY DOOR SLIDE GIRT HANGS TOO LOW.<[01] ADJUSTED FWD ENTRY DOOR ESCAPE SLIDE GIRT BAR IAW AMM 25-66-01SDR SWAA2025102426722Girt Bar · out of adjustCABIN - AFT ENTRY DOOR SLIDE GIRT HANGS TOO LOW. ADJUSTED AFT ENTRY DOOR SLIDE GIRT IN REF TO AMM 25-66-01.SDR SWAA2025102426723Girt Bar · out of adjustCABIN - AFT SERVICE DOOR SLIDE GIRT HANGS TOO LOW.<[01] ADJUSTED AFT SERVICE DOOR SLIDE GIRT IN REF TO AMM 25-66-01.SDR DALA2025102407795Access Panel · damagedFOUND FASTENER HOLE OUT OF ROUND AT TANK PLATE 520HB. REPAIRED REF ERA 629530-14 REV O (1265545)SDR DALA2025102407783Fitting · wornWEAR ON PIVOT FITTING ON AFT LOWER SIDE ON LEFT FWD OVERWING EMERGENCY EXIT DOOR. PIVOT FITTING ON AFT LOWER SIDE ON LEFT FWD OVERWING EMERGENCY EXIT DOOR WAS REPAIRED PER ER/A 629908-14 REV. ORIGINAL SECTION I: REPAIR INSTRUCTIONS AND PRI 629908-1-14 REV. 0.SDR DALA2025102407782Sill Drain · corrodedCORROSION ON THE CREASE BEAM AKA "MOP SEAL" AKA (THE O/B SUPPORT FOR THE O/B CABIN FLOOR PANEL), ON THE RIGHT SIDE FROM STA.1455 TO STA.1485. CORRECTIVE ACTION: CREASE BEAM HAS BEEN FOUND TO BE OUT OF LIMITS PER SRM 53-60-13- 1A-1 DETAIL VIII. NOMINAL .090 REMSDR AALA202510242798Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER IN RIGHT HAND ECS BAY AT STA 663.75, RBL 45.64. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202510242409Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER IN RIGHT HAND ECS BAY AT STA 663.75, RBL 31.83. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR QXEA2025102400330Module · malfunctionedFLIGHT 2268. IN CRUISE FLIGHT @ FLT 360 MASTER CAUTION & CAUTION MSG ON EICAS "ADS 1 FAIL." AUTO REVERSION TO ADS 3. MSG EXTINGUISHED AFTER AUTO REVERSION TO ADS 3. THIS OCCURED SIMULTANEOUSLY AS CAUTION MSG AUTOBRAKE FAIL. MSG EXTINGQUISHED. RETURNED TO FIELDSDR AALA202510240305Bleed Valve · defectiveAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT THE #2 ENGINE WAS SURGING BETWEEN 1.40-1.43 ABOUT ONCE A SECOND. FUEL FLOW FLUCTUATES 100 PPH. ENGINE 2 BLEED PRESSURE 14-38. N1 81.8-83.3. N2 STABLE. N1 VIB 0.7. MAINTENANCE REPLACED THE #2 ENGINE BLEED PRESSURSDR AALA202510247278Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-00.SDR AALA202510245726Solenoid · defectiveAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT THE NR 2 ENGINE WAS SURGING BETWEEN 1.40-1.43 ABOUT ONCE A SECOND. FUEL FLOW FLUCTUATES 100 PPH. ENGINE 2 BLEED PRESSURE 14-38. N1 81.8-83.3. N2 STABLE. N1 VIB 0.7. MAINTENANCE REPLACED THE #2 ENGINE BLEED PRESSSDR AALA202510243638Control Panel · fault messageAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS CONTROL PANEL AT THE L4 DOOR HAS MULTIPLE ISSUES. DOOR CLOSED LIGHT NOT INDICATING CORRECTLY, CABINET LIGHT INDICATORS SHOW FULL BRIGHT WHEN THEY'RE IN LOW, CIDS CAUTION LIGHT TURNS ON AND OFF APPROXIMATLEY EVERY 7SDR AALA202510241586Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-00.SDR P5CA2025102200094Power Supply · inoperativeMULTIPLE GEAR MESSAGES INCLUDING GEAR MONITOR, GEAR DISAGREE, AND GEAR DOOR AND GEAR WOULD NOT RETRACT. R & R PSEU & PERFORMED CMC GND TEST & ZONAL INSPECTION OF NOSE LANDING GEAR & NOSE LANDING GEAR DOOR IAW AMM 32-09-03/401 & AIPC 32-61-01-01, OPS CHK GOODSDR ABXA20251022276Fire Warning · false activationEICAS FIRE / OVRHT SYS LIGHT ILLUMINATED WHILE TURNING FINAL UNTIL BOTH ENGINES SHUT DOWN.. MAINTENANCE PERFORMED FIRE / OVHT SYSTEM 6 TC CHECK IAW FIM 26-11 FT 804. NO FAULTS NOTED AT THIS TIME. A/C REMAINS NO ETOPS. PERFORMED GVI OF LOOPS ON NR 1 ENGINE SDR CALA2025102410500Indication Sys · false indicationSUSPECT FUEL LEAK RT WING IAW FM PROCEDURES ACCOMPLISHED WALK AROUND WITH NO EXTERNAL LEAKS NOTED, RAN ENGS 5 MIN WITH NO EXTERNAL LEAKS NOTED. FOUND CENTER TANK REFUELING VALVE OPEN UPON ARRIVAL TO HANGER. ACCOMPLISHED FUEL STICK READING COMPARISON TO FUELSDR CALA2025102410490Slide · unpackedSLIDE AT POS 2L HAS A LOT OF MATERIAL COMING FROM UNDERNEATH THE SLIDE COVER INSTALLED SAFTEY PIN ON SLIDE. REPACKED Z FOLD ON L-2 SLIDE. REMOVED SAFETY PIN AND STOWED IN POUCH IN SLIDE.REF MM25-66-01-400-804. CHECK SLIDE EXPIRATION DATE AND SHIPPING / SAFETY SDR CALA2025102410489Slide · deployedPOTENTIAL PARTIAL SLIDE DEPLOYMENT NEAR GIRT BAR DOOR 1R ADD PICS REMOVED AND REPLACED R-1 SLIDE ASSY PER 737 AMM 25-66-01-000-802 803. RENDER SAFE C/W AND EMAILEDPARTS USED: 29-2566-9-0006, QTY :1ROTABLE PARTS CHG:TT # 1223979 SN OFF 0727 PN OFF 29-2566-9-000SDR CALA2025102410488Girt Bar · no discrepancyDOOR 1L HAS EXCESSIVE MATERIAL HANGING OUT OF SLIDE CONTAINER WH ICH IN TERFERES WITH GIRT BAR. INSPECTED DOOR 1L GIRT BAR MATERIAL FOUND TO BE WITH IN LIMITS GIVEN IN AMM 25-66-01SDR CALA2025102410487Guide Arm · lack of lubeMAIN CAB DOOR LIGHT ON DURING TAXI POST LANDNG CLEANED/GREASED GUIDE ARM AREAS REF AMM 52-11-21-400-802 AND AMM 12-25-11-640-801. OPEN AND CLOSED DOOR WITH NO FAULTS FOUND. LIGHT TURNED ON AND OFF WHEN COMMANDED