Skip to content

Springfield, MO

Cancelled registrations · 189

Query with SQL

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 = 'SPRINGFIELD' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

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 = 'SPRINGFIELD'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N971TCColt Balloons 69A · S/N 1480Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1989 · Robinson Shane N63306Horras Phillip W TWINSTARR-HORRAS · S/N TS97010Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1998 N50795Schweizer SGS 2-8 · S/N 28Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1942 · Aldridge Jon S N97WBBrowning Willis W CA-65 · S/N 111976Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1987 · Bryant Ronald N858DJCessna 172M · S/N 17261199Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1972 · Jacquet Dominic Patrick Henry N6363RCessna 172RG · S/N 172RG0170Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Jacquet Dominic Patrick Henry DBA N64724Aerostar International S-60A · S/N S60A-3058Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Built 1987 · Cox Lester B N90047Cessna 140 · S/N 9105Cancelled Jul 15, 2013 · Built 1946 · Tailwheel Flight Instruction Plus LLC N4889UCheney William R BABY LAKES · S/N 7720-B-653-BCancelled Jul 11, 2013 · Sale reported, canceled N7541UMignet HM290 · S/N HM-290L1Cancelled Jul 11, 2013 · Sale reported, canceled N2081YCameron Balloons US N-65 · S/N 5413Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Bearden Carpet Supply Co N65237Aerostar International S-60A · S/N S60A-3065Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1987 · Wilson John N83PVFrye Paul V MONNETT MONI · S/N 169Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Frye Paul V N121RERotec Engineering PANTHER 2 PLUS · S/N 1014Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1985 N9270JPiper PA-28-180 · S/N 28-3347Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1966 · Pro Flight Air Inc N8121TPiper PA-28-181 · S/N 28-8090143Cancelled May 13, 2013 · Registration expired, pending cancellation · Janeczko Gregory F N613SEDouglas DC-6A · S/N 45058Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1956 · Falcon Leasing Co N5750DPiper PA-22-150 · S/N 22-4450Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1956 · Strouse Donald L N5430BCessna 182 · S/N 33430Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1956 · Jespersen Norman L N9675DPiper PA-22-150 · S/N 22-6591Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1959 N88MHHuston John E SONERAI-II · S/N 311Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1984 N6329Republic F-84F · S/N F876Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1951 N3239FMooney M20E · S/N 670032Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1967 · Keller Otis A N25191Boeing E75N1 · S/N 75-2117Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1941 · Air And Military Museum Of The Ozark N5585XWoolaway R.F. THORP T-18 · S/N 694Cancelled Sep 5, 2012 · Registration pending, canceled · Built 1980 N19275Cessna 150L · S/N 15074294Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1973 · Springfield Flying Service Inc N1050HFoster Roger L SBII · S/N 1Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Foster Roger L N1375YCessna 172C · S/N 17249075Cancelled Jun 14, 2012 · Sale reported, canceled · Built 1961 N4125APiper PA-32R-301T · S/N 3257032Cancelled May 19, 2011 · Exported to Mexico · Built 1998 · D J Leasing LLC N7754TCessna 172A · S/N 47354Cancelled Mar 21, 2011 · Expired dealer · Built 1960 · Lance Call World Aircraft Services Inc N292UXEmbraer EMB-120ER · S/N 120.292Cancelled Jan 10, 2011 · Exported to Zambia · Built 1994 · Dunham David E Trustee N3555GCessna 172S · S/N 172S8958Cancelled Dec 11, 2009 · Exported to Australia · Kaufman C Erick N89PESims Dale EMERAUDE · S/N 1436Cancelled Dec 2, 2009 · Built 1991 · Sims Dale E N95152Piper PA-28-140 · S/N 28-25824Cancelled Sep 17, 2009 · Registration revoked · Built 1969 · Mitchell Tim N2665Semco Balloon TC-4 · S/N SEM27Cancelled Jul 15, 2009 · Registration revoked · Built 1971 · Hi Vu Copter Company N5625NPowrachute SKY RASCAL · S/N 029Cancelled Apr 9, 2009 · Built 2002 · Bender Robert H N3112JCessna 150G · S/N 15065812Cancelled Aug 18, 2008 · Triennial form undeliverable · Built 1966 · Humphreys Melvin D N7731GCessna 150L · S/N 15074720Cancelled Jul 21, 2008 · Triennial form undeliverable · Built 1973 · Springfield Flying Service Inc N7096ZAerostar International RX-7 · S/N RX7-3302Cancelled Jul 14, 2008 · Exported to Canada · Built 1994 · Elliff Carson N5193BBell 47G-2 · S/N 2174Cancelled Mar 3, 2008 · Triennial form undeliverable · Built 1958 · Modern Transportation Mode Inc N123XSSaab-Scania SF340A · S/N 340A-123Cancelled Oct 17, 2007 · Exported to Argentina · Worldwide Aircraft Services Inc N140BFFrey Brian D BKF 5 · S/N 1634Cancelled Jun 25, 2007 · Triennial form undeliverable · Built 1998 · Frey Brian D N85MMMalone Mark S VANS RV6A · S/N 20034Cancelled Aug 7, 2006 · Triennial form not returned · Malone Mark S N99776Kile PIETENPOL · S/N CRK-2Cancelled Mar 29, 2006 · Second triennial mailing, no response · Built 1976 · Kile Charles B N619TThompson Steve L AVID MARK IV · S/N 968Cancelled Dec 13, 2005 · Triennial form not returned · Built 1997 · Thompson Steve L N203YVEmbraer EMB-120 · S/N 120.203Cancelled Sep 9, 2005 · Exported to Australia · Built 1990 · Dunham David E Trustee N90GSCessna 177RG · S/N 177RG0890Cancelled Jul 14, 2004 · Exported to Spain · Built 1976 · Sharp Glennis V N51013Cessna U206F · S/N U20601971Cancelled Mar 3, 2004 · Exported to Mexico · Built 1973 · Double H Enterprises LLC N102GSSwearingen SA227-AC · S/N AC-503Cancelled May 6, 2002 · Exported to Mexico · Built 1982 · Worldwide Aircraft Services Inc N63668Cessna 150M · S/N 15077469Cancelled Nov 2, 2001 · Triennial form not returned · Built 1975 · Corry Francis M

Back to Springfield, MO