Skip to content

Registered aircraft · 718

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

N8412U8 For 9 LLC · Scotia, NYBuilt 1965 · S/N 17252312 N8414UHanan Rose R · Arcata, CABuilt 1964 · S/N 17252314 N8415Marcy Arthur W · Appleton, WIBuilt 1964 · S/N 17252315 N8416UKing J Boyd · Snover, MIBuilt 1964 · S/N 17252316 N8417UPeninsula Aero Technology Inc · Kenai, AKBuilt 1964 · S/N 17252317 N8419USweeney Building Co · Lakeview, ORS/N 17252319 N8421USky Falcon LLC · Syracuse, NYS/N 17252321 N8427UCoulombe Michael J · Lunenburg, MABuilt 1964 · S/N 17252327 N8429UHomrich Paul R · Maybee, MIBuilt 1964 · S/N 17252329 N8431UNelson Burton · Cookeville, TNBuilt 1964 · S/N 17252331 N8432UHesse Paul W · Oxford, NCBuilt 1964 · S/N 17252332 N8434UJwa Flight School LLC · Bolingbrook, ILS/N 17252334 N8436UClinton Aviation Corp · Clinton, ARBuilt 1964 · S/N 17252336 N8438UPomella Logan L · Sharon Springs, NYBuilt 1964 · S/N 17252338 N8439USeeliger Jeremy E · Pasco, WABuilt 1964 · S/N 17252339 N8443UNapieralski Todd Allan · Chelsea, MIS/N 17252343 N8448UGillis Christopher Paul · Fredericksburg, VABuilt 1964 · S/N 17252348 N8450UJust-Plane-Fun LLC · Searcy, ARBuilt 1964 · S/N 17252350 N8452UGibson Gregory I · Ivel, KYS/N 17252352 N8453USappah Guy · Lusby, MDBuilt 1964 · S/N 17252353 N8455UOverton James D · Midland, TXBuilt 1964 · S/N 17252355 N8457UMcclure Garnet J · Frankston, TXBuilt 1964 · S/N 17252357 N8459ULucci Giacinto A · Nashville, MIS/N 17252359 N8463UDixon Steven M · Waynesboro, GABuilt 1964 · S/N 17252363 N8464UOrmat Glenn · Wakarusa, INS/N 17252364 N8467USkyhawk Aviators LLC · Clayton, WAS/N 17252367 N8468UWarne Cory S · Granbury, TXBuilt 1964 · S/N 17252368 N8469UTaylor Aviation Inc · Fort Benton, MTBuilt 1964 · S/N 17252369 N8470UEagle Sky Patrol · Deadwood, SDBuilt 1964 · S/N 17252370 N8473UGerding Timothy A · Philomath, ORBuilt 1964 · S/N 17252373 N8475UEec Group LLC · Kalispell, MTBuilt 1964 · S/N 17252375 N8476USmith Gordon J · Manhattan, KSBuilt 1964 · S/N 17252376 N8477UHart Robert M · Champaign, ILBuilt 1964 · S/N 17252377 N8478URig Aviation LLC · Troy, VABuilt 1964 · S/N 17252378 N8480UPeterson Ronald G · Mora, MNFirst renewal noticeBuilt 1964 · S/N 17252380 N8481UThree Rivers Aero LLC · Three Rivers, MIBuilt 1964 · S/N 17252381 N8483UWilson Aviation LLC · Lamar, MOBuilt 1964 · S/N 17252383 N8484UFarrah Gabriel E · Avon, CTBuilt 1964 · S/N 17252384 N8487UOwens Ben E Jr · Jonesboro, ARBuilt 1964 · S/N 17252387 N8490ULemons Mary A · Conner, MTBuilt 1964 · S/N 17252390 N8491URegistration Pending · Garrettsville, OHRegistration pendingBuilt 1964 · S/N 17252391 N8496UChandler Donald M · Alexandria, LABuilt 1964 · S/N 17252396 N8497URawlins Flying Club Inc · Rawlins, WYBuilt 1964 · S/N 17252397 N8501UOverbaugh Gary R · Highland, UTBuilt 1964 · S/N 17252401 N8502USmitty 172 LLC · Rockford, MIBuilt 1964 · S/N 17252402 N8504UDoug & Holly Harmon Inc · Fremont, MIBuilt 1964 · S/N 17252404 N8505USilverman Phillip E Trustee · Fullerton, CABuilt 1964 · S/N 17252405 N8508UEspinosa Isaac · Kissimmee, FLBuilt 1964 · S/N 17252408 N8510UTds Property Holdings LLC · Gilmer, TXBuilt 1964 · S/N 17252410 N8514UDyck Johan · Key Largo, FLBuilt 1964 · S/N 17252414

Back to Cessna 172F