Registered aircraft · 18

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

N145VARobinson Helicopter R44 II · S/N 13482Seguin, TX N152SRobinson Helicopter R44 II · S/N 14250Built 2018 · Seguin, TX N155MGRobinson Helicopter R44 II · S/N 12713Built 2009 · Seguin, TX N223VARobinson Helicopter R22 · S/N 4925Built 2025 · Seguin, TX N243EHRobinson Helicopter R22 BETA · S/N 3482Seguin, TX N258VADJI T20 · S/N 35PBICS0010XZASeguin, TX N271SHRobinson Helicopter R22 BETA · S/N 4240Built 2007 · Seguin, TX N306VARobinson Helicopter R44 · S/N 30111Built 2025 · Seguin, TX N4684SRobinson Helicopter R22 BETA · S/N 2996Built 1999 · Seguin, TX N513HPCessna T206H · S/N T20608285Built 2001 · Seguin, TX N544BBRobinson Helicopter R44 II · S/N 11592Built 2007 · Seguin, TX N58LERobinson Helicopter R44 II · S/N 11900Built 2007 · Seguin, TX N604JARobinson Helicopter R44 II · S/N 10179Built 2003 · Seguin, TX N743DPRobinson Helicopter R22 BETA · S/N 3429Built 2003 · Seguin, TX N7521ZRobinson Helicopter R22 BETA · S/N 3810Built 2005 · Seguin, TX N830JRobinson Helicopter R22 BETA · S/N 4236Built 2007 · Seguin, TX N860VARobinson Helicopter R22 BETA · S/N 3089Seguin, TX N938SHRobinson Helicopter R22 BETA · S/N 3915Built 2005 · Seguin, TX

Back to Veracity Aviation LLC