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.
N105RBTriple T Aviation LLC · Los Lunas, NMN105WPPercival Wilhelm F · Las Vegas, NVN105YXMunch Gordon E · Aumsville, ORN1061HBristol David W · Sautee Nacoochee, GAN10629Watts Garage LLC · Jersey Shore, PAN1062SDepew Michael P · Nashua, NHN10636What A Wind LLC · Mattawan, MIN1064FWeeks Vaughan B · Racine, WIN1065TMcgee Kenneth J · Wilmington, NCN1067LCollins Gene William · Manassas, VAN1067ZRaile Stanley L · Calera, OKN1068SAndrezej Sitarz · Bridgewater, NJN1068WSterling Foundation · Valparaiso, INN1069KAbernethy David A · Atlantic Beach, NCN106DLB A G H S LLC · Fort Lauderdale, FLN106EJDemaria Christopher J · Redmond, WAN106JMGentile Kevin Joseph · Louisa, VAN106SBHolden Britton Reed · Denham Springs, LAN106XXBank Of Utah Trustee · Salt Lake City, UTN1071GRegistration Pending · Fort Scott, KSRegistration pendingN10728Jstream Lc · Sheridan, WYN10743Liimatainen William J · Monroe, WIN1079EEastern Stearman Inc Trustee · Leesburg, VAN107BWBlumer James Allen · Sun City, AZN107FMZing Aerosports LLC · Peoria, AZN107GCHistoric Aircraft Restoration Museum · Saint Louis, MON107JWPlayer Jennifer L · Stevenson, WAN107LMLance Murray Aviation LLC · San Marcos, CAN107PJPc-24 LLC · Park City, UTN107RMDierolf Robert Scott · Carrollton, TXN107SDMiller Daniel A Sr · Manassas, VAN107TTBpi Labs Inc · Evanston, WYN107VCLopez Hidaldo Vicente · San Juan, PRN1081HTevis Aviation Inc · Emporia, KSN1084AMarkle Rick S · Waddy, KYN1085PFirkins Todd H · Granbury, TXN108ETCarlisle LLC · Scottsdale, AZN108GLLoucks David M Executor · Hammondsport, NYN108KMockler David R · Azle, TXN108SWExpress Air LLC · Wilmington, DEN108YZGopalan Hariharan · Morrisville, NCN1090GEdwards David M Jr · Greenwood, MSN1091Mid America Museum Of Aviation And Transportation · Sioux City, IAN109ACSayger Jack M · Ridgeland, SCN109BRSchwenninger Ronald L · Allison Park, PAN109BSPereira Rodrigo · Winter Haven, FLN109BWJones Victor · Delaware, OKN109CNOestreich Klaus M · Needville, TXN109FHAlbatross Aviation Hawaii LLC · Waialua, HIN109GBWheeler Steven E · Northfield, MN
Back to Amateur-built UNKNOWN ENG