Skip to content

Registered aircraft · 7,850

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

N1130SBockelman Michael · Lone Jack, MOS/N 61 N11321Wadsworth William C · Albuquerque, NMBuilt 2022 · S/N 1890 N1134SSky Sailing Inc · Warner Springs, CABuilt 1971 · S/N 514 N1134TChen Yifei · Irvine, CABuilt 1973 · S/N 400 N1135SGluck Lewis · Wurtsboro, NYBuilt 1971 · S/N 515 N1138SLoomiller Craig D · Disney, OKBuilt 1972 · S/N 518 N1139SFault Line Flyers Inc · Leander, TXBuilt 1972 · S/N 519 N113ADStiles Paul W · Hamilton, TXS/N 20688 N113DADel Mar College · Corpus Christi, TXBuilt 1972 · S/N 1799 N113SABarry Russell L · Fort Mohave, AZS/N 4-113 N113TCEkdahl Dean · Temecula, CABuilt 1990 · S/N 1737USA N113TXSwift Montana LLC · Lakeside, MTBuilt 1992 · S/N 104 N113YZNevada Soaring Association Inc · Reno, NVBuilt 1973 · S/N 555 N1141SRing Susan E · Hahira, GABuilt 1972 · S/N 521 N1142SSchweizer Leslie E · Cayuta, NYBuilt 1972 · S/N 522 N1143Bruder Niclas · Portland, ORBuilt 1966 · S/N 29 N1143PRed Rock Balloon Adventures · Cornville, AZBuilt 2017 · S/N 6809 N1143SNicholson Larry C · Calcutta, OHBuilt 1972 · S/N 523 N1146Bogardus George Randal · Jacksonville, ORS/N 27 N1146SHonolulu Soaring Club Inc · Waialua, HIBuilt 1971 · S/N 76 N1146XKramer Dean E · Bernville, PABuilt 1966 · S/N 20 N1147WWilkinson Steve A · Lake Havasu City, AZBuilt 2005 · S/N 6425 N1148SMullins Darrel L · Urbandale, IABuilt 1971 · S/N 58 N1149SRasmussen Steven T · Papillion, NEBuilt 1972 · S/N 483 N114DMSale Reported · Freehold, NYSale reportedBuilt 1986 · S/N 101B0253 N114JSJenkyn Lawrence R · Hanover, NHBuilt 1993 · S/N 24190 N114LBSeize The Breeze LLC · Southampton, NJBuilt 2009 · S/N 5446 N114MSLynch James D · Scottsdale, AZBuilt 1976 · S/N 20131C N114SZRutledge Todd K · Fishers, INBuilt 1989 · S/N 4731 N114TWSaunders Christopher D · Lehighton, PABuilt 2000 · S/N 57 N1152GN1152g LLC · Oklahoma City, OKBuilt 1981 · S/N 25-0625 N1155QWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1964 · S/N 18 N1156QHardy John S · Fort Worth, TXBuilt 1964 · S/N 19 N1156SGreater Boston Soaring Club · Sterling, MABuilt 1971 · S/N 56 N115LBBoylan Michael E · Washington, ILBuilt 2012 · S/N 5527 N115LCLow Country Soaring Association · Ridgeland, SCBuilt 1997 · S/N 17.09.007 N115TCPyramid Pool LLC · Glendale, AZBuilt 1990 · S/N 1704USA N1161RMcclusky Curtis G · Fair Oaks, CABuilt 1977 · S/N S55A-322 N1161SAntelope Valley Soaring Club Inc · Llano, CABuilt 1972 · S/N 239 N1162RGriffin Nancy O · Fort Collins, COBuilt 1977 · S/N S55A-324 N11635Radowski Johnathan P · Phoenix, AZS/N 078 N1164Benjamin Kirby · Colorado Springs, COS/N 8542-SH N1164SConnecticut Soaring Association Inc · New London, CTBuilt 1972 · S/N 64 N1166SBlanton Robert D · Wichita, KSBuilt 1972 · S/N 66 N1167SKite Adam H · Ogden, UTBuilt 1972 · S/N 67 N1169SCypress Soaring Inc · Hemet, CABuilt 1972 · S/N 69 N116BBTomanek Wojciech K · Pueblo West, COBuilt 1992 · S/N 551192041 N116CBGo Ballooning LLC · Beavercreek, OHBuilt 1977 · S/N 239 N116DSStevenson Malcolm D Jr · Cedar Crest, NMBuilt 1985 · S/N 6025 N116FSLowenstein Albert L · Albuquerque, NMS/N 171