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 SWAA2025111334383Lamp · inoperativeAFT ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS AFT ENTRY DOOR EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-04.SDR SWAA2025111334137Lamp · inoperativeAFT ENTRY DOOR ESCAPE SLIDE LIGHT INOPERATIVE. R & R THE LAMP AT AFT ENTRY DOOR ESCAPE SLIDE IAW AMM 33-51-04.SDR SWAA2025111334131Light · inoperativePASSENGER CABIN LT EMERGENCY EXIT DOOR LIGHT INOPERATIVE. R & R CABIN OVERWING EXIT LIGHT PER AMM 33-51-04.SDR FDEA202511122167Circuit Breaker · faultedR1 DOOR INTERIOR EMERGENCY EXIT LIGHT WILL NOT TEST. TROUBLESHOT RT EMERGENCY EXIT SIGN FAULT IAW WDM 33-51-12. RESET EMERGENCY LIGHT CIRCUIT BREAKER IAW MM 20-60-01-2. RT EMERGENCY EXIT SIGN OPS CHECKED NORMAL IAW MM 33-51-01-2.SDR FDEA202511122166Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BETWEEN BS 698 AND STGR 32/33L. LIGHTNING STRIKE ON FUSELAGE SKIN BTW STGR 32L AND STGR 33L AT STA 698 WAS REPAIRED IAW SRM 53-00-01-2R, REPAIR 29, REV 93 AUG 15, 2025.SDR FDEA202511122165Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BETWEEN BS 676 AND STGR 32/33 LH. LIGHTNING STRIKE ON FUSELAGE SKIN BTW STGR 32 LT AND STGR 33 LT AT STA 676 WAS REPAIRED IAW SRM 53-00-01-2R REPAIR 29 REV. 93 AUG 15,2025.SDR GTIA2025111339176Unknown · odorFLIGHT ATTENDANT REPORTED WET TOWEL SMELL FEW MINUTES BEFORE GEAR EXTENSION THROUGH TAXIN AFTER LANDING. ON GROUND AFT FA REPORTED SMELL WENT AWAY ON TAXI IN BUT FWD FLIGHT ATTENDANT SAID SMELL PERSISTED. NO SMELL NOTED BY CA/FO NR 2 PACK TURNED OFF FOR TAXI ISDR DALA2025111308341Longeron · crackedAFTER LEFT WHEEL BIN REMOVAL FOUND CRACK IN CENTER LONGERON MFG P/N C02382111-001S. PERFORMED HFEC ON CRACK IN CTR LONGERON IAW A220 ANDTP 51-01-08- 01AAA-A. MARKED ENDS OF CRACK INDICATION AS REQUESTED BY MTC. ( 907014). REMOVAL OF LONGERON IN PROGRESS (77288SDR IPXA2025111341703Engine · oil consumptionINFLIGHT SHUTDOWN, EMERGENCY DECLARED. DURING CRUISE AT APPROX 3.5 HRS INTO FLT. ENG 4 OIL QTY BEGAN TO DROP FROM 5 QT TO ZERO IN 25 MINS. OIL PRESS WAS NORMAL UNITL AT REACHED ZERO. WHEN OIL PRESS INDICATED RED LINE. ENG WAS SHUT DOWN. PERFORMED ENG RUN CHSDR AALA202511133848Actuator · inoperativeAIRCRAFT WAS GROUNDED: DURING FLIGHT THE FUEL CENTER TANK RIGHT TRANSFER FAULT PUMPS WENT INOPERATIVE. THERE WAS 6,000 LBS OF FUEL IN CENTER TANK. FLIGHT CREW FOLLOWED ECAM INSTRUCTIONS. ABOUT AN HOUR LATER WITH ABOUT 1500 LBS INTHE TANK THE PUMPS STARTED WORKSDR AALA202511130519Battery · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT 3L TEST LIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA202511130263Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FOR EMERGENCY POWER SUPPLY UNIT 12WL FAILED BITE TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202511135613Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TOP SKIN PANEL UPPER SURFACE AT RIB 5 AND THE REAR SPAR. REPAIRED SKIN PANEL PER EA 368796.SDR ABXA20251112295Warning Message · illuminatedON CLIMB OUT, RECEIVED AILERON LOCKOUT EICAS MESSAGE. AFTER LANDING, MTX DEFERRED AILERON LOCKOUT SYSTEM IAW MEL ABX 27-11-2 PLACARD INSTALED MX PROCEDURES ACCOMPLISHED. AIRCRAFT RETURNED TO SERVICE.SDR DALA2025111308339Wire · damagedSEAT 4A EMERGENCY LIGHT INOPERATIVE. REPLACED ASSY AND REPAIRED WIRING IAW AMM 33-51. OK FOR SERVICE. (8105152)SDR DALA2025111308337Stringer · gougedSTRINGER 1R GOUGED ON OUTBD SIDE JUST FWD OF FRAME 64. REPLACED FRAME PER A330 SRM 53-11. (1301142)SDR DALA2025111308336Frame · damagedFRAME 49 AT STRINGER 7R NOTED WITH TOOLING DAMAGE ON FWD SIDE. REPAIRED PER ER/A 628197-14 REV ORIGINAL. (1300594)SDR DALA2025111308335Wire Harness · pinchedWIRE HARNESS PINCHED INSIDE CLAMP AT WAP NR 2, C31. CAUSED WIRE TO GROUND OUT AND ARC AGAINST CLAMP. REPAIRED WIRE HARNESS (WIRE 2456-5260) PER A330 ESPM 20-53-29. (1301310)SDR DALA2025111308327Girt Bar · fodESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHT/S/ 1L DOOR SLIDE LIGHT INOP. CLEANED DEBRIS AROUND GIRT BAR ARMED/DISARMED SEVERAL TIMES OPS NML REF B757 AMM 25-61. (1300827)SDR DALA2025111308326Reservoir · out of toleranceIN REFERENCE TO AMDS 5211-3001-1L: POWER RESERVOIR OF 1L DOOR WAS FOUND WITH LOWER PRESSURE. RESERVOIR ASSY OF L1 DOOR WAS REMOVED AND SERVICEABLE RESERVOIR ASSY WAS INSTALLED PER B757-300 AMM 52-11-30. (1300018)SDR DALA2025111308325Floor Support · corrodedIN REF NRC 00273: CORROSION OUT OF LIMITS ON FLOOR SUPPORTS STA 1470 RBL 2.9. PER B757-300 SRM 53-00-53-1A PROCEDURE 1 ALLOWABLE DAMAGE 1 FIGURA 101 NOTE C DETAIL IX AND B757 NDT MANUAL PART 4, 51-00-10 PROCEDURE 2. CORROSION LEVEL 2: FLOOR SUPPORTS STA 147SDR DALA2025111308323Life Raft · damagedDURING SERVICE CHECK FOUND AFT LIFE RAFT PRESSURE GAUGE UNREADABLE. REMOVED AND REPLACED AFT LIFE RAFT PER B757 AIPC 25-64-00-01G, SHEET 1, ITEM 20. (7937887)SDR DALA2025111308320Strap · crackedCRACK STRAP ASSY ELEVATOR HINGE ARM 1 ON LT HORIZONTAL STABILIZER. REPLACED STRAP ASSY ELEVATOR HINGE ARM 1 ON LT HORIZONTAL STABILIZER AND FASTENERS AS PER SRM-51-42-11 AND AS PER SRM-51-72-11. (1301316).SDR DALA2025111308319Strap · crackedCRACK STRAP ASSY ELEVATOR HINGE ARM 4 ON RH HORIZONTAL STABILIZER. REPLACED STRAP ASSY AND FASTENERS ELEVATOR HINGE ARM 4 ON RH HORIZONTAL STABILIZER AS PER A319 SRM 51-42-11 AND SRM: 51-72-11. (1301375).SDR DALA2025111308318Stringer · corrodedCORROSION STRINGER 38R LOCATED BTW FR 59 TO FR 60 IN AFT CARGO COMPARTMENT. REPLACED STRINGER 38R LOCATED BTW FR 59 TO FR 60 IN AFT CARGO COMPARTMENT AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1301361).SDR DALA2025111308317Strap · crackedCRACK STRAP ASSY ELEVATOR HINGE ARM 2 ON LH HORIZONTAL STABILIZER. REPLACED STRAP ASSY ELEVATOR HINGE ARM 2 ON LH HORIZONTAL STABILIZER AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1301350).SDR DALA2025111308316Web · crackedCRACK WEB LOCATED FLOOR STRUCTURE FROM FR68 TO FR69 AND STR23RH AT AF T GALLEY AREA. REPLACED WEB LOCATED FLOOR STRUCTURE FROM FR68 TO FR69 AND STR23RH AT AFT GALLEY AREA AS PER A319 SRM 51-42-11 AND AS PER A319 SRM 51-72-11. (1301335).SDR DALA2025111308315Stringer · corrodedCORROSION STRINGER 42R AT LEVEL FR60 IN AFT CARGO COMPARTMENT. REPLACED STRINGER 42R AT LEVEL FR60 IN AFT CARGO COMPARTMENT AS PER SRM 51-42-11. (1301326).SDR DALA2025111308321Skin · dentedRIGHT WING SLAT NR 1 L/E AREA SKIN DENTED BETWEEN RIB 5 AND RIB 8. PERFORMED DENT FILLER REPAIR AT SLAT NR 1 TOP SKIN NOSE SECTION IAW SRM TASK 57-40-00-300-106. (1301315).SDR YENA2025111301101Fire Loop · faultedFLT 2724, LAX-JFK. (ETOPS) ENG 1 FIRE LOOP B FAULT PRESENTED ON CLIMBOUT THROUGH OUT FLT 180; (RESOLVED ON W/O: 1456657 TASKCARD: NR-00002) CONTACTED MCC AND WAS INFORMED TO CLEAR THIS MEL DUE TO NO FAULTS SINCE MX ACTION WAS PERFORMED ON 11/13/25 MDDR CLEARESDR AALA202511132460Support Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT VACUUM WASTE TANK ENCLOSURE SUPPORT BRACKET AT BS 867, LBL 18. REPLACED BRACKET PER SRM 51-40-02.SDR AALA202511131110Guide · out of trackAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS LEFT SIDE AFT LAVATORY DOOR JAMS WHEN ATTEMPTING TO OPEN AND CLOSE. FOUND LAVATORY DOOR GUIDE OUT OF TRACK. REINSTALLED DOOR GUIDE.SDR AALA202511132337Track · bentAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR WILL NOT OPEN FROM THE INSIDE. FOUND LEFT AFT LAVATORY DOOR UPPER TRIM HAS LOOSE SCREWS AND BENT TRACK. RESHAPED TRIM RAIL TRACK AND SECURED RAIL FASTENERS. OPERATIONAL CHECK GOOD. PER 737 MM 25-40-14.SDR AALA202511132591Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY-D DOOR. PER AMM 25-40-00. OPERATIONAL CHECK GOOD.SDR YENA2025111301100Unknown · odorFLT#123, JFK-LAX. AFTER PARKING TOW INFLIGHT CREW MEMBERS REPORTED DIRTY SOCK SMELL IN THE AFT GALLEY FROM DESCENT THROUGH 10,000 UNTIL TOUCHDOWN. APU WAS OFF. ENTERED A CLOUD LAYER AT ABOUT 5,000' TILL 400' , SMELL INTENSITY REPORTED AS MILD. ONE FWD FA ALSOSDR YENA2025111301099Skin · corrodedDURING HEAVY MAINTENANCE: FUSELAGE / REAR FUSELAGE/ VENT OUTLET SKIN / BTW FR69/70 & STGR31/33 / CORROSION - PERMANENT REPAIR; REFERENCES: /1/ STS EA 160-2025-02 REV IR_DRAFT /2/ AIRBUS RDAF 81686597/003/2025#A. ENGINEERING FERRY CONCURRENCE ECA-321. DESCRIPTSDR SIMA20251112001Unknown · odorPAX AND FA AS WELL AS A OFF LINE PILOT REPORTED VERY STRONG SMELL COMING FROM THE CABIN THAT BEGAN AS WE TOOK OFF FROM ORD AND WAS INTERMITTENT THROUGH OUT DESCENT MOST PEOPLE INCLUDING OFF LINE PILOT DESCRIBED IT AS A HOUSEHOLD HEATER THAT HAS NOT BEEN USED USDR CALA2025111311173Fuse · failedFOUND FIRST CLASS EMERGENCY AISLE LOGHTS INOP TESTED FUSES IN REF TO AMM 33-51-06-960-801, FOUND ONE BAD. REPLACED FUSE, OPS CHECK GOODSDR CALA2025111311172Light · no testEMERGENCY LIGHTS - OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - SEAT 10C EPL MOUNT BROKEN AND HANGING DOWN. (LIGHT FUNCTIONS NORMALLY) REPLACED ENDBAY BUMPER AND EPL HOUSING ON SEAT 10C REF CMM 25-22-52-4675.SDR CALA2025111311171Light · detached52F EMERGENCY PATH LIGHTING DAMAGED INSPECTED EMERGENCY LIGHT AT 52F, FOUND LIGHT HANGING FROM THE HOUSING. RESECURED EMERGENCY LIGHT INTO THE HOUSING.SDR CALA2025111311170Light · no testEMERGENCY LIGHTS, OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - ROWS 8 TROUGH 12 EMERGENCY FLOOR PROXIMITY LIGHTS INOP. REPLACED FUSE AT POWER SUPPLY - FUSE REPLACEMENT REFERENCE: TASK 33-51-06-960-804. CHECK OPS IS GOOD TEST PASSED.SDR CALA2025111311169Battery Pack · dischargedSOME PROXIMITY AND AREA EMERGENCY LIGHTS DONT COME ON. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS M33401; M33096 AND M33098 REF AMM33-51-00.SDR 3GWA2025111200270Engine · overtempAT FL380, DESCENDED TO FL240. DISCONNECTED THE AUTOTHROTTLES & PULLED THE ENGS TO IDLE. ACFT STARTED TO SHAKE WITH A LOW FREQUENCY. IMMEDIATELY CHECKED IF SPOILERS DEPLOYED AS IT FELT LIKE AN INTENSIFIED SPOILER DEPLOYMENT. THERE WAS NO SPOILER DEPLOYMENT. GOTSDR JGVR20251112002Skin · corrodedBLENDED CORRODED AREAS LOCATED ON THE NUTPLATE-SIDE OF THE FUSELAGE STRUCTURE WHERE THE SPADE DOOR (MAIN ENTRY DOOR LOWER FAIRING DOOR) ATTACHES TO THE AIRCRAFT, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. FABRICATED AND INSTALLED REPAIR DOUBLERS AS REQSDR DALA2025111208306Skin · mechanic errorDAMAGE WAS FOUND AFT OF L2 DOOR. DAMAGE IS LOCATED 20 INCHES AFT OF DOOR ON SKIN LAP JOINT. MTX MISDRILLED HOLES WHILE WORKING SRM REPAIR. C/W ER/A 630312-14 REV 0. QC5368 251784. C/W ER/A 630312-14 REV 1. QC5368 251784. C/W ER/A 630312-14 REV 2. QC5368 251784SDR DALA2025111208305Door · damagedFOUND DAMAGE AFT OF L2 DOOR. DAMAGE MEASURED 20 INCHES AFT OF DOOR SEAM ON SEAM LAP JOINT. REMOVED DAMAGE AREA REF B737 SRM 53-70-01-2R . PARAGRAPH 4,D. PERFORMED ALL HFEC PER B737 SRM . HFEC OF CUTOUT AREA PER NDT PART 6 51 00-00 PROCEDURE 23. BHEC PERFORMEDSDR DALA2025111208293Oxygen Mask · dislodgedMASK DROP AT 3C AND 3D. RESTOWED PASSENGER O2 MASK IAW A319 35-21. (7337934).SDR DALA2025111208291Light · inoperativeRIGHT EMERGENCY OVERWING LIGHT INOP. R & R RT OVERWING EMERGENCY LIGHT IAW AMM 33-50. (7522056).SDR JJBA20251112063Elec Connector · disconnectedBOTH EMERGENCY LIGHTS NEAR RH WING ROOT IS INOPERATIVE. RECONNECTED CANNON PLUGS OF BOTH RH WING-TO-FUSELAGE FAIRING EMERGENCY LIGHTS.SDR JGVR20251112001Skin · corrodedFOUND 5 AREAS OF CORROSION ON THE UPPER SURFACE OF THE LH UPPER WING SKIN AND 2 AREAS ON THE UPPER SURFACE OF THE RH UPPER WING SKIN, MECHANICALLY BLENDED CORRODED AREAS, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. FABRICATED AND INSTALLED REPAIR DOUBL