OpenAirDocs.org
Huntington Beach, CA

Cancelled registrations · 156

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 = 'CA' AND d.registrant_city = 'HUNTINGTON BEACH'
  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.

N833STEugene Cannarella MOOSE SR 3500 · S/N 280SRCancelled Feb 9, 2025 · Meines Enterprises LLCN132AKDB Aerocopter AK1-3 · S/N 1001Cancelled Oct 16, 2023 · Exported to Australia · Built 2008 · Christopher Brian HaugN57014Piper PA-32-260 · S/N 32-7400014Cancelled Mar 23, 2023 · Built 1973 · Demartino Ricardo FN521HBMcdonnell Douglas Helicopter 500N · S/N LN084Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1998 · City Of Huntington BeachN7988WDJI PHANTOM 3 PROFESSION · S/N P76DCI15A20338Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Williams Kelly M DBAN522HBMD Helicopters 500N · S/N LN096Cancelled Aug 17, 2022 · Exported to Australia · Built 2001 · City Of Huntington BeachN260CWWieland Charles L CX-4 · S/N 260Cancelled Jan 13, 2022 · First renewal notice · Built 2013 · Wieland Charles LN8015HBeech F33A · S/N CE-1511Cancelled Dec 17, 2021 · Exported to Brazil · Sc Aero IncN322JLLynch Jay A ZODIAC 601XL · S/N 5957Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2011 · Lynch Jay AN8884HNorth American NAVION · S/N NAV-4-884Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1947 · Roberts David AlanN6740JPiper PA-28-140 · S/N 28-24455Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1968 · Four Star Air IncN9959WPiper PA-28-140 · S/N 28-23506Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1967 · Cornick John R Co-TrusteeN153DJDJI PHANTOM 2 VISION + · S/N PH64602739Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Easy Street Partners IncN7444ADJI INSPIRE 1 · S/N W13DCA12020209Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Alviz Mark Anthony VN8170KStinson 108-1 · S/N 108-1170Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1946 · Smith Patrick JN81965Aeronca 7DC · S/N 7AC-590Cancelled Sep 14, 2019 · Revoked, canceled · Built 1946 · Turner Jay PN684TKKaizen Kinetics International KAIZEN EYE · S/N K2I-EY2014-002Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Kaizen Kinetics InternationalN684RKKaizen Kinetics International GUARDIAN · S/N K21-GD2014-004Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Kaizen Kinetics InternationalN744WKAquacopters BULLFROG · S/N K2I-BF2016-010Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Kaizen Kinetics InternationalN947DSDean Verne Smith CH 750 CRUZER · S/N C75-10047Cancelled Mar 21, 2019 · Built 2015 · Smith Dean VerneN6236KAquacopters BULLFROG · S/N K2I-BF2015-008Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Kaizen Kinetics InternationalN611MKKaizen Kinetics International GUARDIAN EE · S/N K2I-GE2015-007Cancelled Mar 8, 2019 · Registration expired, pending cancellation · Kaizen Kinetics InternationalN611PKKaizen Kinetics International PHOENIX · S/N K2I-PX2015-005Cancelled Mar 8, 2019 · Registration expired, pending cancellation · Kaizen Kinetics InternationalN31158Stone-Koppe RAND KR-2 · S/N 6141-3Cancelled Mar 2, 2019 · Revoked, pending cancellation · Built 1977 · Stone Robert LN2258BWarwick Bantam W-3 · S/N 1Cancelled Jul 26, 2018 · Revoked, canceled · Built 1966 · Collord John RN7357EDJI PHANTOM 3 PROFESSION · S/N P76DCD13012707Cancelled Jun 26, 2018 · Registration pending, canceledN9436GCessna TU206E · S/N U20601636Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1971 · Erl George MN2366BGlobe GC-1B · S/N 3666Cancelled Mar 23, 2018 · Revoked, canceled · Built 1948 · Wilkins Robert IN90140Cessna 140 · S/N 9201Cancelled Mar 16, 2018 · Revoked, canceled · Built 1946 · Delapp Henry GN8848ABeech B35 · S/N D-2503Cancelled Mar 1, 2018 · Revoked, pending cancellation · Built 1950 · Armstrong George AN5840TWestland Helicopters WG30 · S/N 006Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1982 · Airspur Helicopters IncN2338BTemco GC-1B · S/N 3638Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1948 · Bunker Donal JN3936Allen David W UMF · S/N 3936Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Allen David WN5830TWestland Helicopters WG30 · S/N 005Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1982 · Airspur Helicopters IncN1099VAero Commander 680 · S/N 680-348-39Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1956 · Schwartz Eric RN6556XCessna 210 · S/N 57556Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1960 · Mile High Flying ClubN7266Turner DER JAGER · S/N 001Cancelled Feb 4, 2017 · Revoked, canceled · Built 1974 · Savage Benjamin HaroldN7473QCessna TU206F · S/N U20602214Cancelled Feb 4, 2017 · Revoked, canceled · Built 1973 · Collins M RudolphN7510BChampion 7FC · S/N 7FC15Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Hefner DonN89517Cessna 140 · S/N 8553Cancelled Jan 25, 2017 · Revoked, pending cancellation · Built 1946 · Regan Joseph E Co OwN364WLCessna 172S · S/N 172S9590Cancelled Jul 22, 2016 · Exported to Thailand · Built 2004 · Campanella Drew SN5168SCessna R182 · S/N R18201512Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1980 · Brennan Thomas WN86943Bellanca 14-13 · S/N 1305Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1946 · Bolstad John WN6720FCessna 150F · S/N 15063320Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1966 · Wilson MarkN419PSAerostar International S-60A · S/N S60A-3145Cancelled May 4, 2015 · Registration expired, pending cancellation · Schafer PaulN161CWPiper PA-28-161 · S/N 28-7816324Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Wilson Cassandra NN51086Cessna 150J · S/N 15069754Cancelled Dec 22, 2014 · Revoked, canceled · Built 1968 · Fleming Bill R DBAN124HBBiddle Charles R CIRCA NIEUPORT 11 · S/N 1322Cancelled Dec 19, 2014 · Registration expired, pending cancellation · Biddle Charles RN54HBHughes 269B · S/N 1280405Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1968 · Perkins Jeffrey MN7341WPiper PA-28-180 · S/N 28-1212Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1963 · Landers Robert K
Back to Huntington Beach, CA