OpenAirDocs.org
Livermore, CA

Cancelled registrations · 73

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

N7265HCessna T206H · S/N T20608057Cancelled Jul 17, 2023 · Exported to India · Built 1999 · Altamont AviationN91GMeredith John W M46 · S/N M46-101Cancelled May 27, 2023 · Built 1996 · Meredith John WN91JMeredith LITTLE TOOT · S/N 241Cancelled May 27, 2023 · Built 1977 · Meredith John WN2371QBeech 23 · S/N M-444Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1963 · Lavi DanielN821EBCessna 152 · S/N 15285210Cancelled Apr 8, 2021 · Non-citizen corporation, flight hours not reported · Built 1982 · Ahart Aviation ServicesN2367WBeech A23-19 · S/N MB-5Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1966 · Rockstead Raymond HN59310Cessna 310C · S/N 39007Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1959 · Gallien AnthonyN8441RPiper PA-28-140 · S/N 28-22324Cancelled Sep 30, 2019 · Built 1966 · Carter JasonN8204KStinson 108 · S/N 1081204Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Kimberling Rex FN1312TMa Vinci SIRIUS · S/N BC:6A:29:7D:00:2064Cancelled Jan 22, 2019 · Registration expired, pending cancellation · Topcon Positioning Systems IncN56217Fairchild M-62A-3 · S/N FV-657Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1945 · Cook Frederic DN6748GCessna 150L · S/N 15072248Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1970 · Guidotti David A DBAN6639TCessna 150A · S/N 15059039Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1960 · Mallon Richard GN921APiper PA-22 · S/N 22-226Cancelled Nov 21, 2017 · Revoked, canceled · Built 1951 · Rhoads Richard L Co OwN39TJAero Vodochody L39C · S/N 812041Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1981 · Stewart Rocky LN726WRLearjet 25 · S/N 007Cancelled Jul 15, 2016 · Sale reported · Built 1968N19376Waco YKS-7 · S/N 5208Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1938 · Anderson Arthur RN2803FRaven Industries RALLY RX7 · S/N RX7-392Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1985 · Early Risers Ballooning IncN4039WPZL 101A · S/N 74135Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1965 · Red Sky Aviation LLCN9039SMoogk Robert J STEEN SKYBOLT · S/N RJM53032-2Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Moogk Robert JN8346EMooney M20A · S/N 1524Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1959 · Martin Specialties IncN6160LAmerican AA-1 · S/N AA1-0360Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1970 · Breshears James DN6165MCessna 152 · S/N 15284634Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1980 · Wollard Aviation IncN5747ECessna 150 · S/N 17247Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1959 · Nichols Patrick MN891VFlug & Fahrzeugwerke DIAMANT 16.5 · S/N 011Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1967 · Calderon Paul DN6657SCessna 150H · S/N 15067457Cancelled Sep 26, 2013 · Revoked, canceled · Built 1967 · Bushey Kayfar ZN7584BChampion 7FC · S/N 7FC-87Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1957 · Dutcher Norris KN4330CChampion 7EC · S/N 7EC-339Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1955N51459Taylorcraft DCO-65 · S/N L-5784Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1943 · Oberlander RonaldN1212RRobins Frank BENSEN B-8M · S/N R-1Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1965 · Orton John BN67358Cessna 152 · S/N 15281776Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1978 · Phillips Lee RN2309KMoogk-Robert STEEN SKYBOLT · S/N RJM3032Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Moogk Robert JN5155BCessna 152 · S/N 15283779Cancelled Nov 28, 2012 · Third renewal notice · Built 1979 · K S Aviation Inc DBAN777HPAero Commander 560 · S/N 163Cancelled Oct 22, 2012 · Sale reported, pending cancellation · Built 1953N331FMHomebuilt HP-14 · S/N 40Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1971 · Larder Richard AN67TBSocata TB-20 TRINIDAD · S/N 535Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Trinidad Distributing CorporationN96313Swan SMYTH SIDEWINDER · S/N 212311Cancelled Sep 17, 2009 · Registration revoked · Built 1978 · Swan Donald A JrN6648SCessna 150H · S/N 15067448Cancelled Jul 31, 2009 · Triennial form not returned · Thomas James RN281ZTruitt Peter ZENAIR CH 701SP · S/N 7-9565Cancelled Nov 1, 2007 · Built 2004 · Chemical Solutions IncN3411GJodel D-9 · S/N F-3055Cancelled Aug 11, 2006 · Triennial form not returned · Built 1963 · Clark Robyn EN614PDiamond Aircraft Ind DA20-A1 · S/N 10014Cancelled Jun 20, 2006 · Exported to Mexico · Timms Jeffery LN56TFPiper PA-31-350 · S/N 31-8252022Cancelled Nov 30, 2005 · Exported to Dominican Republic · Built 1981 · King Brian DBAN2AASchempp-Hirth K.G. JANUS · S/N 16Cancelled Aug 11, 2004 · Exported to United Kingdom · Built 1976 · Catt David PN80661Yak 18T · S/N 7201014Cancelled Mar 24, 2004 · Exported to Canada · Built 1977 · Red Sky Aviation LLCN48512Cessna 152 · S/N 15283345Cancelled May 6, 2003 · Triennial form not returned · Built 1979 · Flying Particles IncN320BDSteffen Robert LANCAIR 320 · S/N 520-320-258FBCancelled May 6, 2002 · Second triennial mailing, no response · Steffen RobertN71DEMaule M-5-235C · S/N 7210CCancelled Oct 30, 2001 · Exported to Canada · Built 1978 · Shumaker Dana EN25538Cessna 152 · S/N 15280726Cancelled Aug 27, 1997 · Exported to New Zealand · Hans TeresaN9942VCessna 172M · S/N 17264567Cancelled Aug 27, 1997 · Exported to New Zealand · Hans TeresaN2126PPiper PA-28-181 · S/N 287990290Cancelled Jul 17, 1997 · Triennial form not returned · Stear Jackson C
Back to Livermore, CA