San Luis Obispo, CA

Cancelled registrations · 86

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 = 'SAN LUIS OBISPO'
  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.

N3319BAerospatiale SA319B ALOUETTE III · S/N 2030Cancelled Jun 11, 2026 · Exported to South Africa · Gazelle Helicopters IncN7257PCessna 172R · S/N 17280786Cancelled Dec 9, 2025 · Exported to Canada · Built 1999 · Aviation Consultants Inc DBAN670ATBeech B90 · S/N LJ-481Cancelled May 25, 2024 · Sale reported, canceled · Built 1969N7323KPiper PA-20-135 · S/N 20-268Cancelled Jun 21, 2023 · Built 1950 · Hellewell Nicolas RN3235PPiper PA-23-150 · S/N 23-1179Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1957 · Yecny Alan KN68603Cessna 152 · S/N 15282315Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1978 · Yecny Alan KN3279ECessna 172N · S/N 17271490Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1978 · Yecny Enterprises Inc DBAN801QWLockheed Martin FURY BLOCK 10 · S/N AV029Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Lockheed Martin Unmanned Integrated Systems IncN767LCDJI PHANTOM 2 VISION + · S/N PT646037103Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Cannon CorpN699GFLockheed Martin FURY BLOCK 10 · S/N AV022Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lockheed Martin Unmanned Integrated Systems IncN699HFLockheed Martin FURY BLOCK 10 · S/N AV023Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lockheed Martin Unmanned Integrated Systems IncN699JFLockheed Martin FURY BLOCK 10 · S/N AV025Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lockheed Martin Unmanned Integrated Systems IncN889PCLockheed Martin FURY BLOCK 10 · S/N AV026Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lockheed Martin Unmanned Integrated Systems IncN890PCLockheed Martin FURY BLOCK 10 · S/N AV020Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lockheed Martin Unmanned Integrated Systems IncN25076Piper J3C-65 · S/N 3645Cancelled Dec 17, 2018 · Revoked, canceled · Built 1939 · Hoover BrosN341CPCirrus Design SR22 · S/N 3245Cancelled Jun 26, 2018 · Registration pending, canceled · Built 2008N2252DCessna 170B · S/N 20404Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1952 · Burch Loren WN337LJCessna P337H · S/N P3370294Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Csc Solutions LLCN3FVHarmuth BABY LAKES · S/N 7210B-409BCancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1979 · Yancey Patrick DN80566Day Jacque V G MARK III · S/N 1Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 2004 · Crane Jerry R TrusteeN225DHBeech 95-B55 (T42A) · S/N TC-1271Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1969 · Rollins Lonny WN6231MStinson 108-3 · S/N 108-4231Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1948 · Frost William LN711AXCessna 310H · S/N 310H0093Cancelled May 11, 2015 · Exported to Paraguay · Built 1963 · Gidapis LLCN79226Cessna 172K · S/N 17257978Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1969 · Highways Flying Club IncN5539LNicolaides John D. FLYER 10 · S/N N10NFCancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1979 · Nicolaides Dr John DN2054HBalloon Works FIREFLY 6B · S/N 6680Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1977 · Wright Ronald LN9063ACessna 170A · S/N 18822Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1949N27692Taylorcraft BL-65 · S/N 2334Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1940 · Gambucci Joseph PN3031SCessna 150G · S/N 15066931Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1967 · Maddalena Ben LN4342BPiper PA-28-161 · S/N 28-8416050Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1984 · Burnette Larry FN4931HCessna 152 · S/N 15284026Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1979N9214YPiper PA-31-310 · S/N 31-278Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1968 · Blaser Rebecca RN8469SCessna 182H · S/N 18256569Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1965 · Glassmeyer Gary GN714RHCessna 150M · S/N 15079371Cancelled May 3, 2013 · Registration expired, pending cancellation · Northwind AviationN71727Luscombe 8C · S/N 3154Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1946 · Dagle John PN68618Orion D200 · S/N D200XCancelled May 2, 2013 · Registration expired, pending cancellation · Built 1964 · Dagle John PN6575BMooney M20A · S/N 1245Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1958 · Richardson Hugh SN6185QCessna 320B · S/N 320B0002Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1963 · Slo 3 Holdings LLCN4042UCessna 150E · S/N 15061442Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1965 · Nax RichardN43702Taylorcraft BC12D-85 · S/N 7361Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1946 · Fitzgerald John W IIIN792JBBowers Fly Baby 1-A · S/N 67-48Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1972N3741PPiper PA-22-150 · S/N 22-3461Cancelled Mar 8, 2013 · Registration expired, pending cancellation · Built 1955 · Osteyee Leon FN86801Bellanca 8GCBC · S/N 20-74Cancelled Feb 27, 2013 · Sale reported, pending cancellation · Built 1974N44028Taylorcraft BC12-D · S/N 9828Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1946 · Stegner Ralph EN5488YCessna T210N · S/N 21064226Cancelled Nov 6, 2012 · Exported to Mexico · Built 1980 · Michael JerryN279JBeech E35 · S/N D-3946Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1954 · Thompson Emil S JrN533RGCessna 182P · S/N 18262419Cancelled Aug 10, 2012 · Exported to Kenya · Built 1973 · Aviation Consultants IncN8608WPiper PA-28-235 · S/N 28-10124Cancelled Feb 25, 2012 · First renewal notice · Built 1963 · Elliott Clifford R TrusteeN10PLCessna 180J · S/N 18052588Cancelled May 17, 2011 · Exported to Australia · Aircraft Maintenance Consultants LLCN4175BAero Commander 520 · S/N 520-81Cancelled Oct 18, 2010 · Built 1953 · Coast National Bank
Back to San Luis Obispo, CA