Ridgeline Assets LLC
Registered aircraft · 35
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 = 'RIDGELINE ASSETS LLC' OR list_contains(g.other_registrant_names, 'RIDGELINE ASSETS 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 = 'RIDGELINE ASSETS LLC' OR list_contains(g.other_registrant_names, 'RIDGELINE ASSETS 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.
N205FGTextron 172S · S/N 172S12093N2129JCessna 172S · S/N 172S9441N239FGTextron 172S · S/N 172S13273N267FGTextron 172S · S/N 172S12725N272FGTextron 172S · S/N 172S13454N278FGTextron 172S · S/N 172S13453N305FGTextron 172S · S/N 172S13274N499KWCessna 172S · S/N 172S8430N508FGTextron 172S · S/N 172S12910N543THTextron 172S · S/N 172S12255N561FGTextron 172S · S/N 172S12909N567FLPiper PA-44-180 · S/N 4496643N570FGTextron 172S · S/N 172S13455N577FGTextron 172S · S/N 172S13079N613LGCessna 172S · S/N 172S9252N617FGTextron 172S · S/N 172S12597N623HBTextron 172S · S/N 172S12397N677AATextron 172S · S/N 172S12151N705FGTextron 172S · S/N 172S13073N717FGTextron 172S · S/N 172S13456N728FGTextron 172S · S/N 172S13275N754FGTextron 172S · S/N 172S13276N772FGTextron 172S · S/N 172S13277N786FGTextron 172S · S/N 172S13278N802FGTextron 172S · S/N 172S12606N814FGTextron 172S · S/N 172S12456N817FGTextron 172S · S/N 172S13457N828FGTextron 172S · S/N 172S13076N848FGTextron 172S · S/N 172S13459N856FGTextron 172S · S/N 172S13460N908FGTextron 172S · S/N 172S12724N945FGTextron 172S · S/N 172S13461N954FGTextron 172S · S/N 172S13279N972FGTextron 172S · S/N 172S13462N974THTextron 172S · S/N 172S12974
Back to Ridgeline Assets LLC