Skip to content

Registered aircraft · 7,855

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.

N2905HHigh Flights Soaring Club · Peyton, COBuilt 1979 · S/N 545 N290BAMayes Brent L · Aurora, ORBuilt 1996 · S/N 940316 N290CBHot Airtime Ballooning LLC · Grass Lake, MIBuilt 1979 · S/N 453 N290MUMueller James J · Washington, DCBuilt 2017 · S/N 2016-90 N290SBSeminole Flying & Soaring Inc · Clermont, FLS/N 938029 N291JSWiederkehr Hans R · Ballston Lake, NYBuilt 2012 · S/N 29076 N291SMTwenty Inc · Wilmington, DEBuilt 2008 · S/N 29042 N291SVKini Vivekanand R · Sunnyvale, CABuilt 2006 · S/N 29005 N291WHaynes Michael J · Lenexa, KSS/N 15021 N2922HUmphlette Charles B Jr · Suffolk, VABuilt 1978 · S/N 92 N2923Wind Surfer Ballooning LLC · Carlisle, IABuilt 2024 · S/N 2387 N29236Atwill John R IV · Vancouver, WABuilt 1986 · S/N RX7-3022 N2924HReilman Robert F Jr · Colorado Springs, COBuilt 1979 · S/N 94 N2925LBoland Brian J · Post Mills, VTBuilt 1984 · S/N 5050 N2926Martucci Dennis J · Monroe, GAS/N 84 N2927HCrowley James S · Riverview, FLBuilt 1980 · S/N 97 N292DHHillary Dennis S · Machesney Park, ILBuilt 1999 · S/N 40 N292EWCarlson Emily K · Topeka, KSS/N F7-294 N292WMWashburn Gordon L · Lakeland, FLBuilt 1970 · S/N 15076 N292XASoar Hawaii Foundation · Waialua, HIS/N XA-292 N2930HConnecticut Soaring Association · New London, CTBuilt 1978 · S/N 530 N2938Robertson Raymond A · Potsdam, NYBuilt 1970 · S/N 20 N293BACentral Alabama Soaring Association · Birmingham, ALBuilt 1994 · S/N 948122 N29417Sommers Christopher Alan · Slatington, PABuilt 1986 · S/N RX7-3028 N2941KWilliams Scott M · Gales Ferry, CTS/N RX7-3026 N2941RBourgeois Roy A · Litchfield Park, AZBuilt 2008 · S/N 29041 N2943Profota Don L · Bozeman, MTBuilt 2008 · S/N 29035 N2947HHayter Henry W Jr · Burlington, KYBuilt 1979 · S/N 687 N294BAHinckley David D DBA · Belton, TXBuilt 1994 · S/N 948121 N294MGDutton Douglas D · Lindsborg, KSS/N 1584 N294SLStoops Brian A · Dayton, OHBuilt 2006 · S/N 29003 N2952HKeyuravong Pisonth · Anchorage, AKBuilt 1979 · S/N 682 N2953HCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 553 N2954CWoodin Stephen D · Flagler Beach, FLS/N 23 N2954HLiles Daniel A · Winston Salem, NCBuilt 1979 · S/N 684 N2955CClemons Benji · Norwalk, IABuilt 2019 · S/N LC-03 N2956FAvag Inc · Richvale, CAS/N 63-12950 N295MHHostage Gilmary M III · Boerne, TXBuilt 2015 · S/N 002 N29616Walter Forrest L · Spokane Valley, WABuilt 1976 · S/N 11 N2966HLannom Tony F · Fort Davis, TXBuilt 1979 · S/N 96 N2968YNead Mark · Las Vegas, NVBuilt 1986 · S/N 5170 N29699Cushing John R · Lutz, FLBuilt 1977 · S/N 37 N2972Macveigh John D · Thomasville, PABuilt 1972 · S/N 282 N2975HArizona Soaring Inc · Maricopa, AZBuilt 1979 · S/N 693 N2977XConrad Kenneth J · Albuquerque, NMBuilt 1986 · S/N 5167 N2978JBubbles On Ash LLC · Tempe, AZS/N 5069 N29801Stanko Nicholas J DBA · Austin, TXS/N 5087 N2981HWashburn Peter J · Lemont, ILBuilt 1979 · S/N 691 N2983YHorst Daniel L · Webster, SDBuilt 1988 · S/N 5180 N2984HTidewater Soaring Society · Windsor, VABuilt 1979 · S/N 560