OpenAirDocs.org
Encino, CA

Cancelled registrations · 47

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

N2057ZCessna 150C · S/N 15059857Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Bowerman David EN3254ERobinson Helicopter R44 II · S/N 11702Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 2007 · National Helicopter Service & Engineering CoN55WTBell 206B · S/N 1683Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1975 · National Helicopter Service And Engineering CoN503EPDJI INSPIRE 1 · S/N W13DCD08030672Cancelled Sep 20, 2019 · Christian Horan Photography IncN5807CLumenier QAV500 · S/N AA-QAV001Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Astraeus Aerial LLCN5809CDJI INSPIRE 1 · S/N W13DCD21030076Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Astraeus Aerial LLCN581DCDJI INSPIRE 1 · S/N W13DCD21030100Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Astraeus Aerial LLCN984DGDJI PHANTOM 3 PROFESSION · S/N P76DCF09016387Cancelled Dec 20, 2018 · Registration expired, pending cancellation · Galerkin Darren PN985DGDJI INSPIRE 1 · S/N W13DCC23030536Cancelled Dec 20, 2018 · Registration expired, pending cancellation · Galerkin Darren PN779AAAstraeus Aerial V.3CS · S/N 0010Cancelled Jun 11, 2018 · Registration expired, pending cancellation · Astraeus Aerial LLCN67FBBrooks N F LONG EZE · S/N 523Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Toggenburger Frank JN492JTGrumman G-1159 · S/N 82Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1970 · Constellation Productions IncN93YART Chesters GOON · S/N 2Cancelled Sep 12, 2016 · Revoked, pending cancellation · Built 1957 · Caler John WN774AAAzure Films Inc DBA Astraeus A V.3CS · S/N 0001Cancelled Mar 10, 2015 · Azure Films Inc DBAN775AAAzure Films Inc DBA Astraeus A V.3CS · S/N 0002Cancelled Mar 10, 2015 · Azure Films Inc DBAN776AAAzure Films Inc DBA Astraeus A V.3CS · S/N 0003Cancelled Mar 10, 2015 · Azure Films Inc DBAN778AAAzure Films Inc DBA Astraeus A V.3CS · S/N 0004Cancelled Mar 10, 2015 · Azure Films Inc DBAN777PLSmith AEROSTAR 601 · S/N 61-0334-111Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1976 · Wild Blue LtdN74862Grumman American Avn. AA-5B · S/N AA5B0384Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1976 · Clifton L Portnoff M D A Med CorpN3056HEngineering & Research ERCOUPE 415-C · S/N 3681Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1946 · Van De Veere Glen EN8156UNorth American T-28A · S/N 491960Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Sarkowsky MarkN9068TRobinson Helicopter R22 · S/N 0173Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1981 · Mil Air IncN244RRWeiss Ron LANCAIR · S/N JC003Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2009N5771UPiper PA-28-140 · S/N 28-26595Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1969N53275Schweizer SGS 2-8 · S/N 27Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1942 · Mar Vista Glider Club IncN5106ACessna 172 · S/N 28106Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Built 1955 · Sprinkle Phillip JN5900Douglas DC-7C · S/N 45068Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1956N1929QCessna 177RG · S/N 177RG0329Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1973 · Stamler AlanN80595Cirrus Design SR22 · S/N 0688Cancelled Dec 14, 2009 · Triennial form not returned · Built 2003 · John D Stoller Cpa IncN87826Piper J3C-65 · S/N 15221Cancelled Aug 11, 2009 · Exported to Israel · Built 1946 · Continental Training & Service IncN732SZCessna T210M · S/N 21061750Cancelled Aug 11, 2008 · Second triennial mailing, no response · Built 1977 · Sandorf AeN99WCRockwell International 690A · S/N 11308Cancelled May 17, 2005 · Exported to Australia · Built 1975 · Special Investments IncN700USPiper AEROSTAR 601 · S/N 6106527962140Cancelled Jun 29, 2004 · Triennial form not returned · Willard George GN4296JPiper PA-28RT-201T · S/N 28R-8331028Cancelled Jun 21, 2000 · Exported to Canada · Heim FredN291JDDunham Jeff EXEC 90 · S/N RI162JD2Cancelled Oct 30, 1998 · Triennial form not returned · Dunham Jeff DN87QToggenburger Frank QUICKIE · S/N 087Cancelled May 16, 1997 · Triennial form not returned · Toggenburger Frank JN6337XCessna 340A · S/N 340A0506Cancelled May 8, 1991 · Exported to Mexico · Jet Set AircraftN3186CCessna R182 · S/N R18200253Cancelled May 7, 1982 · Built 1978 · Sobel Kenneth P Et AlN39467Stinson 108 · S/N 108-23Cancelled Dec 23, 1981 · Built 1946 · Hoffman Richard FN2500TAero Commander 680-F · S/N 680-F-1158-82Cancelled Mar 7, 1974 · Harmon Al Et AlN6568RCessna 177 · S/N 17700971Cancelled Jun 26, 1973 · Susfolk Joseph And Montgomery HarryN803SWDouglas DC-8F-55 · S/N 45821Cancelled Oct 13, 1972 · Exported to Gabon · Seaboard World Airlines IncN7421Douglas DC-7C · S/N 44884Cancelled Apr 7, 1972 · International Aerodyne IncN5751WPiper PA-28-150 · S/N 28-1482Cancelled Mar 10, 1970 · Exported to Canada · Built 1964 · Morton FassbergN46278Piper J4E · S/N 4-1599Cancelled Jan 29, 1962 · Exported to Mexico · Built 1941 · Gumpert Theodore LN34578Aeronca 65-TC · S/N C10201TCancelled Jan 5, 1960 · Madelyn Lenora GumpertN56899Fairchild M-62A · S/N T42-3142Cancelled Dec 4, 1953 · Exported to Mexico · Rose Marguerite L
Back to Encino, CA