Skip to content

Registered aircraft · 420

Aircraft of this model 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 aircraft_model_code IN ('21101NN')
  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 aircraft_model_code IN ('21101NN')
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.

N9090LBascue Brandon D · Ward, ARFirst renewal noticeS/N 227-70 N9091LAmelia Reid Aviation LLC · San Jose, CABuilt 1970 · S/N 784-70 N9092LYoung Vernon P · Metter, GAS/N 785-70 N9097LHoover Mark B · Wasilla, AKBuilt 1970 · S/N 789-71 N9098LDavenport Ross K · Raleigh, NCS/N 794-71 N9106LShipman Jesse L · Honey Grove, TXBuilt 1970 · S/N 795-71 N9107LJ P Aero Holdings Inc · Carson City, NVS/N 796-71 N9115LSavonen Stephen D · Ukiah, CABuilt 1970 · S/N 797-71 N9120LHarper Kevin J · Valley Center, KSBuilt 1970 · S/N 799-71 N9123LAppold Dave J · Bay City, MIBuilt 1970 · S/N 804-71 N9130LJohnsen David E · Oklahoma City, OKBuilt 1970 · S/N 805-71 N9131LAeronautical Technical Service Inc · Collierville, TNS/N 806-71 N9140LPretorius Ellen T · Smithville, OHBuilt 1971 · S/N 807-71 N9141LAmerican Airpower Heritage Flying Museum · Dallas, TXS/N 808-71 N9152LBaker Glen M · El Reno, OKBuilt 1971 · S/N 810-71 N91FTLegassey Matthew G · Millinocket, MEBuilt 1966 · S/N 107 N927WTHaugen Delos L · Burlington, NDBuilt 1966 · S/N 438 N939ABTractorboyflys LLC · Sugar Land, TXBuilt 1998 · S/N 1369-98 N94SAInternational Air Services Inc Trustee · Carson City, NVS/N 227 N9501SLarue Guy D · Tulalip, WAS/N 7ECA-240 N9502SWatson Troy L · Midlothian, TXBuilt 1965 · S/N 7ECA-243 N9507SKoppie Gary J · Emmetsburg, IABuilt 1965 · S/N 7ECA-254 N9509SChambers David R · Centre, ALS/N 259 N9510SStory Brian J · Noblesville, INS/N 7ECA-275 N9519SKs Flying Club Inc · Manhattan, KSBuilt 1965 · S/N 7ECA-257 N9522TVeillon Joseph B · Alexandria, LAS/N 555 N9523SHogan Edison D · Macon, ILBuilt 1965 · S/N 95 N9531SUpland Amy L · Miami Springs, FLBuilt 1966 · S/N 349 N9534SBall Ronald C · Colby, KSBuilt 1965 · S/N 297 N9538SClark William · Easton, MOBuilt 1965 · S/N 304 N9539SFox Norman A · Maryville, TNBuilt 1965 · S/N 305 N9540SNeufeld Maria · Seminole, TXBuilt 1965 · S/N 258 N9543STherkelsen Robert D · Burlington, WABuilt 1965 · S/N 271 N9549SZippy Airways LLC · Columbus, OHBuilt 1965 · S/N 7ECA363 N9551SBerberich John E · Wasilla, AKS/N 364 N9555SMcquillin Duane C · Palmer, AKBuilt 1965 · S/N 370 N9562SVon Bevern Brian J · Overland Park, KSBuilt 1966 · S/N 84 N9563SMumm Paul D · Geneva, NEBuilt 1965 · S/N 337 N9564SRegistration Pending · Taylorsville, KYRegistration pendingBuilt 1965 · S/N 7ECA-62 N9565SLittle Lambert W · Hamilton, TXFirst renewal noticeS/N 373 N9571SShetterly Maxine M · Livingston, TXBuilt 1965 · S/N 7ECA-379 N9577SConner Harvey E · Coahoma, TXS/N 368 N9578SSlone Donald L · Holden, MOS/N 320 N9580SSkyvault Holdings LLC · Saint Petersburg, FLBuilt 1965 · S/N 30 N9581SKing John D · Midland, VABuilt 1966 · S/N 192 N9584SWalker James M Jr · Springfield, KYBuilt 1965 · S/N 334 N9593SStoffer Aviation LLC · Marion, INS/N 35 N9610SLake A Randy · San Diego, CABuilt 1966 · S/N 265 N9617SAnderson David R · Hastings, MNBuilt 1966 · S/N 366 N9618SBradley Christopher · Juneau, AKBuilt 1965 · S/N 385

Back to Champion 7ECA