Cameron Balloons US
Registered aircraft · 42
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 = 'CAMERON BALLOONS US' OR list_contains(g.other_registrant_names, 'CAMERON BALLOONS US') 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 = 'CAMERON BALLOONS US' OR list_contains(g.other_registrant_names, 'CAMERON BALLOONS US') 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.
N142CBCameron Balloons O-84 · S/N 408N16XTCameron Balloons US XT-65 · S/N 6946N2035XCameron Balloons US A-105 · S/N 6564N26ENCameron Balloons US Z-105 · S/N 7052N26XTCameron Balloons U S XT-60 · S/N 7050N276MMCameron Balloons U S Z-315 · S/N 7055N29777Cameron Balloons N-77 · S/N 629N2991QCameron Balloons US N-105 · S/N 5219N3025WCameron Balloons U S A-90 · S/N 6884N3065YCameron Balloons US C-80 · S/N 6062N358PVCameron Balloons US Z-105 · S/N 7043N383CBCameron Balloons O-65 · S/N 730N389CBCameron Balloons N-77 · S/N 628N390CBCameron Balloons O-84 · S/N 409N391CBCameron Balloons V-65 · S/N 625N394CBCameron Balloons N-105 · S/N 735N395CBCameron Balloons N-65 · S/N 733N397CBCameron Balloons O-65 · S/N 606N398CBCameron Balloons O-65 · S/N 607N3995HCameron Balloons US N-105 · S/N 5712N401CBCameron Balloons O-77 · S/N 680N41445Cameron Balloons US RX100 · S/N 2656N50DECameron Balloons US Z-90 · S/N 7049N5820ECameron Balloons US V-31 · S/N 5033N6001LCameron Balloons US C-80 · S/N 7053N6083CCameron Balloons US N-160 · S/N 5505N64CBCameron Balloons US O-84 · S/N 6829N6955FCameron Balloons US O-105 · S/N 6746N700RGCameron Balloons ZL-105 · S/N 6727N704ESCameron Balloons US Z-105 · S/N 7056N7401CCameron Balloons US O-84 · S/N 5116N7401UCameron Balloons N-31 · S/N 5079N740CBCameron Balloons D-50 · S/N 822N749CBCameron Balloons V-56 · S/N 460N750CBCameron Balloons O-84 · S/N 725N750HGCameron Balloons US Z-210 · S/N 6921N7519JCameron Balloons US ROUND THE WORLD · S/N RTW6N897DDCameron Balloons US Z-105 · S/N 7040N90ZSCameron Balloons US Z-90 · S/N 7037N9293ACameron Balloons US ZL-90 · S/N 7051N950LVCameron Balloons US Z-90 · S/N 6950N98YRCameron Balloons US Z-90 · S/N 7054
Back to Cameron Balloons US