Skip to content

Registered aircraft · 1,805

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

N8611BCrider Raymond K · Swifton, ARS/N 36311 N8612BRichards Lyle · San Diego, CABuilt 1957 · S/N 36312 N8613BGrieve David A · Sebastopol, CABuilt 1957 · S/N 36313 N8616BStewart Joel · Albany, NYBuilt 1957 · S/N 36316 N8618BRegistration Pending · Nacogdoches, TXRegistration pendingBuilt 1957 · S/N 36318 N8619BBasham James L · Livingston, TXBuilt 1957 · S/N 36319 N8621BMcmillan Thomas J · Milburn, NEBuilt 1957 · S/N 36321 N8628BScarcella Joseph A · Redlands, CAS/N 36328 N8633BPrigmore Phillip M · Alva, OKBuilt 1957 · S/N 36333 N8635BShafik Mohammed · Las Vegas, NVS/N 36335 N8636BFisher'S Crop Care By Air LLC · Fredericktown, OHS/N 36336 N8642BCommercial National Flooring Inc · New Carlisle, OHBuilt 1957 · S/N 36342 N8644BUavionix Corp · Bigfork, MTBuilt 1957 · S/N 36344 N8650BKing Kenneth M · Charleston, SCBuilt 1957 · S/N 36350 N8655BFredrickson Sherman E Jr · Norman, OKBuilt 1957 · S/N 36355 N8660BNaramore Tyler R · Salem, MOBuilt 1957 · S/N 36360 N8661BBottorf Benjamin R · Springfield, ILS/N 36361 N8662BPark Arthur N · College Park, GABuilt 1957 · S/N 36362 N8664BBoyer Cal A · Cleona, PABuilt 1957 · S/N 36364 N8666BHultquist Casey D · Anchorage, AKS/N 36366 N8667BHaingray Donald F · Houghton, NYBuilt 1957 · S/N 36367 N8668BFriesen Conrad · Lott, TXBuilt 1957 · S/N 36368 N8671BBoas Edward E Jr · Chesapeake City, MDBuilt 1957 · S/N 36371 N8672BVolker Bradley B · Rice Lake, WIBuilt 1957 · S/N 36372 N8675BMountain Express LLC · Haines City, FLBuilt 1957 · S/N 36375 N8680BGabelli Alfred R · Grand Junction, COBuilt 1957 · S/N 36380 N8686BMcknight Thomas N · Fredericksburg, TXBuilt 1957 · S/N 36386 N8687BSelf Aviation LLC · Hayden, IDBuilt 1957 · S/N 36387 N8688BRegistered aircraftBuilt 1957 · S/N 36388 N8689BTeynor Jason J · Ontario, WIBuilt 1957 · S/N 36389 N8691BHeller Teena · Granbury, TXBuilt 1957 · S/N 36391 N8692BCogan Walter J Jr · Shelter Island, NYBuilt 1957 · S/N 36392 N8694BMiller Jason M · Eaton, OHBuilt 1957 · S/N 36394 N8697BHillis Gary D · Brookland, ARBuilt 1957 · S/N 36397 N8700BWall Bernardo · Seminole, TXS/N 36400 N8702BHill Thomas Gerald · Port Tobacco, MDBuilt 1957 · S/N 36402 N8705BCarney David M · Mc Allister, MTS/N 36405 N8706BCox Robert D · Caldwell, IDBuilt 1957 · S/N 36406 N8707BEmblom Donald B · Hackensack, MNBuilt 1957 · S/N 36407 N8709BBaldwin Steve · Lawson, MOBuilt 1957 · S/N 36409 N8711BHubert Gregory D · Charles Town, WVBuilt 1957 · S/N 36411 N8715BSchultz John J · Kenai, AKS/N 36415 N8717BNorsic Michael · Parma, OHBuilt 1957 · S/N 36417 N8719BSale Reported · Westerville, NESale reported, canceledS/N 36419 N8722BBuell Jack A · St Maries, IDBuilt 1957 · S/N 36422 N8724BMcmahon William · Westville, INS/N 36424 N8726BEckles Phillip · Holdenville, OKBuilt 1957 · S/N 36426 N8729BChristian Melvin Lee Jr · Apison, TNBuilt 1957 · S/N 36429 N8736BCampbell Jack G · Spring Valley, WIBuilt 1957 · S/N 36436 N8737BFranklin Rodney S · Burns, ORBuilt 1957 · S/N 36437

Back to Cessna 172