Big Bend Community College
Registered aircraft · 33
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 = 'BIG BEND COMMUNITY COLLEGE' OR list_contains(g.other_registrant_names, 'BIG BEND COMMUNITY COLLEGE') 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 = 'BIG BEND COMMUNITY COLLEGE' OR list_contains(g.other_registrant_names, 'BIG BEND COMMUNITY COLLEGE') 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.
N18966Beech B19 · S/N MB-869N1987LBeech B19 · S/N MB-806N2047ABeech B19 · S/N MB-899N2048ABeech B19 · S/N MB-904N2059LBeech B19 · S/N MB-808N22711Beech B19 · S/N MB-865N262PMBeech F33A · S/N CE-1681N36137Bellanca 7GCBC · S/N 542-73N3621XPiper PA-28-181 · S/N 2881010N3714XBeech C23 · S/N M-2278N3715XBeech C23 · S/N M-2283N3722XPiper PA-28-181 · S/N 2881011N3723XPiper PA-28-181 · S/N 2881012N4506MBeech B19 · S/N MB-881N5012MBeech B19 · S/N MB-882N5731VBeech D95A · S/N TD-652N6010CBeech B19 · S/N MB-905N60501Beech C23 · S/N M-2138N60503Beech C23 · S/N M-2170N6084CPiper PA-44-180 · S/N 4496267N625BBPiper PA-28-181 · S/N 2881694N62954Beech C23 · S/N M-2355N63866Beech C23 · S/N M-2374N6594RBeech B19 · S/N MB-718N6595RBeech B19 · S/N MB-714N6639DBeech C23 · S/N M-2223N66710Beech C23 · S/N M-2387N7911VCessna 180H · S/N 18051811N819BABeech B19 · S/N MB-866N824BBPiper PA-28-181 · S/N 2881695N82964Beech F33A · S/N CE-1761N82966Beech F33A · S/N CE-1757N9182SBeech B19 · S/N MB-786
Back to Big Bend Community College