Skip to content

Registered aircraft · 90

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

N102BDDickinson Gene S · Santa Paula, CABuilt 1989 · S/N 6816 N106ARTapson Jonathan · Telluride, COBuilt 1977 · S/N B-755 N107MBEaa Chapter 691 · Los Alamos, NMS/N 508 N124ATSmith David D · San Rafael, CAS/N 2178 N128GTToth George · Huntsville, TXS/N 6735 N128JHHughes Jay W · Yoakum, TXBuilt 2010 · S/N 2810 N133RMSafronoff Drew · Seattle, WABuilt 1994 · S/N 8103 N13706Baumli John · Maryville, MOBuilt 1982 · S/N 470672 N138DHCook Reginald A · Iselin, NJS/N 0436 N141ASPft Inc · Wilmington, DES/N B-775 N1442AWilkerson William L · Middleton, IDBuilt 1983 · S/N 144 N152CRReeves Charles W Jr · Tucson, AZBuilt 2002 · S/N 3258 N15ABBuehler Andrew C · Eatonville, WABuilt 1991 · S/N 001 N15GERegistration Pending · Ozark, ALRegistration pendingBuilt 2000 · S/N 6792GME N163ARFountaine Michael D · Goleta, CABuilt 2016 · S/N ANR029 N1662CO'Connell Jeffrey J · Bradenton, FLBuilt 2007 · S/N 001 N169TBVess Joel W · Cherryville, NCBuilt 1991 · S/N 2222 N169XXMason Benny F · Effingham, ILBuilt 2008 · S/N 992 N170RThayer Alan R · San Leandro, CAS/N 2224 N1852ZSchmitt Robert F · Lees Summit, MOBuilt 2006 · S/N 847 N21QQMoore Michael R · Spokane, WABuilt 1983 · S/N 2005 N21SYCole Leon D · Lewis Run, PABuilt 1980 · S/N 2021 N222VPJagust William M · St Peters, MOBuilt 2012 · S/N V2-1296 N24HBulaw Brian · Plano, TXS/N 2235 N24TCKnox Sid G · Welling, OKBuilt 1980 · S/N 1437 N25974Johnson Leif M · Hermann, MOBuilt 1987 · S/N 2658 N25BMWhittley Stephen Wayne · Adkins, TXBuilt 2008 · S/N 1192 N265SXSale Reported · West Des Moines, IASale reportedBuilt 2008 · S/N 0104 N275JFRobinson Mark V · Vacaville, CAS/N 2757 N29BXWeyland Hendrik J · Udall, KSS/N 01216 N2PQFrisbee Robert P · Mcminnville, ORBuilt 1987 · S/N 2140 N312TRPhillippi Glenda Joyce · Brookshire, TXBuilt 2011 · S/N X0039 N316LJGruntmeir Joseph L · Iroquois, SDBuilt 2015 · S/N E-08 N327CXShokoui Kourosh Casey · Panama City, FLBuilt 2011 · S/N 0327 N32DKFincher Brandon J · Marietta, OKBuilt 1992 · S/N 2453 N337LLockwood Robert K Jr · El Cajon, CABuilt 1994 · S/N 2634 N33PAAdams Paul · Marshalltown, IABuilt 2018 · S/N 91 N350JDWright Nicholas G · Thomasville, GABuilt 1987 · S/N 2772 N35SLTate Isaac · Yucaipa, CABuilt 1995 · S/N 1643L N3790CSniffen Morgan T · Sycamore, OHS/N 2723 N3800NChizek Terry L · Marion, KSBuilt 1983 · S/N 4090 N39425Freeburg Timothy L · Holdrege, NEBuilt 1983 · S/N 2236 N395DBAlbright Michael A · Chippewa Falls, WIS/N 0396 N42189Acs Aviation LLC · Burlington, VTBuilt 1980 · S/N V2-10-79CB N42QDrake Richard · Goldendale, WAS/N 2290 N42QQDapp Eric M · Corvallis, ORS/N 2055 N4346GHinman Nathaniel J · Tulsa, OKS/N 1941 N436WBMatthewson Benjamin J · Converse, TXBuilt 1998 · S/N 436 N440CHDennis Joseph D · Redmond, ORBuilt 2016 · S/N C-5095 N443TXAngle Bryan N · San Angelo, TXS/N 2425

Back to Revmaster 2100