OpenAirDocs.org
Svetfur Aviation LLC

Registered aircraft · 17

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 = 'SVETFUR AVIATION LLC' OR list_contains(g.other_registrant_names, 'SVETFUR 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.

N169KSCessna 414A · S/N 414A0015Built 1978 · Camden, SCN21019Cessna 172S · S/N 172S9595Built 2004 · Camden, SCN24108Cessna 172S · S/N 172S10504Built 2007 · Camden, SCN2466TCessna 172S · S/N 172S10062Built 2005 · Camden, SCN277GTCessna 172S · S/N 172S9286Built 2002 · Camden, SCN45EFCessna 172S · S/N 172S8982Built 2001 · Camden, SCN5114ZCessna 172S · S/N 172S10927Built 2009 · Camden, SC · Co-owner with Mustang Sally Aviation LLCN51390Cessna 172S · S/N 172S10892Camden, SC · Co-owner with Mustang Sally Aviation LLCN5251ZCessna 172S · S/N 172S10902Built 2009 · Camden, SC · Co-owner with Mustang Sally Aviation LLCN52522Cessna 172S · S/N 172S10905Built 2009 · Camden, SC · Co-owner with Mustang Sally Aviation LLCN5253CCessna 172S · S/N 172S10906Built 2009 · Camden, SC · Co-owner with Mustang Sally Aviation LLCN6064RCessna 172S · S/N 172S10246Built 2006 · Camden, SCN635BACessna 172S · S/N 172S11596Built 2015 · Camden, SCN687BACessna 172S · S/N 172S11581Built 2015 · Camden, SCN9004WCessna 172S · S/N 172S11047Built 2010 · Camden, SC · Co-owner with Mustang Sally Aviation LLCN926JACessna 172S · S/N 172S10926Built 2009 · Camden, SC · Co-owner with Mustang Sally Aviation LLCN963TACessna 172S · S/N 172S9610Built 2004 · Camden, SC
Back to Svetfur Aviation LLC