OpenAirDocs.org
St George, UT

Cancelled registrations · 108

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 = 'UT' AND d.registrant_city = 'ST GEORGE'
  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.

N2184XPiper PA-28-181 · S/N 28-7990365Cancelled Oct 23, 2019 · Sale reported · Built 1979N7294NCessna T210N · S/N 21063216Cancelled Sep 3, 2019 · Registration pending, canceled · Built 1979N47KJJohnson Kenneth SUPER CUB SPORT · S/N 471DCancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2014 · Brown Wallace AN411SWCanadair CL-600-2B19 · S/N 7067Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1995 · Skywest Airlines IncN8236FCessna 150F · S/N 15064336Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1966 · Planelogic LLCN824ASCanadair CL-600-2B19 · S/N 7203Cancelled Nov 13, 2017 · Third renewal notice · Built 1997 · Skywest Airlines IncN988CACanadair CL-600-2B19 · S/N 7204Cancelled Nov 13, 2017 · Built 1997 · Skywest Airlines IncN26177Bell 47G-4A · S/N 7621Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1968 · Skyhawk Helicopter Service IncN9087MBalloon Works FIREFLY 8B · S/N F8B-338Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1991 · Howes William RN9074RBalloon Works FIREFLY 8B · S/N F8-351Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1989 · Howes William RN2608EGooch Paul R DREAM MACHINE · S/N 4875Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Gooch PaulN406SWCanadair CL-600-2B19 · S/N 7030Cancelled Jun 8, 2017 · Third renewal notice · Built 1993 · Skywest Airlines IncN410SWCanadair CL-600-2B19 · S/N 7066Cancelled Jun 8, 2017 · Third renewal notice · Built 1995 · Skywest Airlines IncN821ASCanadair CL-600-2B19 · S/N 7194Cancelled Jun 8, 2017 · Registration expired · Built 1997 · Skywest Airlines IncN837ASBombardier CL-600-2B19 · S/N 7271Cancelled Jun 8, 2017 · Built 1998 · Expressjet Airlines IncN839ASBombardier CL-600-2B19 · S/N 7284Cancelled Jun 8, 2017 · Built 1999 · Expressjet Airlines IncN983CACanadair CL-600-2B19 · S/N 7169Cancelled Jun 8, 2017 · Built 1997 · Skywest Airlines IncN1744TPiper PA-28-140 · S/N 28-7125062Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1970 · Red Hills Flying ClubN984CACanadair CL-600-2B19 · S/N 7171Cancelled May 3, 2017 · Built 1997 · Skywest Airlines IncN394CDBuckeye DREAM MACHINE · S/N 4119Cancelled Mar 1, 2017 · Registration expired, pending cancellation · Larson SteveN3609LCessna 172G · S/N 17253778Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1965 · Jsr Aero LLCN81718Champion AERONCA 7AC · S/N 7AC-337Cancelled Feb 4, 2017 · Revoked, canceled · Built 1945 · Rice Wilford WN71VLCessna 150L · S/N 15072266Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1970 · Leonis Jack VincentN7318XCessna R182 · S/N R18200074Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Skywest Aviation IncN983KCRobinson Helicopter R22 BETA · S/N 2811Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1998 · K N K Leasing IncN401ZBoeing 727-25C · S/N 19854Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1968N7256BBeech J35 · S/N D-5588Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1958N6663PCessna P210N · S/N P21000195Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1978N52043Cessna 177RG · S/N 177RG1149Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1977 · Houston David KN2253Beech UC-45J · S/N 51339Cancelled Aug 13, 2012 · Sale reported, canceled · Built 1969N115FSStringham Frank VISION BY AM AFF AC · S/N 115Cancelled Jun 14, 2012 · Registration expired, pending cancellation · Stringham FrankN24EZSylvester Rex J VARIEZE · S/N DC-001Cancelled Jul 20, 2011 · Registration pending, canceled · Built 1980N1323ACessna T182T · S/N T18208657Cancelled Jun 1, 2011 · Exported to Australia · Built 2006 · Cloud Niner LLCN92RKKirby Robert A CHRISTEN EAGLE · S/N 0391Cancelled Feb 22, 2010 · Exported to Thailand · Built 1993 · Employ/Ease IncN250RRoder ACROSPORT 150 · S/N 250Cancelled Jun 17, 2008 · Triennial form not returned · Built 1974 · Duenas CarlosN5254CBeech B35 · S/N D-2646Cancelled Nov 26, 2007 · Built 1950 · Noonan Charles MN46405Cessna 152 · S/N 15283043Cancelled Aug 15, 2007 · Exported to Philippines · Built 1978 · Forsyth Michael ShaneN212SWEmbraer EMB-120ER · S/N 120-276Cancelled Apr 20, 2007 · Exported to Brazil · Built 1992 · Skywest Airlines IncN214SWEmbraer EMB-120ER · S/N 120.280Cancelled Feb 8, 2007 · Exported to France · Built 1993 · Skywest Airlines IncN224FHHallstrom Floyd P BD-5B · S/N 2248Cancelled Apr 6, 2006 · Triennial form not returned · Built 1994 · Hallstrom Floyd PN190SWEmbraer EMB-120 · S/N 120.050Cancelled Mar 22, 2006 · Exported to Nigeria · Built 1987 · Skywest Airlines IncN197SWEmbraer EMB-120ER · S/N 120.186Cancelled Feb 24, 2006 · Exported to Australia · Built 1990 · Skywest Airlines IncN189SWEmbraer EMB-120 · S/N 120.048Cancelled Jan 13, 2006 · Exported to Nigeria · Built 1987 · Skywest Airlines IncN187SWEmbraer EMB-120 · S/N 120.037Cancelled Sep 12, 2005 · Exported to Angola · Skywest Airlines IncN30796Cessna T210L · S/N 21059963Cancelled May 7, 1998 · Triennial form not returned · Atkin Lee CN9560HCessna 172M · S/N 17266229Cancelled Mar 29, 1991 · Triennial form not returned · Bundy J BradleyN9764Piper PA-25-235 · S/N 253821Cancelled Mar 22, 1991 · Triennial form not returned · Skyhawks IncN61343Cessna 150J · S/N 15070978Cancelled Jun 20, 1984 · Hall Orlo HN4650EAeronca 7EC · S/N 7EC-4Cancelled Apr 15, 1982 · Built 1950 · Red Hills Flying ClubN64803North American F-86L · S/N 53581Cancelled Jan 2, 1979 · Dixie College
Back to St George, UT