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.

N9862EStanton Sport Aviation Inc · Stanton, MNBuilt 1965 · S/N 26 N9863HFrost R Edward · Winchester, ILS/N 18268079 N9864EBrown Resources And Research LLC · North Las Vegas, NVBuilt 1965 · S/N 27 N9867EDoll John M · Austin, TXBuilt 1967 · S/N 303 N9867PTree Top Flyer Ballooning LLC · Cleveland, NCBuilt 2019 · S/N F8-2038 N986JFWindley Lance E · Jacksonville, FLBuilt 1984 · S/N 4437 N986KBDelmarva Balloon Rides LLC · Chester, MDBuilt 2026 · S/N 2605 N986PWFriends Aviation Inc · Wilmington, DEBuilt 1997 · S/N 17.09.005 N987DMBoerner Raul Trustee · Aurora, COBuilt 1989 · S/N 6190 N987HAGoodman Seth A · Lincoln, ILBuilt 2017 · S/N 5648 N987RBVon Drashek Bruce P · Prior Lake, MNBuilt 1982 · S/N 4196 N9882White Shannon N · Loveland, COBuilt 2019 · S/N 1561 N988KMTrujillo Mark A · Corvallis, ORBuilt 2009 · S/N F8B-2110 N98987Civil Air Patrol Inc · Maxwell Afb, ALS/N 17276391 N989JEAz Air Ventures LLC · Safford, AZBuilt 2004 · S/N 6394 N98AEGalliano Mario E · Yreka, CABuilt 2005 · S/N 166 N98CCBogard Charles E · Payette, IDBuilt 1969 · S/N 88 N98KKWhitcomb Matthew J · Roanoke, VABuilt 1925 · S/N 027155 N98LBBreeze Air LLC · Henderson, TXBuilt 1998 · S/N 5076 N98PNDoyle Brian G · Windsor, MABuilt 1975 · S/N 1859 N98PSSchuessler Scott · Stillwater, OKBuilt 1977 · S/N D-9996 N98SBVandyke Mark A · Romulus, NYBuilt 1973 · S/N 312 N98WXKovari Peter D · Simi Valley, CABuilt 1984 · S/N 3E13 N98ZSMartinez Lawrence · Rio Rancho, NMBuilt 1999 · S/N 6189 N9903JRaven Nw Llp · Acme, PABuilt 1965 · S/N 237 N9904JKuydendall David E · Roland, IABuilt 1965 · S/N 239 N9905JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1965 · S/N 240 N990BRAdvertising Balloon Company Inc · Las Vegas, NVBuilt 2011 · S/N 425/52 N990CWHandcrafted Furniture Balloon Rides LLC · Lake Tomahawk, WIBuilt 2025 · S/N MAB2025001 N990EFBerka Joel M · Binghamton, NYBuilt 2014 · S/N EF-2014-1 N990RKKidd Robert L · Logan, UTBuilt 1972 · S/N 152 N990SGGerbus Daniel John Jr · Lewisville, NCBuilt 2021 · S/N 5739 N990WBBristol David W · Sautee, GABuilt 2016 · S/N 450 N990YSSmith Edward R · Pueblo, COBuilt 2013 · S/N 151 N9910JMurray James P · Virginia Beach, VABuilt 1966 · S/N 335 N9912JAutomotive Marine Specialists Inc · Fitchburg, MABuilt 1966 · S/N 31 N99167Cascade Soaring Society Inc · East Wenatchee, WABuilt 1976 · S/N 43 N9916JRouch Michael D · Moseley, VABuilt 1966 · S/N 35 N9918JMueller Douglas G · Boulder City, NVBuilt 1966 · S/N 246 N9919Phelps Thomas L · Raleigh, NCBuilt 1969 · S/N 4 N9919JCollins James C Jr · Whitehouse Station, NJBuilt 1966 · S/N 247 N991FAAnderson Van F · Morgantown, WVBuilt 1995 · S/N 5990 N991GRWix Shawn A · Seaford, DEBuilt 2023 · S/N 90/216 N9922JProodian Kevin J · Wellington, FLS/N 341 N9924JHood River Soaring · Hood River, ORBuilt 1966 · S/N 343 N9926JAbel William F · Billings, MTBuilt 1966 · S/N 345 N9929J29 Juliet LLC · Longmont, COS/N 38 N992CCAerial Sign Co · Melbourne, FLS/N 5-992 N992RZKbdu Gliders LLC · Denver, COBuilt 2003 · S/N 152 N99361Kaounas Kostas T · Brookings, SDBuilt 1976 · S/N 1282