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.

N2503ARegistered aircraftS/N 17249930 N2503YGutierrez Gilberto · Lindsay, CAS/N 17249803 N2505YGauges Green LLC · Euless, TXS/N 17249805 N2506USterling John A · Port Lavaca, TXBuilt 1963 · S/N 17250106 N2506YTouching Clouds LLC · Bridgeview, ILBuilt 1962 · S/N 17249806 N2507YGap Mountain Development LLC · Jaffrey, NHBuilt 1962 · S/N 17249807 N2508YWarren Jerry L · Medford, ORS/N 17249808 N2509USnyder Mari A · Brighton, COBuilt 1963 · S/N 17250109 N2509YAgha-Khan Sikander B · Carolina Shores, NCBuilt 1962 · S/N 17249809 N2512UNative Sons Aviation LLC · Lake Placid, FLBuilt 1963 · S/N 17250112 N2513YWilson Hubert Ernest · Gustavus, AKBuilt 1962 · S/N 17249813 N2514UHenson David C · Fort Worth, TXBuilt 1963 · S/N 17250114 N2514YBargabos Julie A · Peterboro, NYBuilt 1962 · S/N 17249814 N2516ULofton Johnathan V · Springer, OKBuilt 1963 · S/N 17250116 N2516YSchutjer Dennis · Clear Lake, IABuilt 1962 · S/N 17249816 N2517YEbnet Joel · Holdingford, MNBuilt 1962 · S/N 17249817 N2518YTracy Michael S · Homer, AKBuilt 1962 · S/N 17249818 N2519UBradford Murvin L · Hensley, ARS/N 17250119 N2521YClanin James Robert · Vandalia, OHBuilt 1962 · S/N 17249821 N2522WHollenbeck William M · Montrose, COS/N 17250128 N2523YLawson Matt E · Gobles, MIBuilt 1962 · S/N 17249823 N2524YPaul Danny W · Locust Grove, GABuilt 1962 · S/N 17249824 N2526YJahnke Ryan M · Grafton, WIBuilt 1962 · S/N 17249826 N2527YSuazo Tito L · Glendale, AZBuilt 1962 · S/N 17249827 N2528YHock Adam · Ankeny, IABuilt 1962 · S/N 17249828 N2529UCampbell Alto L III · Pike Road, ALBuilt 1963 · S/N 17250129 N252JMMccallister Billy G · Virginia Beach, VABuilt 1963 · S/N 17250277 N2530YHarbour William T Jr · Mobile, ALBuilt 1962 · S/N 17249830 N2532UMills Randall J · Monroe, MIBuilt 1963 · S/N 17250132 N2532YBatie Gregory T · Rogers, ARBuilt 1962 · S/N 17249832 N2534YTorres Gerardo · Gurabo, PRBuilt 1962 · S/N 17249834 N2535YFleck Timothy · Hurst, TXBuilt 1962 · S/N 17249835 N2536UNeal Tommy G · Sulphur Springs, TXBuilt 1963 · S/N 17250136 N2538UHall Chad B · Baytown, TXBuilt 1963 · S/N 17250138 N2538YChapman James Tod · Portland, ORBuilt 1962 · S/N 17249838 N2539ULoes Todd A · Waterloo, IABuilt 1963 · S/N 17250139 N2539YOly LLC · Onida, SDBuilt 1962 · S/N 17249839 N2542UDoak Ronald E · Reno, NVBuilt 1963 · S/N 17250142 N2544YChristianson Cleet M · Enumclaw, WABuilt 1962 · S/N 17249844 N2546YAvquest LLC · Jonesboro, ARBuilt 1962 · S/N 17249846 N2547UCostanzo Richard L · Toms River, NJBuilt 1963 · S/N 17250147 N2548UAlt Alexander B · Lockport, NYBuilt 1963 · S/N 17250148 N2548YColbert Robert R · Oroville, WABuilt 1962 · S/N 17249848 N2549YHerlihy Douglas · Denville, NJBuilt 1962 · S/N 17249849 N2554UMustang Ops LLC · Orem, UTBuilt 1963 · S/N 17250154 N2555UBurull Donald E · Wichita, KSBuilt 1963 · S/N 17250155 N2556YZeafla Randall R · Elizabethtown, KYBuilt 1962 · S/N 17249856 N2557UWings Of Hope · Chesterfield, MOBuilt 1963 · S/N 17250157 N2557YSaddle Mountain LLC · Cave Creek, AZBuilt 1962 · S/N 17249857 N2558UDelany Patrick J · Marion, TXBuilt 1963 · S/N 17250158

Back to Cessna 172D