OpenAirDocs.org
Boonville, MO

Cancelled registrations · 40

Query with SQL
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_state = 'MO' AND d.registrant_city = 'BOONVILLE'
  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.

N233ASDJI AGRAS T25 · S/N 1581F6BUD22CE001P929Cancelled Sep 18, 2026 · Agri Spray Drones LLCN502ASDJI AGRAS T40 · S/N 1581F574B226D00100XUCancelled Sep 18, 2026 · Agri Spray Drones LLCN604ASDJI AGRAS T40 · S/N 1581F574B234C00100RHCancelled Sep 18, 2026 · Agri Spray Drones LLCN115HBDJI AGRAS T30 · S/N 1581F446LK4V30301880Cancelled Sep 17, 2026 · Agri Spray Drones LLCN135KBDJI AGRAS T40 · S/N 1581F574B239B001012Cancelled Sep 17, 2026 · Agri Spray Drones LLCN143KBDJI AGRAS T40 · S/N 1581F574B236300100HVCancelled Sep 17, 2026 · Agri Spray Drones LLCN1461DDJI AGRAS T40 · S/N 1581F574B234C00100NRCancelled Sep 17, 2026 · Agri Spray Drones LLCN190NADJI AGRAS T20P · S/N 1581F574B225M00102WACancelled Sep 17, 2026 · Agri Spray Drones LLCN2329KDJI AGRAS T40 · S/N 1581F574B223T00101X2Cancelled Sep 17, 2026 · Agri Spray Drones LLCN274EADJI AGRAS T50 · S/N 63Y1M120AR0004Cancelled Sep 17, 2026 · Agri Spray Drones LLCN274QCDJI AGRAS T50 · S/N 63Y1M120AR0009Cancelled Sep 17, 2026 · Agri Spray Drones LLCN277HADJI AGRAS T40 · S/N 1581F574B234C00100TFCancelled Sep 17, 2026 · Agri Spray Drones LLCN299VADJI AGRAS T40 · S/N 1581F574B2383001007VCancelled Sep 17, 2026 · Agri Spray Drones LLCN304LDDJI AGRAS T30 · S/N 527BJAL0010074Cancelled Sep 17, 2026 · Agri Spray Drones LLCN306LDDJI AGRAS T30 · S/N 1581F446LJ4B20L00600Cancelled Sep 17, 2026 · Agri Spray Drones LLCN3074ADJI AGRAS T50 · S/N 1581F6BUB235N001002ZCancelled Sep 17, 2026 · Agri Spray Drones LLCN307ZADJI AGRAS T50 · S/N 1581F6BUB235T00100KZCancelled Sep 17, 2026 · Agri Spray Drones LLCN3138ADJI FLYCART 30 · S/N 1581F7C6B23AU001NN20Cancelled Sep 17, 2026 · Agri Spray Drones LLCN314VPDJI AGRAS T50 · S/N 1581F6BUB23AG001TZ29Cancelled Sep 17, 2026 · Agri Spray Drones LLCN315NADJI AGRAS T50 · S/N 1581F6BUB235H0010011Cancelled Sep 17, 2026 · Agri Spray Drones LLCN329AADJI AGRAS T25 · S/N 1581F6BU5238Q0C1P53NCancelled Sep 17, 2026 · Agri Spray Drones LLCN356AGXag P100 PRO · S/N 1863FPEG821931421EP0Cancelled Sep 17, 2026 · Agri Spray Drones LLCN501ASDJI AGRAS T40 · S/N 1581F574B28F00100MDCancelled Sep 17, 2026 · Agri Spray Drones LLCN782DCDJI AGRAS T40 · S/N 1581F574B227400100YXCancelled Sep 17, 2026 · Agri Spray Drones LLCN936JWDJI AGRAS T30 · S/N 527BJAQ001006DCancelled Sep 17, 2026 · Agri Spray Drones LLCN9376ADJI AGRAS T30 · S/N 1581F446LJAB30300HB0Cancelled Sep 17, 2026 · Agri Spray Drones LLCN966DCDJI AGRAS T40 · S/N 1581F574B237W00100YXCancelled Sep 17, 2026 · Agri Spray Drones LLCN967DCDJI AGRAS T40 · S/N 1581F574B236300100UGCancelled Sep 17, 2026 · Agri Spray Drones LLCN970UJDJI AGRAS T30 · S/N 1581F446LK4N30300S20Cancelled Sep 17, 2026 · Agri Spray Drones LLCN298VADJI AGRAS T25P · S/N 63N1L6K0AR0004Cancelled Oct 3, 2024 · Agri Spray Drones LLCN298XADJI AGRAS T25P · S/N 63N1M370AR0001Cancelled Oct 3, 2024 · Agri Spray Drones LLCN1056ADJI AGRAS T40 · S/N 1581F574B225500101HZCancelled Apr 10, 2024 · Exported to Canada · Agri Spray Drones LLCN73051Cessna 140 · S/N 10259Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1946 · Slaughter Bradley RN1994DBeech C35 · S/N D-3257Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1952 · Slaughter Bradley RayN43641Taylorcraft BC12-D · S/N 7300Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1946 · Lutz Irl MN89037Cessna 152 · S/N 15282605Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1978 · Tig Air Aviation IncN3526QZeller Christopher B T BIRD II · S/N 002Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Zeller Christopher BN8106TCessna 175B · S/N 17556806Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1960 · Twenter J DN1785NCessna 120 · S/N 12029Cancelled Jul 9, 2009 · Registration revoked · Built 1946 · Hern & Pringer AviationN44144Taylorcraft BC12-D1 · S/N 9944Cancelled Oct 6, 1971 · Built 1946 · Craig Paul F
Back to Boonville, MO