OpenAirDocs.org
Kahului, HI

Cancelled registrations · 47

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 = 'HI' AND d.registrant_city = 'KAHULUI'
  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.

N718LDCirrus Design SR20 · S/N 1463Cancelled Nov 16, 2024 · Registration pending, canceled · Built 2004N808SRSimon Ralf KR 2 M · S/N 8306-6513Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Makai Sky IncN6455WDJI S900 · S/N 070064062Cancelled May 6, 2019 · Registration expired, pending cancellation · Franco Winston CN189WFDJI PHANTOM 2 · S/N PH646062030Cancelled May 4, 2019 · Registration expired, pending cancellation · Franco Winston CN1076CBell 204 · S/N 157841Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Pacific Helicopter Tours IncN64FBell 204-B · S/N 2027Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Pacific Helicopter Tours IncN4963FBell TH-1L · S/N 157809Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1969 · Pacific Helicopter Services LLCN1113LHughes Helicopters HUGHES 369D · S/N 1100837DCancelled Jan 9, 2018 · Registration expired, pending cancellation · Pacific Helicopter Tours IncN8625FHughes Helicopters HUGHES 369D · S/N 470111DCancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1977 · Alexander Steven HN529RSBell 206B · S/N 989Cancelled May 31, 2017 · Registration expired, pending cancellation · Pacific Helicopter Tours IncN9041FHughes 369HS · S/N 990201SCancelled May 23, 2017 · Registration expired, pending cancellation · Built 1969 · Pacific Helicopter Tours IncN503AHBell 206B · S/N 686Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1971 · Pacific Helicopter Tours IncN4234LPartenavia P66C · S/N 225Cancelled May 5, 2015 · Registration expired, pending cancellation · Paragon Air IncN3280UBell UH-1H · S/N 66-16904Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Built 1966 · Pacific Helicopter Services LLCN483VAPiper PA-31-350 · S/N 31-7552124Cancelled Aug 27, 2014 · Second renewal notice · Built 1975 · Maui Aircraft Leasing LLCN88898Emroth-Emair MA-1B · S/N 040Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1978N9792CHiller UH-12E · S/N 2277Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1963N9205FHughes 369HS · S/N 440583SCancelled May 22, 2013 · Registration expired, pending cancellation · Built 1974 · Alexander Steven HN8293Hiller UH-12E · S/N 1573Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1964 · Pacific Helicopter Services LLCN6210BAero Commander 560-E · S/N 610Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1958 · Air Maui Flight Services IncN9919MEmroth-Emair MA-1B · S/N 034Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1977N88899Emroth-Emair MA-1B · S/N 041Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1978N88910Emroth-Emair MA-1B · S/N 043Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1986N3246QCessna 402 · S/N 402-0046Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1967 · Air Maui Flight Services IncN30775Piper PA-28-161 · S/N 28-7816547Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1978 · D & B Flying IncN58240Hughes Helicopters HUGHES 369D · S/N 890560DCancelled Aug 13, 2012 · Registration expired, pending cancellation · Pacific Helicopter Tours IncN87EWAerospatiale AS350BA · S/N 2116Cancelled Jun 1, 2012 · Built 1988 · Sunshine Helicopters IncN130WSEurocopter EC 130 B4 · S/N 3685Cancelled Sep 9, 2009 · Triennial form not returned · Built 2003 · Sunshine Helicopters IncN4064FEurocopter AS 350 BA · S/N 3087Cancelled Feb 14, 2008 · Exported to Canada · Built 1998 · Sunshine Helicopters IncN3607PAerospatiale AS350BA · S/N 1249Cancelled Apr 10, 2006 · Triennial form not returned · Built 1979 · Sunshine Helicopters IncN4073SEurocopter AS 350 BA · S/N 3041Cancelled Jan 21, 2005 · Exported to Canada · Sunshine Helicopters IncN633WAHughes Helicopters HUGHES 369D · S/N 042DCancelled May 14, 2004 · Triennial form not returned · Windward Aviation IncN655WAHughes Helicopters HUGHES 369D · S/N 400711DCancelled Apr 22, 2004 · Exported to United Kingdom · Built 1980 · Windward Aviation IncN622WAHughes Helicopters HUGHES 369D · S/N 200674DCancelled Mar 19, 2004 · Exported to United Kingdom · Built 1980 · Windward Aviation IncN5782DAerospatiale AS 355F1 · S/N 5076Cancelled Jun 13, 2003 · Exported to Canada · Built 1982 · Hawaii HelicoptersN5799ZAerospatiale AS 355F1 · S/N 5188Cancelled Jun 13, 2003 · Exported to Canada · Hawaii Helicopters IncN57936Aerospatiale AS 355F1 · S/N 5129Cancelled May 28, 2003 · Exported to Canada · Hawaii Helicopters IncN510TGAerospatiale AS 355F1 · S/N 5168Cancelled Apr 29, 2002 · Triennial form not returned · Built 1982 · Helicopter Consultants Of Maui Inc DBAN836FCPiper PA-28-140 · S/N 28-22236Cancelled Sep 25, 2000 · Triennial form not returned · Helicopter Consultants Of Maui IncN112HDMcdonnell Douglas Helicopter 500N · S/N LN008Cancelled Oct 30, 1998 · Triennial form not returned · Windward Aviation IncN350SMS N I A S AS-350B ECUREUIL · S/N 1488Cancelled Oct 10, 1997 · Triennial form not returned · Hawaii Helicopters IncN6262NBell 206A · S/N 133Cancelled Feb 12, 1997 · Triennial form not returned · Pacific Helicopter Tours IncN9495ECessna 182R · S/N 18268419Cancelled May 16, 1996 · Exported to New Zealand · American Pacific Air IncN42434Bell 212 · S/N 30768Cancelled Oct 21, 1993 · Exported to Canada · Built 1976 · Pacific Helicopter Tours IncN5956WPiper PA-28-160 · S/N 28-3714Cancelled Apr 12, 1983 · Sanovik LarryN3811QCessna 172L · S/N 17259911Cancelled Aug 7, 1982 · Built 1972 · Talon AirN16803Corben JUNIOR ACE · S/N A-136Cancellation date not recorded · Built 1936 · Miller Charles
Back to Kahului, HI