Skip to content

American Drone Network LLC

Registered aircraft · 39

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'AMERICAN DRONE NETWORK LLC' OR list_contains(g.other_registrant_names, 'AMERICAN DRONE NETWORK LLC') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'AMERICAN DRONE NETWORK LLC' OR list_contains(g.other_registrant_names, 'AMERICAN DRONE NETWORK LLC')
  ORDER BY g.n_number"

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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'AMERICAN DRONE NETWORK LLC' OR list_contains(g.other_registrant_names, 'AMERICAN DRONE NETWORK LLC')
ORDER BY g.n_number

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.

N103ADDJI AGRAS T100 · S/N 1581F8ZLC259T002MG98Columbia, MO N104ADDJI AGRAS T100 · S/N 1581F8ZLC25B6002K9C5Columbia, MO N117ADDJI AGRAS T100 · S/N 1581F8ZLC25B4002E2NPColumbia, MO N121ADDJI AGRAS T100 · S/N 1581F8ZLC25AB002JTX8Columbia, MO N124ADDJI AGRAS T100 · S/N 1581F8ZLC25AD0022M08Columbia, MO N125ADDJI AGRAS T100 · S/N 1581F8ZLC25AU002V44XColumbia, MO N137ADDJI AGRAS T100 · S/N 1581F8ZLC25AU002D8KNColumbia, MO N147ADDJI AGRAS T100 · S/N 1581F8ZLC25B3002LV64Columbia, MO N152ADDJI AGRAS T100 · S/N 1581F8ZLC25AC0023169Columbia, MO N157ADDJI AGRAS T100 · S/N 1581F8ZLC25B6002ECPQColumbia, MO N402ADTalos Drones T60X · S/N 2104F7EZW2567001GR40Columbia, MO N483WAEavision EA-J150 · S/N 1596A30D5907B74Columbia, MO N484LDEavision EA-J150 · S/N 1596A30A68384FAColumbia, MO N484QAEavision EA-J70 · S/N JMZKJ1070UAV61255239Columbia, MO N484VAEavision EA-J70 · S/N JMZKJ1070UAV61255238Columbia, MO N5200BTalos Drones T60X · S/N 2104F7EZW255P001FFM0Columbia, MO N5201BTalos Drones T60X · S/N 2104F7EZW255Q001U696Columbia, MO N5202ATalos Drones T60X · S/N 2104F7EZW255Q001LSXNColumbia, MO N5206DTalos Drones T60X · S/N 2104F7EZW255Q001PJ0ZColumbia, MO N5209ZTalos Drones T60X · S/N 2104F7EZW255Q001PFU2Columbia, MO N520FATalos Drones T60X · S/N 2104F7EZW255P00122E0Columbia, MO N520GNTalos Drones T60X · S/N 2104F7EZW2567001J67RColumbia, MO N520HJTalos Drones T60X · S/N 2104F7EZW255Q001HCK9Columbia, MO N520KATalos Drones T60X · S/N 2104F7EZW255P001DW80Columbia, MO N520QATalos Drones T60X · S/N 2104F7EZW255P001MKTKColumbia, MO N520WATalos Drones T60X · S/N 2104F7EZW255P0012X81Columbia, MO N520YBTalos Drones T60X · S/N 2104F7EZW255P0018JTLColumbia, MO N520ZBTalos Drones T60X · S/N 2104F7EZW255Q0015VS8Columbia, MO N5212LTalos Drones T60X · S/N 2104F7EZW255P001QDYZColumbia, MO N5215MTalos Drones T60X · S/N 2104F7EZW255P001QFSWColumbia, MO N5217MTalos Drones T60X · S/N 2104F7EZW255P0013EC5Columbia, MO N521EDTalos Drones T60X · S/N 2104F7EZW255Q0012H72Columbia, MO N521GLTalos Drones T60X · S/N 2104F7EZW255Q001496EColumbia, MO N521HTTalos Drones T60X · S/N 2104F7EZW255P00198X6Columbia, MO N521JLTalos Drones T60X · S/N 2104F7EZW255Q00193X2Columbia, MO N521NMTalos Drones T60X · S/N 2104F7EZW255Q001J3V7Columbia, MO N521PJTalos Drones T60X · S/N 2104F7EZW256K0010H5HColumbia, MO N521QBTalos Drones T60X · S/N 2104F7EZW255Q0018KKVColumbia, MO N521ZTTalos Drones T60X · S/N 2104F7EZW255Q001L9X0Columbia, MO

Back to American Drone Network LLC