Lindstrand Balloons USA
Registered aircraft · 24
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 = 'LINDSTRAND BALLOONS USA' OR list_contains(g.other_registrant_names, 'LINDSTRAND BALLOONS USA') 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 = 'LINDSTRAND BALLOONS USA' OR list_contains(g.other_registrant_names, 'LINDSTRAND BALLOONS USA') 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.
N1734ZArbc Inc DBA Lindstrand 90A · S/N 5842N2010KLindstrand Balloons 105A · S/N 5466N223PPLindstrand Balloons 77A · S/N 5276N3023QLindstrand Balloons 210A · S/N 5130N31LBLindstrand Balloons 31A · S/N 5082N4020AArbc Inc DBA Lindstrand 310A · S/N 5708N4020GArbc Inc DBA Lindstrand 77X · S/N 5718N404LBLindstrand Balloons 69A · S/N 5274N434RTArbc Inc DBA Lindstrand 77X · S/N 5608N61040Arbc Inc DBA Lindstrand 105A · S/N 105AN620PSArbc Inc DBA Lindstrand 77A · S/N 5839N6291MArbc Inc DBA Lindstrand 77A · S/N 5623N6XXLindstrand Balloons 60X · S/N 5388N708RRLindstrand Balloons 210S · S/N 5415N74TEArbc Inc DBA Lindstrand 90A · S/N 5585N80011Arbc Inc DBA Lindstrand 77X · S/N 5845N8002VArbc Inc DBA Lindstrand 90A · S/N 5844N8002XArbc Inc DBA Lindstrand 60X · S/N 5747N80041Arbc Inc DBA Lindstrand 90A · S/N 5841N80072Arbc Inc DBA Lindstrand 69X · S/N 5843N8007EArbc Inc DBA Lindstrand 90A · S/N 5846N810LBLindstrand Balloons 25A · S/N 5188N817MTArbc Inc DBA Lindstrand 120A · S/N 5640N9024ZArbc Inc DBA Lindstrand 90A · S/N 5840
Back to Lindstrand Balloons USA