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.

N6959Wille Chad C · Corning, IAS/N 8 N695BBRadowski Johnathan P · Phoenix, AZBuilt 2007 · S/N 106 N695UMessner Dale A · Uniontown, OHBuilt 1965 · S/N 223 N6969DAnnis Charles H · Morristown, NJBuilt 2020 · S/N 2020-01 N6969GGood John R · Baton Rouge, LABuilt 1999 · S/N 5107 N696CTSaint Louis Soaring Association Inc · Saint Louis, MOBuilt 2022 · S/N 21997 N696VBVista Balloon LLC · Portland, ORBuilt 2018 · S/N 210/120 N69720Midwest Glider Conservancy Inc · Wichita, KSBuilt 1943 · S/N 030.240 N697MHPate Earl G · Hickory, NCBuilt 2005 · S/N 163 N697UNevada Soaring Association Inc · Reno, NVBuilt 1965 · S/N 19 N697ZBruno Vassel · Draper, UTS/N 727 N698PAM&H Research & Development Corp · Elmira, NYBuilt 2011 · S/N 7 N698RRRed Rock Balloons · Cornville, AZBuilt 2023 · S/N 6987 N6998Johannesen Lars L · New Castle, DEBuilt 1971 · S/N 30A N699UZapata James A · Fallbrook, CAS/N 317 N699WHRobey Samuel B · Gladewater, TXBuilt 2000 · S/N S53A-3071 N69AZWelch Troy O · Graford, TXBuilt 1974 · S/N 205 N69BGKing Steven · San Jacinto, CABuilt 1981 · S/N 5560S N69FFWeeks Kermit · Polk City, FLFirst renewal noticeBuilt 2008 · S/N 5421 N69FTEndeavor Aviation Inc · Belgrade, MTBuilt 1995 · S/N S53A-3006 N69HLRenwick John K · Minneapolis, MNBuilt 1970 · S/N 122 N69JLLutkus Janet M · Medina, OHBuilt 1999 · S/N 111 N69KUToncray Tristan D O · Colorado Springs, COBuilt 2022 · S/N 2043 N69MCSproul Keith A · North Brunswick, NJBuilt 1993 · S/N RX8-3181 N69MMGiordano Christian J · Glendale, AZS/N 1329 N69RAGoebel James W · Loveland, OHS/N 571 N69SPHandcraft Furniture Balloon Rides LLC · Lake Tomahawk, WIBuilt 1972 · S/N S40A-122 N69WMBalloon Meadows Inc · Clinton Corners, NYBuilt 1983 · S/N F7B-068 N6DZMoses Charles A III · West Friendship, MDBuilt 1986 · S/N 6091 N6HLRegistration Pending · Pace, FLRegistration pendingBuilt 1975 · S/N 20057 N6LPNuss David A · Cortland, OHBuilt 1975 · S/N 436 N6MNSchoo Michael J · Ridgway, COBuilt 1986 · S/N 6070 N6NBBlaser Swisslube · Goshen, NYBuilt 2010 · S/N 1001 N6TWJonesing2fly LLC · Gig Harbor, WABuilt 1974 · S/N 539 N6VSFenix Space Inc · San Bernardino, CABuilt 1978 · S/N 20609 N6XBFessenden John F · Horseheads, NYBuilt 2000 · S/N 27126 N6XDButler Julie L · Los Osos, CABuilt 1987 · S/N 202 N6ZSColby Robert D · Bigfork, MTS/N 6028 N70001Schwartz Lorin P · Thornton, COBuilt 1981 · S/N E81709 N70002Walter Carolanne E · Lynnwood, WAS/N 213 N7000HNational Ballooning Ltd · Winterset, IAS/N 126 N70016Albert Daniel L · New Athens, ILBuilt 1994 · S/N S60A-3196 N7002JButera Joseph P · Gowanda, NYBuilt 1981 · S/N E81717 N7003Martin J Campbell · Tehachapi, CABuilt 1968 · S/N 12 N70047Avian Balloon Co · Spokane Valley, WABuilt 1984 · S/N 124 N7004NCampbell Danny D · Pleasant Hill, IABuilt 1997 · S/N 128 N70050Clark David R · Kent, OHBuilt 1997 · S/N 129 N70051Edmundson George · Hood River, ORBuilt 1987 · S/N 145 N7005HDavis William · Helena, ALBuilt 2020 · S/N RGX1638-0001 N7005JMullinax Thomas A · Greenville, SCBuilt 1987 · S/N 138