Elk Grove Village, IL

Cancelled registrations · 21

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 = 'IL' AND d.registrant_city = 'ELK GROVE VILLAGE'
  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.

N3838JScrabeck Jerald TITAN BEMMER · S/N 001Cancelled Sep 13, 2016 · Sale reported, canceled · Built 2007N611ARBoeing 747-128 · S/N 19749Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1970 · Aar Aviation Trading IncN6088XMooney M20A · S/N 1684Cancelled Jul 16, 2013 · Revoked, canceled · Built 1960 · Copa CorporationN3632GWarwick TINY CHAMP M-I · S/N 1960Cancelled Jan 5, 2011 · Revoked, canceled · Built 1960 · Sonnemann William RN92TBBolger Terence A BUCCANEER II · S/N B2BK048Cancelled Aug 13, 2004 · Triennial form not returned · Built 1995 · Ta Bolger Realtors IncN108UABoeing 747-422 · S/N 26903Cancelled Sep 11, 2003 · Exported to United Arab Emirates · Built 1998 · United Air Lines IncN1855UMcdonnell-Douglas DC-10-30 · S/N 47837Cancelled Mar 24, 2003 · Triennial form not returned · Built 1980 · United Air Lines IncN610ARBoeing 747-128 · S/N 20800Cancelled Mar 12, 1997 · Triennial form not returned · Aar Aviation Trading IncN200AUBoeing 737-201 · S/N 19418Cancelled Jul 9, 1996 · Aar Allen Group IncN601ARBoeing 727-228 · S/N 19865Cancelled May 22, 1996 · Triennial form not returned · Aar Financial Services CorpN602ARBoeing 727-228 · S/N 20075Cancelled May 22, 1996 · Triennial form not returned · Aar Financial Services CorpN78020Boeing 747-243B · S/N 19731Cancelled Mar 18, 1996 · Aar Engine Group IncN210DSBoeing 720-047B · S/N 18167Cancelled Jun 7, 1991 · Triennial form not returned · Aar Allen Aircraft CorpN1910HSeverson Aeroplane I · S/N 1Cancelled Feb 27, 1985 · Built 1968 · Severson Harold WN17207Boeing 720-024B · S/N 19002Cancelled Jul 8, 1976 · Aar CorpN57201Boeing 720-024B · S/N 18416Cancelled Jul 8, 1976 · Sale reported · Built 1962N57205Boeing 720-024B · S/N 18587Cancelled Jul 8, 1976 · Sale reported · Built 1963N62119Boeing 727-30 · S/N 18934Cancelled Mar 20, 1975 · Exported to Jordan · Air Finance International IncN4005NMooney M20F · S/N 680158Cancelled Jun 22, 1973 · Westmont Industries ProductsN2315Spinner B-8M · S/N 1Cancelled Sep 15, 1971 · Spinner Fred WN7668PPiper PA-24 · S/N 24-2881Cancelled May 5, 1971 · Exported to Canada · Built 1962 · Weber Donald R
Back to Elk Grove Village, IL