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.

N2832EBlair Ventures LLC · Newark, DEBuilt 2023 · S/N 2120 N2832HHardy Truly C · Southampton, NYBuilt 1978 · S/N 532 N28366Krieg Fred W · Independence, ORBuilt 1986 · S/N S60A-430 N2836HPauda Jose Mario · Salinas, CABuilt 1978 · S/N 676 N2843HOliver James M · Jeffersonville, INBuilt 1979 · S/N 683 N2846HSparta Rotors · New York, NYBuilt 1976 · S/N 66 N2847NPost William S · Custer, WAS/N RX7-450 N2848HGroshel Joseph C · State College, PABuilt 1978 · S/N 538 N284BAAmiet Borys J · Joplin, MOBuilt 1994 · S/N 940312 N284BMSielicki Tomasz · Joliet, ILBuilt 1984 · S/N 226 N284SGWaters Christopher J · Los Altos, CABuilt 2024 · S/N 3.MD207 N2851HSmith Leonard I III · Overland Park, KSBuilt 1976 · S/N 51 N2854AHodges Eric C · Rio Rancho, NMS/N RX7-3005 N2862JTexas Tea Promotions LLC · Hutto, TXBuilt 2022 · S/N BB-004 N2863Tuohino Lawrence A · Atascadero, CABuilt 1977 · S/N 20588 N2864EBallooning Adventures Of Colorado LLC · Denver, COBuilt 1986 · S/N S60A-3015 N2866Arnold David A · Jeffersonville, INBuilt 1970 · S/N 60 N2867Marek John M · Tucson, AZS/N 33 N28724Zemlachenko Michael · Cape Canaveral, FLBuilt 1986 · S/N S60A-3017 N2876DJutras Joan C · Loxahatchee, FLBuilt 1986 · S/N S50A-3001 N287BAWood Tyler G · Orlando, FLBuilt 1996 · S/N 940314 N287ESteinkamp Thomas F · Brentwood, TNBuilt 1997 · S/N 028 N288Taylor Nathan R · Nashville, TNBuilt 1981 · S/N 20463 N2880HLeonard Glenn D · Ruidoso, NMBuilt 1976 · S/N 70 N2885XCalderini Morgan A · Colorado Springs, COS/N 2007-01-MAC N2886AEvergreen Soaring · Lynnwood, WABuilt 1978 · S/N 3098 N2888HFricke Fred J · Reno, NVS/N 88 N2888VMaedl Marcus A · San Marcos, CAS/N 32 N288VEuroaviation Inc Trustee · KematenBuilt 2007 · S/N 35E33 N2890HCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 550 N2895HSkinner John Jay · Citrus Springs, FLBuilt 1978 · S/N 95 N2898Rouw Calvin Cuin · Menifee, CABuilt 1970 · S/N 30 N289BAMit Soaring Association Inc · Sterling, MABuilt 1996 · S/N 940315 N289SIllini Glider Club · Danville, ILBuilt 1992 · S/N 03-24 N28BZGallatin Glider Club Inc · Gallatin Gateway, MTBuilt 1991 · S/N 350 N28CLSprague Jeffrey D · Lake Elsinore, CAS/N 27 N28CYZaluska Maksymin A · Garden City Park, NYBuilt 2001 · S/N 28015 N28DDSundale Soaring LLC · Erwinna, PABuilt 1965 · S/N 20 N28DGConner Walter L · Los Lunas, NMBuilt 1978 · S/N 112 N28GGWrinkle David M · Beavercreek, OHBuilt 2002 · S/N 28056 N28GYDurbin Andrew (Nmn) · Glendale, AZBuilt 2002 · S/N 28048 N28JJSchneider Paul R · Midway, UTBuilt 1998 · S/N 8212 N28LKWiesmeier Edward III · Poway, CABuilt 1977 · S/N 90 N28MMBowen Stephen T · Englewood, TNBuilt 1982 · S/N 22007 N28TBMoreland James R · Sandia Park, NMS/N 61 N28VUPhysicians Air Transport LLC · Hot Springs, ARBuilt 1980 · S/N BB-743 N28WGGeiger William D · Pittsburgh, PABuilt 2006 · S/N 220 N28YNHerrli Tod E · Marion, INBuilt 2001 · S/N 28037 N29032Montgolfier Aeronautical Holdings LLC · Helena, MTBuilt 2000 · S/N 425/156 N2903HPierre-Alban Grellet-Aumont · East Quogue, NYBuilt 1979 · S/N 686