Amateur-built UNKNOWN ENG
Registered aircraft · 6,573
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_numberRun 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.
N111GLLankfer Gary M · New Era, MIN111JKKing Gailyn M · Boulder, CON111LMGuzman Roger P · Madera, CAN111NNZwierlein Victor A · Grand Prairie, TXN111PUWorthington Sean T · Templeton, CAN111SYNachbar Daniel · Amherst, MAN111ZEWiese Paul · Owosso, MIN11216Van Pelt Scott · Northwood, NHN1124TEiland Eddie L · Dublin, TXN1127Wiebe James R · Valley Center, KSN11273Johnson Terri L · Spring Green, WIN112DSugden Richard G · Wilson, WYN112EVArbie Phillip S · Mc Donald, OHN112GLDenton Dustin · Westville, OKN112JHHutton Joseph M Jr · Ocala, FLN112KVKaitis Keye V · Joliet, ILN112SESpirit Engineering Inc · Grand Junction, CON112SXBuck Peter A · Valencia, CAN112TMSurgent Richard L · Wall Township, NJN112XSJohnson Gary A · Lecanto, FLN1139QAmerican Flight Museum · Topeka, KSN113AJMorris Douglas K · Huntsville, ALN113ASCutter Anthony D DBA · Corning, CAN113MHCasavia Corp · Guelph OntarioN113SPAdvance Alarm Monitoring Inc · Paris, TXN113WDDoiron W David · Tempe, AZN1145Evans Timothy Kent · Fremont, NCN114AREngvall Allan E Jr · Antelope, CAN114CHLb Aero Services Inc · Poplar Grove, ILN114DZGaluppo Ronald Richard Jr · Bynum, TXN114FGDee Stephen W · Cordova, TNN114JJHarris Dan C · Rockford, TNN114KMAeolus Labs Inc · San Francisco, CAN114KSUSA Up Star Air Charters LLC - S Series B · Greenwood, INN114TRLacombe Thomas · Denton, TXN114VPietsch Warren A · Minot, NDN114VSVertol Systems Co Inc · Destin, FLN114XPParkhurst Thomas G · Guilford, NYN1150Ace Aircraft Co Inc · Toccoa, GAN1154MMarshall John M · Byers, CON1155DParsons Duane A · Morgantown, INN11574Branham Ronald O · Panama City Beach, FLN1158KGaithersburg Mooney Flyers LLC · Rockville, MDN115AJJdi Holdings LLC · Belgrade, MTN115BWeber David A · Bryan, TXN115DHMalousek Andrew James · Lincoln, NEN115DPWerth Justin T · Bellville, TXN115JHCorrell Walter L · Fairbanks, AKN115JKAircraft Guaranty Corp Trustee · Oklahoma City, OKN115LRipps Robert S · Georgetown, TX
Back to Amateur-built UNKNOWN ENG