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.

N5637Davis Richard C · Tok, AKBuilt 1955 · S/N 103 N563KBBillson Margaret S · Albuquerque, NMBuilt 2023 · S/N 2131 N563LLEakin Sean T · Placitas, NMBuilt 2014 · S/N 008 N563SSmith Matthew T · Milford, CTBuilt 1985 · S/N 5632S N564LLovinggood Ray D · Carrboro, NCBuilt 1970 · S/N 27 N564NSGlover John H · Seattle, WABuilt 1974 · S/N 564 N5654KAir Carriage LLC · Albuquerque, NMBuilt 2002 · S/N 100 N565KBEdmiston Fred A · Maxwell, TXBuilt 2001 · S/N 6133 N565NMckerlie Charles · San Diego, CABuilt 1985 · S/N 4503 N5668Beltz Thomas G Jr · Lehighton, PABuilt 1972 · S/N 207 N5673NHannibal Robert A · Topeka, KSBuilt 1978 · S/N RX6-306 N567RMRonald J Mazzolz Inc · San Diego, CAS/N EA-282 N5681Leonard Steven E · Wichita, KSBuilt 1969 · S/N 16 N5683BSorensen Christopher · College Ward, UTS/N S57A-3117 N569CSCypress Soaring Inc · Hemet, CABuilt 1996 · S/N 04-06KP N56FLMinear Wesley J · Jonesboro, ARBuilt 2002 · S/N 58-17 N56GGAdler Billy K · Longview, TXBuilt 1990 · S/N 1843USA N56GWGromacki Ana Z · Waialua, HIBuilt 1995 · S/N 201 N56HZLavoie Michael T · West Ossipee, NHBuilt 2009 · S/N 004 N56KBWestern Horizons LLC · Hot Springs, SDBuilt 2023 · S/N 2112 N56KKEvergreen Soaring Inc · Lynnwood, WAS/N 10-11S11 N56LSSouthern Eagles Soaring Inc · Butler, GABuilt 1973 · S/N 399 N56SNMichalik Stephen A · Edmond, OKBuilt 2006 · S/N 29017 N56TFWoodbine Aviation LLC · Akron, OHS/N 560-0014 N56TXHarwell James Pat · Keithville, LABuilt 2013 · S/N 008 N56UKLuckett Graham J · Fort Collins, COBuilt 2001 · S/N 776 N56USPadelt Albert F · Barto, PABuilt 2023 · S/N HY-7 N56UTWyman Jack S · Manchester, MIBuilt 1998 · S/N 561197001 N56VNakajima N43je LLC · Beaverton, ORS/N 33153 N56XSArmstrong Scott A · Urbandale, IABuilt 2008 · S/N 5400 N56ZLSmith Cameron Mcpherson · Portland, ORBuilt 2004 · S/N 6377 N5700SPalmquist Neal D · Homer, LABuilt 1969 · S/N 396 N5701SSilent Knights Inc DBA · Ankeny, IABuilt 1967 · S/N 49 N5702SLamont Scott B · Grafton, MABuilt 1970 · S/N 380 N57030Lesmeister Michael A · Rochester, MNS/N S60A-3180 N5704SPrescott Area Soaring Inc · Prescott Valley, AZBuilt 1967 · S/N 52 N5705SCrawford Susan B · Flagstaff, AZBuilt 1967 · S/N 383 N5708SMerlin Soaring Association Inc · Amelia Court House, VABuilt 1967 · S/N 55 N5709SWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1967 · S/N 56 N5710SSt Louis Soaring Association Inc · Saint Louis, MOBuilt 1976 · S/N 381 N5711SHardin John M · Terrell, TXBuilt 1967 · S/N 57 N5712SNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1967 · S/N 58 N5715SRefugio Soaring Circle Inc · Refugio, TXBuilt 1967 · S/N 61 N5716NBauer William S · Ona, WVBuilt 1980 · S/N S55A-703 N5716SStoner Robert A Trustee · Fort Myers, FLBuilt 1967 · S/N 386 N5716YRobinson David G · Half Moon Bay, CABuilt 1980 · S/N S60A-152 N5717HAero Electric Inc · Boulder City, NVFirst renewal noticeBuilt 1980 · S/N S55A-707 N5718SAntelope Valley Soaring Club (Avsc) · Llano, CABuilt 1967 · S/N 66 N57194Nilz Patrick · Tucson, AZBuilt 1980 · S/N S66A-115 N571JJaszlics Ivan J · Golden, COBuilt 2001 · S/N 289CS