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.

N52935Stewart Karen · Sinclair, MEBuilt 2001 · S/N RX8-3346 N52943Van Dyck Chris · Albuquerque, NMBuilt 2001 · S/N RX8-3348 N52948Keller Environment Co Inc · Columbus, OHS/N S60A-3276 N5294JDakota Balloons LLC · Hot Springs, SDBuilt 2001 · S/N S53A-3084 N5294QSkyline Hot Air Balloons LLC · Fishers, INBuilt 2001 · S/N RX8-3347 N5294VIrwin Patrick S · Lovelock, NVBuilt 2001 · S/N RXS8-3106 N52965Dreams Aloft · Rochester, MNBuilt 2001 · S/N S57A-3230 N5296LLight Flight Balloons Inc · Bel Air, MDBuilt 2001 · S/N RXS8-3107 N52972Registered aircraftBuilt 2001 · S/N RXS8-3108 N5297VBullock John W · Wausau, WIBuilt 2001 · S/N S51A-3018 N52984Maughan Stephanie · Wentzville, MOBuilt 2025 · S/N B5-65-002 N5299JOlin Michael A · Warner, NHBuilt 2001 · S/N RX8-3350 N5299PCastellion Susan C · Winter Park, COBuilt 2001 · S/N S81A-3012 N529JNNelson Lawrence W · Guilford, CTBuilt 2011 · S/N 2011-54K-1 N529PWCentral Ms Soaring Society LLC · Brandon, MSS/N 1706002 N52ABMead Colin E · Jacksonville Beach, FLBuilt 1980 · S/N 4006 N52ASCascade Soaring Society · East Wenatchee, WABuilt 1977 · S/N 027056 N52BWNeilson William Andrew · Louisa, VABuilt 1977 · S/N 3198 N52FPurves Keith C · Renton, WABuilt 1973 · S/N 17020 N52HPHeritage Aviation Management LLC · Headland, ALBuilt 1967 · S/N R1720079 N52LBWhiteside Samuel L · Minden, NVS/N 13 N52WHOliva Raul C · Hotchkiss, COS/N F8B-459 N5300FCatron Robert M · Shelbyville, TNBuilt 1997 · S/N 6130 N5300JClark Brian Andrew · Lexington, OKBuilt 2000 · S/N 6131 N5300XCarter Country Flights LLC · Honey Brook, PAS/N 6139 N5303CGunderson John H · Irene, SDFirst renewal noticeBuilt 2001 · S/N RX3349 N5303HMcclenahan Andromeda B · Rio Rancho, NMBuilt 1998 · S/N 6168 N5303ZRichards Ursula J · Albuquerque, NMBuilt 1997 · S/N 6151 N5304XLiberti Daniel J · Rio Rancho, NMBuilt 1998 · S/N 6170 N5305EEdmiston Fred A · Maxwell, TXBuilt 1997 · S/N 6125 N5305MEwer Daniel W · Tucson, AZBuilt 2001 · S/N S57A-3232 N5305YLewis John R · Leakey, TXBuilt 2002 · S/N S71A-3024 N5306THjorth Garret P · Spanish Fork, UTS/N RXS8-3110 N5307KGrauberger Sheldon D · Minden, NVBuilt 1997 · S/N 6135 N5307YBrunner Lindsay A · Phoenix, AZS/N 6174 N53081Mcdevitt Daniel B · Galway, NYBuilt 2002 · S/N RX7-3344 N5308CCelentano Michael J · Allen, TXBuilt 1997 · S/N 6119 N5308NKramer David · Fort Edward, NYBuilt 2001 · S/N RX7-3343 N5308UAirtime Equipment LLC · Mesa, AZBuilt 1998 · S/N 6171 N5308XMidwest Ballooning Adventures Inc · Chicago, ILBuilt 1998 · S/N 6172 N5309UBuzzards Glory Balloon Co LLC · Cedar Rapids, IABuilt 1998 · S/N 6175 N5309WNiemi Matthew · Carson City, MIBuilt 1997 · S/N 6126 N5309YStodolski Mark D · Sterling, MABuilt 2001 · S/N 6178 N530BYCalifornia Balloon Repair · Dixon, CABuilt 2023 · S/N 6989 N530DMBorders Nowell · Edinburg, TXS/N 421B0839 N5310UKomadina Steven A · Corrales, NMBuilt 1998 · S/N 6181 N5312EBalloons Of Vermont LLC · Quechee, VTBuilt 2002 · S/N S71A-3025 N5312XAirtime Equipment LLC · Mesa, AZBuilt 1998 · S/N 6186 N53138Rushkarski Dawne Renae · Monroe, WABuilt 2002 · S/N S53A-3086 N53145D C G & Assoc Inc · Rio Rancho, NMBuilt 2002 · S/N S60S-3006