I was ready to throw it away, I opened it up and didn't find anything wrong with it. After a quick Google Search, turns out Apple fucked up their users (again) and locked this drive to only one laptop : the MacBook Air.
Bellow is the tweak (found online) to make it usable on Linux
# Debian/linux only - Linux SCSI generic driver
sudo apt install sg3-utils -y
# RHEL/Fedora only - Linux SCSI generic driver
sudo dnf install sg3_utils -y
# tell the external DVD player/burner to turn on
sudo sg_raw /dev/sr0 EA 00 00 00 00 00 01
It's much easier to setup a custom udev rule than to manually run the command all the time.
Reference:
https://cmos.blog/use-apples-usb-superdrive-with-linux/comment-page-1/