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.

N2661UMoret Ronald P · Los Osos, CABuilt 1963 · S/N 17250261 N2662UDeal Sarah M · Saint Joseph, MIBuilt 1963 · S/N 17250262 N2663UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250263 N2666URegistration Pending · Decatur, TXRegistration pendingBuilt 1963 · S/N 17250266 N2668UMid South Aircraft Inc · Gadsden, ALBuilt 1963 · S/N 17250268 N2671UMetz Thomas H · Mifflintown, PABuilt 1963 · S/N 17250271 N2672UBender John Lowell Trustee · N Richland Hills, TXBuilt 1963 · S/N 17250272 N2673UBonin Patrick G · Blossvale, NYBuilt 1963 · S/N 17250273 N2675UAv Hawk Aviation LLC · Montclair, NJS/N 17250275 N2676URobinson Dalton M · Londonberry, OHS/N 17250276 N2681UOsterhaus Jonathan · Petersburg, TNBuilt 1963 · S/N 17250281 N2682UCseh Sandor · New Brunswick, NJBuilt 1963 · S/N 17250282 N2684UAnderson Robert David · Brighton, MIBuilt 1963 · S/N 17250284 N2686USzalay Jamey R · Princeton, NJBuilt 1963 · S/N 17250286 N2688UGould Martin W · Alba, TXBuilt 1963 · S/N 17250288 N2690USmith Daryn D · Billings, MTBuilt 1963 · S/N 17250290 N2691UHess Garrett J · Fullerton, CABuilt 1963 · S/N 17250291 N2693UBolden Myles · Plumas Lake, CABuilt 1963 · S/N 17250293 N2697UOharra Robert J · Buckley, WAS/N 17250297 N2699UHogue Richard L · Dos Palos, CAS/N 17250299 N2700UMinier Manuel · Kissimmee, FLS/N 17250300 N2702ULeatherwood Vaughn L · La Place, LAS/N 17250302 N2706UHoelsch Shawn C · Livermore, CABuilt 1963 · S/N 17250306 N2707UHills Holding · Newark, DEBuilt 1963 · S/N 17250307 N2710UCape Aerial Tours DBA · Chatham, MABuilt 1963 · S/N 17250310 N2713UAeronetica LLC · Tulsa, OKS/N 17250313 N2715UBelle Fourche Flight Center LLC · Belle Fourche, SDBuilt 1963 · S/N 17250315 N2717URasmussen Raleigh C · Seattle, WABuilt 1963 · S/N 17250317 N2718UBondurant Ross · Eugene, ORBuilt 1963 · S/N 17250318 N2719UVilches Armando L · Brentwood, TNBuilt 1963 · S/N 17250319 N2724UGarner Harry W · Le Roy, NYBuilt 1963 · S/N 17250324 N2726USampan Aviation LLC · Greenville, TXS/N 17250326 N2727URoy Justin C · Georgetown, OHBuilt 1963 · S/N 17250327 N2728UCatsakis Andrew W · Lovettsville, VABuilt 1963 · S/N 17250328 N2729UDenair Inc · Canandaigua, NYBuilt 1963 · S/N 17250329 N2731UKemp Gilbert A · Waterville, NYBuilt 1963 · S/N 17250331 N2732UDavenport Jimmy J · Hayesville, NCS/N 17250332 N2734URegistered aircraftBuilt 1963 · S/N 17250334 N2735UKnepper Gary E · Canby, ORBuilt 1963 · S/N 17250335 N2738UVan Der Waal Allan L · Port Angeles, WABuilt 1963 · S/N 17250338 N2739UN2739u Holding LLC · New Orleans, LABuilt 1963 · S/N 17250339 N2740UHarowicz Richard J · Mountain Top, PABuilt 1963 · S/N 17250340 N2741UNickel Aviation LLC · Williamstown, NJBuilt 1963 · S/N 17250341 N2742UPembroke Farm LLC · Conowingo, MDBuilt 1963 · S/N 17250342 N2743UArmstrong John Kyle · Lovington, NMBuilt 1963 · S/N 17250343 N2744UFladager Daryl W · Peerless, MTS/N 17250344 N2745UMidfield Aviation LLC · Caldwell, IDBuilt 1963 · S/N 17250345 N2750UMartin Maximilian · Sonora, TXBuilt 1963 · S/N 17250350 N2754UKirkpatrick Dan C · Little Rock, ARBuilt 1963 · S/N 17250354 N2757UUt Lightsport One LLC · Uintah, UTBuilt 1963 · S/N 17250357

Back to Cessna 172D