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.

N5145XAnderson Aviation LLC · Hillsboro, NDBuilt 1969 · S/N 671 N5146TMattson Randall · Richvale, CAS/N 118 N5146XChart-Airs LLC · West Terre Haute, INBuilt 1969 · S/N 672 N5147XBrown Russell J · Mahtomedi, MNBuilt 1969 · S/N 673 N5148TKloss Matthew Joseph · Rew, PABuilt 1967 · S/N 567 N5159TSvggp LLC · Carnation, WABuilt 1967 · S/N 189 N5161TStuart M Davis Inc · Rice, WABuilt 1967 · S/N 250 N5162TAdvanced Insulation Enterprises LLC · Calhoun, LABuilt 1967 · S/N 253 N5162XMcmorries Kyle Patrick · Nacogdoches, TXBuilt 1969 · S/N 691 N5164TLeonard Bruce Danield · Spokane, WABuilt 1966 · S/N 178 N5168XCulver Marc D · Anchorage, AKBuilt 1968 · S/N 616 N5169XRegistration Pending · Palmer, AKRegistration pendingBuilt 1969 · S/N 676 N5170THardison Aviation LLC · Hampton, SCBuilt 1966 · S/N 527 N5170XFitzpatrick Robert M · Fredericksburg, TXBuilt 1969 · S/N 677 N5171TGowins Steven M · Eagle, AKBuilt 1966 · S/N 563 N5172TJacksonville Aviation Group LLC · Jacksonville, FLBuilt 1966 · S/N 525 N5172XO'Daniel Mike · Elkhorn, NEBuilt 1969 · S/N 679 N5173TMorris Dennie R · North Fort Myers, FLBuilt 1966 · S/N 545 N5173XInabnit Michael S · Colville, WABuilt 1969 · S/N 680 N5174TMarnoch Kenneth S Trustee · Canyon Country, CAS/N 163 N5177TJensen Larry F · Millington, MIBuilt 1967 · S/N 219 N5177XAdams John L · Carmi, ILBuilt 1969 · S/N 683 N5179THiggs Kathleen A · Garden Plain, KSBuilt 1967 · S/N 139 N5181TSchmetter Kenneth E · Needville, TXBuilt 1967 · S/N 508 N5187XBerkeland Jacob J · Bricelyn, MNBuilt 1969 · S/N 685 N5188XMullahy Patrick O · Burlington, IABuilt 1969 · S/N 686 N5189TZerck Joseph W · Anchorage, AKBuilt 1967 · S/N 199 N5190XGawf Mike · Springdale, ARBuilt 1969 · S/N 690 N5191TLeonard Jon F · Glenn, CAS/N 300 N5195TRainbow Flying Service LLC · Moses Lake, WAS/N 344 N5199TOwens Roger A · San Antonio, TXBuilt 1967 · S/N 211 N5219XBlack Mark A · Lawsonville, NCBuilt 1969 · S/N 695 N5234XZonneveld Case M · Hanford, CABuilt 1969 · S/N 684 N5235XOrtu Gerard · East Hanover, NJBuilt 1969 · S/N 698 N5238Teague Keith S · East Jordan, MIS/N 701 N5240XPaulson Ricky R · Hudson, WIBuilt 1969 · S/N 703 N5254XDahl Kevin A · Fargo, NDBuilt 1969 · S/N 704 N5261XPetri Howard R · Vincennes, INBuilt 1969 · S/N 712 N555BJGypsy Aviation LLC · Newnan, GAS/N 182 N55AMAdams Floyd R · Sebring, FLBuilt 1966 · S/N 362 N592RJWood Roger E · Waxhaw, NCBuilt 1969 · S/N 702 N596JRWilliams David J · San Francisco, CAS/N 1359-96 N6096FColeman Gregory M · Chewelah, WABuilt 1966 · S/N 7ECA-352 N61JGMac Air Inc · Farmington, MOBuilt 1966 · S/N 220 N62985Alexander Aviation LLC · Brighton, COS/N 369 N6305NPerera Nandana L · Logan, OHBuilt 1967 · S/N 207 N6306NSmith Michael J · Chebanse, ILBuilt 1967 · S/N 228 N6308NJ Squared Enterprises Corp · Hendersonville, TNBuilt 1967 · S/N 194 N6309NJohnson Darrick C · Wolford, NDBuilt 1967 · S/N 233 N6310NHumbert Jeff M · Cottonwood, CABuilt 1967 · S/N 463

Back to Champion 7ECA