Skip to content

Registered aircraft · 435

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

N7410TLepinsky Donald J · Whitehall, MTBuilt 1959 · S/N 47010 N7411TMcbain Sarah R · West Warwick, RIBuilt 1959 · S/N 47011 N7412TDavis Tonya · Hohenwald, TNBuilt 1959 · S/N 47012 N7413TThompson Daniel L · Malta, OHBuilt 1959 · S/N 47013 N7416TMcalister Donald F Jr · Munith, MIBuilt 1959 · S/N 47016 N7417TMcgrath William F Jr · Nantucket, MABuilt 1959 · S/N 47017 N7418TDavis Larry M · Waleska, GABuilt 1959 · S/N 47018 N7419TIntellipix LLC · Cambridge, MDBuilt 1959 · S/N 47019 N7421TCostello Charles E · Greenfield, ILBuilt 1959 · S/N 47021 N7424THicks Kirby L · Dawson, GABuilt 1959 · S/N 47024 N7428THallstrom Steven D · Pasco, WABuilt 1959 · S/N 47028 N7429TDasilva David S · Catasauqua, PABuilt 1959 · S/N 47029 N7431TKorinko Seana L · Rostraver Township, PABuilt 1959 · S/N 47031 N7432TWilcox Joshua · Mesa, AZBuilt 1959 · S/N 47032 N7433TAndreatta Susan J · Canon City, COBuilt 1959 · S/N 47033 N7434TDixon Farm · Tribune, KSS/N 47034 N7435TJohnson Scott E · Wausau, WIBuilt 1959 · S/N 47035 N7440TFranklin Benjamin L Jr · Woodstock, GABuilt 1960 · S/N 47040 N7441TGarst Lynn F · Oklahoma City, OKBuilt 1959 · S/N 47041 N7442TTrono Zach C · Charlotte, VTBuilt 1959 · S/N 47042 N7443TGuarno Adam C · Milton, FLS/N 47043 N7444TDmac Aircraft LLC · Savannah, GABuilt 1959 · S/N 47044 N7445TKiss Sandor A Jr · Petaluma, CAS/N 47045 N7446TGot Wings LLC · Woodbury, NYBuilt 1959 · S/N 47046 N7453TEllis Wendell Kirk · Gakona, AKBuilt 1959 · S/N 47053 N7455THowes Roger W · Hinckley, UTBuilt 1959 · S/N 47055 N7456TWalker Chad E · Denton, NCBuilt 1960 · S/N 47056 N7459TBurrows Nicholas J · Daytona Beach, FLS/N 47059 N7460TJones Andrew G · Terrell, TXBuilt 1959 · S/N 47060 N7463TCurp Christopher A · San Jose, CABuilt 1959 · S/N 47063 N7466TAiken Auusta Aviation LLC · Aiken, SCBuilt 1959 · S/N 47066 N7467TEckhart George R · Perkasie, PABuilt 1959 · S/N 47067 N7469TBrest John E · Moses Lake, WAS/N 47069 N7471TSanders Evan C · Honea Path, SCBuilt 1959 · S/N 47071 N7473TDraper Joshua L · Monitor, WAS/N 47073 N7475TAllen Renee E · Jensen Beach, FLBuilt 1959 · S/N 47075 N7476TStuart Thomas A · Prairie Farm, WIBuilt 1960 · S/N 47076 N7480THalley Dan R · Avery, TXBuilt 1959 · S/N 47080 N7481TFairon Daniel · Fox Island, WABuilt 1959 · S/N 47081 N7486TRhodes Vergil H Jr · Bartlesville, OKBuilt 1959 · S/N 47086 N7492TSale Reported · Newport, ORSale reportedS/N 47092 N7493TLee Cody C · Denton, MTS/N 47093 N7497TLeffler Greg L · Zion Crossroads, VABuilt 1959 · S/N 47097 N7498TLala Princy · Deltona, FLBuilt 1959 · S/N 47098 N7499TWright Donald E · Greensboro, NCBuilt 1959 · S/N 47099 N7500TJacks Jerry W · Dalton, GABuilt 1960 · S/N 47100 N7502TDavis Chip · Apex, NCBuilt 1959 · S/N 47102 N7503THutchison Greg A · Moses Lake, WABuilt 1959 · S/N 47103 N7506TLeblond Robert F · Wardsboro, VTBuilt 1959 · S/N 47106 N7508TJasmer Steven M · Randle, WABuilt 1959 · S/N 47108

Back to Cessna 172A