Is this a chromed metal shaft that stick straight up?
IF SO, the broken piece can be PROBABLY be unscrewed using pliers. Then you have the thread size, the piece, that you can take to a hardware store and get a long blot this the same threads.
The part can probably be found on the internet using google.com or on eBay.
92results for Brother sew spool pin
×