Skip to content

Cancelled registrations · 132

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 = 'MT' AND d.registrant_city = 'KALISPELL' 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 = 'MT' AND d.registrant_city = 'KALISPELL'
  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 = 'MT' AND d.registrant_city = 'KALISPELL'
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.

N9009RSkykits USA SAVANNAH VG · S/N 05-10-51-432Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 2006 · Buck Properties LLC N15321Piper PA-28-140 · S/N 28-7325039Cancelled Mar 6, 2020 · Registration pending, canceled · Built 1972 N19366Cessna 150L · S/N 15074368Cancelled Feb 21, 2020 · Sale reported, canceled · Built 1973 N1780TPiper PA-28-140 · S/N 28-7125095Cancelled Mar 16, 2019 · Registration pending, canceled · Built 1970 N190CPNelson Leon CHICKEN PLUCKER · S/N LN1FEB86Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Built 1986 · Colby Clayton L N577LMaule M-5-235C · S/N 7083CCancelled Dec 10, 2018 · Registration expired, pending cancellation · Built 1977 · Mason Nicholas A N12769Cessna 172M · S/N 17262243Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1973 N93235Rearwin 185 · S/N 1740Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Kalispell Flying Club N3285WBalloon Works FIREFLY 8B-15 · S/N F8B-509Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1996 · Lets Go Ballooning Inc N44095Quicksilver SPORT MXL · S/N 255Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1998 · Gerke Russell L N77ZFCavin O. H. THORP T-18 · S/N 249Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1980 · Cassutt Aerobatics LLC N829LGGerek Larry CHALLENGER II LONG · S/N CHII-1204-2566Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 2007 · Rahn Robert K N8186PPiper PA-24-250 · S/N 24-3442Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1963 · Hay Glen R N1CDCessna T337D · S/N 337-1124Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1969 · Diamond Aire LLC N118GGGreen Gary E THORP T-18 · S/N 949Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1980 · Flatter David E N6948RCessna T210H · S/N T210-0348Cancelled Sep 27, 2017 · Exported to Colombia · Built 1968 · Lhp West Investments LLC N216JWWegener James D GLASAIR SUPER II RG · S/N 2304Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Wegener James D N76VGRobinson Helicopter R44 II · S/N 12127Cancelled Sep 13, 2017 · Exported to Indonesia · Built 2008 · Lhp West Investments LLC N4142PPiper PA-23-160 · S/N 23-1623Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 1959 · Diamond Aire LLC N63ACBeech C35 · S/N D-3279Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1952 · Air-Ray Corp N2596TVon Delius C Christian ALPINE TRIKE · S/N CVD001Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Von Delius C Christian N7FGBeech A36TC · S/N EA-250Cancelled Sep 27, 2016 · Built 1981 · Kavak Aviation LLC N508FFouga 6 CM 170 · S/N 508Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1966 · Xxst Century N511FMFouga CM 170 MAGISTER · S/N 511Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1966 · Xxst Century N4317PPiper PA-23-160 · S/N 23-1818Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1959 · Diamond Aire LLC N82139Piper PA-31T · S/N 31T-7720040Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1977 · S&H Sales N860CDCano David AVID FLYER · S/N 860Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1991 · Cano David N88095Bellanca 8GCBC · S/N 75-74Cancelled Feb 20, 2015 · First renewal notice · Built 1974 · Hay Glen R N9013ZPiper PA-23-250 · S/N 27-7405335Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1974 · Carley William J N12QJBallhagen/Shyrock QUICKIE Q-2 · S/N A2876Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1986 · Hudak David G N51PPPiper PA-23 · S/N 23-513Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1956 · Concept 360 Inc N127TPBell 206B · S/N 2582Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1978 · Tp Helicopter LLC N50TATemco D-16 · S/N TTN-16Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1948 · Lucas Harold L N38906Piper PA-28R-201T · S/N 28R-7703283Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1977 · Seaman Michael V N695NSCessna 150H · S/N 15067659Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1967 N48105Bell OH-13S · S/N 3252Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1964 · Carley Bill J N48339Aeronca 0-58B · S/N 058B2962Cancelled Nov 13, 2012 · Revoked, canceled · Built 1942 · Ertz Ralph N1255HAeronca 15AC · S/N 15AC-267Cancelled Jun 14, 2012 · Registration expired, pending cancellation · Built 1948 · Spurgeon Clinton W DBA N3331PPiper PA-23-160 · S/N 23-1282Cancelled Oct 28, 2011 · Exported to Canada · Built 1958 · Talmage John R N17LWBell 407 · S/N 53488Cancelled Jan 27, 2011 · Exported to Canada · Built 2001 · Wilson Aviation LLC N206SMCessna U206G · S/N U20606459Cancelled Mar 19, 2009 · Triennial form not returned · Built 1982 · Edwards Jet Center Of Montana N64187Cessna 172M · S/N 17265073Cancelled Apr 18, 2008 · Exported to Philippines · Built 1975 · Yager Greg J N52BTHeckel Robert P AIR WAGON · S/N 101Cancelled Sep 24, 2007 · Exported to Canada · Built 1999 · Heckel Robert P N71FSchempp-Hirth K. G NIMBUS II · S/N 34Cancelled Jul 16, 2007 · Exported to Argentina · Built 1973 · Baier Larry S N8825DPiper PA-22-160 · S/N 22-5994Cancelled Aug 8, 2006 · Exported to Canada · Built 1958 · Santa Scott J N87BCCreitz Robert D RV-3 · S/N RC-1-57Cancelled Apr 5, 2006 · Triennial form not returned · Built 1980 · Young David E N17CEJackson William C CHRISTEN EAGLEII · S/N 0001-JCancelled Aug 25, 2005 · Exported to Canada · Built 1982 · Mcadams Richard T N1612WAvian Balloon SKYHAWK · S/N 146Cancelled Jun 29, 2005 · Triennial form not returned · Fantasy Flights LLC N630WRRistine Wayne L MURPHY RENEGADE · S/N 630Cancelled Aug 26, 2002 · Exported to Germany · Ristine Wayne L N4DXDuncan BABY HORNET DX4 · S/N 1Cancelled Oct 27, 2000 · Triennial form not returned · Suarez Robert Murray

Back to Kalispell, MT