OpenAirDocs.org
Layton, UT

Cancelled registrations · 40

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 = 'UT' AND d.registrant_city = 'LAYTON'
  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.

N44740Piper PA-28R-200 · S/N 28R-7535002Cancelled Dec 7, 2022 · Sale reported, pending cancellation · Built 1974N7018YPiper PA-30 · S/N 30-19Cancelled Mar 1, 2022 · Exported to Canada · Built 1963 · Bell RogerN7097TAerostar International RX-9 · S/N RX9-3006Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Built 1995 · Nichols Investments LLCN3377UCessna 182F · S/N 18254777Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Thatcher RobertN761TTTerning Nate Allan KR-2 · S/N NT0199KR2Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1999 · Terning NateN4529WBoeing 737-275 · S/N 20785Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1973 · Department Of Air ForceN3610RBalloon Works FIREFLY 7 · S/N F7-031Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1983 · Rathke Thomas HN5176YBoeing 737-200 · S/N 20692Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1974 · Department Of The Air ForceN27RABeech 1900C · S/N UB-37Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1985 · Department Of The Air ForceN73PEEricson Paul W ACRO SPORT-II · S/N 258Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1980 · Williams Rand WN98011Piper J3C-65 · S/N 18146Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1946 · Robinson Mark DBAN290DLLatham David T F-1 ROCKET · S/N 108Cancelled Apr 9, 2015 · Exported to Canada · Built 2004 · Spreeman Jason AN174BTTerning Brett R SKY SCOUT · S/N 174Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 2001 · Terning Brett RN3263BCessna 172M · S/N 17267079Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1976 · Cansler George DN2166PPiper PA-23 · S/N 23-771Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1956 · Stevenson Brent SN41494Nielson Richard ROTORWAY EXEC · S/N 3205Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1993 · Nielson Richard DN5294MBoeing 737-200 · S/N 20694Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1974 · Department Of The Air ForceN3323PPiper PA-23-160 · S/N 23-1274Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1958 · Stevens Thomas VN5175UBoeing 737-200 · S/N 20689Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1974 · Department Of The Air ForceN5177CBoeing 737-200 · S/N 20693Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1974 · Department Of The Air ForceN47176Aeronca 0-58B · S/N 058B-9183Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1943N3605VCessna 140 · S/N 14873Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1948 · Voigt Robert W JrN8894RBellanca 14-19-3 · S/N 4256Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1965 · Flatau Alan GN7498KPiper PA-20-135 · S/N 20-414Cancelled Dec 6, 2012 · Sale reported, pending cancellation · Built 1950N23371Piper PA-38-112 · S/N 38-81A0090Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1981 · Stevens Thomas VN2362KPiper PA-38-112 · S/N 38-79A0592Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1979 · Stevens Thomas VN5294EBoeing 737-200 · S/N 20691Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Built 1974 · Department Of The Air ForceN47NWWhittle Norman V RANS S-4 COYOTE 1 · S/N 802310Cancelled Sep 8, 2011 · Triennial form not returned · Built 2007 · Whittle Norman VN34647Cessna 177B · S/N 17701921Cancelled Dec 14, 1999 · Triennial form not returned · Stevens Thomas VN191BAAdams Robert D AVID FLYER · S/N 91Cancelled Mar 9, 1994 · Fairbourn Lee RN8148MCessna 310I · S/N 310I0148Cancelled Jan 15, 1991 · Eagle Air CorporationN20007Taylorcraft F19 · S/N F-132Cancelled Feb 13, 1984 · Administratively canceled · Dahle Clyde MN4146CCessna 185A · S/N 1850411Cancelled Dec 3, 1976 · Exported to Canada · Built 1962 · Hurst J WN3354MPiper PA-12 · S/N 12-2197Cancelled Nov 30, 1976 · Exported to Canada · Hurst James WN3089HErcoupe 415-C · S/N 3714Cancelled May 19, 1965 · Built 1946 · Criddle Val GN50245Cessna T-50 · S/N 2805Cancelled Oct 21, 1955 · Built 1943 · Macarthur H TN53363Fairchild PT-26A · S/N FT-546Cancelled Apr 7, 1955 · Built 1943 · Evans Carl JN53387Cessna T-50 · S/N 2487Cancelled May 18, 1951 · Adams Beecher DN53364Cessna T-50 · S/N 2611Cancelled Feb 28, 1951 · Evans Carl JN16712Piper J-2 · S/N 720Cancelled Oct 2, 1941 · Built 1936 · Marston Keith
Back to Layton, UT