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 SWAA2025081193106Lens · brokenSIDEWALL PANEL 231YHW EMERGENCY EXIT LIGHT LENS BROKEN<[01] REMOVED AND REPLACED SIDEWALL PANEL 231YHW EMERGENCY EXIT LIGHT IAW AMM 33-51-01-960-802 <BR>OPT. CHECK: GOOD;[02] VERIFIED CORRECTIVE ACTION COMPLETESDR AALA202508075931Stop Pad · wornAIRCRAFT IN BASE MAINTENANCE: R1 DOOR STOP PADS WORN AT AFT DOOR FRAME CUT OUT. INSTALLED NEW DOOR THRESHOLD STOP PADS. PER SRM 53-10-15 AND AIPC 53-13-00-39.SDR AALA202508075543Stop Pad · wornAIRCRAFT IN BASE MAINTENANCE: L2 DOOR STOP PADS WORN AT AFT DOOR FRAME CUT OUT. INSTALLED ALL NEW DOOR THRESHOLD STOP PADS. PER SRM 53-10-15 AND AIPC 53-13-00-39.SDR AALA202508074405Plate · wornAIRCRAFT IN BASE MAINTENANCE: L1 DOOR STOP PADS WORN AT AFT DOOR FRAME CUT OUT. REMOVED AND REPLACED WORN DOOR THRESHOLD STOP PLATES. PER SRM 53-10-15 & AIPC 53-13-00-39SDR AALA202508079271Stop Pad · wornAIRCRAFT IN BASE MAINTENANCE: R2 DOOR STOP PADS WORN AT AFT DOOR FRAME CUT OUT. INSTALLED NEW DOOR THRESHOLD STOP PAD. PER SRM 53-10-15, AIPC 53-13-00-39.SDR AALA202508051785Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO AT BS 867 AND LBL 15, FLOOR AND SIDE WALL SUPPORT CORNER ATTACH ANGLE CRACKED ON THE OUTBOARD SIDE AT FLOOR LEVEL. INSTALLED BRACKET. PER B737 AARD 51-00-05-1 AND BOEING DRAWING 149A8102 SHEET 19SDR AALA202508020199Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM Y1162.5 BTW FR68 AND FR69 AT AFT GALLEY AREA CORRODED AREA IS L= 0.537 IN W=0.258 IN D=0.030 IN. MAINTENANCE REPLACED FLOOR BEAM Y1162.5 LOC BTW FR68 TO FR69 AT AFT GALLEY IAW A319 SRM 51-72-11-911-001, DWG D5SDR AALA202507316991Potable Water · odorAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT POTABLE WATER SMELLS FUNKY. CONFIRMED POTABLE WATER SMELLS. FOLLOWED J/C 08T10038001, ACCOMPLISHED DISINFECTION WITH OZONE TRALER BLUE. PER J/C 08T10038006, NO SMELL NOTED AT THIS TIME.SDR AALA202507311253Girt Bar · dislodgedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR GIRT BAR NYLON LATCH CLIP HAS OUTER SLEEVE DISPLACED. INSTALLED NEW CLIP. PER AMM 25-66-01.SDR AALA202507319151Girt Bar · wornAIRCRAFT IN BASE MAINTENANCE: R1 DOOR ESCAPE SLIDE LOWER FABRIC WORN. REPAIRED ESCAPE GIRT SLIDE LOWER FABRIC ON R1 DOOR. PER AARD 25-66-00-2.SDR SWAA2025072992996Hinge · crackedWATER SERVICE DOOR; AFT HINGE CRACKED. REMOVED AND REPLACED WATER SERVICE DOOR; AFT HINGE IAW SRM 51-40-02-0G-0 AND IPC 52-49-00-02.SDR AALA202507297101Door Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) FROM BS 967 TO BS 986 AT RBL 48. REPLACED CHORD PER AARD 51-00-05-1.SDR CALA2025072907031Floor Support · crackedMAIN CABIN FWD WET AREA CRACKED AT INTERCOSTAL RBL 35" BETWEEN BS 312-328. REMOVED AND REPLACED INTERCOSTAL AT MAIN CABIN FWD WET AREA BETWEEN BS 312 TO 328 RBL 31.6 IAW SRM 51-40-02-0G-0 AND DWG 141A5400.SDR IPXA2025072313969Stringer · dentedMAJOR REPAIR, STRINGER 25L DENTED AT STA 1340. DISPLACED FRAME AT STATION 1340, STRINGER 25L FOR FOM. EO-94445-REQ1SDR AALA202507288095Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 948, LBL 24. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202507287876Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) FROM BS 967 TO BS 986 AT LBL 48. REPLACED CHORD PER SRM 53-70-51-1A-1.SDR AALA202507285093Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY SEAT ROW LIGHT IS INOP AT ROW 8ABC. MAINTENANCE REPLACED EEPL & HOUSING IAW CMM 25-22-52.SDR 2025F00168Motor · faultedUPON LANDING - CREW REPORTED- LO BRK PRESS & ANTI SKID INOP LIGHT CAME ON DURING TAXI, NORMAL BRAKES COULD NOT STOP THE AIRCRAFT AND USED EMERGENCY BRAKES.SDR 2025F00167Motor · faultedUPON LANDING - CREW REPORTED- LO BRK PRESS & ANTI SKID INOP LIGHT CAME ON DURING TAXI, NORMAL BRAKES COULD NOT STOP THE AIRCRAFT AND USED EMERGENCY BRAKES.SDR QMLA202507262079Cowling · failedA HAMMER WAS DISCOVERED ON THE ENGINE COWING DURING TAKEOFF AS IT ROLLED ONTO THE WINDSCREEN DURING TAKEOFF. SDR FORM SUBMITTED ON 07/23/2025.SDR DALA2025072405557Window Frame · cracked(LOG 1093958) R/H COCKPIT CO- PILOT SIDE WINDOW #1 FRAME HAS A CRACK IN UPPER CORNER. COMPLIED WITH REPAIR AT R/H COCKPIT CO-PILOT WINDOW #1 FRAME IAW ER/A 619132-14ADTR REV.A.SDR DALA2025072305541Fitting · corroded(LOG 1094749) FUSELAGE / STRINGERS / S-14L AND S-14R, FS 663.75 / SPLICES FOR ACCESS TO PICKLE FORK FITTING. ASSOCIATED ER/A 14-627733 ADDED FOR AC 3750.SDR DALA2025072305540Fitting · corroded(LOG 1094762) FUSELAGE / STRINGERS / S-10L AND S-10R, FS 674 / SPLICES FOR ACCESS TO PICKLE FORK FITTING. ASSOCIATED ER/A 14-627734 ADDED FOR AC 3750.SDR DALA2025072305539Cargo Track · corroded(LOG 1094621) CORROSION ON RH FITTINGS ABOVE STRINGER STA 727A, 727B, 727D, 727F, 727H, 747, 787, RBL 13 AT AFT CARGO COMPARTMENT. TIE TRACK (FLOOR STRINGER) RBL 13 BTW STA 727A TO 887 WAS REPLACED PER B737-800 SRM 51-40-02-OG PAR 7 AND PAR 9 AND DWG. 146A7501SDR DALA2025072305538Power Port · cracked(LOG 1094341) POWER RECEPTICLE CUTOUT FWD EDGE HAS CRACK. ACCOMPLISHED FUSELAGE SKIN REPAIR OF ELECTRICAL GROUND POWER RECEPTACLE DOUBLER AND FUSELAGE SKIN IAW B 737 SRM 53-10-15-2R REPAIR 5.SDR DALA2025072305537Floor Support · corroded(LOG 1093979) CORROSION AROUND FASTENER HOLES IN FWD CARGO COMPARTMENT FLOOR STRUCTURE SUPPORT INTERCOSTAL, BS.500E-BS.500F STR.26R. REMOVED AND REPLACED INTERCOSTAL AT FWD CARGO R/H SIDE STA 500E-500F STR 26R IAW B 737 SRM 51-40-02.SDR DALA2025072305536Transition Panel · corroded(LOG 1093973) FWD CARGO RH TRANSITION PANEL BS 500 - 500A HAS CORROSION. REMOVED AND REPLACED PANEL AT FWD CARGO R/H TRANSITION PANEL BS 500 IAW B 737 SRM 51-40-02.SDR DALA2025072305535Skin · corroded(LOG 1093284) CORROSION WAS FOUND ON SKIN AFTER REMOTION OF AIRPHONE ANTENNA NO.1, ALSO CORROSION ON INTERNAL SUPPORT EDGE BTW STA 747 AND STA 767 BTW S-27L AND S-27R AT AFT LOWER FUSELAGE. SKIN BTW STA 747 AND STA 767 BTW S-27L AND S-27R AT AFT LOWER FUSELAGESDR YENA2025072300749Unknown · odorFLT#1454, SJU-FLL. "FA'S REPORT ELECTRICAL ODOR DURING LANDING AFTER ARRIVING AT THE GATE (FWD GALLEY); INSPECTED L & R AVIONICS COMPT, INSPECTED FLT DECK CB'S, GALLEYS' CB'S, COFFEEMAKERS, WITH NO ODOR PRESENT. ACCOMPLISHED TSM 24-00-00-810-823-1 WITH NO 30 DSDR UIEA2025071900978Engine · damagedENG #3 SEVERE DAMAGE. NO OIL QUANTITY. REMOVED AND REPLACED #3 ENGINE IAW AMM 71-00-02-004-001-J00. PERFORMED ENGINE TEST RUN IAW AMM 71-00-00-700-801-J00 TEST #3. ALL OPS SATISFACTORY AND NO LEAKS OBSERVED. REF W/O 149634.SDR SWAA2025072293263Lavatory · odorODOR IN AFT LAV SMELL STRONGEST ON CAPT SIDE AFT LAV DESCRIBED AS SMOKE SMELL, STRONGEST ODOR AT ROW 29. PERFORMED INSPECT IAW AMM 05-51-56 & IFIM 21-00-00-810-830. FOUND FOUL ODOR FROM AFT LT LAV. PERFORMED TOILET ASSY & SURROUNDING AREA CLEANING PER SIP. SDR SWAA2025072293073Lamp · inoperativeLT FWD ENTRY DOOR OUTSIDE EMERGENCY LIGHT INOPERATIVE. RELAMPED AND PERFORMED GOOD OPS CHECK OF LT FWD ENTRY SLIDE/OVERWING EMERGENCY LIGHT PER AMM 33-51-04-960-801.SDR SWAA2025072292810Handle · looseFWD ENTRY DOOR LINER ASSIST HANDLE LOOSE. RESECURED FWD ENTRY DOOR LINER ASSIST HANDLE IAW AMM 52-11-31.SDR SWAA2025072292973Fairing · crackedRH PYLON STRUT IMBD AFT FAIRING PANEL CRACKED AT LOWER EDGE.<[01] REMOVED AND REPLACED ACCESS PANEL IAW SRM 51-40-02 AND SRM 51-20-07SDR SWAA2025072293080Structure · crackedRH PYLON TRAILING EDGE ASSY CRACKED. R&R RH ENGINE PYLON TRAILING EDGE ASSY PER SRM 51-40-02SDR IPXA2025072016626Seat · sparksCAPTAINS ELECTRIC SEAT ADJUST SPARKED AND SMOKED MID FLIGHT. SEAT WAS TURNED OFF AND MANUAL ADJUSTMENT USED REMAINDER OF FLIGHT. REPLACED CAPTAIN SEAT IAW AMM 25-11-01/401 REV. 48 PN OFF: 3A258-0041-01-2 SN OFF: 93659 PN ON: 3A258-0041-01-2 SN ON: 100669SDR DALA2025072205493Seat Track · corrodedREAR BARREL SEAT TRACKS. AT RH FR 71 IB MULTIPLE AREAS OF CORROSION ON THE SEAT TRACK (M). SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0584:5300-2015/002 00502 REPLACED SEAT TRACK REF. A220 DWG C01342700 AND A220 ASDR AALA202507229955Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202507223087Strut · dischargedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHL DUE TO THE FLIGHT CREW REPORTING A LANDING GEAR SHOCK ABSORBER FAULT AFTER RETRACTION AND GEAR WAS SLOW TO COME UP. THE AIRCRAFT LANDED SAFELY AT PHL WITHOUT FURTHER INCIDENT. MASDR AALA202507222557Wire · disconnectedAIRCRAFT IN BASE MAINTENANCE: FORWARD LEFT OVERHEAD BIN EMERGENCY LIGHTS INOPERATIVE. CONNECTED WIRE HARNESS ON FORWARD LEFT OVERHEAD BIN EMERGENCY LIGHTS. PER AMM 33-22-00. OPERATIONAL CHECK GOOD.SDR AALA202507225513Light · missingAIRCRAFT WAS NOT GROUNDED: NUMBER 3 HORSESHOE BULLNOSE PANEL IS MISSING EMERGENCY LIGHT. REPLACED MISSING NUMBER 3 HORSESHOE BULLNOSE PANEL EMERGENCY LIGHT LOCATED ABOVE SEAT ROW 23. PER AMM 33-22-00. OPERATIONAL CHECK GOOD.SDR AALA202507225128Light · disconnectedAIRCRAFT WAS NOT GROUNDED: LEFT OVERHEAD BIN EMERGENCY LIGHTS INOPERATIVE AT ROW 14. CONNECTED LEFT OVERHEAD BIN EMERGENCY LIGHTS AT ROW 14. PER AMM 33-22-00. OPERATIONAL CHECK GOOD.SDR AALA202507220832Life Line · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND LIFE LINE ON EMERGENCY OVER WING EXIT DOOR IS WORN BEYOND LIMITS. REMOVED WORN DAMAGED LIFE LINE AND REPLACED WITH A NEW SERVICEABLE LIFE LINE. PER AMM 25-61-10-400.SDR AALA202507221334Light · disconnectedAIRCRAFT WAS NOT GROUNDED, FORWARD LEFT OVERWING EXIT LIGHT INOPERATIVE, CONNECTED FORWARD LEFT OVERWING EXIT LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA202507221937Light · disconnectedAIRCRAFT IN BASE MAINTENANCE: FORWARD RIGHT OVERHEAD BIN EMERGENCY LIGHTS INOPERATIVE AT ROW 12. CONNECTED FORWARD RIGHT OVERHEAD BIN EMERGENCY LIGHTS AT ROW 12. PER AMM 33-22-00, OPERATIONAL CHECK GOOD.SDR AALA202507221027Light · inoperativeAIRCRAFT WAS NOT GROUNDED: MAIN CABIN, EMERGENCY PATH LIGHTING AT SEAT 1B INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 1B. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202507225584Light · inoperativeAIRCRAFT WAS NOT GROUNDED: CEILING OVER WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED CEILING OVERWING EMERGENCY LIGHT. PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR KCSA2025071939Battery · inoperativeRIGHT UPPER DECK DOOR BATTERY "OK LIGHT" INOPERATIONAL. COMPLIED WITH PLACARD INSTALLED. RIGHT UPPER DECK DOOR BATTERY LIGHT. OPERATIONS CHECK GOOD IAW B747-400 AMM 51-23-14.SDR DALA2025072205492Pump · leakingSHIP 3304 - DE - DECLARED EMERGENCY DUE TO GREEN HYDRAULIC SYSTEM LEAK ECAM MSG AND LOSS OF QUANTITY. CORRECTIVE ACTION: REPLACED #1 AND #2 ENG EDP PUMPS AND RETURN LINE ELBOW ON #1 ENG. OPS AND LEAK CHECK GOOD. (7072450)SDR CALA2025072206843Actuator · faultedAT 60 KTS ENG 2 COMP VANE ECAM ON TO PULLED PFR. SEE PHOTO. INSTALLED RIG PIN INTO FRONT OF BEARING HOUSING CRANK UP TO SUB TASK D (3). WORK ACCOMPLISHED ON LOG 5549419, REMOVED ACC ACTUATOR REF MM 75-24-52-000-010-A PARTS USED: 00-0594-3-2278,QTY :1 31-7520-9