Earlier aircraft under this name · 23

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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_name = 'NOEVIR AVIATION INC' OR list_contains(d.other_registrant_names, 'NOEVIR AVIATION INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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_name = 'NOEVIR AVIATION INC' OR list_contains(d.other_registrant_names, 'NOEVIR AVIATION INC')
  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.

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_name = 'NOEVIR AVIATION INC' OR list_contains(d.other_registrant_names, 'NOEVIR AVIATION INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N101NAAirbus Helicopters AS 350B3 · S/N 7970Cancelled Apr 12, 2024 · Exported to Canada · Built 2014 · Montvale, NJ N102NARobinson Helicopter R22 BETA · S/N 4565Cancelled Oct 26, 2023 · Exported to Japan · Built 2012 · Montvale, NJ N204NARobinson Helicopter R44 II · S/N 13125Cancelled Aug 25, 2023 · Exported to Japan · Montvale, NJ N229NAEurocopter EC 130 T2 · S/N 7751Cancelled Jun 10, 2022 · Exported to Canada · Montvale, NJ N475KAAmerican Eurocopter AS350B3 · S/N 4563Cancelled Feb 8, 2022 · Exported to Canada · Montvale, NJ N108NARobinson Helicopter R22 BETA · S/N 4126Cancelled Jul 8, 2021 · Exported to Japan · Montvale, NJ N720NAEurocopter Deutschland EC135T1 · S/N 0124Cancelled Apr 8, 2020 · Exported to Switzerland · Built 2000 · Montvale, NJ N365NAAerospatiale AS 365 N2 · S/N 6496Cancelled Mar 21, 2018 · Exported to Germany · Built 1995 · Montvale, NJ N680NACessna 680 · S/N 680-0526Cancelled Dec 12, 2016 · Exported to Japan · Built 2014 · Wilmington, DE N599NAEurocopter AS 350 B3 · S/N 4350Cancelled Feb 13, 2012 · Exported to Canada · Montvale, NJ N590NAEurocopter AS 350 B2 · S/N 1783Cancelled Mar 30, 2010 · Exported to Canada · Built 1984 · Montvale, NJ N611WCEurocopter France AS350B2 · S/N 1219Cancelled Aug 28, 2008 · Exported to South Korea · Built 1980 · Montvale, NJ N365NAAerospatiale SA365N · S/N 6205Cancelled Mar 26, 2008 · Exported to Portugal · Built 1986 · Montvale, NJ N380NAAmerican Eurocopter AS350B2 · S/N 1685Cancelled Mar 3, 2008 · Exported to Canada · Montvale, NJ N149SCEurocopter AS 350 B3 · S/N 4201Cancelled Jul 5, 2007 · Exported to Japan · Built 2007 · Montvale, NJ N18732Aerospatiale SA315B · S/N 2521Cancelled Jun 22, 2007 · Exported to Canada · Built 1978 · Montvale, NJ N309PRaytheon A36 · S/N E-3622Cancelled Sep 27, 2006 · Exported to Japan · Montvale, NJ N558MBell 206B · S/N 2318Cancelled Jul 7, 2006 · Exported to Sweden · Built 1978 · Montvale, NJ N730SBAerospatiale AS350BA · S/N 1378Cancelled Apr 1, 2005 · Exported to Canada · Built 1981 · Montvale, NJ N953SDMcdonnell Douglas Helicopter 500N · S/N LN070Cancelled Mar 2, 2005 · Exported to New Zealand · Built 1995 · Montvale, NJ N45457Hughes 369HS · S/N 140557SCancelled Dec 15, 2004 · Exported to United Kingdom · Built 1974 · Montvale, NJ N809MMcdonnell Douglas Helicopter 500N · S/N LN 009Cancelled Oct 22, 2004 · Exported to New Zealand · Built 1991 · Montvale, NJ N3070RAerospatiale AS 355F2 · S/N 5508Cancelled Mar 26, 2002 · Exported to South Africa · Montvale, NJ

Back to Noevir Aviation Inc