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.

N66CKReim Rodney D · Enid, OKBuilt 2018 · S/N 1 N66HKWomer Edward P · Duncannon, PABuilt 2001 · S/N 001 N66TDDavis Terry A · Baker City, ORFirst renewal noticeBuilt 2006 · S/N FS01-1-00058 N686KMStraten Oliver · Wasilla, AKBuilt 2007 · S/N 02297XS N6921TCooper Sean P · Walnut Creek, CABuilt 2019 · S/N 801 N6BDBede Family Foundation Inc · Medina, OHS/N 6-0001 N6QLWeaver Clyde W · Hurst, TXBuilt 2007 · S/N 006 N7009ZRose Bruce · Aloha, ORS/N 2565 N701UFGuess Jonathan M · Pineville, LABuilt 2008 · S/N CH2-0305-2606 N70665Shafer Jerry · Georgetown, OHBuilt 2007 · S/N GT2801496 N706JMKnott Joseph D · Unionville, IAS/N 001 N707MLBrock William · Wetumpka, ALBuilt 2022 · S/N HV-44 N70HKMorrison Dale C · Eloy, AZBuilt 2006 · S/N 1055 N711TERegistration Pending · Canton, GARegistration pendingBuilt 2000 · S/N 312 N721MPPoliak Mark A Trustee · Carmel, INBuilt 2005 · S/N A0500303H N7473AVaughn Scott E · Phoenix, AZBuilt 2005 · S/N 111342 N749EMMoreno Ernest W · Independence, ORBuilt 2008 · S/N 396 N74GBBrewer Gary · Canton, ILBuilt 2015 · S/N 01 N787MLStorm Ronald F · Kettering, OHBuilt 2017 · S/N HV-27 N78KFTaylor Mark W · Jackson, TNBuilt 2009 · S/N FS08-2-0085 N796HBBelton Mark · Eugene, ORBuilt 1994 · S/N 8675309 N797SFBrown Leland E · Vandergrift, PABuilt 2019 · S/N L93XXXOHK0015 N7QLTait Jesse L · Belton, TXS/N 007 N804HATrevelline Joseph V · Missoula, MTBuilt 2008 · S/N HAII-323-HKS-TRI N8074LLeyh Joel P · Waupun, WIBuilt 2002 · S/N 100339 N80778Plummer William O · Cordele, GABuilt 2006 · S/N 75433 N80915Glaude Jason T · Scarborough, MEBuilt 1999 · S/N 231 N831JAGitchel Delbert D · Wilcox, NES/N 076 N8554KSale Reported · Bethel, VTSale reportedBuilt 1991 · S/N 020 N86025Smith Kenneth A · Granton, WIBuilt 2006 · S/N 05.11.52.196 N863GBSpicer Larry E · Milwaukee, WIBuilt 2008 · S/N 041744 N882DMMedlin Darren · San Antonio, TXBuilt 2016 · S/N 854490 N895SGCamlin Stephen · Geneva, FLBuilt 2014 · S/N 001 N89QLNickman Kirk A · Aledo, TXS/N 089 N8YBMackowiak Michael S · Haines, AKS/N 02222HXS N90795Franks Richard A · Mc Lean, NYBuilt 2002 · S/N 347 N910DGWhatley Allen W · Catlett, VABuilt 2010 · S/N 101 N914NMRogero Joseph F · Keystone Heights, FLBuilt 2007 · S/N 1968 N91SWSwartzentruber Kevin L · Abbeville, SCBuilt 2001 · S/N 284 N920DDBertuleit Donald J · Newport, ORBuilt 2005 · S/N DD1 N924ECLevoy Duane J · Lafayette, INS/N 251 N930SMinton Melanie J · Leslie, ARS/N 980 N932RCZimmerman Marlin M · Newmanstown, PABuilt 2008 · S/N 397 N935BMHampton Michael M · Taylorsville, NCBuilt 2021 · S/N 0001 N940ZSheehan Donald C · Harrisonville, PABuilt 2005 · S/N A0501010H N94756Brown Jason A · Bloomfield, INBuilt 2005 · S/N A0501312H N952JSSwilley Shannon · Marshall, TXS/N 0804137 N952PWN952pw LLC · North East, PABuilt 1998 · S/N H-II-CGS-114 N957BBMuniz-Bueno Jose L · Aguadilla, PRBuilt 2006 · S/N 0143 N960BO'Brien Patrick C · Daleville, ALFirst renewal noticeBuilt 2011 · S/N 0249

Back to HKS 700E