Skip to content

Cancelled registrations · 50

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

N587FLPiper PA-28-140 · S/N 28-7125446Cancelled Dec 19, 2024 · Built 1971 · Florida Keys Flight Academy LLC N9231EAeronca 11AC · S/N 11AC-865Cancelled Dec 14, 2024 · Florida Keys Flight Academy LLC N131RTPolaris Motors FIB-582 · S/N 0331076Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 2003 · Tilman Robert B N103SNRidge Lowell H LIGHTNING · S/N 103Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 2012 · Cirrito Thomas J N541JFDJI Innovations PHANTOM 2 VISION + · S/N PH645439941Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Florida Keys Mosquito Control District N541UHDJI Innovations PHANTOM 2 VISION + · S/N PH645420433Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Florida Keys Mosquito Control District N8622HCessna 172C · S/N 17249267Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1962 · Fly Mth Inc N413DBeech 95-B55 (T42A) · S/N TC-1726Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1974 · Tropical Isle Resort Inc N139JFFessenden Jeff A SEATURA · S/N JF 101Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 2012 · Mikles Ken D N3972DCessna 182A · S/N 34672Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1957 · Herzhauser Ludwig W N6564XCessna 210 · S/N 57564Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1960 · Bfi America Inc N3749APiper PA-22-135 · S/N 22-1992Cancelled Nov 18, 2017 · Revoked, canceled · Built 1954 · Riley William E N89675Cessna 140 · S/N 8723Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Daniels Randolph N100UUCessna 150 · S/N 15078712Cancelled Aug 8, 2016 · Third renewal notice · Fatzinger James C N3527WPiper PA-32-260 · S/N 32-413Cancelled Mar 21, 2016 · First renewal notice · Built 1966 · Air Toy LLC N333RKMitsubishi MU-2B-26A · S/N 380SACancelled Dec 8, 2015 · Built 1978 · Sdc Equipment Inc N444WJDassault-Breguet FALCON 10 · S/N 64Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1975 · Worldwide Charters LLC N73268Bell 47J-2A · S/N 1871Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1962 · Dingman Allison DBA N64110Cessna 172M · S/N 17265026Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1975 · Daniels Wade N6751FCessna 150F · S/N 15063351Cancelled Sep 26, 2013 · Revoked, canceled · Built 1966 · Hubbard Robert E N3352EAeronca 11AC · S/N 11AC-1684Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1947 · Johnson Jon P N7626NBeech 65-B80 · S/N LD-399Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1968 · Rce Air Inc N7335ECessna 210 · S/N 57035Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · Bibbs James E N61730Cessna 172M · S/N 17264758Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1975 · Allen Charles B N6614FCessna 150F · S/N 15063214Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1966 N260XXChristen Industries PITTS S-2B · S/N 5116Cancelled Nov 27, 2012 · Exported to Turkey · Built 1986 · Conch Air Corp N151SBAero Vodochody L39C · S/N 83 11 05Cancelled Aug 27, 2012 · Registration pending, canceled · Built 1983 N9056Enstrom F-28A · S/N 167Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1973 · All Air Corporation N1392UCessna 172M · S/N 17267063Cancelled Jun 27, 2012 · Registration expired, pending cancellation · Built 1976 · Zieg Nancy A N800RBBeech K35 · S/N D-5972Cancelled Nov 15, 2010 · Sale reported · Built 1959 N632WEurocopter EC120B · S/N 1467Cancelled Nov 30, 2009 · Exported to Canada · Built 2006 · Fw Enterprise Inc N801VCPiper PA-32-260 · S/N 32-674Cancelled Feb 13, 2008 · Triennial form not returned · Built 1966 · R A R Aircraft Inc N3800GCessna U206B · S/N U206-0800Cancelled Apr 10, 2006 · Triennial form not returned · Built 1967 · Collins Carol J DBA N418UEBritish Aerospace BAE JETSTREAM 3101 · S/N 780Cancelled Feb 24, 2006 · Exported to Dominican Republic · Built 1987 · Sum Air Services Inc N7742YPiper PA-30 · S/N 30-832Cancelled Dec 6, 2005 · Triennial form not returned · Built 1965 · Plett John V N2145LPiper PA-28-181 · S/N 28-7990258Cancelled Dec 2, 2005 · Triennial form not returned · Built 1978 · Black And Waldorf Inc N4520XPiper PA-28-140 · S/N 28-7625048Cancelled Nov 30, 2005 · Triennial form not returned · Built 1975 · Cameron Lyle W N734SPCessna 172N · S/N 17269079Cancelled Dec 4, 2002 · Triennial form not returned · Built 1977 · Paradise Aviation Inc N55VXCessna 210-5A(205A) · S/N 205-0237Cancelled Feb 27, 2002 · Triennial form not returned · Built 1963 · A1 Used Car Rental Inc N36FDCessna 172N · S/N 17273218Cancelled Dec 6, 1999 · Exported to Canada · Grantair Services Inc N6916GCessna 150L · S/N 15072416Cancelled Jan 28, 1991 · Triennial form not returned · D Aiuto Joseph N3220JCessna 150G · S/N 15065920Cancelled Jan 17, 1991 · Blue Max Inc N5143VCessna 172RG · S/N 172RG0454Cancelled Jul 17, 1984 · Built 1980 · Richardson Michael H N22247Cessna 150H · S/N 15068165Cancelled Mar 27, 1984 · Administratively canceled · Baker Stanley W N1562SBeech P35 · S/N D-6992Cancelled Jul 20, 1971 · Mercier Ray N4010DCessna 182 · S/N 34710Cancelled Oct 28, 1970 · Dr Gaines Const Co Inc N2965DCessna 170B · S/N 26908Cancelled Jun 30, 1970 · Cornell Henry R N7523CForney F-1 · S/N 5638Cancelled May 20, 1965 · Bishop George T N84201Aeronca 7AC · S/N 7AC-2892Cancelled Jul 15, 1961 · Loren C Troup N4445VBeech 35 · S/N D 1254Cancelled Jun 23, 1958 · Hanley Thomas E

Back to Marathon, FL