Registered aircraft · 20

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

N138AChiavetta Andy LANCAIR LEGACY · S/N L2K-138Built 2002 · Uvalde, TX N15TZCessna 750 · S/N 750-0127Uvalde, TX N28QACessna 525 · S/N 5250215Built 1997 · Uvalde, TX N322SBCessna 525C · S/N 525C0053Built 2011 · Uvalde, TX N326KFCessna 510 · S/N 510-0326Built 2010 · Uvalde, TX N34TCCessna 525 · S/N 5250083Built 1994 · Uvalde, TX N373HSEurocopter EC120B · S/N 1490Built 2007 · Uvalde, TX N42VUCirrus Design SR20 · S/N 2440Built 2018 · Uvalde, TX N46KKTextron 525 · S/N 525-1013Built 2018 · Uvalde, TX N614CHHuffstutler Mark SPORT TRAINER · S/N 4295Built 2005 · Reno, NV N6274ECessna 172 · S/N 46374Built 1959 · Uvalde, TX N678LSAero Vodochody L39C · S/N 430404Built 1974 · Uvalde, TX N67MHSchempp-Hirth Flugzeugbau VENTUS 3M · S/N 262 MPBuilt 2025 · Uvalde, TX N723SRClassic WACO YMF · S/N F5C-070Built 1996 · Reno, NV N739JSCessna 525B · S/N 525B0045Built 2005 · Uvalde, TX N7407CNorth American-Banaire Entprs. SNJ-4 · S/N 8813345Uvalde, TX N744JSCessna 525B · S/N 525B0304Built 2009 · Uvalde, TX N76MHSchempp Hirth Flugzeugbau ARCUS M · S/N 135Built 2016 · Uvalde, TX N850FTCessna 560XL · S/N 560-5807Uvalde, TX N8601XWing D-1 · S/N 008Uvalde, TX

Back to Huff Air LLC