Earlier aircraft under this name · 18

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'OHIO STATE UNIVERSITY' OR list_contains(d.other_registrant_names, 'OHIO STATE UNIVERSITY') 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_name = 'OHIO STATE UNIVERSITY' OR list_contains(d.other_registrant_names, 'OHIO 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 = 'OHIO STATE UNIVERSITY' OR list_contains(d.other_registrant_names, 'OHIO 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.

N619RAOhio State University AVANTI · S/N 1Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Columbus, OH N614RAOhio State University PEREGRINE · S/N 1Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Columbus, OH N120BGDJI PHANTOM 3 PROFESSION · S/N P76DCF29016402Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Columbus, OH N616RAOhio State University The OCTAVIAN · S/N 1Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Columbus, OH N547WUSensefly EBEE · S/N EB-02-618Cancelled Oct 23, 2021 · Registration expired, pending cancellation · Columbus, OH N121BGEvent 38 Unmanned Systems E384 · S/N 3845047Cancelled Oct 12, 2021 · Second renewal notice · Columbus, OH N571MUDJI PHANTOM 2 · S/N PH645205288 V1.0Cancelled Oct 12, 2021 · Third renewal notice · Columbus, OH N33225Piper J3F-65 · S/N 5900Cancelled Jul 30, 2019 · Built 1940 · Columbus, OH N615RAOhio State University BAT-III · S/N 1Cancelled Dec 12, 2018 · Registration expired, pending cancellation · Columbus, OH N110SQBell 47G-3B · S/N 3100Cancelled Dec 5, 1982 · Administratively canceled · Columbus, OH N15386Bell 47G-2 · S/N 2399Cancelled Jan 21, 1982 · Administratively canceled · Columbus, OH N90SUBell 47G-3B · S/N 3288Cancelled Dec 17, 1981 · Columbus, OH N260SUPiper PA-28-140 · S/N 28-7425220Cancelled Dec 19, 1974 · Built 1974 · Columbus, OH N140SUBeech 19A · S/N MB-442Cancelled Feb 25, 1974 · Columbus, OH N61625Boeing A75N1 · S/N 75-644Cancelled Jul 9, 1954 · Exported to Mexico N53539Taylorcraft DCO-65 · S/N L-5998Cancelled Feb 1, 1951 N53531Taylorcraft DCO-65 · S/N L-5201Cancelled Nov 30, 1948 N48279Taylorcraft/Coburn DCO-65L2M · S/N 5396Cancelled Nov 2, 1948 · Columbus, OH

Back to Ohio State University