Skip to content

Registered aircraft · 7,860

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.

N4644SBracy Rodney E · Middleville, MIBuilt 1963 · S/N 39 N46482Henck Mark E · Indiana, PABuilt 1976 · S/N 67 N464GTTomco Stores Ltd · Ruidoso, NMBuilt 2023 · S/N 28076 N4653TWille Chad C · Corning, IABuilt 1964 · S/N WB-1 N4659Hutchings Mathew J · Camano Island, WAFirst renewal noticeBuilt 1971 · S/N 174715 N465CBTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1983 · S/N 4339 N465LBRowland Jacob · Albuquerque, NMBuilt 2008 · S/N 5390 N465PWTidewater Soaring Society Inc · Windsor, VABuilt 1997 · S/N 17.08.025 N465XChristian Bret A · Indianola, IABuilt 2017 · S/N 5637 N4660SChristman Timothy A · Dayton, OHBuilt 1963 · S/N 8204 N46627Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1943 · S/N G-184 N4663SClayton Harry L · Wichita, KSS/N 8213 N4663TSlad George W · Albuquerque, NMS/N 5525 N4676SHenderson Gary W · Bowdon, GABuilt 1964 · S/N 6288 N4678SMorrison Scott R · Keizer, ORBuilt 1964 · S/N 8349-SH N467SEDelta Breeze Hot Air Balloon Promotions LLC · Greenwood, MSS/N 987 N467USBlue Skies Hot Air Balloon Adventures LLC · Boise, IDBuilt 2009 · S/N 1258 N46811Sky Sailing Inc · Warner Springs, CABuilt 1977 · S/N 20013 N46898Rander Steven D · Cornelius, ORBuilt 1977 · S/N 75 N468MPSchababerle Mark Joseph · Cincinnati, OHBuilt 1979 · S/N 3298 N468SASouthern California Soaring Academy Inc · Valencia, CABuilt 2014 · S/N 21908 N469BRAnderson Justin C · Walla Walla, WABuilt 2002 · S/N 5204 N469DRRegistered aircraftBuilt 2010 · S/N 6586 N469KBPolishchuk Igor A · Noblesville, INBuilt 2006 · S/N A033SM01 N469PKLiley Brian A · Fall Branch, TNBuilt 1977 · S/N 770 N469RMRe/Max Marketing Fund LLC · Denver, COBuilt 2019 · S/N 6880 N46ASDobbins John R · Green Valley, AZBuilt 1978 · S/N W-864 N46AVOn-Target Management Group LLC DBA · Dublin, OHBuilt 1980 · S/N 46 N46DXBergman Trey · Houston, TXBuilt 2000 · S/N 3E489A30 N46GHBunnell Shawn H · Gilmanton, NHS/N 20800 N46JDKarst Max H · Seattle, WABuilt 1976 · S/N 20145C N46KSCarlton Robert D · Polk City, FLBuilt 1993 · S/N S49A-3178 N46RDLake Norman Flyers LLC · Huntersville, NCS/N 174129 N4700GSouthern Eagles Soring Inc · Butler, GABuilt 1964 · S/N 7164 N470BACivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 069204 N470BDDierker Robert R · Chestertown, MDBuilt 1970 · S/N 470 N470LBStevenson Frank W · Frankfort, KYBuilt 2006 · S/N 5326 N470WLMoore Gary K · Lake Havasu City, AZBuilt 2004 · S/N TV-00104 N471LBSweet Jeffrey E · Hendersonville, NCS/N 5322 N472BACivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 069206 N472JHMabry Thomas · Atlanta, GABuilt 1981 · S/N 20472 N473Cote Matthew R · Fairfield, VTBuilt 1968 · S/N 1 N47312Leatherheads LLC · Greer, SCS/N 7637 N4736GLeonard Steven E · Wichita, KSBuilt 1966 · S/N 1 N4736MAmp Air LLC · Gulf Shores, ALBuilt 1985 · S/N E-2243 N47390Rebholz Mark A · Aguila, AZBuilt 1942 · S/N 19 N473BACivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 079207 N473DFUsda Forest Service Fepp · Mcclellan, CAS/N 155406 N4749SOverton Wilbur Charles · Roanoke Rapids, NCBuilt 1966 · S/N 28 N474BTMagee Aviation Services LLC · Rochester, NYS/N 5108