Skip to content

Registered aircraft · 781

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

N3240LWooden Alan L · Signal Mountain, TNBuilt 1967 · S/N 17256140 N3241LDostroph Manfred J · Lewis Center, OHBuilt 1967 · S/N 17256141 N3244LKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1967 · S/N 17256144 N3245LGift Academy Inc · Vernon, TXBuilt 1967 · S/N 17256145 N3246LStephens David J · Clarence, NYBuilt 1967 · S/N 17256146 N3250LMiner Jess L · Emmet, NEBuilt 1967 · S/N 17256150 N3251LWiles David A · Ozark, ARBuilt 1967 · S/N 17256151 N3252LElizabethton Aerobatic Club Inc · Elizabethton, TNS/N 17256152 N3254CCoon Vernon Ray · Atmore, ALBuilt 1967 · S/N 17256156 N3254LSelby Thomas A · Fenton, MIBuilt 1967 · S/N 17256154 N3255LPatton Steven W · Fayetteville, ARS/N 17256155 N3257LBeene Jerry · Bulverde, TXBuilt 1967 · S/N 17256157 N3260LHerring Rhett H · College Station, TXBuilt 1967 · S/N 17256160 N3262LKd3262 LLC · Downers Grove, ILBuilt 1967 · S/N 17256162 N3263LSale Reported · Arcata, CASale reportedBuilt 1967 · S/N 17256163 N3266LWolverine LLC · Roanoke, VABuilt 1967 · S/N 17256166 N3267LBetter Fly Inc · Litchfield, ILS/N 17256167 N3271LHenson Raul Andre · Fox Island, WABuilt 1967 · S/N 17256171 N3274LHk Ventures LLC · Paynesville, MNS/N 17256174 N3275LMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 17256175 N3277LDeshpande Peter N · Eugene, ORBuilt 1967 · S/N 17256177 N3278LPeterson Donald A · Ajo, AZBuilt 1967 · S/N 17256178 N3279LDomnarski Michael J · Ware, MABuilt 1967 · S/N 17256179 N3280LDobbertin Thomas E · Redlands, CAS/N 17256180 N3281LWizna LLC · Boca Raton, FLBuilt 1967 · S/N 17256181 N3282LFranco David F Jr · Santa Rosa, CABuilt 1967 · S/N 17256182 N3283LHill Suzanne L · Edmond, OKBuilt 1967 · S/N 17256183 N3284LWill Clifford S · Grayson, GABuilt 1967 · S/N 17256184 N3285LDouglass Grant · Rockport, TXBuilt 1967 · S/N 17256185 N3286LEagle Eye Aviation LLC · Meridian, IDBuilt 1967 · S/N 17256186 N3291LSun Baron · Arcadia, CABuilt 1967 · S/N 17256191 N3297LRaymond Patrick H · Jerseyville, ILBuilt 1967 · S/N 17256197 N3298LThompson Edward E · Buxton, MEBuilt 1967 · S/N 17256198 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N3704FBrzezinski Samuel M · Boyceville, WIS/N 17255199 N3707RHartsfield Amy G · Pace, FLBuilt 1966 · S/N 17255507 N3708RNeufeld Henry F · Brownfield, TXBuilt 1966 · S/N 17255508 N3709FWeaver Jerry T Jr Trustee · Anchorage, AKBuilt 1966 · S/N 17255204 N3709RBaillie Stephen H · Flint, MIBuilt 1966 · S/N 17255509 N3710FDavis Charles Arthur Wesley · Petersburg, AKS/N 17255205 N3711FMission Aviation Training Academy · Arlington, WABuilt 1966 · S/N 17255206 N3713FDavis Jeffery S · Oregon City, ORBuilt 1966 · S/N 17255208 N3713RTroglio Joseph A · Peoria, ILBuilt 1966 · S/N 17255513 N3714FSwearengen Sally · Tunica, MSBuilt 1966 · S/N 17255209 N3715RFriederich Claudio T · Honolulu, HIBuilt 1966 · S/N 17255515 N3717FLake Area Technical College · Watertown, SDBuilt 1966 · S/N 17255212 N371SRHurt David · Shallotte, NCBuilt 1966 · S/N 17256111 N3720FRegistration Pending · Chantilly, VARegistration pendingBuilt 1966 · S/N 17255215 N3721RMoran William J · Keller, TXBuilt 1966 · S/N 17255521 N3722FHutchinson Flying Club LLC · Freeman, SDBuilt 1966 · S/N 17255217

Back to Cessna 172H