Skip to content

Registered aircraft · 7,860

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.

N81WPPowell Richard J · Scranton, PABuilt 1978 · S/N 443 N8205HHaege Bradley D · Nashville, ILBuilt 2025 · S/N 5818 N820BBBroker William · Wylie, TXBuilt 2023 · S/N 007 N820CFDee III Balloon Team LLC · Holladay, UTBuilt 2021 · S/N 6924 N820PRPost Balloon Club Inc · Battle Creek, MIBuilt 2014 · S/N 6734 N820SBPost Balloon Club Inc · Battle Creek, MIBuilt 2008 · S/N 6529 N820TCKessenich Jeffrey A · Vancouver, WABuilt 1994 · S/N 2466USA N8217WMerlin Soaring Association Inc · Amelia Court House, VABuilt 1992 · S/N 357 N821TCGauthier Joseph R · Waterford, MIBuilt 1994 · S/N 2467USA N821ZEsser Paul H · Fairfield, CTBuilt 1966 · S/N 21 N8221KKlassen Thomas L · Corpus Christi, TXBuilt 1997 · S/N 551197093 N82233Ross Fred · Hollywood, FLBuilt 1995 · S/N 220 N822EHHamilton Elizabeth A · Hobe Sound, FLBuilt 2017 · S/N 5625 N822JHSkycab Balloon Promotions · Louisville, KYBuilt 2009 · S/N 5428 N822WBBaker William E · Tyler, TXBuilt 2006 · S/N 56/34 N823LMHunt Logan G · Corry, PAS/N F7-898 N823TJCandelaria Gerald J · Albuquerque, NMBuilt 2022 · S/N 1911 N8241Ashcraft Luke · San Francisco, CABuilt 2015 · S/N 29093 N8241ESo Soo Flying Club · South Sioux City, NEBuilt 1961 · S/N 927 N8246ARoss Fred · Hollywood, FLBuilt 1997 · S/N 235 N824XGHewitt Ronnie E · Villa Rica, GABuilt 1992 · S/N RX8-3143 N8257Dupre Sam · Peyton, COBuilt 1974 · S/N 78 N825FBFreedom Ballon Rides LLC · Indianola, IABuilt 2024 · S/N 6988 N825WBAerosports Inc · Cleveland, NCBuilt 2009 · S/N 6558 N826KBFoelske Aaron J · New Lenox, ILBuilt 2011 · S/N 826 N826KMMinckler Kevin M · East Haven, CTS/N 495 N826SHHundley Stephen C · Dallas, TXBuilt 2000 · S/N 104 N826TCBogle Edward T · Los Lunas, NMBuilt 1994 · S/N 2647USA N826ZBZb Promotions LLC · Ashland, OHBuilt 2023 · S/N 5798 N8271MBoyd David R · San Jose, CAS/N 21062041 N827BBBluedorn Charles Britton · Palmdale, CABuilt 2004 · S/N 27230 N827BCChristian Bret A · Indianola, IABuilt 2009 · S/N 5433 N827SGGalatioto Santo J · Orange, CTBuilt 2015 · S/N 2015-54-1 N8282ESundance Balloons US Ltd · Belmont OntarioBuilt 1996 · S/N 3945 N828BHTaylor Clyde E · Jefferson, GABuilt 2002 · S/N 28059 N828JNHutnick Michael C Jr · Bloomsburg, PABuilt 2001 · S/N 120 N828LAMay First Inc · Fishers, INS/N 481 N8295Boland Brian J · Post Mills, VTBuilt 1974 · S/N 3 N829FFox Blue LLC · Portland, ORS/N 1685 N82DDSale Reported · Cumberland Gap, TNSale reportedBuilt 1999 · S/N 38 N82VASoaring Adventures LLC · Fort Collins, COBuilt 2003 · S/N 76 N83030Foster Andrew L · Canton, MAS/N 268 N83036Mckinley Barbara M · Siler City, NCBuilt 1997 · S/N 256 N8304TAnson Jeanne Marie · Brandon, SDBuilt 1993 · S/N 219 N8305NBristol David W · Sautee, GABuilt 1995 · S/N 226 N8307FHolmestead Aviation LLC · Lebanon, TNBuilt 1998 · S/N 267 N8307MBristol David W · Sautee, GAS/N 218 N8307XMccord Mikael R · Albuquerque, NMS/N 271 N8308DGomez Stevie T · Albuquerque, NMBuilt 1997 · S/N 261 N830ALZielinski Alan Wayne · Niles, ILBuilt 1997 · S/N F71028