OpenAirDocs.org
Green Valley Aviation Inc

Earlier aircraft under this name · 20

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

Query with SQL
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 = 'GREEN VALLEY AVIATION INC' OR list_contains(d.other_registrant_names, 'GREEN VALLEY AVIATION INC')
  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.

N7695RBeech C23 · S/N M-1295Cancelled Feb 4, 2017 · Revoked, canceled · Built 1970 · Everett, WAN3032YCessna 182E · S/N 18254032Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1962 · Everett, WAN8387HAero Commander 680 · S/N 680-449-120Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1956 · Granite Falls, WAN7438XCessna 172B · S/N 17247938Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1960 · Granite Falls, WAN60092Cessna TU206F · S/N U20602004Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1973 · Granite Falls, WAN77WHMooney M20A · S/N 1251Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1958 · Granite Falls, WAN7608RBeech 19A · S/N MB-419Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1969 · Cranite Falls, WAN789ECMooney M20C · S/N 1965Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1961 · Granite Falls, WAN7226FPiper PA-28-140 · S/N 28-25138Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1968 · Granite Falls, WAN5976PPiper PA-24-250 · S/N 24-1069Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1959 · Granite Falls, WAN60194Cessna 150J · S/N 15070139Cancelled Mar 26, 2013 · Revoked, canceled · Built 1969 · Everett, WAN11758Cessna 150L · S/N 15075617Cancelled Jan 30, 2013 · Registration expired, pending cancellation · Built 1974 · Granite Falls, WAN40332Maule M-4-220C · S/N 2107CCancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1972 · Granite Falls, WAN5947LAmerican AA-1 · S/N AA1-0247Cancelled Aug 30, 2012 · Revoked, canceled · Built 1969 · Everett, WAN2420CCessna 180 · S/N 30720Cancelled Jul 14, 2009 · Registration revoked · Built 1954 · Everett, WAN1599JPiper PA-28-140 · S/N 28-24011Cancelled Jun 30, 2009 · Registration revoked · Built 1968 · Everett, WAN1354JRockwell International 112A · S/N 354Cancelled Jan 21, 1982 · Administratively canceled · Grante Falls, WAN8642PPiper PA-24-260 · S/N 24-4084Cancelled Jul 27, 1975 · Revoked, pending cancellation · Built 1964 · Everett, WAN88326Piper J3C-85 · S/N 15944Cancelled Jan 10, 1975 · Exported to Canada · Everett, WAN7672RBeech B23 · S/N M-1269Cancellation date not recorded · Everett, WA
Back to Green Valley Aviation Inc