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.

N6112CSchultz Scott C · Fountain, COBuilt 1995 · S/N 5992 N6115GZing Aerosports LLC · Peoria, AZS/N 5539 N6117UKeller Clifford G · Santa Cruz, NMBuilt 1989 · S/N 5541 N611CWMoondance Balloons LLC · Swisher, IABuilt 2025 · S/N 5816 N6123YLopez-Cortes Ignacio · Napa, CABuilt 1989 · S/N 5511 N6128BAir Carriage LLC · Albuquerque, NMBuilt 2018 · S/N 1415 N612KDDraughn Kenneth W · Burlington, NCBuilt 2012 · S/N 5501 N612MGMid-Georgia Soaring Association Inc · Monroe, GABuilt 1992 · S/N 21544 N613FPCox Jordan R · Carmel, INBuilt 2004 · S/N LPC 200410 N613UMKeller Ann T · Indianola, IABuilt 2005 · S/N 65/148 N61414Salt Lake Soaring LLC · Helena, MTBuilt 2022 · S/N 1998 N614BDGraham Keith P · Alta Loma, CAS/N F8B-496 N614DGU S Air Force · Usaf Academy, COBuilt 2012 · S/N 10-183S113 N614JRBalloons Over Westchester LLC · Bedford, NYBuilt 1994 · S/N S49A-3186 N614LBEakin Sean T · Placitas, NMBuilt 2015 · S/N 5580 N614RPLeonard Steven E · Wichita, KSS/N 48 N614TWAir Ventures Balloon Rides Inc · Paoli, PABuilt 2022 · S/N 1984 N61502Carter Jonathan P · Honey Brook, PAS/N 6009 N61503Berka Joel M · Binghamton, NYBuilt 1996 · S/N 6010 N6152Ashmore Paul A · Sioux Falls, SDBuilt 1970 · S/N 121 N6154YSteenblik Jan W · Bloomington, INFirst renewal noticeBuilt 1961 · S/N 398 N61552Coyote Balloons US · Mc Cook, NEBuilt 1993 · S/N 470001 N61553Kugler John · Mccook, NES/N 470002 N6155VDavis Chet · Kent, OHBuilt 1996 · S/N 6014 N6159Leonard Steven E · Wichita, KSBuilt 1970 · S/N WVB/WTM-11-70 N6159MAdrian Soaring Club Inc · Ypsilanti, MIBuilt 1961 · S/N 86-58 N615DGUS Air Force · Usaf Academy, COBuilt 2012 · S/N 10-184S114 N615JRTewksbury Balloon Adventures LLC · Whitehouse Station, NJBuilt 2007 · S/N 6486 N615LBChism John B · Fishers, INBuilt 2013 · S/N 5539 N615PLipscomb James W · Salt Lake City, UTBuilt 1971 · S/N 15133 N615SHSekban Ali M · Honolulu, HIBuilt 2005 · S/N 015 N615XItalo Valentino Vasili · Atlanta, GABuilt 1967 · S/N 40 N61636Knerr Joshua D · Tehachapi, CAS/N 86 N6164RFour Corners Balloon Rides LLC · Rio Rancho, NMBuilt 1995 · S/N 5999 N6164ZMouser Emily S · Canton, OHBuilt 1996 · S/N 3638 N616BGHigher Reach LLC · Meridian, IDBuilt 2002 · S/N S57A-3238 N616DGU S Air Force · Usaf Academy, COBuilt 2012 · S/N 10-185S115 N616TPHardee Jewell E · Keller, TXS/N 0-4449 N617MTMcclung Collin P · Albuquerque, NMBuilt 2016 · S/N 5622 N618MCCowie Mary L · Jonesburg, MOBuilt 1975 · S/N 18006 N618SPBalloon Travels Unlimited · Marion, IABuilt 2018 · S/N 6854 N618WZAbove It All Balloon Co Inc · Basalt, COBuilt 2016 · S/N 6798 N6191Szostak Edward M · San Diego, CABuilt 1966 · S/N 718 N619DGPs Soaring Inc · Bellefonte, PAS/N 69 N619DLLiberti Daniel J · Rio Rancho, NMBuilt 2013 · S/N ZR-002 N619JCEscape Adventures Inc · Temecula, CABuilt 2014 · S/N 300/51 N619KMSpinetta Lawrence J · Austin, TXS/N 019 N619TBTitov Iulian · Temecula, CABuilt 1985 · S/N 619 N61AGWolsey Brandon · Salt Lake City, UTBuilt 1985 · S/N 50 N61BRBryant Thomas A · Tallahassee, FLBuilt 1999 · S/N 990505