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.

N1734ZArbc Inc DBA Lindstrand 90A · S/N 5842Built 2026 · Galena, IL · Co-owner with A R B C Inc DBAN2010KLindstrand Balloons 105A · S/N 5466Galena, IL · Co-owner with A R B C Inc DBAN223PPLindstrand Balloons 77A · S/N 5276Galena, IL · Co-owner with A R B C Inc DBAN3023QLindstrand Balloons 210A · S/N 5130Galena, IL · Co-owner with A R B C Inc DBAN31LBLindstrand Balloons 31A · S/N 5082Galena, IL · Co-owner with A R B C Inc DBAN4020AArbc Inc DBA Lindstrand 310A · S/N 5708Galena, IL · Co-owner with A R B C Inc DBAN4020GArbc Inc DBA Lindstrand 77X · S/N 5718Galena, IL · Co-owner with A R B C Inc DBAN404LBLindstrand Balloons 69A · S/N 5274Galena, IL · Co-owner with A R B C Inc DBAN434RTArbc Inc DBA Lindstrand 77X · S/N 5608Galena, IL · Co-owner with A R B C Inc DBAN61040Arbc Inc DBA Lindstrand 105A · S/N 105AGalena, IL · Co-owner with A R B C Inc DBAN620PSArbc Inc DBA Lindstrand 77A · S/N 5839Built 2026 · Galena, IL · Co-owner with A R B C Inc DBAN6291MArbc Inc DBA Lindstrand 77A · S/N 5623Galena, IL · Co-owner with A R B C Inc DBAN6XXLindstrand Balloons 60X · S/N 5388Built 2018 · Galena, IL · Co-owner with A R B C Inc DBAN708RRLindstrand Balloons 210S · S/N 5415Galena, IL · Co-owner with A R B C Inc DBAN74TEArbc Inc DBA Lindstrand 90A · S/N 5585Galena, IL · Co-owner with A R B C Inc DBAN80011Arbc Inc DBA Lindstrand 77X · S/N 5845Galena, IL · Co-owner with A R B C Inc DBAN8002VArbc Inc DBA Lindstrand 90A · S/N 5844Built 2026 · Galena, IL · Co-owner with A R B C Inc DBAN8002XArbc Inc DBA Lindstrand 60X · S/N 5747Built 2021 · Galena, IL · Co-owner with A R B C Inc DBAN80041Arbc Inc DBA Lindstrand 90A · S/N 5841Built 2026 · Galena, IL · Co-owner with A R B C Inc DBAN80072Arbc Inc DBA Lindstrand 69X · S/N 5843Galena, IL · Co-owner with A R B C Inc DBAN8007EArbc Inc DBA Lindstrand 90A · S/N 5846Galena, IL · Co-owner with A R B C Inc DBAN810LBLindstrand Balloons 25A · S/N 5188Built 2001 · Galena, IL · Co-owner with A R B C Inc DBAN817MTArbc Inc DBA Lindstrand 120A · S/N 5640Galena, IL · Co-owner with A R B C Inc DBAN9024ZArbc Inc DBA Lindstrand 90A · S/N 5840Built 2026 · Galena, IL · Co-owner with A R B C Inc DBA
Back to Lindstrand Balloons USA