OpenAirDocs.org
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.

N7185JRobinson Helicopter R44 · S/N 0702Cancelled May 13, 2026 · Registration pending, canceled · Built 1999N105FPMaule M-7-260C · S/N 30036CCancelled Jun 30, 2025 · Registration pending, canceled · Built 2005N775MWPartenavia P 68 C/TC · S/N 208.01Cancelled Feb 22, 2024 · Exported to Canada · Built 1979 · Gv Air IncN22387Piper PA-23-250 · S/N 27-7754065Cancelled Dec 24, 2022 · Built 1977 · Gv Air IncN5152UCessna 206 · S/N 206-0152Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1964 · Skinner Leasing LLCN303GBNorth American T-28C · S/N 140058Cancelled Feb 3, 2021 · Exported to France · Built 1955 · Burrill Gladys O TrusteeN237ACErickson S-64F · S/N 64095Cancelled Jun 25, 2020 · Exported to Italy · Built 1970 · Erickson IncN63868Piper PA-23-250 · S/N 27-7854020Cancelled Apr 14, 2020 · First renewal notice · Built 1978 · Gv Air IncN6014QBeech 76 · S/N ME-153Cancelled Mar 19, 2020 · First renewal notice · Built 1979 · Gv Air IncN320MFCessna 320D · S/N 320D0061Cancelled Feb 14, 2020 · First renewal notice · Built 1965 · Gv Air IncN4812VBoeing E75 · S/N 75-5370Cancelled Dec 30, 2019 · Revoked, canceled · Warren WilliamN118MFBeech C90 · S/N LJ-1383Cancelled Sep 27, 2019 · First renewal notice · Built 1994 · Mercy Flights IncN135MTDJI PHANTOM 3 PROFESSION · S/N P76DCD19010566Cancelled Jul 11, 2019 · Registration expired, pending cancellation · Mha LLCN31177Striplin KR-II · S/N KRS-68Cancelled May 4, 2019 · Revoked, canceled · Built 1975 · Striplin Kenneth RN8302HEmigh TROJAN A-2 · S/N 5Cancelled Jan 28, 2019 · Revoked, canceled · Built 1948 · Nelson Dorothy MaeN350SBEurocopter AS 350 BA · S/N 2196Cancelled Dec 4, 2018 · Registration expired, pending cancellation · Built 1989 · T Scott Dunn Construction IncN4099MErickson S64E · S/N 64028Cancelled Oct 19, 2018 · Exported to South Korea · Built 1967 · Erickson IncN80930Globe GC-1B · S/N 1123Cancelled Sep 21, 2018 · Revoked, canceled · Built 1946 · Scott Henry LN80685Globe GC-1B · S/N 1090Cancelled Sep 20, 2018 · Revoked, canceled · Built 1946 · Scott Henry LN29045Striplin MODEL "A" · S/N 763Cancelled Aug 9, 2018 · Revoked, canceled · Built 1976 · Striplin Paul AN5189QKaman OH-43D · S/N 139989Cancelled May 18, 2018 · Revoked, canceled · Command Helicopters IncN5191QKaman OH-43D · S/N 139991Cancelled May 18, 2018 · Revoked, canceled · Command Helicopters IncN5192QKaman OH-43D · S/N 139994Cancelled May 18, 2018 · Revoked, canceled · Command Helicopters IncN5193QKaman OH-43D · S/N 139995Cancelled May 18, 2018 · Revoked, canceled · Command Helicopters IncN5194QKaman OH-43D · S/N 139997Cancelled May 18, 2018 · Revoked, canceled · Command Helicopters IncN5195QKaman OH-43D · S/N 139998Cancelled May 18, 2018 · Revoked, canceled · Command Helicopters IncN5196QKaman OH-43D · S/N 139999Cancelled May 18, 2018 · Revoked, canceled · Command Helicopters IncN4342VCessna 190 · S/N 7248Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1948 · Hendricks Cassandra LN333MFAero Vodochody L39C · S/N 931520Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1979 · Blue Sky CompanyN5197QKaman OH-43D · S/N 140001Cancelled Mar 1, 2018 · Revoked, canceled · Command Helicopters IncN125HMVinces WEEDHOPPER · S/N 1Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2007 · Burrill Rodney WN8270APiper PA-30 · S/N 30578Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Airtime CorporationN421FLCessna 421B · S/N 421B0527Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1974 · Vd 680 LLCN999DBNavion NAVION H · S/N NAV-4-2527Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1969 · Briggs Donald AN155GCessna 310C · S/N 35909Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1959 · Reagan Roy DN2848JKaman H-43A · S/N 58-1829Cancelled Nov 22, 2017 · Revoked, canceled · Built 1969 · Command Helicopters IncN2852JKaman H-43A · S/N 58-1835Cancelled Nov 22, 2017 · Revoked, canceled · Built 1965 · Command Helicopters IncN2854JKaman H-43A · S/N 58-1838Cancelled Nov 22, 2017 · Revoked, canceled · Built 1958 · Command Helicopters IncN5169QKaman OH-43D · S/N 129818Cancelled Nov 21, 2017 · Revoked, canceled · Command Helicopters IncN5170QKaman OH-43D · S/N 129823Cancelled Nov 21, 2017 · Revoked, canceled · Command Helicopters IncN5160QKaman OH-43D · S/N 125528Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5162QKaman OH-43D · S/N 129803Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5163QKaman OH-43D · S/N 129804Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5165QKaman OH-43D · S/N 129806Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5166QKaman HOK-1 · S/N 129813Cancelled Nov 20, 2017 · Revoked, canceled · Built 1954 · Command Helicopters IncN5167QKaman OH-43D · S/N 129815Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5168QKaman OH-43D · S/N 129817Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5171QKaman OH-43D · S/N 129825Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5172QKaman OH-43D · S/N 129827Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters IncN5174QKaman OH-43D · S/N 129829Cancelled Nov 20, 2017 · Revoked, canceled · Command Helicopters Inc
Back to Medford, OR