Riviere James A Jr

Earlier aircraft under this name · 58

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 = 'RIVIERE JAMES A JR' OR list_contains(d.other_registrant_names, 'RIVIERE JAMES A JR')
  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.

N9271Enstrom F-28A · S/N 246Cancelled Sep 17, 1990 · Administratively canceled · Fluet Romeo E, Hollis, NHN9513DPiper PA-22-160 · S/N 22-6429Cancelled Feb 14, 1985 · Administratively canceled · Smith Howard C, Spring, TXN9303JPiper PA-28-180 · S/N 28-3394Cancelled Jan 22, 1985 · Administratively canceled · Iosco Flying Club Inc, East Tawas, MIN93338Cessna T210L · S/N 21060367Cancelled Jan 22, 1985 · Administratively canceled · Dobbs William, Foster City, CAN9274FHughes 369HS · S/N 160781SCancelled Dec 11, 1984 · Administratively canceled · US Department Of Justice, Washington, DCN923CStinson 108-3 · S/N 108-3923Cancelled Oct 26, 1984 · Administratively canceled · Bourgeois Richard J, Thibodaux, LAN9361XCessna 182E · S/N 18253761Cancelled Oct 26, 1984 · Administratively canceled · Academy Flyers Inc, Phoenix, AZN931DBAerospatiale SA341G GAZELLE · S/N 1207Cancelled Oct 3, 1984 · Administratively canceled · Aerospatiale Helicopter Corporation, Grand Prairie, TXN93SMWittman Tailwind W-8 · S/N 21Cancelled Sep 18, 1984 · Administratively canceled · Mockrud Stanley C, Madison, WIN93801Engineering & Research ERCOUPE 415-C · S/N 1124Cancelled Sep 6, 1984 · Administratively canceled · Widener John H, Hooker, OKN9514WPiper PA-28-140 · S/N 28-22939Cancelled Aug 31, 1984 · Administratively canceled · Lewis Bruce E, Limerick, MEN9410BCessna 175 · S/N 55210Cancelled Aug 20, 1984 · Administratively canceled · Bos Bernard D, Helena, MTN9274KStinson 108-2 · S/N 108-2274Cancelled Jul 21, 1984 · Administratively canceled · Lee Thomas G, Anchorage, AKN9515Glasflugel H 301 LIBELLE · S/N 90Cancelled Jul 21, 1984 · Administratively canceled · Frauens Frederick W, San Anselmo, CAN9388KStinson 108-2 · S/N 108-2388Cancelled Jul 11, 1984 · Administratively canceled · Wall O Ray, Huntsville, ALN9490ASmith Terry B. SCORPION 133 · S/N S1125-78Cancelled Jun 22, 1984 · Administratively canceled · Millhorn Farms Inc, Worley, IDN9275AVan Manen BIRDMAN TL-1A · S/N 137Cancelled May 15, 1984 · Administratively canceled · Vanmanen Donald, Noxon, MTN9365SBeech C23 · S/N M-1661Cancelled Apr 10, 1984 · Administratively canceled · Smith Jay H Jr, Trapper Creek, AKN9301FHughes 269B · S/N 0003Cancelled Feb 13, 1984 · Administratively canceled · Harrington Vet Service Inc, Guymon, OKN9288ZYost Mfg. EB-55 · S/N 105Cancelled Jan 13, 1984 · Administratively canceled · Rosie O Gradys Of Orlando Inc, Orlando, FLN9276ZBell 47G-3B-1 · S/N 2892Cancelled Jan 10, 1984 · Administratively canceled · Evergreen Helicopters Inc, Mcminnville, ORN9325ECessna 172N · S/N 17272227Cancelled Dec 14, 1983 · Administratively canceled · Union Airfinance Co, Kansas City, MON92946Commonwealth REARWIN 185 · S/N 1679Cancelled Nov 23, 1983 · Administratively canceled · Mann Richard A, Santa Susana, CAN9338LAmerican AA-1A · S/N AA1A-0038Cancelled Nov 23, 1983 · Administratively canceled · Tobacco Robert, Colts Neck, NJN93956Cessna 210L · S/N 21060465Cancelled Nov 23, 1983 · Administratively canceled · Cochise College, Douglas, AZN94074Ercoupe 415-C · S/N 1397Cancelled Nov 23, 1983 · Administratively canceled · Herreman Fred A, Edwardsburg, MIN92606Cessna 172M · S/N 17261593Cancelled Oct 1, 1983 · Administratively canceled · Airflite Inc South, Long Beach, CAN9320UCessna 150M · S/N 15078270Cancelled Sep 3, 1983 · Administratively canceled · Sky Brezze Aviation Inc, Lubbock, TXN9366EAeronca 11AC · S/N 11AC-1004Cancelled Jul 22, 1983 · Administratively canceled · Marymee V E, Sparks, NVN95KTDouglas DC3C-S1C3G · S/N 6255Cancelled May 5, 1983 · Administratively canceled · Miami Air Lease, Miami, FLN9234SBeech C23 · S/N M-1730Cancelled Apr 16, 1983 · Administratively canceled · Hlh Leasing Inc, Peachtree City, GAN9410LAmerican AA-1A · S/N AA1A-0210Cancelled Apr 9, 1983 · Administratively canceled · Woods Charles M, Corvallis, ORN9243WWeatherly 201C · S/N 1038Cancelled Mar 26, 1983 · Administratively canceled · Decker Air Ag Inc, Hood River, ORN924WBeech E18S · S/N BA-53Cancelled Mar 26, 1983 · Administratively canceled · Oliver Henry III, Santa Fe, NMN9425UCessna 150M · S/N 15078373Cancelled Feb 16, 1983 · Administratively canceled · Uran Richard L, Phoenix, AZN9512PPiper PA-25-235 · S/N 25-7405599Cancelled Feb 16, 1983 · Administratively canceled · Suber Van F, Hartsfield, GAN9307UCessna 150M · S/N 15078257Cancelled Feb 12, 1983 · Administratively canceled · Zgrabik Donald, Thousand Oaks, CAN9445GCessna U206E · S/N U20601645Cancelled Feb 12, 1983 · Administratively canceled · Bowling Green Airlease Co, Borling Green, OHN9316DCessna 210 · S/N 57509Cancelled Feb 10, 1983 · Administratively canceled · Merritt Earl B, Simi, CAN9478CCessna 180 · S/N 31876Cancelled Feb 10, 1983 · Administratively canceled · Dennis Leslie E Jr, Anchorange, AKN9292TPiper PA-38-112 · S/N 38-78A0331Cancelled Oct 16, 1982 · Administratively canceled · Koba Timothy, Elvria, OHN9292DPiper PA-18A 150 · S/N 18-6599Cancelled Oct 14, 1982 · Administratively canceled · Ace Aviation Services Inc, Atlantic City, NJN94322Cessna 182Q · S/N 18266408Cancelled Oct 14, 1982 · Administratively canceled · Szajvolt Bela, Sunnyvale, CAN9503LAmerican AA-5 · S/N AA5-0205Cancelled Oct 14, 1982 · Administratively canceled · Weaver B R DBA, Duncanville, TXN93130Cessna A185F · S/N 18503182Cancelled Oct 7, 1982 · Administratively canceled · Bennett John C, Anchorage, AKN938Owens-James OWENS SPECIAL · S/N 1Cancelled Oct 7, 1982 · Administratively canceled · Owens James P, Birmingham, ALN9437PPiper PA-24-260 · S/N 24-4945Cancelled Oct 7, 1982 · Administratively canceled · G & R Farms Inc, Champaign, ILN9482FHughes 269B · S/N 1160288Cancelled Oct 7, 1982 · Administratively canceled · C Q Air, Garrett Park, MDN925RZBeech A23A · S/N M-969Cancelled Oct 2, 1982 · Administratively canceled · Kecle Donald E, Fallon, NVN9333RCessna A188B · S/N 18802240TCancelled Sep 25, 1982 · Administratively canceled · Blue Spring Bank, Blue Spring, MO
Back to Riviere James A Jr