Skip to content

Registered aircraft · 781

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

N1688FSkydive Spi LLC · South Padre Island, TXBuilt 1966 · S/N 17255083 N1690FN1690f LLC · Bluffton, INBuilt 1966 · S/N 17255085 N1691FVess Joel W · Cherryville, NCBuilt 1966 · S/N 17255086 N1692FBeck Seth · Deer Lodge, MTS/N 17255087 N1705FTennis Gayland L · Bath, MIBuilt 1966 · S/N 17255100 N1707FFreije Anthony M · Anchorage, AKBuilt 1966 · S/N 17255102 N1708FKnudsen Mark A · Whitmore Lake, MIBuilt 1966 · S/N 17255103 N1710FValley Aviators Inc · Williston, NDBuilt 1966 · S/N 17255105 N1715FBradley Max T II · West Plains, MOBuilt 1966 · S/N 17255110 N1718FSavage David E · American Falls, IDS/N 17255113 N1719FMoran Aviation LLC · Rose Bud, ARS/N 17255114 N1721FCenterline Flying Club Inc · Williamstown, NJBuilt 1966 · S/N 17255116 N1722FLeone William T II · Canfield, OHBuilt 1966 · S/N 17255117 N1724FWalters Todd J · Darwin, MNBuilt 1966 · S/N 17255119 N1725FWagner Harold D Jr · Hilltop Lakes, TXBuilt 1966 · S/N 17255120 N1727FWhetham Ed · Wilton, NDBuilt 1966 · S/N 17255122 N172AKGazarek Edward · Fort Myers, FLBuilt 1967 · S/N 17255914 N172HMatusky Gregory S · Cal Nev Ari, NVBuilt 1967 · S/N 17256262 N172LWCrane Donald L · Kenai, AKBuilt 1967 · S/N 17255790 N172PJSlykhouse Gary B · Grand Rapids, MIBuilt 1966 · S/N 17255099 N172PM98x LLC · Caddo Mills, TXS/N 17256117 N172PSSchwarzenberg Johannes · MoosburgBuilt 1967 · S/N 172-55822 N172TNRegistration Pending · San Antonio, TXRegistration pendingBuilt 1966 · S/N 17255519 N1730FSpragues Aerial Spraying Inc · Courtenay, NDBuilt 1966 · S/N 17255125 N1731FHostetler Robert J · Windyville, MOBuilt 1966 · S/N 17255126 N1732FWicks Colton D · Cooper, TXBuilt 1966 · S/N 17255127 N1733FRegistered aircraftBuilt 1966 · S/N 17255128 N1734FWlb Farms LLC · Iota, LABuilt 1966 · S/N 17255129 N1737FVoltl Mike N · Coloma, WIS/N 17255132 N1738FWesley Emerson Holdings LLC · Clifton, TXBuilt 1966 · S/N 17255133 N1739FSessions Jan · Kirbyville, TXBuilt 1966 · S/N 17255134 N1740FBecton Richard A · San Antonio, TXBuilt 1966 · S/N 17255135 N1742FMarsteller Bruce Paul Jr · Greensburg, PABuilt 1966 · S/N 17255137 N1743FLittle Bird Airways LLC · Hamburg, NYBuilt 1966 · S/N 17255138 N1745FClary David D · Elk Grove Village, ILBuilt 1966 · S/N 17255140 N1747FSmith Jason F · Ronkonkoma, NYBuilt 1966 · S/N 17255142 N1748FManning Malcolm · Senatobia, MSBuilt 1966 · S/N 17255143 N1750FLeggett Lee D · Murfreesboro, NCBuilt 1966 · S/N 17255145 N1755FSummit Aviation LLC · Belton, SCBuilt 1966 · S/N 17255150 N1756FHeistad Aviation Inc · Houston, TXBuilt 1966 · S/N 17255151 N1757FAcker David Lynn · Eugene, ORBuilt 1966 · S/N 17255152 N1759FOklahoma Flight Academy LLC · Owasso, OKBuilt 1966 · S/N 17255154 N1760FPark Rapids Avionics Inc · Park Rapids, MNBuilt 1966 · S/N 17255155 N1761FTuttle Trent · Deforest, WIS/N 17255156 N1765FKohler Daniel J · Mapleton, ORS/N 17255160 N1772FTia Aviation LLC · Hot Springs, ARBuilt 1966 · S/N 17255167 N1773FRegistration Pending · Jasper, ALRegistration pendingBuilt 1966 · S/N 17255168 N1774FBarnstormers Aero Services Inc · Lompoc, CABuilt 1966 · S/N 17255169 N1778FBlake Brian R · Irvine, CABuilt 1966 · S/N 17255173 N1782FCfi Care Inc · Woodbury, CTS/N 17255177

Back to Cessna 172H