Skip to content

Cancelled registrations · 72

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

N9075SInfinity Power Parachutes INFINITY 2007 COMMAN · S/N IPP7-346Cancelled Nov 1, 2025 · Sale reported, canceled · Built 2007 N772LBHead Balloons AX7-77 · S/N 205Cancelled Jul 20, 2024 · Sale reported, canceled · Built 1993 N761PMCessna T210M · S/N 21062410Cancelled Apr 18, 2023 · Exported to Canada · Built 1977 · Woods William L N650BTTheophilus Okosun ZENITH ZODIAC CH650B · S/N 65-8879Cancelled Jan 14, 2023 · Sale reported, canceled · Built 2014 N3678DBeech A36 · S/N E-1715Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Advantage Construction Inc N7718TCessna 172A · S/N 47318Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1960 · Bodine Micheal J N982AGDJI INSPIRE 1 · S/N W13DCA18020552Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Steve Twitchell Production Inc N685JEDJI PHANTOM 3 ADVANCED · S/N P79DCK13040693Cancelled Sep 10, 2019 · Registration expired, pending cancellation · Enchanted Creatures Photography LLC N670GEDJI PHANTOM 3 PROFESSION · S/N P78DCE12030396Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Enchanted Creatures Photography LLC N5566HPiper PA-11 · S/N 111088Cancelled Apr 17, 2019 · Miles Charles D N9429ZGrumman TBM-3E · S/N 91714Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Stricker Wes N750RLZenith Air Research Lab STOL CH 750 RL · S/N 75-8752Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Zenith Air Research Lab LLC N50EPParker VARI-EZE · S/N 89Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1979 · Dohrn Carroll E DBA N1986ZSixchuter SR7 · S/N SR7XL-2584Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Built 2003 · Simms Sam R N691USBalloon Works FIREFLY 8 · S/N F8408Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Mccollum Roger N4069TBalloon Works FIREFLY 7 · S/N 10049Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1979 · Bartok Peter J N1248FBalloon Works FIREFLY 6 · S/N 601Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1974 · Montague Terry N462XVSupermarine/Vickers SEAFIRE MK IV · S/N 415Cancelled Mar 24, 2014 · Exported to United Kingdom · Stricker William E N2561JBalloon Works FIREFLY 7B-15 · S/N F7B-350Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Graham Gerald T N8300HEmigh TROJAN A-2 · S/N 3Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1948 · Mitchell T W N6231ZRote Thomas Dean SPACE SHUTTLE · S/N 2001Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Rote Thomas Dean N64RBBowers FLY-BABY · S/N 68-5Cancelled Aug 20, 2013 · Sale reported, canceled N1500CBalloon Works FIREFLY 7 · S/N 11109Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1981 · Bartok Peter J N1623RGrumman American Avn. AA-1B · S/N AA1B-0623Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1976 · Tig Air Aviation N4889EChampion AERONCA 7GC · S/N 7GC-63Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1959 · Swearingen Terrill P N8518SCessna 182H · S/N 18256618Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1965 · Wells Henry G Jr N738AGCessna 172N · S/N 17269821Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Fay John M N2484DInfinity INFINITY 2002 · S/N IPP2-108Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 2002 · Anderson James M N47859Cessna 152 · S/N 15283260Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1979 · Financial Architects Inc N5270XChampion 7KCAB · S/N 226Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1969 · Vandine Rose M N423WCCrowley E W DAVIS DA-2B · S/N 4Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Crowley E W N55MWWheeler PITTS SPECIAL · S/N MW-1Cancelled Sep 25, 2009 · Exported to Canada · Built 1980 · Hansen Ronald J N3404LCessna U206B · S/N U206-0704Cancelled Dec 17, 2008 · Exported to Mexico · Built 1966 · Brandecker Edward W N310VBCessna 310R · S/N 310R0108Cancelled Mar 5, 2008 · Exported to Canada · Built 1975 · Stohldrier Donald I N5429TCessna 172E · S/N 17251329Cancelled Jul 13, 2007 · Exported to Canada · Built 1964 · Pieper Robert L A N8041APiper PA-28RT-201T · S/N 28R-8231020Cancelled Apr 20, 2006 · Exported to Canada · Built 1981 · Q And E Aircraft LLC N1527BBalloon Works FIREFLY 7 · S/N 10986Cancelled Sep 30, 2005 · Second triennial mailing, no response · Built 1981 · Sutter Denis N73445Cessna 207A · S/N 20700591Cancelled Oct 4, 2004 · Exported to Philippines · Built 1980 · Subic Bay Medical Center Inc N2272DOliver Tim/Price Albert QUICKSILVER MX · S/N 10839Cancelled Aug 13, 2003 · Second triennial mailing, no response · Oliver Tim S N126APBeech B200 · S/N BB1157Cancelled Aug 28, 2002 · Exported to Philippines · Built 1984 · Subic Bay Medical Center Inc N27029Balloon Works FIREFLY 6B · S/N 6643Cancelled Dec 18, 2001 · Built 1976 · Montague Terry N40699Balloon Works FIREFLY 6B · S/N 10051Cancelled Jun 13, 2001 · Triennial form not returned · Montague Terry W N8168WPiper PA-28-180 · S/N 28-2287Cancelled May 10, 2000 · Triennial form not returned · Hindman Darwin A Jr N1020JAero Commander 112 · S/N 20Cancelled Sep 10, 1997 · Triennial form not returned · Thomas Robert M N2397JBeech 23 · S/N M364Cancelled Apr 14, 1997 · Triennial form not returned · Palmer Harri A N795JRRaney John F YOUNGSTER V · S/N B0016Cancelled Mar 19, 1997 · Raney John F N7566JPiper PA-28R-180 · S/N 28R30945Cancelled May 14, 1996 · Triennial form not returned · Yanders Armon F N4704JBeech A23-24 · S/N MA166Cancelled Oct 25, 1995 · Second triennial mailing, no response · Antweiler William L N95956Taylorcraft BC12-D · S/N 8256Cancelled Oct 14, 1992 · Exported to Australia · Bowman Brian R N2256APiper PA-22-135 · S/N 22658Cancelled Mar 6, 1992 · Woolery David W Jr

Back to Columbia, MO