Skip to content

Cancelled registrations · 39

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 = 'CLERMONT' 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 = 'CLERMONT'
  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 = 'CLERMONT'
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.

N779NRDJI PHANTOM 3 PROFESSION · S/N P76DCG15016237Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Mitigation Resources LLC N704GZDJI INSPIRE 1 · S/N W13DCC28030225Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Senninger Irrigation Inc N3207XCessna 150G · S/N 15064607Cancelled Aug 19, 2021 · Exported to Argentina · Built 1966 · Pendergast Gary N5052VAirborn EDGE X 2000 · S/N 582-596Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2001 · Perez Felipe N770DSCessna 500 · S/N 500-0011Cancelled Feb 8, 2021 · Built 1972 · Cypress Aircraft Sales LLC N501KMCessna 501 · S/N 501-0101Cancelled Dec 9, 2020 · Sale reported · Built 1979 N7968LBeech A23A · S/N M-1002Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1966 · Johnson Jerry Dean N39DMSchempp-Hirth DISCUS-2CT · S/N 38Cancelled Jun 16, 2020 · Exported to Switzerland · Built 2006 · Mackenzie David A N6030GCessna 150K · S/N 15071530Cancelled Apr 6, 2020 · Exported to Argentina · Built 1969 · Bond James N43BLCessna 550 · S/N 5500118Cancelled Jan 27, 2020 · Built 1980 · Cypress Aircraft Sales LLC N649WDDJI PHANTOM 3 PROFESSION · S/N P76DCE15012273Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Devore Design LLC N667PFItaldron ITALDRON SCRABBLE 4H · S/N ID4HSE-M38Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Frisby Crystal M N561BBSanford Brian E ZODIAC CH 650 · S/N 65-8891Cancelled Aug 23, 2019 · First renewal notice · Built 2017 · Sanford Brian E N9321HMoncure Stephen CAPELLA SX FW265CTD · S/N FW2C65TD719114Cancelled Jan 25, 2019 · Registration expired, pending cancellation · Built 1992 · Elliott Frederick T N2702MPiper PA-28R-201T · S/N 28R-7803140Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1977 · Burlingame Financial Advisors LLC N580CRBoeing 727-247 · S/N 20580Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1972 · International Air Leases Of Pr Inc N3645QAerostar International RX 8 · S/N RX8-3061Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1990 · Mccourt Kimberly Royal N2062DHead Balloons AX9 118 · S/N 331Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2004 · Swift Ian R N706BUToulson EB REPLICA JUNGMANN · S/N PFA 242-13771Cancelled Jan 23, 2017 · Exported to Austria · Built 2002 · Tarv Air LLC N691CLRockwell International 690 · S/N 11058Cancelled Jun 9, 2015 · Built 1974 · Centerline Aerospace Inc N321BALet L-23 SUPER BLANIK · S/N 988407Cancelled Mar 12, 2015 · Third renewal notice · Built 1998 · Seminole Flying & Soaring Inc N7890TCessna 172A · S/N 47490Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Built 1960 · Lopez Rafael N151LSBuccaneer XA · S/N B046-A270-447Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1989 · Carlton John W N979BWBell 412 · S/N 33111Cancelled Aug 12, 2014 · Exported to Mexico · Built 1985 · Heli-USA Corp N46EGGreen Earnest Everette RANS S-9 · S/N 0489072Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1991 N2030PInterplane SKYBOY · S/N 026/2001Cancelled Aug 6, 2013 · Sale reported, canceled · Built 2001 N9331TPiper PA-38-112 · S/N 38-78A0043Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1978 N91BLPrice B/Webb D B SCHREDER HP-11A · S/N 14Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Carlton John W N2540LPiper PA-38-112 · S/N 38-79A0755Cancelled Aug 23, 2012 · Registration pending, canceled · Built 1979 N96252Taylorcraft BC12-D · S/N 8552Cancelled Mar 22, 2011 · Second renewal notice · Built 1946 · Haller Theodore R N308BGBurkhart Grob G-103A TWIN II ACRO · S/N 34033-K-265Cancelled Feb 2, 2010 · Triennial form not returned · Seminole Flying & Soaring Inc N6171ZPdps Pzl-Bielsko SZD-55-1 · S/N 551198101Cancelled Apr 20, 2000 · Exported to Canada · Goshorn Kenneth E N98952Cessna 310R · S/N 310R0664Cancelled Mar 5, 1998 · Exported to Kenya · Griffin Ruth E N7HVPiper PA-28R-180 · S/N 28R30927Cancelled Jan 23, 1997 · Exported to Netherlands Antilles · Trentco Inc N25PHHoman Paul E B-8M · S/N 1931Cancelled Jun 24, 1992 N1887HPiper PA-32R-300 · S/N 32R-7780198Cancelled Jun 19, 1982 · Administratively canceled · Langley Richard H N5904XBrantly B-2 · S/N 39Cancelled Feb 1, 1971 · Midway Industries Inc N9391HBell 47D1 · S/N 64Cancelled Jul 21, 1961 · Exported to Canada · Mccaffrey D M N87345Erco 415-C · S/N 518Cancelled Oct 13, 1955 · Hunt W A

Back to Clermont, FL