# Pastebin AEqga1xU
(openstackclient) ➜  ~ for port in $(openstack port list --network my-net --long -c ID -f value); do openstack port show $port -f json | jq '.device_owner, .project_id'; done

# null
"network:router_centralized_snat" ""

# admin project
"network:router_interface_distributed" "<ADMIN_PROJECT_ID>"
"network:dhcp" "<ADMIN_PROJECT_ID>"

# normal project
"compute:nova" "<PROJECT_ID>"