OpenAirDocs.org
Coronado, CA

Cancelled registrations · 35

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

N25RWRotor Wings Systems ROTOR WING NUMBER-1 · S/N RW001Cancelled Nov 19, 2019 · Revoked, pending cancellation · Built 1977 · Rotor Wing Systems IncN6098QMooney M20E · S/N 917Cancelled May 21, 2019 · Built 1965 · Greene David EN7469RBeech A36 · S/N E-1263Cancelled Apr 18, 2019 · First renewal notice · Built 1978 · Hall George WN2596MPiper PA-12 · S/N 12-955Cancelled Nov 22, 2017 · Revoked, canceled · Built 1946 · Gallion JamesN132MDYakovlev YAK 52 · S/N 833802Cancelled May 30, 2017 · First renewal notice · Built 1983 · Molter Frank B TrusteeN7066DBeech C-12 · S/N 76-22563Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Avpac IncN5931ACessna 340 · S/N 340-0022Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Avpac IncN610PMPiaggio P.136-L1 · S/N 214Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1957 · Griffin JosephN7092CLearjet 35A · S/N 184Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Cefaratti International IncN5562NHoward DGA-15P · S/N 1729Cancelled Aug 14, 2013 · Registration pending, canceled · Built 1943N105TJCessna T303 · S/N T30300117Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1982N8682CPiper PA-22-135 · S/N 22-1342Cancelled Dec 26, 2012 · Sale reported, pending cancellation · Built 1953N92JPPalmore Joseph W BENSEN B8M · S/N 1Cancelled Nov 9, 2012 · Registration pending, canceledN104TJPiper PA-34-200T · S/N 34-8070215Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1980N67602Cessna T-50 · S/N 6119Cancelled Sep 5, 2012 · Revoked, canceled · Reid B EN766ALSikorsky S-76A · S/N 760029Cancelled Aug 1, 2012 · Registration pending, canceled · Built 1979N18VLLarson VARIEZE · S/N 197Cancelled Jul 30, 2012 · Sale reported, canceled · Built 1978N300EHDehavilland DHC-6-300 · S/N 352Cancelled Oct 6, 2011 · Exported to Canada · Tactical Air Operations IncN5998MCessna 421B · S/N 421B0241Cancelled Aug 18, 2009 · Sale reported · Built 1972N4161KFife Raymond B PUSHER · S/N 1Cancelled Jul 27, 2009 · Registration revoked · Built 1950 · Fife Raymond BN716PCCessna 172N · S/N 17269242Cancelled Aug 8, 2002 · Exported to Mexico · Built 1977N9883ZCessna TU206G · S/N U20606727Cancelled Jun 3, 1998 · Exported to Mexico · Petersen Jeffrey ScottN163JJenkins Harry Tarleton JR LONG EZ · S/N 1135Cancelled Mar 28, 1997 · Triennial form not returned · Jenkins Harry T JrN1360NBoeing IB75A · S/N 755125Cancelled Dec 14, 1995 · Exported to Australia · Morris James IN1692XCessna T210L · S/N 21060727Cancelled Dec 12, 1994 · Exported to Mexico · Baz Luis GN7208NCessna 182P · S/N 18263000Cancelled Jan 13, 1986 · P A Mike Zimmerman Realty IncN2205CBeech D-45 (T-34B) · S/N BG-15Cancelled Mar 31, 1982 · Built 1967 · North Island Navy Flying ClubN8220FCessna 150F · S/N 15064320Cancelled Oct 27, 1981 · Exported to Mexico · Meeh Robert WN2671QCessna 182K · S/N 18257871Cancelled Aug 19, 1981 · Exported to Mexico · Built 1966 · Otero Eduardo M Et AlN8059PPiper PA-24 · S/N 24-3306Cancelled Jul 5, 1974 · Dubbs Jack BN6634MStinson 108 · S/N 108-4634Cancelled Jan 4, 1971 · Built 1948 · Eastman Verna LN2320APiper PA-18 · S/N 18-1896Cancelled May 14, 1957 · Exported to Canada · Galwil Mining CoN4101NCessna 120 · S/N 13559Cancelled Aug 18, 1948 · San Diego Flying Club IncN53013Ryan Aeronautical ST3KR · S/N 1944Cancelled May 14, 1948 · Built 1942 · Landon Myrtle KathrynN67603Cessna T-50 · S/N 2960Cancellation date not recorded · Reid B E
Back to Coronado, CA