Medford, OR

Cancelled registrations · 210

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 = 'OR' AND d.registrant_city = 'MEDFORD'
  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.

N5175QKaman K-600 · S/N 129830Cancelled Nov 20, 2017 · Revoked, canceled · Built 1956 · Command Helicopters IncN5177QKaman OH-43D · S/N 129838Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5178QKaman OH-43D · S/N 138098Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5179QKaman OH-43D · S/N 138099Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5180QKaman OH-43D · S/N 138100Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5182QKaman OH-43D · S/N 139977Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5183QKaman HOK-1 · S/N 139978Cancelled Nov 20, 2017 · Revoked, canceled · Built 1957 · Command Helicopters IncN5184QKaman OH-43D · S/N 139981Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5186QKaman OH-43D · S/N 139983Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5187QKaman OH-43D · S/N 139984Cancelled Nov 20, 2017 · Revoked, canceled · Built 1956 · Command Helicopters IncN5188QKaman OH-43D · S/N 139988Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN28211Piper J4A · S/N 4-1133Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Forman Albert VN2844JKaman H-43A · S/N 58-1824Cancelled Oct 28, 2017 · Revoked, canceled · Command Helicopters IncN2845JKaman H-43A · S/N 58-1826Cancelled Oct 28, 2017 · Revoked, canceled · Command Helicopters IncN2846JKaman H-43A · S/N 58-1827Cancelled Oct 28, 2017 · Revoked, canceled · Built 1965 · Command Helicopters IncN2850JKaman H-43A · S/N 58-1832Cancelled Oct 28, 2017 · Revoked, canceled · Built 1965 · Command Helicopters IncN365RRidge Lowell H JAYBIRD · S/N 201Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 2005 · Multi-Mission LLCN45UReagan Roy D ONE DESIGN · S/N 94-0029Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Reagan Roy DN143BCQuicksilver SPORT 2S · S/N 0128Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2006 · Fleischman Robert WN9847Kaman HUK-1 · S/N 146308Cancelled Feb 13, 2017 · Revoked, canceled · Built 1958 · Command Helicopters IncN5164QKaman OH-43D · S/N 129805Cancelled Feb 4, 2017 · Revoked, pending cancellation · Command Helicopters IncN5173QKaman OH-43D · S/N 129828Cancelled Feb 4, 2017 · Revoked, pending cancellation · Built 1956 · Command Helicopters IncN693CKWharton Chris EXEC 90 · S/N 3223Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1997 · Wharton Chris VN767RMBeech D50C · S/N DH-251Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1960 · Hannan LarryN700WBeech E18S · S/N BA-54Cancelled Dec 24, 2014 · Registration expired, pending cancellation · Built 1955 · Federated Air Freight CorpN161RRCurtiss Aeroplane & Motor F6C-4 HAWK · S/N 7404Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Reagan Roy DN7798XCessna 172B · S/N 17248298Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1961 · Hirschy Don LN737ZMCessna 172N · S/N 17269802Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Piatt Lock JN6522FPiper PA-34-200T · S/N 34-7770031Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1976 · Dennis Ponte IncN58677Cessna 182P · S/N 18262228Cancelled Oct 30, 2014 · Second renewal notice · Built 1973 · Watson Robert PN3423VBeech 35 · S/N D-903Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1947 · Ray Offord LoggingN3178BBell 206L-3 · S/N 51033Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1983 · Briles Wing And Helicopter IncN65277Davis William H AVID FLYER · S/N 396Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1990N8356KRobinson Helicopter R22 BETA · S/N 2721Cancelled Apr 1, 2014 · Exported to Mexico · Built 1997 · Boyd Heli Leasing LLCN836EMMartin Lawrence H AVID-TRIGEAR-STOL · S/N 836Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1993 · Martin Lawrence HN4277LDouglas AD-4W · S/N 7946Cancelled Sep 28, 2013 · Registration expired, pending cancellation · Gill Cham SN8323KStinson 108-1 · S/N 108-1323Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1946 · Vanway Wayne DN334TTreadwell Walter L LANCAIR 235 · S/N 184Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1988 · Clark Donald AN726WMMacphee William T RV-6 · S/N 20246Cancelled Aug 22, 2013 · Sale reported, canceledN4591LCessna 310Q · S/N 310Q0733Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1973 · Wayne Van Wey HomesN25484Cessna 152 · S/N 15280687Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1977 · Winston JerryN2905WBell 47G-3B-2 · S/N 6820Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1971 · Culliton James MN6566HPiper J3C-65 · S/N 19758Cancelled Aug 7, 2013 · Revoked, canceled · Built 1946 · Hamilton James WN752DFQuicksilver SPORT 2 · S/N 000468Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1992N1988SCameron Balloons US O-84 · S/N 5254Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Thompson Tom NN44JLSchempp-Hirth K. G NIMBUS II · S/N 32Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1973 · Briggs Donald AN4110CCessna 177RG · S/N 177RG0588Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1974 · 177 Rg CoN9431PPiper PA-24-260 · S/N 24-4939Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1970 · Holst John HughN8316FHughes 369HS · S/N 460812SCancelled May 14, 2013 · Registration expired, pending cancellation · Built 1976 · Culliton James MN8039ZReading John H MONERAI-S · S/N 0084Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1980 · Ogier Ronald O
Back to Medford, OR