Skip to content

Registered aircraft · 1,025

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

N7749LDouble Bridges Aviation LLC · Enterprise, ALBuilt 1970 · S/N 17259015 N78027Cramlet Kirk T · Woodlake, CABuilt 1968 · S/N 17257467 N78066Orlandi Properties LLC · Blairstown, NJBuilt 1968 · S/N 17257470 N78076Clinton Aeroclub · Clinton, IABuilt 1968 · S/N 17257472 N78078International Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17257473 N78086Drake Ronald N · Helena, MTBuilt 1968 · S/N 17257475 N78095Leuer James A · Encinitas, CABuilt 1968 · S/N 17257480 N78112Botnick Eric L · Luling, LABuilt 1968 · S/N 17257486 N78123Rrr3 LLC · Midway, FLS/N 17257490 N78124Barrow James L · Elizabethtown, KYBuilt 1968 · S/N 17257491 N78126Orme Jason R · Red Oak, IABuilt 1968 · S/N 17257492 N78130Garoutte Kirk E · Anchorage, AKBuilt 1968 · S/N 17257493 N78139Van Straten Patrick F · Shiocton, WIBuilt 1968 · S/N 17257497 N78142Partyka Kenneth M · Circle Pines, MNBuilt 1968 · S/N 17257499 N78144Kyzer Aviation Holdings LLC · Fort Mill, SCS/N 17257500 N78158Hill Donald J · Godfrey, ILBuilt 1968 · S/N 17257505 N78174Spencer Aviation Inc · Delaware, OHBuilt 1968 · S/N 17257510 N78179Horgan Robert V Jr · Wolfeboro, NHS/N 17257513 N78180Gatewood Doris E · Stokesdale, NCBuilt 1968 · S/N 17257514 N78182Ajayi Samuel O · Jacksonville, ARS/N 17257515 N78183Smolik Vincent C · Ponder, TXBuilt 1968 · S/N 17257516 N78186Johnson Gavin R · Othello, WABuilt 1968 · S/N 17257517 N78190Prp Aviation LLC · Ocala, FLBuilt 1968 · S/N 17257520 N78195Mishawaka Pilots Club Inc · Osceola, INBuilt 1968 · S/N 17257522 N78197Allen County Regional Airport Authority · Lima, OHBuilt 1968 · S/N 17257523 N78207Sherman Todd P · Collinsville, OKBuilt 1968 · S/N 17257526 N78215Alvarado Eduardo · Fayetteville, TXBuilt 1968 · S/N 17257530 N78219Testa Christopher · Kennesaw, GAFirst renewal noticeBuilt 1968 · S/N 17257532 N78221Waldrop Floyd D · Robinson, ILBuilt 1968 · S/N 17257534 N78228Lanning Keith L · Everton, ARBuilt 1968 · S/N 17257537 N78239Draco Flight School DBA · Chino, CABuilt 1968 · S/N 17257540 N78240Kinney Joan M · Vermillion, SDBuilt 1968 · S/N 17257541 N78242176fps LLC · Marthasville, MOBuilt 1968 · S/N 17257543 N78249Howard Ronald W · Okeechobee, FLBuilt 1968 · S/N 17257545 N78253Chatman Hannah K · Poplar Bluff, MOS/N 17257546 N78254Bpk Holdings LLC · Montesano, WABuilt 1968 · S/N 17257547 N7826681 Escadrille Inc · Hutchinson, KSBuilt 1968 · S/N 17257549 N78286Marsh David J · Sioux Falls, SDBuilt 1968 · S/N 17257554 N78295Cofsky Gregory J · Sandwich, MABuilt 1968 · S/N 17257556 N78299Jb Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 17257558 N78302Gardner Christopher · South Saint Paul, MNBuilt 1968 · S/N 17257559 N78303Citizen Air LLC · Port Angeles, WABuilt 1968 · S/N 17257560 N78305Woollen Claude D · Moore, SCBuilt 1968 · S/N 17257562 N78312Roemer Joanne · Kemah, TXS/N 17257565 N78330Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257567 N78331Clifton Jack D · La Junta, COS/N 17257568 N78332Albright John T · Decatur, ALBuilt 1968 · S/N 17257569 N78335Marotte David J · Windham, NHBuilt 1968 · S/N 17257570 N78338Mbh Aviation LLC · Tulalip, WABuilt 1968 · S/N 17257572 N78339Hopfmann Alwin E · Rutland, MABuilt 1968 · S/N 17257573

Back to Cessna 172K