Skip to content

Cancelled registrations · 35

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 = 'WA' AND d.registrant_city = 'MARYSVILLE' 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 = 'WA' AND d.registrant_city = 'MARYSVILLE'
  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 = 'WA' AND d.registrant_city = 'MARYSVILLE'
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.

N1964CMaxair DRIFTER DR 440 · S/N 0101984Cancelled Aug 20, 2022 · Third renewal notice · Built 1985 · Chandler Brian E N19LSRolladen-Schneider LS-3 · S/N 3319Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1978 · Clark Ronald L N2301WBeech A23A · S/N M-902Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1965 · Gumke Devon A N750MMMccoy SONERAI-I · S/N 0288Cancelled Aug 29, 2019 · Sale reported, canceled · Built 1978 N361CDHytek HURRICANE · S/N H100876Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1995 · Platt Jerry R N2605PTeam MINIMAX 1500R · S/N MM231Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1999 · Nordmeyer Robert W N4789UCessna 180H · S/N 18051489Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Rainbow Salvage N539JWKolb FIRESTAR II · S/N FS 381Cancelled Sep 25, 2017 · Exported to Canada · Jones Stan J N2721RHurricane Hytek 103 · S/N 00615Cancelled Jul 19, 2017 · Registration expired, pending cancellation · Built 1999 · Hjort Alan C N4690MBeech C24R · S/N MC-585Cancelled May 8, 2017 · Third renewal notice · Built 1978 · Richardson William M Jr N4641DBeech G35 · S/N D-4810Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1956 · Rainbow Salvage Recovery N7711RPiper PA-18-150 · S/N 18-5381Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Brewer Joe L N185KKCessna A185F · S/N 18502983Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Rainbow Salvage N9036TCessna 182C · S/N 52936Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1960 · Rainbow Salvage N62454Stinson L-5 · S/N 76-382Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1943 · Horton Lena M N937CDCirrus Design SR20 · S/N 1249Cancelled Oct 21, 2014 · Exported to South Korea · Built 2002 · Newman Air LLC N900NKKnutson Neil K B1-RD · S/N AB-009Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1985 · Powers Harry R N456TCHeidtman D G / Golden K L AVID AMPHIBIAN · S/N 85ACancelled Aug 6, 2013 · Sale reported, canceled · Built 1991 N999WPCessna 414A · S/N 414A0526Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1980 · Rainbow Rotor Parts Inc N240MWWood Mark K MINI MAX · S/N 240MKCancelled May 16, 2013 · Registration expired, pending cancellation · Wood Mark K N8397SCessna 182H · S/N 18256497Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1965 · Rainbow Salvage & Recovery N76553Cessna 140 · S/N 10989Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1946 · Rainbow Salvage Recovery N4HLLindblom TAYLOR COOT-A · S/N HL-1Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Lindblom Hugo N III N3358DCessna 180 · S/N 32156Cancelled Jun 4, 2012 · Registration pending, canceled · Built 1955 N94296Cessna A185F · S/N 18503303Cancelled Apr 29, 2011 · Registration pending, pending cancellation · Built 1977 N7055FCessna 150F · S/N 15063655Cancelled Mar 8, 2010 · Exported to Canada · Built 1966 · Rush Stephen D N540ACCessna 172R · S/N 17280040Cancelled Mar 9, 2006 · Exported to Canada · Built 1997 · Aircraft Rental Services LLC N9082QBeech A36 · S/N E-242Cancelled May 26, 1999 · Rainbow Salvage & Recovery Inc N1142Dean A Case PITTS SPECIAL · S/N 1114Cancelled Jul 24, 1997 · Longdon Russell T N816SCBell UH-1B · S/N 610738Cancelled Sep 29, 1995 · Exported to Argentina · Snohomish County Volunteer N4481UCessna 150D · S/N 15060481Cancelled Sep 15, 1975 · Built 1964 · Andersen Earl C N87278Ercoupe 415-C · S/N 451Cancelled Jun 6, 1974 · Exported to Canada · Built 1946 · Sarvis Wayne T N3139XCessna 150G · S/N 15064539Cancelled Dec 11, 1973 · Built 1967 · Marr Orland E N6636JPiper PA-28-180 · S/N 28-5103Cancelled Sep 14, 1973 · Cross Wayne R N72194Cessna 140 · S/N 9367Cancelled Aug 17, 1965 · Exported to Canada · Cataford R G

Back to Marysville, WA