OpenAirDocs.org
Flushing, NY

Cancelled registrations · 60

Query with SQL
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 = 'NY' AND d.registrant_city = 'FLUSHING'
  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.

N28620Luscombe 8C · S/N 1449Cancelled Sep 16, 2019 · Revoked, pending cancellation · Built 1940 · Lantay FrankN1420LBeech A23 · S/N M-813Cancelled Aug 5, 2019 · Sale reported, canceled · Built 1965N3701SCessna 172E · S/N 17250901Cancelled Sep 7, 2018 · Sale reported, canceled · Built 1963N3295VBeech 35 · S/N D-746Cancelled May 18, 2018 · Revoked, canceled · Built 1947 · Miller Robert LN66888BDC Aero Industrie PUMA LSA · S/N AB-59-20-614Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Polytech International Resources CorpN910MHAero Commander 1121 · S/N 45Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1965 · College Of AeronauticsN923TSBoeing 727-225 · S/N 20441Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc DBA Usair ShuttleN795KBeech 65-90 · S/N LJ-95Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1965 · College Of AeronauticsN30923Cessna 177B · S/N 17701548Cancelled Jan 10, 2018 · Third renewal notice · Built 1970 · Mei-Chu CorpN2279KPiper PA-18 · S/N 18-2110Cancelled Aug 17, 2016 · Third renewal notice · Built 1952 · College Of AeronauticsN927TSBoeing 727-227 · S/N 20837Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1973 · Shuttle Inc DBAN1916DBeech C35 · S/N D-3165Cancelled Dec 22, 2014 · Revoked, canceled · Built 1952 · Costas Emanuel JN89807Cessna 152 · S/N 15282876Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1978 · Aer Aisling Ltd DBAN7021CPiper PA-34-200T · S/N 34-7670082Cancelled Nov 14, 2013 · Registration expired, pending cancellation · Built 1975 · College Of AeronauticsN67451Cessna 152 · S/N 15281842Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1978 · Sunset Enterprises IncN9708UGrumman American Avn. AA-5A · S/N AA5A-0108Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1976N1148WBell 47J-2A · S/N 3125Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1964 · Charles M Trojahn IncN9177YBeech B-55 · S/N TF-22Cancelled Jul 8, 2013 · Registration expired, pending cancellation · College Of AeronauticsN922TSBoeing 727-225 · S/N 20415Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc DBAN84TSCrawford Timothy L LONG-EZ · S/N RAF-476Cancelled May 10, 2013 · Sale reported, canceled · Built 1984N701CCBeech H-18 · S/N BA-740Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1966 · Moonlight Express CorpN14BPPiper PA-23-250 · S/N 27-4279Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1969N2745YBeech 95 · S/N TD-103Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1958 · College Of AeronauticsN42749Cessna 182L · S/N 18259174Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1968N22685Cessna 150H · S/N 15068448Cancelled Aug 31, 2012 · Registration expired, pending cancellation · Built 1968 · College Of AeronauticsN3404PPiper PA-23-160 · S/N 23-1368Cancelled Jun 30, 2008 · Triennial form not returned · Built 1958 · College Of AeronauticsN52DHHall STEEN SKYBOLT · S/N 1Cancelled Oct 18, 1999 · Exported to Ireland · O Sullivan Brian GN404NCessna 404 · S/N 4040855Cancelled Mar 26, 1998 · Exported to India · Lefer Blanc IncN7274NCessna 310 · S/N 582171Cancelled Mar 18, 1996 · Triennial form not returned · College Of AeronauticsN12928Cessna 172M · S/N 17262380Cancelled Sep 9, 1993 · Exported to Israel · El Rom IncN89427Cessna 152 · S/N 152-82740Cancelled Jun 25, 1980 · Exported to Canada · Aer Aisling LtdN428PABoeing 707-321B · S/N 19363Cancelled May 12, 1977 · Exported to South Korea · Built 1967 · Auerbach Frank TrusteeN7467CNorth American AT-6D · S/N 121-41912Cancelled Jun 28, 1971 · Flight Safety IncN82054Aeronca 7AC · S/N 7AC-680Cancelled May 10, 1971 · Edwards Flying Service IncN15659Fairchild 24 C8C · S/N 2713Cancelled Sep 2, 1970 · Chaarles T HartzogN83196Aeronca 7AC · S/N 7AC-1857Cancelled Aug 24, 1970 · Edwards Flying Service IncN2654BAero Commander 560 · S/N 154Cancelled Jul 13, 1970 · Built 1954 · Academy Of AeronauticsN8828WPiper PA-28-235 · S/N 28-10376Cancelled Jun 30, 1970 · Speed'S Flying Service IncN1888JPiper PA-28-140 · S/N 28-24333Cancelled Jun 8, 1970 · Built 1968 · Flight Safety IncN20609Fairchild 24 J · S/N 3511Cancelled May 21, 1965 · Speeds Flying Service IncN3831MPiper PA-12 · S/N 12-2748Cancelled May 20, 1965 · Speeds Flying Service IncN9925RBeech B95 · S/N TD-382Cancelled Aug 12, 1964 · Exported to Switzerland · Cossato Louis DN2910PPiper PA-22S-150 · S/N 22-3178Cancelled Jun 1, 1964 · Frank LantayN69206Boeing PT-17 · S/N 75-1665Cancelled Dec 23, 1959 · Lokey Charles MartinN270MBeech D18S · S/N A-954Cancelled Apr 8, 1958 · Exported to Sweden · Transaero IncN603DBeech D18S · S/N A-599Cancelled Apr 8, 1958 · Exported to Sweden · Transaero IncN1269CPiper PA-22-135 · S/N 22-1067Cancelled Oct 4, 1957 · Exported to Germany · Speeds Flying Service IncN16224Waco ZQC-6 · S/N 4430Cancelled May 12, 1953 · Built 1936 · Speeds Flying Service IncN21311Aeronca 65-LA · S/N L-1168Cancelled Jan 26, 1950 · Built 1938 · Heiligmann Alan K / Reilly Bernard JN1208VBoeing E75(N2S-5) · S/N 75-5213Cancelled Jun 16, 1949 · Yarnall Edward S
Back to Flushing, NY