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 CALA2025090408452Bottle · no discrepancyPRESSURE GAUGE DOOR 2L IN RED CHECKING THE GAUGE FROM THE PROPER ANGLE, WITHIM LIMITS REF AMM 25-66-01-206-024SDR ASAA2025090260531Battery Pack · inoperativeWHILE WORKING TC 78233001 THE FOLLOWING DEFECTS NOTED: 1) RH FWD OWE GROUND ILLUMINATION LIGHT INOP. 2) L2 OVERDOOR & ASSOCIATED LIGHTS INOP. 3) 21-24 DEF EMERGENCY AISLE LIGHTS INOP. 4) LH OWE GROUND ILLUMINATION & ESCAPE LT INOP. 5) 18-22 ABC EMERGENCY AISLESDR 2025FA0000624Engine · bird ingestionON 09/2/25 WE WERE DEPARTING RUNWAY 21 AT KCNM. AT V1 DURING OUR TAKE ROLL WE HEARD A VERY AUDIBLE IMPACT OR “ THUD” AIRCRAFT RIGHT. THE IMPACT INDUCED A SIGNIFICANT RIGHT YAW. THERE WAS ALSO A MOMENTARY EICAS CAUTION MESSAGE. IT CLEARED BEFORE BEING ABLE TO ISDR AALA202509034806Slide Raft · faultedAIRCRAFT WAS NOT GROUNDED: DURING EPSU BITE CHECK, AFT L EPSU FAILS EXTERNAL AND INTERNAL LIGHT LOAD. MAINTENACNE REPLACED L4 DOOR SLIDE PER T/C 26L00025011.SDR AALA202509034446Indicator · brokenAIRCRAFT WAS NOT GROUNDED: FOUND L1 DOOR CABIN PRESSURE WARNING LIGHT DAMAGED. MAINTENANCE REPLACED L1 DOOR CABIN PRESSURE WARNING LIGHT REF AMM 52-73-22.SDR AALA202509031926Power Supply · no testAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING OPERATIONAL TEST OF EMERGENCY LIGHTING SYSTEM DURING SLIDE CHANGE FOUND RIGHT EPSU FAULT. MAINTENANCE REPLACED RIGHT CENTER EPSU IAW AMM 33-51-38.SDR AALA202509036566Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: INOP EPSU 13WL. MAINTENANCE REPLACED EPSU (13WL) P/N: 3214-54-10, S/N: 5245 IAW AMM 33-51-38-000-001-A AMM 33-51-38-400-001-A.SDR DALA2025090306532Stiffener · crackedCRACK FOUND ON HORIZONTAL UPPER STIFFENER OF LATERAL WINDOW FRAME AT FR4 RT. COMPLIED WITH ER/A 563906-14AD. (1178062).SDR DALA2025090306531Window Frame · crackedUPPER SURFACE OF LATERAL WINDOW FRAME AT FR4 RH SIDE CRACK INDICATION. COMPLIED WITH ER/A 563906-14AD. (7710258).SDR DALA2025090306530Bracket · crackedCRACK BRACKET TELESCOPIC DUCT OB FIXED LEADING EDGE IB SIDE LH WING. REPLACED BRACKET AND FASTENERS ON TELESCOPIC DUCT OB FIXED LEADING EDGE IB SIDE LH WING AS PER A319 SRM 51-72-11 AND A319 SRM51-42-11. (1178540).SDR AALA202509034347Coupling · brokenAIRCRAFT WAS NOT GROUNDED: FOUL LAVATORY LIKE ODOR IN THE FLIGHT DECK. FOUND FORWARD TOILET VACUUM LINE COUPLING BROKEN AND SEEPING INTO FLIGHT DECK. REPLACED COUPLING, PER AMM 38-32-01. OPERATIONAL CHECK GOOD NO LEAKS NOTED. ACCOMPLISHED WORK CARD SMOKE ODOR SDR AALA202509039979Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 23C EMERGENCY LIGHT PULLED OFF. CHECKED AND VERIFIED SEAT 23C EMERGENCY INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202509034003Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH HARD TO UNLOCK. SEVERAL PASSENGERS HAD TROUBLE GETTING OUT. ADJUSTED LAVATORY DOOR. PER AMM 25-40-00.SDR AALA202509037299Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR HARD TO OPEN. LUBERICATED DOOR, PER AMM 52-50-00.SDR AALA202509039158Tube · missingAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR GIRT BAR MISSING RED HEATSHRINK. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202509034969Pin · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT AND AGENT REPORTED HAVING A DIFFICULT TIME OPENING THE L1 DOOR. FOUND STOP PINS REQUIRED ADJUSTMENT. ADJUSTED PINS, PER AMM 52-11-00.SDR AALA202509034395Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR HARD TO OPEN. LUBED AFT RIGHT LAVATORY DOOR STRIKER. OPERATIONAL CHECK GOOD.SDR AALA202509035539Bustle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT FORWARD SERVICE SLIDE BUSSEL HAS 4 INCH GAP BETWEEN IT AND DOOR. FOUND R1 DOOR LOOSE SECURED R1 BUSSEL. PER AMM 25-66-01.SDR AALA202509032327Sign · missingAIRCRAFT WAS NOT GROUNDED: BACK SIDE OF EXIT SIGN ON CEILING ABOVE EXIT ROW 16 IS MISSING THE ARROWS POINTING TO OVER WING DOORS. REMOVED AND REPLACED EXIT SIGN. PER AMM 33-51-01.SDR AALA202509035297Pump · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FUEL PUMP LOW PRESSURE LIGHT NOT ILLUMINATING WITH PUMP TURNED OFF. FOUND TANK NUMBER 2 AFT FUEL PUMP LOW PRESSURE LIGHT INOPERATIVE. (OPEN).SDR AALA202509035848Girt Bar · dislodgedAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR SLIDE COMING OUT OF BUSSEL. RESECURED R1 DOOR SLIDE GIRT. PER AMM 25-66-01.SDR AALA202509031819Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT BY L2 DOOR IS INOPERATIVE. RELAMPED EXTERIOR EMERGENCY LIGHT BY L2 DOOR. PER AMM 33-51-04.SDR VNAA2025090311102Selector Valve · faultedGEAR DISAGREE ON LANDING NOSE DIDNT COME DOWN TURNED ON 3B CYCLED GEAR HANDLE BOTH MAINS CONFIRMED DOWN NOSE NOT DOWN HEARD BANG. AFTER CYCLING GEAR ALL 3 GEAR DOWN. EMERGENCY WAS DECLARED. / REMOVED AND REPLACED LANDING GEAR SELECTOR VALVE IAW CRJ 900 AMM 32ÂSDR HALA20250903271Hydraulic Line · leakingETOPS - AFTER PDC WALK AROUND MX FOUND HYDRAULIC LEAK ON ENG #2. LEAK WAS FOUND TO BE CHAFING ON ENG 2 EDP GREEN SYS SUCTION TUBE. REMOVED AND REPLACED SUCTION TUBE, LEAK CHECK GOOD A/C OK FOR SERVICE ALL WORK PERFORMED PER AMM 29-11-49SDR HALA20250903270Pump · faultedETOPS - AT CRUISE ECAM B SYS LO PR, FOLLOWED BY B RSVR LO LVL. ECAM ACTIONS COMPLETED, (SHUTDOWN B ELEC PUMP) NO FURTHER ACTIONS. REMOVED AND REPLACE BLUE ELECTRIC PUMP PER AMM 29-12-51. PERFORMED TEST OF BLUE ELEC PUMP PER AMM 29-12-00. TEST OK. NO LEAKS NOTESDR AALA202509030935Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS PRESSURE ON DOOR 4R IS INDICATING LOW. MAINTENANCE SERVICED THE 4R DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509033604Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 11WL BATTERY FAILED SYSTEM TEST, REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202509030213Fitting · stuckAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE AFT GIRT BAR FITTING ON FLOOR IS STUCK, DOES NOT SPRING LOAD BACK TO POSITION. MAINTENANCE LUBRICATED 1L DOOR GIRT BAR FLOOR MOUNTED FITTINGS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-62-00.SDR ABXA20250902206Seal · brokenDURING SERVICE CHECK SECURITY SEAL MISSING ON FIRST AID KIT. INVENTORY NON-COMPLIANT. MTX REMOVED AND REPLACED FIRST AID KIT IAW B767 AMM 25-64-03. AC COMPLIANT,SDR SCNA20250903349Lens · detachedEXIT ROW EMER EXIT LIGHT MISSING FWD EXIT SIGN. FOUND LENS FOR EXIT LOCATOR SIGN IN COMPARTMENT, RESECURED AT OVERWING POSITION IN REF AMM 33-51-00. OKAY FOR SERVICE.SDR SIMA20250902001A/C Pack · odorHORRIBLE BURNING SMELL IN COCKPIT AND CABIN ON CLIMB OUT RETURNED TO AIRPORT PACK 1 FAILED ON GROUND. EMERGENCY DECLARED PERFORMED OPC OF PACK 2 IAW AMM 21-62-00, OPC GOOD.REF AML PG 113401195-1, AML PG 113401196-1, AML PG 113401186-1 FOR WORK PERFORMED.SEE AMSDR 2025FA0000621Stringer · crackedPERFORMED INSPECTIONS PER AD-2023-12-18 IAW BOEING REQUIREMENTS BULLETIN 747-53A2907. IDENTIFIED CRACKS IN STRINGERS AT THE FOLLOWING LOCATIONS: STA 1740: S-13L, S-14L, S-14R, S-15R STA 1960: S-1L, S-2L, S-3L, S-4L, S-6L, S-8L, S-9L, S-10L, S-11L, S-12L, S-SDR 2025FA0000620Stringer · crackedPERFORMED INSPECTIONS PER AD-2023-14-03 IAW BOEING REQUIREMENTS BULLETIN 747-53A2911. IDENTIFIED CRACKS IN STRINGERS AT THE FOLLOWING LOCATIONS: STA 2598: S-4R, S-5R, S-25R, S-4L, S-5L, S-8L, S-10LSDR 2025FA0000619Pump · out of toleranceFUEL PUMP FAILED ON CRUISE, TURNED ON BOOST PUMP, CONTINUED MISSION AND LANDED SAFELY.SDR DALA2025090206516Wire · damagedEMERGENCY SEAT LIGHTS AT 5A, 44JH AND 56JH INOPERATIVE. REPAIRED WIRING IAW AMM 33-51. OK FOR SERVICE. (7064558)SDR DALA2025090206515Bottle · low pressureDOOR 4L ASSIST BOTTLE LOW. SERVICED DOOR ASSIST BOTTLE IAW AMM 52-15. OK FOR SERVICE. (7600979)SDR DALA2025090206505Seat Track · corrodedSEAT TRACK AT FR 74 LBL 23 HAD EXCESSIVE CORROSION. REMOVED AND REPLACED THE SEAT TRACK FROM FR 61 TO FR 74 IAW ASRP BD500-A-J51-42-21-00AAA-078A-A, AND DWG C01342701 REV - G. . (LP# 1177283)SDR DALA2025090206504Seat Track · corrodedSEAT TRACK AT FR 74 RBL 23 HAS EXCESSIVE CORROSION. REMOVED DAMAGED SEAT TRACK AT RBL 23 FR 60 TO FR 74 AND REPLACED WITH NEW SEAT TRACK IAW ASRP BD500- A-J51-42-21-00AAA-078A-A, AND DWG C01342701 REV - G. (LP# 1177127)SDR IPXA2025090267453Battery Pack · inoperativeEMER LT BAT 1 LO ON STATUS PAGE. R & R EMER SUPPLY BATTERY IAW AMM 33-51-01-401.SDR AALA202509027270Light · miswiredAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT IN CENTER CEILING PANEL ABOVE SEAT ROW 27/28 IS INOPERATIVE. MAINTENANCE FOUND THE EMERGENCY LIGHT MIS-WIRED AND CORRECTLY ATTACHED THE WIRES TO THE LIGHT PER AMM 33-51-00. A SATISFACTORY OPERATIONAL WAS ACCOMPLISHED SDR AALA202509026889Bottle · 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 FDEA202509021603Floor Panel · gougedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231LFF IS GOUGED. JM30 REPAIRED MAIN DECK FLOORBOARD PANEL # 231LFF, P/N 143T5869-127, AT STA 654- STA 784, LBL 11"- RBL 11" IN REF. TO SRM 53-00-50-2R REPAIR 1 FIG.201 SHEET 1. PANEL WILL BE REINSTALLED ON NR# 352 SDR FDEA202509021602Floor Panel · gougedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231QFF IS GOUGED. JM29 REPAIRED MAIN DECK FLOORBOARD PANEL # 231QFF, P/N 143T5876-19, AT STA 654- STA 784, LBL LBL 77.50"- 86.50", IN REF. TO SRM 53-00-50-2R REPAIR 1 FIG.201 SHEET 1. PANEL WILL BE REINSTALLED ON NRSDR FDEA202509021601Floor Panel · gougedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231PFF IS GOUGED. JM28 REPAIRED MAIN DECK FLOORBOARD PANEL # 231PFF, P/N 143T5876-129, AT STA 654- STA 784, LBL 54.75"- LBL 77.50" IN REF. TO SRM 53-00-50-2R REPAIR 1 FIG.201 SHEET 1. PANEL WILL BE REINSTALLED ON NRSDR FDEA202509021600Floor Panel · gougedMAIN DECK CARGO COMPARTMENT,FLOOR PANEL 241DFF IS GOUGED.JM27 REPAIRED MAIN DECK FLOORBOARD PANEL # 241DFF, P/N 145T5876-105, AT STA 731- STA 834, LBL 54.75"- LBL 77.50" IN REF. TO SRM 53-00-50-2R REPAIR 1 FIG.201 SHEET 1. PANEL WILL BE REINSTALL ON NR# 186 SDR DALA2025090206473Fuse · inoperative(LOG 7836602) EMERGENCY LIGHTS OUT AT END OF ROWS SEAT'S ROW 16, 17, AND 18. R/R FUSE AT LOCATION M1695 PER B737 33-51. OPS CHECK GOOD.SDR SCNA20250902348Coffeemaker · damagedPLACARD ON FORWARD GALLEY COFFEE MAKER IS BENT AND SHARP. SECURED FWD. GALLEY PLACARD AT COFFEE MAKER PER AMM 11-32-00SDR SCNA20250902346Glowstrip · crackedPHOTO-LUMINESCENT STRIP IS CRACKED AND PULLING UP NEXT TO SEAT 1C RESECURED PHOTOLUMINESCENT STRIP IAW AMM 33-51-15SDR IXXA20250902001Skin · corrodedREPAIR RIGHT WING UPPER SURFACE PANEL NO.1 WSTA 491 PART NUMBER 112N3101-14SDR HALA2025090200615Seat Track · corrodedSEAT RAIL COORODED AT CROWN AREA FR 73 TO 74 ADJACENT TO DR4 LT.