Skip to content

Registered aircraft · 718

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

N5574RStrong Thomas E · Jefferson, GABuilt 1965 · S/N 17253170 N5578RSmith Robert G Jr · High Point, NCBuilt 1965 · S/N 17253176 N5579RAndress Ronald H · Bloomsburg, PABuilt 1965 · S/N 17253177 N5580RN5580r LLC · Summerville, SCBuilt 1965 · S/N 17253179 N5581RCousins Aviation Inc · Birmingham, MIS/N 17253180 N5586RKakkar Sunit · Buena Park, CABuilt 1965 · S/N 17253187 N5589RKern Eric M · Wesley Chapel, FLBuilt 1965 · S/N 17253191 N5592RAbbott Cedric M · Buckfield, MEBuilt 1965 · S/N 17253196 N5593RMaddox Tracey A · Adamsville, TNBuilt 1965 · S/N 17253197 N5595RTailwind Enterprises LLC · Edwardsville, ILBuilt 1965 · S/N 17253200 N5596RRegistration Pending · Crossville, TNRegistration pendingBuilt 1965 · S/N 17253201 N5597RStevens Daniel T · Trenton, MOBuilt 1965 · S/N 17253202 N5598RCross Brian K · Winters, CABuilt 1965 · S/N 17253204 N5600RBreland Gerald Monroe Sr · Bogalusa, LABuilt 1965 · S/N 17253207 N5603RRegistered aircraftBuilt 1965 · S/N 17253211 N5604RSkunda Robert J · Hebron, OHBuilt 1965 · S/N 17253213 N5605RCostello John M · Wichita, KSBuilt 1965 · S/N 17253214 N5611RNordell Louis W · Watervliet, MIBuilt 1965 · S/N 17253222 N5612RLoerke James S · John Day, ORBuilt 1965 · S/N 17253224 N5615RWittrock Thomas L · Wiota, IABuilt 1965 · S/N 17253228 N5618RMiller Richard L · Tipp City, OHFirst renewal noticeBuilt 1965 · S/N 17253232 N5620RVandeven Avery D · Saint Joseph, LABuilt 1965 · S/N 17253235 N5621RSale Reported · Genoa, WVSale reported, canceledBuilt 1965 · S/N 17253236 N5622RKv Enterprises LLC · Kalispell, MTBuilt 1965 · S/N 17253238 N5627RBitikofer Brent E · Kansas City, KSBuilt 1965 · S/N 17253245 N5628RKellam Garnett A · Mappsville, VABuilt 1965 · S/N 17253247 N5629RSadie Hawk Aviation LLC · Collinsville, CTBuilt 1965 · S/N 17253248 N5630RLanas Flying Machine LLC · Hollywood, FLBuilt 1965 · S/N 17253249 N5633RBirds Eye View LLC · Nampa, IDBuilt 1965 · S/N 17253253 N5636RSkyhawk Aviation LLC · Ogden, UTBuilt 1965 · S/N 17253258 N5638RBurkhart Andrew · Toccoa, GABuilt 1965 · S/N 17253261 N5639RKeith L S · Forestburg, TXBuilt 1965 · S/N 17253262 N5640RUnruh Jerel W · Versailles, MOBuilt 1965 · S/N 17253264 N5641REaton Samuel D · Clinton, PABuilt 1965 · S/N 17253265 N5642RMatheny Roger P · Humble, TXBuilt 1965 · S/N 17253266 N5644RShaffer Mark J · Porterfield, WIBuilt 1965 · S/N 17253269 N5645RGecha Brian S · Brandon, VTBuilt 1965 · S/N 17253270 N5646RAumack Bryant D · Melbourne, FLBuilt 1965 · S/N 17253272 N5648RKurtz Richard G · Ithaca, NYS/N 17253275 N5651RChickasha Wings Inc · Chickasha, OKBuilt 1965 · S/N 17253279 N5654RSudbrink Charles D · Willet, NYS/N 17253283 N5657RFord Darryl · Caldwell, IDBuilt 1965 · S/N 17253287 N5658REilers Scott D · Amissville, VABuilt 1965 · S/N 17253289 N5660RSpirit Hills Ranch LLC · Belgrade, MTBuilt 1965 · S/N 17253292 N5665RLimmer Rita G · Redding, CABuilt 1965 · S/N 17253299 N5666RSport Flying USA Inc · Ronkonkoma, NYBuilt 1965 · S/N 17253300 N5667RBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1965 · S/N 17253302 N5669RBeasley Marty J · Statesboro, GABuilt 1965 · S/N 17253304 N5674RSpellman Mark · Novi, MIBuilt 1965 · S/N 17253312 N5675RN5675r Corp · Rochester, NYBuilt 1965 · S/N 17253313

Back to Cessna 172F