Skip to content

Buckeye DREAM MACHINE

Registered aircraft · 160

Aircraft of this model 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 aircraft_model_code IN ('05901BU', '059010A', '059010K', '05628L3', '059002R', '05627JC', '056305E', '056285E', '05629XP', '059017Y')
  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 aircraft_model_code IN ('05901BU', '059010A', '059010K', '05628L3', '059002R', '05627JC', '056305E', '056285E', '05629XP', '059017Y')
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.

N112EKBenfer Brian L · New Columbia, PABuilt 1998 · S/N 4089 N119SEWilliams Conley B · Duffield, VAS/N 4636 N120JAAndriotis John C · Hudson, FLS/N 5016 N1225SDetweiler Aaron · Greensburg, KYS/N 6689 N124JAAndriotis John C · Hudson, FLS/N 4804 N130JRBanes John R · Toddville, IABuilt 2001 · S/N 3373 N1315LVerburg Thomas C · Ada, MIBuilt 1995 · S/N 3276 N153CPPillman Francis C · Lake Geneva, WIBuilt 1999 · S/N 4498 N1659LRossi Christopher S · Gleason, WIS/N 4748 N16ZXMyers Scott James · Sebewaing, MIBuilt 1998 · S/N 4379 N17MZMiller Robert B · Lake Almanor, CAS/N BA9517 N189BRRasler Brian H · Topeka, INS/N 4179 N190ZXSiegenthaler John C · Holland Patent, NYBuilt 1996 · S/N 3411 N217ABJohnson Kevin W · Hardwood, MIBuilt 1996 · S/N 1008 N22444Davis Dennis R · Walla Walla, WABuilt 1999 · S/N 4667 N2249FForrest Christopher · Midlothian, VAS/N 4974 N2418FVosters Marvin N · Appleton, WIS/N 4760 N2486ZMclain Justin · Covington, INBuilt 1998 · S/N 4299 N2494CThomas Timothy N · Dubois, IDBuilt 1996 · S/N 3469 N2496JLumbeck Steven N · Oquawka, ILBuilt 2007 · S/N 6058 N2496QPederson Chris D · Francesville, INS/N 3216 N25197Registration Pending · Crestview, FLRegistration pendingS/N JDR1535 N2520ZLillehaugen Grant A · Castle Rock, COBuilt 1994 · S/N 3220 N2526JFork Kevin L · Gibsonburg, OHBuilt 1997 · S/N 3611 N2539FBarnhart David R · New Carlisle, INBuilt 2000 · S/N 6020 N2541YBurton Jeff J · Temple, GABuilt 1998 · S/N 4011 N2545NMurray Willan C · Butler, PABuilt 2000 · S/N 6043 N25670Winn Brian · Discovery Bay, CABuilt 1999 · S/N 4499 N25716Merrill Brian L · Rexburg, IDS/N 5387 N2628TMiller Nathan · Irwin, OHBuilt 2007 · S/N 4900 N2631TLanderos Edward E · Brighton, TNBuilt 2000 · S/N 4960 N2674AGill Glenn L · Weston, OHBuilt 2003 · S/N 16372 N2745RRose Gerald B · Jonesville, VABuilt 2002 · S/N 4951 N279JMMeehan James H Jr · Ballston Spa, NYS/N 3168 N2802PCrawford Rocky D · Knoxville, TNS/N 4346 N2808SRatcliff Stephan J · Olivehill, KYBuilt 2003 · S/N 16372 N2919PSeltenright Iceses L · Plymouth, INBuilt 1999 · S/N 4583 N307RHBass Stephen G · Scottsdale, AZBuilt 2004 · S/N 16437 N3130AKaminski Terry J · Kimberly, WIBuilt 2001 · S/N 6151 N3144CArvin Christopher J · Greenfield, INS/N 4546 N31725Hanshaw Joe W · Louisa, KYBuilt 2003 · S/N 16357 N31755Goebel David K · Ashland, KYBuilt 2000 · S/N 4878 N31778Gough Clarke A · Amelia Court House, VAS/N 16516 N3253PBishop Steven R · Bountiful, UTBuilt 1999 · S/N 4655 N3272XJenzano John · Kennett Square, PABuilt 1996 · S/N 3388 N3301MSchmidt Jeffrey E · Waupun, WIBuilt 2001 · S/N 6073 N3508YBailey Harvey R · Big Rapids, MIS/N 4958 N3514NGutelius James B · Milton, PABuilt 1997 · S/N 4014 N3519LFelbush Monte · Abilene, KSBuilt 2000 · S/N 4894 N3519TDale Keith T · Beaver Dam, KYBuilt 2002 · S/N 4064

Back to Buckeye DREAM MACHINE