Sunrise Aviation Inc
Registered aircraft · 66
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 = 'SUNRISE AVIATION INC' OR list_contains(g.other_registrant_names, 'SUNRISE AVIATION INC') 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 = 'SUNRISE AVIATION INC' OR list_contains(g.other_registrant_names, 'SUNRISE AVIATION INC') 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.
N2084APiper PA-44-180 · S/N 44-7995081N2173SPiper PA-44-180 · S/N 44-7995245N2334MPiper PA-28R-201 · S/N 28R-7837083N23566Cessna 172S · S/N 172S10097N24264Cessna 152 · S/N 15280183N24874Cessna 152 · S/N 15280427N24887Cessna 152 · S/N 15280433N25047Cessna 152 · S/N 15280514N25325Cessna 152 · S/N 15280596N25362Cessna 152 · S/N 15280616N2548CPiper PA-38-112 · S/N 38-79A0225N25564Cessna 152 · S/N 15280732N30101Piper PA-44-180 · S/N 44-7995069N301CFCessna 172R · S/N 17281135N342SACessna 172S · S/N 172S10475N343SACessna 172S · S/N 172S10477N3786TPiper PA-28R-180 · S/N 28R-30099N41538Piper PA-34-200 · S/N 34-7450131N41SGPiper PA-28R-201 · S/N 28R-7837288N4388RCessna 172M · S/N 17263138N4534TPiper PA-34-200 · S/N 34-7250127N46138Cessna 152 · S/N 15283005N46261Cessna 152 · S/N 15283024N47133Cessna 152 · S/N 15283178N4819BCessna 152 · S/N 15283654N48961Cessna 152 · S/N 15281074N49005Cessna 152 · S/N 15281095N49878Cessna 152 · S/N 15281377N49899Cessna 152 · S/N 15281381N510NDCessna 172S · S/N 172S10952N511NDCessna 172S · S/N 172S10762N516NDCessna 172S · S/N 172S10786N517NDCessna 172S · S/N 172S10787N523NDCessna 172S · S/N 172S11062N5357PCessna 152 · S/N 15284927N5383MCessna 152 · S/N 15284572N551ERCessna 172S · S/N 172S10548N556ERCessna 172S · S/N 172S10561N574NDCessna 172S · S/N 172S10943N6102HCessna 152 · S/N 15284131N6106QCessna 152 · S/N 15285131N6469PCessna 152 · S/N 15285019N66946Cessna 152 · S/N 15281681N673DWCessna 172R · S/N 17280771N674DWCessna 172R · S/N 17280772N676DWCessna 172R · S/N 17280774N67840Cessna 152 · S/N 15282049N67852Cessna 152 · S/N 15285312N679DWCessna 172R · S/N 17280940N681DWCessna 172R · S/N 17280942
Back to Sunrise Aviation Inc