Jefferson City, MO

Cancelled registrations · 45

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 = 'MO' AND d.registrant_city = 'JEFFERSON CITY'
  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.

N601ZPAircraft Mfg & Development CH601XL · S/N 1-001SCancelled Aug 22, 2026 · Built 2005 · Simmon Timothy AN314KADJI AGRAS T50 · S/N 1581F6BUB2359001014FCancelled Jul 7, 2025 · Sale reported, canceledN986KEDJI AGRAS T40 · S/N 1581F574B224S00101NVCancelled Jul 20, 2024 · Elevated Crop Consulting & Drone Services LLCN402MCCessna 402C · S/N 402C1015Cancelled Jan 3, 2024 · Exported to Bahamas · Built 1985 · Missouri Department Of ConservationN21380Firefly Balloons FIREFLY 7-15 · S/N F7-2061Cancelled Feb 20, 2021 · Registration expired, pending cancellation · Built 2005 · State Of MissouriN701VZDavid Shell ZENITH CH701 · S/N 7-6687Cancelled Feb 12, 2016 · Sale reported · Built 2012N2666HErcoupe 415-C · S/N 3291Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1946 · Langston Arthur EN8130APiper PA-28-161 · S/N 28-8016157Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1979 · Aldridge Mahlon R IIIN40388Balloon Works FIREFLY 7 · S/N 7819Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1978 · Wolters James AN877KCCirrus Design SR22 · S/N 3432Cancelled Dec 10, 2013 · Exported to Canada · Built 2009 · Missouri Vein Care LLCN7524PCameron Balloons US N-65 · S/N 5792Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1992 · Wolters Jim AN9081YBalloon Works FIREFLY 7B-15 · S/N F7B-319Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1991 · Wolters Jim AN7858RBeech D55 · S/N TE-681Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1969 · Lowry J KentN4499MBalloon Works FIREFLY 7 · S/N 7942Cancelled Aug 21, 2013 · Sale reported, canceledN35722Cessna 172I · S/N 17256934Cancelled Jul 11, 2013 · Registration expired, pending cancellation · Built 1968 · Hopkins Sam GN2598LBalloon Works FIREFLY 7-15 · S/N F7-827Cancelled Jun 11, 2013 · Registration expired, pending cancellation · State Of Missouri/Missouri LotteryN7422LBalloon Works FIREFLY 8B · S/N F8B-031Cancelled May 10, 2013 · Sale reported, canceledN7108VBalloon Works FIREFLY 7 · S/N F7-396Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Wolters Jim AN22CNPiper PA-31T1 · S/N 31T-7904049Cancelled Aug 27, 2012 · Registration expired, pending cancellation · Fain IncN563QCessna 150F · S/N 15061777Cancelled Aug 27, 2012 · Revoked, canceled · Built 1965 · Industrial AvnN96MPBell 206B · S/N 3377Cancelled Feb 17, 2011 · Second renewal notice · Built 1981 · Missouri State Highway PatrolN34SAmerican Eurocopter AS350B2 · S/N 4533Cancelled Feb 2, 2010 · Exported to South Africa · Built 2008 · Ozark Management IncN94149Supermarine/Vickers SPITFIRE MK IX · S/N 441Cancelled Jun 16, 2009 · Exported to United Kingdom · 4 Star Aviation IncN77MZKoonce John Paul VANS RV-7A · S/N 70459Cancelled Aug 21, 2007 · Exported to Australia · Built 2003 · Koonce John PN94141Supermarine/Vickers SPITFIRE MK IX · S/N 424Cancelled Aug 8, 2007 · Exported to United Kingdom · 4 Star Aviation IncN24WFLearjet 24 · S/N 24-143Cancelled Jul 19, 2004 · Triennial form not returned · Built 1967 · Ozark Management IncN98MBCessna 500 · S/N 500-0054Cancelled Jul 3, 2003 · Exported to Mexico · Built 1972 · Computer Service Professionals Inc DBAN34TMCessna 421B · S/N 421B0965Cancelled May 1, 2000 · Linville Robert EN77MPBell OH-58A · S/N 72-21187Cancelled May 1, 2000 · Missouri State Highway PatrolN110SLBeech B90 · S/N LJ364Cancelled Aug 8, 1998 · Triennial form not returned · Ozark Management IncN152KTThompson Kinnith W J24 WEEDHOPPER · S/N SN1522Cancelled Apr 29, 1995 · Triennial form not returned · Thompson Kinnith WN98MPBeech B-55 · S/N TF14Cancelled Jul 21, 1994 · Missouri State Highway PatrolN25943Cessna 152 · S/N 15280871Cancelled May 31, 1994 · Exported to New Zealand · Skylark IncN5556WPiper PA-28-160 · S/N 28648Cancelled May 27, 1994 · Triennial form not returned · Kalfus Raymond NN8944VCessna 172 · S/N 36844Cancelled Mar 26, 1991 · Triennial form not returned · Wildhaber Kenneth VN555TTPiper PA-28-151 · S/N 287515241Cancelled Jul 15, 1990 · Triennial form not returned · Jefferson City Flying ServiceN66419Cessna 150M · S/N 15076034Cancelled Sep 29, 1983 · New Jefferson City Flying Serv IncN90MPHughes 269A · S/N 1050413Cancelled Dec 14, 1978 · Missouri State Highway PatrolN5792MCessna 310P · S/N 310P-0092Cancelled Apr 16, 1974 · Jefferson City Flying Service IncN5868ECessna 150 · S/N 17368Cancelled Jan 4, 1971 · Capital City Flying Club IncN33722Aeronca 65-CA · S/N CA-12931Cancelled Feb 20, 1956 · Jones Joe FrankN54880Consolidated L5 · S/N 75-132Cancelled Feb 7, 1951 · Missouri State Highway PatrolN73546Cessna T-50 · S/N 2849Cancelled Jan 23, 1951 · Brummet Aircraft CoN48253Fairchild M-62A · S/N T42-3399Cancelled Oct 31, 1949 · Brummet Aircraft CoN73528Howard DGA-15P · S/N 29486Cancelled May 10, 1949 · National Air Transport System Inc
Back to Jefferson City, MO