Cedar Ridge Aviation LLC
Registered aircraft · 21
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 = 'CEDAR RIDGE AVIATION LLC' OR list_contains(g.other_registrant_names, 'CEDAR RIDGE 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 = 'CEDAR RIDGE AVIATION LLC' OR list_contains(g.other_registrant_names, 'CEDAR RIDGE 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.
N144SRRobinson Helicopter R44 II · S/N 10079N197HLRobinson Helicopter R44 · S/N 1386N212JBRobinson Helicopter R44 II · S/N 11519N224RHRobinson Helicopter R44 · S/N 1137N3040PRobinson Helicopter R44 · S/N 1802N4177GRobinson Helicopter R44 II · S/N 12514N436MRRobinson Helicopter R44 · S/N 0788N442CBRobinson Helicopter R44 II · S/N 12712N446SGRobinson Helicopter R44 · S/N 1431N44HNRobinson Helicopter R44 · S/N 1455N458SGRobinson Helicopter R44 II · S/N 10458N509KMRobinson Helicopter R44 · S/N 0327N531BPRobinson Helicopter R44 · S/N 1379N551BKRobinson Helicopter R44 II · S/N 12197N616NCRobinson Helicopter R44 II · S/N 11389N6SGRobinson Helicopter R44 · S/N 0878N7195DRobinson Helicopter R44 · S/N 0905N828RDRobinson Helicopter R44 · S/N 1254N842ECXag P150 · S/N 186324P1822350X8E91N911CRAir Tractor AT-802 · S/N 802-1264N966ECXag P150 · S/N 186324P182235087J9J9
Back to Cedar Ridge Aviation LLC