Skip to content

Subaru ALL MDLS A/B

Registered aircraft · 349

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 ('59050')
  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 ('59050')
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.

N1031ZGillis Mary Ann · Dryden, MIBuilt 1964 · S/N 1 N1037GMcnamara Douglas S · El Cajon, CAS/N 573 N105BJBulfer James G · Fairmont, MNBuilt 1996 · S/N 058 N109BZZimmerman Bruce J · Pierce, NEBuilt 2003 · S/N 5782 N109JTTomlinson Charles E Jr · Walnut, MSBuilt 1998 · S/N 109 N109RTLandskroner Michael R · Zolfo Springs, FLBuilt 1994 · S/N 6-3511 N10XLJahnke Robin C · Sartell, MNBuilt 1996 · S/N 001 N111LWSnodgrass Matthew Taylor · Sierra Vista, AZS/N 862 N114DBacon Gregory A · Prairie Home, MOBuilt 2002 · S/N 688 N114NRRalph Theodore A · Bolingbrook, ILBuilt 2012 · S/N 6-6742 N1156CEtna Airplane LLC · Ozark, ARBuilt 2011 · S/N 001 N115CMOneil Conn W · Ogallala, NEBuilt 1999 · S/N CM01 N115HWFrancis Stotz Terence John · Hillsboro, ORS/N 5015 N115WMMilbauer Wayne N · Fuquay Varina, NCBuilt 2009 · S/N 7106 N12121Main Patrick R · Udall, KSS/N 09 N1219Thibodeaux Gerald J · Duson, LABuilt 2005 · S/N E-H2-03-14-595 N121SBBookout Brent · Bakersfield, CABuilt 1996 · S/N 1029D N1226BCameron Brian · Santa Rosa, CABuilt 2009 · S/N 60508 N122DGDegraw Richard R Trustee · Sun City Center, FLBuilt 2011 · S/N RDX 107 N124MHMoore Friedrich H · South Lake, TXS/N 003 N124TDCallahan Ted F Jr · Magnolia, TXBuilt 2005 · S/N 1093 N124XXKiefer Matthew J · Xenia, OHBuilt 2003 · S/N 82856 N127RBBraun Rainer H · Pikeville, TNBuilt 2009 · S/N 72020 N129MLLarkin Marion J · Salome, AZBuilt 2002 · S/N H2-01-12-513 N129TLBriggs Lynn V · Northglenn, COBuilt 1995 · S/N LCU-138 N130VMVan Mieghem William C · Morton, ILS/N 130 N133DCBachman David A · Griggsville, ILS/N 360 N136LBHolloway Jack G · Belle Plaine, KSS/N HCA1 N147CMCarson Roy R · Walterboro, SCBuilt 2008 · S/N 71424 N148DNRobbins Aviation LLC · Scottsbluff, NEBuilt 2003 · S/N 6-3346 N164MESchneider Rodney D · Ball Ground, GABuilt 2013 · S/N 24876 N166BEFaktor Richard A · Tacoma, WAS/N 001 N168GHSale Reported · Sioux Falls, SDSale reportedS/N 002 N169APBecker Jason A · Buffalo, MNBuilt 2002 · S/N 1 N16CENce Inc DBA · Tucson, AZBuilt 2013 · S/N NCE-001 N170TJCarpenter Clifford · Lockhart, TXBuilt 2013 · S/N TRHD 001 N1718BFritts Dofin A · Molino, FLBuilt 1994 · S/N H2-94-5-138 N173XPerry Albert D · Houston, TXBuilt 1997 · S/N DMO252 N177GMBailey Seth E · Coos Bay, ORS/N 11321040 N179WHBryant Thomas A · Tallahassee, FLBuilt 2005 · S/N 25378 N179WWYork William H · Ocilla, GABuilt 1998 · S/N H298349 N181LLShearer William J · Vicksburg, MIBuilt 1996 · S/N 1300B N1886EReed Melvin E · Lewisburg, PABuilt 1992 · S/N 827 N194TCColdenhoff Timity · Lavinia, TNBuilt 2005 · S/N 90338 N194XCNewsted Gary M · Wilton, NHBuilt 2003 · S/N 90059 N196MBBecerra Michael A · Twin Falls, IDBuilt 2004 · S/N 1483D N1980AMullen Gary J · Liberty Twp, OHBuilt 2007 · S/N MRB 01207 N2008LSanders Mark T · Surprise, AZBuilt 2006 · S/N SH20050015K N2022RNorth East Oregon Aviation Foundation · Joseph, ORBuilt 2004 · S/N 500 N202LPOsborn Ralph O · Richmond, TXBuilt 1994 · S/N 2

Back to Subaru ALL MDLS A/B