Registered aircraft · 19

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

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 = 'ALPHA AVIATION LLC' OR list_contains(g.other_registrant_names, 'ALPHA AVIATION LLC') ORDER BY g.n_number

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

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

N17ZERobinson Helicopter R44 II · S/N 14757Built 2024 · Anchorage, AK N254JAPiper PA-28-181 · S/N 28020035Built 2021 · Indianapolis, IN N326SBCirrus Design SR22T · S/N 2399Built 2021 · Rancho Cordova, CA N376AKRobinson Helicopter R66 · S/N 0790Built 2016 · Anchorage, AK N381AKEurocopter AS 350 B2 · S/N 2641Built 1992 · Anchorage, AK N382AKEurocopter AS 350 B2 · S/N 3591Built 2002 · Anchorage, AK N383AKEurocopter AS 350 B3 · S/N 3530Built 2002 · Anchorage, AK N384AKEurocopter AS 350 B2 · S/N 3092Built 1998 · Anchorage, AK N385AKEurocopter AS 350 B3 · S/N 3128Built 1998 · Anchorage, AK N386AKEurocopter AS 350 B3 · S/N 3336Built 2000 · Anchorage, AK N389AKRobinson Helicopter R44 II · S/N 14543Built 2022 · Anchorage, AK N503AMCessna 172P · S/N 17275767Built 1982 · Spartanburg, SC N633AKRobinson Helicopter R44 II · S/N 14904Built 2025 · Anchorage, AK N712DCessna 172N · S/N 17268279Built 1976 · Dalhart, TX N785AKRobinson Helicopter R44 II · S/N 14765Built 2024 · Anchorage, AK N786AKRobinson Helicopter R44 II · S/N 14760Built 2024 · Anchorage, AK N791AKRobinson Helicopter R44 II · S/N 14878Built 2025 · Anchorage, AK N8170ACirrus Design SR22 · S/N 0745Built 2003 · Springfield, MO N987WHRobinson Helicopter R44 II · S/N 10551Built 2004 · Anchorage, AK

Back to Alpha Aviation LLC