Skip to content

Registered aircraft · 7,857

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.

N338WNUsda Forest Service Fepp · Olympia, WAS/N 63-08846 N33904Perkins Trever G · La Luz, NMBuilt 1975 · S/N 634 N33909West Michigan Aviation Academy · Grand Rapids, MIBuilt 1975 · S/N 629 N33914Boggs Gary D · Tonopah, AZS/N 644 N33915Fenske Joseph G · Boonton, NJBuilt 1975 · S/N 625 N33917Greater Boston Soaring Club Inc · Sterling, MABuilt 1975 · S/N 637 N33923Las Vegas Valley Soaring Assoc · Jean, NVBuilt 1975 · S/N 413 N33926Henderson Colin D · Norman, OKBuilt 1975 · S/N 641 N33928Flying L Aircraft Inc · Fort Denaud, FLBuilt 1975 · S/N 408 N33929High Flights Soaring Club Inc · Peyton, COBuilt 1975 · S/N 411 N33933Hershey Flying Service Inc · David City, NEBuilt 1975 · S/N 403 N33941Gehrlein Rodney L · Waterford, PABuilt 1975 · S/N 401 N3394FPortland Rose Balloons LLC · Wilsonville, ORBuilt 1999 · S/N 6207 N3394PBaird Allen · Tipton, INBuilt 2002 · S/N 6304 N33962Soaring Club Of Houston · Waller, TXBuilt 1974 · S/N 362 N33966Flight Experience For Youth · Warren, VTBuilt 1974 · S/N 366 N33968Franconia Soaring Assoication Inc · Franconia, NHBuilt 1974 · S/N 368 N33982Johnson Theodore Otto Jr · San Diego, CABuilt 1975 · S/N 632 N33983Jersey Ridge Soaring LLC · Blairstown, NJBuilt 1975 · S/N 383 N33996Doyle Brian G · Windsor, MABuilt 1974 · S/N 6 N339PRegistration Pending · Saint Augustine, FLRegistration pendingBuilt 1979 · S/N 3399 N339WNUsda Forest Service Fepp · Olympia, WAS/N 63-12979 N33DXBostik Josef J · Green Cove Springs, FLBuilt 1985 · S/N 33 N33GALay Lawrence W · Douglass, KSBuilt 1977 · S/N 111 N33HBSciortino David L · Vail, AZBuilt 1984 · S/N 3 E 47 N33RDVarvarosky Chris G · Columbus, OHS/N 15129 N33UUGallego Javier · Diamond Bar, CABuilt 1980 · S/N 3444 N340TWJoyce David B · Brookline, NHBuilt 1999 · S/N 45 N34107Strong Kurt J · Lake Geneva, WIBuilt 1975 · S/N 50 N34173Zacharski Robert · Wakefield, MAS/N 12 N34174Registered aircraftBuilt 1975 · S/N 14 N34175Hull Mahlon B · Sedro Woolley, WABuilt 1975 · S/N 15 N34180Raven Nw Llp · Acme, PAS/N 20 N34181Folwarczny Petr · Round Lake, ILBuilt 1975 · S/N 21 N34183Smith Timothy A · Poynette, WIBuilt 1975 · S/N 33 N34185Olczyk Adam · Woodhaven, NYBuilt 1975 · S/N 25 N34189Mays Paul R · Toney, ALBuilt 1975 · S/N 39 N341BAVan Noy Terry W · Henderson, NVBuilt 1999 · S/N 998415 N341KSSkyline Soaring Club Inc · Front Royal, VABuilt 2002 · S/N 21752 N341PWSoaring Science Inc · Wilmington, DEBuilt 2002 · S/N 17.12.023 N341RRRainbow Ryders Inc · Albuquerque, NMBuilt 2021 · S/N 6953 N34215Burbank Franklin R · Ocala, FLBuilt 1975 · S/N 415 N34262Zhills Soaring LLC · Temple Terrace, FLBuilt 1975 · S/N 42 N34292Registration Pending · Tehachapi, CARegistration pendingBuilt 1975 · S/N 412 N34298Frasca Air Museum · Urbana, ILBuilt 1976 · S/N 420 N342CRTree Top Flyer Ballooning LLC · Cleveland, NCBuilt 2018 · S/N 2018/342 N342EZMcgowin Timothy P · Auburn, ALBuilt 2001 · S/N 40-17 N34367University Of Central Missouri · Warrensburg, MOFirst renewal noticeBuilt 1975 · S/N 407 N34396Swett Frank M · Zebulon, NCBuilt 1975 · S/N 416 N343RRosenbaum Henry D · Mechanicsville, VABuilt 2023 · S/N LP2023-03