OpenAirDocs.org
Hutchinson, KS

Cancelled registrations · 51

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 = 'KS' AND d.registrant_city = 'HUTCHINSON'
  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.

N76430Cessna 140 · S/N 10856Cancelled Jul 6, 2023 · Built 1946 · Liby Max LN626APiper PA-22 · S/N 22-30Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1951 · Neujahr Ronald WN6174TCessna 150E · S/N 15060874Cancelled Apr 1, 2020 · Built 1964 · Kahn Jerome GN9102CCessna 180 · S/N 31201Cancelled Oct 12, 2018 · Revoked, canceled · Built 1954 · Sunflower Aerodrome IncN258BSLet BLANIK L-13 · S/N 025528Cancelled Mar 16, 2018 · Revoked, canceled · Built 1973 · Sunflower Aerodrome IncN9360GPowrachute PC 2000 · S/N B 317 POWCancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 2001 · Duncan Anthony LN5144CDuncan Anthony L SKYCHOPPER · S/N 001Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Duncan Anthony LN29358Cessna 177 · S/N 17700837Cancelled Nov 22, 2017 · Revoked, canceled · Built 1968 · Cardinal IncN7604Schweizer SGS 1-34 · S/N 51Cancelled Feb 4, 2017 · Revoked, canceled · Built 1971 · Seed William Haydn JrN481HMSlade Baker BUCKEYE · S/N 4980Cancelled Jun 2, 2016 · Exported to Saudi Arabia · Maior George PN252GMMooney M20K · S/N 25-1029Cancelled Jun 2, 2014 · Third renewal notice · Brust RobertN8204PInfinity C-912S · S/N IPP6-325Cancelled Aug 29, 2013 · Sale reported, canceledN3406LCessna TU206B · S/N U206-0706Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1966 · Sky Sports II IncN6470CConsolidated PBY-5A · S/N 08068Cancelled Aug 6, 2013 · Revoked, canceled · Moore PatN8743B.K.W. Farms SCORPION HELICOPTER · S/N 1969Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1969N3998Caproni Vizzola CALIF A21J · S/N 203Cancelled Jun 27, 2012 · Sale reported, pending cancellation · Built 1971N1264WWeatherly 201B · S/N 618Cancelled Apr 4, 2011 · First renewal notice · Built 1974 · Bird Brian AN6107ZCommander 114TC · S/N 20007Cancelled Aug 30, 2004 · Triennial form not returned · Built 1995 · Data Center IncN2495LPiper PA-38-112 · S/N 3879A0734Cancelled Sep 18, 1996 · Triennial form not returned · Hall Marvin L DBAN2038GCessna 182A · S/N 51338Cancelled Mar 28, 1991 · Triennial form not returned · Morgan Hubert EN4977MBeech E-90 · S/N LW-277Cancelled Feb 6, 1979 · Exported to Philippines · Wells Aircraft IncN61CBeech D18S · S/N A-333Cancelled Sep 3, 1976 · Wells Aircraft IncN69JBeech B90 · S/N LJ-337Cancelled Mar 3, 1976 · Exported to Canada · Wells Aircraft IncN9642HCessna 172M · S/N 17266289Cancelled Jan 27, 1976 · Exported to Canada · Wells Aircraft IncN11WDouglas DC3C · S/N 20196Cancelled Sep 19, 1975 · Exported to Canada · Built 1946 · Wells Aircraft IncN666RBBeech D50C · S/N DH-269Cancelled Sep 9, 1975 · Exported to Philippines · Wells Aircraft IncN17231Cessna 150L · S/N 15073680Cancelled Sep 2, 1975 · Exported to Canada · Wells Aircraft IncN8895XCessna 182D · S/N 18253295Cancelled Nov 12, 1974 · Exported to Canada · Superior Boiler Works IncN91785Cessna 182M · S/N 18259906Cancelled Oct 29, 1974 · Cessna Employees Flying Club Of Hutchinson Ks IncN4812EDouglas B-26 · S/N 4435893Cancelled Jan 15, 1974 · Exported to Canada · Schneider Robert RN3737UCessna 182G · S/N 18255137Cancelled Mar 28, 1973 · Exported to Canada · Wells Aircraft IncN92928Cessna 182N · S/N 18260430Cancelled Apr 11, 1972 · Cessna Employees Flying Club Of HutchinsonN943BWBeech C-45H · S/N 52-10622Cancelled Sep 11, 1970 · Wells Aircraft IncN8844DPiper PA-22-160 · S/N 22-6014Cancelled Aug 19, 1970 · Krehbiel C JN4137UCessna 150D · S/N 15060137Cancelled Jun 12, 1967 · Exported to Canada · Skycraft IncN71775Luscombe 8A · S/N 3202Cancelled May 25, 1965 · Three Pointers Incc/O David MillsN9118ACessna 170A · S/N 19416Cancelled Apr 17, 1957 · Exported to Germany · Hiett Homer RN2572CCessna 170B · S/N 26216Cancelled May 2, 1956 · Exported to Germany · Wells School Of Aviaiton IncN99329Ercoupe 415-C · S/N 1952Cancelled Feb 28, 1956 · Built 1946 · Wilbeck Robert AN1176KLuscombe 8A · S/N 3903Cancelled Oct 4, 1955 · Dick Henry NN5806VBoeing A75N1 · S/N 75-3101Cancelled Jan 22, 1952 · Sieker Robert LN78458Piper PA-12 · S/N 12-1969Cancelled Aug 2, 1951 · Merle WesleyN3407KPiper J3C-65 · S/N 22098Cancelled Mar 9, 1951 · Commercial School Of AviationN3708HEngineering & Research 415-C · S/N 4333Cancelled Jul 25, 1950 · Built 1946 · Rucker J DN2152VCessna 140 · S/N 14381Cancelled Sep 16, 1949 · Leighnor AircraftN71387Luscombe 8A · S/N 2814Cancelled Jun 14, 1949 · Leighnor Aircraft CoN72377Cessna 140 · S/N 9563Cancelled Feb 11, 1949 · Krause Plow CorpN48447Taylorcraft DCO-65 · S/N L-5506Cancelled Aug 30, 1948 · Grundy Harold L DBA Commerical School Of AviationN15851Cessna C-34 · S/N 318Cancelled Sep 27, 1936 · Torrey O EN5403Stinson SM-1 · S/N M-237Cancelled Feb 19, 1934 · Baker Rex
Back to Hutchinson, KS