Skip to content

Cancelled registrations · 257

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

N70PGCessna TU206G · S/N U20604545Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1978 · Naples Aircraft Leasing Inc N68581Nelson PG-185-B · S/N 81Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1955 · Nelson Aircraft Corp N5650ZPiper PA-22-108 · S/N 22-9473Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1962 · Howard William Cary N3293TCessna 177 · S/N 17700593Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1967 · Paradis Victor J N9966SGulfstream AM Corp Comm Div 695A · S/N 96046Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1982 N846MBDouglas DC3C 1830-94 · S/N 33305Cancelled Mar 7, 2013 · Sale reported, canceled N554RGGillespie Richard L GN-1 AIRCAMPER · S/N 2554Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 2003 · Busse J Robert N368PBPiper PA-32-300 · S/N 32-40440Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1968 · Provincetown Boston Airline Inc N23013Cessna 150H · S/N 15068677Cancelled Oct 31, 2012 · Exported to Brazil · Built 1968 · Johansen Morten A N2801QJamieson J-2-L1B · S/N 3Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1963 · Hilmer R S N28BHelio H-391B · S/N 005Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1955 · Stucker William L N2898PPiper PA-18-150 · S/N 18-4496Cancelled Sep 12, 2012 · Revoked, canceled · Built 1955 · Hogan Douglas J N2417ZPiccard AX-6 · S/N 417Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1977 · Kurtz Ronald J N2442DPiper PA-38-112 · S/N 38-79A0318Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1978 · Arthur Todd A N19MELivin-Piel Emeraude CP-305 · S/N 1274Cancelled Sep 4, 2012 · Sale reported, pending cancellation · Built 1970 N2EHHarmes VJ-22 SPORTSMAN · S/N 1Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1975 · Galloway John E N250PPCessna 310F · S/N 310-0093Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1961 N52721Beech C18S · S/N 6647Cancelled Aug 14, 2012 · Revoked, canceled · Built 1945 · Brown Joseph L N4412WSorrels Thomas C QCKSLVR MXL II SPORT · S/N 349Cancelled Aug 6, 2012 · Registration pending, canceled · Built 1992 N824CPBeech 95-C55 · S/N TE-129Cancelled Jul 16, 2012 · Exported to Belize · Built 1966 N22GSPiper PA-23 · S/N 23-1098Cancelled May 18, 2012 · Exported to Bolivia · Built 1957 N241FRCanadair CL-600-2B16 · S/N 5102Cancelled May 18, 2012 · Exported to Saudi Arabia · Built 1992 · Gopman Jonathan E Trustee N532FAAerospatiale ATR42-500 · S/N 532Cancelled Feb 16, 2012 · Exported to Colombia · Business Aviation Services Inc N320CPCessna 172S · S/N 172S10249Cancelled Dec 27, 2011 · Exported to French Guiana · Built 2006 · Cp LLC N3508WPiper PA-32-260 · S/N 32-389Cancelled Jul 5, 2011 · Revoked, canceled · Built 1966 · Hatcher Jack F N69GBDassault-Breguet FALCON 10 · S/N 24Cancelled Jun 7, 2011 · Built 1974 · Arnold & Arnold Ral Estate Inc N440BCHawker Siddeley DH.125-400A · S/N NA744Cancelled Apr 12, 2011 · Sale reported · Built 1970 N100DLLearjet 24B · S/N 201Cancelled Mar 3, 2011 · First renewal notice · Ajm Airplane Company N7535FRobinson Helicopter R44 II · S/N 10459Cancelled Feb 22, 2011 · Built 2004 · Jaj Investments Ltd N6XNCessna 208B · S/N 208B1069Cancelled Feb 16, 2011 · Exported to Argentina · Built 2004 · East West Aircraft Sales Inc N80MBeech F90 · S/N LA-150Cancelled Nov 22, 2010 · Exported to Brazil · Built 1981 · Ghk Aviation LLC N295CPBell 407 · S/N 53606Cancelled Nov 16, 2010 · Exported to Turkey · Built 2004 · Jet 1 Charter Inc N832SACessna 208B · S/N 208B0832Cancelled Nov 12, 2010 · Exported to New Zealand · Built 2000 · Eastwest Aircraft Sales Inc N385FAAerospatiale ATR 72-212 · S/N 385Cancelled Oct 19, 2010 · Exported to Bangladesh · Built 1993 · Business Aviation Services Inc N5EVVan Dyke Henry CAVALIER · S/N 69-128Cancelled Sep 14, 2010 · Keil Richard E N83LJLearjet 23 · S/N 23-076Cancelled Aug 24, 2010 · Second triennial mailing, no response · Built 1965 · Ajm Airplane Co N1869SSmitrovich John W SE5A REPLICA · S/N 078258Cancelled Jun 2, 2010 · Exported to Canada · Built 1984 · Smitrovich John W N412BZCessna 208B · S/N 208B-1111Cancelled Apr 26, 2010 · Exported to Suriname · Eastwest Aircraft Sales Inc N379FAAerospatiale ATR 72-212 · S/N 379Cancelled Mar 15, 2010 · Exported to Indonesia · Business Aviation Services Inc N704ABoeing 727-173C · S/N 19504Cancelled Mar 5, 2010 · Triennial form undeliverable · Built 1967 · Clark Aviation Holdings LLC N609SRCirrus Design SR22 · S/N 2098Cancelled Jan 22, 2010 · Built 2006 · Cirrus Aviation Leasing One LLC N9594LCessna 172P · S/N 17276587Cancelled Sep 22, 2009 · Built 1986 · Lorenzo Walker Institute Of Technology N165TCCessna 208 · S/N 20800183Cancelled Jul 27, 2009 · Exported to New Zealand · Built 1990 · Carols Planes Inc N172ANCessna 172N · S/N 17272419Cancelled Mar 17, 2009 · Exported to Italy · Ruberto Roberto N651ARCessna 650 · S/N 650-0212Cancelled Feb 17, 2009 · Exported to Germany · Built 1992 · Business Aviation Services Inc N793ABoeing 727-227 · S/N 20774Cancelled Nov 20, 2008 · Triennial form not returned · Built 1973 · Clark Aviation Holdings LLC N625PACessna 152 · S/N 15280529Cancelled Oct 31, 2008 · Exported to Bolivia · Built 1977 · Naples Air Center Inc N367CJCessna 525A · S/N 525A0367Cancelled Jul 29, 2008 · Exported to Germany · Built 2007 · Jet 1 Charter Inc N601GFetzer George R CH 601 HDS · S/N 6-3340Cancelled Jul 9, 2008 · Triennial form not returned · Built 2001 · Fetzer George R N5557CApollo North America RACER GT AS-1 · S/N USA 21-02Cancelled Jun 30, 2008 · Exported to Mexico · Built 2007 · Ebrahim Tariq

Back to Naples, FL