Skip to content

Registered aircraft · 30

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

N114KCEmbraer S A EMB-505 · S/N 50500067Built 2011 · South Burlington, VT N16ARHelicopteres Guimbal CABRI G2 · S/N 1412South Burlington, VT N17NBoeing A75N1(PT17) · S/N 75-3667Built 1943 · South Burlington, VT N17SEPilatus PC-12/47E · S/N 1322Built 2011 · South Burlington, VT N209JPCessna 208 · S/N 20800409Built 2007 · South Burlington, VT N21157Cessna 172M · S/N 17263901Built 1974 · South Burlington, VT N363KSSchleicher ASK-21 · S/N 21228Built 1984 · South Burlington, VT N371PAHelicopteres Guimbal CABRI G2 · S/N 1078Built 2014 · South Burlington, VT N399CLSaab SAAB 340B · S/N 340B-399Built 1996 · South Burlington, VT N401SHHelicopteres Guimbal CABRI G2 · S/N 1195Built 2017 · South Burlington, VT N415TSDiamond Aircraft Ind DA 42 · S/N 42.AC015Built 2006 · South Burlington, VT N52332Cessna 182P · S/N 18262534Built 1973 · South Burlington, VT N533LPPipistrel D O O ALPHA TRAINER · S/N 1220 AT 912 LSABuilt 2024 · South Burlington, VT N534LPPipistrel D O O ALPHA TRAINER · S/N 1222 AT 912 LSABuilt 2024 · South Burlington, VT N540LPPipistrel D O O VIRUS SW 121A · S/N VSWX121A0181Built 2025 · South Burlington, VT N58957Boeing D75N1 · S/N 75-3850Built 1942 · South Burlington, VT N60AFStemme S10-VT · S/N 11005Built 1998 · South Burlington, VT N801RPPipistrel D O O ALPHA TRAINER · S/N 1224 AT 912 LSABuilt 2024 · South Burlington, VT N802RPPipistrel D O O ALPHA TRAINER · S/N 1251 AT 912 LSABuilt 2024 · South Burlington, VT N803EPPipistrel D O O VIRUS SW 128 · S/N VSW128F0107Built 2024 · South Burlington, VT N804EPPipistrel D O O VIRUS SW 128 · S/N VSW128F0111Built 2024 · South Burlington, VT N805BTEurocopter AS 350 B3 · S/N 3563Built 2002 · South Burlington, VT N805EPPipistrel D O O VIRUS SW 128 · S/N VSW128F0112Built 2024 · South Burlington, VT N806BTPiper J3C-65 · S/N 5367Built 1940 · South Burlington, VT N807BTPipistrel D O O VIRUS SW 128 · S/N VSWX1280033Built 2021 · South Burlington, VT N808BTPipistrel D O O VIRUS SW 128 · S/N VSWX1280034Built 2021 · South Burlington, VT N813BTHelicopteres Guimbal CABRI G2 · S/N 1179Built 2017 · South Burlington, VT N870JTAir Tractor AT-802 · S/N 802-0870Built 2021 · South Burlington, VT N930AXSocata TBM 700 · S/N 1191Built 2017 · South Burlington, VT N98TSExtra Flugzeugbau EA 300/L · S/N 083Built 1999 · South Burlington, VT

Back to Beta Fleet LLC