Oshkosh, WI

Cancelled registrations · 340

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 = 'WI' AND d.registrant_city = 'OSHKOSH'
  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.

N39KGCentrair 101A · S/N 101A0130Cancelled May 30, 2018 · Sale reported, canceled · Built 1984N4158JPiper PA-28-140 · S/N 28-22486Cancelled May 30, 2018 · Sale reported, canceledN3129RCrippen WM Cornelius DYKE DELTA JD-2 · S/N 1251Cancelled May 8, 2018 · Sale reported, canceled · Built 1991N72207Cessna 140 · S/N 9380Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1946 · Votava Paul AN3976EAeronca 11BC · S/N 11BC-61Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1947 · Chiefs Dirty Dozen LLCN954VFairchild KR-21 · S/N 1502Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1931 · Eaa Aviation Foundation Inc.N3517HMooney M20C · S/N 20-1219Cancelled Apr 13, 2018 · Sale reported · Built 1976N5294KRyan NAVION B · S/N NAV-4-2194BCancelled Mar 14, 2018 · Sale reported, pending cancellation · Built 1950N3483KPiper J3C-65 · S/N 22181Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1946 · Votava Paul AN86JRCanadair F-86 MK.5 · S/N 1120Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1954 · Eaa Aviation Foundation IncN90381Loboschefsky Terry L HUMMER · S/N 1Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Eaa Aviaiton Foundation IncN6414Volksplane WE-1 · S/N 1Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1968 · Eaa Aviation Foundation IncN77RFGreat Lakes 2T-1A · S/N 260Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1931 · Eaa Aviation Foundation IncN2725TNorthwing Design APACHE SPORT · S/N MUSTANG II 17.M WING #5412Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Sakowski James MN6359TCessna R182 · S/N R18201995Cancelled Feb 28, 2018 · First renewal notice · Built 1984 · Myers Aviation IncN6272Estupinan HOVEY WD-A · S/N 1Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1971 · Eaa Aviation Foundation IncN5501CQuicksilver GT-500 · S/N GT5 TC0107Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1995 · Engel Michael BN4404WRearwin 8135 · S/N 828Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Eaa Aviation Foundation IncN3286MCessna 310R · S/N 310R1894Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1980 · Pro Aire Cargo & Consulting IncN422HCMiller Dennis J MARINER · S/N 530690Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Miller Dennis JN133JMCessna 500 · S/N 500-0028Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1972 · Philmar LLCN222FJScaled Composites 271 · S/N 001Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1997 · Eaa Aviation Foundation IncN1174Mong Sport 1 · S/N 1Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1960 · Eaa Aviation Foundation IncN80RARutan Aircraft Factory 72 · S/N 001Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1984 · Eaa Aviation Foundation IncN7527Waco CTO · S/N A-33Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1928 · Eaa Aviation Foundation IncN58JPoberezny PITTS P-7 · S/N 107Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1971 · Eaa Aviation Foundation IncN689EGGrunska Earl J BABY ACE D · S/N E. G. 1Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1987 · Toelle Troy AN4291CLesher TEAL · S/N 2Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1965 · Eaa Aviation Foundation IncN12YXSonex WAIEX · S/N 0001Cancelled Jan 9, 2018 · Second renewal notice · Built 2003 · Sonex LtdN96176Taylorcraft BC12-D · S/N 8476Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Wilcox Eugene LN20741Rearwin 6000M · S/N 311Cancelled Jul 21, 2017 · Registration expired, pending cancellation · Built 1963 · Eaa Aviation Foundation IncN142SDMatheny Robert E SOLITAIRE · S/N 6Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1985 · Eaa Aviation Foundation IncN83SHLegare Garry J SEA HAWK · S/N 001Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1983 · Eaa Aviation Foundation IncN24116Funk B · S/N 45Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1940 · Eaa Aviation Foundation IncN32CHHenderson C F STARDUSTER TOO SA300 · S/N 1961Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1981 · Eaa Aviation Foundation IncN125CASix Chuter SKR II · S/N 99-2380Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1999 · Irving Alan DN4994PAerocar ONE · S/N 1Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1949 · Eaa Aviation Foundation IncN5406EBeckhan-Fifinella-Taylor Mono HB · S/N PATCancelled Jun 23, 2017 · Registration expired, pending cancellation · Built 1964 · Eaa Aviation Foundation IncN22QPitts S-2 · S/N 1001Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1966 · Eaa Aviation Foundation IncN2WXHerron Leighton B QUICKIE · S/N 0004Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1979 · Eaa Aviation Foundation IncN346JSSchifferer John S OSPREY II · S/N JS-3Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1981 · Eaa Aviation Foundation IncN7808Universal Moulded Products MONOCOUPE 113 · S/N 247Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1929 · Eaa Aviation Foundation IncN442XPitts Special S-1 · S/N 117HCancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1969 · Eaa Aviation Foundation IncN683LSDouglas DC3C · S/N 43084Cancelled Jun 9, 2017 · Exported to Canada · Built 1942 · Basler Turbo Conversions LLCN707BADouglas DC3C-S1C3G · S/N 33046Cancelled Jun 9, 2017 · Exported to Canada · Basler Turbo Conversions LLCN15045Piper E-2 · S/N 196Cancelled May 31, 2017 · Registration expired, pending cancellation · Eaa Aviation Foundation IncN42963Pete Myers Special M-1 · S/N 1Cancelled May 31, 2017 · Registration expired, pending cancellation · Eaa Aviation Foundation IncN7772Douglas DC3 · S/N 6338Cancelled May 26, 2017 · Registration expired, pending cancellation · Eaa Aviation Foundation IncN702EWEagle EA-100 · S/N 1003Cancelled May 15, 2017 · Registration expired, pending cancellation · Eagle Aircraft Company LLCN122SXMonnett Jeremy T SONEX ST · S/N 0007Cancelled Apr 18, 2017 · Exported to Canada · Sonex Ltd
Back to Oshkosh, WI