OpenAirDocs.org
Key Biscayne, FL

Cancelled registrations · 31

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 = 'KEY BISCAYNE'
  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.

N99BFPiper PA-28R-201T · S/N 28R-7803329Cancelled Aug 3, 2022 · Registration expired, pending cancellation · Lazuri IncN365KBDJI PHANTOM 3 PROFESSION · S/N P76DCF16017246Cancelled Dec 15, 2021 · Registration expired, pending cancellation · Village Of Key BiscayneN21916Firefly Balloons FIREFLY 8B-15 · S/N F8B-2048Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2004 · Wilson Oscar Alfredo QuinteroN8483Piper PA-22-108 · S/N 22-9526Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Stickney Thomas JN1536UBalloon Works FIREFLY 7-B · S/N 10258Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1981 · Quintero OscarN222FHBell 206B · S/N 903Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1977 · Foster C TomN75830Cessna 172N · S/N 17267986Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1976 · Riggs Charles AN41519Piper PA-32-300 · S/N 32-7440095Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1974 · Vilanova SalvadorN477RCRockwell International 500-S · S/N 3095Cancelled May 20, 2013 · Exported to Panama · Callaway JenniferN734BMCessna 172N · S/N 17268726Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · 734 Bm IncN5306ZPiper PA-22-108 · S/N 22-9009Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1961 · Stickney Thomas JN48DBeech 65-A80 · S/N LD-196Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1964 · Goldcoast Aircraft IncN2864BBell 47J · S/N 1435Cancelled Sep 18, 2009 · Registration revoked · Built 1957 · Foster C TomN15982Bell 47J · S/N 1598Cancelled Jun 30, 2009 · Registration revoked · Built 1956 · Foster C TomN111FHBell 206B · S/N 2023Cancelled Jun 26, 2009 · Registration revoked · Built 1976 · Foster C TomN1120KBell 47G-2 · S/N F-001Cancelled Jun 25, 2009 · Registration revoked · Built 1952 · Foster C TomN5441SCessna 337B · S/N 337-0541Cancelled Mar 3, 2009 · Exported to Italy · Built 1966 · Atlantic Med CorpN601RGPiper AEROSTAR 601P · S/N 61P08028063413Cancelled Aug 7, 2007 · Exported to Guatemala · Built 1980 · Cybsa CorporationN8388TPiper PA-34-220T · S/N 348133100Cancelled May 16, 1997 · Exported to Ecuador · Rosales Xavier FN9700FCessna 172R · S/N 17280012Cancelled May 15, 1997 · Exported to Ecuador · Bancon IncN134KMPiper PA-42 · S/N 427801003Cancelled Oct 20, 1995 · Exported to Peru · Damason IncN183CCPiper PA-42 · S/N 428001067Cancelled Oct 12, 1995 · Exported to Peru · Damason IncN145CAPiper PA-42 · S/N 428001022Cancelled Oct 10, 1995 · Exported to Peru · Damason IncN3792ES N I A S AS350D ASTAR · S/N 1209Cancelled Jul 19, 1994 · Triennial form not returned · Nafilylan Investments IncN4680PCessna 152 · S/N 15284799Cancelled Jan 22, 1993 · Exported to Germany · American Aircraft IncN6915RPiper PA-28-181 · S/N 288590057Cancelled Jan 15, 1993 · Exported to Germany · American Aircraft IncN2461PPiper PA-38-112 · S/N 3879A1034Cancelled Feb 13, 1991 · Exported to Mexico · American Aircraft IncN25669Douglas DC3 · S/N 2242Cancelled Aug 11, 1983 · Exported to Colombia · Bahamas Poultry TransportN42677Cessna 180J · S/N 18052369Cancelled May 18, 1978 · Exported to Canada · Built 1973 · Jordan G WN2375Lockheed 18-56 · S/N 2455Cancelled May 17, 1974 · Air Caribbean IncN5182ACessna 172 · S/N 28182Cancelled Apr 16, 1970 · Exported to Canada · Wright William J
Back to Key Biscayne, FL