Skip to content

Cancelled registrations · 69

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

N246BKCessna 340A · S/N 340A1246Cancelled Dec 1, 2025 · Exported to Canada · Built 1981 · Dfsb LLC N4540CAir Tractor AT-502 · S/N 502-0119Cancelled Nov 21, 2022 · Registration pending, canceled N626ZWDJI PHANTOM 3 ADVANCED · S/N CE161123429556Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Ozair LLC N691VDDJI PHANTOM 3 PROFESSION · S/N P76DCK19A26094Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Vandrone LLC N692VDYuneec Electric TYPHOON Q500+ · S/N YU15150934B02B01Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Vandrone LLC N706VUNew Earth Robotics PLUTO · S/N 201601003Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Department Of Plant Pathology N778KGDJI PHANTOM 3 PROFESSION · S/N P78DCH06031360Cancelled Nov 4, 2019 · Registration expired, pending cancellation · 502 Media Group LLC N254UA3D Robotics IRIS · S/N KSUM004Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Kansas State University N690RKKsu Aiaa Uas Competition Team OCTOKAT 2 · S/N 20001015Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Ksu Aiaa Uas Competition Team N694EBKsu Aiaa Uas Competition Team OCTOKAT 1 · S/N 20001014Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Ksu Aiaa Uas Competition Team N706TPNew Earth Robotics PLUTO · S/N 201601002Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Kansas State University N634XKKansas State Univ Aiaa Uas Com SPYKAT · S/N 20001013Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Ksu Aiaa USA Competition Team N261RFTolbert Robert R RANS S-6 · S/N 01041544Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Bell Andrew A N231UAKansas State University DJI S1000 · S/N KSUE002Cancelled Feb 13, 2018 · Kansas State University N232UAKansas State University DJI S800 · S/N KSUM003Cancelled Feb 13, 2018 · First renewal notice · Kansas State University N233UAKansas State University DJI S800 · S/N KSUH001Cancelled Feb 13, 2018 · Kansas State University N252UADJI MATRICE · S/N KSUA002Cancelled Feb 13, 2018 · Kansas State University N255UAAquacopters BULLFROG · S/N KSUM005Cancelled Feb 13, 2018 · Kansas State University N720UAKansas State University AERO · S/N KSU-E-001Cancelled Feb 13, 2018 · Kansas State University N722UAKansas State University AERO · S/N KSUM001Cancelled Feb 13, 2018 · Kansas State University N723UAKansas State University ZEPHYR · S/N KSUM002Cancelled Feb 13, 2018 · Kansas State University N8550GCessna 150F · S/N 15062650Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1965 · Mcelligott Jeremiah L N115LMMoon Larry L SINGLE · S/N 1Cancelled May 20, 2015 · Registration expired, pending cancellation · Moon Larlry L N369WTFrost Roger A EXEC 162F · S/N 6132Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Crna Pa Inc N815Testory SPECIAL · S/N 1Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1973 · Taylor Kerry M N4508QCessna 402A · S/N 402A0008Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1968 · Capitol Ar Service Inc N7835PPiper PA-24 · S/N 24-3055Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1962 · Calvin Joe B N3599ECessna 172N · S/N 17271602Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1978 · Capitol Air Service Inc N36ZZFrost Roger A MINI 500 · S/N 336Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Frost Roger A N3225HWalter Leo W BD-5-B · S/N 3033Cancelled May 7, 2013 · Sale reported, pending cancellation · Built 1984 N70058Cessna A188B · S/N 18801825Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1974 · Dare William N3961SSmith Robert L BENSEN B8M · S/N 1Cancelled Dec 11, 2012 · Sale reported, pending cancellation N56712Piper PA-34-200 · S/N 34-7450025Cancelled Oct 3, 2012 · Revoked, canceled · Built 1973 · Capitol Air Service Inc N2689YCessna 180F · S/N 18051189Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Built 1962 · Bath William J N130CMPiper PA-31-350 · S/N 31-7652142Cancelled Jul 20, 2005 · Triennial form not returned · Built 1976 · Kansas Air Center Inc N24993Cessna 152 · S/N 15280500Cancelled Nov 2, 1998 · Triennial form not returned · Kansas Air Center Inc N7126NBeech 95-B55 (T42A) · S/N TC1060Cancelled Feb 24, 1996 · Triennial form not returned · Stout Bill R N4268SBeech A36 · S/N E960Cancelled Nov 28, 1995 · Triennial form not returned · Briggs Russell K N6663XCessna 210A · S/N 21057663Cancelled Nov 7, 1995 · Triennial form not returned · Heartland Aviation N4805SPiper PA-32-260 · S/N 321168Cancelled Sep 30, 1995 · Triennial form not returned · Nelson Poultry Farms Inc N4215CStinson 108-3 · S/N 1085215Cancelled Jun 9, 1995 · Exported to Australia · Schroll James R N52826Cessna 182P · S/N 18262876Cancelled May 18, 1995 · Triennial form not returned · Bambara John F N135ATPiper PA-28-161 · S/N 287916222Cancelled Jul 7, 1994 · Triennial form not returned · Charter America Inc N733XSCessna 172N · S/N 17268636Cancelled Mar 21, 1994 · Kansas Air Center Inc N26545Piper PA-39 · S/N 395Cancelled Sep 13, 1993 · Irvin H Hugh N6603HCessna 172M · S/N 17265505Cancelled Sep 13, 1993 · Triennial form not returned · K S Flying Club Inc N67928Cessna 152 · S/N 15282105Cancelled Sep 13, 1993 · Triennial form not returned · K S Flying Club Inc N1FBCessna 421C · S/N 421C1403Cancelled Sep 11, 1993 · Kansas Farm Bureau Services Inc N9320SBeech C23 · S/N M1637Cancelled Aug 31, 1993 · Triennial form not returned · Kuhlman Dennis K N2720FCessna 182J · S/N 18256820Cancelled Nov 27, 1991 · Triennial form not returned · Dennis Everett J

Back to Manhattan, KS