Skip to content

Registered aircraft · 471

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

N2559USnake River Flying Club LLC · Horseshoe Bend, IDBuilt 1963 · S/N 17250159 N2559YA & D Precision Machining Inc · Fremont, CAS/N 17249859 N2560USpangenberg Daniel M · Greenville, MIBuilt 1963 · S/N 17250160 N2561UNeinast Jeffrey J · Olton, TXBuilt 1963 · S/N 17250161 N2564UBurris Bruce · Deer Park, WAS/N 17250164 N2564YBrewer George H · Muskegon, MIBuilt 1962 · S/N 17249864 N2566YAns Aircraft LLC · Midland, TXS/N 17249866 N2567URegistration Pending · Fort Worth, TXRegistration pendingBuilt 1963 · S/N 17250167 N2568ULuce Mark E · Tucson, AZBuilt 1963 · S/N 17250168 N2569UHalladay Roy · Erie, COBuilt 1963 · S/N 17250169 N2574Y9th Moon Enterprises LLC · Alpine, TXS/N 17249874 N2575YSky Unlimited · Portland, ORBuilt 1962 · S/N 17249875 N2576YRowe John W · Glen Haven, COBuilt 1962 · S/N 17249876 N2578YBush James W · Skaneateles, NYBuilt 1962 · S/N 17249878 N2579UHann Aviation LLC · Yuma, AZBuilt 1963 · S/N 17250179 N2581YOverman Aviation LLC · Saint Louis, MOS/N 17249881 N2583UUfly Vi LLC · St Thomas, VIBuilt 1963 · S/N 17250183 N2584URedd David C · Blanding, UTBuilt 1963 · S/N 17250184 N2585ULionudakis Michael A · Scotts Valley, CABuilt 1963 · S/N 17250185 N2586UMaynor Roy · Brazoria, TXS/N 17250186 N2587UEt Flight LLC · Cedar Park, TXBuilt 1963 · S/N 17250187 N2589YOrtner Airport LLC · Wakeman, OHBuilt 1962 · S/N 17249889 N2593UCamara Cesar David · Plumas Lake, CABuilt 1963 · S/N 17250193 N2594YBruns John R Jr Trustee · Floyds Knobs, INBuilt 1963 · S/N 17249894 N2595UHare Sidney Wiggins · Roanoke, ALBuilt 1963 · S/N 17250195 N2595YRenco Angelo · Oceanside, CAFirst renewal noticeBuilt 1962 · S/N 17249895 N2598YHarding William R Jr · Quinlan, TXBuilt 1963 · S/N 17249898 N2599YTalmadge Robert E · Vero Beach, FLBuilt 1962 · S/N 17249899 N2601UK D Helicopters Inc · Shingleton, MIBuilt 1963 · S/N 17250201 N2602UVan Zee Charles C · Rancho Cucamonga, CABuilt 1963 · S/N 17250202 N2604UTalboy Theodore Neal · Lathrop, CABuilt 1963 · S/N 17250204 N2612UNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17250212 N2613UHill Richard W · Salem, ORBuilt 1963 · S/N 17250213 N2618UOubari Hesham D · Suffolk, VABuilt 1963 · S/N 17250218 N2619UChase Joshua R · Princeton, MNBuilt 1963 · S/N 17250219 N261SEGapen Patrice Marie · Cheyenne, WYBuilt 1962 · S/N 17249852 N2622UComos Gregg J · West Palm Beach, FLBuilt 1963 · S/N 17250222 N2624UGillespie Richard L · Beaver Island, MIBuilt 1963 · S/N 17250224 N2625URogers James F III · Dover, NHBuilt 1963 · S/N 17250225 N2626UFarren Jake J · Eagle River, AKBuilt 1963 · S/N 17250226 N2628UMiranda Jason G · Utica, OHBuilt 1963 · S/N 17250228 N2634UCoolaire LLC · Boerne, TXBuilt 1963 · S/N 17250234 N2637UMarks Charles A III · Apalachicola, FLBuilt 1963 · S/N 17250237 N2640USealey Gary W · Saint Pauls, NCBuilt 1963 · S/N 17250240 N2643UGaring Gerald R · Schenectady, NYBuilt 1963 · S/N 17250243 N2646UEarly Patricia A · Palmyra, PABuilt 1963 · S/N 17250246 N2648URock Kenneth L · Petersburg, AKBuilt 1963 · S/N 17250248 N2649UMorrison Kent · Mccleary, WAFirst renewal noticeBuilt 1963 · S/N 17250249 N2653UClark Nikita C · Ontario, ORS/N 17250253 N2657USzymanski Janet M · Alanson, MIBuilt 1963 · S/N 17250257

Back to Cessna 172D