OpenAirDocs.org
Urbana, IL

Cancelled registrations · 72

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

N46FGFrasca Rudy A FIAT G46 SPECIAL · S/N 97Cancelled Feb 24, 2024 · Expired dealer · Built 1996 · C16 Aviation IncN659PAAscending Technologies ASCTEC FIREFLY · S/N 10157Cancelled Jul 30, 2022 · Registration expired, pending cancellation · University Of Illinois Urbana ChampaignN659FHHorizon Hobby CARBON-Z T-28 BNF · S/N EFL1350Cancelled Jun 4, 2022 · Registration expired, pending cancellation · University Of Illinois At Urbana-ChampaignN855LCPowrachute SKY RASCAL · S/N SR095Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2006 · Carico Kim KN769KCDJI PHANTOM 4 · S/N 07DDD2V0A11492Cancelled Nov 4, 2019 · Registration expired, pending cancellation · University Of Illinois At Urbana-ChampaignN24691Piper J4A · S/N 4684Cancelled Oct 21, 2019 · Revoked, canceled · Built 1939 · Spencer ShermanN1923Bensen B-8MEJ · S/N NG1923Cancelled Oct 18, 2019 · Revoked, canceled · Built 1967 · Johnson Richard LN665RBAscending Technologies PELICAN V1 · S/N 20429Cancelled Oct 5, 2019 · Registration expired, pending cancellation · University Of Illinois At Urbana ChampaignN22TQMaris James R QUICKIE 2 · S/N 2337Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1984 · Frasca Air MuseumN29HRReiss RUTAN VARI-VIGGEN SP · S/N 267Cancelled Aug 9, 2018 · Revoked, canceled · Built 1977 · Reiss Harold LN99502Engineering & Research 415-C · S/N 2125Cancelled Feb 14, 2017 · Revoked, canceled · Built 1946 · Shott Fred GN280TPVickers Supermarine SPITFIRE MARK XVIII · S/N 6S-676372-165Cancelled Feb 20, 2015 · Exported to Germany · Built 1945 · Frasca International IncN5949XBrantly B-2 · S/N 88Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1961 · Patken IncN4648MCessna 152 · S/N 15284473Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1980 · Frasca International IncN4979PAllbritten Darrell/Dennis SNOOP II · S/N S-83-0009Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1984 · Buck Gary LN3975YWeaver James E GOLDWING · S/N 068Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Buck Gary LN4741DCessna 182A · S/N 34841Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Ruperts Angus HN7848ZCessna 150C · S/N 15059948Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1963N2527NPiper PA-38-112 · S/N 38-79A0891Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1979 · Jarrell Vincent CN162JAAllen Joseph W CHRIS TENA MINICOUPE · S/N JA-1Cancelled Aug 10, 2012 · Registration pending, canceled · Built 1981N262CPMooney M20K · S/N 25-0092Cancelled Sep 14, 2011 · Built 1979 · Folk Daniel HN9026ZRobinson Helicopter R22 · S/N 0043Cancelled Mar 5, 2009 · Triennial form not returned · Built 1980 · Summersky2 IncN92HGCessna TU206A · S/N U206-0576Cancelled Mar 9, 2006 · Exported to Mexico · Built 1966 · Aerial Mapping Services IncN6167ZBeech C23 · S/N M-2349Cancelled May 21, 2002 · Built 1981 · University Of Illinois FoundationN3482Beech UC-45J · S/N 029659Cancelled Jun 14, 2001 · Triennial form not returned · Brutlag Aviation LtdN84WSWisconsin Sport AVID FLYER · S/N 79Cancelled Apr 19, 1999 · Triennial form not returned · Seversen John EN999JFFrasca Joe ASTROCRAFT · S/N 100JFCancelled Jan 24, 1992 · Triennial form not returned · Frasca Joe PN5465ECessna 172N · S/N 17271874Cancelled Nov 7, 1984 · Exported to Australia · Cross Construction IncN9214PPiper PA-24-260 · S/N 24-4710Cancelled Oct 15, 1981 · Illini Aviation IncN8592CPiper PA-28-181 · S/N 28-7690151Cancelled Feb 10, 1977 · Illini Aviation IncN8724YPiper PA-30 · S/N 30-1877Cancelled Sep 3, 1975 · Built 1969 · Illini Aviation IncN9287PPiper PA-24-260 · S/N 24-4787Cancelled Aug 20, 1974 · Illini Aviation IncN8057HBeech C-45 · S/N 44-47691Cancelled Oct 13, 1970 · University Of IllinoisN4422DBeech G35 · S/N D4559Cancelled Oct 6, 1970 · University Of IllinoisN7332XCessna 150B · S/N 15059432Cancelled Sep 28, 1970 · University Of Illinois Board Of TrusteesN21197Stinson HW75 · S/N 7069Cancelled Jul 2, 1970 · Built 1939 · Reed Eugene PN9611ACessna 140A · S/N 15332Cancelled Jun 30, 1970 · University Of IllinoisN3470EAeronca 11AC · S/N 11AC-1766Cancelled Jun 16, 1970 · Chevalier Adelore JN4629MPiper PA-11 · S/N 11133Cancelled Jun 8, 1970 · Built 1947 · Illini AirportN1629EAeronca 7AC · S/N 7AC-5194Cancelled Nov 3, 1969 · Built 1946 · Rapp Dale LN5055PPiper PA-24 · S/N 24-60Cancelled Aug 5, 1969 · Illini AirportN92NPiper PA-23 · S/N 23-87Cancelled Feb 11, 1969 · Modular Construction IncN1007PPiper PA-23 · S/N 23-9Cancelled Aug 5, 1968 · Sampley Eldred CN6856SAero Commander 680 · S/N 680-371-56Cancelled Apr 9, 1968 · Board Of Trustees Of The University Of IllinoisN6498RPiper PA-28-140 · S/N 28-21691Cancelled Feb 2, 1968 · Illini Aviation IncN72406Beech TC-45H · S/N AF142Cancelled Jun 5, 1965 · Ill UnivN7640BHiller H-23A · S/N 51-16124Cancelled May 22, 1965 · The Board Of Trustees Of The Univ Of IllN7641BLockheed T-33A · S/N 51-4039Cancelled May 22, 1965 · The Board Of Trustees Of The Univ Of IlN2216SDouglas C-47A · S/N 42-93066Cancelled May 21, 1965 · Board Of Trustees Of University Of IllinoisN2217SDouglas C-47A · S/N 42-23727Cancelled May 21, 1965 · Board Of Trustees Of University Of Illinois
Back to Urbana, IL