Skip to content

Earlier aircraft under this name · 50

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 = 'VINSON JAN M' OR list_contains(d.other_registrant_names, 'VINSON JAN M') 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 = 'VINSON JAN M' OR list_contains(d.other_registrant_names, 'VINSON JAN M')
  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 = 'VINSON JAN M' OR list_contains(d.other_registrant_names, 'VINSON JAN M')
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.

N1171SSchweizer SGS 1-34 · S/N 71Cancelled Aug 11, 1987 · Administratively canceled · Poole William L Jr, San Diego, CA N11137Cessna 150L · S/N 15075214Cancelled Feb 12, 1985 · Administratively canceled · United States Air Force Owner, Apo New York, NY N1164EBellanca 7KCAB · S/N 615-77Cancelled Feb 12, 1985 · Administratively canceled · Long Eugene H DBA, King City, CA N11457Cessna 150L · S/N 15075436Cancelled Oct 3, 1984 · Administratively canceled · University Of N H Flying Club, Durham, NH N11539Cessna 150L · S/N 15075501Cancelled Aug 6, 1984 · Administratively canceled · Carter Joy B, Tavernier, FL N1172QCessna A185F · S/N 18503467Cancelled Jul 11, 1984 · Administratively canceled · Shaw Don, Loranger, LA N11207Cessna 150L · S/N 15075254Cancelled Jun 15, 1984 · Administratively canceled · Isla Grande Flg School & Serv Corp, Hato Rey, PR N1183JAero Commander 112 · S/N 160Cancelled Jun 15, 1984 · Administratively canceled · Hinton Jack Dr, Eufaula, AL N1164JRockwell International 112A · S/N 176Cancelled May 26, 1984 · Administratively canceled · Warren Donald W, Clinton, AR N11NKCessna 310A · S/N 38064Cancelled Apr 17, 1984 · Administratively canceled · U S Air Force Owner, Randolph Afb, TX N1108RRaven S55A · S/N S55A-291Cancelled Mar 10, 1984 · Administratively canceled · Raven Industries Inc, Sioux Falls, SD N115SMitsubishi MU-2B-30 · S/N 518Cancelled Mar 10, 1984 · Administratively canceled · Richards & Associates Inc, Carrollton, GA N11439Cessna 150L · S/N 15075422Cancelled Nov 23, 1983 · Administratively canceled · Air Service Caravan Co Inc, New Bedford, MA N11MUUdall HELICOM COMMUTER JR · S/N 11Cancelled Nov 23, 1983 · Administratively canceled · Stewart Robert J, Camarillo, CA N11KQGrumman American Avn. G-164 · S/N 106Cancelled Aug 2, 1983 · Administratively canceled · Commercial Leasing Inc, Hughes, AR N1119XPiper PA-32-300 · S/N 32-7540145Cancelled Jun 25, 1983 · Administratively canceled · L A B Flying Service Inc, Haines, AK N111WKKleinbauer WAKE ISLAND SCORPION · S/N WJK-1-74Cancelled Jun 25, 1983 · Administratively canceled · Kleinbauer William J, Hawthorne, CA N1160QCessna T210L · S/N 21059660Cancelled Jun 25, 1983 · Administratively canceled · Upanaway Aircraft Corporation, Seattle, WA N112DHCessna 337A · S/N 337-0256Cancelled Apr 16, 1983 · Administratively canceled · Vaughan William A Jr, Canton, MS N11624Cessna 150L · S/N 15075578Cancelled Apr 16, 1983 · Administratively canceled · Taylorcraft Flying Club Inc, Tigard, OR N11217Cessna 150L · S/N 15075260Cancelled Jan 15, 1983 · Administratively canceled · Berham & Bernham, Rosalia, WA N1180Beech C-45H · S/N AF-750Cancelled Dec 31, 1982 · Administratively canceled · Fabre Enterprises Inc, Austin, TX N110EFEllis & Farrar WEEDHOPPER-B · S/N 116Cancelled Dec 18, 1982 · Administratively canceled · Farrar Leonard O, Bastrop, LA N114KBeech E-90 · S/N LW-122Cancelled Dec 18, 1982 · Administratively canceled · Butler Johnson Inc, Shreveport, LA N1130YCessna 150 · S/N 15059530Cancelled Dec 11, 1982 · Administratively canceled · Hoeft Gary A, Hamburg, MI N1099PPiper PA-23 · S/N 23-109Cancelled Dec 9, 1982 · Administratively canceled · Warner Ted K, Lancaster, CA N110SQBell 47G-3B · S/N 3100Cancelled Dec 5, 1982 · Administratively canceled · Ohio State University, Columbus, OH N11633Cessna 150L · S/N 15075586Cancelled Nov 6, 1982 · Administratively canceled · Hoops Aviation, Pasco, WA N111NTCessna 320D · S/N 320D0093Cancelled Oct 30, 1982 · Administratively canceled · Banks Harold N, Republic, WA N11424Cessna 150L · S/N 15075410Cancelled Oct 24, 1982 · Administratively canceled · Greenway Scott, Springer, OK N1127CPiper PA-22-135 · S/N 22-962Cancelled Oct 2, 1982 · Administratively canceled · Schott Norman L, Lexington, KY N110SCBell 47G-3B-1 · S/N 3419Cancelled Sep 16, 1982 · Administratively canceled · Berkeley County Disaster Prep Agency, Moncks Corner, SC N11112Funkhouser COUGAR 1 · S/N 10201Cancelled Aug 12, 1982 · Administratively canceled · Judson Arthur T, Stony Brook, NY N1173UCessna 172M · S/N 17266874Cancelled Aug 12, 1982 · Administratively canceled · Young Kenneth, Fresno, CA N11586Cessna 150L · S/N 15075542Cancelled May 8, 1982 · Administratively canceled · Sherban Laurie, Sterling Hts, MI N11013Cessna 150L · S/N 15075194Cancelled Apr 15, 1982 · Administratively canceled · Sulland Marion, Richmond, MO N110RACessna 340A · S/N 340A0315Cancelled Apr 15, 1982 · Administratively canceled · Staal Leasing Inc, Grand Rapids, MI N11275Cessna 150L · S/N 15075292Cancelled Apr 15, 1982 · Administratively canceled · Skyline Motors Aviation Services Inc, Beaver Falls, PA N1131XPiper PA-28-151 · S/N 28-7515391Cancelled Jan 21, 1982 · Administratively canceled · Merritt Island Air Service Inc, Merritt Island, FL N116DWBritten-Norman BN-2A · S/N 202Cancelled Oct 22, 1981 · Administratively canceled · Dorado Wings Inc, Dorado Beach, PR N11164Cessna 150L · S/N 15075234Cancelled Oct 15, 1981 · Administratively canceled · Costa Joseph DBA, Painted Post, NY N114RADehavilland BEAVER DHC-2 MK.1 · S/N 1346Cancelled Oct 15, 1981 · Administratively canceled · United States Navy, San Diego, CA N1107JAero Commander 112 · S/N 107Cancelled Jun 13, 1981 · Administratively canceled · Rockwell International Corporation, Bethany, OK N1148PPiper PA-23-150 · S/N 23-161Cancelled Jun 13, 1981 · Administratively canceled · The Gerardin Corp DBA, Torrance, CA N11BRPiper PA-24-250 · S/N 24-3504Cancelled Jun 13, 1981 · Administratively canceled · Dickson Ivan R, Yorkville, IL N1108LConsolidated Aeronautics LAKE LA-4 · S/N 699Cancelled Jun 6, 1981 · Administratively canceled · Hartig Robert L, Anchorage, AK N1135WBell 47G-3B-1 · S/N 2932Cancelled Jun 6, 1981 · Administratively canceled · Rah Corporation DBA, Burbank, CA N11474Cessna 150L · S/N 15075446Cancelled Jun 6, 1981 · Administratively canceled · Dennis Lawrence W, Des Moines, IA N1171XBeech 3 TM · S/N CA-167Cancelled Jun 6, 1981 · Administratively canceled · Rhoades Aviation Inc, Columbus, IN N1122KBrantly B-2B · S/N 422Cancelled Aug 16, 1980 · Administratively canceled · Mortensen Bryan F, Algona, IA

Back to Vinson Jan M