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.

N1001LSlow Roll Aviation LLC · Sacramento, CABuilt 1996 · S/N 1001 N107YKDalton Gary · Belton, SCBuilt 1981 · S/N 811306 N108GCCurry Arnold J · Houston, TXBuilt 1984 · S/N 844710 N108YKAirhart Michael D · Justin, TXBuilt 1982 · S/N 822114 N110JYYak 110 LLC · Newark, DES/N 1 N110YAMatuska F Dale · Port Orange, FLBuilt 1986 · S/N 863110 N1139XRed Star Warbirds Llp · Tulsa, OKBuilt 1984 · S/N 844610 N113YKVancott Dirk Alan · Reno, NVBuilt 1991 · S/N 9111114 N1157DUltralight Sport Aviation LLC · Union, MIBuilt 1983 · S/N 833910 N11YKAlpha Juliet LLC · Sheridan, WYBuilt 1985 · S/N 853001 N120RMLogue Patrick J · Henderson, NVBuilt 2016 · S/N 12-307 N12DRBunker Aviation LLC · Sugar Grove, ILBuilt 2013 · S/N 281 N12VXZoom Leasing LLC · Barto, PABuilt 2016 · S/N 333 N13GBLipka Will G · Center Point, TXBuilt 2010 · S/N 304 N152JBBooker Daniel R · Newaygo, MIBuilt 1981 · S/N 811403 N152RSAnderson Kreg J · Alexandria, MNBuilt 1985 · S/N 855711 N152WSEhgotz George P · Mc Gregor, TXBuilt 1984 · S/N 844712 N154DBMy Toys Inc · Jacksonville, FLBuilt 1997 · S/N 01002 N15YKTucker Brandon J · Poway, CABuilt 1993 · S/N 9311702 N171JGParadox Aviation LLC · Whiting, IABuilt 2016 · S/N JG-2 N177MFYuba-Sutter Aviation Inc · Olivehurst, CABuilt 2009 · S/N 299 N191YKJames Anthony W · San Jose, CABuilt 1992 · S/N 920309 N202YABergeson John S · Rhome, TXBuilt 1996 · S/N 961005 N205YARegistered aircraftBuilt 1996 · S/N 961008 N207YKGrifa Nathaniel Arick · Waterloo, NYBuilt 1996 · S/N 9611913 N208YAAir Care Systems Inc · Lamar, COBuilt 1989 · S/N 8910009 N209YAEckebrecht Jenna · New River, AZBuilt 1987 · S/N 878009 N20SRWilliams James Bruce · Germansville, PABuilt 2010 · S/N SR0901 N213JJWro LLC · Conway, ARBuilt 2005 · S/N F5C109 N218CJDavis Clint H · Paola, KSBuilt 1979 · S/N 3532021 N21YKJaeger Wendell R · Wausau, WIS/N 9211609/01 N22154Kodiak Cash Systems Inc · Granger, INBuilt 1989 · S/N 899414 N223DHPool Hap · Vail, COS/N 223SR N227WLam Lawrence Y C · Rosemead, CABuilt 1983 · S/N 832601 N229BHSale Reported · Ramona, CASale reportedBuilt 1993 · S/N 75-05 N22YKI Love To Fly LLC · Asheville, NCBuilt 1974 · S/N 1232009 N23YKAndrews Donald A Trustee · Scottsdale, AZBuilt 1973 · S/N 1432028 N2411ZGnarly Gnat LLC · Friendswood, TXBuilt 1981 · S/N 821911 N24SURedstar Air Shows Inc · Discovery Bay, CABuilt 1990 · S/N 0301 N2504UMansfield Heliflight Inc · Milton, VTBuilt 1987 · S/N 878012 N25CJFriedt Dean A · Scottsdale, AZBuilt 1979 · S/N 1332028 N25JNHuotari Leonard Joseph · Lakeville, MNS/N 833315 N26PSBrauer Jeffrey L · Hendersonville, TNBuilt 2009 · S/N 298 N26YCKss Aviation Inc · Evansville, INBuilt 2010 · S/N SR 275 N2832Warsaw Pact Aviation Lc · Davenport, IABuilt 1986 · S/N 866411 N285CJBlue Skies Aviation LLC · Gulfport, MSS/N 1232003 N28KXGreen Hornet Aviation LLC · Washington, DCBuilt 1992 · S/N 06-06 N301JGTortolita Aviation LLC · Oro Valley, AZBuilt 1993 · S/N 0204 N30419Howard Matthew Wm · Louisville, COBuilt 1981 · S/N 811114 N305RGGattis Aircraft Inc · Wasilla, AKBuilt 2007 · S/N 249SR

Back to Vedeneyev M14P