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.

N6352ERotter Dale H · Colville, WABuilt 1959 · S/N 46452 N6355EMassey David A · Yuba City, CABuilt 1959 · S/N 46455 N6356ENielsen James Patrick · Chugiak, AKBuilt 1959 · S/N 46456 N6358EStanford Point LLC · Kalispell, MTBuilt 1959 · S/N 46458 N6362EYoungblood Harley O III · Vancouver, WABuilt 1959 · S/N 46462 N6363EHanson Douglas L · Montpelier, VTBuilt 1959 · S/N 46463 N6369ETeed Brad S · Vancouver, WABuilt 1959 · S/N 46469 N6371EPrincy Lala · Deltona, FLS/N 46471 N6375EDial Eric A · Eldon, MOBuilt 1959 · S/N 46475 N6376EZawacki William M · Medford, WIBuilt 1959 · S/N 46476 N6385ELucky Dog Land Co LLC · Caldwell, IDBuilt 1959 · S/N 46485 N6390ERyan Michael P · Melrose, IAFirst renewal noticeBuilt 1959 · S/N 46490 N6391EDay Stephen F · Queen Creek, AZBuilt 1959 · S/N 46491 N6393EBrewster Richard D · Bellvue, COBuilt 1959 · S/N 46493 N6395EStott David L · Wasilla, AKBuilt 1959 · S/N 46495 N6398EMetter John R · Litchfield, OHBuilt 1959 · S/N 46498 N6399EMountain House LLC · Clear Lake, IABuilt 1959 · S/N 46499 N6400BHowes Frank E · Macomb, MIBuilt 1956 · S/N 29600 N6401EReynolds Richard E · Trumansburg, NYBuilt 1959 · S/N 46501 N6402EWichman Scott A · Lewistown, MTS/N 46502 N6403EGultch Dale R · Brookfield, WIBuilt 1959 · S/N 46503 N6405ERiggs Bradley A · Emporia, KSBuilt 1959 · S/N 46505 N6406BWojtacha Jacob M · Wasilla, AKBuilt 1956 · S/N 29606 N6406EOwczarek Przemyslaw J · Hampton Bays, NYBuilt 1959 · S/N 46506 N6407BMclean Diane A · Weirsdale, FLBuilt 1956 · S/N 29607 N6407EN6407e LLC · Hanover, MDBuilt 1959 · S/N 46507 N6408EMorgan Lloyd J · Memphis, MOBuilt 1959 · S/N 46508 N6409EChehalis Skies Aircraft LLC · Chehalis, WABuilt 1959 · S/N 46509 N6410EKelaita Dean M · Mokelumne Hill, CABuilt 1959 · S/N 46510 N6412BFlight Expo Inc · Princeton, MNS/N 29612 N6412EJoseph Jeric A · Lincoln, MTBuilt 1959 · S/N 46512 N6413BMccroan William R · Blountstown, FLBuilt 1956 · S/N 29613 N6413ESchad Tom J · Gainesville, TXBuilt 1959 · S/N 46513 N6414BFamuliner Dennis M · Carrollton, MOS/N 29614 N6414ETobin Cory J · Cheney, WAS/N 46514 N6417ESharpley David Jr · Pittsboro, INBuilt 1959 · S/N 46517 N6421BNord Andrew E · West Columbia, SCBuilt 1956 · S/N 29621 N6421EOsborn Jon C · Groveland, FLBuilt 1959 · S/N 46521 N6423BMolina Rodney R · New Kent, VABuilt 1956 · S/N 29623 N6424EBurns Travis Lance · Lake Wales, FLBuilt 1959 · S/N 46524 N6425ETurner Steven G · Clearwater, KSS/N 46525 N6426EV1 Air Inc · Hibbing, MNS/N 46526 N6427EN6427e LLC · Kilgore, TXBuilt 1959 · S/N 46527 N6428BRegistered aircraftBuilt 1956 · S/N 29628 N6428EMoore Urban Joseph · Cottage Grove, ORBuilt 1959 · S/N 46528 N6429BNethery Christopher H · Shelbyville, KYBuilt 1956 · S/N 29629 N6429EKeeton Andrew · Palestine, TXS/N 46529 N6431BStecconi Ferraro Denise M · Seattle, WABuilt 1957 · S/N 29631 N6431EGroup 172 LLC · Tucson, AZBuilt 1959 · S/N 46531 N6432BLuebke David M · Canton, SDBuilt 1957 · S/N 29632

Back to Cessna 172