OpenAirDocs.org
Crystal Lake, IL

Cancelled registrations · 56

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 = 'CRYSTAL LAKE'
  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.

N769MIsrael Aircraft Industries 1124A · S/N 344Cancelled Mar 27, 2023 · Klockenga Matthew BN81SGCessna TU206F · S/N U20603038Cancelled Mar 1, 2023 · Exported to Guatemala · Built 1975N42079Piper PA-31-350 · S/N 31-7405488Cancelled Dec 22, 2022 · Exported to Canada · Built 1974 · Klockenga MatthewN652SSDJI INSPIRE 1 · S/N W13DCB15020177Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Satellite Technology Systems IncN6743BPiper PA-22-150 · S/N 22-4077Cancelled Jul 27, 2021 · Revoked, canceled · Built 1956 · Morgan Franklin AN947GSGates Learjet 35A · S/N 250Cancelled May 6, 2020 · Exported to Mexico · Built 1979 · Saldana Air LLCN652ESDJI S1000+ · S/N 03Q0012229Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Satellite Technology Systems IncN3665ZBalloon Works FIREFLY 7 · S/N F7-061Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 1983 · Hill Dave AN5046SPiper PA-28R-200 · S/N 28R-35792Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1970 · Lockart DaleN69404Cessna 402B · S/N 402B0537Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1973 · Aircraft Sales CorpN97CMBeech A36 · S/N E-1119Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1977 · Aircraft Sales CorpN6645GBeech V35B · S/N D-10271Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1979 · Aircraft Sales CorpN5852MCessna 340 · S/N 340-0055Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1972 · Aircraft Sales CorpN6111CBeech A36 · S/N E-1955Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1981 · Aircraft Sales CorpN6655TBeech V35B · S/N D-10274Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Aircraft Sales CorpN7253ZBeech A36 · S/N E-2279Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1985 · Aircraft Sales CorpN2048DBeech V35B · S/N D-10192Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Aircraft Sales CorpN4682CCessna T303 · S/N T30300115Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1982 · Aircraft Sales CorpN6144UCessna T210R · S/N 21064912Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Aircraft Sales CorpN8442FCessna 340 · S/N 340-0159Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1972 · Aircraft Sales CorpN8682KCessna 340A · S/N 340A0617Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1978 · Aircraft Sales CorpN1701GCessna 340 · S/N 340-0512Cancelled Oct 25, 2017 · Registration expired, pending cancellation · Built 1974 · Aircraft Sales CorpN837LPiper PA-23-250 · S/N 27-3181Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1966 · Aircraft Sales CorpN9151FPiper PA-23-250 · S/N 27-4580Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1970 · Aircraft Sales CorpN6035YPiper PA-23-250 · S/N 27-3220Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1966 · Aircraft Sales CorpN94640Cessna 182Q · S/N 18266470Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1978 · Aircraft Sales CorpN3978HMooney M20J · S/N 24-0999Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1980 · Aircraft Sales CorpN8180RBeech 58 · S/N TH-522Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1974 · Aircraft Sales CorpN4065ABalloon Works FIREFLY 7 · S/N 10006Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1979 · Koehler KeithN4979GCessna 172N · S/N 17273526Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1979 · Aircraft Sales CorpN432ARCessna P210N · S/N P21000098Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1978 · Aircraft Sales CorpN587CPiper PA-32R-301T · S/N 3257324Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 2003 · Aircraft Sales CorpN25WRRosenthal William CHRISTEN EAGLE II · S/N ROSENTHAL-0001Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Rosenthal WilliamN37221Cessna T310R · S/N 310R0961Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1977N7858BBeech 58TC · S/N TK-64Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1978 · Aircraft Sales CorpN6871BCessna 340A · S/N 340A1517Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1982 · Aircraft Sales CorpN5788ZPiper PA-22-108 · S/N 22-9632Cancelled Feb 21, 2013 · Revoked, canceled · Built 1963 · Bowles Edward TN145BLCessna 680 · S/N 680-0045Cancelled Jan 31, 2013 · Exported to Chile · Built 2005 · Aircraft Sales CorpN40532Balloon Works FIREFLY 7 · S/N 10090Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1980 · Pierce Ronald WN2377VCessna 140 · S/N 14614Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1948N341DMCessna 340 · S/N 340-0347Cancelled Jun 26, 2012 · Expired dealer · Built 1974 · Aircraft Sales CorpN4162KPiper PA-34-220T · S/N 3449097Cancelled Jun 26, 2012 · Expired dealer · Built 1999 · Aircraft Sales CorpN366JCessna 310K · S/N 310K0086Cancelled Sep 16, 2008 · Triennial form not returned · Built 1966 · National Assocation Of System Administrations IncN4315SBeech A36 · S/N E-685Cancelled Nov 2, 2004 · Triennial form not returned · Built 1975 · Larocco Gary JN7172BGelasi John J AIRCAMPER · S/N 1188Cancelled Jan 11, 2002 · Triennial form not returned · Built 1991 · Gelasi John JN9021ACessna 170A · S/N 18776Cancelled Mar 6, 1979 · Exported to Canada · Stokes Winston LN1957WBeech B19 · S/N MB-621Cancelled Jul 21, 1977 · Built 1973 · Bennett James CN6413UMooney M20C · S/N 2160Cancelled Feb 24, 1976 · Hurt Michael LN7689ACessna 180 · S/N 32586Cancelled Jun 24, 1975 · Miller Gerald RN110JHHagle THORP T-18 · S/N 347Cancelled Dec 14, 1972 · Built 1971 · Hagle Conrad H
Back to Crystal Lake, IL