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.

N2760UAnderson Justin Charles · Rockingham, NCS/N 17250360 N2761UShafer Luke M · Wyoming, ILBuilt 1963 · S/N 17250361 N2762UCapozzi Rocky P · Eagle River, AKBuilt 1963 · S/N 17250362 N2763UKnutson Wayne R · Tioga, NDBuilt 1963 · S/N 17250363 N2764UWells Dave · Nampa, IDBuilt 1963 · S/N 17250364 N2767UFisher James S · Texarkana, TXBuilt 1963 · S/N 17250367 N2769UMckinney Edward L · Candler, NCFirst renewal noticeBuilt 1963 · S/N 17250369 N2770UStandard Equipment Leasing And Sales LLC · Wilmington, DEBuilt 1963 · S/N 17250370 N2771UTobin Eric L · Cambridge, OHBuilt 1963 · S/N 17250371 N2775ULuff John W · Odessa, MOBuilt 1963 · S/N 17250375 N2776UGarrison Randy · Queen City, TXBuilt 1963 · S/N 17250376 N2778URoberts Kenneth B · Wall Township, NJBuilt 1963 · S/N 17250378 N2782UFrazier Doris C · Keller, TXBuilt 1963 · S/N 17250382 N2784UCobb Robert · Elberton, GAS/N 17250384 N2785UN2785u LLC · Hilton, NYBuilt 1963 · S/N 17250385 N2786UBoos Daniel Paul · Jackson, WYBuilt 1963 · S/N 17250386 N2787UNethery Autumn M · Shelbyville, KYBuilt 1963 · S/N 17250387 N2789UKruse Russell E Jr · Siren, WIBuilt 1963 · S/N 17250389 N2795URichardson Robert S · Austin, TXBuilt 1963 · S/N 17250395 N2799UWinslow Linda S Trustee · Creswell, ORS/N 17250399 N2800UFAA LLC · Big Lake, AKBuilt 1963 · S/N 17250400 N2801UDallas Flying Associates Inc · Dallas, TXBuilt 1963 · S/N 17250401 N2802UPatterson Bud N · Perry, OKBuilt 1963 · S/N 17250402 N2803USwan Aviation Ministries Inc · Laurel Hill, FLS/N 17250403 N2805UContinental Skylarks Inc · Deer Park, NYBuilt 1963 · S/N 17250405 N2806UWeeber Charles · Pelham, MABuilt 1963 · S/N 17250406 N2807UMeese Brian D · Conroe, TXBuilt 1963 · S/N 17250407 N2809UBleskan Erick J · New Berlin, WIBuilt 1963 · S/N 17250409 N2810UN2810u LLC · Delray Beach, FLBuilt 1963 · S/N 17250410 N2812UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250412 N2815UHarris Tony James · Stanley, NCBuilt 1963 · S/N 17250415 N2817UAero Ventures Inc · Yukon, OKBuilt 1963 · S/N 17250417 N2818UWard Jasper Eugene · Telford, TNFirst renewal noticeS/N 17250418 N2819UGartner Thomas M · Newton, KSBuilt 1963 · S/N 17250419 N2821UPelotte Raymond J · Waterville, MEBuilt 1963 · S/N 17250421 N2823UPowell Mark J · Chelsea, MIBuilt 1963 · S/N 17250423 N2826UJohnson James E · College Station, TXBuilt 1963 · S/N 17250426 N2831USchmidt Paul D · Whitesburg, GABuilt 1963 · S/N 17250431 N2832URegistration Pending · Wasilla, AKRegistration pendingS/N 17250432 N2836USolymanbeyk Willard · Modesto, CABuilt 1963 · S/N 17250436 N2838UCag Farms Inc · Angier, NCS/N 17250438 N2839UEttelson Michael J · New Hampton, NHBuilt 1963 · S/N 17250439 N2840UDejong Robert W · Austin, TXBuilt 1963 · S/N 17250440 N2842UDeshaies Robert · Cumberland, RIBuilt 1963 · S/N 17250442 N2843UFlite Five Inc · Kiowa, KSBuilt 1963 · S/N 17250443 N2852UWatten Sig V · Rhinelander, WIBuilt 1963 · S/N 17250452 N2854UGerbig Robert A · Gleason, WIBuilt 1963 · S/N 17250454 N2856UNguyen Trinh Kieu Thi · Jacksonville, FLBuilt 1963 · S/N 17250456 N2857UAuck Allyn L · Fort Mohave, AZBuilt 1963 · S/N 17250457 N2858UGelfius Glenn E · Dahlgren, ILBuilt 1963 · S/N 17250458

Back to Cessna 172D