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.
N109GSKalmar Istvan · Torrance, CAN109HBLambros J Mitchell · Cockeysville, MDN109JARocca John C · Box Elder, SDN109MTMorris Daryl L · Miami, AZN109PLSherman Aircraft Sales Inc · West Palm Beach, FLN109RLShannon Air Museum LLC · Fredericksburg, VAN109TBMensink David L · Preston, MNN109TCCrook E Tracy · Bell, FLN109WHTre Aviation Corp · Wilmington, DEN109YKGilbert William O · La Quinta, CAN10AGoodyear Tire & Rubber Co · Akron, OHN10BAAsberry Gregg J · Sidney, ARN10CZKalb Kent W · Flemingsburg, KYN10EDKraft Thomas · Meridian, TXN10FXFox Christopher K · Hanover, PAN10GXAero Flight Solutions LLC · Jensen Beach, FLN10LSLund Clayton L · Cheboygan, MIN10PGNoguess Levi B · Belton, TXN10QTRainbow Aviation Services · Kingsville, MON10RXSchmader Leonard J · Sewalls Point, FLN10VEGambrill Lucas W · Athol, IDN10VNTen Victor November LLC · Kailua, HIN10VRPoon Andre · Arcadia, CAN10XDWitham Philip J · Portland, ORN10XHScion Helicopters LLC · Fort Collins, CON10XXBennett Graham F · Winston Salem, NCN10YKJ & A Aero Inc · Wilmington, DEN1100BKelley Keith B · Forney, TXN1104GBrowett Don A · Independence, MOFirst renewal noticeN1105BAgaliotis Paul E · San Martin, CAN1106PHopland Steven R · Johnson City, TNN110BLBlue Ridge Soaring Society · New Castle, VAN110DEDraper Paul S · Livonia, MIN110EPDouble Eagle Flyers LLC · Louisville, KYN110FFFreedom Flight Works · San Diego, CAN110FTEast Boulder LLC · Mc Leod, MTN110KHOlson Spencer L · Keysville, GAN110KKO Neill Kevin J · Granbury, TXN110TUQualls Steven Bret · Conway, ARN110VCPete Bitar · Anderson, INFirst renewal noticeN110YKPetri David S · Peyton, CON110YXMcnorton Edward A · Sanford, NCN1111BCoastal Explorer LLC · Eastlake Weir, FLN1112UMoroianu Dragos · Cupertino, CAN111CWWight Leland S · Williamsfield, ILN111DWLumcavok Aviation 1 Inc · Middletown, DEN111EHRosvold Eric O · Petersburg, AKN111EPPuschmann Eric R · Beavercreek, OHN111FSTsi Holdco Inc · Virginia Beach, VAN111GCSimmons Brandon M · Sylacauga, AL
Back to Amateur-built UNKNOWN ENG