Skip to content

Saint Augustine, FL

Cancelled registrations · 60

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 = 'SAINT AUGUSTINE' 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 = 'SAINT AUGUSTINE'
  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 = 'SAINT AUGUSTINE'
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.

N5708FPiper PA-28-140 · S/N 28-24837Cancelled Aug 17, 2026 · Exported to South Africa · Built 1968 · N5708f LLC N1063MLeading Edge Aerial Tech PV40X · S/N 11420Cancelled Jul 13, 2026 · Registration pending, canceled N324DWLeading Edge Aerial Tech PV35X · S/N 11159Cancelled Jul 4, 2026 · Registration pending, canceled N3987TAlexa Alex OSPREY 2 · S/N 369Cancelled Nov 9, 2024 · Sale reported, canceled · Built 1989 N39855Bellanca 17-30A · S/N 73-30509Cancelled Jun 5, 2024 · Sale reported · Built 1972 N224DSSims David L RV 6A · S/N 22449Cancelled May 25, 2024 · Registration pending, canceled · Built 1998 N302NGExtra Aerobatic EXTRA NG · S/N NG002Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Southeast Aero Sales Inc N208DPDJI PHANTOM 3 PROFESSION · S/N P76DCJ12A20177Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Big Blue Aerial Photography N5300EBeech K35 · S/N D-5765Cancelled Sep 9, 2022 · Registration expired · Built 1958 · St Augustine Beech LLC N951ERCessna 152 · S/N 15282854Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1978 · Florida Flyers Flight Academy Inc N12333Avery Norman S EXPRESS SRS 2000RG · S/N 200004-MCancelled May 7, 2022 · Registration expired, pending cancellation · Avery Norman S Trustee N540HBHeisler Martin HARMON ROCKET II · S/N 30Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Bh Enterprises LLC N757RWCessna 152 · S/N 15279953Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1977 · Florida Aviation Career Training Inc N2821EChampion 7AC · S/N 7AC-6404Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1946 · Little Champ LLC N662AMAircraft Mfg & Development CH 2000 · S/N 20-1020Cancelled Aug 12, 2021 · Built 2003 · Barefoot Aircraft LLC N9721SSmallwood Allan B JUNKSTER II · S/N 0001Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2010 · Smallwood Allan B N519PBell OH-58A · S/N 73-21899Cancelled Oct 31, 2020 · Registration expired, pending cancellation · St Johns County Sheriffs Office N5549PPiper PA-24-250 · S/N 24-613Cancelled Feb 12, 2020 · First renewal notice · Built 1958 · Avante Associates Inc N6012MBeech 76 · S/N ME-104Cancelled Dec 20, 2019 · Sale reported, canceled · Built 1978 N7687HRobinson Helicopter R22 BETA · S/N 4370Cancelled Nov 26, 2019 · Exported to Mexico · Built 2008 · Old City Helicopter Sales LLC N9431NPiper PA-28R-200 · S/N 28R-35144Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1969 · Martin Robert S N57SLDJI INSPIRE 1 PRO · S/N W21AC127011911Cancelled Apr 30, 2019 · Registration expired, pending cancellation · Skylens LLC N848AKRobinson Helicopter R22 BETA · S/N 3681Cancelled Oct 1, 2018 · Exported to South Africa · Old City Helicopter Sales LLC N516PBell OH-58C · S/N 68-16900Cancelled Mar 14, 2018 · Registration expired, pending cancellation · St Johns County Sheriffs Office N2500Beech D18S · S/N A-558Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1951 · Barnum James P N308PJCirrus Design SR22 · S/N 2628Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 2007 · Gandy Air LLC N1514HLindstrand Balloons 90A · S/N 5402Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 2008 · Legacy Aerial Promotions LLC N260MESiai-Marchetti F.260 · S/N 117Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1968 · Van Waeyenberghe Bruno N475ASPiaggio P-149D · S/N 300Cancelled Sep 6, 2016 · Third renewal notice · Flightops N104FWFocke-Wulf FWP 149D · S/N 104Cancelled Aug 30, 2016 · Third renewal notice · Flightops Inc N5016MBell 206B · S/N 2636Cancelled Jun 14, 2016 · Third renewal notice · Abraham Holdings LLC N54770Piper PA-23-250 · S/N 27-7554078Cancelled Feb 22, 2016 · Exported to Bahamas · Built 1975 · Sandwood Aircraft Holdings Corp N4105VCessna 170 · S/N 18437Cancelled Sep 8, 2014 · Expired dealer · Built 1948 · Buchanan Mary DBA N5221PPiper PA-24-250 · S/N 24-248Cancelled Sep 8, 2014 · Expired dealer · Built 1958 · Buchanan Mary DBA N2153WBeech C23 · S/N M-1535Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1974 N4549WBell 206B · S/N 191Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1967 · Highway 66 Aviation LLC N1820YCessna 172C · S/N 17249420Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1962 · Sharpe Frank L N2404JSproch Arthur Kenneth SPECIAL · S/N 252Cancelled Dec 13, 2012 · Registration pending, canceled N6450ECessna 172 · S/N 46550Cancelled Oct 24, 2012 · Exported to Canada · Built 1959 · Thompson Jack R N388NDehavilland BEAVER DHC-2 MK.3 · S/N 1642TB23Cancelled Oct 3, 2012 · Exported to Canada · Built 1966 · Abraham Holdings LLC N45241Robinson Helicopter R44 · S/N 2162Cancelled Nov 29, 2011 · Exported to Canada · Old City Helicopter Sales LLC N4470BRobinson Helicopter R44 · S/N 2122Cancelled May 10, 2011 · Exported to Canada · Old City Helicopter Sales LLC N44977Robinson Helicopter R44 · S/N 2093Cancelled Nov 8, 2010 · Exported to Canada · Built 2010 · Old City Helicopter Sales LLC N44934Robinson Helicopter R44 II · S/N 12920Cancelled Apr 27, 2010 · Exported to China · Old City Helicopter Sales LLC N46029Robinson Helicopter R44 II · S/N 12695Cancelled Apr 8, 2010 · Exported to India · Built 2010 · Old City Helicopter Sales LLC N44569Robinson Helicopter R44 II · S/N 12947Cancelled Mar 19, 2010 · Exported to Chile · Old City Helicopter Sales LLC N43958Robinson Helicopter R44 · S/N 2049Cancelled Dec 23, 2009 · Exported to Canada · Old City Helicopter Sales LLC N4538VRobinson Helicopter R44 · S/N 2044Cancelled Nov 23, 2009 · Exported to Canada · Old City Helicopter Sales LLC N4223TRobinson Helicopter R44 II · S/N 12673Cancelled Feb 13, 2009 · Exported to Canada · Old City Helicopter Sales LLC N244RPBell OH-58A · S/N 71-20533Cancelled Mar 19, 2007 · Triennial form not returned · Fl St Johns County Sheriffs Office

Back to Saint Augustine, FL