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.
N102SXJohnson Alvie M · New Plymouth, IDN102TATerpin Gregory A · Champion, PAFirst renewal noticeN102TJFitchen Christopher H · Poplar Grove, ILN102TWSmolinski Ryszard · Burbank, CAN102XXBank Of Utah Trustee · Salt Lake City, UTN102YCullman Daniel H · Kent, WAN102YKHonan John A · Lincroft, NJN10367Neidert Melvin E · Ulysses, KSN10396Jackson Arthur P · Catawba, SCN1039WLiewer Timothy M · Anselmo, NEN103AWLove Thomas C · Jeffersonville, INN103BESanders Darrel T · Camp Douglas, WIN103DRHosmer Jack · Sanford, NCN103FKWilliams Eric L · Angola, INN103JJPerkins Dennis W · Avon, INN103MNDaus Chuck · Imler, PAN103PHHomyk Randy C · Homestead, FLN103SCarter Tonja B · Monroeville, ALN103TRCathriner Richard J · Plano, TXN103VKCc Aviation Inc · Tracy, CAN103VTSchilling Mark K · Jeffersonville, VTN103WHPs Soaring Inc · Bellefonte, PAN103WTSchultz Todd · Bakersfield, CAN103YKLucas John W · Henryville, INN1042CRmi Air LLC · Ocilla, GAN10432Huey 197 LLC · Argyle, TXN1045SRegistration Pending · Lakeview, ORRegistration pendingN1049SRankin Bradley W · Maryville, MON104AMSee Kimberly · Seeley Lake, MTN104BPSalisbury Peter R · Whitebear Township, MNN104CHWhite Dustin · Yukon, OKN104DDDawson William J · Beaverton, ORN104JCHarlen Joseph · New Palestine, INN104JKWilson Ronald J · Wichita Falls, TXN104JRRodrigue James N · Lewiston, MEN104LGN104lg LLC · Wilmington, DEN104PZLefever Benjamin E · White Oak, NCN104RDStarfighters International Inc · Merritt Island, FLN104STFlandermeyer Scott R · Fayetteville, GAN104YKBales Philip · Chandler, AZFirst renewal noticeN104ZZDubbert Roger · Mexico, MON1051JRegistered aircraftN-number assigned, not yet registeredN1059YZielinski Gary R · Gainesville, GAN105DAKenmore Crew Leasing Inc Trustee · Bellingham, WAN105ECProp & Jet Air Museum · Romoland, CAN105ELTanzer David I · Waitsfield, VTN105FRNational Test Pilot School · Mojave, CAN105GDHudson Mitchell C · Erie, CON105JXSchneider Jesse · Jenks, OKN105NBNorthcentral Aircraft LLC · Blaine, MN
Back to Amateur-built UNKNOWN ENG