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.

N1076CMooney M20J · S/N 241165Cancelled Feb 11, 1982 · Exported to Chile · Mooney Aircraft CorpN1155RMooney M20J · S/N 241246Cancelled Feb 2, 1982 · Exported to South Africa · Mooney Aircraft CorpN1158ZMooney M20K · S/N 25-0650Cancelled Feb 2, 1982 · Exported to South Africa · Built 1982 · Mooney Aircraft CorpN1154TMooney M20K · S/N 25-0637Cancelled Jan 7, 1982 · Exported to South Africa · Built 1981 · Mooney Aircraft CorpN1141XMooney M20J · S/N 24-1169Cancelled Nov 20, 1981 · Exported to Australia · Built 1981 · Mooney Aircraft CorpN1148ZMooney M20K · S/N 25-0600Cancelled Oct 19, 1981 · Exported to South Africa · Built 1981 · Mooney Aircraft CorpN231LZMooney M20K · S/N 250306Cancelled Sep 29, 1981 · Exported to Australia · Built 1980 · Mooney Aircraft CorpN1092SMooney M20K · S/N 25-0586Cancelled Sep 24, 1981 · Exported to South Africa · Built 1981 · Mooney Aircraft CorpN1141YMooney M20J · S/N 24-1170Cancelled Aug 20, 1981 · Exported to South Africa · Built 1981 · Mooney Aircraft CorpN1138DMooney M20J · S/N 24-1142Cancelled Aug 5, 1981 · Exported to Australia · Built 1981 · Mooney Aircraft CorpN1098TMooney M20K · S/N 25-0568Cancelled Aug 3, 1981 · Exported to South Africa · Built 1981 · Mooney Aircraft CorpN1064BMooney M20J · S/N 24-1122Cancelled Jun 29, 1981 · Exported to Australia · Mooney Aircraft CorpN10837Mooney M20J · S/N 24-1128Cancelled Jun 29, 1981 · Exported to South Africa · Built 1981 · Mooney Aircraft CorpN97827Mooney M20J · S/N 24-1081Cancelled Jun 29, 1981 · Exported to Australia · Mooney Aircraft CorpN9900FMooney M20J · S/N 24-1090Cancelled Jun 29, 1981 · Exported to Australia · Mooney Aircraft CorpN10248Mooney M20J · S/N 24-1114Cancelled May 29, 1981 · Exported to South Africa · Mooney Aircraft CorpN9923SMooney M20J · S/N 24-1094Cancelled May 27, 1981 · Exported to United Kingdom · Mooney Aircraft CorpN97080Mooney M20J · S/N 24-1077Cancelled May 8, 1981 · Exported to Australia · Mooney Aircraft CorpN9898MMooney M20J · S/N 24-1087Cancelled Apr 24, 1981 · Exported to South Africa · Mooney Aircraft CorpN9857PMooney M20K · S/N 25-0536Cancelled Apr 21, 1981 · Exported to Canada · Mooney Aircraft CorpN3356XMooney M20F · S/N 660002Cancelled Mar 13, 1981 · Dugosh Aircraft Serv Co IncN93173Mooney M20J · S/N 24-1064Cancelled Feb 5, 1981 · Exported to Australia · Mooney Aircraft CorpN3597HMooney M20J · S/N 241060Cancelled Jan 19, 1981 · Exported to South Africa · Built 1980 · Mooney Aircraft CorpN3739HMooney M20J · S/N 24-1042Cancelled Dec 9, 1980 · Exported to South Africa · Mooney Aircraft CorpN97158Mooney M20K · S/N 25-0464Cancelled Dec 9, 1980 · Exported to South Africa · Mooney Aircraft CorpN3574HMooney M20K · S/N 25-0425Cancelled Nov 12, 1980 · Exported to Japan · Mooney Aircraft CorpN4051HMooney M20J · S/N 24-1021Cancelled Oct 24, 1980 · Exported to Australia · Mooney Aircraft CorpN3554HMooney M20K · S/N 25-0420Cancelled Sep 19, 1980 · Exported to South Africa · Mooney Aircraft CorpN4066HMooney M20J · S/N 24-0984Cancelled Sep 4, 1980 · Exported to South Africa · Mooney Aircraft CorpN4062HMooney M20K · S/N 25-0401Cancelled Aug 14, 1980 · Exported to United Kingdom · Mooney Aircraft CorpN3999HMooney M20J · S/N 24-1007Cancelled Aug 5, 1980 · Exported to South Africa · Built 1980 · Mooney Aircraft CorpN3938HMooney M20J · S/N 24-0987Cancelled Jul 16, 1980 · Exported to South Africa · Built 1980 · Mooney Aircraft CorpN231QNMooney M20K · S/N 250363Cancelled Jun 6, 1980 · Exported to Australia · Built 1980 · Mooney Aircraft CorpN3839HMooney M20J · S/N 240958Cancelled May 30, 1980 · Exported to United Kingdom · Built 1980 · Mooney Aircraft CorpN3961HMooney M20J · S/N 24-0994Cancelled May 14, 1980 · Exported to South Africa · Built 1980 · Mooney Aircraft CorpN231MVMooney M20K · S/N 250315Cancelled Apr 17, 1980 · Exported to Sweden · Mooney Aircraft CorpN3872HMooney M20J · S/N 24-0968Cancelled Apr 9, 1980 · Exported to Australia · Mooney Aircraft CorpN231PUMooney M20K · S/N 25-0346Cancelled Apr 7, 1980 · Exported to Canada · Mooney Aircraft CorpN231QSMooney M20K · S/N 25-0366Cancelled Apr 4, 1980 · Exported to Switzerland · Mooney Aircraft CorpN231QUMooney M20K · S/N 25-0368Cancelled Apr 4, 1980 · Exported to Switzerland · Mooney Aircrafr CorpN3817HMooney M20J · S/N 24-0949Cancelled Mar 27, 1980 · Exported to South Africa · Built 1980 · Mooney Aircraft CorpN3824HMooney M20J · S/N 240952Cancelled Mar 12, 1980 · Exported to Australia · Built 1980 · Mooney Aircraft CorpN231LQMooney M20K · S/N 25-0301Cancelled Mar 10, 1980 · Exported to United Kingdom · Built 1980 · Mooney Aircraft CorpN4770HMooney M20J · S/N 24-0889Cancelled Mar 6, 1980 · Exported to Germany · Built 1979 · Mooney Aircraft CorporationN3738HMooney M20J · S/N 24-0915Cancelled Mar 3, 1980 · Exported to Australia · Mooney Aircraft CorpN3763HMooney M20J · S/N 24-0932Cancelled Mar 3, 1980 · Exported to South Africa · Mooney Aircraft CorpN231LHMooney M20K · S/N 250297Cancelled Feb 5, 1980 · Exported to Australia · Mooney Aircraft CorpN3754HMooney M20J · S/N 24-0926Cancelled Feb 5, 1980 · Exported to Australia · Built 1979 · Mooney Aircraft CorpN4788HMooney M20J · S/N 24-0878Cancelled Feb 1, 1980 · Exported to New Zealand · Built 1979 · Mooney Aircraft CorporationN231HDMooney M20K · S/N 25-0256Cancelled Jan 18, 1980 · Exported to Germany · Built 1979 · Mooney Aircraft Corp
Back to Kerrville, TX