Skip to content

Agri Spray Drones LLC

Earlier aircraft under this name · 32

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'AGRI SPRAY DRONES LLC' OR list_contains(d.other_registrant_names, 'AGRI SPRAY DRONES LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'AGRI SPRAY DRONES LLC' OR list_contains(d.other_registrant_names, 'AGRI SPRAY DRONES LLC')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_name = 'AGRI SPRAY DRONES LLC' OR list_contains(d.other_registrant_names, 'AGRI SPRAY DRONES LLC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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.

N233ASDJI AGRAS T25 · S/N 1581F6BUD22CE001P929Cancelled Sep 18, 2026 · Boonville, MO N502ASDJI AGRAS T40 · S/N 1581F574B226D00100XUCancelled Sep 18, 2026 · Boonville, MO N604ASDJI AGRAS T40 · S/N 1581F574B234C00100RHCancelled Sep 18, 2026 · Boonville, MO N115HBDJI AGRAS T30 · S/N 1581F446LK4V30301880Cancelled Sep 17, 2026 · Boonville, MO N135KBDJI AGRAS T40 · S/N 1581F574B239B001012Cancelled Sep 17, 2026 · Boonville, MO N143KBDJI AGRAS T40 · S/N 1581F574B236300100HVCancelled Sep 17, 2026 · Boonville, MO N1461DDJI AGRAS T40 · S/N 1581F574B234C00100NRCancelled Sep 17, 2026 · Boonville, MO N190NADJI AGRAS T20P · S/N 1581F574B225M00102WACancelled Sep 17, 2026 · Boonville, MO N2329KDJI AGRAS T40 · S/N 1581F574B223T00101X2Cancelled Sep 17, 2026 · Boonville, MO N274EADJI AGRAS T50 · S/N 63Y1M120AR0004Cancelled Sep 17, 2026 · Boonville, MO N274QCDJI AGRAS T50 · S/N 63Y1M120AR0009Cancelled Sep 17, 2026 · Boonville, MO N277HADJI AGRAS T40 · S/N 1581F574B234C00100TFCancelled Sep 17, 2026 · Boonville, MO N299VADJI AGRAS T40 · S/N 1581F574B2383001007VCancelled Sep 17, 2026 · Boonville, MO N304LDDJI AGRAS T30 · S/N 527BJAL0010074Cancelled Sep 17, 2026 · Boonville, MO N306LDDJI AGRAS T30 · S/N 1581F446LJ4B20L00600Cancelled Sep 17, 2026 · Boonville, MO N3074ADJI AGRAS T50 · S/N 1581F6BUB235N001002ZCancelled Sep 17, 2026 · Boonville, MO N307ZADJI AGRAS T50 · S/N 1581F6BUB235T00100KZCancelled Sep 17, 2026 · Boonville, MO N3138ADJI FLYCART 30 · S/N 1581F7C6B23AU001NN20Cancelled Sep 17, 2026 · Boonville, MO N314VPDJI AGRAS T50 · S/N 1581F6BUB23AG001TZ29Cancelled Sep 17, 2026 · Boonville, MO N315NADJI AGRAS T50 · S/N 1581F6BUB235H0010011Cancelled Sep 17, 2026 · Boonville, MO N329AADJI AGRAS T25 · S/N 1581F6BU5238Q0C1P53NCancelled Sep 17, 2026 · Boonville, MO N356AGXag P100 PRO · S/N 1863FPEG821931421EP0Cancelled Sep 17, 2026 · Boonville, MO N501ASDJI AGRAS T40 · S/N 1581F574B28F00100MDCancelled Sep 17, 2026 · Boonville, MO N782DCDJI AGRAS T40 · S/N 1581F574B227400100YXCancelled Sep 17, 2026 · Boonville, MO N936JWDJI AGRAS T30 · S/N 527BJAQ001006DCancelled Sep 17, 2026 · Boonville, MO N9376ADJI AGRAS T30 · S/N 1581F446LJAB30300HB0Cancelled Sep 17, 2026 · Boonville, MO N966DCDJI AGRAS T40 · S/N 1581F574B237W00100YXCancelled Sep 17, 2026 · Boonville, MO N967DCDJI AGRAS T40 · S/N 1581F574B236300100UGCancelled Sep 17, 2026 · Boonville, MO N970UJDJI AGRAS T30 · S/N 1581F446LK4N30300S20Cancelled Sep 17, 2026 · Boonville, MO N298VADJI AGRAS T25P · S/N 63N1L6K0AR0004Cancelled Oct 3, 2024 · Boonville, MO N298XADJI AGRAS T25P · S/N 63N1M370AR0001Cancelled Oct 3, 2024 · Boonville, MO N1056ADJI AGRAS T40 · S/N 1581F574B225500101HZCancelled Apr 10, 2024 · Exported to Canada · Boonville, MO

Back to Agri Spray Drones LLC