Skip to content

Registered aircraft · 155

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

N42ATBeste Stephen H · Springfield, VABuilt 1998 · S/N BILL-JACOBSON N43144Woodside Bryan M · Taylors, SCBuilt 1996 · S/N CH20496CW1481 N4330KAmcosawa LLC · Albion, INBuilt 2006 · S/N 205 N433ACChiavetta Andy W · Santa Paula, CAS/N 001 N4357SCarter Gary J · Manlius, NYBuilt 1997 · S/N 0532 N43594Maynard Joseph T · Powell, OHBuilt 2007 · S/N 006 N43677Barber Bradley W · Eagle Creek, ORFirst renewal noticeBuilt 2006 · S/N 1001 N43HKRegistered aircraftBuilt 2019 · S/N HAII-429-TRI N4480GNorth American Aircraft Holdings LLC · Phoenix, AZS/N T07061 N456TVBerghoff Jan S · Danbury, WIBuilt 2011 · S/N 0690 N46229Cote James V · Ladysmith, WIBuilt 2002 · S/N HII-161-A-HKSTRI N46367Burdick Russell L · Baker, MTBuilt 2001 · S/N 330 N48PCSyster Jeffrey S · Latrobe, PABuilt 2006 · S/N 00001 N4908TSanders George W · Cloverdale, INBuilt 2005 · S/N 3151 N490AKCheatwood Jim W · Big Lake, AKBuilt 2003 · S/N 1-MA-33-HKS700E N50143Sale Reported · Humble, TXSale reportedS/N GT 2801494 N5041GAitchison Gilbert W · Harpursville, NYBuilt 1983 · S/N H-8-342K N5082TYeager Alec C · Hendley, NEBuilt 2006 · S/N 02 N50RDDundas Ronald S · Grass Valley, CABuilt 2023 · S/N 901 N5118YBlose Robert S · Holland, NYBuilt 2006 · S/N A0500910H N512TDCross Thomas A D · Yacolt, WABuilt 2014 · S/N 1001 N5132DHighsmith Corey W · Aragon, GAS/N 11SC5012 N51336Karevoll John R · Running Springs, CABuilt 2007 · S/N 29652 N526CLJose L Muniz · Aguadilla, PRBuilt 2003 · S/N 904-003422 N531EDGilbert Kent G · Brookshire, TXBuilt 2005 · S/N 1115 N531JCTyre Danny J · Hahira, GABuilt 2002 · S/N G2K2002JRC N55017Libby Ronald J · Patten, MES/N SKR0305324 N5525GBuehler Barry · Castle Rock, WAS/N 405068 N557MBSale Reported · Beulaville, NCSale reported, canceledBuilt 2021 · S/N 578 N55JZTav8rs LLC · Tea, SDBuilt 2018 · S/N HV-35 N5624YHale Daniel E · Ontario, ORBuilt 2000 · S/N 265 N5639SErnst Randi L · Hawkins, TXBuilt 2006 · S/N 100485 N5672KBradley Craig P · Santa Fe, NMBuilt 2007 · S/N 120.07.02 N582ALLindemann Allan · Land O Lakes, FLBuilt 2007 · S/N 12404 N5QLPeeler James K · Cherryville, NCBuilt 2007 · S/N 005 N601NXShockley David C · Warsaw, VABuilt 2006 · S/N 001 N601SLGirard Richard N · Udall, KSFirst renewal noticeBuilt 2006 · S/N 1001 N6116USudul Benjamin J · Russell, PABuilt 2001 · S/N 313 N6125QPietrobono Joseph P · Palm Beach Gardens, FLBuilt 2005 · S/N A0501111H N6154ZMorgan Anthony · Brooksville, FLBuilt 1998 · S/N 193 N6175FEricson Jay D · Nisland, SDBuilt 1999 · S/N 208 N625PWGreene Carl W DBA · Crivitz, WIBuilt 2007 · S/N 195 N63AYRuby Glen R · Treynor, IAS/N 0063 N64615Resh Randall A · Fayetteville, ARBuilt 2012 · S/N HAII-312-HK700E-TD N65028Landry Philip · Westlake Village, CABuilt 1999 · S/N 14REH N6507LWalton Lynn E · Brazil, INBuilt 2007 · S/N 5877 N6510UHahn Nicholas E · Coshocton, OHBuilt 2007 · S/N 0932 N654JPOberlin Brandon G · Indianapolis, INS/N 7494 N659DImhoff David E · Sandy Valley, NVBuilt 2008 · S/N AAHP0022 N65TNHoward James · Dothan, ALBuilt 2001 · S/N 336

Back to HKS 700E