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.

N72214Island Balloons Inc · Lanexa, VABuilt 1998 · S/N F8B-563 N72277Rauch Seth J · Wamsutter, WYBuilt 1999 · S/N F8428 N7227SGrube Jay C · Decatur, INBuilt 1998 · S/N F8B-565 N722BKPhillip C Umphres · Dallas, TXBuilt 2002 · S/N 17 N72312Neumann Ulrich · Simpsonville, SCBuilt 1975 · S/N 228 N7232TZirnheld Peter M · Chamblee, GABuilt 2000 · S/N F8B-602 N72348Lewis John R · Leakey, TXBuilt 2000 · S/N F10-031 N7234TIsland Balloons Inc · Lanexa, VABuilt 1999 · S/N F8B-584 N72358Pfeiffer Neal J · Wichita, KSBuilt 1957 · S/N 337 N7236GHeagerty Derek S · Tres Piedras, NMS/N F8B-572 N7240PHouseknecht Thomas J · State College, PABuilt 1969 · S/N 15022 N724DCLiberti Christopher M · Castle Rock, COBuilt 2017 · S/N 457 N724LBStrine Steven · Ashland, OHS/N 5024 N724WBKansas City Aeroports · Overland Park, KSBuilt 2024 · S/N 7012 N72503Island Balloons Inc · Lanexa, VAS/N F8B-591 N72509Austin Aeronauts Inc · Austin, TXFirst renewal noticeBuilt 2017 · S/N 001-42 N7252EOflynn Chris M · Woodland, WABuilt 2001 · S/N F7-1102 N7252HEvans Timothy A · Cedar Crest, NMBuilt 2001 · S/N F7-1103 N7252VVanwye Kenneth Edward · Albuquerque, NMBuilt 2001 · S/N F8B-618 N7252WWilson Dale R II · Augusta, MIBuilt 1999 · S/N F7-1067 N7253HCalm Sky Adventures LLC · Omro, WIBuilt 1999 · S/N F7-1073 N7253KKansas City Aerosports Inc · Overland Park, KSBuilt 2000 · S/N F7-1094 N7253MMahoney Kade J · Eaton, COBuilt 1999 · S/N F7-1076 N72546Salgueiro Cristian · Las Cruces, NMBuilt 2000 · S/N F7-1088 N725CWLite Haus Ballooning LLC · Ridge Spring, SCBuilt 2007 · S/N 5348 N725RWGalante Holdings LLC · Altamont, ILS/N 31-7952187 N726GSIsley Todd · Carlisle, IABuilt 2020 · S/N 5692 N726MCOkeson Trent J · Spring, TXBuilt 1973 · S/N 289G N726PASproul Keith A · North Brunswick, NJBuilt 2016 · S/N 209 N726TCPaulin Jerry · Yuma, AZBuilt 1993 · S/N 2495USA N72716Gray Phillip W · Indianola, IAS/N 1201 N72718Mcfadden Joseph M · Rio Rancho, NMFirst renewal noticeBuilt 1989 · S/N 55121 N72785Albritton Clifford H · Fort Worth, TXBuilt 1985 · S/N E184-G150 N727AMLikos William E · Warner Robins, GABuilt 1979 · S/N 20273 N727FSBaldwin Roger · Bosque Farms, NMBuilt 2004 · S/N GF-0306 N727GFBaldwin Roger · Bosque Farms, NMBuilt 2005 · S/N GF-0510 N727JLBriceno M Alonso J · Boynton Beach, FLBuilt 1968 · S/N 6639 N727RAAndrew Ross · Woods Cross, UTBuilt 1970 · S/N 159 N72866Castellion Jack A · Winter Park, COBuilt 2019 · S/N 1564 N7297BConfetti Balloons LLC · Washington, UTBuilt 2023 · S/N 2133 N729MDMiddleline Aviation Inc · Ballston Spa, NYBuilt 2002 · S/N 27197 N72AJDunlap Martin L · Hartville, OHBuilt 1977 · S/N 22 N72ASBeskow Charles R · Navasota, TXBuilt 1977 · S/N B-810 N72DGGradwell Dean H · Jacksonville, ORBuilt 1975 · S/N 7201 N72EJLakeland Aero Club Inc · Lakeland, FLBuilt 1979 · S/N 3253-T-30 N72EMLavalle Miguel A · Pflugerville, TXBuilt 2002 · S/N 27193 N72KXSproul Keith A · North Brunswick, NJBuilt 2004 · S/N S-003 N72LBSheehy Danielle · Topeka, KSBuilt 2013 · S/N 5537 N72ZZRavanfar Kia N · Redondo Beach, CABuilt 1972 · S/N 221 N730DHodgins Gregory W · Tucson, AZBuilt 1943 · S/N 139