Skip to content

Cancelled registrations · 48

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 = 'FT MYERS' 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 = 'FT MYERS'
  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 = 'FT MYERS'
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.

N1232DCessna 170A · S/N 19786Cancelled Jul 17, 2021 · Expired dealer · Frana Joel A DBA N1364TPiper PA-28-140 · S/N 28-7225482Cancelled Jul 17, 2021 · Expired dealer · Built 1972 · Frana Joel A DBA N29451Cessna 177 · S/N 17700896Cancelled Jul 17, 2021 · Expired dealer · Built 1968 · Frana Joel A DBA N29877Cessna T207 · S/N 20700247Cancelled Jul 17, 2021 · Expired dealer · Frana Joel A DBA N3370TCessna 177 · S/N 17700670Cancelled Jul 17, 2021 · Expired dealer · Built 1967 · Frana Joel A DBA N6280KRepublic RC-3 · S/N 490Cancelled Jul 17, 2021 · Expired dealer · Frana Joel A DBA N7209PPiper PA-24-180 · S/N 24-2379Cancelled Jul 17, 2021 · Expired dealer · Built 1960 · Frana Joel A DBA N7334MCessna 175 · S/N 55634Cancelled Jul 17, 2021 · Expired dealer · Built 1958 · Frana Joel A DBA N9206PPiper PA-24-260 · S/N 24-4701Cancelled Jul 17, 2021 · Expired dealer · Frana Joel A DBA N21383Aeronca 50-C · S/N C1928Cancelled Nov 27, 2019 · Revoked, canceled · Built 1938 · Gibson E C N92974Rearwin 185 · S/N 1707Cancelled Oct 2, 2019 · Revoked, canceled · Built 1946 · Morehouse Paul E N7718Bensen Gyrocopter 8BM · S/N HBM23Cancelled Feb 4, 2017 · Revoked, canceled · Built 1967 · Van Pelt Martin J N2549SCessna 337C · S/N 337-0849Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1968 · Kennard Compton K N348RStekeur Robert D TERRIA II · S/N 1Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Stekeur Robert D N784VDouglas DC3C 1830-94 · S/N 11664Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1976 · Sw Fl Regional Veterans Memorial Inc N175DKKittinger Dwight Gerald BENSEN · S/N 161987Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Kittinger Dwight G N6151JPiper PA-28-181 · S/N 28-7690354Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1976 · Den Besten Wendel N2228YDewitt George B JR CGS HAWK · S/N INFLIGHT1CGS16Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Inflight Ventures Inc N5913ACessna 172 · S/N 28513Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1956 · Sakalis Albert C N4929XRockwell International S-2R · S/N 2131RCancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1974 · Spillman Charles N86540Cessna 337E · S/N 33701230Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1969 N64727Grumman S-2E · S/N 147893Cancelled Feb 25, 2013 · Sale reported, pending cancellation N9762Lanyi Ernest S BD-4 · S/N 80Cancelled Nov 26, 2012 · Sale reported, pending cancellation · Built 1971 N5126KRyan NAVION A · S/N NAV-4-2026Cancelled Aug 10, 2012 · Revoked, canceled · Built 1950 · Bauer Paul R N4015UCessna 150E · S/N 15061415Cancelled Jun 7, 2012 · Registration pending, canceled · Built 1965 N57WLLipe William E B8M LIPE · S/N 001Cancelled Dec 30, 2005 · Triennial form not returned · Built 1991 · Lipe William E N4627XCessna 150G · S/N 15064677Cancelled Jun 20, 2002 · Triennial form not returned · Built 1966 · Mr Perc Inc N6312TStilwell William BENSON TYPE GYRO · S/N ST-7Cancelled Aug 29, 2000 · Triennial form not returned · Stilwell William N3891JBurgess Joseph H SCORPION 133 · S/N 1019Cancelled Jul 18, 2000 · Triennial form not returned · Burgess Joseph H N9738PPiper PA-25-235 · S/N 257556055Cancelled Jul 24, 1998 · Exported to Brazil · Berkel James V DBA N7354ECessna 172N · S/N 17272092Cancelled Jan 3, 1994 · Triennial form not returned · Alternative Flying Club Inc N793MABeech C90 · S/N LJ703Cancelled Dec 30, 1993 · Exported to Turkey · Resort Title Agency Inc N3RPPiper PA-23-250 · S/N 274597Cancelled Feb 19, 1991 · Triennial form not returned · Cm Squared Inc N620ACCessna 402C · S/N 402C-0455Cancelled Jan 15, 1985 · Fort Myers 21 Inc N49863Cessna 152 · S/N 15281367Cancelled Dec 5, 1983 · Schorr Leon W N8250JPiper AEROSTAR 601P · S/N 61P07198063348Cancelled May 21, 1983 · Administratively canceled · West Coast Insulation Co Inc N2754PPiper PA-22-150 · S/N 22-3061Cancelled Apr 6, 1983 · Simon Richard & Linzalone Joseph N1043ABeech E33 · S/N CD-1227Cancelled Apr 15, 1982 · Administratively canceled · Garner James F N5562MAero Commander 100 · S/N 131Cancelled May 7, 1981 · The Lark Club Inc N23596Bell TH-13T · S/N 3608Cancelled Feb 2, 1976 · Sale reported N5929YPiper PA-23-250 (6PCLM) · S/N 27-3090Cancelled Sep 26, 1975 · H F W Partnership N6699SCessna 150H · S/N 15067499Cancelled Nov 21, 1972 · South West Aviation Inc N2927MPiper PA-12 · S/N 12-1329Cancelled May 19, 1965 · Frank Swearingen N5885ACessna 172 · S/N 28485Cancelled Jun 15, 1960 · Exported to Canada · Shaw Douglas W N3798KGlobe GC-1B · S/N 1491Cancelled Dec 4, 1957 · Exported to Mexico · Built 1947 · Snow Marcus Lauren N55954Consolidated Vultee SNV-2 · S/N 79-19Cancelled Oct 25, 1954 · Ft Myers Squadron Civil Air Patrol N55423Boeing A75 · S/N 75-154Cancelled Dec 15, 1948 · Built 1940 · Royal Palm Flying Service Inc N55424Boeing A75 · S/N 75-251Cancelled Dec 15, 1948 · Royal Palm Flying Service Inc

Back to Ft Myers, FL