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.

N116LBWinkel John H · Marion, IAS/N 5162 N116RBRatzin Brendan · Pahrump, NVBuilt 1968 · S/N 95 N116RRGross Gary O · Beaverton, ORBuilt 1995 · S/N 016 N116TCHorst Daniel L · Webster, SDS/N 1700US N116TMBlakely Carmen R · Salem, ORBuilt 2003 · S/N 90/62 N1170SRefugio Soaring Circle Inc · Refugio, TXBuilt 1972 · S/N 70 N11716Coffing Stephen A · Albuquerque, NMBuilt 2022 · S/N 2034 N1171ERamponi Dominic · Phelan, CABuilt 2006 · S/N 6439 N1172SValley Soaring Club Inc · Middletown, NYBuilt 1972 · S/N 72 N11737Hebert Leonard W · Logan, UTS/N A664 N1173SFlint River Soaring LLC · Bainbridge, GABuilt 1972 · S/N 233 N1176SSky Sailing Inc · Warner Springs, CABuilt 1971 · S/N 226 N1178SLowry Wilson R · Leonardtown, MDBuilt 1971 · S/N 228 N1179SSchwam Julie R · Hayden, IDS/N 229 N117BSBlaser Swisslube · Goshen, NYBuilt 2021 · S/N 1917 N117GVTexas Soaring Association Inc · Midlothian, TXBuilt 1998 · S/N 181 N117RTDoyle Connor G · North Adams, MABuilt 1972 · S/N 17009 N117TBSaunders Christopher D · Lehighton, PAS/N 17 N1182SDouglas Paul W · Brooklyn, WIBuilt 1972 · S/N 232 N1184RClemons Pamela K · Boone, IAS/N RX6-238 N1184SBates Marcus L · Leander, TXS/N 234 N1185SFault Line Flyers · Leander, TXBuilt 1972 · S/N 235 N1186SMohawk Soaring Club · Hoosick Falls, NYBuilt 1972 · S/N 236 N1187SAir Biscuit LLC · Williamson, GABuilt 1972 · S/N 237 N1188SFault Line Flyers · Leander, TXBuilt 1972 · S/N 238 N11895Boland Brian J · Post Mills, VTBuilt 1971 · S/N 1 N1189SSkysurfing Hawaii LLC · Waialua, HIBuilt 1972 · S/N 62 N118ABMathrani Nirmal K · Potomac, MDBuilt 1992 · S/N 102CS N118BBair Ray · Albuquerque, NMBuilt 2013 · S/N 6689 N118BBFranconia Soaring Association · Franconia, NHS/N 938026 N118BLEdge Aviation LLC · Hawthorne, FLBuilt 1965 · S/N 30-913 N118ECCohen Eliav · Burien, WABuilt 2019 · S/N 6879 N118JSIndy Hot Air LLC · Westfield, INBuilt 2022 · S/N 1989 N118LBBrodbeck Amanda Pearl · Dacono, COBuilt 2001 · S/N 5179 N1190SSky Sailing Inc · Warner Springs, CABuilt 1971 · S/N 227 N1191SCivil Air Patrol · Maxwell Afb, ALBuilt 1967 · S/N 5 N1192WSuttle James Paul · Strasburg, OHBuilt 2003 · S/N 6343 N1194Leonard Steven E · Wichita, KSS/N 4 N11951Zing Aerosports LLC · Peoria, AZBuilt 2006 · S/N 6449 N1196SBlack Industries LLC · Helena, MTBuilt 1970 · S/N 196 N119BBGet High Incorporated · Longview, TXBuilt 1992 · S/N 2214USA N119CFHustler James E · Carson City, NVBuilt 1981 · S/N S66A-119 N119FKRegistered aircraftBuilt 2013 · S/N 6713 N119JGGrecco Joseph J · Saddle Brook, NJBuilt 1977 · S/N 19137 N119LTCilley Sherburn C · South Royalton, VTBuilt 1980 · S/N 19312 N119SKKing Air 3au LLC · Wichita, KSS/N 414A0660 N11BQBalloon Quest Inc · Fenton, MIBuilt 2001 · S/N S81A-3010 N11CNSoar Wisc Inc · Little Canada, MNBuilt 1976 · S/N 20099 N11EKEastern Soaring Center Inc · Petersburg, WVBuilt 1972 · S/N 13401 N11GVGrah David B · Bishop, CABuilt 1965 · S/N 6