Venice, FL

Cancelled registrations · 94

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

N831LCHawker Siddeley DH.125-1A/522 · S/N 25095Cancelled Mar 21, 2011 · Expired dealer · Built 1966 · Duncan Aircraft Sales Of Florida IncN925RAero Commander 1121 · S/N 80Cancelled Mar 18, 2011 · Expired dealer · Built 1966 · Duncan Aircraft Sales Of Florida IncN55NJLearjet 24 · S/N 162Cancelled Mar 17, 2011 · Expired dealer · Built 1968 · Duncan Aircraft Sales Of Florida IncN445Aero Commander 1121 · S/N 37Cancelled Mar 8, 2011 · Expired dealer · Built 1965 · Duncan Aircraft Sales Of Florida IncN2145DBeech D35 · S/N D3490Cancelled Nov 18, 2010 · Built 1953 · Kelly Francis LN25054Cessna 152 · S/N 15280518Cancelled Nov 4, 2010 · Exported to Brazil · Built 1977 · Florida Flight Training CenterN467TCPiper PA-34-200T · S/N 34-7870006Cancelled Sep 24, 2010 · Exported to Costa Rica · Built 1977 · Florida Flight Training Center IncN58736Cessna 182P · S/N 18262265Cancelled Apr 19, 2010 · Sale reported · Built 1973N316AFBeech 65-A90 · S/N LJ-214Cancelled Apr 8, 2010 · Built 1967 · Agape Flights IncN954PACessna 208B · S/N 208B-0556Cancelled Feb 9, 2010 · Triennial form not returned · Built 1996 · Agape Flights IncN2689XCessna P206A · S/N P206-0189Cancelled Apr 3, 2009 · Exported to Canada · Built 1965 · American Aircraft Sales International IncN94339Ercoupe 415-C · S/N 1562Cancelled Mar 27, 2009 · Built 1946 · Hudson Robert EN2213ZPiper PA-28-181 · S/N 287990405Cancelled Jun 12, 2007 · Mccormick Charles EN1712ZCessna 336 · S/N 336-0012Cancelled Dec 7, 2006 · Built 1963 · Hudson Robert EN8978Palmer BUSHBY MUSTANG II · S/N 413-1Cancelled Aug 3, 2006 · Triennial form not returned · Built 1996 · Palmer Frank JN212KRJones Steven W KR2 · S/N KR2FL2002Cancelled May 4, 2006 · Triennial form not returned · Built 2003 · Jones Steven WN460TCCessna 152 · S/N 15280144Cancelled Jan 17, 2006 · Triennial form not returned · Built 1977 · Florida Flight Training CenterN51SXVan Pelt Martin J PITTS S1S · S/N 001Cancelled Feb 4, 2005 · Triennial form not returned · Built 1999 · Van Pelt Martin JN93BABritish Aerospace JETSTREAM 3217 · S/N 923Cancelled Sep 28, 2004 · Exported to Philippines · Built 1991 · Triple Diamond Jet Center LLCN829JSBritish Aerospace BAE JETSTREAM 3101 · S/N 713Cancelled Dec 3, 2003 · Britannia Aviation Services IncN1002CBeech E18S · S/N BA-251Cancelled Jan 28, 2003 · Built 1957 · Eagle Point IncN427UEBritish Aerospace BAE JETSTREAM 3101 · S/N 811Cancelled Oct 10, 2002 · Exported to Guatemala · Built 1988 · Britannia Aviation Services IncN321GEGates Learjet 25D · S/N 289Cancelled Sep 19, 2002 · Exported to Mexico · Built 1979 · American Aircraft Sales International IncN474SWWilker Sidney J SILHOUETTE · S/N 230Cancelled Sep 25, 2001 · Wilker Sidney JN1239VCessna R172K · S/N R1722149Cancelled Oct 26, 1999 · Exported to Panama · Randy JaN2571ZBellanca 8KCAB · S/N 347-77Cancelled Mar 13, 1999 · Triennial form not returned · Built 1977 · Segalla Stanley JN2827VCessna R172K · S/N R1722231Cancelled Jun 19, 1998 · Sale reportedN6524CAerostar International RAVEN S57-A · S/N S57A3003Cancelled Nov 8, 1997 · Triennial form not returned · Prindiville ThomasN77FMRaven S55A · S/N S55A616Cancelled Oct 28, 1997 · Triennial form not returned · Prindiville ThomasN5130FCessna 172F · S/N 17252881Cancelled Sep 20, 1997 · Mcclelland Raymond AN888HAPiper PA-28-140 · S/N 287125440Cancelled Dec 4, 1996 · Triennial form not returned · Huffman Aviation IncN86RMNorth American NA-265-60 · S/N 30689Cancelled Jul 25, 1994 · Exported to Mexico · Duncan Aircraft SalesN109HACessna 150M · S/N 15077570Cancelled Jun 9, 1993 · Triennial form not returned · Huffman Aviation IncN9669VCessna 172M · S/N 17264449Cancelled Dec 21, 1992 · Exported to Germany · Machold Winfried WN3447GCessna 310R · S/N 310R0836Cancelled Aug 1, 1984 · Administratively canceled · Wings Of Venice IncN8330BPiper PA-28-161 · S/N 28-8116138Cancelled Jul 11, 1984 · Administratively canceled · Venice Flying Service IncN5093GCessna 172N · S/N 17273542Cancelled May 20, 1983 · Ingram'S Air Service IncN5557LRaven Industries RX6 · S/N RX6345Cancelled Jun 15, 1981 · Exported to Canada · Miller J Fred III DBA Cirrus AirN199BPPiper PA-23-250 · S/N 27-3774Cancelled Oct 26, 1979 · Exported to Bolivia · Venice Flying Service IncN42294Cessna 172M · S/N 17264169Cancelled Mar 13, 1975 · Built 1974 · Venice Flying Service IncN9079BChampion 7FC · S/N 7FC-163Cancelled May 17, 1974 · Miller Frank LN914JLBeech S35 · S/N D-7419Cancelled Jun 16, 1971 · Built 1964 · Larkin John JN1293KLuscombe 8A · S/N 4020Cancelled Jun 5, 1970 · Built 1946 · Pullen Donald EN32296Stinson 10A · S/N 7944Cancelled Apr 26, 1960 · Fette Vincent
Back to Venice, FL