Skip to content

Cancelled registrations · 28

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

N760FPHorizon Hobby BLADE CHROMA · S/N 7556Cancelled Nov 13, 2019 · Third renewal notice · Puto Jerauld N666APDJI PHANTOM 3 PROFESSION · S/N P76DCH25A26749Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Puto Jerauld N9877XCessna 185 · S/N 185-0077Cancelled Apr 22, 2019 · Revoked, canceled · Built 1961 · Miller Clifford C N93870Engineering & Research ERCOUPE 415-C · S/N 1193Cancelled Dec 20, 2018 · Registration expired, pending cancellation · Built 1946 · Carlson Kevin J N2624FCessna 182J · S/N 18256724Cancelled May 11, 2018 · First renewal notice · Built 1965 · Flightseeing LLC N565XAndrew Harold B GLASAIR · S/N 565Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1987 · Esy Corp N519WAero Commander 560-A · S/N 280Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1955 · Williams John D N66951Cessna 152 · S/N 15281686Cancelled Jul 24, 2017 · Exported to Canada · Built 1978 · Esy Corp N776FBPolaris Motors FIB-582 · S/N 0631193Cancelled Mar 23, 2016 · Exported to Paraguay · Built 2006 · Gilbert John M Jr N4694JPiper PA-28R-180 · S/N 28R-30597Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1968 · Fitzpatrick Brian N2564JCessna 150E · S/N 15061064Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1964 · Upper Keys Flying Club Inc N6119KRepublic RC-3 · S/N 305Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1947 N1263FBalloon Works FIREFLY 7 · S/N 189Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1974 · Schafer Charles H N211CLRutter Royce R 532 COMMANDER ELITE · S/N RRR-2Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1989 · Rutter Royce R N6371KRepublic RC-3 · S/N 600Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1947 · Ruzakowski Henry N485BBeech V35A · S/N D-8709Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1968 · Miller June M N2115XCessna 337 · S/N 337-0015Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1965 · Southcoast Development Inc N120BFSky King LANCAIR 4 · S/N 010Cancelled Jul 30, 2012 · Registration expired, pending cancellation · Sky King Aviation Inc N986SPCessna 172S · S/N 172S8191Cancelled Apr 4, 2011 · Exported to Germany · Built 1999 · Thompson David R N6150YPiper PA-23-250 · S/N 27-3367Cancelled Jul 12, 1999 · Triennial form not returned · Tailfeathers Inc N1787MCessna T337F · S/N 33701387Cancelled Nov 29, 1996 · Exported to Israel · Steamboat Springs Inc N410ASCessna T310R · S/N 310R0583Cancelled Sep 1, 1995 · Exported to Namibia · C & S Aircraft Inc N98894Cessna 310R · S/N 310R0637Cancelled Jun 19, 1995 · Exported to South Africa · C And S Aircraft Inc N6162JPiper PA-28-181 · S/N 287690357Cancelled Dec 28, 1994 · Triennial form not returned · Regan Robert Emmett N2224DPiper PA-28-161 · S/N 287916151Cancelled Jun 29, 1994 · Triennial form not returned · Schrader Christopher James N733RECessna 172N · S/N 17268483Cancelled Jul 24, 1991 · Exported to Denmark · Buckeye Aircraft Corp N11539Cessna 150L · S/N 15075501Cancelled Aug 6, 1984 · Administratively canceled · Carter Joy B N8704KStinson 108-1 · S/N 108-1704Cancelled Nov 20, 1970 · Built 1947 · Green John T

Back to Tavernier, FL