OpenAirDocs.org
Aurora, 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 = 'AURORA'
  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.

N3831VCessna 170 · S/N 18689Cancelled Feb 19, 2019 · Revoked, canceled · Built 1948 · Halter RobertN937SSudlow Christopher TWINSTAR MARK III · S/N 1139Cancelled Jan 30, 2018 · Registration expired, pending cancellation · Built 2002 · Sudlow Christopher AN747EZPettinger D/Baird W VARIEZE · S/N 880Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Baird William BN514KTSapp Larry E SEAWIND 3000 KIT PLN · S/N 60Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 2002 · Presbrey Kim EN345JMMorrison John K E-RACER · S/N 186Cancelled Oct 25, 2017 · Registration expired, pending cancellation · Built 2011 · Morrison John KN82VEHudson Billy W VARIEZE · S/N 1774Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1986 · Barba Jorge HN1812ABeech A36 · S/N E-1878Cancelled Apr 14, 2017 · Registration expired, pending cancellation · Built 1981 · 1812 Alpha LLCN8325Stinson L-5E · S/N 44-18023Cancelled Feb 4, 2017 · Revoked, canceled · Sky Ads IncN70432Wild Richard W QUICKSILVER MXL II · S/N 1282Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1988 · Wild Richard WN3983QUltralight Air QUICKSILVER MX II · S/N 1492Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1983 · Salman RobertoN5021YHeiman-Harold VARIEZE · S/N 678Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1979 · Heiman Harold FN43048Piper PA-28-151 · S/N 28-7415414Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1974 · Sidmore Earl JN7175YPiper PA-30 · S/N 30-195Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1963 · Sterling Investment CoN1261Krippelz Jacob B-8M · S/N 1Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Graf Ronald LN81896Krippelz Jacob SCORPION TOO · S/N 12232Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1979 · Krippelz JacobN94EZMueller Richard L VARIEZE · S/N 2009Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Mueller Richard LN26063Nelson BENSEN B-8M · S/N B8M9176Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1977 · Waid Ronald PN313JBBerkland-James SONERAI II · S/N 4421645Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Berkland James LN2366HBalloon Works FIREFLY 5 · S/N 507Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1978N345JMMorrison John K E RACER · S/N 113Cancelled Jul 30, 2008 · Triennial form not returned · Morrison John KN6268BPearce George CHALLENGER II · S/N CH2-1195-1420Cancelled Apr 9, 2008 · Triennial form not returned · Pearce George FN7305HPiper J3C-65 · S/N 20561Cancelled Sep 29, 2005 · Exported to Canada · Built 1946 · Shelburne Jack R IIN5288MTaylorcraft BC12-D · S/N 10588Cancelled Mar 6, 2001 · Triennial form not returned · Diehl William JN90526Desmond Albert D AX3 · S/N AD100Cancelled Jan 19, 2001 · Triennial form not returned · Desmond Albert DN44227Robinson Helicopter R22 · S/N 0189Cancelled Oct 28, 1999 · Triennial form not returned · Morrison John KN4351NPearce George SPORT II · S/N 296Cancelled Oct 6, 1998 · Triennial form not returned · Pearce George FN966LACessna 172RG · S/N 172RG1102Cancelled Jul 15, 1997 · Triennial form not returned · Lumanair IncN84HMHill Clayton C BUSHBY MUSTANG II · S/N MII1145Cancelled Aug 3, 1994 · Triennial form not returned · Kane Air IncN451Ostreka George STEEN SKYBOLT · S/N 1951GOCancelled Apr 23, 1993 · Triennial form not returned · Ostreko GeorgeN7142RPiper PA-28-140 · S/N 2821846Cancelled Sep 23, 1992 · Triennial form not returned · Payne Craig WN608DBeech C35 · S/N D2864Cancelled Jun 12, 1991 · Triennial form not returned · Weathers Kenneth EN9522FHughes 269B · S/N 580364Cancelled Mar 28, 1991 · Triennial form not returned · Sportflight Helicopter IncN33332Piper PA-28-151 · S/N 287515310Cancelled Feb 1, 1991 · Lumanair IncN6351ACessna 182 · S/N 33151Cancelled May 24, 1984 · Larson Pamela KN74PCCessna 411 · S/N 411-0072Cancelled Apr 13, 1983 · Lumanair IncN809QBeech 65 · S/N LC-30Cancelled Aug 31, 1982 · Lumanair IncN323HBeech 65 · S/N LC-178Cancelled Aug 7, 1982 · Built 1965 · Lumanair IncN8141FCessna 150F · S/N 15064241Cancelled Mar 1, 1982 · Skyles Alvin EN4774LPiper PA-28-180 · S/N 28-4108Cancelled Feb 19, 1981 · Built 1967 · Sidmore Earl JN4611XCessna U206G · S/N U20605511Cancelled Jan 14, 1981 · Exported to Democratic Republic of the Congo · Built 1979 · Spurlock Robert LN9113JPiper PA-28-180 · S/N 28-3155Cancelled Nov 28, 1980 · Exported to Canada · Maras Frank AN34266Schweizer SGS 1-35 · S/N 46Cancelled Aug 16, 1980 · Administratively canceled · Freedy Allan LN6043Hanson A T-BIRD · S/N 001Cancelled Dec 5, 1977 · Hanson Donald EN6508FCessna 150F · S/N 15063108Cancelled May 9, 1975 · Ce-Nr IncN5596WPiper PA-28-160 · S/N 28-732Cancelled Dec 18, 1974 · Barr John PN64121Balloon Works FIREFLY 6 · S/N 121Cancelled Aug 21, 1974 · Desmond Albert DN17373Cessna 150L · S/N 15073716Cancelled Jun 4, 1974 · Exported to Canada · Built 1972 · Lumanair IncN3121Bensen B-8M · S/N RX7464Cancelled Aug 31, 1971 · Lockard ChristopherN3684NPiper PA-12 · S/N 12-1934Cancelled Jan 15, 1971 · Thed A WiestN9360CCessna 180 · S/N 31758Cancelled Jan 12, 1971 · Wyer Paul H
Back to Aurora, IL