Stuart, FL

Cancelled registrations · 207

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

N604CBBombardier CL-600-2B16 · S/N 5526Cancelled Nov 25, 2008 · Exported to Italy · Built 2002 · East Coast Jet Center IncN9302CPiper PA-34-200T · S/N 34-7870180Cancelled Aug 26, 2008 · Exported to Brazil · Built 1978 · Jet Sales Of Stuart LLCN37012Luscombe 8A · S/N 1673Cancelled Aug 1, 2008 · Built 1941 · Treasure Coast Sport FlyersN8743CPiper PA-34-200T · S/N 34-7670152Cancelled Jun 24, 2008 · Exported to Costa Rica · Built 1976 · Breen Patrick GN4824TPiper PA-34-200 · S/N 34-7250154Cancelled May 28, 2008 · Exported to Philippines · Built 1972 · Clear Sky Air LLCN80KAHawker Beechcraft C90GTI · S/N LJ-1862Cancelled Apr 3, 2008 · Exported to Brazil · Built 2008 · East Coast Jet Center IncN507DMEmbraer EMB-120ER · S/N 120.118Cancelled Jan 28, 2008 · Exported to Brazil · Built 1989 · Jet Sales Of Stuart LLCN222YKYakovlev YAK-52S · S/N 877501Cancelled Oct 5, 2007 · Exported to Australia · Built 1989 · Ham Howard SN788JREmbraer EMB-120ER · S/N 120.095Cancelled May 14, 2007 · Exported to Nigeria · Built 1988 · Jetss LLCN302DWCessna 152 · S/N 15285453Cancelled Nov 27, 2006 · Exported to Poland · Built 1981 · Pratt Frederick WN691ACCessna 441 · S/N 4410250Cancelled Sep 20, 2006 · Exported to Venezuela · Built 1981 · Caams IncN729FRaytheon 58 · S/N TH-2020Cancelled Oct 20, 2005 · Exported to Brazil · Built 2001 · East Coast Jet Center IncN760VACessna 150L · S/N 15075098Cancelled Nov 18, 2004 · Exported to Nicaragua · International Flight Training AcademyN43LABeech F90 · S/N LA-168Cancelled Jun 17, 2004 · Exported to Mexico · Built 1981 · East Coast Jet Center IncN979NDCessna 182J · S/N 18257443Cancelled Dec 10, 2001 · Apex Aviation IncN381CABeech 65-B80 · S/N LD-381Cancelled Dec 14, 2000 · Exported to Venezuela · Park Avenue Group IncN330DRRaytheon B200 · S/N BB1578Cancelled Jun 13, 2000 · Exported to Brazil · East Coast Jet Center IncN1705WBeech 95-B55 (T42A) · S/N TC-1489Cancelled May 31, 2000 · Exported to Paraguay · Diversified Aircraft Sales IncN19LHGates Learjet 35A · S/N 279Cancelled Dec 22, 1998 · Orion Aircraft Sales IncN5799WAerospatiale AS 355F1 · S/N 5187Cancelled Sep 21, 1998 · Exported to Czech Republic · Skymarine Inc DBAN5793ZAerospatiale AS 355F1 · S/N 5142Cancelled Apr 9, 1998 · Exported to France · Skymarine Inc DBAN15GEEichhorn Gary L SONERAI II LS · S/N 0065LSCancelled Mar 11, 1998 · Triennial form not returned · Eichhorn Gary LN69025Cessna 152 · S/N 15282443Cancelled Jul 19, 1997 · Triennial form not returned · J R Leasing IncN5774MAerospatiale AS 355F1 · S/N 5009Cancelled May 14, 1997 · Exported to Germany · Skymarine Inc DBAN5782XS N I A S AS350D ASTAR · S/N 1421Cancelled Mar 19, 1997 · Exported to Canada · Skymarine Inc DBAN8043FBeech A36 · S/N E2706Cancelled Nov 2, 1994 · Exported to Brazil · Diversified Aircraft Sales IncN144THHahn Thomas C RV-4 · S/N 793Cancelled Jun 9, 1994 · Exported to Ireland · Kight Stephanie PN8504GPiper PA-31-310 · S/N 31478Cancelled Mar 3, 1994 · Exported to Netherlands · F P E IncN415BHughes Helicopters HUGHES 369D · S/N 911083DCancelled Jan 30, 1992 · R R Flight Services IncN5585UPiper PA-28-140 · S/N 2826315Cancelled May 15, 1991 · Exported to Portugal · Delgado Jose PauloN8461RPiper PA-28-161 · S/N 288216056Cancelled Feb 12, 1991 · Exported to United Kingdom · K Aero IncN704WACessna 150M · S/N 15078921Cancelled Dec 24, 1990 · Exported to United Kingdom · Treasure Coast Flight Academy IncN4777APiper PA-22-150 · S/N 223927Cancelled Apr 20, 1983 · Powell Sheryl LN8767GCessna 150F · S/N 15062867Cancelled Dec 17, 1981 · Flying Sailfish Club IncN3350WPiper PA-32-260 · S/N 32-192Cancelled Oct 13, 1981 · Bennetts Rent ItN17228Cessna 150L · S/N 15073678Cancelled Oct 31, 1977 · St Lucie Skyway IncN40941Piper PA-28-151 · S/N 28-7415114Cancelled Jul 7, 1977 · Built 1973 · Bennetts Rent-ItN72356Cessna 120 · S/N 9541Cancelled Jun 17, 1976 · Exported to Canada · Lee BrockN5025LLake LA-4-200 · S/N 482Cancelled Mar 27, 1975 · Built 1971 · Cardenas Alex BN8810TCessna 182C · S/N 52710Cancelled Jul 1, 1974 · St Lucie Skyways IncN9405Grumman SA-16 · S/N 9309Cancelled Mar 12, 1974 · Exported to Mexico · Grumman Aerospace CorpN2222UBrantly 305 · S/N 1032Cancelled Nov 21, 1972 · Dean Development Co IncN6212BAero Commander 680 · S/N 680-596-232Cancelled Oct 18, 1965 · Niagara Therapy Mfg CorpN4859DCessna 182A · S/N 34959Cancelled Jun 12, 1965 · St Lucie SkywaysN52114Convair BT-13A · S/N 268Cancelled May 24, 1965 · Clyde CoutantN1062MBeech AT-10GF · S/N 681Cancelled May 21, 1965 · Kreuger A PN1041BHiller YH32 · S/N 55-4972Cancelled Jan 7, 1960 · Burn-Brae IncN53489Cessna T-50 · S/N 4838Cancelled Nov 6, 1959 · Krueger A PN11111Cessna 170B · S/N 25167Cancelled Aug 14, 1959 · Exported to Finland · Built 1952 · Mosley ZackN66015Vultee BT-13 · S/N 9691Cancelled Mar 14, 1956 · Built 1943 · Perry Eugeng Ray
Back to Stuart, FL