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.

N2388URay Charlie B · Prosser, WABuilt 1963 · S/N 17249988 N2389UAllworth Ruger · Wapello, IABuilt 1962 · S/N 17249989 N2390UKuhn Jacob H · Bloomer, WIBuilt 1962 · S/N 17249990 N2395UBucher Sheldon L · Divide, COBuilt 1962 · S/N 17249995 N2400YClark Nikita C · Ontario, ORFirst renewal noticeBuilt 1962 · S/N 17249700 N2401YBeauchamp William J · Rigby, IDBuilt 1962 · S/N 17249701 N2403UFloyd Carson K · Elberton, GABuilt 1962 · S/N 17250003 N2403YLarkin Timothy J · Pearland, TXBuilt 1962 · S/N 17249703 N2404YRegistration Pending · Rexburg, IDRegistration pending, pending cancellationBuilt 1962 · S/N 17249704 N2407UFrancis Ronald · Fredericktown, MOBuilt 1963 · S/N 17250007 N2410UYellow Breast Aviation LLC · Christiansted, VIS/N 17250010 N2411USiemens Jonathan Lee · Seminole, TXBuilt 1963 · S/N 17250011 N2411YMullings Michael A · Orange, NJBuilt 1962 · S/N 17249711 N2412UHill Brock E · Palouse, WABuilt 1963 · S/N 17250012 N2413UAmazon Aero Corp · Wilmington, DES/N 17250013 N2413YRegistration Pending · Bangor, MERegistration pendingS/N 17249713 N2414URozell Wallace R · Argyle, TXBuilt 1963 · S/N 17250014 N2414YHigh Flight LLC · Casey, ILBuilt 1962 · S/N 17249714 N2416USzabo Stephen A · Sacramento, CABuilt 1963 · S/N 17250016 N2418UGronning Chris D · Anchorage, AKBuilt 1963 · S/N 17250018 N2419YBaker Adam W · Germantown, TNBuilt 1962 · S/N 17249719 N2420UAylmer Debra L · Black Creek, GABuilt 1963 · S/N 17250020 N2421UWiney Jonathan · Michigan City, INS/N 17250021 N2421YAzflygal LLC · Phoenix, AZS/N 17249721 N2423UChord Line LLC · Homer, AKBuilt 1963 · S/N 17250023 N2423YStevens Mark E · Virgilina, VABuilt 1962 · S/N 17249723 N2424YBeek Nigel A · Pembroke Pines, FLBuilt 1962 · S/N 17249724 N2426UMartin Odis Bruce · Whitney, TXBuilt 1963 · S/N 17250026 N2426YShamrock Flying Club Inc · Millersville, PABuilt 1962 · S/N 17249726 N2427YGreen Terry W · Binger, OKFirst renewal noticeS/N 17249727 N2428YYellen Mark A · Mohave Valley, AZBuilt 1962 · S/N 17249728 N2429UNorman Jon Frederic Jr · Pineville, LABuilt 1963 · S/N 17250029 N2429YTucker Robert A · Kingston, OHBuilt 1962 · S/N 17249729 N2430UWarnaka Brian Justin · The Villages, FLBuilt 1963 · S/N 17250030 N2431UJackson Robert W · Bridgeport, TXBuilt 1963 · S/N 17250031 N2433YWheeler Dean S · Lebanon, ORS/N 17249733 N2434USkyhawk N2434u LLC · Wilmington, DEBuilt 1963 · S/N 17250034 N2435UGalati Stephen E · Florissant, MOBuilt 1963 · S/N 17250035 N2437YRussell John D · Dana Point, CABuilt 1962 · S/N 17249737 N2438UThweatt Greg K · Lodi, CABuilt 1963 · S/N 17250038 N2438YHoskins Aaron C · Cayuga, NYBuilt 1962 · S/N 17249738 N2439USmith Steven T · Charlottesville, VABuilt 1963 · S/N 17250039 N2439YBluegate Engineering LLC · Richburg, SCBuilt 1962 · S/N 17249739 N2440UMiller Patrick · Madison, MNBuilt 1963 · S/N 17250040 N2440YMorristown Flying Service Inc · Talbott, TNBuilt 1962 · S/N 17249740 N2443UIntream Companies LLC · Perryville, MOBuilt 1963 · S/N 17250043 N2444YConrad Matthew J · Dardenne Prairie, MOBuilt 1962 · S/N 17249744 N2445UPeachey Jason J · Milroy, PABuilt 1963 · S/N 17250045 N2445YNew England Aircraft Detailing LLC · Webster, MAS/N 17249745 N2446YMcmickle Edward R · Riverside, CAS/N 17249746

Back to Cessna 172D