Denton, TX

Cancelled registrations · 166

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 = 'TX' AND d.registrant_city = 'DENTON'
  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.

N94802Cessna 152 · S/N 15285791Cancelled Apr 30, 2012 · First renewal notice · Built 1983 · US Aviation Group LLCN33681Piper PA-32-300 · S/N 32-7540111Cancelled Apr 6, 2012 · Sale reported, pending cancellation · Built 1975N69103Cessna 152 · S/N 15282483Cancelled Feb 17, 2012 · Built 1978 · U S Aviation Group LLCN987BTCessna 172R · S/N 17280452Cancelled Feb 16, 2012 · First renewal notice · Built 1998 · US Aviation Group LLCN6263QCessna 310Q · S/N 310Q0524Cancelled Apr 28, 2011 · Built 1972 · Integrity Office Solutions IncN1482WBell 206B · S/N 412Cancelled Mar 28, 2011 · Sale reported, pending cancellation · Built 1969N4546TPiper PA-34-200 · S/N 34-7250130Cancelled Jan 10, 2011 · Built 1972 · U S Aviation Group LLCN4998LPiper PA-28-140 · S/N 28-7525186Cancelled Apr 2, 2010 · Triennial form not returned · Built 1975 · Tweeddale Thomas AN99EFCessna 414A · S/N 414A0666Cancelled Dec 31, 2009 · Exported to Mexico · Built 1981 · Nebrig & Associates IncN8248VCessna A185F · S/N 18502722Cancelled Dec 1, 2009 · Exported to Brazil · Built 1975 · Nebrig & Associates IncN1080BMooney M20A · S/N 1306Cancelled Jun 25, 2009 · Registration revoked · Built 1958 · Lewelling HaroldN88JGBucker-Jungman 131 · S/N 27Cancelled Aug 13, 2008 · Exported to France · Built 1935 · Whitmore MarthaN111DSBell 222U · S/N 47554Cancelled Jul 25, 2008 · Exported to Ethiopia · Built 1986 · Turbines LtdN64936Cessna 152 · S/N 15281485Cancelled Jan 14, 2008 · Built 1978 · U S Aviation Group LLCN66450Cessna 150M · S/N 15076057Cancelled Jan 23, 2007 · Exported to Mexico · Built 1974 · Hyde Alfred D IIIN9419CPiper PA-28-161 · S/N 28-7816474Cancelled Nov 14, 2006 · Built 1978 · Grundei Charles KN107EHPiper PA-28-140 · S/N 28-7525057Cancelled Nov 2, 2006 · Triennial form not returned · Built 1974 · Tweeddale Thomas AllanN6870GCessna 150L · S/N 15072370Cancelled Nov 1, 2006 · Triennial form not returned · Built 1970 · Wakefield DeeN7390YPiper PA-30 · S/N 30-446Cancelled Jan 19, 2006 · Exported to Canada · Built 1964 · Whitmore AlexN2511PPiper PA-22-150 · S/N 22-2873Cancelled Dec 2, 2005 · Exported to Iceland · Built 1955 · Parsons Walter RN150GTCessna 401B · S/N 401B0040Cancelled Sep 20, 2005 · Triennial form undeliverable · Built 1970 · Texas Air Charters IncN2488HEngineering & Research ERCOUPE 415-C · S/N 3113Cancelled Apr 19, 2005 · Triennial form not returned · Built 1946 · Evans William JN76SVBellanca 17-30A · S/N 76-30810Cancelled Mar 11, 2005 · Triennial form not returned · Built 1976 · Seitz David CN400TFIsrael Aircraft Industries 1124 · S/N 279Cancelled Jun 4, 2004 · Exported to Mexico · Built 1980 · Nebrig & Associates IncN900JFAmerican Champion 8KCAB · S/N 871-2000Cancelled May 7, 2004 · Exported to United Kingdom · Built 2000 · Dugan Richard CN400BKPiper PA-24-400 · S/N 26-115Cancelled Nov 19, 2003 · Exported to Canada · Built 1965 · Putnam D KerryN402GRCessna 402C · S/N 402C0035Cancelled Sep 8, 2003 · Triennial form not returned · Built 1979 · Texas Air Charters IncN6013JBell OH-58A · S/N 70-15545Cancelled Apr 28, 2003 · Exported to Canada · Built 1970 · Hangar 10 Flying MuseumN99470Ercoupe 415-D · S/N 2093Cancelled Apr 9, 2003 · Triennial form not returned · Built 1947 · Brown Michael DN4612Miller Monte PIETENPOL AIR-CAMPER · S/N RW420Cancelled Feb 11, 2003 · Triennial form not returned · Built 1999 · Miller Monte MN221NCBeech B90 · S/N LJ-393Cancelled Jul 2, 2002 · Triennial form not returned · Built 1968 · Stone Aviation LLCN80QCessna 402B · S/N 402B1384Cancelled Oct 4, 2001 · Triennial form not returned · Built 1978 · Texas Air Charters IncN9022DCessna 305A · S/N 21311Cancelled Dec 14, 2000 · Exported to Chile · Moore James CN113JKKearns Homer Charles III VANS RV-8 · S/N 80271Cancelled Aug 8, 2000 · Triennial form not returned · Kearns Homer C IIIN710WTCessna 402A · S/N 402A-0094Cancelled Apr 3, 2000 · Triennial form not returned · Texas Air Charters IncN667NABeech 200 · S/N BB-667Cancelled Mar 23, 2000 · Exported to Canada · Nebrig & Associates IncN334Larson Stuart E JAVELIN V6STOL · S/N 001Cancelled Aug 6, 1999 · Larson Stuart EN21LLPiper PA-28-235 · S/N 2811235Cancelled Dec 9, 1998 · Altair Aviation IncN81110Grumman American Avn. AA-5B · S/N AA5B0432Cancelled Oct 29, 1997 · Exported to Italy · Italian Aviation Services IncN57GDDeaton Gene G JUNGSTER-I · S/N 7201Cancelled Apr 18, 1997 · Triennial form not returned · Mahon Kelly AN718RSAlon A2 · S/N A82Cancelled Jan 21, 1997 · Watkins Kirt BN4268QRaven S-60A · S/N S60A298Cancelled May 1, 1996 · Triennial form not returned · Hi Rise Ballonport IncN1408HPiper PA-28-181 · S/N 287790311Cancelled Apr 3, 1996 · Exported to United Kingdom · Morris Gene G DdsN72FDSIAI Marchetti F.260C · S/N 729Cancelled May 29, 1986 · Exported to New Zealand · Fox Five One LtdN7414VMooney M20F · S/N 22-1207Cancelled Jun 4, 1985 · Harrison Carlton RN2105XCessna 337 · S/N 337-0005Cancelled Sep 8, 1982 · Built 1964 · Erwin Henry W IIIN4238JPiper PA-28-140 · S/N 28-22590Cancelled Mar 18, 1982 · Built 1967 · Cole Don GN15983Piper PA-34-200 · S/N 34-7350115Cancelled Mar 26, 1979 · Exported to Canada · Built 1973 · Aerosmith Denton IncN79047Cessna 172K · S/N 17257840Cancelled Nov 1, 1977 · Vose P GeorgeN5887LGrumman American Avn. AA-5 · S/N AA5-0087Cancelled Aug 5, 1977 · Exported to Canada · Morris Gene G D D S
Back to Denton, TX