Skip to content

Registered aircraft · 144

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2210302', '2210400')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2210302', '2210400')
ORDER BY 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.

N100HUSimpson Jared S · Malad City, IDBuilt 1996 · S/N 1319 N104CAMeggers Roger D · Baker, MTBuilt 1996 · S/N 1338 N107AMYoung Mark · Vancouver, WABuilt 1997 · S/N 1385 N111TQEngbring Paul · Telluride, COBuilt 1993 · S/N 1243 N116QCigarroa Jorge J · Laredo, TXBuilt 1997 · S/N 1360 N117RJFine Frank E · Oakdale, CAS/N 1314 N11KZHigh Tale LLC · Saint Anthony, IDBuilt 1998 · S/N 1393 N121HHTimm Robert S · Minneapolis, MNBuilt 1992 · S/N 1209 N1275BWeisgram Ted · Corbett, ORBuilt 1995 · S/N 1287 N12HUVintage Flyers LLC · The Villages, FLBuilt 1997 · S/N 1345 N12TQWyoming Aeroflight LLC · Laramie, WYBuilt 1994 · S/N 1270 N13HUSzalay Dennis R · Mooresville, INS/N 1323 N14KKBeachrock Logistics LLC · Lafayette, LABuilt 1994 · S/N 1272 N151SLChambers Scott K · Aurora, ORBuilt 1993 · S/N 1255 N157TBPerrin James F · Bancroft, WIBuilt 1997 · S/N 1389 N15HUBratton Gary · Poteau, OKBuilt 1996 · S/N 1318 N17SLTastad Joel M · Hager City, WIBuilt 1997 · S/N 1368 N180HJSummit Peak Holdings LLC · Missoula, MTS/N 1305 N180HUScarberry Dennis Lee · Goddard, KSBuilt 1996 · S/N 1333 N188WBNelson Pete L · Challis, IDBuilt 1994 · S/N 1263 N193JTMaroon Aviation LLC · Ferriday, LAS/N 1233 N194RLDorris Richmond Sloan · Anchorage, AKS/N 1266 N196PFCloudbase Imaging LLC · Erie, COBuilt 1995 · S/N 1301 N200HGBallou-Crawford Terry F · Enid, OKS/N 1200 N200HUVanderhoof Chad T · Elk, WABuilt 1992 · S/N 1203 N21AWMershon James W · Newcomerstown, OHBuilt 1998 · S/N 1399 N21HUSkyline Aviation LLC · Lewistown, MTBuilt 1995 · S/N 1291 N22HUGove Gary Alan · Marion, MTS/N 1355 N234HUStevens Matthew S · Penn Yan, NYBuilt 1996 · S/N 1336 N236CDLoven Richard · Waukon, IABuilt 1992 · S/N 1219 N23HGWilkinson Dan · Morgan, UTBuilt 1994 · S/N 1269 N241PArnston Ranch Inc · Circle, MTBuilt 1992 · S/N 1214 N258AKThompson Nick · Eagle, AKBuilt 1994 · S/N 1258 N27HUOlson Dorian J · Lake Park, MNBuilt 1997 · S/N 1359 N29HUClimb LLC · Kalispell, MTS/N 1381 N300HUMackes Michael Trustee · Gardnerville, NVBuilt 1997 · S/N 1358 N301MXRockin T Construction Inc · Swan Valley, IDBuilt 1998 · S/N 1391 N31HUStella Air Inc · Wyoming, PABuilt 1995 · S/N 1294 N321SASedlak Julien · Fort Worth, TXBuilt 1993 · S/N 1251 N323SAPfister Patrick · Pinedale, WYBuilt 1993 · S/N 1254 N334CBBarrett Jeff B · Mendota, ILBuilt 1992 · S/N 1232 N33AVMaurer Sara Ann · Anchorage, AKBuilt 1996 · S/N 1332 N33HURunzel Brothers Aviation LLC · Bensenville, ILS/N 1310 N345HUSkydotcom LLC · Inver Grove Height, MNBuilt 1996 · S/N 1312 N360HUParker John J · Hamilton, MTBuilt 1996 · S/N 1341 N36LEViens Ernest W Jr · Eagle River, AKS/N 1198 N377Rancho Bonito LLC · Oxnard, CABuilt 1997 · S/N 1344 N3QRKittridge Gordon · East Corinth, VTBuilt 1997 · S/N 1361 N3XJJax Transport LLC · Amarillo, TXS/N 1390 N400JSKing Canyon Buffalo Inc · Denver, COBuilt 1996 · S/N 1328

Back to Aviat A-1