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.

N194PBauman Jennifer · Tehachapi, CABuilt 1971 · S/N 217 N1951Knerr Joshua D · Tehachapi, CAS/N 168 N1958SVandelhoef Edward L DBA · Broomfield, COBuilt 2021 · S/N 210/149 N195FWMoab Ballooning LLC · Moab, UTBuilt 2011 · S/N 858 N195MHRomano James J · San Antonio, TXBuilt 2007 · S/N 2023K N1965RJohns Robert · Fredonia, WIBuilt 1972 · S/N S50A-178 N1967RHerman Kevin E · York, PAS/N S50A-182 N1969RGunter Ryan S · Albuquerque, NMBuilt 2021 · S/N 5736 N196BANewberg Edgar T · Hector, MNBuilt 1981 · S/N 196 N196HSale Reported · AlbertaSale reportedBuilt 1977 · S/N 19139 N196JPrenovost Jon Michael · Wichita, KSBuilt 1967 · S/N 766 N196PLMidwestern Soaring Assoc · Peculiar, MOBuilt 1964 · S/N 6282 N196RWEzell Jeffrey P · Annapolis, MDBuilt 1996 · S/N 043 N1972FFiesta Club II LLC · Albuquerque, NMBuilt 2021 · S/N 6947 N1973CRed Wing Soaring Association · Osceola, WIBuilt 1973 · S/N 025725 N1974CRed Wing Soaring Association · Osceola, WIBuilt 1974 · S/N 026032 N1974NNelson Gregory C · Minden, NVBuilt 2020 · S/N 6901 N1975SSines Keith L · Keyser, WVBuilt 1975 · S/N 20033 N1975VVande Hoef Edward L DBA · Broomfield, COBuilt 2012 · S/N 180/107 N1977Dilibero Barry B · Chester Springs, PABuilt 2003 · S/N FMB-200274 N197HBKhan Asad U · Austin, TXBuilt 1997 · S/N 1707008 N197PWLouisville Soaring Club Inc · Lexington, KYBuilt 1997 · S/N 1709004 N1983RRainbow Ryders Inc · Albuquerque, NMBuilt 2022 · S/N 6964 N1985DGunby Robert W · Stapleton, GABuilt 1985 · S/N 120 N1985HDeadhead Cadillac Ltd · Centennial, COBuilt 2024 · S/N 2349 N1985NYates Brian D · Perkasie, PAS/N 121 N1985SJohnson Allen H · Shakopee, MNBuilt 1985 · S/N 111 N1985TStinson Roy A · Louisville, KYBuilt 1985 · S/N 115 N1989PMorning Star Visions Inc · Smoketown, PAS/N 5260 N198MSCb Equipment Inc · Pell City, ALS/N 61P08038063414 N1990KHerbst John H · Lexington, KYBuilt 1987 · S/N 5267 N1991CCliver Harold L Jr DBA · Lewisville, TXBuilt 2026 · S/N 60/11 N1991GEakin Sean T · Placitas, NMS/N 5272 N1991TRoss David H · Kansasville, WIBuilt 1987 · S/N 5278 N19927Dilibero Barry B · Chester Springs, PABuilt 1987 · S/N 5289 N1992FFritton Jennifer E · Gasport, NYBuilt 2016 · S/N 6797 N1993ABuchar Zdenek · Chattanooga, TNBuilt 1993 · S/N B-2072 N1993JCato Josh · Paris, TXBuilt 2025 · S/N 2544 N1993PSierra Valley Balloons · Thousand Oaks, CABuilt 1987 · S/N 5293 N1995JHustler James E · Minden, NVBuilt 2025 · S/N 2540 N19964May David W · Danville, KYBuilt 1987 · S/N 5325 N1996BChapman Edward J · Jordan, MNBuilt 1996 · S/N 5313 N1997WGlen Michael J · Mesa, AZBuilt 1987 · S/N 5321 N19990Shaffer Keith B · Carmel, INBuilt 1991 · S/N 5351 N19993Opat Randall J · Port Saint Lucie, FLBuilt 1941 · S/N 129 N199ASKinnaman Christopher E · Edgewood, NMBuilt 2002 · S/N 6K2 N199ATTrzpis Pawel · Pittstown, NJBuilt 1967 · S/N 773 N199RCMudd Robert · Albuquerque, NMBuilt 1999 · S/N 2009 N19AR19ar Flight LLC · Concord, NHBuilt 2019 · S/N 105/233 N19BEVan De Velde Thomas E · Brookline, MAS/N 27