Skip to content

Registered aircraft · 7,857

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.

N304DDBehm Christopher B · Harbor City, CABuilt 1999 · S/N 7 N304DJRobinson Douglas J · Littlerock, CABuilt 1998 · S/N 6 N304FTRodriguez Joseph R · Lake Elsinore, CABuilt 2000 · S/N 28 N304GTDe La Torre Robert · Scottsdale, AZBuilt 2002 · S/N 62-C N304HVRizy David J · Arlington, TXBuilt 1999 · S/N 11 N304JDLysy David G · Lyme, NHBuilt 2000 · S/N 30 N304LSkorikov Viktor · Los Angeles, CABuilt 2000 · S/N 29 N304LSStreppel Thorsten · Cohasset, MABuilt 1985 · S/N 6042 N304MTMcallister Timothy S · Miami, FLBuilt 2002 · S/N 45-C N304PMPost Mills Soaring Club Inc · Lyme, NHBuilt 2002 · S/N 47-C N304RKScott Randy W · Maple Valley, WABuilt 2002 · S/N 46-C N304TJRegistration Pending · Raleigh, NCRegistration pendingBuilt 2002 · S/N 53-17 N304TMAirtravel LLC · Reno, NVBuilt 2000 · S/N 19 N304WWescott Thomas F · San Diego, CAS/N 5 N304WNLynskey Stephan E · Exeter, NHBuilt 2014 · S/N 074-C N304XSRapp Michael T · Temecula, CABuilt 2002 · S/N 60-17 N304ZSZero Sink Inc · Wilmington, DEBuilt 2002 · S/N 52-C N30505Richter Thomas P · Buffalo, NYBuilt 1976 · S/N 1279 N3052PClemons Louise E DBA · Truro, IABuilt 2005 · S/N 153 N3058FAley David K · Albuquerque, NMBuilt 1996 · S/N 6040 N305BAMcbee Andrew W · Portland, ORBuilt 1996 · S/N 960408 N305BGStreamline Aviation LLC · Battlefield, MOS/N 5642CB N305CSFirewalker Balloon Adventures LLC · Battle Creek, MIBuilt 2018 · S/N 6858 N305MGN305mg LLC · Homestead, FLBuilt 1992 · S/N 917930 N30609Remax Marketing Fund LLC · Denver, COBuilt 2018 · S/N 5674 N3064PCarolina Soaring Association · Spartanburg, SCBuilt 1975 · S/N 1052 N3064RWalker David C · Laclede, MOBuilt 2006 · S/N 158 N3065YAerostatica Inc DBA · Ann Arbor, MIBuilt 1996 · S/N 6062 N30667Hoffmann Justin P · Sandoval, ILS/N 5601 N30693Colegate Terry · Breaux Bridge, LABuilt 1999 · S/N 275 N3069WAppenzeller Allan Dean · Indianola, IABuilt 2017 · S/N 5644 N306BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 968304 N306DGUS Air Force · U S A F Academy, COBuilt 2011 · S/N 10-175S105 N306EKnox Ohio III · Albuquerque, NMBuilt 2023 · S/N 508 N306FBMastis Linas V · Green Cove Springs, FLBuilt 1991 · S/N 054 N306MKCarlson Michael L · Shelbyville, KYBuilt 1965 · S/N 14 N306MMDisneyland Resort · Boise, IDBuilt 2006 · S/N 6445 N306TMCook David E · Montgomery, TXBuilt 2002 · S/N 55-C N30722Boylan Michael E · Washington, ILBuilt 2000 · S/N 288 N3073DBader Jeffrey A · Butler, PABuilt 1998 · S/N 265 N3074WWoodward Jay · Snohomish, WABuilt 1996 · S/N 6024 N3075Gradwell Dean H · Jacksonville, ORBuilt 1965 · S/N 4024 N3077LWerder Harold D · Hudson, FLFirst renewal noticeBuilt 1994 · S/N F8B-473 N3077RRonning Enterprises Inc · Sioux Falls, SDBuilt 2015 · S/N 5595 N3078EEgerton Clinton W · Brevard, NCBuilt 1997 · S/N F8B-548 N3079KNowak Lorraine K · Xenia, OHBuilt 1999 · S/N 277 N307BGRunway 5 LLC · Wurtsboro, NYS/N 34032-K-264 N307PBSproul Keith A · North Brunswick, NJBuilt 2007 · S/N 2007104 N3080AMccann Craig S · Jamestown, NYBuilt 2002 · S/N 314 N3081JMurphy Charles P · Augusta, GABuilt 2007 · S/N 004K