Skip to content

Earlier aircraft under this name · 96

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'DECKER ANNE' OR list_contains(d.other_registrant_names, 'DECKER ANNE') 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_name = 'DECKER ANNE' OR list_contains(d.other_registrant_names, 'DECKER ANNE')
  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_name = 'DECKER ANNE' OR list_contains(d.other_registrant_names, 'DECKER ANNE')
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.

N2284RCessna T210J · S/N T210-0434Cancelled Aug 23, 1989 · Administratively canceled · Kruse Charles A, Hacienda Heights, CA N25853Cessna 152 · S/N 15280818Cancelled May 19, 1986 · Administratively canceled · Wallace Allan Wayne, Clearwater, FL N2140HBalloon Works FIREFLY 6B · S/N 505Cancelled Aug 8, 1985 · Administratively canceled · Ruppert Jon L, Taylorville, IL N2114QCessna 177RG · S/N 177RG0514Cancelled Jul 25, 1985 · Administratively canceled · Abbey Barbara J, Yorba Linda, CA N2146CCessna 177B · S/N 17702741Cancelled Jul 25, 1985 · Administratively canceled · Shinn Charles M Jr, Winter Haven, FL N2239MPiper PA-28-161 · S/N 28-7816259Cancelled Jul 25, 1985 · Administratively canceled · Twidwell George E, Rancho Palos Verde, CA N2260CHovey-Robert BUSHWACKER · S/N 001Cancelled Jul 25, 1985 · Administratively canceled · Hovey Robert W, Agua Dulce, CA N2293BMeade-James MITCHELL WING B-10 · S/N 101Cancelled Jul 25, 1985 · Administratively canceled · Meade James M, Porterville, CA N25838Cessna 152 · S/N 15280810Cancelled Jul 25, 1985 · Administratively canceled · Windham Ralph Edwin, Fort Worth, TX N25134Benjamin RAND-ROBINSON KR-2 · S/N 1594Cancelled Feb 20, 1985 · Administratively canceled · Benjamin Brian S, Spartanburg, SC N238CSAmerican AA-1 · S/N AA1-0150Cancelled Feb 12, 1985 · Administratively canceled · Cleveland Board Of Education, Cleveland, OH N2616HSchweizer SGS 2-33A · S/N 426Cancelled Jan 23, 1985 · Administratively canceled · Civil Air Patrol Inc, Maxwell Afb, AL N21369Cessna A185F · S/N 18503055Cancelled Jan 8, 1985 · Administratively canceled · Cape Smythe Air Service, Barrow, AK N22848Cessna 150H · S/N 15068561Cancelled Jan 8, 1985 · Administratively canceled · Triangle Aviation Service Inc, Eustis, FL N24023Beech C24R · S/N MC-485Cancelled Jan 8, 1985 · Administratively canceled · Roy John W, West Dundee, IL N2522YCessna 172D · S/N 17249822Cancelled Jan 8, 1985 · Administratively canceled · Bull Steve Wayne, Grand Prairie, TX N25782Cessna 152 · S/N 15280782Cancelled Jan 8, 1985 · Administratively canceled · Gallaway Dolores D, Paradise Valley, AZ N2638SCessna T337C · S/N 337-0938Cancelled Jan 8, 1985 · Administratively canceled · Mizokami Bros Of Arizona Inc, Blanca, CO N21932Cessna 150L · S/N 15074547Cancelled Dec 11, 1984 · Administratively canceled · Clapsaddle Ronald E, Papillio, NE N234JSCessna 175 · S/N 55489Cancelled Dec 11, 1984 · Administratively canceled · Stockhill Aviation Inc, Kalispell, MT N2214XPiper PA-28-161 · S/N 28-7916352Cancelled Oct 26, 1984 · Administratively canceled · Sunset Aviation Inc, Burley, ID N2193DBeech D18S · S/N A-971Cancelled Oct 25, 1984 · Administratively canceled · Conatser Bennie, Perris, CA N2197FPiper PA-44-180 · S/N 44-7995189Cancelled Oct 25, 1984 · Administratively canceled · Odofin Abayomi A, Miami, FL N2297ZNess A K VOLMER VJ22 · S/N N1S1Cancelled Oct 25, 1984 · Administratively canceled · Sterling William C, Mechanicsville, VA N23016Cessna 150H · S/N 15068679Cancelled Oct 25, 1984 · Administratively canceled · Ruzicka John, Kokomo, IN N258MDouglas DC3C-S1C3G · S/N 9555Cancelled Oct 25, 1984 · Administratively canceled · Skytrain Air Inc, Mcallen, TX N9027MNielsen Carl S QUICKIE · S/N 0339Cancelled Oct 25, 1984 · Administratively canceled · Nielsen Carl S, Middletown, CA N214GBDouglas R4D-6 · S/N 26388Cancelled Oct 5, 1984 · Administratively canceled · Usda Forest Service, Washington, DC N2590APiper PA-22-135 · S/N 22-856Cancelled Oct 5, 1984 · Administratively canceled · Hawarden Flying Club Inc, Hawarden, IA N2259PKelly-George WHING DING II · S/N 1Cancelled Oct 3, 1984 · Administratively canceled · Kelly George F, Torrance, CA N2626NCessna 140 · S/N 12884Cancelled Oct 3, 1984 · Administratively canceled · Mcdowell David, Salem, OR N2472UCessna 172D · S/N 17250072Cancelled Aug 23, 1984 · Administratively canceled · Trowhill Richard L, Bad Axe, MI N26VEBeasley Gerald L VARIEZE · S/N 1362Cancelled Aug 20, 1984 · Administratively canceled · Beasley Gerald L Jr Md, Duncan, OK N2514FChampion 7ECA · S/N 7ECA-131Cancelled Aug 15, 1984 · Administratively canceled · Decathlon Aviation Inc, Vicksburg, MS N21869Cessna 172M · S/N 17264037Cancelled Aug 11, 1984 · Administratively canceled · Sawyer Aldrich W, Haverhill, MA N21738Cessna A188B · S/N 18800994TCancelled Aug 6, 1984 · Administratively canceled · Agrotor Spraying Services Inc, Milford, KS N2145ZCessna 180F · S/N 18051245Cancelled Aug 1, 1984 · Administratively canceled · Wuksinich Stephen F, North Pole, AK N2627UCessna 501 · S/N 501-0247Cancelled Aug 1, 1984 · Administratively canceled · Cessna Aircraft Co Wallace Div, Wichita, KS N21537Piper PA-28-181 · S/N 28-7990053Cancelled Jul 13, 1984 · Administratively canceled · American Aviation Inc, Brooksville, FL N2317YCessna 177 · S/N 17700117Cancelled Jul 13, 1984 · Administratively canceled · Harder Ralph N, Maryville, TN N233MAMitsubishi MU-2B-25 · S/N 251Cancelled Jul 11, 1984 · Administratively canceled · Brigadier Industries Corp, Nashville, NC N2450WSchweizer SGS 2-32 · S/N 50Cancelled Jul 11, 1984 · Administratively canceled · Indrebo E J DBA, Calistoga, CA N253EECessna Wren 182K460 · S/N 18258247Cancelled Jul 11, 1984 · Administratively canceled · Hollers Ranch Co, Cody, NE N2569Browing BENSEN B-8M · S/N 1Cancelled Jul 11, 1984 · Administratively canceled · Browning Walter A, Hope Valley, RI N2259JCessna 150G · S/N 15065459Cancelled Jul 3, 1984 · Administratively canceled · Strang Air Inc, Chadron, NE N2411SCessna 337B · S/N 337-0711Cancelled Jul 3, 1984 · Administratively canceled · Bursell Harold A, Medford, OR N221FBCessna R172E · S/N R1720206Cancelled Jun 15, 1984 · Administratively canceled · Fort Bliss Flying Club, Biggs Army Airfld, TX N2428ECessna 172N · S/N 17271279Cancelled Jun 15, 1984 · Administratively canceled · Snohomish Flying Service Inc, Snohomish, WA N2534HSchweizer SGS 2-33A · S/N 434Cancelled Jun 15, 1984 · Administratively canceled · Andersen Jorgen, El Paso, TX N2122ZPiper PA-28RT-201T · S/N 28R-7931147Cancelled Jun 2, 1984 · Administratively canceled · Long Richard DBA, Hobbs, NM

Back to Decker Anne