San Juan Aviation LLC

Registered aircraft · 25

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'SAN JUAN AVIATION LLC' OR list_contains(g.other_registrant_names, 'SAN JUAN AVIATION LLC')
  ORDER BY g.n_number"

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.

N1075WBell Helicopter Textron 206L-1 · S/N 45377Built 1980 · Wilmington, DEN176ETSikorsky S-76 · S/N 760095Built 1980 · Wilmington, DEN17LABell 412 · S/N 36044Built 1992 · Wilmington, DEN196SJBell 206B · S/N 3198Wilmington, DEN204AVBell 206A · S/N 158Built 1969 · Wilmington, DEN207SJBell 407 · S/N 53721Wilmington, DEN208SJAerospatiale SA315B ALOUETTE III · S/N 225245Wilmington, DEN210SJAerospatiale SA315B · S/N 2426Wilmington, DEN218SJAerospatiale SA315B ALOUETTE III · S/N 2272/29Wilmington, DEN220SJAerospatiale SA315B · S/N 2657Wilmington, DEN256SJCessna R172K · S/N R1723166Built 1979 · Wilmington, DEN277RLBell 206B · S/N 3277Built 1981 · Wilmington, DEN316SPBell Helicopter Textron 206L-1 · S/N 45768Built 1983 · Wilmington, DEN3538TMesserschmitt-Boelkow-Blohm BO-105S · S/N S-350Registration expired, pending cancellationBuilt 1977 · Wilmington, DEN385RLBell Helicopter Textron Canada 206L-4 · S/N 52385Built 2008 · Wilmington, DEN407SJBell 407 · S/N 53608Built 2004 · Wilmington, DEN430CFBell 430 · S/N 49118Built 2006 · Wilmington, DEN430CGBell 430 · S/N 49062Wilmington, DEN430CMBell 430 · S/N 49090Wilmington, DEN512SCBell 206B · S/N 3967Built 1987 · Wilmington, DEN58003Bell 206B · S/N 1020Built 1983 · Wilmington, DEN58140Bell 206B · S/N 1108Built 1973 · Wilmington, DEN67SJBell 206L-3 · S/N 51098Wilmington, DEN7963JBell 206A · S/N 685Built 1971 · Wilmington, DEN9190YMesserschmitt BO 105CB · S/N S-669First renewal noticeBuilt 1987 · Wilmington, DE
Back to San Juan Aviation LLC