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.

N7104RSky Adventures Inc · Oxford, MIS/N F8B-093 N7105DStrobel Rodney W · Canton, OHS/N F8B-095 N7105HHarbold Clarke D · Charlotte, NCS/N F7-377 N7105JCoffer Erika J · Harvard, ILBuilt 1995 · S/N S53A-3008 N7105YSmileys Dream Ballooning LLC · Santaquin, UTBuilt 1987 · S/N F8B-099 N71063Get High Incorporated · Longview, TXS/N F7-391 N7106ENiccum Jonathan S · Hampden, MABuilt 1987 · S/N F7B-134 N7106RGoodson Andrew J · Oxford, MIBuilt 1987 · S/N F7-387 N7106XVezzosi Rosalie I · Milford, NJBuilt 1987 · S/N F7-390 N71072Matney Dallas L · Sparta, MOBuilt 1995 · S/N S57A-3180 N71087Coffman Leroy B II · Fresno, CABuilt 1995 · S/N F8B-482 N7108CSewell Robert M · Reno, NVS/N F8B-114 N7108KWright Joshua A · Knoxville, TNBuilt 1987 · S/N F8B-105 N7108MAdams Tyler J · Kennewick, WABuilt 1995 · S/N S53A-3010 N7108NBalloons Unlimited Inc · Middleburg, VAS/N F8-105 N7108TSchilling William J · Reno, NVBuilt 1987 · S/N F8B-111 N7108UTriple T Aviation LLC · Los Lunas, NMBuilt 1995 · S/N XP-3007 N71096Davison Associates Inc · Phoenix, AZBuilt 1995 · S/N S57A-3172 N710BWCooley Brooks Taylor · Hockessin, DEBuilt 2002 · S/N 026 N710JWTaylor Timothy A · Hurricane, UTBuilt 2008 · S/N 122 N710MWWallace Marilyn · Santa Monica, CABuilt 2015 · S/N 6760 N710QATatum Daryl A · Canton, GABuilt 2016 · S/N 206 N71104Stahlecker Matt M · Napa, CAFirst renewal noticeBuilt 1987 · S/N F8B-116 N71106Sena Paul A · Worthington, MAS/N F7B-136 N71113Avian Balloon Company Inc · East Bend, NCBuilt 1987 · S/N F8B-117 N7111GJones Christopher J · Billings, MTS/N S55A-3068 N7115Schipper Gail C · Longmont, COBuilt 1967 · S/N 50 N71159Mccalla Darrell P · Mountain Brook, ALFirst renewal noticeBuilt 1988 · S/N F7-420 N7115HMakhlouf Mary H · Hurdle Mills, NCBuilt 1987 · S/N F6B-026 N7117CBliss Stephen D · Norwich, NYBuilt 1988 · S/N F7-417 N7118ASally T Ware · Salt Lake City, UTBuilt 1995 · S/N RX7-3310 N7118FGordon Edward G · Austin, TXBuilt 1995 · S/N RX7-3311 N71192Seeger Kenneth Anthony · Travelers Rest, SCS/N F8B-141 N711ARFlying Burrito LLC · Placerville, CABuilt 1982 · S/N EA-284 N711CXJdbsb LLC · Las Vegas, NVS/N 7342C N711EFThornton Floyd R · Saint Louis, MOBuilt 1997 · S/N S60A-3225 N711GRInverted Manikaka LLC · Bella Vista, ARS/N 30 N711JRBell Kenneth Charles · Wilmington, VTS/N 8064C N711KXKelley Thomas E · Alamogordo, NMBuilt 2006 · S/N 29016 N711KYVon Berckefeldt Richard W · Franklin, TNBuilt 2002 · S/N 27177 N711TZJw Group Holdings Co LLC · Coopersburg, PABuilt 2022 · S/N LP2022-03 N711UMHoch Darcy R · Milo, IABuilt 2004 · S/N 65/131 N71208Sale Reported · Marlton, NJSale reportedBuilt 1987 · S/N 5352 N7120ASperry Brock A · Battle Creek, MIBuilt 2023 · S/N 6970 N7120XFisher Craig D · Wellington, COBuilt 1988 · S/N F7-429 N7121CHarris Stephen M · North Clarendon, VTBuilt 1988 · S/N F8B-143 N7121JWicker Basket Balloon Center · Wixom, MIBuilt 1988 · S/N F8-127 N7122MA To Z Ballooning LLC · Mesa, AZBuilt 2025 · S/N 2543 N7122ZLeisek John C · Tooele, UTFirst renewal noticeS/N F7-432 N7125JPennell Mark G · Sparta, NCS/N F7-448