OpenAirDocs.org
Ag-Air Inc

Earlier aircraft under this name · 20

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

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_name = 'AG-AIR INC' OR list_contains(d.other_registrant_names, 'AG-AIR INC')
  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.

N3538KPiper J3C-65 · S/N 22229Cancelled Aug 17, 2016 · Third renewal notice · Built 1946 · Pine Bluff, ARN73074Air Tractor AT-301 · S/N 301-0620Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1985 · Los Fresnos, TXN32944Piper J3C-65 · S/N 5728Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1940 · Pine Bluff, ARN7304LAir Tractor AT-301 · S/N 301-0599Cancelled Jun 28, 1985 · Exported to Mexico · Los Fresnos, TXN73052Air Tractor AT-301 · S/N 301-0619Cancelled Jun 28, 1985 · Exported to Mexico · Los Fresnos, TXN7307XAir Tractor AT-301 · S/N 301-0614Cancelled Apr 8, 1985 · Exported to Mexico · Los Fresnos, TXN7301CAir Tractor AT-301 · S/N 301-0586Cancelled Apr 2, 1985 · Exported to Mexico · Los Fresnos, TXN7305TAir Tractor AT-301 · S/N 301-0604Cancelled Mar 15, 1985 · Exported to Mexico · Los Fresnos, TXN7304HAir Tractor AT-301 · S/N 301-0598Cancelled Feb 25, 1985 · Exported to Mexico · Los Fresnos, TXN36501Air Tractor AT-301 · S/N 301-0257Cancelled Mar 29, 1984 · Exported to Mexico · Built 1980 · Los Fresinos, TXN36500Air Tractor AT-301 · S/N 301-0255Cancelled Mar 6, 1984 · Exported to Mexico · Built 1980 · Los Fresnos, TXN8666LPiper PA-25-235 · S/N 25-5117Cancelled Jul 10, 1982 · Exported to Canada · Suring, WIN3656DAir Tractor AT-301 · S/N 301-0305Cancelled May 14, 1982 · Exported to Mexico · Built 1980 · Los Fresnos, TXN2347VAir Tractor AT-301 · S/N 301-0389Cancelled Dec 28, 1981 · Exported to Mexico · Los Fresnos, TXN3650FAir Tractor AT-301 · S/N 301-0241Cancelled Oct 27, 1981 · Exported to Mexico · Los Fresnos, TXN76MHAir Tractor AT-301 · S/N 301-0028Cancelled May 1, 1981 · Exported to Mexico · Los Fresnos, TXN3650PAir Tractor AT-301 · S/N 301-0250Cancelled May 23, 1980 · Exported to Mexico · Los Fresnos, TXN4405SAir Tractor AT-301 · S/N 301-0065Cancelled Jan 14, 1980 · Exported to Mexico · Built 1977 · Los Fresnos, TXN4343SAir Tractor AT-301 · S/N 301-0023Cancelled Jan 26, 1977 · Built 1975 · Los Fresnos, TXN4918YPiper PA-25-235 · S/N 25-4721Cancelled Jun 17, 1974 · Sikeston, MO
Back to Ag-Air Inc