OpenAirDocs.org
Lincoln, CA

Cancelled registrations · 42

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 = 'LINCOLN'
  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.

N2764RSchweizer SGU 2-22E · S/N 171Cancelled Jun 10, 2023 · Revoked, canceled · Built 1963 · California Flying Machine & Fun CorpN41260Block Melvin H RV-6A · S/N 20618Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1991 · Mcmahan Kevin LeeN1942SCessna 172E · S/N 17251562Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1964 · Rockwell Zachary CN733NZCessna 172N · S/N 17268432Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1976 · Lincoln Skyways IncN6035GCessna 150K · S/N 15071535Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1969 · Gerolamy Ralph MN32RBGrumman American Avn. AA-1B · S/N AA1B-0569Cancelled Mar 1, 2018 · Revoked, pending cancellation · Built 1975 · Blanchard Richard DN121SDSawyer Steve M GOLDWING · S/N 121Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1988 · Sawyer Steve MN2889DPiper PA-28-236 · S/N 28-7911227Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Stack Joseph AN9180VMooney M20F · S/N 690046Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1969 · Stiles Steven AN2368FCessna 210E · S/N 21058568Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1965 · Jenkins Harold DN6193APiper PA-36-375 · S/N 36-8102024Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1981 · Defty Peter AN2287FEngland-Arthur BENSEN B-8M · S/N AE-1Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1978 · England Arthur SN4880BCessna 310 · S/N 35180Cancelled Aug 30, 2012 · Sale reported, pending cancellation · Built 1955N17355Bell 206B · S/N 694Cancelled Jul 24, 2012 · Sale reported, canceled · Built 1971N3038PPiper PA-34-200T · S/N 34-7970136Cancelled Dec 2, 2009 · Triennial form not returned · Built 1979 · Atkin Air LLCN32936Piper PA-34-200T · S/N 34-7570067Cancelled Jul 1, 2009 · Triennial form not returned · Built 1975 · Atkin Willard Kent DBAN531MCessna 150M · S/N 15077673Cancelled Dec 15, 2008 · Triennial form not returned · Built 1975 · Atkin Air LLCN206MTBell 206B · S/N 2276Cancelled Jun 20, 2005 · Triennial form not returned · Built 1977 · Westwind Helicopters IncN2296NBell 206B · S/N 3575Cancelled Mar 11, 2003 · Triennial form not returned · Built 1982 · Westwind Helicopters IncN983SCStack A Joseph III ELITE XL-RG · S/N 3RX028Cancelled Nov 14, 2000 · Stack Joseph A IIIN95MTPiper PA-22-135 · S/N 22-923Cancelled Dec 16, 1999 · Second triennial mailing, no response · Puente Jeff CN6870FPiper PA-28-181 · S/N 287790170Cancelled Jan 25, 1999 · Atkin AirN2362YPiper PA-36-300 · S/N 368160018Cancelled Dec 9, 1998 · Exported to Argentina · Weatherly Aviation Co IncN9043AWeatherly 620B TG · S/N 3000Cancelled Sep 17, 1998 · Exported to Argentina · Weatherly Aviation Co IncN8662JCessna 150G · S/N 15066562Cancelled May 28, 1998 · Triennial form not returned · Read Kenneth DN90413Weatherly 620B · S/N 1653Cancelled Nov 24, 1997 · Exported to Argentina · Weatherly Aviation Company IncN9034MWeatherly 620B · S/N 1644Cancelled Apr 17, 1997 · Exported to Canada · Weatherly Aviation Company IncN9032HWeatherly 620B · S/N 1642Cancelled Feb 5, 1997 · Exported to Canada · Weatherly Aviation Company IncN9022YWeatherly 620B · S/N 1632Cancelled Oct 10, 1996 · Exported to Belize · Weatherly Aviation Company IncN2028LWeatherly 620B · S/N 1579Cancelled Dec 6, 1994 · Exported to Guatemala · Weatherly Aviation Co IncN2029ZWeatherly 620B · S/N 1580Cancelled Nov 7, 1994 · Exported to Guatemala · Weatherly Aviation Company IncN24314Cessna 152 · S/N 15280211Cancelled May 27, 1994 · Exported to Switzerland · Cameron Wings IncN757ZJCessna 152 · S/N 15280131Cancelled May 27, 1994 · Exported to Switzerland · Cameron Wings IncN2025LWeatherly 620B · S/N 1574Cancelled Apr 20, 1994 · Exported to Canada · Built 1994 · Weatherly Aviation Co IncN3579SPiper PA-32R-301T · S/N 32R8029040Cancelled Sep 29, 1993 · Exported to Switzerland · Cameron Wings IncN704JWCessna 150M · S/N 15078657Cancelled Apr 19, 1993 · Exported to Germany · Fourtner Robert DBA A US Acft MktgN1379HPiper PA-28-161 · S/N 287716020Cancelled Dec 20, 1990 · Exported to AustraliaN58230Hughes Helicopters HUGHES 369D · S/N 1080378DCancelled Jun 1, 1984 · Exported to Japan · Infinity Aviation IncN58287Hughes Helicopters HUGHES 369D · S/N 490490DCancelled Jun 1, 1984 · Exported to Japan · Infinity Aviation IncN5552TCessna 172E · S/N 17251452Cancelled Aug 1, 1980 · Harder Karl C DBA Karls Flying ServiceN3742RCessna 172H · S/N 17255542Cancelled Dec 31, 1970 · Karls Flying ServiceN9256XCessna 182E · S/N 18253656Cancelled Mar 11, 1965 · Earl Harder Jr
Back to Lincoln, CA