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.

N451CHBay Area Soaring Associates Inc · San Jose, CABuilt 2003 · S/N 10-23S23 N45251White Bernard C · Jackson, MIBuilt 1994 · S/N 5893 N4528EBristol David W · Sautee, GABuilt 1992 · S/N 188 N4528YOshields Wayne · Easley, SCBuilt 1992 · S/N 189 N452DSGriffin Nancy · Fort Collins, COBuilt 2006 · S/N 6475 N452HCloudbase Assets Ltd · Avon Lake, OHS/N 3E118 N452LBSumner Carlton R Jr · Rincon, GABuilt 2014 · S/N 5554 N45303Registration Pending · El Mirage, AZRegistration pendingS/N 154 N45318Adventures In Ballooning Inc · Port Saint Lucie, FLS/N 5898 N45320Berka Joel M · Binghamton, NYBuilt 1993 · S/N 5901 N4538LZip Zap Aviation LLC · Atlanta, ILBuilt 1979 · S/N AA5B-1295 N453CSSmart Chris T · Roanoke, INBuilt 2012 · S/N 6683 N45441Wildtiger Aerosports LLC · Topeka, KSS/N 5904 N4549JHigh Flight Ministries · Grass Lake, MIBuilt 1993 · S/N 5868 N454BKWooge Glen S · Swisher, IAS/N 5075 N454LBCole Dustin · Town Creek, ALBuilt 2005 · S/N 5313 N454SGMcconathy Jason · Granby, COBuilt 2001 · S/N 3E499A36 N4553Dyer Evan H · Whitmore Lake, MIBuilt 1968 · S/N 127 N4553APortland Rose Balloons LLC · Wilsonville, ORBuilt 1993 · S/N 5890 N45584Petitti Anthony J II · Canton, OHBuilt 1994 · S/N 5914 N4559NBucket List Adventures LLC · Albuquerque, NMFirst renewal noticeBuilt 1993 · S/N 5899 N4559ZBrielmann Kevin C · Cromwell, CTS/N 5915 N455ABRenaissance Balloons LLC · Hartland, MIS/N 6590 N455BASoaring Club Of Houston · Waller, TXBuilt 2003 · S/N 039020 N455NLNorthern Light Balloons Expeditions · Sedona, AZBuilt 2019 · S/N 300/73 N456DBMahony John · Ballston Spa, NYBuilt 1987 · S/N 25023 N456PHN456ph LLC · Rehoboth Beach, DES/N 659M N457BANorth Florida Soaring Society Inc · Jacksonville, FLBuilt 2004 · S/N 049102 N4582BLapointe Wilfred · Heber City, UTBuilt 2015 · S/N 1186 N458BKClosson Luke E Jr · Valdosta, GAS/N 6043 N4590GBerka Joel M · Binghamton, NYBuilt 2004 · S/N 1001 N459LBObrien Robert P · Waupaca, WIBuilt 2020 · S/N 5719 N45AVGibbons Thomas W · Stow, OHBuilt 1980 · S/N 45 N45AWWiederkehr Anthony C · Arlington, WABuilt 2002 · S/N 27175 N45EMGlaab Louis J · Hampton, VABuilt 1996 · S/N 27007 N45EWDoherty Mark R · Pryor, OKBuilt 1978 · S/N 3224 N45KAShumaker Timothy R · Brevard, NCBuilt 1977 · S/N 20589 N45THLane Christopher W · Conroe, TXFirst renewal noticeBuilt 1981 · S/N 4085 N45UMCollins Scott M · Belen, NMBuilt 2005 · S/N 90/76 N4600TDevine Steven C · Doylestown, PAS/N 6315 N4600YRainbow River Lodge Aviation LLC · Sandy, UTBuilt 1955 · S/N 993 N46096Padelt Albert F · Barto, PABuilt 2004 · S/N 1004 N460GHGoulding Haven H Jr · Howard, PABuilt 2001 · S/N 121 N460JRegistered aircraftBuilt 2023 · S/N 2121 N461FYonge Robert R · Ocala, FLBuilt 1971 · S/N 3014 N461JKWind Surfer Ballooning LLC · Carlisle, IABuilt 2008 · S/N 631 N461RBBogardus George R · Jacksonville, ORS/N 10 N461SHAir America Promotions Inc · Deltona, FLBuilt 1996 · S/N S53A-3021 N4622SBitikofer Dawid K · Kansas City, KSS/N 23 N4637TMetz Stephen V · Stanton, MNBuilt 1964 · S/N 7153