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.

N3757HMooney M20J · S/N 24-0929Cancelled Jan 15, 1980 · Exported to United Kingdom · Mooney Aircraft CorpN231GKMooney M20K · S/N 25-0243Cancelled Dec 19, 1979 · Exported to South Africa · Mooney Aircraft CorpN4797HMooney M20J · S/N 240884Cancelled Nov 6, 1979 · Exported to Australia · Mooney Aircraft CorporationN4778HMooney M20J · S/N 240869Cancelled Oct 18, 1979 · Exported to Australia · Mooney Aircraft CorpN4803HMooney M20J · S/N 24-0885Cancelled Oct 17, 1979 · Exported to Australia · Mooney Aircraft CorpN4764HMooney M20J · S/N 24-0842Cancelled Sep 12, 1979 · Exported to United Kingdom · Mooney Aircraft CorpN4608HMooney M20J · S/N 24-0858Cancelled Aug 27, 1979 · Exported to Australia · Built 1979 · Mooney Aircraft CorpN201HDMooney M20J · S/N 240231Cancelled Jul 19, 1979 · Exported to Netherlands · Martin RsN4714HMooney M20J · S/N 24-0816Cancelled Jul 11, 1979 · Exported to Australia · Mooney Aircraft CorporationN4736HMooney M20J · S/N 24-0830Cancelled Jul 11, 1979 · Exported to Australia · Mooney Aircraft CorpN4708HMooney M20J · S/N 240813Cancelled Jun 21, 1979 · Exported to Australia · Mooney Aircraft CorporationN4724HMooney M20K · S/N 25-0154Cancelled Jun 21, 1979 · Exported to Australia · Mooney Aircraft CorpN4506HMooney M20J · S/N 240783Cancelled Jun 1, 1979 · Exported to Australia · Mooney Aircraft CorpN4453HMooney M20J · S/N 24-0739Cancelled Feb 26, 1979 · Exported to Germany · Built 1978 · Mooney Aircraft CorpN4190HMooney M20J · S/N 24-0659Cancelled Sep 27, 1978 · Exported to Australia · Built 1978 · Mooney Aircraft CorpN4188HMooney M20J · S/N 24-0658Cancelled Sep 1, 1978 · Exported to Australia · Built 1978 · Mooney Aircraft CorpN7057VMooney M20J · S/N 24-0550Cancelled Aug 7, 1978 · Exported to Japan · Mooney Aircraft CorpN4107HMooney M20J · S/N 24-0624Cancelled Jul 17, 1978 · Exported to Australia · Built 1978 · Mooney Aircraft CorpN7063VMooney M20J · S/N 24-0588Cancelled Jul 5, 1978 · Exported to Australia · Mooney Aircraft CorpN5201KMooney M20J · S/N 240579Cancelled Jul 3, 1978 · Exported to Australia · Mooney Aircraft CorpN201YMMooney M20J · S/N 240521Cancelled Jun 14, 1978 · Exported to South Africa · Mooney Aircraft CorpN3614HMooney M20C · S/N 20-1250Cancelled May 15, 1978 · Exported to Australia · Mooney Aircraft CorpN7047VMooney M20J · S/N 24-0454Cancelled Mar 16, 1978 · Exported to Australia · Mooney Aircraft CorpN7050VMooney M20J · S/N 24-0468Cancelled Mar 16, 1978 · Exported to Australia · Mooney Aircraft CorpN201XAMooney M20J · S/N 240379Cancelled Dec 21, 1977 · Exported to Austria · Mooney Aircraft CorpN7039VMooney M20J · S/N 24-0371Cancelled Dec 12, 1977 · Exported to Australia · Mooney Aircraft CorpN7021VMooney M20J · S/N 24-0331Cancelled Dec 8, 1977 · Exported to Australia · Mooney Aircraft CorpN7024VMooney M20J · S/N 24-0335Cancelled Dec 8, 1977 · Exported to Australia · Mooney Aircraft CorpN3572HMooney M20C · S/N 20-1234Cancelled Oct 18, 1977 · Exported to Japan · Built 1977 · Mooney Aircraft CorpN7011VMooney M20J · S/N 24-0272Cancelled Sep 28, 1977 · Exported to Australia · Mooney Aircraft CorpN3547HMooney M20F · S/N 22-1439Cancelled Jul 11, 1977 · Exported to Australia · Built 1977 · Mooney Aircraft CorpN3543HMooney M20C · S/N 20-1229Cancelled Apr 7, 1977 · Exported to Australia · Mooney Aircraft CorpN3533HMooney M20F · S/N 22-1436Cancelled Apr 5, 1977 · Exported to Australia · Built 1977 · Mooney Aircraft CorpN3531HMooney M20C · S/N 20-1225Cancelled Mar 4, 1977 · Exported to Australia · Mooney Aircraft CorpN3532HMooney M20C · S/N 20-1226Cancelled Mar 4, 1977 · Exported to Australia · Mooney Aircraft CorpN7033VMooney M20J · S/N 24-0081Cancelled Mar 4, 1977 · Exported to Australia · Mooney Aircraft CorpN7031VMooney M20J · S/N 24-0024Cancelled Jan 14, 1977 · Exported to Australia · Mooney Aircraft CorpN7032VMooney M20J · S/N 24-0039Cancelled Jan 14, 1977 · Exported to Australia · Mooney Aircraft CorpN7095VMooney M20F · S/N 221423Cancelled Sep 20, 1976 · Exported to Australia · Mooney Aircraft CorpN7088VMooney M20C · S/N 20-1214Cancelled Sep 16, 1976 · Exported to Australia · Mooney Aircraft CorpN7083VMooney M20F · S/N 22-1419Cancelled Aug 27, 1976 · Exported to Australia · Mooney Aircraft CorpN7084VMooney M20F · S/N 22-1420Cancelled Aug 27, 1976 · Exported to Australia · Mooney Aircraft CorpN7062VMooney M20F · S/N 22-1404Cancelled Jul 27, 1976 · Exported to Japan · Mooney Aircraft CorpN7071VMooney M20C · S/N 20-1208Cancelled Jul 23, 1976 · Exported to Australia · Mooney Aircraft CorpN7035VMooney M20F · S/N 22-1382Cancelled Jul 12, 1976 · Exported to Australia · Mooney Aircraft CorpN7065VMooney M20F · S/N 22-1407Cancelled Jul 9, 1976 · Exported to Australia · Mooney Aircraft CorpN7046VMooney M20C · S/N 20-1204Cancelled Jun 25, 1976 · Exported to Australia · Mooney Aircraft CorpN7064VMooney M20F · S/N 22-1406Cancelled Jun 25, 1976 · Exported to Australia · Mooney Aircraft CorpN6394VMooney M20F · S/N 22-1307Cancelled May 14, 1976 · Exported to United Kingdom · Mooney Aircraft CorpN6983VMooney M20F · S/N 22-1345Cancelled May 12, 1976 · Exported to Germany · Mooney Aircraft Corp
Back to Kerrville, TX