Skip to content

Registered aircraft · 7,853

Aircraft with this engine 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 engine_model_code IN ('00000')
  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 engine_model_code IN ('00000')
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.

N140BHRegistered aircraftBuilt 2000 · S/N 85 N140CCBuzzards Glory Balloon Co LLC · Cedar Rapids, IABuilt 2011 · S/N 5485 N140CPColumbia Asset Trust Corp Trustee · Wichita, KSS/N 362SA N140ERegistered aircraftBuilt 1988 · S/N 5460 N140HVSawhill Matthew P · Ankeny, IABuilt 1964 · S/N W244 N140PSJohnson Durwood D · Beaumont, TXBuilt 1989 · S/N 1470US N140USKniffen Nicholas A · Tyndall, SDBuilt 1996 · S/N 1330 N140WBSkypoint Inc · Carmel, INS/N 2145USA N140XLAerosport Holdings Inc · Woodstock, GABuilt 2013 · S/N 5528 N1410CElevated Ballooning · Driggs, IDBuilt 2006 · S/N 5345 N1416KRocky Mountain Hot Air LLC · Denver, COBuilt 2012 · S/N 965 N141CKMitchell Steven J · Chagrin Falls, OHBuilt 2009 · S/N 6565 N141PRPortland Rose Balloons LLC · Wilsonville, ORBuilt 2024 · S/N 2280 N141SFThermal Energy Search LLC · Salida, COS/N 220 N141VEllertson Don R · Torrance, CABuilt 1983 · S/N 3 N141VGHult Philip C · Minneapolis, MNBuilt 2002 · S/N 05.001.09 N1424PStardrifter Hot Air Balloons LLC · Oakdale, MNBuilt 2001 · S/N 3343 N1426HLeota Kenneth R · Howell, NJBuilt 2016 · S/N 1236 N14287Fronius Douglas L · Poway, CABuilt 1946 · S/N CC4-36 N1428BSmith Richard G · Kokomo, INBuilt 1981 · S/N 37 N142AAniol Christopher M · Glendale, AZBuilt 1978 · S/N 20623 N142DCLyne James D Trustee · N Richlnd Hls, TXBuilt 1995 · S/N B-2162 N142KNimbus 4 Inc · Wilmington, DEBuilt 1998 · S/N 9 N142KAPfeiffer Neal J · Wichita, KSBuilt 1955 · S/N 126 N142PCCjm Aviation LLC · West Hartford, CTBuilt 1993 · S/N U-14 N142SSPittsburgh Soaring Association · Pittsburgh, PABuilt 1976 · S/N 1368 N14300Morozowsky Anthony II · Zanesville, OHS/N 3965 N1435Above The Clouds Inc · Middletown, NYBuilt 2020 · S/N 1716 N143CXHot Air Ohio LLC · Medina, OHBuilt 2006 · S/N 5331 N143DCBrooks Carolyn M · Milton Freewater, ORBuilt 2002 · S/N 5199 N143FSSilva Fernando · Atlanta, GABuilt 2023 · S/N 03-143 N143HSTalbert Elisa N · Albuquerque, NMBuilt 2007 · S/N 5378 N143SSBennett Wolfgang · Steamboat Springs, COBuilt 1976 · S/N 1370 N14420Shugg Gregory G · Flagler Beach, FLBuilt 1981 · S/N 175114 N144BAMaez Manuel E · Peralta, NMS/N 1133 N144CBGoss Richard · Leander, TXBuilt 2015 · S/N 6750 N144JSullivan Brent · Houston, TXBuilt 2000 · S/N 73 N144LHPaul John R · Hamilton, MTS/N RLH14 N144LSCulp John M · Asheville, NCBuilt 1985 · S/N 4481 N144RGAeronautical Solutions LLC · Taos, NMBuilt 2005 · S/N 10613 N144SMBalloonpong Enterprises LLC · Louisville, KYBuilt 2012 · S/N 6667 N144TCypress Soaring Inc · Hemet, CABuilt 1989 · S/N 266 N14501Eastern Shore Helicopters Inc · Labelle, FLBuilt 1968 · S/N 59 N1454ZOut There Outfitters LLC · Boise, IDBuilt 1955 · S/N 972 N1455ZD & B Aircraft Leasing LLC · Anchorage, AKBuilt 1953 · S/N 769 N14561Wells Russell L · Seville, OHS/N SEM-149 N145BAPulaski Robert A · Pineville, LABuilt 1987 · S/N 1132 N145BSDavid Lee Bradley Productions Inc · Temecula, CAS/N 130/41 N145EXCircle City Balloon Rides LLC · Indianapolis, INBuilt 2012 · S/N 6680 N145LBBiernacki Buzz · Albuquerque, NMBuilt 2005 · S/N 5314