Skip to content

Registered aircraft · 413

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

N120DHHiester Donald J · Sicklerville, NJBuilt 1961 · S/N 17248694 N127KGardner Victoria S · Port Saint Lucie, FLBuilt 1960 · S/N 17248076 N12TYSewell Roger C · Meridian, IDBuilt 1960 · S/N 17248030 N172GLGlover Anthony R · Louisville, KYBuilt 1960 · S/N 17247944 N172GVJackson Gordon W · Fort Worth, TXBuilt 1961 · S/N 17248487 N172NXHolcomb Garry M · Point, TXBuilt 1960 · S/N 17248148 N172TTErvin Max W · Bend, ORBuilt 1961 · S/N 17248370 N1961BGoose Aviation LLC · Cumberland, WIBuilt 1960 · S/N 17247934 N2573YFritz David C · Lincoln, NEBuilt 1960 · S/N 17247906 N3108FSuntech LLC · St George, UTS/N 17248297 N34270Goza Samuel · Fresno, CABuilt 1960 · S/N 172630 N361CCSackman Robert B · Unionville, INBuilt 1961 · S/N 17248703 N44PForester Dwain E · Tonopah, NVBuilt 1961 · S/N 17248620 N461DYYoung Duff L · Avoca, TXBuilt 1961 · S/N 17248326 N56JRMccollum Eric B · Fair Oaks, CAS/N 17248012 N579KRed Plane Aviation LLC · Key West, FLBuilt 1960 · S/N 17247827 N6218GGoatley Valerie M · Springfield, KYBuilt 1961 · S/N 17248655 N621WHerzog Daniel L · Clinton, MIS/N 17248576 N66BDCampanella Stephen · Brunswick, OHBuilt 1960 · S/N 17248101 N673XBusy Bee Ventures Inc · Cherokee, NCBuilt 1960 · S/N 17247922 N678RMLaw Roger Jay · Franklin, INBuilt 1961 · S/N 17248390 N6848XHinkleman Howard R · Brownsboro, ALBuilt 1960 · S/N 17247748 N6849XReiss Alan T · Gig Harbor, WAS/N 17247749 N6858XHoang Andrew Q · Seal Beach, CABuilt 1960 · S/N 17247758 N6859XWilkerson Bradley W · Caldwell, IDBuilt 1960 · S/N 17247759 N6865XGessley Lester Jack Jr · Port Saint Lucie, FLBuilt 1960 · S/N 17247765 N6868XRegistered aircraftBuilt 1960 · S/N 17247768 N6869XSquires Aaron Lane · Aynor, SCS/N 17247769 N6877XSwick Gerald K · Murfreesboro, TNBuilt 1960 · S/N 17247777 N6878XLinkinhoker Craig W · Carpentersville, ILBuilt 1960 · S/N 17247778 N6879XRegistration Pending · Farr West, UTRegistration pendingBuilt 1960 · S/N 17247779 N6881XWestmoreland Dennis F · Snyder, TXBuilt 1960 · S/N 17247781 N6889XSchler Joseph B · Reno, NVBuilt 1960 · S/N 17247789 N6902XPoules Alexander · Hope Valley, RIBuilt 1960 · S/N 17247802 N6906XDucharme Lynn S · Polson, MTBuilt 1960 · S/N 17247806 N6907XCamp Paul L · Fort Wayne, INBuilt 1960 · S/N 17247807 N6910XRegistration Pending · Mcpherson, KSRegistration pendingS/N 17247810 N6911XNorth Georgia Aviation Management Group LLC · Cumming, GABuilt 1960 · S/N 17247811 N6912XFahrne John E · Bradley, MIBuilt 1960 · S/N 17247812 N6913XEllis Mark C · Rogers, ARS/N 17247813 N6914XMagee Wayland S · Agency, MOBuilt 1960 · S/N 17247814 N6915XWitkowski Terrance G · Winamac, INBuilt 1960 · S/N 17247815 N6917XSchumacher Terry L · Wilson, WIBuilt 1960 · S/N 17247817 N6918XHackbarth Ryan J · Zimmerman, MNBuilt 1960 · S/N 17247818 N6920XEge David D · Mount Horeb, WIBuilt 1960 · S/N 17247820 N6922XIowa Military Aviation Heritage Museum · Ankeny, IABuilt 1960 · S/N 17247822 N6924XAshby Jimmie Thomas · Germanton, NCBuilt 1960 · S/N 17247824 N6925XAdlard Thomas · Spokane, WAS/N 17247825 N6928XN6928x LLC · Sandpoint, IDBuilt 1960 · S/N 17247828 N6931XDanford Gary R · Columbus, MSS/N 17247831

Back to Cessna 172B