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 DALA2025092907025Engine · bird ingestionBIRD STRIKE NR 1 ENGINE TOP OF LEADING EDGE. SMALL FLOCK OF SMALL BIRDS NO ENGINE FLUCTUATION NO TEMP CHANGE. INSPECTED NR 1 ENGINE AND FOUND FEATHERS & BLOOD IN CORE 592343 WIP. PER A320 AMM 72-00-00-200-006-A INSPECTED ENG #1 NO VISUAL DAMAGE TO FAN BLADESDR I5PA2025092568805Module · faultedAPU PNEUMATICS INOP. R & R APU FLOW SENSING MODULE PER AMM. OPS CHECK NORMAL.SDR N6WA2025092711Seat Track · corrodedCORROSION ON RH OTBD SEAT TRACK BETWEEN FS847.00-FS977.00. REMOVE AND REPLACED RH OTBD SEAT TRACK BETWEEN FS847-FS977 IAW CRJ SRM 51-41-02.SDR N6WA2025092710Seat Track · corrodedCORROSION ON RH INBD SEAT TRACK BETWEEN FS847.00-FS977.00. REMOVE AND REPLACED RH INBD SEAT TRACK BETWEEN FS847-FS977 IAW CRJ SRM 51-41-02.SDR N6WA2025092709Seat Track · corrodedCORROSION ON LH INBD SEAT TRACK BETWEEN FS847.00-FS977.00. REMOVE AND REPLACED LH INBD SEAT TRACK BETWEEN FS847-FS977 IAW CRJ SRM 51-41-02.SDR N6WA2025092708Seat Track · corrodedCORROSION ON RH OTBD SEAT TRACK BETWEEN FS847-FS977. REMOVED AND REPLACED SEAT TRACK BETWEEN FS847-FS977 IAW CRJ SRM 51-41-02SDR N6WA2025092707Seat Track · corrodedCORROSION ON RH INBD SEAT TRACK BETWEEN FS847-FS977. REMOVE AND REPLACED RH INBD SEAT TRACK BETWEEN FS847-FS977 IAW CRJ SRM 51-41-02SDR AALA202509266419Tire · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 3 TIRE DAMAGED, FOUND THE WHEEL WITH PLIES SEPARATED, CARCASS INTACT STILL. AIRCRAFT EMERGENCY LANDED SAFELY AT YYZ. REMOVE AND REPLACED NUMBER 3 MLG WHEEL ASSEMBLY.SDR AALA202509268985Unknown · odorAIRCRAFT WAS GROUNDED: DURING TAKEOFF OUT OF DCA THERE WAS A VERY STRONG DIRTY, MUSTY, AND OILY SMELL THROUGH OUT THE ENTIRE AIRCRAFT. (OPEN).SDR AALA202509261636Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 10C EMERGENCY PATH LIGHT FIXTURE DANGLING FROM ELECTRIC WIRE. VERIFIED SEAT 10C EMERGENCY PATH LIGHT FIXTURE INOPERATIVE. (OPEN).SDR AALA202509264854Pump · malfunctionedAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD FUEL PUMP DOES NOT ILLUMINATE LOW PRESSURE WHEN TURNED OFF. CONFIRMED FAULT ON FORWARD LEFT HAND FUEL PUMP C/B PULLED AND COLLARD. (OPEN).SDR AALA202509260557Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN 16A MISSING. INSTALLED NEW EXIT ON SEAT 16A. PER AMM 33-51-02.SDR AALA202509262702Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS ABOVE SEATS 29ABC NEEDS TO BE REATTACHED. REATTACHED EMERGENCY LIGHT ABOVE SEAT ROW 29ABC, OPERATIONAL CHECKED GOOD. PER AMM 33-51-00.SDR AALA202509265484Light · detachedAIRCRAFT WAS NOT GROUNDED: LIGHT ABOVE OVERHEAD BIN AT ROW 25-27 (LEFT SIDE) IS DETACHED. RESECURED EMERGENCY LIGHT ABOVE OVERHEAD BIN ROW 25-27(LEFT SIDE).SDR AALA202509263272Slide · exposedAIRCRAFT WAS NOT GROUNDED: AFT LEFT AIRCRAFT DOOR EMERGENCY SLIDE PARTIALLY EXPOSED ABOVE GIRT BAR. RESECURED AFT LEFT DOOR SLIDE. PER AMM 25-66-00.SDR AALA202509266750Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO LOCK AND UNLOCK. THE DOOR FRAME IS BINDING. SECURED DOOR FRAME AT LAVATORY-D. OPERATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202509269982Door · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT AFT LAVATORY LEFT DOOR GETS STUCK. CLEANED AND LUBED AFTER LAVATORY DOOR. OPERATIONAL CHECK GOOD.SDR LR7A2025092503788Fitting · crackedDURING SCHEDULED B-1 CHECK UNDER JOB CARD HB5302, FOUND FITTING CRACKED ON RH FS858 BULKHEAD AT WL176, RBL63 / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001307481.SDR LR7A2025092503787Bumper · damagedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND LONGERON BUMPER DAMAGED AT FS862-1041, RBL62, WL185-267 . / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001314036.SDR LR7A2025092503786Fitting · corrodedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND RH LOWER LONGERON FITTING CORRODED AT FS737/817.0E, RBL62, WL144. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001312166.SDR LR7A2025092503785Bulkhead · crackedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND FS1041.5 RING SEGMENT VERTICAL BULKHEAD CRACKED AT RBL18.5, WL269. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001312165.SDR LR7A2025092503784Bulkhead · crackedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND FS1041.5 RING SEGMENT VERTICAL BULKHEAD CRACKED AT RBL8, WL269. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001312165.SDR LR7A2025092503783Stiffener · crackedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND FS864 STIFFENER CRACKED AT RBL62, WL198. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70.SDR LR7A2025092503782Longeron · corrodedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND RH SLOPING LONGERON CORRODED AT FS858, RBL61.625, WL190. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001309408.SDR LR7A2025092503781Rivet · looseDURING SCHEDULED B-1 CHECK UNDER JOB CARD HB2703, FOUND LEFT OUTBOARD FLAP LOWER TRAILING EDGE SKIN WITH LOOSE RIVETS AT OWFS87L. / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-12. NR# 1001308670.SDR LR7A2025092503780Bulkhead Web · crackedDURING SCHEDULED B-1 CHECK UNDER JOB CARD HB5302, FOUND FS990 BULKHEAD WEB CRACKED AT RBL0.5, RBL6, AND RBL9, WL280. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001308553.SDR LR7A2025092503779Cap · crackedDURING SCHEDULED B-1 CHECK UNDER JOB CARD HB5302, FOUND FS902 BULKHEAD OUTBOARD CAP CRACKED AT RBL64, WL216. / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-22. NR#1001307467.SDR LR7A2025092503778Bulkhead Web · crackedDURING ULTRASONIC SPECIAL NDI INSP IAW LOCKHEED SERVICE FLO CS1370999, FOUND FS93 CANTED BULKHEAD CRACKING IN THE WEB. DOCUMENTED ON KF AERO NDT RPT NDT25-1265 / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70.SDR DALA2025092607022Wire Harness · damagedSEAT 21B FLOOR PROXIMITY EMERGENCY PATH MARKING INOP. REPAIRED WIRING AND ASSY IAW AMM 33-51. (7866933)SDR DALA2025092607021Skin · ground damageFWD CARGO SURROUND SKIN, FR19, STR 37R - 39R, IMPACT DAMAGE. REPAIRED PER ERA 628935-00. (1217760)SDR DALA2025092607020Repair · not reportedFWD FUSELAGE, FR18 & 19, STGR 39RT, LOWER SKIN PANEL, DOUBLER REPAIR. COMPLIED WITH ERA 629171-14. (1217643)SDR DALA2025092607019Frame · damagedFRAME 64 FWD MISSING FASTENER AND DRILL START AT STR 1L AND FWD SIDE OF FRAME 64. REPAIRED PER ERA 627429-14 REV. ORIG. (1217497)SDR DALA2025092607017Skin · damagedSHIP 3310 LOWER SKIN PANEL P/N F5327060020000 DAMAGED BELOW STRG 39 R/H AT FR 19. REPAIRED PER ERA 629171-14 REV. ORIG. (1218232)SDR WX0A2025092632581Battery Pack · no test(AIRCRAFT NOT GROUNDED) BATTERY FAILED EPSU TEST / REMOVED AND REPLACED EPSU REF WO525309"SDR WX0A2025092632580Cover · detached(AIRCRAFT NOT GROUNDED) EXIT SIGN COVER R2 DOOR FELL OFF / INSTALLED NEW R2 FLOOR EXIT LIGHT LENSE COVER IAW 33-51-13-400-001-A.(M) PROCEDURES REVERSED.M151SDR YENA2025092600969Radar · inoperativeFLT#2288, JFK-AMS. (ETOPS) NR 2 WX RADAR INOPERATIVE. OPENSDR YENA2025092600967Sensor · failedFLT#1107, JFK-LHR. (ETOPS) "REF LOGPAGE 4491046 ITEM 1 AIR PACK 2 REGULATOR FAULT ( ECAM INDICATION ON BLEED PAGE PACK COMPRESSOR OUTLET TEMPERATURE ); REMOVED AND REPLACED PACK 2 COMPRESSOR OUTLET TEMP SENSOR PER AMM 21-61-11. OPS CK'D SATIS, NO FAULT MSG PRSDR DALA2025092607015Girt Bar · fodR3 DOOR DISARMED SLIDE LIGHT STILL ON. CLEANED AND CHECKED DOOR GIRT BAR AREA, NORMAL. CYCLED DOOR ARM /DISARM LEVER. OPS NORMAL. (6524482)SDR DALA2025092607014Control Module · faultedOPS DECISION TO DIVERT TO IAD FOR LONGER RUNWAY DUE TO SPOILERS EICAS MESSAGE. REPLACED 1L SPOILER CONTROL MODULE.SDR DALA2025092607013Snubber · out of toleranceIN REF AMDS 2040-0191-4R STEP 7 ROTARY SNNUBER PIN EXTENSION DIMENSION OUT OF L MITS AT R4 DOOR. ROTARY SNNUBER AT R4 DOOR WAS REMOVED PER B757-200 AMM 52-11 AND ROTARY SNUBBER AT R4 DOOR WAS INSTALLED PER B 757-200 AMM 52-11. (1217897)SDR DALA2025092607010Girt Bar · out of limitsTHE ENGAGEMENT BETWEEN THE GIRT BAR SLIDER AND FWD FLOOR FITTING WERE FOUND OUT LIMITS AT L4. GIRT BAR AT 1R DOOR WAS REPLACED PER AMDS 2561-01257-01E AND PER B757-200 AMM 25-66-10 AND P/N VERIFY PER B757-200 AIPC 25-66-05 AND TEST OF GIRT BAR AT R1 WAS PERSDR DALA2025092607009Girt Bar · out of limitsTHE ENGAGEMENT BETWEEN THE GIRT BAR SLIDER AND FWD FLOOR FITTING WERE FOUND OUT LIMITS AT R1 DOOR. GIRT BAR AT 1R DOOR WAS REPLACED PER AMDS 2561-01257-01B, AMM 25-66-10-201, AND P/N VERIFY PER B757-200 AIPC 25-66-05 AND TEST OF GIRT BAR AT R1 WAS PERFORMEDSDR DALA2025092607008Intercostal · corrodedCORROSION ON INTERCOSTAL BTW STGR 24 LH TO STGR 23 LH AND STA 927 TO STA 907 AT AFT CARGO COMPARTMENT. CORROSION LEVEL 2: INTERCOSTAL BTW STGR 24 LH TO STGR 23 LH AND STA 927 TO STA 907 AT AFT CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 51-40-02-0G. (12177SDR IPXA2025092645526Latch · faultedCOVER FOR YELLOW ENTRY DOOR LATCH PROTRUDES OUT AND WILL NOT CLOSE. DEFERRED MAIN ENTRY/SERVICE DOOR ARMING LEVER HINGED COVERS IAW MEL 52-11-2.SDR IPXA2025092546537A/C Pack · odorWITH APU ON, TURNING ON FIRST PACK WE ARE HAVING HEAVY OIL SMELL FUMES IN COCKPIT.SDR IPXA2025092638715Fuel Sys · malfunctionedAT 30 MIN OF FLIGHT, 0.5 OF FUEL FROM RIGHT TANK. NO CROSSFEED WAS USED. LT TANK SCAVENGE PUMP BEGAN PULLING CTR TANK FUEL AT 60% WHICH CAUSED 1500 LB IMBALANCE AT THE1 HR MARK.SDR IPXA2025092633383Lock · lack of lubeATB, CABIN DOOR UNLOCK MESSAGE AT 12500 WARNING AT 23000 DOOR UNLOCK OFF AT 7000 FT HANDLE SHOWED SMALL MOVEMENT PRESSURE WAS NORMAL AT GATE HANDLE VISUALLY SHOWS UNLOCKED ACCOMPLISHED RIG AND ADJUSTMENT OF FWD DOOR REF 52-10-20-501. FWD DOOR WAS WITHIN RIG. NSDR IXXA20280925055Bulb · inoperativeFORWARD FLIGHT ATTENDANT'S EMERGENCY CALL LIGHT IS INOPERATIVE. PLACED ON DEFERRAL 66475 MINIMUM EQUIPMENT LIST 23-41-01-04 CATEGORY B. DUE 28 SEPTEMBER 2025. REPLACED BULB AD ACCOMPLISHED SYSTEM TEST IN ACCORDANCE WITH B757 AIRCRAFT MAINTENANACE MANUAL 23-42-SDR UIEA2025092501245Pdu · burnedPDU NR 1 FOUND BURNED. REMOVED PDU NR 1, INSTALLED BLANKING PLATE, AND DEFERRED PDU NR 1. PERFORMED CONDITIONAL INSPECTION IAW AMM 05-51-56-200-801, NO FURTHER DEFECTS FOUND. TRANSFER TO DMI 238867 PER MEL 25-57-01 CAT D DUE DATE 23JAN26.SDR SWAA2025092617870Seal · crackedRIGHT HORIZONTAL STABILIZER FWD UPPER SLIDING SEAL CRACKED APPROX. 2 INCH ALONG TRACK. R & R RT HORIZONTAL STAB FWD UPPER SLIDING SEAL. IAW AMM 53-31-31.