Skip to content

Cancelled registrations · 44

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

N946LHDJI AGRAS T30 · S/N 3U5BJS00100BRCancelled Jan 10, 2026 · Sale reported, canceled N97461Stinson 108 · S/N 108-461Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1946 · Check Thomas S Jr N6502DSolmon Paul E BENSEN B7MC · S/N PES-1Cancelled Apr 10, 2018 · Revoked, canceled · Built 1960 · Soloman Paul E N175YTheiss Shawn SPEEDSTER · S/N 0003Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1997 · Theiss Shawn M N47238Aeronca 0-58B · S/N 13794Cancelled Nov 18, 2017 · Revoked, canceled · Built 1944 · Filler Fred N712TTemco D-16A · S/N TTN-80Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1947 · Koons David K N7095DTamati Adam QUICKSLIVER MXL-II · S/N 1427Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1993 · Tamati Adam N9328RSikorsky HO5-S1 · S/N 130123Cancelled Feb 13, 2017 · Revoked, canceled · Built 1959 · Dowmont William C N9433HSikorsky S-52-3 · S/N 125516Cancelled Feb 13, 2017 · Revoked, canceled · Dowmant William C N685YPiper PA-23-250 · S/N 27-4410Cancelled Nov 19, 2015 · Exported to Bahamas · Built 1969 · Salem Aviation & Leasing Co N5176Rose VOLKSPLANE · S/N 5-10018Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1971 N43PWWalton Wayne L VANS RV-6 · S/N 23510Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 2002 · Walton Wayne L N48202Lozier BENSEN B-8M · S/N LEA19751Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1975 · Lozier Richard Jr N902JLLakeland Ultralights KOLB MK III · S/N M1071Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1997 · Bookwalter W D N351AMooney M-18L · S/N 12Cancelled Sep 18, 2012 · Sale reported, canceled · Built 1948 N55DBensen B-8M · S/N DB-01Cancelled Aug 23, 2012 · Revoked, canceled · Built 1963 · Norris John W N1298VKoch Edward J BABY ACE C · S/N HB-1Cancelled Jun 12, 2012 · Sale reported, canceled · Built 1967 N1161TLongmire A · S/N 1Cancelled May 24, 2012 · Sale reported, canceled · Built 1961 N213BCCirrus Design SR22 · S/N 0467Cancelled Jun 28, 2007 · Exported to Poland · Built 2003 · Quaker Mfg Corp N2522ZCessna 182S · S/N 18280120Cancelled May 30, 2007 · Exported to Canada · Built 1998 · Corbi Aircraft Sales Inc N407TJPiper PA-31-325 · S/N 31-7512069Cancelled Jan 19, 2007 · Exported to Canada · Built 1975 · P And L Aircraft Leasing Inc N68002Cessna 152 · S/N 15282132Cancelled Nov 8, 2006 · Exported to Philippines · Built 1978 · Skyline Aviation LLC N201UDMooney M20J · S/N 24-0365Cancelled Sep 19, 2006 · Exported to Canada · Corbi Aircraft Sales Inc N89857Cessna 152 · S/N 15282893Cancelled Jun 17, 2005 · Exported to Canada · Built 1978 · Seidner Aviation Inc N700PTPiper PA-31T · S/N 31T-7820032Cancelled Jan 31, 2000 · Exported to Mexico · Quaker Air Services Inc N9930BCessna 182A · S/N 34330Cancelled May 6, 1991 · Triennial form not returned · Birtalan Paul N1850YCessna 172C · S/N 172-49450Cancelled Jul 21, 1977 · Trammell Jimmy G N9305DPiper PA-22-160 · S/N 22-6316Cancelled May 27, 1976 · Botu John C W Butler N3354VBeech 35 · S/N D-818Cancelled Nov 24, 1972 · Bieber Randall F N95022Piper PA-28-140 · S/N 28-25777Cancelled Jul 19, 1971 · Mooney Marilynn E N3271JCessna 150G · S/N 15065971Cancelled Jan 31, 1971 · Salem Air Park Inc N86251Aeronca 11AC · S/N 11AC-55Cancelled Dec 31, 1970 · Paul Birtalan N8277SCessna 150F · S/N 150-61877Cancelled Apr 22, 1968 · Koons Flying Service N51923Fairchild M-62A · S/N T43-5422Cancelled May 20, 1965 · Arden T Glass N6911HPiper J3C-65 · S/N 20147Cancelled Jan 14, 1960 · Birtalan Paul N99528Ercoupe 415-C · S/N 2151Cancelled Feb 28, 1956 · Built 1946 · Paxson Theda L N2573VCessna 170 · S/N 18112Cancelled Sep 13, 1954 · Starbuck Donald E N52311Taylorcraft L-2B · S/N L4953Cancelled Sep 15, 1953 · Built 1945 · Mercer Dean N85600Aeronca 7AC · S/N 7AC-4343Cancelled Mar 30, 1953 · Built 1946 · Lowell Phillis N89721Cessna 120 · S/N 8770Cancelled Apr 17, 1951 · Starbuck Donald E N97747Stinson 108-1 · S/N 747Cancelled Aug 19, 1948 · Exported to Brazil · Built 1946 · Hanks Robert G N5069Cessna T-50 · S/N 1304Cancelled Feb 21, 1944 · Built 1941 · Salem Engineering Company N3006JCessna 150E · S/N 15061106Cancellation date not recorded · Salem Air Park Inc N5759BCessna 182 · S/N 33759Cancellation date not recorded · Salem Air Park Inc

Back to Salem, OH