Aerial Banners Inc
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 = 'AERIAL BANNERS INC' OR list_contains(g.other_registrant_names, 'AERIAL BANNERS 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 = 'AERIAL BANNERS INC' OR list_contains(g.other_registrant_names, 'AERIAL BANNERS 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.
N138ABPiper PA-25-260 · S/N 25-3915N145ABPiper PA-25-235 · S/N 25-3137N189ABPiper PA-25-235 · S/N 25-2781N212KYCessna 305A · S/N 22301N24260Cessna 152 · S/N 15280180N430ABPiper PA-25-235 · S/N 25-3996N4792YPiper PA-25-260 · S/N 25-4568N4860YPiper PA-25-260 · S/N 25-4662N4938YPiper PA-25-260 · S/N 25-4738N6021ZPiper PA-25 · S/N 25-25N6035ZPiper PA-25 · S/N 25-42N6200ZPiper PA-25 · S/N 25-234N6265ZPiper PA-25 · S/N 25-327N7218ZPiper PA-25-235 · S/N 25-3134N7248ZPiper PA-25-235 · S/N 25-3177N7252ZPiper PA-25-235 · S/N 25-3184N7704ZPiper PA-25-235 · S/N 25-3864N7785ZPiper PA-25-235 · S/N 25-3989N8619LPiper PA-25-235 · S/N 25-5049N9573PPiper PA-25-260 · S/N 25-7405683N9777PPiper PA-25-235 · S/N 25-7556089
Back to Aerial Banners Inc