Earlier aircraft under this name · 27

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 = 'UNIVERSITY OF OKLAHOMA' OR list_contains(d.other_registrant_names, 'UNIVERSITY OF OKLAHOMA') 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 = 'UNIVERSITY OF OKLAHOMA' OR list_contains(d.other_registrant_names, 'UNIVERSITY OF OKLAHOMA')
  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 = 'UNIVERSITY OF OKLAHOMA' OR list_contains(d.other_registrant_names, 'UNIVERSITY OF OKLAHOMA')
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.

N7562BCessna A152 · S/N A1520769Cancelled Aug 21, 2025 · Exported to Brazil · Built 1977 · Norman, OK N917UAMeteomatics METEODRONE SSE · S/N 201610-SSE-2Cancelled Nov 15, 2021 · Norman, OK N920UAMeteomatics METEODRONE SSE · S/N 201610-SSE-3Cancelled Nov 13, 2021 · Norman, OK N7602CPiper PA-28R-200 · S/N 28R-7635103Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1975 · Norman, OK N262UAUniversity Of Oklahoma UAVRF920 · S/N CASS-0005Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Norman, OK N935ABAutel Robotics X-STAR PREMIUM · S/N UXS610311953Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Norman, OK N935AADJI PHANTOM 4 PRO · S/N 0AXCE2U0A30222Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Norman, OK N916UAMeteomatics METEODRONE SSE · S/N 201610-SSE-1Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Norman, OK N905UA3D Robotics IRIS+ · S/N OU 03Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Norman, OK N81022Piper PA-28-161 · S/N 28-8016107Cancelled Nov 15, 2006 · Exported to Malaysia · Built 1979 · Norman, OK N8217VPiper PA-28-161 · S/N 28-8016336Cancelled Nov 15, 2006 · Exported to Malaysia · Built 1980 · Norman, OK N8231VPiper PA-28-161 · S/N 28-8016350Cancelled Nov 15, 2006 · Exported to Malaysia · Built 1980 · Norman, OK N8365HPiper PA-28-161 · S/N 28-8116192Cancelled Nov 15, 2006 · Exported to Malaysia · Built 1981 · Norman, OK N73896Hiller YH32 · S/N 55-4964Cancelled Jun 22, 1970 · Norman, OK N73897Hiller YH32 · S/N 55-4966Cancelled Jun 22, 1970 · Norman, OK N5400UPiper PA-28-140 · S/N 28-20324Cancelled Aug 17, 1967 N4720CRepublic F84G · S/N 51-818Cancelled Dec 31, 1963 · Built 1961 · Norman, OK N9100RSikorsky HO5-S1 · S/N 580078Cancelled Dec 20, 1963 · Norman, OK N9101RGrumman F9F · S/N F9F2123078Cancelled Dec 20, 1963 N9102RGrumman F9F · S/N 123054Cancelled Dec 20, 1963 · Norman, OK N4188EAeronca 7AC · S/N 7AC-7140Cancelled Jan 6, 1955 · Built 1947 · Norman, OK N76890Cessna 140 · S/N 11324Cancelled Jun 28, 1949 N3791EAeronca 7AC · S/N 7AC-7071Cancelled Jun 21, 1949 · Built 1947 · Norman, OK N4174EAeronca 7AC · S/N 7AC7138Cancelled Jun 17, 1949 N4194EAeronca 7AC · S/N 7AC7141Cancelled Jun 17, 1949 N4209EAeronca 7AC · S/N 7AC7147Cancelled Jun 17, 1949 N4278EAeronca 7AC · S/N 7AC7166Cancelled Jun 17, 1949

Back to University Of Oklahoma