New Carlisle, OH

Cancelled registrations · 16

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 = 'OH' AND d.registrant_city = 'NEW CARLISLE'
  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.

N19732Aeronca K · S/N K-255Cancelled Jun 29, 2026 · Sale reported, canceled · Built 1937N19741Aeronca K · S/N K-247Cancelled Jun 29, 2026 · Sale reported, canceled · Built 1937N7637BAeronca KS · S/N K318Cancelled Jun 29, 2026 · Sale reported, canceled · Built 1938N4178KRyan NAVION · S/N NAV-4-1178Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Gevedon Craig AN93817Engineering & Research ERCOUPE 415-C · S/N 1140Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Land Richard WN99616Engineering & Research 415-D · S/N 2239Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1946 · Land Richard WN7624CBuckeye DREAM · S/N 5457Cancelled Dec 18, 2018 · Registration expired, pending cancellation · Built 2007 · Brewer Kurt AN704UNCessna 150M · S/N 15078886Cancelled Sep 7, 2016 · Exported to Bolivia · Built 1976 · Louderback Family Investments IncN131LWWhitaker Larry J WHITAKER CENTERWING · S/N CW002Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Whitaker Larry JN7506JPiper PA-28R-180 · S/N 28R-30871Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1968 · Bowen Robert WN5189CBeech B35 · S/N D-2471Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1950 · Loghman John FN7152UMooney M20E · S/N 391Cancelled Feb 4, 2010 · Exported to Canada · Built 1964 · Jones Randall EN6143PPiper PA-24 · S/N 241244Cancelled Jun 17, 1991 · Triennial form not returned · Bowen Robert WN49091Quick Silver EIPPER MX II · S/N 1420128Cancelled Mar 16, 1984 · Built 1983 · Combs DewayneN26312Aeronca 50 LA · S/N L-7780Cancelled Feb 21, 1956 · Browning Paul WN1023Advance WACO 7 · S/N 120Cancelled Jun 8, 1935 · Martin W C
Back to New Carlisle, OH