Skip to content

Alpine Aviation Inc

Registered aircraft · 77

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

N100UXBeech 1900D · S/N UE-100Built 1994 · Provo, UT N101UEBeech 1900C · S/N UC-101Built 1989 · Provo, UT N103SFBeech 1900C · S/N UC-103Built 1990 · Provo, UT N114AXBeech 1900C · S/N UC-36Built 1988 · Provo, UT N118MDBeech 99A · S/N U-118Built 1969 · Provo, UT N120UCBeech 1900C · S/N UC120Built 1990 · Provo, UT N122UXBeech 1900D · S/N UE-122Built 1994 · Provo, UT N124GPBeech 1900C · S/N UB-23Built 1984 · Provo, UT N125BABeech 1900 · S/N UB-6Provo, UT N125KSBeech B200C · S/N BL-125Built 1985 · Provo, UT N127BABeech 1900 · S/N UB-7Provo, UT N132KCBeech 1900D · S/N UE-132Built 1995 · Provo, UT N133BABeech 1900C · S/N UB54Built 1986 · Provo, UT N149SFBeech 1900C · S/N UC-149Built 1991 · Provo, UT N14MVBeech 99 · S/N U59Built 1969 · Provo, UT N150KJBeech 1900C · S/N UC-150Built 1991 · Provo, UT N153GABeech 1900C · S/N UB-34Built 1985 · Provo, UT N153GLBeech 1900D · S/N UE-153Built 1995 · Provo, UT N154GABeech 1900C · S/N UB-25Built 1984 · Provo, UT N154GLBeech 1900D · S/N UE-154Built 1995 · Provo, UT N165YVBeech 1900D · S/N UE-165Built 1995 · Provo, UT N169GLBeech 1900D · S/N UE-169Built 1995 · Provo, UT N170GLBeech 1900D · S/N UE-170Built 1995 · Provo, UT N172GABeech 1900C · S/N UB-11Provo, UT N1733GBeech P35 · S/N D-6949Built 1962 · Mclean, VA N178YVBeech 1900D · S/N UE-178Built 1995 · Provo, UT N184UXBeech 1900D · S/N UE-184Built 1995 · Provo, UT N190GABeech 1900C · S/N UB-1Built 1984 · Provo, UT N192GABeech 1900 · S/N UB-17Provo, UT N194GABeech 1900C · S/N UB-8Built 1984 · Provo, UT N195GLBeech 1900D · S/N UE-195Built 1996 · Provo, UT N197GABeech 1900C · S/N UB-16Built 1984 · Provo, UT N198GABeech 1900C · S/N UB-5Built 1984 · Provo, UT N201GLBeech 1900D · S/N UE-201Built 1996 · Provo, UT N202UXBeech 1900D · S/N UE-202Built 1996 · Provo, UT N211GLBeech 1900D · S/N UE-211Built 1996 · Provo, UT N216CSBeech C-99 · S/N U-216Built 1983 · Provo, UT N218SLBeech 1900C · S/N UC113Built 1990 · Provo, UT N219VPBeech 1900 · S/N UB-14Built 1984 · Provo, UT N220GLBeech 1900D · S/N UE-220Built 1996 · Provo, UT N231YVBeech 1900D · S/N UE-231Built 1996 · Provo, UT N236ALBeech C-99 · S/N U236Built 1987 · Provo, UT N237SLBeech C-99 · S/N U237Built 1987 · Provo, UT N238ALBeech C-99 · S/N U238Built 1987 · Provo, UT N239ALBeech C-99 · S/N U239Built 1987 · Provo, UT N240GLBeech 1900D · S/N UE-240Built 1996 · Provo, UT N245GLBeech 1900D · S/N UE-245Built 1996 · Provo, UT N247GLBeech 1900D · S/N UE-247Built 1996 · Provo, UT N253GLRaytheon 1900D · S/N UE-253Built 1996 · Provo, UT N253SFBeech 1900C · S/N UC53Built 1989 · Provo, UT

Back to Alpine Aviation Inc