Placerville, CA

Cancelled registrations · 93

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

N503HCPdps Pzl-Bielsko SZD-50-3 · S/N B-2098Cancelled May 5, 2010 · Exported to Brazil · Built 1995 · Sinclair John SN6374ECessna A185F · S/N 18504032Cancelled Nov 18, 2009 · Exported to Australia · Built 1980 · Stancil Enterprises IncN6461TCessna TR182 · S/N R18202032Cancelled Sep 24, 2009 · Exported to Mexico · Built 1986 · Stancil Enterprises IncN6143UCessna TU206G · S/N U20605345Cancelled Sep 11, 2009 · Exported to Mexico · Built 1979N3638CCessna R182 · S/N R18200289Cancelled May 12, 2009 · Exported to Canada · Built 1978N232EMSchleicher ASW-20 · S/N 20061Cancelled May 7, 2009 · Exported to Argentina · Sinclair John SN11134Cessna R182 · S/N R18201945Cancelled Apr 27, 2009 · Exported to Brazil · Stancil Enterprises IncN734JQCessna TU206G · S/N U20604840Cancelled Apr 20, 2009 · Exported to Mexico · Built 1979 · Stancil Enterprises IncN744APCessna TU206G · S/N U20606119Cancelled Apr 17, 2009 · Exported to Mexico · Built 1981 · Stancil Enterprises IncN9757HCessna 182R · S/N 18267999Cancelled Mar 24, 2009 · Exported to Malaysia · Stancil Enterprises IncN909MACessna T206H · S/N T20608097Cancelled Jan 14, 2009 · Exported to Mexico · Built 1999 · Stancil Enterprises IncN7435QCessna 182P · S/N 18261075Cancelled May 23, 2008 · Exported to Mexico · Built 1972 · Stancil Enterprises IncN235TXCessna 172P · S/N 17276348Cancelled Nov 27, 2007 · Exported to Canada · Built 1985 · Stancil Enterprises IncN736UMCessna R172K · S/N R1722799Cancelled Aug 28, 2007 · Exported to Poland · Built 1977 · Stancil Enterprises IncN491RPreissner Roland MURPHY REBEL · S/N 491RCancelled Oct 25, 2006 · Exported to Canada · Built 2000 · Preissner RolandN14XLIniziative Industriali Italian SKY ARROW 650 TC · S/N C003Cancelled May 23, 2006 · Triennial form not returned · Built 1997 · Robinson Terry WN1285XMooney M20E · S/N 158Cancelled Mar 11, 2005 · Triennial form not returned · Built 1963 · Rogers Donald AN210GBCessna T210N · S/N T210-63564Cancelled Sep 27, 2004 · Triennial form not returned · Built 1979 · Bowen Floyd E JrN33DGAerotek PITTS S-2A · S/N 2025Cancelled Feb 9, 2004 · Exported to Australia · Built 1972 · Jackson RonaldN401ERCessna 172R · S/N 17280159Cancelled Oct 21, 2003 · Exported to Germany · Built 1997 · Stancil EnterprisesN73817Cessna 172N · S/N 17267697Cancelled Aug 13, 2003 · Exported to Latvia · Built 1976 · Stancil Aviation EnterprisesN959LClark Leonard R TEENIE TWO · S/N 15-2389Cancelled Jul 15, 2003 · Triennial form not returned · Built 1996 · Clark Leonard RN79RRobinson James B GLASAIRIII · S/N 3276Cancelled Apr 28, 2003 · Robinson James BN1317RGrumman American Avn. AA-5 · S/N AA5-0717Cancelled Dec 4, 2002 · Built 1974 · Nelson TedN417DJJohnson David E LANCAIR 360 · S/N 825Cancelled Jun 26, 2002 · Triennial form not returned · Built 1998 · Johnson David EN9424MCessna TU206G · S/N U20604542Cancelled May 3, 1999 · Exported to Mexico · Stancil Aviation Enterprises LtdN405LAMooney M20J · S/N 24-3018Cancelled Nov 3, 1997 · Logan TimN55385Piper PA-28R-200 · S/N 28R7335226Cancelled Aug 27, 1997 · Exported to AustraliaN2980FBellanca 7ECA · S/N 135280Cancelled Mar 25, 1997 · Triennial form not returned · Stephens Harold EN6652UMooney M20D · S/N 147Cancelled Sep 5, 1995 · Triennial form not returned · Burkhalter James BN3231KRagtime Aerolites ROTEC RALLY 3 · S/N 64784Cancelled Dec 22, 1994 · Triennial form not returned · Ragtime Aerolite IncN1999RCessna 210K · S/N 21059270Cancelled Aug 11, 1994 · Baker Joseph JN5110ZLamberson J A/Feng W C KOLB TWINSTAR MK II · S/N 001Cancelled Jan 5, 1993 · Exported to Taiwan · Lamberson Jeremy AN9993FGlaser-Dirks Flugzeugbau DG-100 · S/N 71Cancelled Feb 18, 1992 · Exported to Argentina · Sinclair John SN1179FShannon Jim W MITCHELL B-10 · S/N P981Cancelled Apr 9, 1991 · Triennial form not returned · Shannon Jim WN74140Grumman American Avn. AA-5B · S/N AA5B-0153Cancelled May 22, 1986 · Beard Robert WN1051KTufts Warren T3-160 GOSHAWK · S/N 1Cancelled Nov 11, 1982 · Administratively canceled · Tufts WarrenN6757TCessna 310D · S/N 39057Cancelled Oct 15, 1980 · Gervais Paul EN5944ACessna 172 · S/N 28544Cancelled May 20, 1965 · Palmer James WN20986Culver LCA · S/N 115Cancelled Mar 21, 1961 · Built 1940 · Giddings LeeN56247Ryan Aeronautical ST3KR · S/N 2157Cancelled Dec 2, 1955 · Hardy EdwardN94854Ercoupe 415-E · S/N 4978Cancelled Sep 13, 1954 · Built 1948 · Collins C SN16577Waco YKS-6 · S/N 4517Cancelled May 13, 1948 · Built 1936 · Babcock Daniel Walte
Back to Placerville, CA