Skip to content

Grass Valley, CA

Cancelled registrations · 69

Query with SQL

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 = 'GRASS VALLEY' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'GRASS VALLEY'
  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.

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 = 'GRASS VALLEY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N963DSDiamond Aircraft Ind DA 40 · S/N 40.1116Cancelled Jul 23, 2026 · Exported to Australia · Built 2011 · Airborne Assets LLC N1SSPiper AEROSTAR 601P · S/N 61P06947963331Cancelled Jun 12, 2024 · Built 1979 · Shaw Scott R N81CEMikel Wayne H CHRISTEN EAGLE II · S/N MIKEL 0001Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1982 · Wagner Mark R N4402MRaven S-60A · S/N S60A-346Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Stevenson Byron D N6424QAerostar International RX-7 · S/N RX7-3049Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1986 · Stevenson Byron D N623LBMccleery Gregg A RANS S6ES · S/N 07011418ESCancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 2006 · Wilson Paul A N49042Taylorcraft DCO-65 · S/N 5219Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Roselle Steve N N6115WCameron Balloons US 0-105 · S/N 5528Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1989 · Stevenson Byron D N66RBBastian PITTS SPEC S-1S · S/N 744HCancelled May 6, 2019 · Registration expired, pending cancellation · Built 1976 · Robins Martin T N99SZVan B Anthony ZODIAC 601 HDS · S/N 6-3029Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Built 2015 · Anthony Van B N90819Raven Industries RALLY RX7 · S/N RX7-3281Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1993 · Stevenson Byron D N2842ZPiper PA-22-150 · S/N 22-6837Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1959 · Manis Luke E N457DGGilliland H Dee CHALLENGER II · S/N 001Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1999 · Patrick Dion N1726CCessna 180 · S/N 30426Cancelled Oct 28, 2017 · Revoked, canceled · Built 1953 · Elsbree Jack N6922Stumpf VOLKSPLANE VP-1 · S/N EVS-1Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1974 · Denman Richard E N4073TBoyd Raymond C ZENAIR-601 · S/N 1414Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Ralli Michael E N9651CGrumman TBM-3E · S/N 91664Cancelled Feb 13, 2017 · Revoked, canceled · Cal Nat Airways Inc N9347KStinson 108-2 · S/N 108-2347Cancelled Jan 23, 2017 · Built 1947 · Whittemore Kenneth R Jr N91313Thorp T-211 · S/N 4Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1947 · Riddle Bob N146GFlug & Fahrzeugwerke HBV DIAMANT 18 · S/N 056Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1969 · Poquette Raymond W N24STJohnson Arthur N MITCHELL U-2 · S/N 384Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1988 · Johnson Arthur N N331KMWilson Steven L WILSON VANS RV-7 · S/N 71967Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 2007 · Wilson Steven L N61420Boeing A75N1(PT17) · S/N 75-3358Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1942 N110GGFeemster John GENESIS · S/N GE01/0013Cancelled Jan 31, 2013 · First renewal notice · Built 2001 · Coben Richard N451NYYoung Evert SLEPCEV STORCH · S/N 1124Cancelled Jan 2, 2013 · Young Evert N19KMMatthes William K MATTHES · S/N 105Cancelled Sep 20, 2012 · Third renewal notice · Matthes William K N6957CBeech AT-11 · S/N 43-10383Cancelled Sep 6, 2012 · Revoked, canceled · Cal Nat Airways Inc N152EGSilva/Campbell ROTORWAY EXEC · S/N 03355Cancelled Jul 30, 2012 · Registration expired, pending cancellation · Silva Paul R N4273BBeech F35 · S/N D-4338Cancelled Jun 8, 2012 · Built 1956 · Hoffman Michael C N6138YMaule MX-7-180 · S/N 11061CCancelled Sep 8, 2011 · Second renewal notice · Malvehy Roman M M D N119NCWarner J D/Warner J L EXPRESS · S/N 1119Cancelled Dec 1, 2009 · Exported to Argentina · Built 1991 · N119nc Corp N196DCDiamond Aircraft Ind DA 40 · S/N 40.373Cancelled Aug 4, 2008 · Built 2004 · Diamond Aircraft Group LLC N6121NBeech B23 · S/N M-1208Cancelled Sep 17, 2007 · Triennial form not returned · Built 1968 · Adicoff Arnold N970JHHebb James W AVID MAGNUM · S/N 001Cancelled Jun 29, 2006 · Triennial form not returned · Built 1997 · Hebb James W N4170BCessna 150 · S/N 15062362Cancelled May 5, 2006 · Triennial form not returned · Grass Valley Aviation Inc N518CHazelroth STITS PLAYMATE · S/N 169Cancelled Jun 10, 2005 · Exported to Canada · Built 1975 · Grass Dennis Lee N21451British BAC 167 STRIKEMASTER · S/N 1925Cancelled Feb 24, 2005 · Sale reported N16133Hughes 269B · S/N 180348Cancelled Jun 9, 2004 · Triennial form not returned · Built 1968 · Heli-Fun Inc N16411Piper PA-28-180 · S/N 28-7305246Cancelled Apr 22, 2003 · Triennial form not returned · Built 1973 · Adicoff Arnold N84VRudolph Gary RUDOLPH VENTURE · S/N 74Cancelled Feb 26, 2003 · Built 2000 · Rudolph Forrest G N86559Tyler COOT-A AMPHIBIAN · S/N H-12Cancelled Sep 30, 2002 · Built 1979 · Allen Fred J N18152Beech 77 · S/N WA-286Cancelled Jun 13, 2001 · Sierra Nevada Flyers N7SMDevore O'CACADOR · S/N 001Cancelled Jun 15, 1999 · Triennial form not returned · Mccord David N6387KCessna 150M · S/N 15077679Cancelled Jan 17, 1998 · Triennial form not returned · Grass Valley Aviation Inc N2465HErcoupe 415-C · S/N 3090Cancelled Oct 17, 1997 · Exported to Australia N91133North American NAVION · S/N NAV4199Cancelled Oct 10, 1997 · Lockie Kenneth R N9953NCessna A185F · S/N 18504376Cancelled Aug 9, 1995 · Exported to Argentina · Schultz Charles H N1224TCessna 425 · S/N 4250212Cancelled Nov 1, 1994 · Triennial form not returned · Grass Valley Group Inc N386WTPiper PA-28-236 · S/N 287911162Cancelled Oct 1, 1991 · Exported to Finland · Thacker William R DBA N5752PPiper PA-24-250 · S/N 24-827Cancelled May 13, 1985 · Harris Roger D

Back to Grass Valley, CA