OpenAirDocs.org
Lawrence, KS

Cancelled registrations · 70

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 = 'LAWRENCE'
  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.

N34KUUniv Of Kansas Aerospace Engrg YAK-54 33% · S/N KU-YAK-54-33-2Cancelled Apr 1, 2023 · Registration expired, pending cancellation · University Of Kansas Aerospace Engineering DeptN355UKUniv Of Kansas Aerospace Engrg TBM UAV4 3M H-TAIL · S/N KU-UAV4-1Cancelled Apr 1, 2023 · Registration expired, pending cancellation · University Of Kansas Aerospace Engineering DeptN339JTFokker F.28 MK 0100 · S/N 11339Cancelled Dec 17, 2019 · Odyssey Air Finance LLCN806PLPulse Aerospace VAPOR 35 · S/N 100296-100127Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Pulse Aerospace IncN33KUUniv Of Kansas Aerospace Engrg YAK-54 33% · S/N KU-YAK-54-33-1Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of KansasN5400PPulse Aerospace VAPOR 35 · S/N 100296-100121Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Pulse Aerospace LLCN346PAPulse Aerospace VAPOR 35 · S/N 100296-100125Cancelled Jan 17, 2019 · Registration expired, pending cancellation · Pulse Aerospace LLCN526VKHaiyang Chao FLYING WING 55 INCH · S/N KHAWK03-055-100Cancelled May 3, 2018 · Registration expired, pending cancellation · University Of KansasN526UKHaiyang Chao FLYING WING 48 INCH · S/N KHAWKO1-048-166Cancelled Apr 24, 2018 · Registration expired, pending cancellation · University Of KansasN526WKHaiyang Chao FLYING WING 48 INCH · S/N KHAWK02-048-099Cancelled Apr 24, 2018 · Registration expired, pending cancellation · University Of KansasN31EWRaytheon 58 · S/N TH-1939Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2000 · Arc Aviation LLCN630SWCessna 182Q · S/N 18265516Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1977 · Radford Scott MN5165ZBuckeye Industries DREAM MACHINE · S/N 3513Cancelled May 15, 2017 · Registration expired, pending cancellation · Gottschamer KarlN7903WPiper PA-28-180 · S/N 28-1933Cancelled May 15, 2017 · Built 1964 · Hansen K PeteN52CCBowers BREEZY RUL-1 · S/N 3Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1976 · Finch Gary RN827TDAerospatiale AS 355F · S/N 5242Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Capital Aviation LLCN71388Luscombe 8A · S/N 2815Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1946 · Kocol Stanley TN13580Mccomb Michael C QUICKIE Q-2 · S/N 2056Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Mccomb Michael CN1910FCessna 177B · S/N 17700002Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1968 · University Of KansasN8166EMooney M20A · S/N 1437Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1959 · Clinton Dale LN4282ATevis BREEZY TA-1 · S/N TA-10Cancelled Apr 8, 2013 · Sale reported, pending cancellation · Built 1987N3337TCessna 177 · S/N 17700637Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1967 · Born Daniel PN357NTAerospatiale AS350B · S/N 1549Cancelled Jul 15, 2009 · Exported to Canada · Built 1982N94962Cessna 152 · S/N 15285824Cancelled Jun 12, 2009 · Exported to Czech Republic · Built 1983 · Sherman Jerry LN226MBAerotrike SPIRIT · S/N 226Cancelled Apr 3, 2009 · Built 2007 · Brock Michael EN5397UGrant Floyd JR S 7 COURIER · S/N S787005Cancelled Jun 29, 2004 · Triennial form not returned · Cobb Gerald LN260MHAerospatiale AS 355 F ECUREUIL · S/N 5087Cancelled Dec 2, 2003 · Exported to Canada · Built 1982 · Capital Aviation LLCN750CHRobinson Helicopter R22 BETA · S/N 3060Cancelled Jan 15, 2003 · Exported to New Zealand · Built 2000 · Capitol Helicopter IncN2003ABeech 36 · S/N E166Cancelled Apr 26, 1996 · Triennial form not returned · Tri H CorporationN133SJBuecker JUNGMEISTER BU 133C · S/N 46Cancelled Aug 11, 1994 · Exported to United Kingdom · Craig Stephen JN9140FPiper PA 46-350P · S/N 4622004Cancelled Feb 22, 1994 · Exported to Germany · Environmental Ventures IncN43882Dehavilland-Shawano DHC-2 MK.I · S/N 1010Cancelled Feb 10, 1992 · Exported to Canada · Kansas Geological SurveyN1982VCessna 172M · S/N 17263811Cancelled Aug 2, 1983 · Administratively canceled · Lawrence Flying Club IncN74FJJacobsen DAVIS-DA2B · S/N 233Cancelled Dec 17, 1981 · Jacobson Frederick BN4312JPiper PA-28-140 · S/N 28-22685Cancelled Jan 5, 1977 · Exported to El Salvador · Built 1967 · Day Howard DBAN5682JCessna A188A · S/N 18800632Cancelled May 9, 1975 · Erhart Spraying Service IncN20790Cessna 182P · S/N 18261206Cancelled Apr 22, 1975 · Jones Russell WN300KUBeech SNB-5 · S/N 29623Cancelled Dec 2, 1974 · The University Of Kansas Center For Research IncN52364Cessna 182P · S/N 18262552Cancelled Aug 14, 1974 · Exported to Australia · Lawrence Aviation IncN52671Cessna 182 · S/N 18262758Cancelled Aug 14, 1974 · Exported to Australia · Lawrence Aviation IncN93124Cessna 210L · S/N 210-60271Cancelled Aug 14, 1974 · Exported to Australia · Lawrence Aviation IncN52760Cessna 182P · S/N 18262827Cancelled Feb 25, 1974 · Exported to Australia · Lawrence Aviation IncN1556UCessna U206F · S/N U20602258Cancelled Feb 1, 1974 · Exported to Australia · Built 1973 · Lawrence Aviation IncN21200Cessna 182 · S/N 18261480Cancelled Mar 21, 1973 · Exported to Australia · Lawrence Aviation IncN92511Cessna 182N · S/N 18260239Cancelled Nov 22, 1972 · Erhart Flying Service IncN74080Hughes FLY BABY · S/N 63-67Cancelled Feb 28, 1972 · Sport Flyers IncN61137Stinson L-5 · S/N 42-98209Cancelled Nov 24, 1971 · Allison Lawrence MN9940Grumman F11A · S/N 141811Cancelled Oct 26, 1970 · University Of KansasN83934Aeronca 7AC · S/N 7AC-2616Cancelled Jun 25, 1970 · Erhart Spraying Service IncN8634RSchweizer SGS 1-26B · S/N 177Cancelled Aug 20, 1968 · Haas Frank J
Back to Lawrence, KS