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.

N6886VMooney M20F · S/N 22-1273Cancelled Sep 18, 1975 · Exported to South Africa · Mooney Aircraft CorpN6844VMooney M20E · S/N 21-1178Cancelled Aug 20, 1975 · Exported to Germany · Mooney Aircraft CorpN4545HMooney M20J · S/N 24-0798Cancelled Jun 5, 1975 · Exported to Australia · Built 1979 · Monney Aircraft CorpN7425VMooney M20E · S/N 21-1165Cancelled May 27, 1975 · Exported to Australia · Mooney Aircraft CorpN2722WMooney M22 · S/N 660004Cancelled May 8, 1975 · Mooney Aircraft CorpN3422XMooney M22 · S/N 660005Cancelled May 8, 1975 · Mooney Aircraft CorpN7404VMooney M20F · S/N 22-1197Cancelled Apr 2, 1975 · Exported to Venezuela · Mooney Aircraft CorpN7168VMooney M20F · S/N 22-0077Cancelled Mar 12, 1975 · Exported to New Zealand · Mooney Aircraft CorpN7160VMooney M20F · S/N 220069Cancelled Mar 5, 1975 · Exported to Venezuela · Mooney Aircraft CorpN7118VMooney M20C · S/N 20-0031Cancelled Dec 3, 1974 · Exported to Australia · Mooney Aircraft CorpN7129VMooney M20F · S/N 22-0058Cancelled Dec 3, 1974 · Exported to Australia · Mooney Aircraft CorpN7108VMooney M20F · S/N 22-0043Cancelled Oct 17, 1974 · Exported to South Africa · Mooney Aircraft CorpN7795MMooney M20F · S/N 22-0037Cancelled Sep 16, 1974 · Exported to South Africa · Mooney Aircraft CorpN7796MMooney M20F · S/N 22-0038Cancelled Sep 13, 1974 · Exported to South Africa · Mooney Aircraft CorpN7779MMooney M20E · S/N 220034Cancelled Aug 15, 1974 · Exported to South Africa · Mooney Aircraft CorpN6729UMooney M20E · S/N 101Cancelled Aug 2, 1974 · Mooney CorpN3418XMooney M20E · S/N 1117Cancelled Jul 16, 1974 · Mooney Acft IncN7756MMooney M20F · S/N 22-0018Cancelled May 23, 1974 · Exported to South Africa · Mooney Aircraft CorpN317UPCessna 182L · S/N 18259297Cancelled Apr 19, 1974 · Exported to Canada · Kerrville Flying Service IncN701WAero Commander 560-E · S/N 562Cancelled Mar 1, 1974 · Lewis JimN4093Minijet MJ-1 · S/N 000001Cancelled Jun 22, 1973 · Melenric John AN9617VAerostar Acft Corp Of Texas M20E · S/N 21-0023Cancelled Feb 28, 1972 · Exported to United Kingdom · Built 1971 · Aerostar Aircraft CorpN9619VMooney M20F · S/N 22-0010Cancelled Jul 13, 1971 · Exported to Germany · Built 1970 · Aerostar Aircraft Corp Of TxN9611VAerostar Acft Corp Of Texas M20E · S/N 21-0017Cancelled May 27, 1971 · Exported to Switzerland · Built 1970 · Aerostar Aircraft Corp Of TexasN9432VMooney M20C · S/N 700045Cancelled Mar 31, 1971 · Exported to Cameroon · Built 1970 · Aerostar Aircraft Corp Of TexasN9448VMooney M20E · S/N 700032Cancelled Mar 31, 1971 · Exported to Cameroon · Built 1970 · Aerostar Aircraft CorpN7734MMooney M22 · S/N 700001Cancelled Mar 25, 1971 · Exported to Switzerland · Aerostar Aircraft CorpN6681RMooney M20E · S/N 424Cancelled Mar 1, 1971 · Exported to Australia · Mooney Aircraft IncN9122LMooney M22 · S/N 650001Cancelled Feb 25, 1971 · Mooney Aircraft IncN5709QMooney M20 · S/N 3107Cancelled Feb 23, 1971 · Mooney Acft IncN79863Mooney M20E · S/N 526Cancelled Feb 11, 1971 · Mooney Acft NcN79864Mooney M20E · S/N 527Cancelled Feb 11, 1971 · Mooney Acft IncN78879Mooney M20C · S/N 2938Cancelled Feb 10, 1971 · Mooney Acft IncN7724MMooney M22 · S/N 680015Cancelled Feb 8, 1971 · Mooney CorpN6678RMooney M20 · S/N 2785Cancelled Feb 5, 1971 · Mooney Acft IncN6679RMooney M20 · S/N 2786Cancelled Feb 5, 1971 · Exported to Australia · Mooney Acft IncN7194UMooney M20E · S/N 412Cancelled Feb 3, 1971 · Mooney Acft IncN5944QMooney M20C · S/N 3188Cancelled Feb 1, 1971 · Mooney Acft IncN9446VMooney M20F · S/N 700035Cancelled Dec 22, 1970 · Exported to Germany · Built 1970 · Aerostar AircraftN9431VMooney M20E · S/N 700028Cancelled Nov 2, 1970 · Exported to Italy · Built 1970 · Mooney Aircraft CorpN6764VMooney M20E · S/N 700055Cancelled Oct 28, 1970 · Exported to Japan · Mooney Aircraft CorpN9476VMooney M20F · S/N 700044Cancelled Sep 23, 1970 · Exported to Germany · Built 1970 · Piper Aircraft CorpN9247VMooney M20F · S/N 690067Cancelled Aug 25, 1970 · Exported to Argentina · Built 1969 · Mooney Aircraft CorpN9470VMooney M20F · S/N 700041Cancelled Jul 10, 1970 · Exported to Australia · Built 1970 · Mooney Aircraft CorpN7729MMooney M22 · S/N 690004Cancelled Dec 18, 1969 · Exported to Switzerland · Mooney Aircraft CorpN5401FAlon A-3 · S/N C-1Cancelled Nov 14, 1969 · Mooney Aircraft CorpN7731MMooney M22 · S/N 690006Cancelled Oct 16, 1969 · Mooney Aircraft CorporationN7732MMooney M22 · S/N 690007Cancelled Oct 16, 1969 · Mooney Aircraft CorporationN7733MMooney M22 · S/N 690008Cancelled Oct 16, 1969 · Mooney Aircraft CorporationN9779MMooney M20F · S/N 680196Cancelled Oct 1, 1969 · Exported to Venezuela · Mooney Corp
Back to Kerrville, TX