OpenAirDocs.org
Linden, MI

Cancelled registrations · 23

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 = 'MI' AND d.registrant_city = 'LINDEN'
  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.

N647MFDJI PHANTOM 3 PROFESSION · S/N P78DCI22061565Cancelled Oct 2, 2019 · Registration expired, pending cancellation · Flyby Aerial Media LLCN51032DJI PHANTOM 3 PROFESSION · S/N P76DCG30011382Cancelled May 6, 2019 · Registration expired, pending cancellation · Medore Shayne LN9493UCessna 150M · S/N 15078441Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1976 · Gould JamesN5055YPiper PA-23-250 · S/N 27-2066Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1962 · Cash LarryN380CBeech 65-80 · S/N LD-95Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1963N587CJNantel Alain RV-6 · S/N 23113Cancelled Mar 9, 2010 · Exported to Canada · Built 2003 · Cody F Welch & Associates IncN6245QCessna 152 · S/N 15285209Cancelled Jul 9, 2007 · Exported to Philippines · Built 1981 · Skysports International IncN7545YPiper PA-30 · S/N 30-608Cancelled Mar 9, 2006 · Exported to Canada · Built 1964 · Cody F Welch & Associates IncN7634TPiper PA-34-200T · S/N 347670037Cancelled Sep 10, 1998 · Exported to Panama · Price Aviation IncN606JVVon Linsowe John E KITFOX 2 · S/N 606Cancelled Sep 30, 1995 · Triennial form not returned · Von Linsowe John EN9519BCessna 172RG · S/N 172RG0850Cancelled Dec 13, 1994 · Exported to Chile · Price Aviation IncN95532Cessna 182Q · S/N 18266568Cancelled Jun 22, 1994 · Exported to Canada · Price Aviation IncN52446Hurley James L QCKSLVR MVL II HP · S/N 1614Cancelled Mar 29, 1993 · Hurley James LN4336PMacfarlane Marshall BUCCANEER SX · S/N BIB522503Cancelled Mar 17, 1992 · Exported to Canada · Macfarlane Marshall GN757ETCessna 152 · S/N 15279687Cancelled Mar 25, 1983 · Joel Price DBA Prices ArptN24522Cessna 152 · S/N 15280327Cancelled Apr 16, 1982 · Built 1977 · Price Joel AN66217Cessna 150M · S/N 15075926Cancelled May 7, 1981 · Price JoelN4657LCessna 172G · S/N 17254652Cancelled Aug 14, 1973 · Exported to Canada · Built 1966 · Ellis RichardN8636WPiper PA-28-235 · S/N 28-10152Cancelled Jun 25, 1973 · Built 1964 · Switt Joseph And Self JohnN6752XCessna 310F · S/N 310-0052Cancelled Mar 22, 1971 · Evans Poultry Co IncN7890ZCessna 150C · S/N 15059990Cancelled Nov 22, 1968 · Built 1963 · Price Joel AN4110MPiper PA-12 · S/N 12-3008Cancelled Jul 7, 1967 · Exported to Canada · Gocha Donald EN53853Cessna T-50 · S/N 6595Cancelled Oct 21, 1955 · Smith Richard D
Back to Linden, MI