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.

N3754SKowalis Kurt A · Tinley Park, ILBuilt 2001 · S/N 6091 N3760VSimmons James · West Seneca, NYBuilt 1997 · S/N 3715 N37PTRivir Jason R · Canton, KSS/N 3845 N383WBSwartzlander Craig M · Sunbury, PABuilt 1997 · S/N 3371 N3853VLambert Daniel V · Mosheim, TNBuilt 1999 · S/N 4328 N3856VHouston Hal B · Como, MSBuilt 2005 · S/N 16465 N3862VHartman Jean-Christophe S · Fishers, INBuilt 2005 · S/N 16466 N3990LKarlson Ken · Washington, UTBuilt 2004 · S/N 16391A N4016MArmstrong Brandon S · Milton, WVBuilt 2000 · S/N 5009 N40534Lavi Natan · Cupertino, CAS/N 4957 N4066MJohnson Charles Edward · Winchester, KYBuilt 2004 · S/N 16388 N40675Smith John C · Ashland, KYBuilt 2004 · S/N 16382 N4067MDickess Ronald D · Ironton, OHBuilt 2003 · S/N 16356 N4067XEvans Joshua L · Ironton, OHS/N 6227 N41061Seals Kevin M · Delavan, ILBuilt 1999 · S/N 4491 N4260ZSchmeeckle Tim · Gothenburg, NEBuilt 2005 · S/N 16476 N4278CVan Ausdoll Timothy A · Vienna, ILBuilt 1999 · S/N 4595 N4350MHildebrandt John Edward · Adrian, MIS/N 4446 N4367YSchorr Joseph R · Doylestown, OHBuilt 2000 · S/N 5097 N436BEJoos Zupanki · Lexington, KYBuilt 2001 · S/N 6095 N437PDDeflavio Frank · Ligonier, PAS/N 3738 N4382AJastifer James R · Grandville, MIS/N 4737 N4385JGriswold Donald G · Pontiac, ILBuilt 1996 · S/N 3464 N44020Macleay James F · Morristown, TNBuilt 2004 · S/N 16447 N4404CPenley Brian L · Westfield, INBuilt 2001 · S/N 6939 N44406Horinek David L · Goodland, KSBuilt 2000 · S/N 4860 N4459BStauffer Bradley E · Dorchester, NEBuilt 2000 · S/N 16379 N468XGGoodwin Larry E · Coudersport, PABuilt 1996 · S/N 3025 N4809AGirard Louis W · Schulenburg, TXBuilt 2002 · S/N 131014 N505PSZook David R · Gap, PAS/N 4554 N5076FRitchie Todd R · Bandera, TXBuilt 1997 · S/N 3790 N50801Gregory David A · Westmoreland, TNBuilt 2007 · S/N 4510 N5081JPatten Ben P · Broadus, MTBuilt 2005 · S/N 16439 N5112FWall Les A · Heber Springs, ARBuilt 2000 · S/N 5008 N536MCCorrigan Michael S · Cedar Grove, TNBuilt 2003 · S/N 6217 N5573JBawtinheimer Kris J · Grand Rapids, MIBuilt 2000 · S/N 4939 N5606KGrant Parish Sheriffs Office · Colfax, LABuilt 2006 · S/N 16825 N5618BOberlin Brandon G · Indianapolis, INBuilt 1995 · S/N 3343 N5620YMartin Jeffrey L · Goshen, INBuilt 1998 · S/N 4131 N5629UJustice Paul D · Albuquerque, NMBuilt 2000 · S/N 5021 N5662NGregory David A · Westmoreland, TNBuilt 1999 · S/N 4746 N57010Martin Lawrence · Goshen, INBuilt 1999 · S/N 4528 N5703CBailey Marvin John · Grand Island, NEBuilt 1999 · S/N 4633 N582EHHamm Errett J · Coeburn, VAFirst renewal noticeBuilt 2000 · S/N 5062 N582JHSanders David L · Wise, VABuilt 1997 · S/N 3704 N582PPDubose John H · Hardy, VABuilt 2005 · S/N 16508 N582TFFarr Thomas C · Marcy, NYBuilt 1998 · S/N 4190 N6049CHartlaub Kirk · Halifax, PAS/N G003 N6062UTaylor Dan F · Dallas, GABuilt 2005 · S/N 16503 N61203Morrow Ray A · Baton Rouge, LAS/N 726

Back to Buckeye DREAM MACHINE