OpenAirDocs.org
Archer Aero LLC

Registered aircraft · 17

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 = 'ARCHER AERO LLC' OR list_contains(g.other_registrant_names, 'ARCHER AERO 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.

N147GPiper PA-28-181 · S/N 2881111Built 2019 · Wilmington, DEN243GPiper PA-28-181 · S/N 2881113Built 2019 · Wilmington, DEN271GPiper PA-28-181 · S/N 2881114Built 2019 · Wilmington, DEN328GPiper PA-28-181 · S/N 2881115Built 2019 · Wilmington, DEN334GPiper PA-28-181 · S/N 2881116Built 2019 · Wilmington, DEN374GPiper PA-28-181 · S/N 2881117Built 2019 · Wilmington, DEN383GPiper PA-28-181 · S/N 2881118Built 2019 · Wilmington, DEN449APiper PA-28-181 · S/N 2843798Built 2014 · Wilmington, DEN458APiper PA-28-181 · S/N 2843799Built 2014 · Wilmington, DEN620APiper PA-28-181 · S/N 2843800Built 2015 · Wilmington, DEN901APiper PA-28-181 · S/N 2843801Built 2015 · Wilmington, DEN908APiper PA-28-181 · S/N 2843802Built 2015 · Wilmington, DEN929APiper PA-28-181 · S/N 2843803Built 2015 · Wilmington, DEN952APiper PA-28-181 · S/N 2843804Built 2015 · Wilmington, DEN979APiper PA-28-181 · S/N 2843805Built 2014 · Wilmington, DEN980APiper PA-28-181 · S/N 2843806Built 2015 · Wilmington, DEN991APiper PA-28-181 · S/N 2843807Built 2015 · Wilmington, DE
Back to Archer Aero LLC