Skip to content

Klamath Falls, OR

Cancelled registrations · 142

Query with SQL

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 = 'KLAMATH FALLS' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'KLAMATH FALLS'
  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.

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 = 'KLAMATH FALLS'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3056Aerospatiale SE3160 ALOUETTE III · S/N 1908Cancelled Mar 7, 2024 · Revoked, pending cancellation · Built 1971 · Jensen C T N900DBLockheed 1329-25 JETSTAR II · S/N 5225Cancelled Jun 28, 2023 · Built 1978 · Flying Piggs LLC N2512Mustang Copters MC · S/N A-101Cancelled Mar 3, 2023 · Revoked, canceled · Welker Perry L N6658WPiper PA-28-140 · S/N 28-20761Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1965 · Graham William T N7530BRobinson Helicopter R44 II · S/N 10390Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 2004 · Oho Cattle Company Inc N115GCYakovlev YAK 52 · S/N 9111308Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1991 · Yancey Monty Trustee N520BAIcon A5 · S/N 00047Cancelled Jul 15, 2021 · Exported to Russia · Built 2019 · Holliday Dean M Trustee N4878VBellanca 17-30 · S/N 30119Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1968 · Lindow Herman B N414RSCessna 414A · S/N 414A0821Cancelled Apr 3, 2020 · Registration pending, canceled · Built 1981 N787SBBryk Steven L VELOCITY XL-RG · S/N 3RX097Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 2003 · Cloud Catcher Properties Inc N117PTAdleman Lyle L PROTECH PT-2 · S/N PT1017Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1992 · Milani Gregory F N766UCDJI PHANTOM 3 ADVANCED · S/N OAF5757Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Cross Matthew D N770URDJI PHANTOM 3 ADVANCED · S/N P76DCD13010735Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Rose Gary Darrell N651YRHorizon Hobby BLADE CHROMA · S/N BC1004522Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Rose Gary Darrell N184SJBellet James J VANS RV-8 · S/N 81645Cancelled Apr 2, 2019 · Built 2003 · Bellet James J N902SPMaule M-5-210C · S/N 6181CCancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1976 · Fridinger William C N201KYMooney M20J · S/N 24-0462Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1978 · Corbett Joshua J N8479EBell 47G-3B · S/N 2649Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1961 · United Helicopters Inc N5440DWooding John W BARNETT J4B · S/N W-150Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1996 · Wooding John W N20370Frew John III FREW ZODIAC CH601 XL · S/N 5185Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2007 · Steinbock Dennis M N61361Consolidated Vultee BT-13A · S/N 5803Cancelled Feb 4, 2017 · Revoked, canceled · Built 1942 · Holst Arthur P N4187WRobinson Helicopter R22 BETA · S/N 4399Cancelled Feb 8, 2016 · Third renewal notice · Built 2008 · Oho Cattle Co Inc N5341KRyan NAVION B · S/N NAV-4-2241BCancelled May 20, 2015 · Registration expired, pending cancellation · Built 1950 · Schock Robert H N3HJJohnson Hoy D EVANS VP-1 · S/N V-2533Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1987 · Johnson Hoy D N8262QCessna TU206F · S/N U20603123Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1975 · New Earth Company N8062VCessna 180H · S/N 18052242Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Newman Richard K N7425DPiper PA-22-150 · S/N 22-5186Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1957 · Kennedy Michael L N4936VBellanca 17-30 · S/N 30144Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1968 · Barber Beryl N6253NBell 206A · S/N 127Cancelled Sep 22, 2014 · Revoked, canceled · Built 1967 · Juline Edward L N239MRAeronca 65-C · S/N C-5829Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1939 · Ruddock Martin E N87487Republic RC-3 · S/N 38Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1946 · Paulsen Kim J N6662QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1696Cancelled Sep 26, 2013 · Revoked, canceled · Built 1977 · Ireland Carl N6693GCessna 150L · S/N 15072193Cancelled Sep 26, 2013 · Revoked, canceled · Built 1970 · Mason Frank R N3176BBell 214ST · S/N 28116Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1983 · Global Rotors Inc N986BDHeimann B/Andrews D MODIFIED BD-4 · S/N 0001Cancelled Aug 21, 2013 · Sale reported, canceled N3765XAero Commander 100 · S/N 256Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1968 · Lewiston Marine Diesel N63519Boeing A75N1(PT17) · S/N 75-6934Cancelled Aug 6, 2013 · Revoked, canceled · Built 1942 · Jensen C T N8207Black CAVALIER SA-102 · S/N SA1026846Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1974 · Koepp Donald V N9740UGrumman American Avn. AA-5A · S/N AA5A-0140Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1976 N7624FPiper PA-34-200T · S/N 34-7770057Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1976 N5685Flocchini XF1-B · S/N 1Cancelled Feb 21, 2013 · Revoked, canceled · Built 1974 · Flocchini Lester A N75430Douglas DC3C · S/N 4490Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1941 N2868AChristen Industries A-1 · S/N 1003Cancelled Jan 29, 2013 · First renewal notice · Built 1987 · Alexander Marshall Jay N393LHempel Jeffrey D LANCAIR INTL LANCAIR · S/N LIV-327Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Hempel Jeffrey D N4812DCessna 182A · S/N 34912Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1958 N4077GBell 47G-3B-2 · S/N 6707Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1968 · Glbal Rotors Inc N3640HErcoupe E · S/N 4265Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1947 · Graham Sandra G N2582GCessna 182B · S/N 51882Cancelled Sep 18, 2012 · Registration expired, pending cancellation · Built 1959 · Gleason Peter R N2159UBrantly B-2B · S/N 320Cancelled Aug 22, 2012 · Registration pending, canceled · Built 1963 N1100QCessna 310H · S/N 310H0100Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 1963 · Wilcox James Carson

Back to Klamath Falls, OR