OpenAirDocs.org
Crystal, MN

Cancelled registrations · 565

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 = 'MN' AND d.registrant_city = 'CRYSTAL'
  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.

N38951Piper PA-28-161 · S/N 28-7716296Cancelled May 30, 2018 · Sale reported, canceled · Built 1977N3906SCessna 172E · S/N 17251106Cancelled May 30, 2018 · Sale reported, canceledN3HAPiper PA-32-260 · S/N 32-762Cancelled May 30, 2018 · Sale reported, canceled · Built 1966N400MGPiper PA-32RT-300 · S/N 32R-7985012Cancelled May 30, 2018 · Sale reported, canceled · Built 1978N406XMaule M-5-235C · S/N 7039CCancelled May 30, 2018 · Sale reported, canceled · Built 1976N4179PPiper PA-23-160 · S/N 23-1667Cancelled May 30, 2018 · Sale reported, canceled · Built 1959N4294LCessna 172G · S/N 17254363Cancelled May 30, 2018 · Sale reported, canceled · Built 1966N43982Piper PA-28-181 · S/N 28-7890037Cancelled May 30, 2018 · Sale reported, canceled · Built 1977N4568DBeech G35 · S/N D-4719Cancelled May 30, 2018 · Sale reported, canceled · Built 1956N476CTFlight Design CTSW · S/N 07-07-03Cancelled May 30, 2018 · Sale reported, canceled · Built 2007N49134Cessna 152 · S/N 15281157Cancelled May 30, 2018 · Sale reported, canceled · Built 1977N49772Cessna 152 · S/N 15283510Cancelled May 30, 2018 · Sale reported, canceled · Built 1979N50595Bellanca 7GCBC · S/N 1163-79Cancelled May 30, 2018 · Sale reported, canceled · Built 1979N5068ECessna 172N · S/N 17271702Cancelled May 30, 2018 · Sale reported, canceled · Built 1978N5094UCessna 172RG · S/N 172RG0228Cancelled May 30, 2018 · Sale reported, canceled · Built 1979N5446NCessna 182R · S/N 18267721Cancelled May 30, 2018 · Sale reported, canceled · Built 1980N550RACessna 414 · S/N 414-0828Cancelled May 30, 2018 · Sale reported, canceled · Built 1976N5568JPiper PA-32-260 · S/N 32-1032Cancelled May 30, 2018 · Sale reported, canceled · Built 1968N5608WPiper PA-28-160 · S/N 28-746Cancelled May 30, 2018 · Sale reported, canceled · Built 1962N561CAPiper PA-23-250 · S/N 27-7754005Cancelled May 30, 2018 · Sale reported, canceled · Built 1976N5638KMaule M-5-210TC · S/N 9002CCancelled May 30, 2018 · Sale reported, canceled · Built 1980N56830Piper PA-28-180 · S/N 28-7105218Cancelled May 30, 2018 · Sale reported, canceled · Built 1971N568XLLiberty Aerospace LIBERTY XL-2 · S/N 0053Cancelled May 30, 2018 · Sale reported, canceledN5801PPiper PA-24-250 · S/N 24-881Cancelled May 30, 2018 · Sale reported, canceled · Built 1959N5KSPiper PA-28-235 · S/N 28-10802Cancelled May 30, 2018 · Sale reported, canceled · Built 1966N6060Cessna 320C · S/N 320C0049Cancelled May 30, 2018 · Sale reported, canceled · Built 1964N6173VCessna 172RG · S/N 172RG0589Cancelled May 30, 2018 · Sale reported, canceled · Built 1980N6219DCessna 172N · S/N 17272641Cancelled May 30, 2018 · Sale reported, canceled · Built 1979N78971Mooney M20C · S/N 2005Cancelled May 9, 2018 · Sale reported, pending cancellation · Built 1962N3772FCessna 172H · S/N 17255267Cancelled Apr 25, 2018 · Sale reported, pending cancellation · Built 1966N614SFCessna 150E · S/N 15060881Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1964 · Akn IncN5843Cessna 320C · S/N 320C0047Cancelled Apr 2, 2018 · Registration expired, pending cancellation · Built 1964 · Akn IncN6783ACessna 172 · S/N 28883Cancelled Apr 2, 2018 · Sale reported, pending cancellation · Built 1956N888DRBell 206B · S/N 327Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1968 · Akn IncN738BHCessna 172N · S/N 17269845Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1977 · Akn IncN101YSAgusta A109S · S/N 22099Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 2009 · Akn IncN624PCPiper PA-28R-200 · S/N 28R-7435125Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1973 · Akn IncN969BDPiper PA-31-350 · S/N 31-8152109Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1981 · Akn IncN450EMCessna 210M · S/N 61799Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1977 · Akn IncN318BALet L 33 SOLO · S/N 970418Cancelled Mar 12, 2018 · Sale reported, pending cancellation · Built 1997N9501VMooney M20E · S/N 690021Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1969 · Akn IncN15766Piper PA-32-260 · S/N 32-7300015Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1972 · Akn IncN242TSMooney M20C · S/N 2010Cancelled Mar 8, 2018 · Sale reported · Built 1962N9053WPiper PA-28-235 · S/N 28-10647Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1965 · Akn IncN61PFPiper PA-44-180 · S/N 44-7995187Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1979 · Wentworth Aircraft IncN415HEPiper PA-34-200T · S/N 34-7570181Cancelled Mar 1, 2018 · Exported to Russia · Built 1975N19738Cessna 172L · S/N 17260712Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 1972 · Wentworth Aircraft IncN1066RCessna 172M · S/N 17263020Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1974N13697Cessna 172M · S/N 17262951Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1974N136SBeech E-55 · S/N TE-794Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1970
Back to Crystal, MN