Skip to content

Registered aircraft · 617

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

N3056USchans Richard L Sr · New Bern, NCBuilt 1963 · S/N 17250656 N3057UDesousa Raphael · Fremont, CABuilt 1963 · S/N 17250657 N3060UWhipple James M · Wadsworth, OHBuilt 1963 · S/N 17250660 N3061UWade William J · Waterman, ILS/N 17250661 N3062UMitchell Steven C · Knoxville, IABuilt 1963 · S/N 17250662 N3063ULittle Bird Airways LLC · Hamburg, NYBuilt 1963 · S/N 17250663 N3064UMcintosh Randall W · Rome City, INBuilt 1963 · S/N 17250664 N3068UArlins Aircraft Service Inc · Belgrade, MTBuilt 1963 · S/N 17250668 N306GWCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 17250714 N3071URegistration Pending · Sheridan, WYRegistration pendingBuilt 1963 · S/N 17250671 N3082UArmstrong Geoffrey Peter · Las Vegas, NVBuilt 1963 · S/N 17250682 N3085UMoyers Tim J · Clovis, NMBuilt 1963 · S/N 17250685 N3087UShelite Michael J · Enid, OKS/N 17250687 N3093UEfflandt Joseph E · Eagle, IDBuilt 1963 · S/N 17250693 N3096UDyer Gerald W · Arlington, TXS/N 17250696 N3098UHogan Lee · Addison, ILBuilt 1963 · S/N 17250698 N3099UCotter William P · Elkhart, KSBuilt 1963 · S/N 17250699 N345FBMarino Gregory G · Big Horn, WYBuilt 1967 · S/N 67-15214 N349ADEdelman Loren H · Sabetha, KSBuilt 1964 · S/N 17251516 N3500SVasylenko Volodymyr V · Portland, ORBuilt 1963 · S/N 17250700 N3508SParris Jack L · Pleasant Hill, MOBuilt 1963 · S/N 17250708 N3511SRichard Daniel J · Orrington, MEBuilt 1963 · S/N 17250711 N3515STm Aviation Services LLC · Riverside, CABuilt 1963 · S/N 17250715 N3516SBenedict Greg · Mason City, IABuilt 1963 · S/N 17250716 N3518SVarner Gregory A · Wasilla, AKBuilt 1963 · S/N 17250718 N3520SBrosnan James M · Staten Island, NYBuilt 1963 · S/N 17250720 N3524SFagersten Richard B · Sparta, NJBuilt 1963 · S/N 17250724 N3526SKoenig Edward Executor · Dow, ILBuilt 1963 · S/N 17250726 N3528SCoyer Company Inc · Orr, MNBuilt 1963 · S/N 17250728 N3530SMakosteako Holding Corp · Massapequa, NYBuilt 1963 · S/N 17250730 N3533SDalton Joseph D · Circleville, UTS/N 17250733 N3534SInfinite Air Center LLC · Albany, ORS/N 17250734 N3542SKing Theresa Ann · Bakersfield, CABuilt 1963 · S/N 17250742 N3544STucker Nicholas · Sebastopol, CABuilt 1963 · S/N 17250744 N3545SMaldonado Edward R · Independence, ORBuilt 1963 · S/N 17250745 N3546SJackson Harry Jason · El Centro, CAS/N 17250746 N3547SThhm LLC · Menomonie, WIBuilt 1963 · S/N 17250747 N3549SSchott Roy W · Derby, KSBuilt 1963 · S/N 17250749 N3550SSwalling Matthew C · Wasilla, AKBuilt 1963 · S/N 17250750 N3551SStraub Brian Trustee · Columbus, OHBuilt 1963 · S/N 17250751 N3554SWeisser Steve · Milford, INBuilt 1963 · S/N 17250754 N3556SLakeland Aviation Of Minocqua Inc · Arbor Vitae, WIBuilt 1963 · S/N 17250756 N3557SWagner Joel D · Anchorage, AKBuilt 1963 · S/N 17250757 N3561SMunoz Christian · Visalia, CAS/N 17250761 N3562SSpeedstar Aviation LLC · Kalispell, MTS/N 17250762 N3563SHigh Wing Rentals Inc · Chino, CAS/N 17250763 N3564SMedlin Wayne D · Marshville, NCBuilt 1963 · S/N 17250764 N3565SMarks David A · Madisonville, KYBuilt 1963 · S/N 17250765 N3566SBussio Michael B · Reno, NVBuilt 1963 · S/N 17250766 N3567SKling Ronald L · Kimberling City, MOBuilt 1963 · S/N 17250767

Back to Cessna 172E