OpenAirDocs.org
Lamar, CO

Cancelled registrations · 27

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 = 'CO' AND d.registrant_city = 'LAMAR'
  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.

N846DMAir Tractor AT-502 · S/N 502-0035Cancelled Dec 23, 2021 · Third renewal notice · Built 1988 · Air Care IncN4557JPiper PA-28R-180 · S/N 28R-30417Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1968 · Telfer Roe SN3205MYakovlev YAK 52 · S/N 855306Cancelled Mar 25, 2020 · Expired dealer · Built 1985 · Air Care Systems IncN8319YPiper PA-30 · S/N 30-1459Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Yoon Paul CN8870QAero Commander S2R · S/N 1470RCancelled Jun 4, 2018 · First renewal notice · Built 1969 · Air Care Leasing LLCN201VAMooney M20J · S/N 24-0299Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1977 · Woller Don L DBAN75GSRockwell International S-2R · S/N 5038RCancelled Mar 1, 2016 · Second renewal notice · Air Care Leasing LLCN4996BBeech C-45H · S/N AF-67Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Leatherman DarrellN94RMMorris Ray O PITTS S-1C · S/N 2Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1975 · Mcaskill Jeffery WN735ATCessna 182Q · S/N 18265277Cancelled Aug 13, 2009 · Exported to Canada · Built 1976N230SBStrissel Dale R PITTS S1S 1979 · S/N 7-0422Cancelled Jan 16, 2008 · Second triennial mailing, no response · Built 1982 · Lyddon Steven RN3153YYakovlev YAK 52 · S/N 855006Cancelled May 30, 2007 · Exported to Norway · Air Care Systems IncN8606LPiper PA-25-260 · S/N 255032Cancelled Feb 12, 1996 · Exported to Mexico · Tinnes Allen HN35973Cessna TU206F · S/N U20602841Cancelled Jun 29, 1991 · Triennial form not returned · Lyddon Flying Service IncN7606ZPiper PA-25-235 · S/N 25-3703Cancelled Sep 10, 1986 · Tinnes Allen HN417DRCessna 411A · S/N 4110265Cancelled Jul 2, 1980 · Built 1967 · Ferguson James EN9705KPiper PA-32R-300 · S/N 32R-7680243Cancelled Mar 25, 1977 · Dexters Insurance Agency IncN6031LAmerican AA-5 · S/N AA5-0131Cancelled Feb 24, 1976 · Exported to Canada · Civis JamesN2068GCessna 182A · S/N 51368Cancelled Aug 15, 1974 · Exported to Canada · Atkinson Construction CoN6714ECessna 175 · S/N 56214Cancelled Nov 24, 1971 · Eaton Dwain WN2931VBeech 35 · S/N D315Cancelled Aug 3, 1966 · Built 1949 · Trumble William EN88316Piper J3C-65 · S/N 15934Cancelled May 22, 1965 · Val-Air IncN2263DCessna 170B · S/N 20415Cancelled Apr 16, 1965 · Myers Motor SalesN78269Globe GC-1B · S/N 2269Cancelled Oct 12, 1955 · Bugg Robert MN53038Boeing A75N1 · S/N 75-2214Cancelled Oct 26, 1951 · Exported to Mexico · Built 1945 · Val Air IncN73738Boeing B75N1 · S/N 75-6889Cancelled Oct 26, 1951 · Val-Air IncN2945Eaglerock LONG WING EAGLEROCK · S/N 179Cancelled Oct 1, 1935 · Hatchett Roy K
Back to Lamar, CO