Kansas State University
Earlier aircraft under this name · 47
Cancelled registrations that named this owner when they ended, newest first.
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_name = 'KANSAS STATE UNIVERSITY' OR list_contains(d.other_registrant_names, 'KANSAS STATE UNIVERSITY') 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_name = 'KANSAS STATE UNIVERSITY' OR list_contains(d.other_registrant_names, 'KANSAS STATE UNIVERSITY') 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.
N706VUNew Earth Robotics PLUTO · S/N 201601003N254UA3D Robotics IRIS · S/N KSUM004N706TPNew Earth Robotics PLUTO · S/N 201601002N37UAKansas State University DJI INSPIRE 1 · S/N DJI-IN-11N231UAKansas State University DJI S1000 · S/N KSUE002N232UAKansas State University DJI S800 · S/N KSUM003N233UAKansas State University DJI S800 · S/N KSUH001N250UADJI S800 EVO · S/N KSUW001N252UADJI MATRICE · S/N KSUA002N255UAAquacopters BULLFROG · S/N KSUM005N256UA3D Robotics IRIS+ · S/N KSUC001N257UA3D Robotics IRIS+ · S/N KSUC002N30UAKansas State University DJI S800 · S/N DJI-A2-04N32UAKansas State University DJI S800 · S/N DJI-WO-02N33UAKansas State University S800 · S/N RCT-AD-03N36UAKansas State University S800 · S/N RCT-NZ-01N38UAKansas State University 3DR X8+ · S/N 3DR-AD-12N43UAKansas State University AEROSONDE MK 4.7J · S/N AAI-PI-50N46UAKansas State University AEROSONDE MK 4.7K · S/N AAI-PI-51N47UAKansas State University PENGUIN B · S/N FAC-PI-52N48UAKansas State University PENGUIN B · S/N FAC-PI-53N49UAKansas State University CROW · S/N KSU-PI-54N50UAAeryon Labs SCOUT · S/N ARN-PA-08N51UA3D Robotics X8+ · S/N 3DR-AD-13N52UA3D Robotics X8+ · S/N 3DR-AD-14N54UAKansas State University TREX 800 · S/N KSU-PI-10N56UAKansas State University WOLVERINE · S/N VIK-AD-07N57UAKansas State University WOLVERINE · S/N VIK-WE-06N59UADJI S1000+ · S/N DJI-A2-15N60UAKansas State University CROW · S/N KSU-PI-55N61UAKansas State University X8 · S/N KSU-AD-58N62UAKansas State University ZEPHYR · S/N KSU-P4-56N63UAKansas State University VIREO · S/N UTC-PI-60N64UAKansas State University VIREO · S/N UTC-PI-59N65UAKansas State University ZEPHYR · S/N KSU-AD-57N66UAKansas State University ULTRA LONG STICK · S/N KSU-AD-62N67UAKansas State University X8 · S/N KSU-P4-63N68UAKansas State University SKYWALKER 2014 1800M · S/N KSU-AD-64N70UADJI PHANTOM 2 VISION + · S/N DJI-NZ-16N720UAKansas State University AERO · S/N KSU-E-001N722UAKansas State University AERO · S/N KSUM001N723UAKansas State University ZEPHYR · S/N KSUM002N81UAKansas State University SKYWALKER 2014 1800M · S/N KSU-AD-65N82UAKansas State University SKYWALKER 2014 1800M · S/N KSU-AD-66N804KSSchleicher ASK-21 · S/N 87-974N805KSSchweizer SGM2-37 · S/N 87-0761N803KSSchleicher ASK-21 · S/N 87-973
Back to Kansas State University