OpenAirDocs.org
Goshen, IN

Cancelled registrations · 33

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 = 'IN' AND d.registrant_city = 'GOSHEN'
  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.

N27LYPowrachute PEGASUS · S/N A 107 PEGCancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 2003 · Yoder Larry WN2566ZBuckeye Industries DREAM MACHINE · S/N 16434Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 2004 · Kropf Donald RN1508YBalloon Works FIREFLY 7-B · S/N F7B-003Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1983 · Boyd Nick SN3257CDrepin Oieg T-BIRD II · S/N A0050TCancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2005 · Drepin OiegN218DArion LIGHTNING LS-1 · S/N 152Cancelled Feb 23, 2017 · Built 2012 · Lynn Thomas AN410AMDiamond Aircraft Ind DA20-C1 · S/N C0357Cancelled Jun 16, 2014 · Exported to Canada · Built 2005 · New Horizons Aviation IncN3158QCessna 182K · S/N 18258158Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1967 · Skyhett Aviation LLCN123FSStrammer Fred HOVEY BETA BIRD · S/N 123Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Strammer FredN184PTByler Mark A JDT MINI-MAX 1100R · S/N JDT10Cancelled Feb 25, 2012 · First renewal notice · Built 2009 · Byler Mark AN387JMBeech C23 · S/N M-1568Cancelled Apr 29, 2008 · Exported to Canada · Built 1974 · Vfr Flyers IncN3570KAerostar International RX 8 · S/N RX8-3049Cancelled Mar 4, 2008 · Triennial form not returned · Built 1990 · Chupp Edward JN303VHHershberger Vernon L MK I · S/N 00432Cancelled Aug 19, 2003 · Triennial form not returned · Hershberger Vernon LN68182Cessna 152 · S/N 15282168Cancelled Apr 29, 2002 · Triennial form not returned · Built 1978 · Goshen Air Center IncN75306Piper PA-28R-200 · S/N 28R7635290Cancelled Nov 5, 1998 · Triennial form not returned · Baylor IncN93GKKyle Glen SONERAI TWO LOW WING · S/N 939Cancelled Apr 5, 1991 · Triennial form not returned · Klye Glen PN78227Cessna 172K · S/N 17257536Cancelled Apr 3, 1986 · Enyeart Larry LeeN2340PPiper PA-22-150 · S/N 22-2751Cancelled Dec 21, 1981 · Leer J Dean & Leer Gloria JN4707FCessna P206B · S/N P206-0307Cancelled Jul 7, 1977 · SkyknightsN8859NPiper PA-28-140 · S/N 28-25714Cancelled Nov 14, 1975 · Eaton Richard EN9682KStinson 108-2 · S/N 108-2682Cancelled May 6, 1975 · Mcmahon Flying ClubN5242MTaylorcraft BC12D-85 · S/N 10542Cancelled Aug 23, 1974 · Duckwall William DN1817CCessna 170B · S/N 25961Cancelled May 15, 1974 · Exported to Canada · Blosser Jonathan PN5526RCessna 172F · S/N 17253105Cancelled Oct 1, 1973 · Miller Russell DBA AirgoN30022Bensen Gyrocopter B-8MJ · S/N F8594Cancelled Jan 14, 1971 · Farrand Lowell LN79544Cessna T-50 · S/N 2589Cancelled Sep 25, 1970 · Penn AlbertN54597Cessna T-50 · S/N 4602Cancelled Jul 10, 1970 · Russell Miller DBA AirgoN83613Aeronca 7AC · S/N 7AC-2290Cancelled Jul 22, 1958 · Exported to Canada · Built 1946 · Miller Russell DBA AirgoN61909Consolidated Vultee BT-13A · S/N 3142Cancelled Feb 15, 1956 · Miller RussellN20912Culver DART I · S/N I-23Cancelled Oct 19, 1955 · Applegate & Weyant Engineering CoN2382VCessna 140 · S/N 14620Cancelled Jul 19, 1954 · Flying Eagles IncN3561EAeronca 7AC · S/N 7AC-6908Cancelled Aug 31, 1953 · Built 1947 · Werner Motor Co IncN77460Cessna 120 · S/N 11904Cancelled Sep 1, 1950 · Built 1946 · Ford Jack P/Goshen Flying ServiceN1626KLuscombe 8A · S/N 4353Cancelled Jun 2, 1949 · Midway School Of Aeronautics Inc
Back to Goshen, IN