Skip to content

Registered aircraft · 7,850

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.

N1084HVest Richard D · Jacksonville, FLS/N 101 N1084XJefferson County Sheriffs Office · Birmingham, ALS/N 5170 N1085YMoore George S · Sandpoint, IDBuilt 1995 · S/N 6224 N1087Airpower Museum Inc · Ottumwa, IAS/N 71 N10874Lake Elsinore Soaring Club · Wildomar, CABuilt 1972 · S/N 016 N108AClayton Harry L · Wichita, KSBuilt 1971 · S/N 140 N108AJChristensen Balloons LLC · Hot Springs, SDS/N 5512 N108DGDavid Lee Bradley Productions Inc DBA · Temecula, CABuilt 1998 · S/N 77/148 N108JFFreeman James E · Arlington, TXBuilt 1997 · S/N 17.09.008 N108KFForrest Services LLC · Dayton, NVBuilt 2017 · S/N 5645 N108WBBowman James A · Oklahoma City, OKBuilt 2001 · S/N 6284 N108WRHallett Mark R · Hobe Sound, FLBuilt 2002 · S/N 27189 N109Mikelsen Carlos A · Sun Prairie, WIBuilt 1981 · S/N 66 N1091RMouser Emily S · Canton, OHBuilt 2007 · S/N 142 N1095GFried Michael T · Albuquerque, NMBuilt 1972 · S/N 348 N1096FBalloons Over Bloomington LLC · Bloomington, INBuilt 2023 · S/N 401 N1099RTimblin Joel R · Plum City, WIBuilt 2002 · S/N RX8-3363 N109DArmstrong Ray C · Pinckney, MIS/N 2057 N109JKXclusive Balloons LLC · Taylorsville, KYBuilt 2006 · S/N 105/136 N109KMSorenson Kenneth G · Waller, TXBuilt 2009 · S/N 130 N109LHCato Joshl · Reno, TXBuilt 2013 · S/N 887 N109UAN109ua LLC · Havana, FLBuilt 1969 · S/N 174011 N109VTLamontagne Eric E · Harrisville, RIBuilt 2021 · S/N 001 N10BEBearden David Christopher · Austin, TXBuilt 2000 · S/N 6234 N10BHMastro Kevin J · Malvern, PABuilt 1970 · S/N 89 N10BRSale Reported · Peoria, ILSale reportedBuilt 1991 · S/N 917826 N10DVStringer Jeffrey H · Niskayuna, NYBuilt 1963 · S/N 6023 N10FYNeubeck Michael B · Fayetteville, ARBuilt 2001 · S/N 117 N10GKLong Taylor · Hamilton, TXBuilt 1976 · S/N 19021 N10GVSoaring Science Inc · Wilmington, DEBuilt 1999 · S/N 56 N10JBBojack John · Duluth, GABuilt 2008 · S/N L10-011 N10LACondon Anthony B · Wichita, KSBuilt 1972 · S/N 280 N10LTGolomb Lawrence Jr · Visalia, CABuilt 1992 · S/N 6199 N10MGNoss John F · Round Hill, VABuilt 1980 · S/N 14 N10SWBaum Orthodontic Associates Inc · Los Angeles, CABuilt 2001 · S/N 28041 N10SZVenters Walter S · Huntsville, ALBuilt 2004 · S/N 88 N10TYMountain Peter W · Williams, AZBuilt 1971 · S/N 15127 N10UKLavoie Michael T · West Ossipee, NHBuilt 2022 · S/N 006 N10WHOdonnell Michael F · Newtown, PABuilt 1980 · S/N 19322 N10WKGilbertson Virgle · Goleta, CABuilt 1977 · S/N 80 N10WLBlue Ridge Hot Air Balloons LLC · Front Royal, VAS/N F8B-592 N10WMCalistoga Ballooning Adventures Inc · Napa, CABuilt 2012 · S/N 5479 N10ZFRegistration Pending · Loveland, OHRegistration pendingBuilt 1981 · S/N 42 N1101JGailitis Toms · North Troy, VTBuilt 1968 · S/N 073 N1102SBacon Robert J · Florence, MABuilt 1971 · S/N 502 N1103WWakker William A · Valleyford, WABuilt 2023 · S/N 001 N1104SDocherty Dennis G · Boxborough, MABuilt 1971 · S/N 504 N1105RBrookside Ballooning LLC · Pennington, NJBuilt 1976 · S/N S55A-297 N1105SRasmussen Steven T · Papillion, NEBuilt 1970 · S/N 500 N1106BWillat Garret · Warner Springs, CAS/N 68