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.

N8651RSmith Ted · Grant Park, ILBuilt 1962 · S/N 151 N8653RFueston Vernon A · Montague, CABuilt 1962 · S/N 189 N8654RWhiting Stephen Dow · Poway, CABuilt 1962 · S/N 191 N8656RStewarts Aircraft Service · Waynesville, OHBuilt 1963 · S/N 152 N8657RRainbow Flying Service LLC · Moses Lake, WABuilt 1963 · S/N 193 N8660RSteen Jack E · Hickory Corners, MIFirst renewal noticeBuilt 1962 · S/N 166 N8662RDavenport John P · Redmond, WABuilt 1962 · S/N 190 N8663RShaw Charles W · Hobbs, NMBuilt 1962 · S/N 196 N8664APost Stamp Automotive LLC · Coopersburg, PAFirst renewal noticeBuilt 2019 · S/N 271 N86660Tulsa Skyhawks Inc · Tulsa, OKBuilt 1972 · S/N 025422 N8667AForthun Daniel Jay · Argyle, TXS/N D2129 N8667RTulsa Skyhawks Soaring Club · Tulsa, OKFirst renewal noticeBuilt 1963 · S/N 63 N866EAFm Marketing LLC · Los Ranchos, NMBuilt 2019 · S/N 260 N866RAAz Air Ventures LLC · Safford, AZBuilt 2019 · S/N 264 N866WAZimmer Rachel A · Rio Rancho, NMBuilt 2021 · S/N 265 N866YAWix Shawn A · Seaford, DEBuilt 2019 · S/N 270 N8670RWilkinson Ephriam B · Eads, TNBuilt 1963 · S/N 198 N8676RFirebird Aviation LLC · Amelia Court House, VAS/N 204 N8677RNiagara Soaring Club Inc · Williamsville, NYBuilt 1963 · S/N 211 N8679RMaglaughlin Ronald D · Udall, KSFirst renewal noticeBuilt 1963 · S/N 162 N867DHenderson Colin D · Norman, OKBuilt 1972 · S/N 13369 N867DKAeroink Inc · Tempe, AZBuilt 2005 · S/N 6430 N867FACampbell Brittany Rose · Los Lunas, NMBuilt 2019 · S/N 272 N867HAMabee Bryant J · Apalachin, NYBuilt 2019 · S/N 273 N867JAJones Cameron D · Statesboro, GABuilt 2021 · S/N 274 N867QAGilson Diana L · Rio Rancho, NMBuilt 2019 · S/N 263 N867RABalloons Over Bloomington LLC · Bloomington, INBuilt 2021 · S/N 266 N8680TD2w Enterprise LLC · Miami Lakes, FLS/N 52580 N8681HHughes Stephanie · Spokane, WAS/N 2021LTA N8682RTcoag2 LLC · Tower Lakes, ILBuilt 1963 · S/N 212 N8683RDaye Jeffrey E · Salisbury, NCBuilt 1963 · S/N 214 N8686RChautauqua Soaring Society · Mayville, NYBuilt 1963 · S/N 166 N8687RDennis Polen Aviation Educational Foundation · Granbury, TXS/N 157 N8688RDickson Garry A · Spring Valley, CABuilt 1966 · S/N 209 N868XGGordon Edward G · Austin, TXBuilt 2020 · S/N 5723 N8690RTruly Zane F · Sherman, TXBuilt 1963 · S/N 215 N8692RHartenstine Michael C · Lancaster, CABuilt 1963 · S/N 210 N8693RGehrlein Rodney L · Waterford, PABuilt 1963 · S/N 213 N8694King John D · Midland, VAFirst renewal noticeBuilt 1972 · S/N SEM60 N8694RCondon Anthony Brian II · Wichita, KSBuilt 1963 · S/N 167 N869RSMagee Aviation Services LLC · Rochester, NYBuilt 2019 · S/N 002 N86BGAndrews Ashleigh G · Troy, TXBuilt 1997 · S/N 238CS N86CRBender John L · N Richlnd Hls, TXBuilt 1962 · S/N 6015 N86DGCharlton Arthur R · Marstons Mills, MABuilt 1980 · S/N E-47 G-26 N86GSNevels Steven D · Merritt Island, FLBuilt 1980 · S/N B-1045 N86GTLudlow David J · Toledo, OHS/N F7-276 N86JMOdonnell John C · Marietta, GABuilt 1973 · S/N 445 N86NTBaxter David J · Newport, NHBuilt 2000 · S/N 41039 N86XCAlmond Jonathan D Trustee · San Diego, CABuilt 2001 · S/N 124 N86YRQuantum Mechanics Inc · Miami, FLBuilt 2006 · S/N 023