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.
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
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.
N1075WBell Helicopter Textron 206L-1 · S/N 45377N176ETSikorsky S-76 · S/N 760095N17LABell 412 · S/N 36044N196SJBell 206B · S/N 3198N204AVBell 206A · S/N 158N207SJBell 407 · S/N 53721N208SJAerospatiale SA315B ALOUETTE III · S/N 225245N210SJAerospatiale SA315B · S/N 2426N218SJAerospatiale SA315B ALOUETTE III · S/N 2272/29N220SJAerospatiale SA315B · S/N 2657N256SJCessna R172K · S/N R1723166N277RLBell 206B · S/N 3277N316SPBell Helicopter Textron 206L-1 · S/N 45768N3538TMesserschmitt-Boelkow-Blohm BO-105S · S/N S-350Registration expired, pending cancellationN385RLBell Helicopter Textron Canada 206L-4 · S/N 52385N407SJBell 407 · S/N 53608N430CFBell 430 · S/N 49118N430CGBell 430 · S/N 49062N430CMBell 430 · S/N 49090N512SCBell 206B · S/N 3967N58003Bell 206B · S/N 1020N58140Bell 206B · S/N 1108N67SJBell 206L-3 · S/N 51098N7963JBell 206A · S/N 685N9190YMesserschmitt BO 105CB · S/N S-669First renewal notice
Back to San Juan Aviation LLC