Skip to content

Registered aircraft · 1,025

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

N7143GAllen Nathanael W · Bemidji, MNBuilt 1969 · S/N 17258843 N7144GJc Flight Inc · Wilmington, DEBuilt 1969 · S/N 17258844 N7146GHalladay Roy · Erie, COBuilt 1969 · S/N 17258846 N7147GAffordable Flying LLC · Cedar Park, TXBuilt 1969 · S/N 17258847 N7151GRoadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258851 N7152GJ&B Aircraft Leasing LLC · Lufkin, TXBuilt 1969 · S/N 17258852 N7154GJuranich William M · Kent, WAS/N 17258854 N7157GAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258857 N7158GHawk Aviation Inc · Rush City, MNBuilt 1969 · S/N 17258858 N7159GN7159g LLC · Jacksonville, ARS/N 17258859 N7160GFisher Noel F · Petersham, MABuilt 1969 · S/N 17258860 N7161GJohnson Robert D · Denver, PABuilt 1969 · S/N 17258861 N7162GWmg Security · Shelton, WAS/N 17258862 N7163GDs Flight Services LLC · Battle Ground, WABuilt 1969 · S/N 17258863 N7165GExecutive Flight Institute LLC · Murrieta, CAS/N 17258865 N7168GDurbin John W · Lovington, ILBuilt 1969 · S/N 17258868 N7170GSs Skyways LLC · Becker, MNBuilt 1969 · S/N 17258870 N7173GSale Reported · Haiku, HISale reportedBuilt 1969 · S/N 17258873 N7174GMaloney John T · Deer Park, NYBuilt 1969 · S/N 17258874 N7175GMontgomery Monty · Cave Spring, GABuilt 1969 · S/N 17258875 N7177GCoats George A · The Woodlands, TXBuilt 1969 · S/N 17258877 N7180GPearman Properties LLC · Branson, MOBuilt 1970 · S/N 17258880 N7182GBar-Od-4 Cattle Co LLC · Laredo, TXBuilt 1969 · S/N 17258882 N7185GJones Mark R · Denton, MDS/N 17258885 N7188GVrechek Joseph D · Fort Lauderdale, FLS/N 17258888 N7189GSky Hawk Flying Club · Grand Rapids, MNBuilt 1969 · S/N 17258889 N7190GM T Machinery Inc · Porter, TXBuilt 1969 · S/N 17258890 N7194GAvco Patrol LLC · Lyndon, KSBuilt 1969 · S/N 17258894 N7195GBurnside George C II · Hattiesburg, MSBuilt 1969 · S/N 17258895 N7197GFly Wissota LLC · Chippewa Falls, WIBuilt 1969 · S/N 17258897 N7198GJones Lawrence A · St Simons Island, GABuilt 1969 · S/N 17258898 N7200GWe Fly High LLC · Helena, MTBuilt 1969 · S/N 17258900 N7202GUrmston Benjamin R · Sherborn, MABuilt 1969 · S/N 17258902 N7203GVenard Inc · Murdo, SDS/N 17258903 N7204GGibson James E · Tenino, WABuilt 1969 · S/N 17258904 N7205GJones Keith · Tucson, AZBuilt 1969 · S/N 17258905 N7207GCowden Flying Services Inc · Fort Worth, TXBuilt 1969 · S/N 17258907 N7208GBurgess Keith · Arnoldsville, GABuilt 1969 · S/N 17258908 N7209GElite Planes LLC · Menifee, CABuilt 1969 · S/N 17258909 N7210GOgle Howard J · Moorpark, CAS/N 17258910 N7212GMeister James A · Star Prairie, WIBuilt 1969 · S/N 17258912 N7216GLincoln Skyways Inc · Lincoln, CABuilt 1969 · S/N 17258916 N7217GOne Niner Right LLC · Berkeley, CABuilt 1969 · S/N 17258917 N721AAGammage Linda L · Delanco, NJBuilt 1968 · S/N 17257605 N7220GStagg Travis M · Fairbanks, AKBuilt 1969 · S/N 17258920 N7225GVance Wilbur H III · Hershey, PABuilt 1970 · S/N 17258925 N7226GHerlihy Douglas K II · Denville, NJBuilt 1970 · S/N 17258926 N7227GBeltz Richard D · Lehighton, PABuilt 1970 · S/N 17258927 N7228GFasking Dan · Stanford, ILS/N 17258928 N7230GMaples Kevin T · Pueblo, COS/N 17258930

Back to Cessna 172K