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.

N2508FBailey Joseph H · Port Saint Lucie, FLBuilt 1965 · S/N 7ECA-123 N2510GCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 403 N2511FBradley Cole Mckee · Temple, TXBuilt 1965 · S/N 126 N2513FKeller Jeffrey B · Mount Ulla, NCBuilt 1965 · S/N 129 N2516FBourne Cynthia A · Melbourne, FLBuilt 1965 · S/N 7ECA-133 N2518FWill Larry P · Fort Collins, COBuilt 1966 · S/N 136 N2523FCavin Dale L · Marianna, FLBuilt 1965 · S/N 143 N2524FWilkins Shelley A · Claremore, OKBuilt 1966 · S/N 72 N2525FGarbani Jacob R · Caldwell, IDBuilt 1966 · S/N 419 N2527FHightower Marc S · Sevierville, TNBuilt 1965 · S/N 147 N2529FEvanson Scot A · Monroe, TNBuilt 1965 · S/N 149 N2532FQuinn Michael A · Ruby, AKBuilt 1965 · S/N 154 N2533FMacdonald Craig R · Sonoma, CABuilt 1965 · S/N 155 N2534FCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 7ECA-156 N2538FHill Ag-Air LLC · Bancroft, IDBuilt 1965 · S/N 160 N2538GFerrell Herman H · Oak Grove, LABuilt 1967 · S/N 411 N2543FRowley Harold · Greensboro, ALBuilt 1965 · S/N 165 N2545FJewell Anthony G · Reedley, CABuilt 1965 · S/N 167 N2546FLloyd Clee E · Canby, ORBuilt 1965 · S/N 7ECA-342 N2546GStambaugh Rex E · Westminster, COBuilt 1967 · S/N 421 N2549FAgaliotis Paul E · San Martin, CABuilt 1965 · S/N 7ECA-141 N2550FOdom Richard · Williamson, GABuilt 1965 · S/N 172 N2552FCarolina Warbirds LLC · Patuxent River, MDBuilt 1965 · S/N 174 N2555FKluge Michael F · Chanhassen, MNBuilt 1965 · S/N 340 N2558FTen High Flg Inc · Five Points, CARegistration revokedBuilt 1965 · S/N 188 N2559FHey Eric R · Childersburg, ALS/N 175 N2561FRoehl Ellen D · Conroe, TXBuilt 1965 · S/N 191 N2563FHickey Michael · Honey Grove, TXBuilt 1966 · S/N 137 N2569FStuart Philip · Tallahassee, FLBuilt 1966 · S/N 400 N2570FDexter Fred H · Live Oak, FLBuilt 1965 · S/N 201 N2575FAksarben Flying Club LLC · Bellevue, NEBuilt 1965 · S/N 206 N2576FStefany Brian · Euless, TXBuilt 1966 · S/N 420 N2579FPalmetto Aviation LLC · Florence, SCS/N 210 N2583FChatwell Terry D · Fort Worth, TXS/N 214 N2585FDobberfuhl James P · Clinton, WABuilt 1965 · S/N 7ECA-216 N2586FLofstrom Caleb J · Wasilla, AKS/N 7ECA-217 N2587FPutt Putt Pilots LLC · Xenia, OHBuilt 1965 · S/N 218 N2592FDunlap Burton D · Mooresville, NCS/N 111 N2594GRuddle Kaleb T · Lawrenceburg, TNBuilt 1967 · S/N 448 N2595FDowell Grant A · Lansing, MIBuilt 1965 · S/N 224 N2596FYounger Aviation LLC · Poteau, OKS/N 225 N2598FCheney Jeffrey T · Cambridge, MNS/N 105 N2598GRybacki Peter L · Great Barrington, MABuilt 1967 · S/N 423 N2608GStrom Gordon B Md · Paris, TXBuilt 1967 · S/N 450 N2634GDavis Michael W · Richland, WABuilt 1967 · S/N 476 N2671GAas LLC · Ovid, MIBuilt 1967 · S/N 316 N2684GBlair Daniel S · Perrysburg, OHS/N 546 N2696GGrabeman Allan · Fishers, INBuilt 1967 · S/N 325 N2763GWilko Air LLC · Van Wert, OHBuilt 1967 · S/N 459 N2772GSchultz Jason G · Crowley, LABuilt 1967 · S/N 460

Back to Champion 7ECA