Skip to content

St Petersburg, FL

Cancelled registrations · 225

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 = 'ST PETERSBURG' 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 = 'ST PETERSBURG'
  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 = 'ST PETERSBURG'
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.

N427JVJrsr Venture ZODIAC 601 XL · S/N 6-6430Cancelled May 22, 2026 · Built 2007 · Jrsr Venture LLC N13212Cessna 172M · S/N 17262578Cancelled Dec 9, 2021 · Exported to Turkey · Built 1973 · Southern Comfort Aircraft Paint Interiors & Avioni N155WTAcker-Commuter JR H-1A · S/N ACJ01Cancelled Jun 12, 2019 · Revoked, canceled · Built 1961 · Triggs W A N27018Piper J4A · S/N 4993Cancelled Jan 28, 2019 · Revoked, canceled · Built 1940 · Mitchell Robert C N323SLockheed 18-56 · S/N 2014Cancelled Apr 5, 2018 · Revoked, canceled · Built 1941 · Carlton Robert M N387CStinson 108-2 · S/N 108-3387Cancelled Mar 16, 2018 · Revoked, canceled · Built 1947 · Walding William H N107ZXMicroleve Comercio E Ind Ltda CORSARIO · S/N 454Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Cohen Steven B N56940Polaris FB582 · S/N 5236586Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Tyoe Rodney N148RBBenson GYRO1 · S/N 001Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1996 · Bricker Randall D N2597BLockheed PV-1 · S/N 1596Cancelled Nov 22, 2017 · Revoked, canceled · Royal International Corp N7123DPiper PA-22-150 · S/N 22-4983Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1957 · Dunn Robert E N723LJCirrus Design SR22 · S/N 2402Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 2007 · Jam Aviation LLC N1997ZCessna 150C · S/N 15059797Cancelled Mar 7, 2017 · Registration expired, pending cancellation · Brinkman Paul Anker N6298QCessna 152 · S/N 15285223Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1981 · Bay Air Flying Service Inc N8477CAero Commander 560-E · S/N 826Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Enterprises Inc N7GRRead Gary W READ REVOLUTION · S/N WR204S185Cancelled Nov 30, 2015 · Read Gary W N6080TCessna 150E · S/N 15060780Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1965 · Flordia Aerial Advertising Inc N9506NPoindexter Norman J DRIFTER · S/N 112248Cancelled May 7, 2015 · Registration expired, pending cancellation · Poindexter Norman J N4039KBalloon Works FIREFLY 7 · S/N 7823Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1979 · Corn William L N620BBeech A35 · S/N D-1643Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1948 · Epperson James N6330GCessna 150K · S/N 15071830Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1970 · Tilton Russell F Jr N297ASPiper PA-32R-301T · S/N 3257122Cancelled Mar 19, 2015 · Built 1999 · Howard Aviation N9430KPiper PA-32R-300 · S/N 32R-7680406Cancelled Mar 16, 2015 · Third renewal notice · Built 1976 · Engenius Inc N121WEAir Transportation WHITE LIGHT WLAC 1 · S/N 76Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1989 · Air Transportation Inc N10110Powell M J B8M · S/N MJP-001Cancelled Dec 11, 2014 · Registration expired, pending cancellation · Powell Myron J N3218Florida Avn Historical Socirty FORD FLIVVER · S/N FAHS-2Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1994 · Florida Aviation Historical Society N199WEAir Transportation ADVENTURE · S/N AA36Cancelled Oct 16, 2014 · Built 1995 · Air Transportation Of Nevada Inc N827ABCessna 421 · S/N 421-0101Cancelled Oct 6, 2014 · Revoked, pending cancellation · Built 1968 · Greenber Corporation N25273Piper PA-23-250 · S/N 38-80A0101Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1980 · Bay Air Services Inc N67974Boeing B-17F · S/N 758296Cancelled Oct 24, 2013 · Revoked, canceled · California Atlantic Airways N419JWWalker Joseph M VARIEZE · S/N 419Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1981 · Walker Joseph M N298VMott John B VELOCITY · S/N 007Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Mott John B N5404ACessna T210N · S/N 21063416Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1979 · Cotman Henry E N8983CPiper PA-22 · S/N 22-1561Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1953 · Kramer Martin F W N748FHFairchild Hiller FH-1100 · S/N 75Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1967 N580CABeech 65-B80 · S/N LD-284Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1966 N1430JRockwell International 112A · S/N 430Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1975 · Burns Thomas J N487SBBergin Scott W Q-200 · S/N 2473Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Bergin Scott W N818DPPiper David A TORNADO SPORT · S/N T92XXXCOHK0026Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1995 · Piper David A N2401UCureton Richard L KITFOX III · S/N 894Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 2005 · Cureton Richard L N92919Commonwealth REARWIN 185 · S/N 1652Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1946 · Calabrese Albert J N9346TPiper PA-38-112 · S/N 38-78A0058Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1978 · Aviators Flying Club Inc N68411Cessna 152 · S/N 15282286Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1978 · Cecilys Flight Center Inc N6580YPiper PA-23-250 · S/N 27-3879Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1968 · Hersey Kenneth R N5634JCessna A188A · S/N 18800584Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1969 · Sinness Lon E N2399ZBeech 23 · S/N M-100Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1963 · Lindenmuth Roy E N5412GCessna 404 · S/N 404-0669Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Bayair Services Inc N3978LSpread Your Wings TERRATORN TIERRA II · S/N 1Cancelled Apr 1, 2013 · Sale reported, canceled N5058YPiper PA-23-250 · S/N 27-2069Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1962 · Hathcock James L N9379AMooney M20C · S/N 20-1237Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1977

Back to St Petersburg, FL