Skip to content

Registered aircraft · 7,857

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.

N32AMoreland James R · Sandia Park, NMBuilt 1980 · S/N 225 N32ARMcewen William Garrett · Glens Falls, NYBuilt 1985 · S/N 3E112 N32ASWings Over The Rockies Air And Space Museum · Denver, COBuilt 1978 · S/N B-860 N32AXShipley Michael D · Gilbertsville, PABuilt 2021 · S/N 201 N32BNGravance John R Jr · Llano, CABuilt 1982 · S/N 32 N32CJFolks Michael A · Long Beach, CABuilt 1978 · S/N W-858 N32EZShelby Rick · Montague, CABuilt 1977 · S/N 72 N32FSFronius Douglas L · Poway, CABuilt 1981 · S/N 20471 N32JKSamson Philip C · Nashville, TNS/N 3102 N32LDDinkel Danny · Beloit, KSBuilt 2001 · S/N 057 N32PWGoranson Edwin H III · Durango, COBuilt 1995 · S/N 17.03.023 N32UMNorthern Light Balloon Expeditions Inc · Sedona, AZBuilt 2025 · S/N 300/127 N32USPadelt Joan M · Barto, PABuilt 1997 · S/N 1295596 N32WGLyman Bridget C · Los Alamos, NMBuilt 1910 · S/N F7-131 N32ZXJonard Alex F · Sycamore, ILBuilt 2015 · S/N 2ZX N3302LBryant Thomas A · Tallahassee, FLBuilt 1993 · S/N 930102 N33034Raymond Eric S · Ramona, CAFirst renewal noticeS/N 1 N3304TBird Brian A · Hutchinson, KSBuilt 1965 · S/N 13 N330BAFriends Aviation Inc · Wilmington, DEBuilt 1998 · S/N 980420 N330BBDailey Patrick · Bardstown, KYBuilt 2016 · S/N 002 N330CCWilkinson Steven · Lake Havasu City, AZBuilt 2021 · S/N 6910 N330CUHeavin Howard Gary · Gatesville, TXS/N 5398 N330SVVesely Scott · Frisco, TXBuilt 2022 · S/N BB-001 N331LVVegas Balloon Rides (2021) LLC · Las Vegas, NVBuilt 2018 · S/N 300/81 N331YMClark Raymond C · Rapid City, SDBuilt 2001 · S/N 012 N3337TDakota Diamond Star LLC · Fargo, NDBuilt 2020 · S/N 484 N333ABGlobal Media Box · Albuquerque, NMS/N 6699 N333ATPitts Carl A · Salt Lake City, UTBuilt 1978 · S/N 20102 N333EKDieringer Nathan W · Menasha, WIBuilt 2022 · S/N 051 N333RBRegistration Pending · Fort Wayne, INRegistration pending, pending cancellationBuilt 2025 · S/N 7028 N333RGHarden Jesse R · Colorado Springs, COBuilt 2003 · S/N 001 N333UMason Steven K · Rolla, MOBuilt 1974 · S/N 528 N333UFRote Shannon R · Doylestown, OHS/N 172 N333USHutnick Michael C Jr · Bloomsburg, PABuilt 1977 · S/N 19160 N333VVBoyce John D · San Jose, CABuilt 1979 · S/N 1895 N33519Steen Jack E · Hickory Corners, MIBuilt 1946 · S/N 6 N3358GProkes William J · Tempe, AZBuilt 1960 · S/N 64-565 N335DBTrue North Balloon Co LLC · Paso Robles, CAS/N 6722 N335RRRed Rock Balloons · Cornville, AZBuilt 2025 · S/N 7020 N335SEConnelly William E · Omaha, NEBuilt 1968 · S/N 4229 N336Pfeiffer Neal J · Wichita, KSBuilt 1957 · S/N 23 N33609Weyl Jonathan V · Royal Palm Beach, FLBuilt 1973 · S/N 399 N33871Ellingson Leslie B · Harwood, NDBuilt 1974 · S/N 614 N33873North Carolina Soaring Association · Zebulon, NCBuilt 1974 · S/N 615 N33874Harris Hill Soaring Corp · Horseheads, NYBuilt 1974 · S/N 616 N33876Luogameno Matthew P · Boonton, NJBuilt 1974 · S/N 617 N33880Poole William L Jr · Sandy Valley, NVBuilt 1974 · S/N 620 N33889Leroy Philippe G · Willcox, AZBuilt 1974 · S/N 622 N33898Wurtsboro Airport Foundation Inc · Wurtsboro, NYBuilt 1975 · S/N 628 N338KPThompson Richard I · Evans City, PAS/N 20092