Skip to content

Registered aircraft · 475

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 ('34801', '34802')
  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 ('34801', '34802')
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.

N302DMMcintosh Donald W · Sandpoint, IDBuilt 2010 · S/N S70407064 N303RSPflanz Richard · Fairbury, NEBuilt 2005 · S/N 6-5403 N3076UHastedt Margaret J · College Station, TXBuilt 2005 · S/N C9708-0198 N311DWDw Light Sport Aviation LLC · Troy, VABuilt 2007 · S/N 0708D0313 N312PTN312pt LLC · Tallahassee, FLBuilt 2007 · S/N 401 N3134SAndre George M · Saint Louis, MOBuilt 2007 · S/N 104 N316HDavis Raymond L · Dunnellon, FLBuilt 2007 · S/N 27 N317CKKeith Charles M · Zuni, VABuilt 2008 · S/N 00021 N324ALTerry Charles J · Martinsville, INS/N 59 N325ALRodgers Dustin · White, GABuilt 2009 · S/N 78 N328CDDonohue Joseph Thomas · Piqua, OHBuilt 2008 · S/N 6-5399 N328SXNauman Alan D · Grand Prairie, TXBuilt 2007 · S/N 328 N329ALJenkins Lawrence · Deming, NMBuilt 2010 · S/N 100 N32PT54ch Inc · Fredericksburg, TXFirst renewal noticeBuilt 2009 · S/N 04081876 N330BHMcfarland Randall D · Augusta, KSBuilt 2009 · S/N 00071 N330JAHeatwole Oren E · Dayton, VABuilt 2012 · S/N 120228 N332ALSchweitzer Jay A · Missoula, MTBuilt 2010 · S/N 107 N333JGutteridge Robert W · Santa Rosa, CABuilt 2007 · S/N 333 N333YXWallace Chris · Bend, ORBuilt 2025 · S/N WXB0065 N335ALPerry Robert K · Buellton, CABuilt 2011 · S/N 133 N335CEDauphinee Michael E · Orlando, FLBuilt 2009 · S/N 38 N336ALHarris Robert J · Franklinton, LABuilt 2012 · S/N 139 N337ALReisman Evan · Columbus, OHBuilt 2012 · S/N 142 N340NPWilliams Jeffrey G · Brookfield, WIBuilt 2022 · S/N A157 N342DMAdvance Agra Equipment LLC · Sheridan, WYS/N 091 N344ARTaylor Richard B J · Little Falls, MNBuilt 2008 · S/N 1074 N346BRKonkle Nolan A · Sharpsburg, GABuilt 2010 · S/N 88 N346JZZierenberg Terry R · Mapleton, UTBuilt 2026 · S/N 001 N34TMPort Of Tillamook Bay · Tillamook, ORS/N TM 30 N34YZCragg Philip A · Point Roberts, WABuilt 2008 · S/N 71 N351RNMillsap Joseph B · Granbury, TXBuilt 2002 · S/N DH 35 N3543WSnader Kirk Wayne · Fort Myers, FLBuilt 2009 · S/N 041 N356ABrooks Bill D · Bayfield, COS/N 356 N356MDPlant Curtis W · Runge, TXBuilt 2008 · S/N 0607470 N35YXRegistered aircraftBuilt 2007 · S/N W0035 N362DRHomer Vincent H · Independence, ORBuilt 2008 · S/N 295 N362DVFranklin Paul · Independence, ORBuilt 2014 · S/N 0016 N365CGCook James C · Bakersfield, CABuilt 2012 · S/N 145 N375EAEdinger Vance W · Elizabethtown, PABuilt 2009 · S/N 6-7174 N3762HBrewer Scotty L · Bath Springs, TNBuilt 2010 · S/N 0494 N377YSundby Nelson D · Edgerton, WIBuilt 2012 · S/N 151 N37FJLehr Rick M · Pittsburg, TXBuilt 2005 · S/N 214 N386YXMiller Harvey L · Post Falls, IDBuilt 2012 · S/N W0086 N387RSWood William H Jr · Napa, CABuilt 2009 · S/N 0486 N3889SBradley Sean A · Niceville, FLBuilt 2009 · S/N 6-6410 N397SXSchandel Sean M · Sandy, UTBuilt 2013 · S/N 0001 N401PWFlywerx LLC · Anchor Point, AKBuilt 2010 · S/N 0001 N4031NNichols James · Arlington, WABuilt 2019 · S/N 75-10557 N408SXCason David W · Laurel Hill, FLBuilt 2010 · S/N 408 N40SXDennison Denny M · Coulterville, CABuilt 2013 · S/N 0879

Back to Jabiru 3300