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.

N411HTFluckey Gary T · Homer, AKBuilt 2006 · S/N 11054195 N414GLYorgesen Tyler · Mattawa, WABuilt 2006 · S/N 103 N416MSSiegfried Rand W · Sausalito, CABuilt 2008 · S/N MS101 N417BWTelford Aircraft LLC · Telford, TNS/N 140 N417SXDick David B · Cottage Grove, ORBuilt 2010 · S/N 1507 N418CMHughes Charles R · Hamden, CTBuilt 2011 · S/N 6-6450 N423DSFitzgerald Christian · Ankeny, IABuilt 2008 · S/N 6-7088 N426LBCasey William D · Moberly, MOBuilt 2008 · S/N 5150 N427EBJarcia Aviation LLC · Mahtomedi, MNBuilt 2010 · S/N 65-7561 N427MEastman Brian R Jr · East Hampton, CTBuilt 2007 · S/N TX-1006 N428GWWinkler Gary R · Shallotte, NCS/N 1313 N429WHEgger Robert W · Walkerton, INBuilt 2011 · S/N 75-7995 N4337GJessee Ernest E · Cary, NCBuilt 2007 · S/N 6391 N434GLLarrivee Jules P · Kent, WAS/N 5811 N436JRHoughton Paul J · Cotter, ARBuilt 2012 · S/N 060900075 N437DMJohnson Neal · Mitchell, SDS/N 75-7641 N440HWParodi Juan M · Tomball, TXS/N 1257 N441YPStinson William A · Fort Wayne, INBuilt 2013 · S/N 020900062 N44SXRoss James A · Springville, INBuilt 2006 · S/N 863 N454EELarue Paul E · Farmington Hills, MIBuilt 2017 · S/N 1509 N4568GMelton David G · Hernando, MSBuilt 2009 · S/N 66246 N45NDSmith Steven H · Powell Butte, ORBuilt 2012 · S/N 134 N45YXAnderson Paul D · Tucson, AZS/N W0045 N466SXSmith Dennis Wayne · Phoenix, AZBuilt 2006 · S/N 0466 N469GFSibley Craig P · Wolf Point, MTBuilt 2008 · S/N 1008518 N46HMColvin Johnny L · Hoover, ALBuilt 2011 · S/N 130 N46HVBaker Seth A · Wickenburg, AZBuilt 2009 · S/N 0104360 N46LMSchuur Ryan · Chandler, MNBuilt 2007 · S/N 74 N46SRBarajas Fernando · Las Vegas, NVBuilt 2006 · S/N 305 N475KHHaynes Harold H Jr · Dallas, NCBuilt 2015 · S/N 6-6829 N47CCDeering Curtis D · Owen, WIBuilt 2009 · S/N 009-1 N481DCDixon Tyler · Lubbock, TXS/N 6-5381 N481SLHenry David C · Carson City, NVBuilt 2011 · S/N 121 N482PTGwinnett Experimental Aircraft Assn Chapter 690inc · Lawrenceville, GABuilt 2006 · S/N 6-5293 N486WKKahn Walter Isa · Baldwinsville, NYBuilt 2013 · S/N 375 N4882Gallego Louis R · Tacoma, WABuilt 2009 · S/N 6-4882 N48CUUlsaker Christopher W · Wilmington, DEBuilt 2009 · S/N 1051 N490WBBailey Kenneth K · Bryan, TXS/N 498 N492JKKortens William J · Black Creek, WIBuilt 2014 · S/N 1114 N493TGElohim Benjamin · Mc Kenzie, TNBuilt 2005 · S/N 6-5342 N4972CCavallo Greg P · Munday, TXS/N 8441 N50069Gallo Matthew O · Maxwell Afb, ALBuilt 2006 · S/N 0290 N505WPWright Alvin D · Mcalester, OKBuilt 2005 · S/N 6-4756 N5113EGreat Adventure Sailing Vessel LLC · Greer, SCBuilt 2006 · S/N JAESC0098 N5155HBulechek Mark L · Iowa City, IABuilt 2011 · S/N 120 N515LEMathis Brian J · Colgate, WIBuilt 2015 · S/N 6-7155 N517FLindsey Mitchel T · Chesnee, SCBuilt 2009 · S/N 1046 N519JHPidgeon James E · Germantown, TNS/N 060800010 N519SMMcglynn John H III · Southport, NCBuilt 2020 · S/N 030900063 N51YXJack R Davis · Sacramento, CABuilt 2007 · S/N W0051

Back to Jabiru 3300