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.

N8311UVendetta Consulting LLC · Bellevue, NEBuilt 1964 · S/N 17252211 N8312URowe John R · Stevens Point, WIBuilt 1964 · S/N 17252212 N8314USchmidt Roger W · Wood River, NEBuilt 1964 · S/N 17252214 N8317URiver International LLC · Orlando, FLS/N 17252217 N8318UBeattie Steven K · Colville, WABuilt 1964 · S/N 17252218 N8321UBoss Bradley J · Clarksville, TNBuilt 1964 · S/N 17252221 N8322UBurkett Kevin H · Portland, TXBuilt 1964 · S/N 17252222 N8323UFortman Steven W · Minneapolis, MNBuilt 1964 · S/N 17252223 N8325UCross Dustin · Tonto Basin, AZBuilt 1964 · S/N 17252225 N8329UVolkman Ary D · Waunakee, WIS/N 17252229 N8332UNeeley James L · Temecula, CABuilt 1964 · S/N 17252232 N8334UBrown Matthew D · Hamptonville, NCBuilt 1964 · S/N 17252234 N8335UFaour Douglas M · Macon, GABuilt 1964 · S/N 17252235 N8337UHaeffner Christopher M · Saint Peters, MOBuilt 1964 · S/N 17252237 N8338USchnell Brothers Aviation LLC · Kalispell, MTBuilt 1964 · S/N 17252238 N8339UDrouet Douglas T · Eugene, ORBuilt 1964 · S/N 17252239 N8345U45u Leasing LLC · Beavercreek, OHBuilt 1964 · S/N 17252245 N8347ULeupp Matthew C · Canal Winchester, OHS/N 17252247 N8349UMassey Jay C · Mineral Wells, TXBuilt 1964 · S/N 17252249 N8350UColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17252250 N8351URappa Colin C · Nazareth, PAS/N 17252251 N8352UVirani Shamshuddin · Fayetteville, GAS/N 17252252 N8354UErvin Jerome · Lometa, TXBuilt 1964 · S/N 17252254 N8356UKolb Austin R · Phoenixville, PABuilt 1964 · S/N 17252256 N8358UN8358u LLC · Knoxville, IABuilt 1964 · S/N 17252258 N8359UMusgrove Stacy J · Cunningham, TXS/N 17252259 N8361UBoss Gary W · Bronston, KYS/N 17252261 N8362UJohnson Scott T · Delta, UTS/N 17252262 N8363URagsdale Gregory · Peoria, AZS/N 17252263 N8364UElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1964 · S/N 17252264 N8365UHunt Ellwood M · Texarkana, TXBuilt 1964 · S/N 17252265 N8366UHob Aero Inc · Freeland, MIBuilt 1964 · S/N 17252266 N8367UTb Maintenance And Cleaning LLC · Deltona, FLBuilt 1964 · S/N 17252267 N8369UCamden Aviation LLC · Lewes, DEBuilt 1964 · S/N 17252269 N8370USimonsen Joshua A · White Salmon, WABuilt 1964 · S/N 17252270 N8373UKramer Mark S · Branchburg, NJBuilt 1964 · S/N 17252273 N8380UTrp Enterprises Inc · Mocksville, NCBuilt 1965 · S/N 17252280 N8381UFuryious Aviation LLC · Bossier City, LABuilt 1964 · S/N 17252281 N8383UBuzby Justin T · Wasilla, AKBuilt 1964 · S/N 17252283 N8387URegistered aircraftBuilt 1964 · S/N 17252287 N8392URegistered aircraftBuilt 1964 · S/N 17252292 N8398UAdrenaline Junkies LLC · Richfield, UTBuilt 1964 · S/N 17252298 N8401UMorales Jerardo S · Belleville, ILBuilt 1964 · S/N 17252301 N8402UWj Rothwell Ranch Co · Hyannis, NEBuilt 1964 · S/N 17252302 N8403UAnderson Larry L · Silver City, NMBuilt 1964 · S/N 17252303 N8404UAviation Career Enrichment Inc · Atlanta, GABuilt 1964 · S/N 17252304 N8406UGrzincich Michael J · Coon Rapids, MNBuilt 1964 · S/N 17252306 N8408UMastey Patrick R · Saint Cloud, MNS/N 17252308 N8410UMcbride Robert D · Buffalo, WYBuilt 1964 · S/N 17252310 N8411UNeu Aviation LLC · Benton, LABuilt 1964 · S/N 17252311

Back to Cessna 172F