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.

N6133SJakoubek Kirk D · Valles Mines, MOS/N 4477 N61380Tepper Kathy B · Freeport, FLBuilt 1997 · S/N 3756 N6143AJohnson Alvin · Fredonia, AZS/N 4391 N61456Lombard Robert A · Riverdale, MIS/N 16504 N6178ABurns Jason D · Helena, MTBuilt 2000 · S/N 5061 N6574LBoyer Roger C · Reddick, ILS/N 16435 N660RTKerns Danny L · Chatham, ILBuilt 1999 · S/N 4493 N665JDDittmer John G · Cullom, ILS/N 5051 N697TCLovertich Alex A Jr · Brandon, MSBuilt 2004 · S/N 16421 N7021VStrong Danny T · Suffolk, VABuilt 1999 · S/N 4677 N7056KJohnson Dale F · Marion, INS/N 6019 N707TTDees James R · Coolidge, GABuilt 1996 · S/N 3449 N7083JJourdan Robert M · Glen Ellyn, ILBuilt 2000 · S/N 5026 N7107JPittard Billy · Winterville, GAS/N 123456 N7162QDohm James E · Caledonia, MIS/N 5066 N7173YLacost Michael W · Kankakee, ILBuilt 2004 · S/N 16443 N7193KHollis John D · Tracy, CABuilt 2000 · S/N 4904 N721KBBrandon Stephen R · Livermore, CABuilt 1998 · S/N 4085 N75071Byrnes Dennis S · Chalfont, PABuilt 2006 · S/N 1696506 N75331Murphy Michael D · Lexington, KYS/N 3821 N753CMMeyer Charles E · Monee, ILBuilt 1997 · S/N 1451 N75416Lindsay Gary Bruce · Weatherford, TXBuilt 1998 · S/N 4378 N75585Todd Michael G · Jasper, ALBuilt 2001 · S/N 6242 N75738Shoemaker James O · Millington, TNBuilt 1998 · S/N 4097 N7592ADodge Charles J · Finlayson, MNS/N 6055 N799DKAntunes Daniel · Evansville, INS/N 5036 N80074Stukel James · Ahmeek, MIBuilt 1996 · S/N 3502 N8009MRobson Brent · Tetonia, IDBuilt 2001 · S/N 6165 N8019QGarcia Adam M · Jackson, MIS/N 4641 N8049UKleine Paul W · Cedar Lake, INBuilt 1999 · S/N 4670 N8049VWatson Ricky E · New Market, TNBuilt 1998 · S/N 4427 N80510Wangerin Thomas Wayne · Daggett, MIBuilt 1995 · S/N 3344 N8060YKuehne David · Fayetteville, NCBuilt 2007 · S/N 4259 N830DIngersoll Dean M · Holland Patent, NYBuilt 1999 · S/N 4496 N8509VShoemaker James O'Farrell · Millington, TNBuilt 1998 · S/N 4066 N85959Humphreys Howard M · Wilsonville, ALBuilt 2003 · S/N 16333 N8611NWimer Timothy S · Roanoke, VABuilt 1996 · S/N 3360 N8615GYoder David L · London, OHBuilt 1997 · S/N 3602 N9032HBrombach Joseph · White Pine, TNBuilt 1999 · S/N 4792 N90796Werren Carroll E · Concord, NHBuilt 1996 · S/N 3488 N9080GShortis Kevin R · Petersham, MABuilt 2000 · S/N 4851 N909WXHowell Scott A · Nokomis, FLBuilt 2006 · S/N 16504 N913LWPires Joe · Geneva, FLBuilt 1997 · S/N 3618 N92256Girard Louis W · Schulenburg, TXBuilt 2007 · S/N 3374 N9297ZYoder Calvin J · Hutchinson, KSS/N 3692 N92986Gregerson Leif E · Wisconsin Dells, WIBuilt 2003 · S/N 16378 N9299EKempf Michael David · Vanceburg, KYBuilt 2006 · S/N 16449 N94508Whitney Richard B · North Brookfield, MABuilt 1997 · S/N 3517 N94526Clancy Kevin R · Utica, ILS/N 6082 N94534Erickson Daniel A · Marion, OHBuilt 2001 · S/N 6064

Back to Buckeye DREAM MACHINE