Skip to content

Amateur-built UNKNOWN ENG

Registered aircraft · 6,572

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

N10026Kellum Arthur · Wood River, ILS/N 01020939 N1002CMccurry Danny D · Lawndale, NCBuilt 2005 · S/N 1001 N1003TDrobeck Jeremy · Schoolcraft, MIBuilt 2025 · S/N KA24281641 N1005CMcneilly James T · Grand Ledge, MIBuilt 2005 · S/N 01 N10065Johnson Kyle · Exira, IABuilt 1949 · S/N 830 N10066Buchholz Robert A · Havana, FLS/N 324 N1007Chavers Construction Inc · Cantonment, FLBuilt 2005 · S/N 130 N1007YMaxey Robb · Richland, WAS/N 2202 N1009GLee Jim R · Pataskala, OHBuilt 2003 · S/N 1 N1009ZWilliams David A · Whitewater, WIBuilt 1963 · S/N DG1 N100ASKalitta Charters LLC · Ypsilanti, MIBuilt 1969 · S/N 274 N100C4th Quarter LLC · Missoula, MTBuilt 2001 · S/N LIV-032 N100DQMeans Michael J · Cheyenne, WYBuilt 1994 · S/N 039 N100EFBroderson Eric M · Stillwater, MNBuilt 2002 · S/N S9801-0132 N100FKFk Air LLC · Newark, DEBuilt 2000 · S/N 113 N100NRLudeman Evan M · New Boston, NHBuilt 2017 · S/N 1C-119 N100NUStrong James R · Buffalo, NYBuilt 1991 · S/N 1274 N100XWGlenn Michael Heath · Ranger, TXBuilt 2015 · S/N CCK-1865-0100 N10116Simmons Everett W · Rotan, TXBuilt 1992 · S/N Y5-01 N1014YG-Dawg LLC · Highlands, NCBuilt 2005 · S/N JAESC0083 N1017UMoir Jeffery K · Newhall, CABuilt 1952 · S/N E3B-435 N101AGPosch Johann · Sandy, UTBuilt 1985 · S/N 57 N101AZCarlton Robert J · Moriarty, NMBuilt 1984 · S/N 60 N101BSOn Mission Network · Dallas, TXBuilt 1968 · S/N LJ-375 N101CFClark Floyd Counties Convention & Tourism Bureau · Jeffersonville, INBuilt 2018 · S/N 6852 N101CJMain Patrick R · Udall, KSBuilt 1999 · S/N 02120 N101FSHernandez Adam · Wilmington, CABuilt 1992 · S/N DMO 121 N101GJMorrison Neil E · Port Townsend, WABuilt 1987 · S/N GJ-101 N101HBMarino Mark A · Duluth, MNBuilt 2005 · S/N 001 N101JNCombat Air Museum · Topeka, KSBuilt 1969 · S/N R101 N101KMHolliday Dean M Trustee · Klamath Falls, ORBuilt 1985 · S/N E-2253 N101MXBakr LLC · Los Angeles, CABuilt 2000 · S/N 609 N101RHBarrieault Mark A · Las Vegas, NVBuilt 1983 · S/N RH-1 N101RWSmith Travis T · Watsonville, CABuilt 1991 · S/N 551191028 N101SVHusky Larry Joe · Silverton, ORS/N 0494-CW-0478 N101XPGregory David A · Westmoreland, TNS/N 7149 N10232Sigler Andrew C Jr · Waverly Township, PABuilt 1996 · S/N CH2 0794 CW 11892 N1024DMac Donald Randy N · Weidman, MIS/N MR623P N1024RMays Kevin E · West Liberty, KYS/N 22375 N1025GLatimer Francis E · Washingtonville, NYBuilt 2006 · S/N 82224 N1026WWarner Robert P · Monticello, INBuilt 2004 · S/N 71745 N1028ABaker Guy S · Onalaska, TXBuilt 2004 · S/N 34-N N1028QGranger Arthur E · Hurricane, UTS/N 1001 N102ALKnapp Edward · Zephyrhills, FLBuilt 1993 · S/N 20302 N102BSShannon Bruce Scott · Bethlehem, PABuilt 1984 · S/N 222 N102HSRegistration Pending · Castle Rock, CORegistration pendingBuilt 1995 · S/N 16 N102JHHickey John C · Belleville, MIBuilt 1992 · S/N 1471 N102MLBowden Michael B · Bowling Green, KYBuilt 2000 · S/N 001 N102RE6th Street Consulting LLC · Redondo Beach, CABuilt 2006 · S/N 7182 N102RVSink Douglas · Clarendon Hills, ILBuilt 2004 · S/N 80102

Back to Amateur-built UNKNOWN ENG