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.

N3575GSproul Keith A · North Brunswick, NJBuilt 1989 · S/N RX7-3205 N35773Tobin Joshua Lee · Belen, NMBuilt 2002 · S/N RX8-3356 N3578NOdom David R · Gainesville, GAS/N RX8-3013 N3580LGarrett Terry S · Indianola, IABuilt 1989 · S/N RX7-3216 N3581DBrown Charles S Jr · Mount Washington, KYBuilt 1989 · S/N RX8-3023 N3581UBowie Mark · Greenwood, MSBuilt 1989 · S/N RX7-3221 N35844Krause Shawn L · Zachary, LAS/N S57A-3095 N3584GBalloonacy LLC · Fayetteville, GABuilt 1990 · S/N S57A-3094 N3586BCarter Jonathan · Honey Brook, PABuilt 1990 · S/N S57A-3096 N3588KBlow Hard Balloon LLC · Ringwood, NJBuilt 1988 · S/N S57A-3051 N358ACTikhomirov Vadim K · Acton, MABuilt 2003 · S/N 058 N358BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 998320 N358PVAerostatica Inc DBA · Ann Arbor, MIBuilt 2026 · S/N 7043 N3592CCasey Vincent J · Sparks, NVBuilt 1988 · S/N S60A-3098 N35934Hot Air Ad-Ventures Inc · Tampa, FLBuilt 1988 · S/N S66A-3029 N3595COliviann Balloons LLC · Hodgenville, KYS/N RX8-3001 N3596SShumate Kenneth W · Orlando, FLBuilt 1988 · S/N S60A-3092 N35972Simmons Barbara A · Albuquerque, NMBuilt 1989 · S/N RX8-3009 N3597CWeeks Nathan Andrew Michael · Oklahoma City, OKS/N S57A-3072 N3597LBlackburn Andrew M · University Heights, OHBuilt 1989 · S/N S57A-3073 N3597XHunter Seth A · Farmington, NMBuilt 1989 · S/N S55A-3048 N3598SKilgore Paul J · Calcium, NYBuilt 1989 · S/N RX8-3005 N3598VWiltermuth Brent · Clarissa, MNBuilt 1989 · S/N S55A-3045 N35993Wells Russell L · Seville, OHS/N SEM154 N35997Ibbotson Mark · Grand Prairie, TXS/N S57A-3076 N359BACascade Soaring Society Inc · East Wenatchee, WABuilt 1999 · S/N 990508 N359LBStandefer Wayne B · Italy, TXBuilt 1995 · S/N 270 N359LWConfetti Holdings LLC · Kalispell, MTBuilt 2025 · S/N 2444 N35ACGaddy Larry J · Lakeland, FLBuilt 1976 · S/N 63 N35AVPflasterer Thomas W · Claysville, PABuilt 1979 · S/N 35 N35AZMunnelly Evan F · Oceanside, CAFirst renewal noticeS/N 180/64 N35BDHollatz Walter M · Concord, GABuilt 1982 · S/N 253 N35KSKuehn Matthias W · Monrovia, CABuilt 1989 · S/N 24032 N35PWBetz James G · Meadowbrook, PABuilt 1995 · S/N 1703011 N35UMMars Leasing · Phoenix, AZBuilt 2025 · S/N 300/132 N35WWEichhorn Tyler L · Ramona, CAS/N 20034 N35XCMurphy Rebecca L · Elmira, NYBuilt 2020 · S/N 03-094 N36006Driscoll Denis B · New Carlisle, OHBuilt 1975 · S/N SEM-163 N3601MGear Robert L III · Paradise Valley, AZBuilt 1983 · S/N F7B-044 N3603TKershaw Carl · Mount Hope, KSBuilt 1983 · S/N F7-023 N3604QShumate Kenneth W · Orlando, FLBuilt 1989 · S/N S60A-3120 N36089Jutras Joan C · Loxahatchee, FLBuilt 1989 · S/N S60A-3123 N3608YHolland Benjamin M · Gladstone, MOS/N F7B-067 N3609KPederson Roland E · Circle, MTS/N 22299 N360BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 998701 N360BDEdling John · North Wales, PABuilt 2017 · S/N 1291 N3611GNilz Patrick Shawn · Marana, AZS/N RX8-3031 N3611TThompson Tyler J · Des Moines, IABuilt 2019 · S/N BT-01 N36133Kendallville Soaring Club Inc · Kendallville, INBuilt 1980 · S/N 563 N3613BK & L Soaring LLC · Cayuta, NYS/N 699