Skip to content

Buckeye Industries DREAM MACHINE

Registered aircraft · 42

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 ('059001Z', '059010D', '05641KQ')
  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 ('059001Z', '059010D', '05641KQ')
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.

N137EEberhardt Daniel T · Adell, WIBuilt 2000 · S/N 6046 N156MBJensen Lorenzo · Iola, KSBuilt 1998 · S/N 4201 N216DWWood David F · Bristol, TNBuilt 1997 · S/N 3817 N239ASHammock Timothy D · Marysville, OHS/N 4816 N2488LGesto James W · Mishawaka, INBuilt 1996 · S/N 3436 N25063Freres Michael James · Woodland Park, COBuilt 1996 · S/N 3529 N2546JBarnes Douglas E · South Bend, INBuilt 1999 · S/N 4796 N2564ADuncan David A · Granger, INBuilt 2001 · S/N 6220 N30621Baker Paul L · Sugar City, IDBuilt 2001 · S/N 6134 N3160KLarsen Jonathan · Lagro, INBuilt 2007 · S/N 4195 N3267EQunell Jamie R · Corcoran, MNS/N 4300 N3513CGuthrie Donald G · Marion, INBuilt 2000 · S/N 4929 N35232Peterson Cameron J · Logan, UTS/N 4501 N3534LSchaefer Timothy E · Ave Maria, FLBuilt 2000 · S/N 5037 N372GERegistration Pending · Carthage, MORegistration pendingBuilt 1997 · S/N 3637 N3878VBegue George A · Pickerington, OHS/N 3830 N4247FMiller Keith A · Syracuse, INBuilt 1998 · S/N 4413 N4294EHershberger Roy A · Mishawaka, INBuilt 1997 · S/N 0003 N5039STalbott Walter B · Rochester, INBuilt 1997 · S/N 3672 N51344Herschberger Glen R · Iola, KSBuilt 1998 · S/N 4229 N543JHMinakes Carolyn J · Killen, ALS/N 16534 N5512KStone Ronald K · Edwardsburg, MIBuilt 1994 · S/N 3193 N5601YPowers Thomas R · Seminole, FLS/N 3648 N56043Blanton Tracy G · Gaffney, SCBuilt 2000 · S/N 4916 N56236Conroy Lawrence W · Grovertown, INBuilt 1997 · S/N 6573 N582EEYoder Isaac J · Chappells, SCS/N 4902 N6122FGatto John D · Stevensville, MIBuilt 1997 · S/N 3796997 N61638Walbert Allin J · Walkerton, INBuilt 1997 · S/N E049JS N6164APrater Robert A · Cicero, INS/N 3653 N648GHDaniels Larry F · Elyria, OHBuilt 2001 · S/N 6059 N6557RBreunig Mark J · Sheboygan Falls, WIBuilt 1996 · S/N 3484 N7059JGongolewski Robert · East Setauket, NYS/N 4044 N7122XBrandt Mark A · Bradford, OHBuilt 2002 · S/N 6045 N7179NShidler Brian L · Culver, INBuilt 1999 · S/N 4775 N729MPRichardson William S · Shelbyville, INBuilt 1999 · S/N 4568 N75302Paulsen Matthew C · Wisconsin Dells, WIBuilt 1996 · S/N 1398 N8608CHamilton Roger D · Walkerton, INBuilt 2000 · S/N 4841 N918UTSteiner Paul · Eagle Mountain, UTS/N 6013 N9274VBontrager Jonathan L · Goshen, INBuilt 2000 · S/N 5085 N9287BSkvara Mark D · Green Bay, WIBuilt 2006 · S/N 16519 N9385TWolfe Ricky W · Lakeville, INBuilt 1996 · S/N 4614 N971YTTucker Julian C III · West Palm Beach, FLS/N 5039

Back to Buckeye Industries DREAM MACHINE