Skip to content

Registered aircraft · 55

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 ('21101PC')
  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 ('21101PC')
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.

N144BCThomas George E · Rice, WAS/N 188 N223HWChesnut Tara M · Wasilla, AKBuilt 1960 · S/N 12 N2423Dinstel Daniel A · Alzada, MTBuilt 1960 · S/N 7GCB-55 N432TEEmmons Thomas M · Millington, MIS/N 85 N510RJSpring Mountain Aviation LLC · San Francisco, CAS/N 1310-2001 N6231LDelong Thomas S · Fairbanks, AKS/N 146 N67ZVAircraft Partner Holdings Inc Trustee · BerlinS/N 100 N7158PJinnette James · Raleigh, NCBuilt 1963 · S/N 175 N7432PWeber William A · Brodhead, WIS/N 25 N808BWWeber William A · Brodhead, WIBuilt 1962 · S/N 7GCB-147 N8977RCozine Mark R · Cherokee, IABuilt 1960 · S/N 7KC-1 N8978RRoth Robin A · Wray, COBuilt 1960 · S/N 7GCB-11 N8979RSeeley Lenard D · Osage, WYBuilt 1960 · S/N 13 N8980RHolmes Aviation Inc · Cannon Falls, MNBuilt 1960 · S/N 7GCB-14 N8981RBlock Raymond J · Palmer, AKS/N 7GCB-10 N8986RYarbanton John Robert · Muskegon, MIBuilt 1960 · S/N 7GCB-16 N8993RMiller Scott A · Piney Flats, TNBuilt 1960 · S/N 7GCB-22 N8994RT & H Aviation LLC · Rector, ARS/N 45 N8999RDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1960 · S/N 7GCB-35 N9129SAugust Aero LLC · Kalispell, MTS/N 7GCB-36 N912CPHoppe Gregory M · Big Lake, AKS/N 165 N920CJJones Alva L · Craig, COBuilt 1960 · S/N 56 N9803YHubbard Nathan · Butte, MTS/N 38 N9810YArmstrong Bruce · Port Orchard, WABuilt 1960 · S/N 7GCB-47 N9827YRegistration Pending · Sweet Home, ORRegistration pending, pending cancellationBuilt 1960 · S/N 50 N9865YCloose Brian D · Carlton, MNBuilt 1960 · S/N 7GCB-63 N9866YMummey Gary E · Stockport, OHBuilt 1960 · S/N 64 N9867YPeterson Eric S · North Logan, UTS/N 65 N9880YMerrick Shane · Redgranite, WIBuilt 1961 · S/N 7GCB-73 N9884YRoberts Colton C · Bluebell, UTS/N 7GCB-119 N9885YCentral Air Parts Inc · Staunton, ILS/N 145 N9892YWraith Daniel T · Wasilla, AKBuilt 1961 · S/N 7GCB-77 N9896YFrisby James A · Palmer, AKS/N 7GCB-95 N9897YCline Braxton L · Wasilla, AKBuilt 1962 · S/N 7GCB-117 N9899YOld Style Aircraft LLC · Ellsinore, MOBuilt 1962 · S/N 7GCB-139 N9902YJeepers LLC · New York, NYBuilt 1961 · S/N 8 N9906YMac · Wichita, KSBuilt 1961 · S/N 7GCB-74 N9907YIngle Stephen D · Bainbridge, OHBuilt 1961 · S/N 94 N9911YTyrrell Luke L · Fairbanks, AKS/N 120 N9914YKnapper Jack A · Hibbing, MNBuilt 1961 · S/N 7GCB-112 N9925YDaniel Hull R · Wasilla, AKS/N 98 N9926YMorgan Kenneth K · Norridgewock, MEBuilt 1961 · S/N 7GCB-116 N9937YWoods Justin S · West Glacier, MTS/N 7GCB-129 N9938YSchneider Bros · Manning, NDBuilt 1962 · S/N 7GCB-124 N9939YGehrke Walter L · Willow Lake, SDBuilt 1962 · S/N 7GCB-140 N9940YPiercy Ronald S · Moses Lake, WAS/N 7GCB-136 N9942YHardy John R · Wasilla, AKBuilt 1962 · S/N 150 N9943YDehlin James M · Roscommon, MIBuilt 1962 · S/N 143 N9950YAnders Rod D · Wasta, SDS/N 7GCB-156 N9953YBlock Larry F · Palmer, AKS/N 7GCB-157

Back to Champion 7GCB