OpenAirDocs.org
Santa Barbara, CA

Cancelled registrations · 166

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 = 'SANTA BARBARA'
  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.

N32371Piper PA-32-300 · S/N 32-7540035Cancelled Dec 3, 2025 · Built 1974 · Brunner Eberhard RN114SVJames D Bassage JAYBIRD · S/N 1Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2014 · Bassage James DN523SBDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCH28010469Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Robinson Scott WN150ERCessna 150M · S/N 15077332Cancelled Jul 21, 2021 · Third renewal notice · Built 1975 · Richards RobertN350CLLindros Carl Tte LANCAIR IV · S/N 021Cancelled Jan 7, 2020 · Built 1996 · Lindros Carl TrusteeN188MAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0502Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Built 2016 · Wilson Matthew EN2154BLuscombe 8A · S/N 6581Cancelled Oct 25, 2019 · Revoked, canceled · Built 1949 · Dunbar Glenn MN48673Fairchild M-62A · S/N T411193Cancelled Sep 27, 2019 · Revoked, canceled · Built 1941 · Kaupp RobertN1410APiper PA-22 · S/N 22-320Cancelled Sep 6, 2019 · Revoked, canceled · Built 1951 · Bettison HaroldN652VLDJI PHANTOM 2 · S/N PH645331318Cancelled Sep 6, 2019 · Registration expired, pending cancellation · M4 Consulting IncN512HRDJI INSPIRE 1 · S/N W13DCE15030314Cancelled Jun 10, 2019 · Registration expired · Rabin Harry RN314GGDJI PHANTOM 3 PROFESSION · S/N P78DCE18033742Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Garrison Gavin SN88NHRobinson Helicopter R44 · S/N 2315Cancelled Aug 17, 2018 · Exported to Philippines · Built 2013 · Nanco Helicopters LLCN3460Let BLANIK L-13 · S/N 173930Cancelled Aug 13, 2018 · Registration expired, pending cancellation · Built 1969 · El Mirage Soaring ClubN604HQBombardier CL-600-2B16 · S/N 5583Cancelled Jul 2, 2018 · Exported to San Marino · Built 2004 · Pinkevich Tim TrusteeN3368JCessna 150G · S/N 15066068Cancelled May 30, 2018 · Sale reported, canceled · Built 1967N4972JPiper PA-28R-180 · S/N 28R-30723Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1968 · Trimble Robert JN46012Cessna 172I · S/N 17256987Cancelled Apr 19, 2018 · Built 1968 · Above All Aviation IncN50797Schweizer TG-2 · S/N 41Cancelled Apr 5, 2018 · Revoked, canceled · Built 1942 · Santa Barbara Soaring ClubN116CMooney M-18L · S/N 77Cancelled Mar 23, 2018 · Revoked, canceled · Built 1950 · Richardson IvanN65ASSzybowcowy Zaklad Doswiadczaln JANTAR-2A-SZD 42-1 · S/N B-788Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1977 · Winkler GeneN406AEEurocopter EC120B · S/N 1097Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 2000 · N2cm LLCN321RBell 47G-2 · S/N 397Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Aero Banc Of America IncN179JMOsgood John H SAFARI · S/N S2101Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2004 · Osgood John HN2454UCessna 172D · S/N 17250054Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1963 · Ross Lenny AN46TTMiller Robert Paul JX THUNDER-GULL · S/N 62694Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Miller Robert PN8653TCessna 182C · S/N 52553Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1960 · Stratman Donald WN803ZGPiper PA-32R-301T · S/N 3257357Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2004 · J P III Enterprises IncN80XPAero Design Eleven 12 · S/N 0001Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Callahan Roger ClintonN6GNNiva THORP T-18 · S/N 364Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Kimbell Charles GN40528Robinson Helicopter R22 BETA · S/N 1768Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1991 · Manhattan Banker CorpN495FFouga 6 CM 170 · S/N 495Cancelled May 15, 2017 · Registration expired, pending cancellation · Aerobanc Of America IncN2185Sportavia-Putzer FOURNIER R.F.4.D · S/N 4076Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1968 · Bell Richard HN224PZPzl-Swidnik PW-5 · S/N 17.09.016Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1997 · Galle Steven CN231QAMooney M20K · S/N 25-0352Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1980 · Staves Joan BN40225Beech T-34C-1 · S/N GM-45Cancelled May 6, 2015 · Registration expired, pending cancellation · Excel LtdN7283QCessna 172L · S/N 17260583Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1972 · Truex Don LN1796KLuscombe 8A · S/N 4523Cancelled Dec 22, 2014 · Revoked, canceled · Built 1946 · Dunbar Glenn MN30093Swearingen SA227-AC · S/N AC-449Cancelled Dec 2, 2014 · Registration expired, pending cancellation · N P Metro PartnershipN11794Eldridge Robert E QUICKIE · S/N 131Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1982 · Eldridge Robert EN2010PPiper PA-23 · S/N 23-973Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1957 · Caba James RN696TBeech F50 · S/N FH-93Cancelled Sep 3, 2014 · Revoked, canceled · Built 1958 · Raymond Miller Associates IncN680SSAero Commander 500 S · S/N 3115Cancelled Jul 29, 2014 · Third renewal notice · Aerobanc Of America IncN909FLDavies Richard P KITFOX IV · S/N 1433Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1993 · Crandall Paul WN89043Cessna 152 · S/N 15282607Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1978N7441WWalker David S LANCAIR IV · S/N LIV-076Cancelled Aug 14, 2013 · First renewal notice · Built 1998 · Stratton Bruce AN701DBuckers JUNGMEISTER · S/N DRP-1Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Holsclaw Francis EN354DKBurkhart Grob Flugzeugbau SPEED ASTIR II B · S/N 4036Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1979 · Hartmann Michael RN750TVVonk Anton LANCAIR PROPJET · S/N LIV-573Cancelled Jul 17, 2013 · First renewal notice · Built 2005 · Jetbird LLCN246SABeech 23 · S/N M-273Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1963
Back to Santa Barbara, CA