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.

N5387TMagnusson Charles D · Upper Sandusky, OHBuilt 1964 · S/N 17251287 N5389TChadwell Letch J · Hulbert, OKBuilt 1964 · S/N 17251289 N5390TBakker Johanna · Spokane, WABuilt 1964 · S/N 17251290 N5392TStarkovich James M · Arlington, WABuilt 1964 · S/N 17251292 N5394TBigler Danny L · Owasso, OKBuilt 1964 · S/N 17251294 N5396TMclaughlin Daniel J · Elbridge, NYBuilt 1964 · S/N 17251296 N5398TSandstrom Mark · Minot, NDBuilt 1964 · S/N 17251298 N5400TDonnelly Charles R · Nashua, NHBuilt 1964 · S/N 17251300 N5403TIngrim William Paul · Girdwood, AKBuilt 1964 · S/N 17251303 N5404TCorrea Ruben D · Horn Lake, MSS/N 17251304 N5405TAgt Tech Corp · Hialeah, FLNon-citizen corporation, flight hours not reportedS/N 17251305 N5409TSchein Joshua A · Anchorage, AKBuilt 1964 · S/N 17251309 N5411TTioga Land Development LLC · Tioga, NDBuilt 1964 · S/N 17251311 N5412TBartlomiej Gadaj · Jacksonville, FLBuilt 1964 · S/N 17251312 N5413TLrp Aircraft LLC · Durham, NCBuilt 1964 · S/N 17251313 N5415TStill Flying LLC · Gibsland, LABuilt 1964 · S/N 17251315 N5418TFoster Chad DBA · Theodore, ALBuilt 1964 · S/N 17251318 N5419TGregorski Thomas E · Kenly, NCBuilt 1964 · S/N 17251319 N5422TShrader Kevin M · Browns Valley, CABuilt 1964 · S/N 17251322 N5424TEshleman James E · Yucaipa, CAS/N 17251324 N5427TNw Aircraft Sales & Leasing LLC · Scappoose, ORBuilt 1964 · S/N 17251327 N5428TBarnes Joseph A · Upper Lake, CABuilt 1964 · S/N 17251328 N5430TReitz Enterprise LLC · Goliad, TXBuilt 1964 · S/N 17251330 N5431TCorbett Michael T · Lake City, FLBuilt 1964 · S/N 17251331 N5436TStrachn Adam · Lenoir City, TNBuilt 1964 · S/N 17251336 N5438TFritz James A · Pierce, NEBuilt 1964 · S/N 17251338 N5439TSlone James E · Grundy, VAS/N 17251339 N543DFRichardson Daniel D · Caldwell, IDS/N 17251342 N5440TIsland Lady LLC · Iowa Falls, IAS/N 17251340 N5441TCape Steven A · Columbia, KYS/N 17251341 N5444TTappon Wayne A · Ladysmith, WIS/N 17251344 N5445TSchallip Robert G III · White Lake, MIBuilt 1964 · S/N 17251345 N5448TRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1964 · S/N 17251348 N5452TEagle Sky Patrol Inc · Deadwood, SDBuilt 1964 · S/N 17251352 N5454TPearce David W Trustee · Anchorage, AKBuilt 1964 · S/N 17251354 N5455TStrickland Justin Ryan · Lovington, NMBuilt 1964 · S/N 17251355 N5456TKelley Keith B · Forney, TXBuilt 1964 · S/N 17251356 N5458TTodd Tyler L · Quitman, MSBuilt 1964 · S/N 17251358 N5459TBrennan Brian L · Tipton, IABuilt 1964 · S/N 17251359 N5463TFrazier Isaiah V · Blue River, WIBuilt 1964 · S/N 17251363 N5464TJackson Tyler H · Kittery, MEBuilt 1964 · S/N 17251364 N5466THildebrant Virginia Fay · Fall City, WABuilt 1964 · S/N 17251366 N5467TRegistered aircraftBuilt 1964 · S/N 17251367 N5470TLesnick Robert E · Charlotte, NCBuilt 1964 · S/N 17251370 N5471TWiesen Michael J · Waldo, FLBuilt 1964 · S/N 17251371 N5474TTisdell Branden L · Bear, DEBuilt 1964 · S/N 17251374 N5477TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1964 · S/N 17251377 N5478TSipes David · Bolivar, TNBuilt 1964 · S/N 17251378 N5484TWings Den LLC · Wilmington, DEBuilt 1964 · S/N 17251384 N5485TJohnson Warren A · Delavan, WIS/N 17251385

Back to Cessna 172E