Skip to content

Registered aircraft · 174

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

N313YKCra Travel LLC · Payson, AZBuilt 1964 · S/N 1032013 N31525Malousek Andrew J · Lincoln, NEBuilt 1984 · S/N 844112 N327DZPitts M12 LLC · Warwick, RIBuilt 2010 · S/N 004 N32YKHaven Lee R · Greenleaf, WIBuilt 1986 · S/N 866907 N336LLBryant Jonathan E · Mebane, NCBuilt 2023 · S/N 142 N352BWLam Tack C · Los Angeles, CABuilt 1983 · S/N 833412 N352SHAdams James G · Morgantown, INBuilt 1985 · S/N 855704 N359FGSlyfield Frederick J II · Park City, UTBuilt 1984 · S/N 842305 N35PF2 Dogs Flying LLC · Wilmington, DEBuilt 1984 · S/N 19840809 N369AGMorts Aeroservice Inc · Vincentown, NJBuilt 1979 · S/N 792006 N36YKLi-Paz Michael S Trustee · Calabasas, CABuilt 1995 · S/N 0535A N377DJSurgent Richard L · Wall Twsp, NJBuilt 2019 · S/N 46 N385BVAeroforce · Boca Raton, FLBuilt 2020 · S/N 108 N397HHClark James D · Godley, TXBuilt 2013 · S/N 2012DC N3YKMatuska F Dale · Port Orange, FLBuilt 2002 · S/N 0212402 N4040YGrand Haven Aviation Services · Spring Lake, MIBuilt 1983 · S/N 833213 N41JSStewart Joseph W II · Eloy, AZBuilt 2009 · S/N SR 136 N420RBFun With Physics LLC · Ocala, FLBuilt 1972 · S/N 2132049 N426YKSommers Cole · Katonah, NYBuilt 1985 · S/N 856102 N427WTDiamond Machine Tool LLC · Goshen, OHBuilt 2007 · S/N 081 N4295XSpence Vincent Anthony · Memphis, TNBuilt 1975 · S/N 750503 N42CLSteinthorsson Viktor T G · Boston, MAS/N 890802 N433BTKtbt Aviation LLC · Rogers, ARBuilt 2006 · S/N 87 N43HMHana Hou LLC · Myrtle Beach, SCBuilt 2001 · S/N 64-34 N4413NTherp Todd J · Rigby, IDBuilt 2003 · S/N 0303 N4434URegistered aircraftS/N 889011 N444JAEastern Block Warbirds LLC · Batavia, ILBuilt 1993 · S/N 9311613 N444YKSpaar Kenneth E Jr · Solvang, CABuilt 1991 · S/N 9111504 N4450YYak Flyers LLC · Grants Pass, ORBuilt 1985 · S/N 855809 N44YKClear Blue Skies LLC · Syracuse, KSBuilt 1987 · S/N 877402 N450CTTranstrum Wallace M · Gilbert, AZBuilt 2009 · S/N 008 N456CJ456 Charlie Juliet LLC · Hamilton, MTBuilt 1963 · S/N 4432018 N45BSGeipel William R · Woodville, WIS/N 866712 N46AWSsbm LLC · Phoenix, AZBuilt 1985 · S/N 853008 N477KGGraft Kevin T · Roaming Shores, OHBuilt 2018 · S/N 247 N495BS92nd W Aviation Inc · Lonoke, ARBuilt 2013 · S/N 320 N504BVMarkus Stanley L · Oconomowoc, WIBuilt 1983 · S/N 832510 N504WRRietdyk Guido · Rancho Dominguez, CABuilt 1981 · S/N 812104 N50MYYak 50 LLC · Scottsdale, AZBuilt 1983 · S/N 832606 N50RKEkberg Craig T · Rolling Hills, CABuilt 1981 · S/N 812001 N50RUFranklin Vernon Y · Midlothian, TXBuilt 1984 · S/N 842907 N511Morphew Ben · Mckinney, TXBuilt 2004 · S/N MCC1 N512PM12 Aviation LLC · The Woodlands, TXBuilt 2013 · S/N 291 N5203VAnchor Capital Holdings LLC · Goshen, KYBuilt 1979 · S/N 79-1503 N520CPWilloughby Peter A · Hendersonville, NCBuilt 1989 · S/N 899804 N522BMButler Francis J · Fargo, NDBuilt 2001 · S/N 01-03 N52WNFishrup Andrew H · Victorville, CAS/N 833014 N52XYRoham Rahmanian Corp · Malibu, CABuilt 1989 · S/N 899413 N52YTReimer Peter · Minneapolis, MNBuilt 1983 · S/N 833015 N549DKWashington Health Insurance Agency Inc · Tumwater, WABuilt 2006 · S/N 174SR

Back to Vedeneyev M14P