OpenAirDocs.org
Carmichael, CA

Cancelled registrations · 41

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

N664BJDJI PHANTOM 3 PROFESSION · S/N P76DCL15B27306Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Barrett Colby JN4269YMorrison Marvin E JR RV-6A · S/N 21205Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1996 · Bristow Richard AN22XCSchempp-Hirth Flugzeugbau DUO DISCUS T · S/N 72Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2003 · Colacevich Sergio PN1203BLuscombe 8E · S/N 5830Cancelled Sep 4, 2020 · Registration pending, canceled · Built 1947N93060Martin 202 · S/N 9149Cancelled Nov 8, 2019 · Revoked, pending cancellation · Built 1948 · M EnterprisesN5329KRyan NAVION B · S/N NAV-4-2229-BCancelled Jul 5, 2019 · Registration expired, pending cancellation · Built 1951 · Whittall-Scherfee KenN68353Cessna 152 · S/N 15282279Cancelled Jan 29, 2019 · Exported to Philippines · Built 1978 · Sky Walk IncN227USCzech Sport Aircraft A S SPORTCRUISER · S/N P1102027Cancelled Feb 23, 2018 · Built 2011 · Dwyer GregoryN8980Muench SCORPION TOO · S/N 6262Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1974 · Stone Michael KN7519LEipper Quicksilver GT 280/400 · S/N GT2801030Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1984 · Carleton Gordon SN3560LCessna 150F · S/N 15062360Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1965 · Matthews Ralph A JrN84JRJackson/Royal LONG-EZ · S/N 161Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1984 · Jackson Royal Enterprises IncN7737CDidonna BENSEN B7M · S/N JAD-1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Didonna John AN667WTBeech A36TC · S/N EA-35Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · Timmerman Construction IncN83QBeech E18S · S/N BA-40Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1955 · Hawkins Victor LN2933Hughes-Pietenpol AIRCAMPER · S/N 111Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1969 · Popejoy Edward MN543FCessna 152 · S/N 15283385Cancelled Dec 18, 2013 · Exported to El Salvador · Built 1979 · Hakamata GenN4474EErickson Lynn Edward TIERRA II · S/N 4256Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1983N77CQBeech 95-C55 · S/N TE-299Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1967 · Bargman Stuart RN8190QUltra Zone GT 500 QUICKSILVER · S/N 359Cancelled Jun 5, 2013 · Sale reported, canceledN83895Allison BOWERS FLYBABY · S/N 61Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1977 · Allison Kenneth CN7486JPiper PA-28R-180 · S/N 28R-30846Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1968 · Shartle Rodger WN717NTileston DRAG-N-FLY CT-TF · S/N JET-101Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1963 · Tileston J EutN4092BSky Rider SR-1 · S/N 1-100Cancelled Jun 4, 2012 · Revoked, canceled · Built 1968 · Leisure Emery EmitN31347Aeronca 65-TL · S/N 6000TCancelled Feb 25, 2012 · Sale reported, pending cancellation · Built 1940N2623NCessna 120 · S/N 12882Cancelled Jul 15, 2009 · Registration revoked · Built 1947 · Port Aero ClubN2234Morgan-Bensen GYROGLIDER B-8 · S/N M0001Cancelled Jun 26, 2009 · Registration revoked · Built 1969 · Warden Darryl HN1149NBoeing E75 · S/N 75-5015Cancelled Jun 25, 2009 · Registration revoked · Built 1942 · Martin Kenneth DN235RJMitchell A CH-801 · S/N 8-4114Cancelled Jun 10, 2004 · Built 2000 · Jarrett R DouglasN9796ACessna 170A · S/N 19257Cancelled Jun 29, 1999 · Yeatts Alfred MN8GJJack Gordon GLASAIR RG · S/N 735RCancelled Nov 2, 1994 · Triennial form not returned · Jack Gordon TrusteeN98625Cessna 402B · S/N 402B1021Cancelled Aug 9, 1991 · Second triennial mailing, no response · Hawkins Victor LN8102CPiper PA-28-161 · S/N 288016100Cancelled Feb 12, 1991 · Triennial form not returned · Neumann Rory ON76073Cessna 172N · S/N 17268113Cancelled Apr 9, 1986 · Henricks Dean E & Katherine MN86804Bellanca 14-13-2 · S/N 1165Cancelled Jan 22, 1985 · Administratively canceled · Tocher Arlen CN4328Lee BG-12 · S/N 192Cancelled Dec 1, 1977 · Revoked, pending cancellation · Built 1970 · Lee ThomasN7WXMills P-51D · S/N 1Cancelled Jul 12, 1977 · Mills Leroy KN7787FPiper PA-28-181 · S/N 28-7790225Cancelled Jun 20, 1977 · Wasserman Robert DN3409CCessna 170B · S/N 26452Cancelled May 18, 1973 · Exported to Canada · Lloyd RayN73659Hardin A · S/N H-001Cancelled Sep 22, 1971 · Hardin Henry VN73653Aerostats-Balloons AEROSTAT 45 · S/N 64-1Cancelled Jun 26, 1970 · Muma Lloyd
Back to Carmichael, CA