Skip to content

Cancelled registrations · 511

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 = 'OH' AND d.registrant_city = 'COLUMBUS' 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 = 'OH' AND d.registrant_city = 'COLUMBUS'
  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 = 'OH' AND d.registrant_city = 'COLUMBUS'
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.

N599QSCessna 560XL · S/N 560-5714Cancelled Dec 15, 2025 · Built 2007 · Netjets Sales Inc N28WHRobinson Helicopter R44 II · S/N 14629Cancelled Aug 5, 2025 · Exported to Guatemala · Built 2023 · Performance Transportation Leasing LLC N100YKCessna 152 · S/N 15285955Cancelled Apr 14, 2025 · Exported to Mexico · Built 1985 · Barbee Donald L N50510Cessna 150J · S/N 15069356Cancelled Oct 5, 2024 · Sale reported, canceled · Built 1968 N900LSBombardier BD-700-1A10 · S/N 9522Cancelled Jun 7, 2024 · Exported to Canada · Built 2012 · Vs Service Company LLC N92985Commonwealth 185 · S/N 1719Cancelled Oct 21, 2023 · Revoked, canceled · Built 1946 · Broken Arrow Flyers N3506UNostalgair N-3 PUP · S/N N86660-9Cancelled Aug 17, 2023 · Built 1986 · Schleifer Douglas E N1548APiper PA-20 · S/N 20-744Cancelled May 27, 2023 · Revoked, canceled · Built 1951 · Hartman Wesley J N2622EAeronca 7AC · S/N 7AC-6204Cancelled May 27, 2023 · Revoked, canceled · Built 1946 · Alkire William C N619RAOhio State University AVANTI · S/N 1Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Ohio State University N35938Aerostar International S-60A · S/N S60A-3109Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1989 · Swan Super Cleaners Inc N735HEDJI PHANTOM 4 · S/N 07DDD2000A10197Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Elford Inc N5862WPiper PA-28-180 · S/N 28-2376Cancelled Nov 30, 2022 · Sale reported, canceled · Built 1965 N3943TPiper PA-28R-180 · S/N 28R-30286Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1967 · Abiakel Elio N37815Culver LFA · S/N 324Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Diehl Ryan J N614RAOhio State University PEREGRINE · S/N 1Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Ohio State University N94DAMiller David A DAMRV-4 · S/N 1001Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1994 · Diehl Ryan J N120BGDJI PHANTOM 3 PROFESSION · S/N P76DCF29016402Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Ohio State University N616RAOhio State University The OCTAVIAN · S/N 1Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Ohio State University N851HSensefly EBEE RTK · S/N ER-01-22735Cancelled Jan 8, 2022 · Registration expired, pending cancellation · State Of Ohio Department Of Transportation N547WUSensefly EBEE · S/N EB-02-618Cancelled Oct 23, 2021 · Registration expired, pending cancellation · Ohio State University N121BGEvent 38 Unmanned Systems E384 · S/N 3845047Cancelled Oct 12, 2021 · Second renewal notice · Ohio State University N571MUDJI PHANTOM 2 · S/N PH645205288 V1.0Cancelled Oct 12, 2021 · Third renewal notice · Ohio State University N600LSBombardier CL-600-2B16 · S/N 5913Cancelled Mar 10, 2021 · Exported to Nigeria · Built 2012 · Baden-Baden Properties LLC N158QSBombardier BD-700-1A10 · S/N 60005Cancelled Aug 26, 2020 · Exported to Portugal · Netjets Sales Inc N91WWFlight Design CTSW · S/N 06-08-20Cancelled Jul 23, 2020 · Second renewal notice · Built 2006 · Sunrae Aviation LLC N1675APiper PA-22 · S/N 22-445Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1952 · Bohannan William F N45221Naval Aircraft Factory N3N-3 · S/N 1938Cancelled May 22, 2020 · Revoked, pending cancellation · Built 1940 · Clyde George Co N5823HPiper PA-16 · S/N 16-440Cancelled Feb 10, 2020 · Revoked, canceled · Built 1949 · Sievers Noel H N614SBCessna 525C · S/N 525C0072Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 2012 · Maverick Air LLC N69967Convair BT-13A · S/N 11169Cancelled Jan 24, 2020 · Revoked, canceled · Built 1943 · Bowman Charles F Jr N4739GBensen B-8M · S/N RD1Cancelled Jan 10, 2020 · Revoked, canceled · Built 1965 · Farkas Joseph B Ptnr N176VRBombardier BD-700-1A11 · S/N 9531Cancelled Dec 17, 2019 · Exported to Portugal · Built 2013 · Netjets Sales Inc N36215Taylorcraft BF · S/N 3169Cancelled Dec 13, 2019 · Revoked, canceled · Built 1941 · Webster Allen N29797Taylorcraft BF · S/N 2646Cancelled Dec 9, 2019 · Revoked, canceled · Built 1941 · Davis Norman R N3120KCulver V · S/N V339Cancelled Nov 29, 2019 · Revoked, canceled · Built 1946 · Kirbie Guy B N766TVDJI PHANTOM 2 · S/N PH646019496Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Wbns Tv N2109UBrantly B-2 · S/N 136Cancelled Oct 25, 2019 · Revoked, canceled · Built 1961 · Helicopter Services Inc N432GBTurbo Ace MATRIX-I · S/N MATRIX001Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Battelle Memorial Institute N442GBDJI PHANTOM 3 PROFESSION · S/N P76DCF12016521Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Battelle Memorial Institute N8390BCessna 172 · S/N 36190Cancelled Sep 6, 2019 · Revoked, canceled · Built 1957 · Manson David N N9248JPiper PA-28-180 · S/N 28-3323Cancelled Sep 6, 2019 · Revoked, canceled · Built 1966 · Mar-Vel Sheet Metal Inc N95970Taylorcraft BF · S/N 8270Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Marcum Robert R N97773Howard DGA-15P · S/N 793Cancelled Aug 5, 2019 · Revoked, canceled · Built 1943 · Accurate Maintenance Inc N33225Piper J3F-65 · S/N 5900Cancelled Jul 30, 2019 · Built 1940 · Ohio State University N452GBDJI PHANTOM 2 · S/N PH645159630Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Battelle Memorial Institute N648VAAvyon MICRODRONES MD4-1000 · S/N 233Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Asymmetric Technologies LLC N648ZTAvyon MD4-200 · S/N 552Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Asymmetric Technologies LLC N3660MPiper PA-28-181 · S/N 28-7890321Cancelled Jun 24, 2019 · Exported to New Zealand · Built 1978 · Hcp Inc N20622Fairchild 24 J · S/N 3512Cancelled Jun 12, 2019 · Revoked, canceled · Built 1938 · Mcdermitt William G

Back to Columbus, OH