Staunton, IL

Cancelled registrations · 199

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 = 'STAUNTON'
  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.

N40799Piper PA-28-180 · S/N 28-7405067Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1973 · Central Air Parts IncN6117KCessna 150M · S/N 15077534Cancelled May 16, 2017 · Registration expired, pending cancellation · Built 1975 · Central Air Parts IncN6340ZPiper PA-25 · S/N 25-523Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1961 · Central Air Parts IncN6844FCessna 150F · S/N 15063444Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1966 · Central Air Parts IncN8296FCessna 150F · S/N 15064396Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1966 · Central Air Parts IncN2501LCessna 172H · S/N 17255701Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1966 · Central Air Parts IncN246LBeech 95-B55 (T42A) · S/N TC-502Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1964 · Central Air Parts IncN2059QCessna 177RG · S/N 177RG0459Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1973 · Central Air Parts IncN757LDCessna 152 · S/N 15279817Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1977 · Central Air Parts IncN1140FCessna 172G · S/N 17254735Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1966 · Central Air Parts IncN1290UCessna 172M · S/N 17266984Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1976 · Central Air Parts IncN7682KPiper PA-20 · S/N 20-504Cancelled Aug 24, 2016 · Third renewal notice · Built 1949 · Central Air Parts IncN3005LCessna 310J · S/N 310J0005Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1965 · Central Air Parts IncN43102Cessna 172H · S/N 17255566Cancelled May 20, 2015 · Registration expired, pending cancellation · Central Air Parts IncN105ASocata TB 10 · S/N 590Cancelled May 15, 2015 · Registration expired, pending cancellation · Central Air Parts IncN9372RCessna A188B · S/N 18802263TCancelled May 11, 2015 · Registration expired, pending cancellation · Built 1975 · Central Air PartsN24LHCessna TR182 · S/N R18200769Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1978 · Central Air Parts IncN4045VCessna 150M · S/N 15076683Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1975 · Central Air Parts IncN4307UCessna 152 · S/N 15283725Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1979 · Central Air Parts IncN4189QPiper PA-28-161 · S/N 28-7716172Cancelled May 5, 2015 · Registration expired, pending cancellation · Central Air Parts IncN4957VCessna 172RG · S/N 172RG0426Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1980 · Central Air Parts IncN5290KCessna 172P · S/N 17274047Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1980 · Central Air Parts IncN43844Piper PA-28-181 · S/N 28-7890029Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1977 · Central Air Parts IncN70397Cessna 172M · S/N 17267213Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1976 · Central Air Parts IncN4253SPiper PA-22-135 · S/N 22-728Cancelled Dec 18, 2014 · Sale reported, canceledN2653VCessna 170 · S/N 18163Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1948 · Central Air Parts IncN4877VCessna T303 · S/N T30300282Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Central Air Parts IncN9795LBeech C23 · S/N M-1400Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1972 · Central Air Parts IncN4309DCessna 152 · S/N 15284928Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1981 · Central Air Parts IncN6294JPiper PA-28-151 · S/N 28-7615358Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1976 · Central Air Parts IncN6783TCessna 310D · S/N 39083Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1960 · Central Air Parts IncN731RDCessna A188B · S/N 18803088TCancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Central Air Parts IncN40991Piper PA-28-151 · S/N 28-7415128Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1974 · Central Air Parts IncN6240ZPiper PA-25 · S/N 25-291Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1960 · Willhoit Robert LN4735DCessna 182A · S/N 34835Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1957 · Central Air Parts IncN49856Cessna 152 · S/N 15281361Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1978 · Central Air Parts IncN5002FPiper PA-32R-300 · S/N 32R-7780001Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1976 · Central Air Parts IncN45072Cessna 150M · S/N 15076723Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1975 · Central Air Parts IncN3055ZPiper PA-22-160 · S/N 22-7010Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1959 · Central Air Parts IncN3140QCessna 182K · S/N 18258140Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1967 · Central Air Parts IncN33JECessna 310B · S/N 35555Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1957 · Central Air Parts IncN2647QCessna 182K · S/N 18257847Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1966 · Central Air Parts IncN24724Cessna 152 · S/N 15280340Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1977 · Central Air PartsN2339UCessna 172D · S/N 17249939Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1962 · Central Air Parts IncN2315UCessna 172D · S/N 17249915Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1962 · Central Air Parts IncN266ERPiper PA-44-180 · S/N 44-8195012Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1980N5343KCessna 172P · S/N 17274073Cancelled Nov 14, 2013 · Registration expired, pending cancellation · Built 1980 · Central Air Parts IncN5685RCessna 172F · S/N 17253327Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1965 · Central Air Parts IncN923QBeech 65-80 · S/N LD-123Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1963 · Central Air Parts IncN25919Cessna 152 · S/N 15280858Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1977 · Central Air Parts Inc
Back to Staunton, IL