Skip to content

Coeur D Alene, ID

Cancelled registrations · 43

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 = 'ID' AND d.registrant_city = 'COEUR D ALENE' 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 = 'ID' AND d.registrant_city = 'COEUR D ALENE'
  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 = 'ID' AND d.registrant_city = 'COEUR D ALENE'
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.

N423STBurns Fletcher A SONERAI II L · S/N FB01041Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1984 · Avon Robert W N575DADJI PHANTOM 3 PROFESSION · S/N P78DCF12032326Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Salvation Army Kroc Center N6602BCessna 310B · S/N 35702Cancelled Mar 8, 2022 · Second renewal notice · Built 1958 · Inceptus Inc N2106KDehavilland DHC-2 MK. I(L20A) · S/N 1131Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1956 · Brooks Seaplane Service Inc N848MGSidney G Goodwin BUETO 1 · S/N 4102018Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Goodwin Sidney G N628SRidenhour Jan W SEEKER ONE 85A · S/N S0001ACancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 2004 · Ridenhour Jan W N235SPSchaefer D F / Pelland P G LANCAIR 235 · S/N 52Cancelled Dec 17, 2019 · Exported to Argentina · Built 1993 · Schaefer Daniel E N3210ACessna 170B · S/N 25854Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1953 · Inceptus Inc N723PWDJI PHANTOM 2 VISION + · S/N PH645375081 V2.0Cancelled Jun 25, 2019 · Second renewal notice · Welch Comer Engineers N166TABrown L O Pat STAR-LITE · S/N 166Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1987 · Goodwin Sidney G N521JHHarrison Stanley HARRISON S-7 COURIER · S/N 1096210Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 2004 · Harrison Stanley N6745FCessna 150F · S/N 15063345Cancelled Sep 26, 2013 · Revoked, canceled · Built 1966 · Smith James C N311DHBell 430 · S/N 49067Cancelled Jul 9, 2013 · Exported to Turkey · Built 2000 · Hagadone Helicopters LLC N9GBSemco Balloon CHALLENGER · S/N SEM104Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1973 · Stuart Thomas J N8698ZCessna P206C · S/N P206-0498Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1968 · Hunt Bros Construction Inc N75LPPickrell A Larry LM-1 · S/N 1Cancelled Jun 25, 2012 · Triennial form not returned · Built 1991 · Tennison Rory N156SSSolan Thomas A STORCH · S/N 0001Cancelled Nov 22, 2010 · Solan Thomas A N25016Semco Balloon T · S/N SEM70Cancelled Jul 16, 2009 · Registration revoked · Built 1972 · Semco Balloon N5885CBeech E-55 · S/N TE868Cancelled Jul 24, 2008 · Built 1972 · Wasti Hamid A N222DGFairchild F-27F · S/N 31Cancelled Sep 26, 2005 · Triennial form not returned · Built 1958 · Empire Airlines Inc N789LMCessna 182S · S/N 18280043Cancelled Sep 20, 2005 · Exported to Canada · Lunceford Earl G Trustee N4073ZPiper PA-18-150 · S/N 18-8086Cancelled Aug 21, 2002 · Exported to Canada · Built 1964 · Hall William H N3071RPiper PA-28R-200 · S/N 28R35632Cancelled Jun 15, 1998 · Munkittrick Mark G N6217FBallard Larry CHALLENGER II · S/N CH20995L392Cancelled May 12, 1998 · Exported to Canada · Ballard Larry A N5919YPiper PA-23-250 · S/N 273076Cancelled Mar 15, 1996 · Pope Kent M N903TBeech 95-55 · S/N TC42Cancelled Aug 28, 1992 · Triennial form not returned · Christianson Perry A N8109BCessna 172 · S/N 29909Cancelled Mar 13, 1991 · Triennial form not returned · Hempen Robert L N8744QCessna U206F · S/N U20603497Cancelled Jul 3, 1984 · Administratively canceled · Pulis Builders Inc N2204FPiper PA-28-181 · S/N 28-7990192Cancelled Jul 26, 1980 · Built 1979 · Crawley David B N8556Semco Balloon T · S/N SEM 79Cancelled Sep 23, 1974 · Semco Balloon Mark Semich N7458YPiper PA-30 · S/N 30-521Cancelled Feb 9, 1971 · Jaeger Joseph Jr N1624APiper PA-18A · S/N 18-1269Cancelled Jun 14, 1960 · Kadoun Kenneth R N2000MPiper PA-11 · S/N 11-2Cancelled Oct 4, 1955 · Brooks William R N3350BPiper PA-18 · S/N 18-3303Cancelled Aug 4, 1955 · Exported to United Kingdom · Brooks William R N3801MPiper PA-12 · S/N 12-2560Cancelled Aug 10, 1951 · Aviation Industries Inc N33904Taylorcraft BC12-65 · S/N 2755Cancelled Mar 7, 1950 · O A Wartenberg N49144Aeronca 0-58B · S/N 058B-4062Cancelled Dec 22, 1949 · Lents Percy M N73496Fairchild PT-23-AE · S/N 3113AECancelled Nov 12, 1949 · Schneberger Ed C N297YFairchild 24W-40 · S/N W40-127Cancelled Sep 30, 1949 · Aviation Industries Inc N30115Waco UPF-7 · S/N 5512Cancelled Jul 18, 1949 · Aviation Industries Inc N73497Fairchild PT-23 · S/N 1183AECancelled May 10, 1949 · Robinson James B N2805HEngineering & Research ERCOUPE 415-C · S/N 3430Cancelled Apr 22, 1949 · Aviation Industries Inc N29319Waco UPF-7 · S/N 5346Cancelled Jun 9, 1948 · Aviation Industries Inc

Back to Coeur D Alene, ID