Skip to content

Cancelled registrations · 65

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

N101RCPiper PA-31-310 · S/N 31-7300930Cancelled Dec 26, 2023 · Sale reported, canceled · Built 1972 N139LSAero Vodochody L39C · S/N 330202Cancelled Jun 22, 2023 · Built 1974 · Farnsworth Scott C N20518Cessna 172M · S/N 17261356Cancelled Jan 14, 2023 · Registration expired, pending cancellation · Built 1973 · Chukkar Hill Corp N62670Piper PA-23-250 · S/N 27-7654132Cancelled Dec 24, 2022 · Registration expired, pending cancellation · Built 1976 · Scheff Michael J N2960KLuscombe 8E · S/N 5687Cancelled May 25, 2022 · Registration pending, canceled · Built 1947 N1359QKurz Irving F RV-3 · S/N 3289Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Hogan Mark C N636WMDJI PHANTOM 3 PROFESSION · S/N P76DCE8010955Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Skynet Aerial Media N456EZPipistrel SINUS 912 · S/N 183SN9121005KIT49Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 2005 · Sinus LLC N993JRRaytheon HAWKER 800XP · S/N 258464Cancelled Jun 28, 2021 · Exported to Nigeria · Built 2000 · Jmd Leasing Inc N465PDRockwell International NA-265-65 · S/N 465-37Cancelled Mar 1, 2021 · Exported to Mexico · Built 1980 · Spyglass Air LLC N467LPipistrel SINUS 912 · S/N 213S9121106KIT49Cancelled May 8, 2020 · First renewal notice · Built 2006 · Pelican Soaring LLC N46614Fairchild 24W-41A · S/N W41A252Cancelled Oct 17, 2019 · Exported to United Kingdom · Built 1941 · Armbrust John W N275RBBritish Aerospace BAE 125 SERIES 800A · S/N 258096Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1987 · Jet I LLC N240SJBell 206B · S/N 2354Cancelled Mar 6, 2018 · Exported to Ecuador · Built 1978 · Agricultural Air Services LLC N21JNNewman HOMEBUILT · S/N 52Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Newman James O N7443PPiper PA-24 · S/N 24-2632Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1961 · Smith Andrew G III N205ZMooney M20J · S/N 24-3024Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Short Donald W N930RMCap CAP 232 · S/N 27Cancelled Jun 1, 2017 · Exported to Canada · Built 2000 · Mechanical Artistry LLC N7079JRobinson Helicopter R22 BETA · S/N 2282Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1993 · Blue Hole Helicopters N149LCCub 149 PA-12 REPLICA · S/N TC0604102Cancelled Apr 5, 2017 · Registration expired, pending cancellation · Cub 149 LLC N155ZSCirrus Design SR22 · S/N 3165Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 2008 · Stan Leigh Investments LLC N6142JHajek D/Bogue D ESPRIT · S/N DD-1Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 2001 · Esprit Aircraft Inc N1739GBeech 95-A55 · S/N TC-291Cancelled Apr 25, 2016 · First renewal notice · Built 1962 · Kings Wings Inc N100MXVan Alphen Hans KOLB MARK III EXTRA · S/N M3X 003 00014Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 2002 · Alphen Hans Van N597AWAirbus Industrie A321-131 · S/N 597Cancelled Oct 2, 2014 · Highland 597 LLC N6512YLancair LC42-550FG · S/N 42016Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 2003 · Global Governments Inc N64070Frick William BAKENG DUCE · S/N 1999Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1999 · Golightly Rick N729LCessna U206G · S/N U20606151Cancelled Aug 15, 2014 · Exported to Canada · Patriot Aviation Inc N226XSukhoi SU-26 · S/N 06-08Cancelled Jun 9, 2014 · Exported to Canada · Precision Aircraft Inc N3910WPiper PA-32-260 · S/N 32-856Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1967 · Deal Scott A P N125TRBrown Scott A F-1 · S/N YF0001Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Brown Scott A N4711GKorzep Edward BUMBLE BEE 500 · S/N 6419542BCancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1990 · Kirby Thomas F N9235NMaule MX-7-160 · S/N 19004CCancelled Aug 22, 2013 · Sale reported, canceled N3782APiper PA-22-135 · S/N 22-2024Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1953 · Tefft Thurman N364UABoeing 737-322 · S/N 24533Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1989 N6174XCessna 310R · S/N 310R1312Cancelled Aug 6, 2013 · Exported to Venezuela · Built 1978 · South Florida Aircraft Sales Inc N186KGPiper PA-28-180 · S/N 28-3158Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1966 · Dhooge Charles T N365UABoeing 737-322 · S/N 24534Cancelled Jun 4, 2013 · Sale reported, canceled · Built 1989 N7401VMooney M20F · S/N 22-1194Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1975 · Lindberg Jeffrey D N471HPRD Barn LANCAIR IV P · S/N LIV-474PCancelled Jan 11, 2013 · Dbl Inc N86648Grumman G-44A · S/N 1469Cancelled Aug 14, 2012 · Registration pending, canceled N632ACCessna U206 · S/N U206-05939Cancelled May 9, 2012 · Exported to Paraguay · P & C Leasing LLC N3387EAeronca 11AC · S/N 11AC-1713Cancelled Feb 16, 2012 · Built 1947 · Brower Charles E N16728Bell 206L · S/N 45073Cancelled Jun 15, 2011 · Exported to Canada · Patriot Aviation Inc N985MCCessna 182T · S/N 18281344Cancelled May 20, 2011 · Exported to Canada · Built 2004 · Ocean Key Aviation LLC N5227KPiper PA-34-220T · S/N 3449205Cancelled Dec 23, 2009 · Exported to Malaysia · Built 2001 · Wings LLC N2805TPiper PA-28-140 · S/N 28-7225236Cancelled Nov 19, 2009 · Exported to Mexico · Built 1972 · Henley Enterprises Inc N488SDPohl Douglas A LANCAIR IV-P · S/N LIV-008Cancelled Mar 12, 2009 · Triennial form not returned · Built 2000 · Pohl Douglas A N444EZFehling Jack G VARIEZE · S/N 446Cancelled Jul 29, 2008 · Exported to Argentina · Fehling Jack G N554FSSheldon Richard F AVENTURA II · S/N AP2A0031Cancelled Apr 29, 2008 · Built 2006 · Sheldon Richard F

Back to Jupiter, FL