Cirrus Design Corp
Registered aircraft · 481
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 = 'CIRRUS DESIGN CORP' OR list_contains(g.other_registrant_names, 'CIRRUS DESIGN CORP') 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 = 'CIRRUS DESIGN CORP' OR list_contains(g.other_registrant_names, 'CIRRUS DESIGN CORP') 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.
N105GCCirrus Design SR22T · S/N 11013N108PJCirrus Design SF50 · S/N 0808N109MPCirrus Design SR22 · S/N 11905N110WKCirrus Design SR20 · S/N 2115N114CACirrus Design SR20 · S/N 11535N11532Cirrus Design SR22T · S/N 11532N116KGCirrus Design SR22T · S/N 11718N11770Cirrus Design SR20 · S/N 11770N11JMCirrus Design SR22T · S/N 11780N122WPCirrus Design SR22T · S/N 11795N123BGCirrus Design SR22T · S/N 11744N124SFCirrus Design SR22 · S/N 4621N125TGCirrus Design SR22T · S/N 11747N126CDCirrus Design SR20 · S/N 10672N127CACirrus Design SR22T · S/N 9815N129CDCirrus Design SR22T · S/N 11408N12NDCirrus Design SR22T · S/N 11652N136HHCirrus Design SR22 · S/N 4865N138LACirrus Design SR22T · S/N 11499N139CDCirrus Design SR22 · S/N 0820N13AUCirrus Design SR22 · S/N 11745N140CDCirrus Design SR20 · S/N 1023N141DBCirrus Design SF50 · S/N 0852N142AKCirrus Design SR22 · S/N 11885N142DCirrus Design SR22 · S/N 4587N143CDCirrus Design SR20 · S/N 11353N14MSCirrus Design SR20 · S/N 11592N157JGCirrus Design SF50 · S/N 0855N159JPCirrus Design SR22T · S/N 11818N15EUCirrus Design SR22T · S/N 11379N15GHCirrus Design SR22 · S/N 11388N15RTCirrus Design SRT · S/N 0001N15VSCirrus Design SR22T · S/N 11458N16298Cirrus Design SF50 · S/N 0837N167LRCirrus Design SF50 · S/N 0667N167WPCirrus Design SR20 · S/N 11541N16EUCirrus Design SR22T · S/N 11380N16MXCirrus Design SR22T · S/N 11881N173JBCirrus Design SF50 · S/N 0807N174CDCirrus Design SR20 · S/N 11643N174MPCirrus Design SR22T · S/N 11519N176FDCirrus Design SR22T · S/N 11776N1798ZCirrus Design SR22T · S/N 11602N17EUCirrus Design SR22T · S/N 11409N17JTCirrus Design SR22T · S/N 11736N1818CCirrus Design SF50 · S/N 0820N18EUCirrus Design SR22T · S/N 11416N19626Cirrus Design SR20 · S/N 11717N196TCirrus Design SR10 · S/N 0003N1KLCirrus Design SF50 · S/N 0829
Back to Cirrus Design Corp