Skip to content

Tarpon Springs, FL

Cancelled registrations · 40

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 = 'TARPON SPRINGS' 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 = 'TARPON SPRINGS'
  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 = 'TARPON SPRINGS'
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.

N43FLPudela Paul J EXEC 162F · S/N 6237Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1998 · Pudela Paul J N7182PHoffman Edward C X5 · S/N 1Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1991 · Hoffman Edward C N9634CPiper PA-32-300 · S/N 32-7840108Cancelled Feb 20, 2015 · Exported to Bolivia · Built 1978 · Rapozo Martin Yerko DBA N717BSCessna TU206G · S/N U206-04794Cancelled Feb 9, 2015 · Exported to Bolivia · Rapozo Martin Y DBA N65359Advanced CARRERA · S/N CRIA 004-11ALPHALLCancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1992 · Kostoff Paul S N9624RCessna TU206G · S/N U20606907Cancelled Nov 14, 2014 · Exported to Bolivia · Built 1985 · Rapozo Martin Yerko DBA N252ALCessna U206G · S/N U20603612Cancelled Aug 28, 2014 · Exported to Bolivia · Built 1976 N211CACessna 172I · S/N 17256543Cancelled Jul 8, 2014 · Exported to Bolivia N4571KCessna U206A · S/N U2060464Cancelled Jul 1, 2014 · Exported to Bolivia · Built 1965 N9973MCessna 207A · S/N 20700771Cancelled Apr 29, 2014 · Exported to Bolivia · Built 1984 N2291ZGeneral Dynamics 240-27 · S/N 355Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Western Supply Corp N9497RCessna U206G · S/N U20606876Cancelled Sep 17, 2013 · Exported to Bolivia · Built 1985 · Rapozo Export N1319JRockwell International 112A · S/N 319Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1975 · Porter Edwin E N734JMCessna U206G · S/N U20604839Cancelled Jul 26, 2013 · Exported to Bolivia · Built 1979 N4630FCessna TP206A · S/N P206-0230Cancelled Jul 18, 2013 · Exported to Bolivia · Built 1966 N4676XCessna U206G · S/N U20605520Cancelled Jul 12, 2013 · Exported to Bolivia · Built 1980 · Rapozo Martin DBA N60981Cessna U206F · S/N U20602059Cancelled Jul 3, 2013 · Exported to Bolivia · Built 1973 · Rapozo Martin Y DBA N10EKVan Der Kaay Erik K MARCO J5 · S/N 0135Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Van Der Kaay Erik K N758FQCessna R172K · S/N R1723064Cancelled Jul 1, 2013 · Exported to Bolivia · Built 1978 N729RVCessna U206D · S/N U206-1283Cancelled Jun 27, 2013 · Exported to Bolivia · Built 1969 · Rapozo Martin Y DBA N8235MCessna 210K · S/N 21059235Cancelled Feb 22, 2013 · Exported to Bolivia · Built 1969 · Rapozo Martin Y DBA N638SPCessna 172S · S/N 172S8046Cancelled Dec 26, 2012 · Exported to Bolivia · Built 1998 · Rapozo Martin Yerko DBA N8755ZCessna P206D · S/N P206-0555Cancelled Dec 26, 2012 · Exported to Bolivia · Built 1968 · Rapozo Martin Y N3721YCessna 210D · S/N 21058221Cancelled Dec 4, 2012 · Exported to Bolivia · Built 1963 · Rapozo Martin Y DBA N1196QCessna T210L · S/N 21059696Cancelled Oct 16, 2012 · Exported to Bolivia · Built 1972 · Rapozo Martin Y DBA N4780UCessna U206G · S/N U20605098Cancelled Sep 4, 2012 · Exported to Bolivia · Built 1979 · Rapozo Martin Y DBA N2503XCessna P206 · S/N P206-0003Cancelled Jun 11, 2012 · Exported to Bolivia · Built 1964 · Rapozo Martin Y DBA N9508LCessna 172P · S/N 17276567Cancelled Nov 15, 2011 · Exported to Bolivia · Built 1986 · Rapozo Martin Y N10535Ryan Aeronautical STM · S/N 304Cancelled Jun 25, 2009 · Registration revoked · Webb Robert N75703Cessna 207A · S/N 20700639Cancelled Dec 1, 2008 · Exported to Bolivia · Built 1980 · Rapozo Christine M N73463Cessna 207A · S/N 20700593Cancelled Aug 15, 2008 · Exported to Bolivia · Built 1980 N52581Cessna 182P · S/N 18262687Cancelled Aug 14, 2008 · Exported to Bolivia · Built 1973 N3070ECessna 172N · S/N 17271427Cancelled Jun 12, 2008 · Exported to Bolivia · Built 1978 N357RBCessna 210 · S/N 21061815Cancelled Jan 18, 2007 · Exported to Bolivia · Rapozo Martin Y N7075TPalmer John E JEP 1 · S/N JEP 1Cancelled Apr 11, 2006 · Palmer John E N2645UCessna 172D · S/N 17250245Cancelled Jul 9, 1999 · Banks G Paul N1040ABeech 65-B80 · S/N LD427Cancelled May 21, 1991 · Triennial form not returned · Nicholis Theophilos E M N1736Hoffman X-2 M · S/N 2Cancelled Apr 15, 1982 · Administratively canceled · Hoffman Edward C N6519CDouglas DC-6B · S/N 43519Cancelled Mar 10, 1975 · Exported to Colombia · Tsalickis Mike N4663NBoeing B75N1 · S/N 75-7873Cancelled Feb 15, 1956 · Boyer F L Jr

Back to Tarpon Springs, FL