Skip to content

Cancelled registrations · 37

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_state = 'NJ' AND d.registrant_city = 'MONTVALE' 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_state = 'NJ' AND d.registrant_city = 'MONTVALE'
  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_state = 'NJ' AND d.registrant_city = 'MONTVALE'
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 · Noevir Aviation Inc N102NARobinson Helicopter R22 BETA · S/N 4565Cancelled Oct 26, 2023 · Exported to Japan · Built 2012 · Noevir Aviation Inc N204NARobinson Helicopter R44 II · S/N 13125Cancelled Aug 25, 2023 · Exported to Japan · Noevir Aviation Inc N229NAEurocopter EC 130 T2 · S/N 7751Cancelled Jun 10, 2022 · Exported to Canada · Noevir Aviation Inc N475KAAmerican Eurocopter AS350B3 · S/N 4563Cancelled Feb 8, 2022 · Exported to Canada · Noevir Aviation Inc N108NARobinson Helicopter R22 BETA · S/N 4126Cancelled Jul 8, 2021 · Exported to Japan · Noevir Aviation Inc N720NAEurocopter Deutschland EC135T1 · S/N 0124Cancelled Apr 8, 2020 · Exported to Switzerland · Built 2000 · Noevir Aviation Inc N365NAAerospatiale AS 365 N2 · S/N 6496Cancelled Mar 21, 2018 · Exported to Germany · Built 1995 · Noevir Aviation Inc N374YBowers Fly Baby 1-A · S/N 23Cancelled Mar 16, 2018 · Revoked, canceled · Built 1965 · Bond Elwood M N599NAEurocopter AS 350 B3 · S/N 4350Cancelled Feb 13, 2012 · Exported to Canada · Noevir Aviation Inc N590NAEurocopter AS 350 B2 · S/N 1783Cancelled Mar 30, 2010 · Exported to Canada · Built 1984 · Noevir Aviation Inc N611WCEurocopter France AS350B2 · S/N 1219Cancelled Aug 28, 2008 · Exported to South Korea · Built 1980 · Noevir Aviation Inc N365NAAerospatiale SA365N · S/N 6205Cancelled Mar 26, 2008 · Exported to Portugal · Built 1986 · Noevir Aviation Inc N380NAAmerican Eurocopter AS350B2 · S/N 1685Cancelled Mar 3, 2008 · Exported to Canada · Noevir Aviation Inc N70WAHughes Helicopters HUGHES 369D · S/N 1160029DCancelled Dec 28, 2007 · Exported to South Korea · Built 1976 N149SCEurocopter AS 350 B3 · S/N 4201Cancelled Jul 5, 2007 · Exported to Japan · Built 2007 · Noevir Aviation Inc N18732Aerospatiale SA315B · S/N 2521Cancelled Jun 22, 2007 · Exported to Canada · Built 1978 · Noevir Aviation Inc N18MHCessna 421 · S/N 421-0158Cancelled May 17, 2007 · Second triennial mailing, no response · Maresca Michael J DBA N309PRaytheon A36 · S/N E-3622Cancelled Sep 27, 2006 · Exported to Japan · Noevir Aviation Inc N558MBell 206B · S/N 2318Cancelled Jul 7, 2006 · Exported to Sweden · Built 1978 · Noevir Aviation Inc N730SBAerospatiale AS350BA · S/N 1378Cancelled Apr 1, 2005 · Exported to Canada · Built 1981 · Noevir Aviation Inc N953SDMcdonnell Douglas Helicopter 500N · S/N LN070Cancelled Mar 2, 2005 · Exported to New Zealand · Built 1995 · Noevir Aviation Inc N45457Hughes 369HS · S/N 140557SCancelled Dec 15, 2004 · Exported to United Kingdom · Built 1974 · Noevir Aviation Inc N809MMcdonnell Douglas Helicopter 500N · S/N LN 009Cancelled Oct 22, 2004 · Exported to New Zealand · Built 1991 · Noevir Aviation Inc N3070RAerospatiale AS 355F2 · S/N 5508Cancelled Mar 26, 2002 · Exported to South Africa · Noevir Aviation Inc N8744ZCessna P206D · S/N P2060544Cancelled Jul 11, 1996 · Triennial form not returned · Cds Aircraft N5802BAerospatiale AS 355F1 · S/N 5207Cancelled May 20, 1996 · Exported to France · Rts Helicopter Services Corp N57906Aerospatiale AS 355F1 · S/N 5107Cancelled Mar 29, 1996 · Exported to New Zealand · Rts Helicopter Services Corporation N5802NAerospatiale AS 355F1 · S/N 5211Cancelled Mar 29, 1996 · Exported to New Zealand · Rts Helicopter Services Corporation N60972Eurocopter AS 350 B2 ECUREUIL · S/N 2827Cancelled May 5, 1995 · Rts Helicopter Services Corp N3598FS N I A S AS350D ASTAR · S/N 1132Cancelled Dec 9, 1994 · Exported to New Zealand · Rts Aircraft Services Corp N3606XS N I A S AS350D ASTAR · S/N 1234Cancelled Dec 9, 1994 · Exported to New Zealand · Rts Aircraft Services Corp N5774US N I A S AS350D ASTAR · S/N 1388Cancelled Dec 9, 1994 · Exported to New Zealand · Rts Aircraft Services Corp N9427SBeech 95-C55 · S/N TE45Cancelled Sep 28, 1993 · Triennial form not returned · Murray E Burke N333ASBeech A23-19 · S/N MB183Cancelled Jan 30, 1991 · Ronald Rush D N37KABeech 200C · S/N BL-20Cancelled Nov 16, 1982 · Exported to Germany · Built 1981 · Mercedes - Benz Of North America Inc N3205Hiltbruner SCORPION A-1 · S/N AH-002Cancelled Sep 23, 1974 · King Roy

Back to Montvale, NJ