Skip to content

Cancelled registrations · 183

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 = 'FL' AND d.registrant_city = 'OCALA' 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 = 'FL' AND d.registrant_city = 'OCALA'
  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 = 'FL' AND d.registrant_city = 'OCALA'
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.

N5381SCessna 337A · S/N 337-0481Cancelled Sep 20, 2026 · Sale reported, canceled · Built 1966 N8687SRichard Smith ROTORWAY 162F · S/N 6133Cancelled Jun 9, 2026 · Sale reported, canceled · Built 2018 N318KWJames Wiebe CH-2A · S/N 002Cancelled Apr 1, 2026 · Built 2019 · Jones Nicholas E N10SMParker SPERRY MESSENGER · S/N P1Cancelled Jul 30, 2024 · Built 1974 · Parker Raymond L N911BABell OH-58A · S/N 70-15327Cancelled Mar 14, 2023 · Marion County Sheriffs Department N140JBPiper PA-28-140 · S/N 28-7525151Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1975 · Williams James E N97822Stinson 108-1 · S/N 108-822Cancelled Dec 26, 2022 · Built 1946 · Wilmoth Todd N6644FCessna 150F · S/N 15063244Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1966 · B & C 172 LLC N724BCCessna 172H · S/N 17255148Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1966 · Graham Kenneth G N66BMBruce Mcgregor SPA PANTHER · S/N 106Cancelled Sep 23, 2021 · Mcgregor Bruce J N50934Sky Raider SKY RAIDER 1 · S/N 177Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2007 · Stossel William J N999LPCessna 320D · S/N 320D0129Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1966 · Nall James D N203ATDouglas A4D-2N · S/N 12695Cancelled Jul 17, 2021 · Expired dealer · Raf Group 45 LLC N775EVEmbraer Executive EMB-500 · S/N 50000396Cancelled Jun 8, 2021 · Exported to San Marino · Maveriko LLC N820NGEvektor-Aerotechnik SPORTSTAR · S/N 20070818Cancelled Apr 5, 2021 · Registration expired, pending cancellation · Built 2007 · Navolio Ellen L Trustee N152RCCessna 152 · S/N 15285033Cancelled Mar 25, 2021 · Exported to Mexico · Built 1981 · Ocala Aviation Services Inc N9507EBellanca 17-30A · S/N 76-30817Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Bellanca LLC N30683Piper J3C-65 · S/N 5046Cancelled Aug 15, 2020 · Sale reported, canceled · Built 1940 N79111North American/Aero Classics P-51D · S/N 44-15651Cancelled Mar 1, 2020 · Assigned, pending cancellation · Aero-Trans Corp N40AHHelms Adolphus L ZENITH CH-250 · S/N 14540FCancelled Nov 4, 2019 · Registration expired, pending cancellation · Peters Michael D N754MTDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF09017136Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Thurgaland Marketing And Consulting Inc N6415ECessna 172N · S/N 17272018Cancelled Jul 24, 2019 · Exported to Philippines · Built 1978 · Limor Nachshon N616HGYuneec International TYPHOON Q500 4K · S/N YU15262449B04B01Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Greene Jeff S N567HGDJI Innovations FLAMEWHEEL F550 · S/N 0501Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Luxury Aerial Shots LLC N114DHHermann Donald L SONEX LTD · S/N 0854Cancelled Nov 20, 2018 · Sale reported, canceled N4585JPiper PA-28R-180 · S/N 28R-30455Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1968 · Gulfstream Aviation Inc N6799JPiper PA-28-140 · S/N 28-24530Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Gulfstream Aviation N537JAUniv Of Florida M&As ENG Dept NOVA · S/N 141522100Cancelled Aug 10, 2018 · Registration expired, pending cancellation · University Of Florida N537KAUniv Of Florida M&As ENG Dept NOVA · S/N 141522102Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Mechanical & Aerospace Engineering Department N5418FUniversity Of FL Mech & Aerosp NOVA · S/N 141522101Cancelled Aug 10, 2018 · Registration expired, pending cancellation · University Of Florida N11SQVans RV-12 · S/N 120921Cancelled Aug 1, 2018 · First renewal notice · Built 2016 · Mcgregor Suzanne N89PJTruthan Charles PRGSIVE ARDYN SEAREY · S/N 1DK196Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 2000 · Truthan Charles E N911GEBell 206B · S/N 5271Cancelled Apr 6, 2018 · First renewal notice · Built 2001 · Marion County Sheriff N11BMBruce J Mcgregor VANS RV-10 · S/N 41584Cancelled Feb 20, 2018 · Mcgregor Bruce J N46KEAeronca 7AC · S/N 7AC-5327Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1946 · Boykin Mark C N7025RPiper PA-28-140 · S/N 28-21721Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1966 · Heagy Robert T III N297CFChampion 7GCAA · S/N 72Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1966 · Boykin Mark C N823RGDJI PHANTOM 4 PRO+ · S/N 0AXDE1C0A31762Cancelled Oct 19, 2017 · Golden Film Production & Photography LLC N666PPMcgregor Bruce J SEAREY · S/N 1LK554CCancelled Sep 14, 2017 · Built 2012 · Mcgregor Bruce J N3085PHarris Derrick T ROTOWAY EXEC · S/N DH-4657Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1994 · Fisher David S N510TVHughes Helicopters HUGHES 369D · S/N 1060010DCancelled Jun 30, 2017 · Registration expired, pending cancellation · Bird Group LLC N6284KRepublic RC-3 · S/N 497Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Mcgowan John N7235PPiper PA-24-250 · S/N 24-2409Cancelled Feb 4, 2017 · Revoked, canceled · Built 1960 · Liebrecht Eugene DBA N1235Pitts Special S-1C · S/N 51667Cancelled Aug 16, 2016 · Third renewal notice · Built 1970 · Thorp Patricia J N90081Sabre SABRE 503 · S/N SA991673Cancelled Jun 26, 2015 · Melino Fred D N9433FGibbo Gear BB 503 · S/N GG041896Cancelled Jun 26, 2015 · Melino Fred D N251LRBell OH-58C · S/N 73-21932Cancelled May 19, 2015 · Sale reported N922JTPiper PA-23-250 · S/N 27-7304949Cancelled May 19, 2015 · Exported to Bahamas · Built 1972 · Southern King Air Inc N6172FCornelius Charles C KR-2S · S/N KR-2S-341Cancelled May 13, 2015 · Registration expired, pending cancellation · Cornelius Charles C N7043UNorth American T-39A · S/N 60-3484Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1960 · Iloc Inc

Back to Ocala, FL