Leesburg, FL

Cancelled registrations · 87

Query with SQL
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 = 'LEESBURG'
  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.

N5497YPiper PA-23-250 · S/N 27-2590Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1964N3430QCessna 320E · S/N 320E0030Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1966 · Lake Avn IncN9320YBeech M35 · S/N D-6523Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1960 · Shay James DN3724NBeech 35 · S/N D-933Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1947 · Briggs LeonardN5114BCessna 152 · S/N 15283754Cancelled Jul 23, 2012 · Exported to Brazil · Built 1979 · Herbst Michael DBAN4481DBeech G35 · S/N D-4700Cancelled Jul 9, 2012 · Revoked, canceled · Built 1956 · Clifton William AN65102Hiller H-23D · S/N 1354Cancelled Nov 7, 2011 · Second triennial mailing, no response · Built 1961 · Aerostat IncN60806Boeing A75N1(PT17) · S/N 75-2430Cancelled Feb 9, 2009 · Exported to United Kingdom · Built 1941 · Parsons Dennard CN4854WMcclory Walter E SE5 · S/N 4854Cancelled May 21, 2008 · Built 2006 · Mcclory Walter EN6159ZBeech 76 · S/N ME-434Cancelled Apr 9, 2008 · Exported to Austria · Built 1981 · Neil Fischer IncN1266TPiper PA-28-140 · S/N 28-7225412Cancelled Dec 18, 2007 · Triennial form not returned · Built 1972 · Cobia Lawrence JN5625ECessna 150 · S/N 17125Cancelled Jun 26, 2007 · Triennial form not returned · Built 1958 · Holmes Robert BN2461TNavion NAVION G · S/N NAV-4-2461Cancelled Nov 17, 2005 · Triennial form not returned · Built 1962 · Docmasters IncN2938DPiper PA-28-181 · S/N 28-7990570Cancelled Sep 22, 2005 · Triennial form not returned · Built 1979 · Norcross Geoffrey CN5136CBeech B35 · S/N D-2421Cancelled May 10, 2000 · Triennial form not returned · Westfair IncN8171FCessna 150F · S/N 15064271Cancelled Nov 24, 1999 · Exported to Mexico · Howard Marion RN9076PPiper PA-24-260 · S/N 244545Cancelled Jan 29, 1998 · Exported to Canada · Tweedle William CN32740Bouffard Charles J TEAM Z-MAX 1200 · S/N 608Cancelled Jul 3, 1997 · Bouffard Charles JN4276SStrickland Chester AA EXPLORER · S/N 004503Cancelled May 9, 1997 · Bouffard Charles JN70CAero Commander 560-E · S/N 549Cancelled Mar 8, 1996 · Brainerd Helicopters IncN3518WPiper PA-32-260 · S/N 32402Cancelled Jan 9, 1996 · Exported to New Zealand · Shrewsbury William HN546VBeech 95-C55 · S/N TE165Cancelled Oct 26, 1995 · Triennial form not returned · Gregg F BrowneN15JNNelson John C CORBIN BABY ACE · S/N 1Cancelled Aug 12, 1995 · Triennial form not returned · Nelson John CN14ADRockwell International 690A · S/N 11314Cancelled Nov 2, 1993 · Exported to Panama · Mid Florida Air IncN7784ZPiper PA-25-235 · S/N 253987Cancelled Dec 23, 1986 · Exported to Mexico · Michael Donald K DBA Michael AircraftN5792KBeech S35 · S/N D-7582Cancelled Aug 17, 1982 · Executive Cars IncN8396JCessna 150G · S/N 15066296Cancelled Aug 19, 1974 · Built 1967 · Heyland-Wall Air Sales IncN7JPitts Special S1-C · S/N 61564-65Cancelled Feb 8, 1974 · Smithgall William AN528BBeech A35 · S/N D1543Cancelled Jan 9, 1974 · Built 1949 · Shay James DN6623UMooney M20D · S/N 118Cancelled Nov 23, 1971 · Air South IncN4767YPiper PA-25-235 · S/N 25-4528Cancelled Jun 23, 1970 · Aerostate IncN97439Stinson 108 · S/N 108-439Cancelled May 21, 1960 · Lake County Air Club IncN8951KStinson 108-1 · S/N 108-1951Cancelled Feb 28, 1956 · Hal Hoover & Holland DBA Leesburg Aviation CenterN32178Waco UPF-7 · S/N 5810Cancelled Aug 21, 1952 · Burrell Robert WN34442Aeronca 65-CA · S/N 14671Cancelled Sep 13, 1948 · Hubert Ray LeveretteN7289Roe AVRO-AVIAN · S/N 141Cancelled Nov 15, 1939 · Farmer Albert JamesN21447Piper J-3 · S/N 2288Cancelled May 29, 1939 · Farner Albert James
Back to Leesburg, FL