OpenAirDocs.org
Airstrike Ag LLC

Registered aircraft · 22

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 = 'AIRSTRIKE AG LLC' OR list_contains(g.other_registrant_names, 'AIRSTRIKE AG LLC')
  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.

N18FUXag P100 PRO · S/N 8219425N265YBarnum, IAN243FUXag P150 · S/N 186324P1822350223FK9Barnum, IAN244BXXag P100 PRO · S/N 82193146K8L9Barnum, IAN296DCXag P150 · S/N 186324P18223449F96Y4Barnum, IAN305AGXag P150 MAX · S/N 186325P182275337H4D1Barnum, IAN332AGXag P150 MAX · S/N 186325P182295481R5A9Barnum, IAN335AGXag P150 MAX · S/N 186325P1822954862H1GBarnum, IAN337QAXag P100 PRO · S/N 8219348N04A2Barnum, IAN371AAXag P100 PRO · S/N 8219425YY149Barnum, IAN382QAXag P100 PRO · S/N 8219425A52A9Barnum, IAN382UAXag P100 PRO · S/N 8219425N4E89Barnum, IAN388KAXag P100 PRO · S/N 82194233H19EBarnum, IAN388QZXag P100 PRO · S/N 821942370K1XBarnum, IAN388SSXag P100 PRO · S/N 8219425X94S6Barnum, IAN388UAXag P100 PRO · S/N 8219421M956EBarnum, IAN388VAXag P100 PRO · S/N 8219425S54M7Barnum, IAN388XAXag P100 PRO · S/N 821942303H8RBarnum, IAN389ESXag P100 PRO · S/N 8219425J76N8Barnum, IAN389FAXag P100 PRO · S/N 8219421M3J17Barnum, IAN389HZXag P100 PRO · S/N 82194219E35MBarnum, IAN389QAXag P100 PRO · S/N 821942172EF9Barnum, IAN389UAXag P100 PRO · S/N 8219423CA089Barnum, IA
Back to Airstrike Ag LLC