OpenAirDocs.org
Poplar Grove, IL

Cancelled registrations · 24

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 = 'POPLAR GROVE'
  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.

N2051HErcoupe 415-D · S/N 2674Cancelled May 24, 2026 · Porter Robert AN601ZZAntonacci Lou CH601HDS · S/N 63645Cancelled Apr 9, 2026 · Porter Robert A TrusteeN929MJDJI INSPIRE 1 · S/N W13DCC30030150Cancelled Mar 9, 2023 · Registration expired, pending cancellation · Blackhawk Aerial Film And Photography IncN2MXJohn T Monnett JR MONNETT · S/N JM1Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1973 · Erikson Gregory AN474MAMay Dean STD RG-E · S/N SRE053Cancelled Oct 31, 2020 · Registration expired, pending cancellation · May Dean EN4218Aircraft Mfg & Design CH601XL SLSA · S/N 601-068SCancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2008 · Sherman RobN2574BBalloon Works FIREFLY 7B-15 · S/N F7B-341Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Zangs William JN5502NCorben BABY ACE · S/N 1Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1934 · Poplar Grove Aviation Education Association IncN733TMCessna 172N · S/N 17268536Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1977 · Poplar Grove Airmotive IncN37843Culver LCA · S/N 347Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1941N1054GStuart George G WEEDHOPPER · S/N 0020Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1979N5265URandall Howard CHALLENGER 2 · S/N CH2-0484-Y-0103Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1984 · Randall Howard AN2844KLuscombe 8A · S/N 5571Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1947 · Crane Russell ScottN49752Cessna 152 · S/N 15283503Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1979 · M-S-T Aviation IncN3839VCessna 170 · S/N 18706Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1948 · Poplar Grove Airmotive IncN316BRRusk Billy W SMITH SUPER CUB · S/N 001Cancelled May 10, 2012 · Second renewal notice · Built 2010 · Rusk Billy WN17HKKnight Harry S MONERAI-S · S/N 207Cancelled Sep 22, 2011 · Triennial form not returned · Built 1982 · Porter Robert AN3068BBeech 58 · S/N TH-1719Cancelled Aug 4, 2010 · Exported to Brazil · Built 1994 · Poplar Grove Airmotive IncN4ZES C Aerostar S A YAK-52TW · S/N 0412509Cancelled Nov 19, 2007 · Exported to Australia · Built 2004 · Bear Air CorpN1370RGrumman American Avn. AA-5 · S/N AA5-0770Cancelled Jun 13, 2005 · Triennial form not returned · Built 1975 · Engel Kyle EN718PHS C Aerostar S A YAK-52 · S/N 822108Cancelled Mar 23, 2004 · Exported to New Zealand · Hornick Paul WN1044PPiper PA-23 · S/N 23-46Cancelled Jun 7, 2001 · Triennial form not returned · Poplar Grove Airmotive IncN7726JPiper PA-32-260 · S/N 32-1128Cancelled Mar 29, 1983 · M-S-T Aircraft Leasing & SalesN5004RCessna 172M · S/N 17263245Cancelled Jul 7, 1977 · Built 1974 · M S T Aircraft Leasin And Sales Inc
Back to Poplar Grove, IL