OpenAirDocs.org
Fernley, NV

Cancelled registrations · 24

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 = 'NV' AND d.registrant_city = 'FERNLEY'
  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.

N650CSBoeing 737-400 · S/N 27191Cancelled Jul 2, 2022 · Registration expired, pending cancellation · International Aircraft Lease LLCN551HCHarden Carl D CHALLENGER I · S/N 0196-B0604Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1996 · Sylvis Robert LN301APApollo North America JET STAR AS-II · S/N USA250406Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2006 · Shanahan Thomas AN326FEMcdonnell-Douglas DC-10-30 · S/N 47813Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1984 · Logistic Air IncN982AXMcdonnell Douglas DC-9-32 · S/N 47317Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1968 · Logistic Air IncN655DBBehne David S GLASAIR III · S/N 3051Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 2008 · Dsb IncN125FAAero Structures MD-2 · S/N 003Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1995 · Behne David SN908AXMcdonnell Douglas DC-9-31 · S/N 47008Cancelled Mar 31, 2016 · Second renewal notice · Built 1967 · Logistic Air IncN941AXDouglas DC-9-31 · S/N 47419Cancelled Mar 31, 2016 · Second renewal notice · Logistic Air IncN741LABoeing 747-246B · S/N 19824Cancelled Nov 7, 2013 · Second renewal notice · Logistic Air IncN8060EBell 47D1 · S/N 97Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1948 · Pacific Aero Services IncN7006CPiper PA-28-151 · S/N 28-7615039Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1975 · Sanders Dennis JN8417EBell 47G-2A-1 · S/N 2604Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1960 · Pacific Aero Services IncN17765Bell 204 · S/N 442Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Pacific Aero Services IncN7PHBell TH-13T · S/N 3567Cancelled Aug 9, 2012 · Registration pending, canceled · Built 1966N1197WBell 47G-3B-1 · S/N 2951Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Built 1965 · Pacific Aero Services IncN735LABoeing 737-200 · S/N 20574Cancelled Mar 6, 2012 · Exported to Canada · Logistic Air IncN5487XCessna TU206G · S/N U20605801Cancelled Aug 4, 2008 · Exported to Mexico · Built 1980 · Eilrich CalvinN617FFBoeing 747-121 · S/N 19650Cancelled Aug 1, 2008 · Exported to Bangladesh · Built 1970 · Logistic Air IncN553SWBoeing 747-146B · S/N 22067Cancelled Nov 30, 2007 · Exported to Niger · Logistic Air IncN3554KAerostar International S-60A · S/N S60A-3086Cancelled Mar 7, 2000 · Triennial form not returned · Reynolds Charles MN6550BMooney M20A · S/N 1219Cancelled Mar 31, 1998 · Triennial form not returned · Brown Harvey HN7372XCessna 150B · S/N 15059472Cancelled May 27, 1976 · Brush EdwinN8253WPiper PA-28-180 · S/N 28-2403Cancelled Dec 31, 1974 · Henry Daniel D
Back to Fernley, NV