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.

N248TWBlizzard William · Albuquerque, NMBuilt 2023 · S/N 2124 N2493WRasmussen Steven T · Papillion, NEBuilt 1967 · S/N 379 N2494WTalley Michael L · Arlington, WABuilt 1967 · S/N 47 N2495WSky Sailing Inc · Warner Springs, CABuilt 1967 · S/N 48 N2497WLeroy Phillippe G · Willcox, AZBuilt 1967 · S/N 382 N2498WChristmas Michael G · Long Beach, CABuilt 1967 · S/N 46 N2499Ayotte Stewart R · Glendale, CABuilt 1988 · S/N 24009 N249AFBlakeslee Raymond D · Chesapeake, VABuilt 1968 · S/N 421 N249JPPatton Bruce E · Temple Terrace, FLBuilt 1963 · S/N 5027 N249TBAbove Reality Inc · Jericho, VTBuilt 2020 · S/N 1672 N24CLMarshall Michael A · Hanover, MDS/N 20836 N24HCLeonard Steven E · Wichita, KSBuilt 1977 · S/N 54 N24HYTlc2 LLC · Missoula, MTBuilt 2025 · S/N 2438 N24LLLitton Jenna · Statesville, NCS/N 118 N24MZAcree Randall D · Tucson, AZBuilt 1981 · S/N 24 N24NCSb3 Asset Management LLC · Gilbert, AZBuilt 1999 · S/N 228 N24PJDunning Francis M · Madison, WIBuilt 1992 · S/N 24189 N24TQHowes William R · St George, UTBuilt 2011 · S/N 871 N24UMSonoma Ballooning Adventures LLC · Sonoma, CABuilt 2025 · S/N 300/129 N24VFEly Osvaldo Bins · Cedar Park, TXBuilt 1996 · S/N 024 N24WAPurcell David S · Chandler, AZBuilt 1982 · S/N 20488 N24XRLta Aviation LLC · Wilmington, DEBuilt 2025 · S/N 2555 N25000Leonard Steven E · Wichita, KSBuilt 1967 · S/N 1 N25001Leonard Steven E · Wichita, KSBuilt 1967 · S/N 1 N25007Bourdon David A Jr · Green Cove Springs, FLBuilt 1968 · S/N 041 N25026Harrison Stephen · Ballston Spa, NYBuilt 1972 · S/N 355 N2502KClark Roger D · Greer, SCBuilt 1991 · S/N F7-764 N25048Carnegie Ronald S Jr · Williamsburg, VABuilt 1992 · S/N F8B-407 N2505HWhite Sands Soaring Foundation Inc · Alamogordo, NMBuilt 1976 · S/N 645 N2508HCleveland Soaring Society · Hartville, OHBuilt 1976 · S/N 648 N2509Bjork Richard J · Brackettville, TXBuilt 1971 · S/N 213 N250BENorthern Light Balloon Expeditions/Sedona Balloon · Sedona, AZBuilt 2012 · S/N 250/79 N250BLHarris Mark G · Denver, COBuilt 2021 · S/N B001 N250BRCampbell Brittany Rose · Los Lunas, NMBuilt 2021 · S/N 250/103 N250KBMars Leasing Co · Phoenix, AZBuilt 2014 · S/N 1061 N250NSNapa Valley Aloft Inc · Yountville, CABuilt 2015 · S/N 1150 N250NZRuby Crest LLC · Girdwood, AKBuilt 1989 · S/N 25062 N250PRPortland Rose Balloons LLC · Wilsonville, ORBuilt 2025 · S/N 2432 N250PVNapa Valley Aloft Inc · Yountville, CABuilt 2021 · S/N 1876 N250RRegistered aircraftBuilt 1994 · S/N 5972 N250VBVista Balloon LLC · Portland, ORBuilt 2025 · S/N 180/176 N250WCEagle Point Endeavors LLC · Central Point, ORBuilt 2015 · S/N 1179 N250WWId Georgia Soaring Assn Inc · Monroe, GABuilt 1998 · S/N 250CS N250YVNapa Valley Aloft Inc · Yountville, CABuilt 2021 · S/N 1714 N2511THoglan Brett A · Brighton, COS/N 3 N2512HBenson Arthur V · Brunswick, GAS/N 662 N25133Hills William F · Lambertville, NJS/N RS-15-21 N2513HCaprock Soaring Association · Lubbock, TXBuilt 1977 · S/N 663 N25156Cohn Michael L · Severna Park, MDBuilt 1976 · S/N AM-2 N2515HMerlin Soaring Association Inc · Amelia Court House, VABuilt 1976 · S/N 655