Skip to content

Registered aircraft · 7,853

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.

N2040JWells Russell L · Seville, OHS/N SEM170 N2040TTurlington Jerry K · Lynchburg, VAS/N 339 N2040VNilz Patrick Shawn · Marana, AZBuilt 1988 · S/N 5392 N2041TAba Soaring LLC · Walpole, NHBuilt 1977 · S/N 496 N2042TArizona Soaring Inc · Maricopa, AZBuilt 1977 · S/N 472 N2043WSchendel Robert T · Overland Park, KSBuilt 1988 · S/N 5399 N20441Jd Adventures LLC · Piscataway, NJBuilt 2006 · S/N F8B-2091 N2044FWilliams Frank M · Clearwater, FLBuilt 2005 · S/N F7-2058 N2044TSoaring Eagle Foundation · Peyton, COBuilt 1977 · S/N 474 N2045DVon Tresckow Peter · Madison, WIBuilt 1968 · S/N 13 N2045RVereb Frederick P · Tampa, FLBuilt 2012 · S/N 415 N2046HWallis Edward J · Calistoga, CABuilt 1978 · S/N 7718 N2047TWright Thom W · Albuquerque, NMBuilt 2005 · S/N 342 N20498Ad Astra Per Aspera LLC · Fort Dodge, IABuilt 2011 · S/N 410 N2049YAlbers David · Phoenix, AZBuilt 2011 · S/N 406 N204FSoardelta LLC · Greenwood, MSBuilt 1976 · S/N 52 N204JGGreer John M Jr · Mercer Island, WABuilt 2000 · S/N 76 N204MDCrichton James W · Chattanooga, TNBuilt 1993 · S/N 930204 N204MLSheppe Richard W Jr · Hanover, NHS/N 007 N204THernandez Jorge L · Luthersville, GABuilt 1979 · S/N 91 N204VBVista Balloon LLC · Portland, ORS/N 210/99 N2052BKinsinger Justin L · Richmond, CABuilt 1988 · S/N 1603 N2052SSanderson Alan R · Albany, ORBuilt 2006 · S/N F8B-2093 N2052TPeterson Adam · Bakersfield, CAS/N 497 N2052XCentennial Aerosports LLC · Choctaw, OKBuilt 2006 · S/N F7-2064 N2055HSwann Phyllis Ruth · Madison, ALBuilt 2007 · S/N 349 N2055TLong Island Soaring Association Inc · Yaphank, NYBuilt 1977 · S/N 495 N2056ZNorthern Light Balloon Expeditions · Sedona, AZBuilt 1999 · S/N 205 N2057FGrand Junction Balloon Port · Fruita, COBuilt 2000 · S/N F8B-604 N2057NRegistered aircraftS/N 6589 N2057TLarson Martin B · Rapid City, SDBuilt 1977 · S/N 487 N20586Richardson Sean M · Kannapolis, NCS/N F8-2014 N2059BChapton Donald H Trustee · Menifee, CAS/N F6B-2005 N2059DAlways Time To Fly LLC · Albuquerque, NMBuilt 2008 · S/N 6530 N205AXWillbanks Robert S · Lavonia, GABuilt 1987 · S/N 128 N205PWStoyanov Nikolay S · Jersey City, NJBuilt 1996 · S/N 1706017 N2060TTulsa Skyhawks Inc · Tulsa, OKBuilt 1977 · S/N 490 N2061TSkyleader North America Inc · Madera, CABuilt 1977 · S/N 491 N2062TBriner Mark E · Utica, KYS/N 492 N20642Clemens Russell E · El Cajon, CABuilt 1942 · S/N 186530 N20671Davis William A Jr · Helena, ALBuilt 2009 · S/N 386 N206KBSeattle Ballooning LLC · Burien, WABuilt 2026 · S/N 2632 N2072JSusquehanna Valley Balloon Co Inc · Lititz, PABuilt 1988 · S/N 5432 N20737Finger Lakes Soaring Club Inc · Dansville, NYBuilt 1976 · S/N 1132 N20744Rossano Amanda C · Gordonsville, VABuilt 2023 · S/N 6975 N2075NPowers Daron A · Pewaukee, WIBuilt 2006 · S/N F7-2062 N2078DBloomfield John R · New York, NYBuilt 1977 · S/N 20593 N2078LNauman Russell M · Des Moines, IAS/N 5440 N20796Marketing Services Inc Of Pueblo DBA · Colorado Springs, COBuilt 2006 · S/N F8-2016 N2079BZimmer Rachel A · Rio Rancho, NMBuilt 1988 · S/N 5421