OpenAirDocs.org
Toms River, NJ

Cancelled registrations · 27

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 = 'NJ' AND d.registrant_city = 'TOMS RIVER'
  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.

N673KJDJI PHANTOM 3 PROFESSION · S/N P76DCI15A20505Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Oleske Joseph A IIIN2471XCessna 182H · S/N 18256371Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1965 · Aer O Nauts IncN10537Lotano Gary V VOLKSPLANE-2 · S/N NGAN-77Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Lotano Gary VN3641PPiper PA-22-150 · S/N 22-3392Cancelled May 31, 2017 · Registration expired, pending cancellation · Bass AllanN2160XCessna 337 · S/N 3370060Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1965 · Bianchi CesarN15480Piper PA-28-140 · S/N 28-7325075Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1972 · Ocean Aviation IncN31896Aeronca 65-CA · S/N CA11741Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Bass AllanN9950UGrumman American Avn. AA-1C · S/N AA1C0164Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1978 · Read Franklin SN7915DBeech H35 · S/N D-5216Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1957 · Sonoskus Joseph M DBAN2609MPiper PA-12 · S/N 12-1075Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1946 · Bass AllanN2280FStinson 108-2 · S/N 108-3295Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Bass AllanN1135CPiper PA-22-135 · S/N 22-971Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Bass AllanN156RCessna 310 · S/N 35198Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1955 · Bass AllanN5128BCessna 152 · S/N 15283765Cancelled Feb 8, 2010 · Exported to Canada · Built 1979 · Monmouth Aircraft Service IncN15698Piper PA-34-200 · S/N 34-7350087Cancelled May 8, 2009 · Registration revoked · Built 1972 · Cherokee Enterprises IncN28JPBeech A36 · S/N E-621Cancelled Sep 29, 2000 · Triennial form not returned · Pizzolato JackN51JCCucco John R 7/10 SCALE P-51D · S/N 86-001Cancelled Jul 6, 1999 · Triennial form not returned · Cucco John RN86ANNewman Robert C SEA HAWK · S/N 33Cancelled Oct 3, 1997 · Triennial form not returned · Newman Robert CN8551ABeech A35 · S/N D1973Cancelled Dec 6, 1994 · Triennial form not returned · Treidel Kenneth MN15VPBeech 35-C33 · S/N CD1024Cancelled Apr 20, 1992 · Triennial form not returned · Vanderploeg RichardN48470Cessna 152 · S/N 15283340Cancelled Jun 2, 1980 · Exported to Canada · Ocean Aviation IncN43100Piper PA-28R-200 · S/N 28R-7435247Cancelled Dec 5, 1974 · Ocean Aviation IncN83740Aeronca 7AC · S/N 7AC-2418Cancelled May 22, 1965 · Tiffany Ivins GrantN92073Piper J3C-65 · S/N 16506Cancelled Jul 15, 1958 · Exported to Germany · Bass Allan AN25747Piper J3L-65 · S/N 3706Cancelled Nov 7, 1957 · Exported to Switzerland · Bass Allan AN9979Travel Air 2000 · S/N 1136Cancelled Jul 14, 1948 · Frank FellnerN5850Waco GXE · S/N 1578Cancelled Jun 28, 1929 · Messer Kermit Wesslock
Back to Toms River, NJ