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.

N6998APincheon Reginald · La Vergne, TNBuilt 1956 · S/N 29098 N6999AHartzler Jeffery A · Rittman, OHBuilt 1956 · S/N 29099 N69AMMargitan Allan R · Nine Mile Falls, WABuilt 1958 · S/N 36569 N69ZBSpringfield Flying Service LLC · Columbia, CABuilt 1958 · S/N 36585 N6JYYoung John B · Panacea, FLBuilt 1956 · S/N 28217 N7000AHaley Michael R · Hobbs, NMFirst renewal noticeBuilt 1956 · S/N 29100 N7000TCarter Jared · Lebanon, TNBuilt 1959 · S/N 46600 N7001ALkp Aviation LLC · Montgomery, INS/N 29101 N7002AAustin James M · Fort Worth, TXBuilt 1956 · S/N 29102 N7003AHuang Sophie M · Newcastle, WABuilt 1956 · S/N 29103 N7004AMitchell Mark A · Pittsford, NYBuilt 1956 · S/N 29104 N7005AStansell Clayton H · Los Lunas, NMBuilt 1956 · S/N 29105 N7005TSmith Roy B · Newland, NCBuilt 1959 · S/N 46605 N7006AFletcher John G · Diamondhead, MSBuilt 1956 · S/N 29106 N7006TFraas Stephan H · Meriden, CTBuilt 1959 · S/N 46606 N7008AMitchell Shawn J · Red Bluff, CAS/N 29108 N7008TDelaney Patrick James · Marion, TXS/N 46608 N7009TCrigler Christopher E · Warrenton, VABuilt 1959 · S/N 46609 N7010TLuft Aviation Inc · Wilmington, DEBuilt 1959 · S/N 46610 N7011ALaursen Nancee S · Tarpon Springs, FLBuilt 1956 · S/N 29111 N7012TL L B Ranch Ltd · Del Rio, TXS/N 46612 N7013TJohnston Jeremy · Cedar Springs, MIBuilt 1959 · S/N 46613 N7014AWaller John Michael · Brownsville, TXBuilt 1956 · S/N 29114 N7014THill James T · Rock Hill, SCBuilt 1958 · S/N 46614 N7017AHodgens Phillip J · Saluda, SCBuilt 1956 · S/N 29117 N7017TSchubert Arthur Glen · Wilmington, NCBuilt 1959 · S/N 46617 N7018AKilburn Daniel B · Worcester, MABuilt 1956 · S/N 29118 N7018TWarner Terry S · Grants, NMS/N 46618 N7019AReynolds Barbara A · Los Fresnos, TXBuilt 1956 · S/N 29119 N7019TGerdeman David R · Litchfield, OHBuilt 1959 · S/N 46619 N7020AHale Brian E · Carrollton, MOBuilt 1956 · S/N 29120 N7021TCreamer Johnie M · Rainier, WABuilt 1959 · S/N 46621 N7023TRobertson Rusty · Fresno, CABuilt 1959 · S/N 46623 N7024TCorrigan Joseph M · San Marcos, CABuilt 1959 · S/N 46624 N7028AMazzarese Nicholas · Cedar Hills, UTBuilt 1956 · S/N 29128 N7028TFoster Chase · Mountain View, MOS/N 46628 N7030AStuckle Eugene A · Davenport, WABuilt 1956 · S/N 29130 N7032ARobinson Michael D · Folkston, GABuilt 1956 · S/N 29132 N7033AWalter Aviation LLC · Bradenton, FLS/N 29133 N7033TTimm Alan W · Hettinger, NDS/N 46633 N7035AMcgavock Edward A · Columbus, WIBuilt 1956 · S/N 29135 N7036AMachuga James A · Davis, CABuilt 1956 · S/N 29136 N7040TLesko Shannon Lt · Loves Park, ILBuilt 1959 · S/N 46640 N7041AOfarrell Scott T · Seattle, WABuilt 1956 · S/N 29141 N7042AGuilbert Gerald L Jr · Fairfax, VABuilt 1956 · S/N 29142 N7044ABradley Shannon C · Carrsville, VABuilt 1956 · S/N 29144 N7045TDougherty Peter G · Yakima, WABuilt 1959 · S/N 46645 N7047TPetersen Derrick D · Sibley, IABuilt 1959 · S/N 46647 N7048THenegar Robert A · Newhope, ARFirst renewal noticeBuilt 1959 · S/N 46648 N7049ATjernjund Wesley Gordon · Salem, ORBuilt 1956 · S/N 29149

Back to Cessna 172