OpenAirDocs.org
Youngstown, OH

Cancelled registrations · 90

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 = 'OH' AND d.registrant_city = 'YOUNGSTOWN'
  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.

N8815XCessna 182D · S/N 18253215Cancelled Oct 7, 2023 · Built 1961 · Knickerbocker Ronald EN19053Taylorcraft A · S/N 159Cancelled Mar 27, 2020 · Revoked, canceled · Built 1937 · Womble Charles FN5965ZPiper PA-22-108 · S/N 22-9837Cancelled Feb 10, 2020 · Revoked, canceled · Built 1964 · Southern Airways IncN1211EAeronca 7AC · S/N 7AC4769Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Southern Airways IncN93643Engineering & Research 415-C · S/N 966Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Blackann James VN20698Stinson SR-8A · S/N 9810Cancelled Jun 12, 2019 · Revoked, canceled · Built 1936 · Magrini Eugene JN81998Aeronca 7AC · S/N 7AC623Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1946 · Southern Airways IncN51643Fairchild M-62A · S/N T435959Cancelled May 18, 2018 · Revoked, canceled · Built 1943 · Stambaugh WmN4665LCessna 172G · S/N 17254660Cancelled Apr 23, 2018 · Built 1966 · Southquarter Aviation LLCN34536Cessna 177B · S/N 17701861Cancelled Mar 16, 2018 · Revoked, canceled · Built 1973 · Huberty Robert WN9201RMooney M20J · S/N 24-0614Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1978 · Air Mcroyal LLCN47064Fairchild M-62A · S/N T423877Cancelled Nov 22, 2017 · Revoked, canceled · Built 1942 · Hawkins James AN40WMMissik-William H1754RW · S/N 194053Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1978 · Missik William BN4372PPiper PA-28-236 · S/N 28-8411031Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1984 · Gt Aircraft LLCN7807ACessna 180A · S/N 32704Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · Martin James E DBAN85273Aeronca 7AC · S/N 7AC4008Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Southern Airways IncN732TUCessna T210M · S/N 21061769Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Lewis DanN8434CAero Commander 560-E · S/N 765Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1959 · Marlor CorpN7181DBeech 60 · S/N P-53Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1969N4830XCessna 150G · S/N 15064880Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1966N28737Silvaire LUSCOMBE 8C · S/N 1498Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Johnjulio Reynold JN69550Cessna UC-78 · S/N 2719Cancelled Sep 6, 2012 · Revoked, canceled · Built 1942 · Wings IncN14YKYakovlev YAK 52 · S/N 8910006Cancelled Jun 30, 2008 · Exported to Germany · Built 1989 · Bertelli JohnN71266Luscombe 8A · S/N 2693Cancelled Feb 3, 2006 · Triennial form not returned · Built 1946 · Blewitt Frederick RN5369PPiper PA-24-250 · S/N 24-418Cancelled Oct 14, 2004 · Triennial form not returned · Built 1958 · Ventresco James JrN5457ZPiper PA-22-108 · S/N 22-9235Cancelled Aug 5, 2002 · Triennial form not returned · Built 1961 · Verzilli David VN9090RHarmon And Lopez COUGAR · S/N 1Cancelled Jan 22, 1993 · Triennial form not returned · Simons Don PN61226Cessna 150J · S/N 15070899Cancelled May 26, 1976 · Youngstown Flying Serivce IncN1421BLuscombe 8E · S/N 6048Cancelled Apr 22, 1974 · Tesner Edmund PN90344Temco GC-1A · S/N 358Cancelled Feb 23, 1972 · Sudol JosephN7507JPiper PA-28R-180 · S/N 28R-30872Cancelled Feb 3, 1972 · Ula Joseph JrN78DAero Commander 680T · S/N 1580Cancelled Jan 17, 1972 · Lease Air IncN25YCLockheed PV-1 · S/N 5598Cancelled Dec 10, 1971 · Built 1956 · Lease Air IncN6046VBeech C18S · S/N 8521Cancelled Dec 2, 1971 · Ragan GeorgeN81DBeech G18S · S/N BA612Cancelled Feb 12, 1971 · Built 1962 · Burton Supply CoN42030Piper J3F-65 · S/N 9082Cancelled Dec 7, 1970 · Edward C EgolfN5012ACessna 172 · S/N 28012Cancelled Jun 8, 1970 · Phillips William EN9955ZBeech C-45H · S/N 52-10818Cancelled Dec 20, 1968 · B & B Construction Co Ohio IncN34041Taylorcraft BL12-65 · S/N 2905Cancelled Jun 28, 1963 · Exported to Canada · Kleiner JackN2127EAeronca 7AC · S/N 7AC-5698Cancelled Aug 14, 1961 · Exported to Canada · Built 1946 · Southern Airways IncN49BBeech D-50 · S/N DH-145Cancelled Jul 10, 1961 · Lease Air IncN93DBeech G18S · S/N BA518Cancelled Jun 29, 1961 · Lease Air IncN96313Taylorcraft BC12-D · S/N 8613Cancelled Dec 27, 1960 · Exported to Canada · Rancho SalesN61608Cessna T-50 · S/N 5992Cancelled Apr 26, 1960 · Trimm WilliamN43886Taylorcraft BC12-D · S/N 7545Cancelled Jan 14, 1960 · Southern Airways IncN3313APiper PA-22-135 · S/N 22-1591Cancelled Sep 27, 1957 · Exported to Canada · Youngstown Airways IncN94985Taylorcraft BC12-D · S/N 9385Cancelled Dec 6, 1956 · Exported to Canada · Kleiner JackN40800Piper J3L-65 · S/N 7497Cancelled Feb 28, 1956 · Wings IncorporatedN4482EAeronca 7AC · S/N 7AC-7198Cancelled Nov 17, 1955 · Built 1948 · Wings IncN69107North American SNJ-2 · S/N 2022Cancelled Oct 13, 1955 · Paulo Eugene I
Back to Youngstown, OH