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.

N7308TBerg Weston L · Stanton, NDBuilt 1959 · S/N 46908 N7309TRognlie Brent R · Westminster, COBuilt 1959 · S/N 46909 N7310TYowell Albert W · Etlan, VABuilt 1959 · S/N 46910 N7312THangar 20 Flying Club LLC · Climax, MIS/N 46912 N7314TCarney Mark A · Emporia, KSBuilt 1959 · S/N 46914 N7320TRegistration Pending · Shepherdsville, KYRegistration pendingBuilt 1959 · S/N 46920 N7321TDelaney Glen W · Canyon, TXBuilt 1959 · S/N 46921 N7322TSchaub John P · Darlington, INBuilt 1959 · S/N 46922 N7325TCierra Rose Morgan Shawe · Seattle, WAS/N 46925 N7327TBanister James M · Florence, MTS/N 46927 N7328TPickett Griffith Randall · Kansas City, MOBuilt 1959 · S/N 46928 N7330TBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1959 · S/N 46930 N7331TRothenberger Stanley D · Topeka, KSS/N 46931 N7333TMyl High Flying Club LLC · Mccall, IDFirst renewal noticeBuilt 1959 · S/N 46933 N7334THunter Jeffrey D · Wolfforth, TXBuilt 1959 · S/N 46934 N7337TWallace Austin · Oregon City, ORBuilt 1959 · S/N 46937 N7341TG & D Holdings LLC · Provo, UTS/N 46941 N7342TKeyes George E Jr · Moab, UTBuilt 1959 · S/N 46942 N7346THalford Richard W · Eagle River, AKBuilt 1959 · S/N 46946 N7349TOsipov Vladimir A · Charlotte, NCBuilt 1959 · S/N 46949 N7353TFlyit LLC · Camas, WABuilt 1959 · S/N 46953 N7354TAching Raul E · Yuma, AZBuilt 1959 · S/N 46954 N7360TSoper Phyllis D · San Mateo, CAS/N 46960 N7362TSwanson Michael J · Wayzata, MNBuilt 1959 · S/N 46962 N7363TGilliland Rocky · Deport, TXS/N 46963 N7365TCrowell David P · Plainfield, MABuilt 1959 · S/N 46965 N7367THadorn Daniel J · Solon, OHBuilt 1960 · S/N 46967 N7370TVadakin Jeffrey M · Dover, DEBuilt 1959 · S/N 46970 N7375TMclean Robert M · Baltimore, MDBuilt 1959 · S/N 46975 N7376TClee Jacob M · Chickamauga, GABuilt 1959 · S/N 46976 N7377TRock Nh Services LLC · Alpine, TXS/N 46977 N7379TPaulino Junior · Poughkeepsie, NYBuilt 1959 · S/N 46979 N7380TAndersen William A · Flagstaff, AZBuilt 1959 · S/N 46980 N7382AWretschko Brian W · Phoenix, AZBuilt 1956 · S/N 29482 N7383TLeach Jeff · Terlingua, TXS/N 46983 N7384TMclaughlin James L · Centerburg, OHS/N 46984 N7385TSeed And Sky Provisions LLC · College Station, TXS/N 46985 N7388TAllen Kenneth C · Spring City, TNBuilt 1959 · S/N 46988 N7391TAngell Toby L · Stillwater, OKBuilt 1959 · S/N 46991 N7393TAppalachian Flight Services LLC · Huntington, WVS/N 46993 N7394TSmith Lowell A D · Gresham, ORBuilt 1959 · S/N 46994 N7395TWhalen John F Jr · West Ossipee, NHS/N 46995 N7396TFitzsimmons Robert J · Hastings, FLBuilt 1959 · S/N 46996 N7397TDirectional Holdings LLC · Missoula, MTS/N 46997 N7398THilliard George W · Beeville, TXBuilt 1959 · S/N 46998 N7399TLandrover Ltd · Hills, MNBuilt 1959 · S/N 46999 N7402TKnox David B · Mc Arthur, OHBuilt 1959 · S/N 47002 N7403TKoehn David Scott · Orange Beach, ALBuilt 1959 · S/N 47003 N7404TRaptor Flight LLC · Fort Worth, TXBuilt 1959 · S/N 47004 N7409TJohnson Scott E · Wausau, WIS/N 47009

Back to Cessna 172A