OpenAirDocs.org
Liberal, KS

Cancelled registrations · 103

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 = 'KS' AND d.registrant_city = 'LIBERAL'
  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.

N9323PDJI AGRAS T30 · S/N 3U4DJKK0011D49Cancelled Dec 7, 2024 · Sale reported, canceledN94DEKenneth R Hollrah SUBSONEX · S/N JSX0008Cancelled Jul 13, 2024 · Registration pending, canceledN640KJJohnson Kenneth P GLASAIR III · S/N 3175Cancelled Sep 16, 2023 · Sale reported, canceled · Built 1993N1073CMooney M20A · S/N 1344Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1959 · Magri Lawrence JN32402Rearwin 175 · S/N 1528Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1940 · Maam FoundationN92FFJones ACRODUSTER I SA700 · S/N 12Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1993 · Armstrong Clifford DN80593Mooney M-18L · S/N 73Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1950 · Magri Lawrence JN9014CMooney M20A · S/N 1419Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Magri Lawrence JN19214Piper J-2 · S/N 1614Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1937 · Magri Lawrence JN5542DBeech H35 · S/N D-5097Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1957 · Chacon Francisco JN916SBBeech 400A · S/N RK14Cancelled Jun 19, 2019 · First renewal notice · Built 1991 · Jetshares LLCN4675SBeech 58 · S/N TH-689Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 1975 · Guru Shakti IncN139KPBeech F17D · S/N 257Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1939 · Maam FoundationN1176LThomas James E QUICKIE · S/N 346Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1983 · Maam FoundationN129JMcevilly Jay MUSTANG II · S/N 572Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2002 · Mcevilly JayN82971Aeronca 7AC · S/N 7AC-1623Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Rawson Edson LN9362HStinson VULTEE V-77 · S/N 77-140Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1943 · City Of Liberal KansasN26815Piper J3C-65 · S/N 4196Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1940 · City Of Liberal KansasN46741Ryan Aeronautical ST3KR · S/N 1439Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1941 · City Of Liberal KansasN10973Curtiss Wright JR CW1 · S/N 1151Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1931 · City Of Liberal KansasN1172BLuscombe 8A · S/N 5799Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1947 · City Of Liberal KansasN1015PPiper PA-23 · S/N 23-17Cancelled Aug 8, 2016 · Third renewal notice · Built 1954 · City Of Liberal KansasN502SBPiper AEROSTAR 601P · S/N 61P-0502-207Cancelled Jul 23, 2015 · First renewal notice · Built 1978 · Sierra Bravo PartnershipN39967Jackman Don PITTS S-1S · S/N 100EA421Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1984 · Fleet Edward FN8RMMendenhall CORBEN JR. ACE E · S/N M1Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Mendenhall Ralph AN671WAero Commander CALLAIR A-9B · S/N 1382Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1968N6128SAir & Space America 18A · S/N 18-34Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1966N5056MSkyhawk Helicopter AIR JET · S/N 87-6Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Skyhawk HelicopterN982GSSwanson Gary KR 1 · S/N 1982-1Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1982 · City Of Liberal KansasN5317JGalaxy Balloons GALAXY 7 · S/N GLX-1687Cancelled May 31, 2013 · Sale reported, canceledN4031CStinson 108-3 · S/N 108-5031Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1950 · Trail Thomas DN951JHLakeland Flyers 2/3 SCALE P-51 MSTNG · S/N 68Cancelled Apr 2, 2013 · Sale reported, canceled · Built 2000N4581PPiper PA-23-250 · S/N 27-90Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1960 · City Of Liberal KansasN32431Northwestern PORTERFIELD CP-65 · S/N 861Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1940 · City Of Liberal KansasN32DCWeese BUSHBY MUSTANG II · S/N M11343Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1974 · City Of Liberal KansasN8509ZSmith Max L POBER PIXIE · S/N 1-S-80Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1982 · City Of Liberal KansasN12RGGumm MINICAB-MODIFIED · S/N 1Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1974 · City Of Liberal KansasN18768Commonwealth REARWIN 7000 · S/N 590-SCancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1937 · City Of Liberal KansasN1129CPiper PA-22 · S/N 22-964Cancelled Jan 30, 2013 · Registration expired, pending cancellation · Built 1953 · City Of Liberal KansasN113BTTurner WILLIE II · S/N 52925Cancelled Jan 30, 2013 · Registration expired, pending cancellation · Built 1975 · City Of Liberal KansasN66334Stinson L-5E · S/N 76-2942Cancelled Sep 12, 2012 · Registration pending, canceledN1380EWilliams Neil BREEZY RLU-1 · S/N 4-12-26-ONWCancelled Sep 10, 2012 · Registration pending, canceled · Built 1982N37214Interstate S-1A · S/N 57Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1941N202RGGumm Robert DRAGONFLY · S/N 1Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1984N2NKKensinger N H K-2 · S/N NK2Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1983N31BLLeak Bob AVID FLYER · S/N 31Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1984N3116KCulver V · S/N V335Cancelled Sep 5, 2012 · Registration pending, canceled · Built 1946N72948Cessna 120 · S/N 10146Cancelled Sep 5, 2012 · Registration pending, canceled · Built 1946N65314Beech C18S · S/N 7061Cancelled Aug 23, 2012 · Registration pending, canceled · Built 1944N74456Bellanca 14-13-2 · S/N 1569Cancelled Aug 23, 2012 · Registration pending, canceled · Built 1948
Back to Liberal, KS