OpenAirDocs.org
Lodi, CA

Cancelled registrations · 62

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

N97723Stinson 108-1 · S/N 108-723Cancelled Jun 10, 2023 · Revoked, canceled · Built 1946 · Hicks Roger LN33YXHebestreit William F WAIEX · S/N W0033Cancelled Apr 17, 2021 · Sale reported, canceled · Built 2006N9580KStinson 108-2 · S/N 1082580Cancelled Jul 10, 2020 · Revoked, canceled · Built 1947 · Lewis H KennethN5161KRyan NAVION B · S/N NAV-4-2061BCancelled Jan 31, 2019 · Registration expired, pending cancellation · Built 1950 · Morrow Raleigh D JrN106RJRyan NAVION B · S/N NAV-4-2243BCancelled Jan 29, 2019 · Registration expired, pending cancellation · Morrow Raleigh D JrN524CSCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 161Cancelled Jan 14, 2019 · Built 2006 · Hennefer Greg BN4499VBeech A35 · S/N D-1320Cancelled Apr 5, 2018 · Revoked, canceled · Built 1948 · Vetter Robert LeeN6942RCessna T210H · S/N T210-0342Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1967 · Awan MaqsoodN9729MMooney M20F · S/N 670289Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1967 · De Lasaux Thomas GN6277NBell 47G-5 · S/N 7887Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1968 · J&M Helicopter ServicesN6459SCessna 150H · S/N 15067259Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1967 · Barber BlakeN7543PPiper PA-24-250 · S/N 24-2749Cancelled Feb 4, 2017 · Revoked, canceled · Built 1961 · Parker Teddy TN81119Funk B75L · S/N 249Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1946 · Thomas James LN78BNNipkau William VARIEZE · S/N 462Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · Nipkau WilliamN24178Funk B75L · S/N 204Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1940 · Thomas James LN2312DStreeter-Wayne EVANS VP-1 · S/N 1Cancelled Jul 11, 2013 · Sale reported, canceledN9771UGrumman American Avn. AA-5A · S/N AA5A-0171Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1976 · Powell RudolphN1064LAircraft Parts & Dev. A-9B · S/N 5009Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1979 · Renfroe Flying Service IncN4438MHenslee Bill BENSEN B80 · S/N BSH-1Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Henslee BillN7956SBell 47G-4A · S/N 7551Cancelled May 9, 2013 · Registration expired, pending cancellation · Lodi Vintage Air IncN6446MStinson 108-3 · S/N 108-4446Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1948 · Murdock Gary DN5523ZPiper PA-18-150 · S/N 18-7846Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1962 · Verhagen Raymond SN2396VCessna 140 · S/N 14638Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1948N91687North American NAVION · S/N NAV-4-428Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1946N4017WAyres S2R-600 · S/N 2560RCancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1980 · Ag Flight IncN2569RSomraty T P/Somraty J J PROSTAR MODEL B · S/N PT1190Cancelled Sep 17, 2012 · Somraty Thomas PN100AVBeech D-50 · S/N DH-107Cancelled May 1, 2012 · Registration expired, pending cancellation · Built 1956 · Raverty KentN1026RRaven Industries RX6 · S/N RX6-185Cancelled Jun 22, 2011 · Sale reported, canceled · Built 1975N33747Aeronca 65-CA · S/N C13381Cancelled Jun 13, 2011 · Revoked, canceled · Built 1941 · Wagemann James GN96280Reims CESSNA F182P · S/N F1820025Cancelled Nov 9, 2009 · Exported to Canada · Built 1976 · Haley Leland JN3859EPiper PA-36-375 · S/N 36-7802028Cancelled Aug 12, 2008 · Triennial form not returned · Built 1978 · Roberts Jack AN83785Piper PA-28-161 · S/N 28-8116211Cancelled Jun 10, 2008 · Triennial form not returned · Built 1981 · Rosenau Leland AN83GTEnstrom F-28C · S/N 308Cancelled Nov 13, 2007 · Built 1975 · Houston John R DBAN206KVBell 206B · S/N 4197Cancelled Oct 3, 2003 · Exported to Germany · Built 1991 · Kautz John HN1592Curtiss Wright TRAVEL AIR 4000 · S/N 196Cancelled Jan 9, 2001 · Triennial form not returned · Precissi Flying Svc IncN901Curtiss Wright TRAVEL AIR 4000 · S/N 181Cancelled Nov 9, 2000 · Triennial form not returned · Precissi Flying Service IncN70JSSteers STITS SA3B · S/N 528Cancelled Oct 27, 1993N13CVVaughan STARDUSTER SA-100 · S/N CV2Cancelled Jun 2, 1992 · Triennial form not returned · Vaughan Cye GN5720QMooney M20C · S/N 3062Cancelled Aug 9, 1991 · Triennial form not returned · Vaughan Cye JrN7688VAero Commander CALLAIR A-9B · S/N 1434Cancelled Dec 22, 1987 · Administratively canceled · Killion Air CorpN731RGCessna A188B · S/N 18803091TCancelled Oct 16, 1985 · Thomas James LN7643VAero Commander CALLAIR A-9 · S/N 1371Cancelled May 25, 1984 · Killion Air CorpN7249VIntermountain CALLAIR A-9 · S/N 1286Cancelled Aug 1, 1980 · Renfroe Flying Service IncN3568HErcoupe 415-C · S/N 4193Cancelled Jul 8, 1977 · Murphy AircraftN9LCBeech 95-A55 · S/N TC-336Cancelled Aug 5, 1976 · Built 1962 · Calkins Lester TN3617GAero Commander CALLAIR A-9 · S/N 1017Cancelled Jun 9, 1975 · Renfroe Flying Service IncN2414TNavion NAVION G · S/N NAV-4-2414Cancelled Oct 4, 1973 · M D Freund DBA Eldorado AviationN5979XBrantly B-2 · S/N 122Cancelled May 7, 1971 · Vetter Robert LN68836Boeing A75N1 · S/N 75-3149Cancelled Jan 18, 1971 · Barlow Wm GN70099Cessna T-50 · S/N 4480Cancelled Jul 27, 1970 · Lind Albert A
Back to Lodi, CA