Skip to content

Registered aircraft · 7,848

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.

N1000ALewis Steven G · Salida, COBuilt 1978 · S/N 3255 N1000GSumofiber LLC · Bountiful, UTBuilt 2025 · S/N 2451 N1000ZButler Blake B · Shelbyville, TNBuilt 1960 · S/N 880 N1002ZArnold Sarah D · Benton, TNBuilt 1961 · S/N 984 N1004YNakamura Judith · Placitas, NMBuilt 2006 · S/N 6384 N1006PPhiladelphia Glider Council · Hilltown, PABuilt 1977 · S/N 1668 N100BFBasler Turbo Conversions LLC · Oshkosh, WIS/N 50796 N100DCLang Christopher A · Casper, WYBuilt 1974 · S/N 20008 N100FHJaswal Faisal S · La Conner, WABuilt 1993 · S/N 001 N100KMSorenson Daniel K · Tucson, AZBuilt 1998 · S/N 11 N100LBWooge Glen Scott · Swisher, IABuilt 1996 · S/N 222 N100UMKing Michael G · Sandia Park, NMBuilt 2000 · S/N 6272 N100XLLaitinen David P · Raleigh, NCBuilt 1979 · S/N 3401 N10113Skywalker Balloon Co LLC · Tallahassee, FLBuilt 2021 · S/N 1790 N10124Shafer James P · Kunkletown, PABuilt 1966 · S/N R-2 N1015ZPfeiffer Neal J · Wichita, KSBuilt 1959 · S/N 30 N1017Jednacz Scott T · Bixby, OKBuilt 1967 · S/N 41 N101ASWilliams Roy S · Kendallville, INS/N 027063 N101BPPost William S · Custer, WABuilt 1994 · S/N 101 N101CXMoses Charles A III · West Friendship, MDBuilt 1983 · S/N 101 089 N101CYHarris G Paul · Pine, COBuilt 1994 · S/N 007 N101FHBadzelewicz-Hartl Irena · Scotch Plains, NJBuilt 1981 · S/N 4083 N101GMBlack Forest Soaring Society · Elbert, COBuilt 1997 · S/N 17.09.009 N101LBWooge Glen Scott · Swisher, IABuilt 1993 · S/N 223 N101LELogan Air Services LLC · Logan, UTBuilt 1990 · S/N 907601 N101LVRosenthal Bruce D · Wickenburg, AZS/N 10100264 N101PLaviolette Michael Anthony · Corvallis, ORBuilt 1969 · S/N 001 N101RPBuchanan Jay D · Council Bluffs, IABuilt 1982 · S/N E102G72 N101TMLavoie Michael T · West Ossipee, NHBuilt 2008 · S/N 002 N101TXMapes Steven J · Schenectady, NYBuilt 1984 · S/N E168G 134 N101ZLAllen Scott · Overland Park, KSBuilt 2009 · S/N 6571 N1020QMike Rinker Aircraft LLC · Union City, TNS/N 115-0426 N1022RRegistered aircraftS/N 6446 N1024BBaldwin Roger · Bosque Farms, NMBuilt 2004 · S/N 6371 N1024PByron George James Jr · East Haddam, CTBuilt 1981 · S/N 1 N1028PLta Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2235 N102BMBradley Boroughs Inc · Louisville, KYBuilt 2003 · S/N 77/231 N102DVSaint Louis Soaring Association · Saint Louis, MOS/N 5641S N102ETStevenson David L · Sugar Grove, OHBuilt 1979 · S/N 120 N102GBCibotti Ricardo Roque · Bethesda, MDS/N 1424 N102KWabash Valley Soaring Association Inc · Lawrenceville, ILBuilt 1967 · S/N 4108 N102LBCatskill Mountain Balloon Inc · Oneonta, NYBuilt 2015 · S/N 5575 N1031Kite Adam H · Ogden, UTBuilt 1966 · S/N 8 N1031JAnderson Justin C · Walla Walla, WABuilt 2025 · S/N 001 N10324Boland Brian J · Post Mills, VTBuilt 1980 · S/N 11 N10330Buergel Sandra J · East Aurora, NYBuilt 1960 · S/N 72 N10352Wichita Soaring Association Inc · Wichita, KSBuilt 1960 · S/N 81 N10354Rebholz Mark A · Aguila, AZBuilt 1960 · S/N 82 N10356Dobbins John R · Green Valley, AZS/N 195 N10357Niagara Soaring Club · Williamsville, NYBuilt 1960 · S/N 85