Kerrville, TX

Cancelled registrations · 291

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

N91547Mooney M20R · S/N 29-0050Cancelled Jan 3, 2011 · Expired dealer · Mooney Aircraft CorporationN1105NBeech A36 · S/N E-912Cancelled Apr 15, 2010 · Triennial form not returned · Built 1976 · Barton Amos LN509RTMooney M20R · S/N 29-0509Cancelled Aug 11, 2009 · Exported to Australia · Built 2008 · Mooney Airplane Co IncN3702HMooney M20K · S/N 25-0123Cancelled Jul 10, 2009 · Exported to Germany · Built 1979 · Mooney Aircraft CorpN785RAMooney M20TN · S/N 31-0101Cancelled Jul 16, 2008 · Exported to Australia · Mooney Airplane Co IncN1035SMooney M20TN · S/N 31-0065Cancelled May 1, 2008 · Exported to Australia · Built 2007 · Mooney Airplane Co IncN5310YCessna 210N · S/N 21064158Cancelled Jun 15, 2007 · Exported to Australia · Built 1980 · Stark Arthur RN1046SMooney M20R · S/N 29-0477Cancelled May 15, 2007 · Exported to South Africa · Mooney Airplane Co IncN60YYMooney M20R · S/N 29-0460Cancelled Sep 12, 2006 · Exported to Canada · Built 2006 · Mooney Airplane Co IncN468DAMooney M20R · S/N 29-0408Cancelled Feb 1, 2006 · Mooney Airplane Company IncN913KSMooney M20R · S/N 29-0409Cancelled Feb 1, 2006 · Mooney Airplane Co IncN366GXMooney M20R · S/N 29-0384Cancelled Jan 12, 2006 · Exported to Australia · Built 2005 · Mooney Airplane Co IncN10902Cessna 150L · S/N 15075122Cancelled May 10, 2004 · Triennial form not returned · Built 1973 · Parsons Robert HN997CACessna 500 · S/N 500-0198Cancelled Jul 17, 2003 · Exported to Mexico · Built 1974 · Contrails LLCN1053BMooney M20R · S/N 29-0258Cancelled Apr 15, 2002 · Exported to South Africa · Built 2000 · Mooney Aircraft CorporationN897BMooney M20 · S/N 1060Cancelled May 27, 1999 · Triennial form not returned · Dugosh Aircraft Service Co IncN91648Mooney M20R · S/N 290022Cancelled Apr 6, 1998 · Exported to Paraguay · Mooney Aircraft CorporationN91462Mooney M20M · S/N 270098Cancelled Mar 23, 1998 · Exported to United Kingdom · Mooney Aircraft CorporationN9712PMooney M20K · S/N 250451Cancelled Nov 7, 1997 · Exported to Ecuador · Mooney Aircraft CorporationN2087PFredenburg Richard A CHALLENGER II · S/N 1031Cancelled Jan 16, 1997 · Fredenburg Richard AN91442Mooney M20M · S/N 270217Cancelled Jul 31, 1996 · Exported to South Africa · Mooney Aircraft CorporationN91567Mooney M20J · S/N 243375Cancelled Mar 6, 1996 · Exported to Japan · Mooney Aircraft CorporationN10769Mooney M20R · S/N 290074Cancelled Feb 2, 1996 · Exported to South Africa · Mooney Aircraft CorporationN9157TMooney M20R · S/N 290055Cancelled Sep 5, 1995 · Exported to South Africa · Mooney Aircraft CorporationN9170NMooney M20R · S/N 290032Cancelled Jul 26, 1995 · Exported to South Africa · Mooney Aircraft CorporationN9167HMooney M20R · S/N 290025Cancelled Mar 7, 1995 · Exported to South Africa · Mooney Aircraft CorporationN91642Mooney M20R · S/N 290021Cancelled Jan 20, 1995 · Exported to South Africa · Mooney Aircraft CorporationN9162XMooney M20R · S/N 290014Cancelled Jan 6, 1995 · Exported to South Africa · Mooney Aircraft CorpN9131BMooney M20J · S/N 243348Cancelled Oct 13, 1994 · Exported to South Africa · Mooney Aircraft CorporationN1081WMooney M20J · S/N 243311Cancelled Dec 8, 1993 · Exported to Turkey · Mooney Aircraft CorporationN1082ZMooney M20J · S/N 243314Cancelled Dec 8, 1993 · Exported to Turkey · Mooney Aircraft CorportionN1118RMooney M20J · S/N 241141Cancelled Nov 8, 1993 · Mooney Aircraft CorpN201MMMooney M20J · S/N 240002Cancelled Nov 8, 1993 · Triennial form not returned · Mooney Aircraft CorporationN57881Mooney M20J · S/N 241525Cancelled Nov 12, 1992 · Exported to Portugal · Mooney Aircraft CorporationN5272NMooney M20J · S/N 243084Cancelled Oct 9, 1992 · Exported to Sweden · Mooney Aircraft CorporationN9152BMooney M20M · S/N 270121Cancelled Mar 23, 1992 · Exported to Japan · Mooney Aircraft CorporationN9134ZMooney M20J · S/N 243225Cancelled Jul 10, 1991 · Exported to South Korea · Mooney Aircraft CorpN9135BMooney M20J · S/N 243226Cancelled Jul 10, 1991 · Exported to South Korea · Mooney Aircraft CorpN201AYMooney M20J · S/N 240422Cancelled Feb 19, 1991 · Exported to France · Mooney Aircraft CorpN57422Mooney M20J · S/N 24-1452Cancelled Jan 14, 1985 · Exported to Australia · Mooney Aircraft CorpN5765YMooney M20J · S/N 24-1483Cancelled Jan 11, 1985 · Exported to Australia · Mooney Aircraft CorpN5772FMooney M20J · S/N 24-1499Cancelled Dec 7, 1984 · Exported to Thailand · Mooney Aircraft CorpN5734XMooney M20J · S/N 24-1453Cancelled Aug 24, 1984 · Exported to Thailand · Mooney Aircraft CorpN125RMMcdonnell Robert L KR 2 · S/N 10279Cancelled Jun 19, 1984 · Administratively canceled · Mcdonnell Robert LN5653MMooney M20J · S/N 24-1387Cancelled Oct 19, 1983 · Exported to Canada · Mooney Aircraft CorpN3995HMooney M20J · S/N 24-1004Cancelled May 18, 1983 · Exported to Australia · Built 1980 · Mooney Aircraft CorpN1167WMooney M20K · S/N 25-0693Cancelled Aug 11, 1982 · Exported to United Kingdom · Built 1982 · Mooney Aircraft CorpN1170NMooney M20J · S/N 24-1316Cancelled Aug 11, 1982 · Exported to United Kingdom · Mooney Aircraft CorpN11671Mooney M20J · S/N 241302Cancelled Jun 14, 1982 · Exported to Australia · Built 1982 · Mooney Aircraft CorpN1165KMooney M20J · S/N 24-1294Cancelled May 12, 1982 · Exported to Australia · Built 1982 · Mooney Aircraft Corp
Back to Kerrville, TX