Skip to content

Registered aircraft · 617

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

N5588TMoore Robert L · Sublette, KSBuilt 1964 · S/N 17251488 N5590TGlendening Douglas W · Naples, FLS/N 17251490 N5591TNordstrom Terry G · Scottsdale, AZBuilt 1964 · S/N 17251491 N5602TBerg William J · Aberdeen, SDS/N 17251502 N5604TAndrews Jeremy R · Walker, MNBuilt 1964 · S/N 17251504 N5609TWestfall Gage T · Marietta, OKBuilt 1964 · S/N 17251509 N5611TAnderson King David · Lenexa, KSBuilt 1964 · S/N 17251511 N5612TLord David A · Mackay, IDS/N 17251512 N5613TJones Curtis DBA · Jacksonville, NCBuilt 1964 · S/N 17251513 N5614TBarnes Roger F · Oronoco, MNBuilt 1964 · S/N 17251514 N5618THildebrand Mark D · Manawa, WIBuilt 1964 · S/N 17251518 N5626TWerkman James R · Scottdale, PABuilt 1964 · S/N 17251526 N5627TSchulte Lawrence · Griffin, GAS/N 17251527 N5629T5629t LLC · Denison, TXBuilt 1964 · S/N 17251529 N5630TBolin Matthew R · Everett, WABuilt 1964 · S/N 17251530 N5632THodder Philip Michael · Houston, TXBuilt 1964 · S/N 17251532 N5636TRegistered aircraftBuilt 1964 · S/N 17251536 N5637TBarbour George E Jr · Croydon, NHBuilt 1964 · S/N 17251537 N5641TMarcy Dara Owen · Tacoma, WABuilt 1964 · S/N 17251541 N5644TScootair LLC · Alburgh, VTBuilt 1964 · S/N 17251544 N5645TJ & J Aviation Inc · Martinsville, VABuilt 1964 · S/N 17251545 N5647TJohnson Jeffri K · Brighton, COBuilt 1964 · S/N 17251547 N5648TYankton Area Aviators Inc · Crofton, NEBuilt 1964 · S/N 17251548 N564EDTilse William A · Kirkland, WABuilt 1956 · S/N 28362 N5650TWander Harry J · Nevada City, CABuilt 1964 · S/N 17251550 N5651TRegistered aircraftS/N 17251551 N5654THayes Travis · Harrisonville, MOS/N 17251554 N5659TMorgan Peter Thomas · Bellingham, WABuilt 1964 · S/N 17251559 N5660TChoose You LLC · Twin Falls, IDS/N 17251560 N5661TSingletary Kenneth W · Newman Lake, WAS/N 17251561 N5668TShattuck Shaun R Jr · Coarsegold, CABuilt 1964 · S/N 17251568 N5669TClemmons Gavin T · Hopkins, MNBuilt 1964 · S/N 17251569 N5674TPerma-Culture Inc · Dade City, FLBuilt 1964 · S/N 17251574 N5675TPhillips Michael · Thompson Falls, MTBuilt 1964 · S/N 17251575 N5679TCataneda Jose · Yakima, WAFirst renewal noticeS/N 17251579 N5683TSkydotcom LLC · Inver Grove, MNS/N 17251583 N5684TStahl Adam Charles · Fort Wainwright, AKBuilt 1964 · S/N 17251584 N5685THolland Bruce B · Mansfield, TXBuilt 1964 · S/N 17251585 N5687TSchultz Josh · Blanchard, OKBuilt 1964 · S/N 17251587 N5690TJohnson Clinton A · Haughton, LABuilt 1964 · S/N 17251590 N5691TEsterly Bryan L · Hope Mills, NCBuilt 1964 · S/N 17251591 N5695TJohnston David L · Williamsville, MOBuilt 1964 · S/N 17251595 N5704TCorrigan Stephen J · Prescott, AZS/N 17251604 N5710TLaney Charles A · Maiden, NCBuilt 1964 · S/N 17251610 N5711TColeman Darryl W · Fayetteville, GABuilt 1964 · S/N 17251611 N5712TSessoms Keith V · Seagrove, NCBuilt 1964 · S/N 17251612 N5713TSears Irwin C · Rockwall, TXBuilt 1964 · S/N 17251613 N5715TCarter James · Thornville, OHBuilt 1964 · S/N 17251615 N5718TMccormack Timothy J · Marcy, NYS/N 17251618 N5720TFrost Nathan L · Olympia, WABuilt 1964 · S/N 17251620

Back to Cessna 172E