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.

N7103ACady Marshall J · Seadrift, TXS/N 29203 N7105ADunkley Judith A · London, OHS/N 29205 N7107ASlingerland Rex · Grand Haven, MIBuilt 1956 · S/N 29207 N7107TRaetzke Bradley · Columbus, OHBuilt 1959 · S/N 46707 N7109TOwens Emmett E · Madison, INBuilt 1959 · S/N 46709 N7110TWright Donald E · Greensboro, NCS/N 46710 N7111ABurgess Fred P · Titusville, FLBuilt 1956 · S/N 29211 N7111TMesseder Thomas Alan Jr · Fredericksburg, VABuilt 1959 · S/N 46711 N7113ATrail Richard L · Mccook, NEBuilt 1956 · S/N 29213 N7114TMeyer Andrew J · Carter, SDBuilt 1959 · S/N 46714 N7115ARothenbusch Michael G · Tampa, FLBuilt 1956 · S/N 29215 N7115T172 Club LLC · Olalla, WABuilt 1959 · S/N 46715 N7116TMaierhoffer Henry F · Sylvania, GAS/N 46716 N7117TOrtega Rolando J · Davie, FLBuilt 1959 · S/N 46717 N7119AMcfarland Michael G · Seabeck, WABuilt 1956 · S/N 29219 N7120TDelauder Patrick J · Terra Alta, WVBuilt 1959 · S/N 46720 N7121ARoberts Calvin D · Bluebell, UTBuilt 1956 · S/N 29221 N7121TSiscoe Ronald D · Bloomington, INBuilt 1959 · S/N 46721 N7123AMerchant Herbert M · Powhatan, VAS/N 29223 N7123TDevalcourt Randall · Washington, LABuilt 1959 · S/N 46723 N7124TCaskey Jessica B · Anchorage, AKS/N 46724 N7126AFreeman Michael D · Morgantown, INBuilt 1956 · S/N 29226 N7127ASeremet Cristina L · Beaver Dam, WIS/N 29227 N7127TLehmer Jereme · Oxford, NYBuilt 1959 · S/N 46727 N7128AEgbert Tom · Claremore, OKBuilt 1956 · S/N 29228 N7130AJohnston David E · Fort Myers, FLBuilt 1956 · S/N 29230 N7131AOneill Mark B · Pinckney, MIBuilt 1956 · S/N 29231 N7131TReyes Jose Daniel Cruz · Wilmington, NCBuilt 1959 · S/N 46731 N7133APeacock Richelle L · Arcadia, FLBuilt 1956 · S/N 29233 N7133TQuam Gary L · Rio, WIBuilt 1959 · S/N 46733 N7135AMoss Colin · Sparta, NCBuilt 1956 · S/N 29235 N7136ACross Frank · Huntsville, MOBuilt 1956 · S/N 29236 N7136TSnouffer Robert E · Mountain Grove, MOBuilt 1959 · S/N 46736 N7137ACarrico Drew E · Redway, CABuilt 1956 · S/N 29237 N7137TLeavitt John E · Palmer, AKBuilt 1959 · S/N 46737 N7138THudson Thomas C · Bessemer, ALBuilt 1959 · S/N 46738 N7139ATimothy Scott Bloom · Chugiak, AKBuilt 1956 · S/N 29239 N713BJRiley James A · Richmond, KYBuilt 1959 · S/N 46696 N7141AFarruggia John A · West Winfield, NYBuilt 1956 · S/N 29241 N7141TRosser David S · Lynn, ALBuilt 1959 · S/N 46741 N7145TZacharias Norman R · Hinckley, MNFirst renewal noticeBuilt 1959 · S/N 46745 N7147AAir Cover Academy LLC · Frankford, MOBuilt 1956 · S/N 29247 N7147TMoody George A II · Dyersburg, TNBuilt 1959 · S/N 46747 N7149ASteffanic Matthew R · Bastrop, TXS/N 29249 N7149TRb Associates · North Bend, ORBuilt 1959 · S/N 46749 N7150TKittelman Real Estate Inc · Enumclaw, WABuilt 1959 · S/N 46750 N7152TKaras Alyssa Jane · Henderson, NVBuilt 1959 · S/N 46752 N7153TBarlow Ephraim · Hyde Park, UTS/N 46753 N7154AKim Sungtae · Los Angeles, CABuilt 1956 · S/N 29254 N7155ABrown Benjamin K · Norman, OKBuilt 1956 · S/N 29255

Back to Cessna 172