Skip to content

Registered aircraft · 1,805

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

N6250EBox Samuel G · Stigler, OKS/N 46350 N6252EDmac Aircraft LLC · Savannah, GABuilt 1959 · S/N 46352 N6253EReed Nathan A · Seward, NEBuilt 1958 · S/N 46353 N6255EHall Thomas R · Kittanning, PABuilt 1959 · S/N 46355 N6256EParish Don P · Russells Point, OHBuilt 1958 · S/N 46356 N625RDLoup City Airservice · Lincoln, NEBuilt 1957 · S/N 36028 N6260EAltobelli Anthony J · Marcell, MNS/N 46360 N6261ELapic George R · Safety Harbor, FLBuilt 1959 · S/N 46361 N6262EBauer Flying Services LLC · Reese, MIS/N 46362 N6267E67 Echo LLC · Las Vegas, NVBuilt 1959 · S/N 46367 N6268EBilton Nicholas J · Bozeman, MTS/N 46368 N6269ERule Paul Crane Trustee · Wapato, WAS/N 46369 N6271ENate Abel Flying Club · Fort Worth, TXBuilt 1958 · S/N 46371 N6272EFeauto Aviation Inc · Saint Cloud, FLBuilt 1958 · S/N 46372 N6273EBunner Corin Anthony · Murfreesboro, TNBuilt 1959 · S/N 46373 N6274EHuff Air LLC · Uvalde, TXBuilt 1959 · S/N 46374 N6278EJ K Sparks Inc · Lutz, FLBuilt 1959 · S/N 46378 N6281EPlunk Ben · Mesquite, TXBuilt 1959 · S/N 46381 N6284ECastle Donald L · Auburn, CABuilt 1959 · S/N 46384 N6287EClemons Martin · Butte, MTS/N 46387 N6288EMccardy Derk · Torrance, CABuilt 1959 · S/N 46388 N6289EMaverick Jets LLC · Vineburg, CABuilt 1959 · S/N 46389 N6290EConnell Mark Stephen · Melbourne, FLBuilt 1959 · S/N 46390 N6292ELucci Giacinto A Jr · Nashville, MIS/N 46392 N6293EWatkins Jerry G · Portland, ORBuilt 1959 · S/N 46393 N6294EFlightpath Leasing LLC · Tallahassee, FLS/N 46394 N6295EBuffo Perry J · Albion, NJBuilt 1959 · S/N 46395 N6296EKlad-Air LLC · Catlett, VABuilt 1959 · S/N 46396 N6299ECarpenter Daniel R · Jefferson City, MOBuilt 1959 · S/N 46399 N6310EMinor Mark · Central Point, ORBuilt 1959 · S/N 46410 N6313EGottshall Curt E · Monroe, WABuilt 1959 · S/N 46413 N6314EWeber Tom L · Douglas, WYBuilt 1959 · S/N 46414 N6318EEvans Robert W · Upland, CABuilt 1959 · S/N 46418 N6323ESwedish Flying Couching LLC · Franklin, WIBuilt 1959 · S/N 46423 N6327ESpiro Brian F · Wonder Lake, ILBuilt 1959 · S/N 46427 N6329EFeigl Frederick D · Dallas, TXBuilt 1959 · S/N 46429 N6330ECollins Anthony W · Bowdoinham, MEBuilt 1959 · S/N 46430 N6332ERampani Joe J · Sullivan, MOBuilt 1959 · S/N 46432 N6334ESrygley Donald E · Muscle Shoals, ALBuilt 1959 · S/N 46434 N6335ECorro Lee A · Holden, MES/N 46435 N6338EBarber Theodore C Trustee · Spanish Fork, UTBuilt 1959 · S/N 46438 N6339EJudge Nathan E · Coeur D Alene, IDBuilt 1959 · S/N 46439 N6340EAdams Mandy Reed · New Braunfels, TXBuilt 1959 · S/N 46440 N6341EHansen'S Garage LLC · Spring City, UTS/N 46441 N6344ECantley Richard W · Bluff City, TNBuilt 1959 · S/N 46444 N6345EBatts Gregory W · Barnesville, OHBuilt 1959 · S/N 46445 N6347EHinton Charles L · Nunda, SDBuilt 1959 · S/N 46447 N6348EHumble Aviation LLC · Russellville, ARS/N 46448 N6350EAirport Bums Aero Club · Branson, MOBuilt 1959 · S/N 46450 N6351EMaluda Erick · Enigma, GABuilt 1959 · S/N 46451

Back to Cessna 172