Skip to content

Registered aircraft · 413

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

N7927XWhitefeather Aviation LLC · Creston, OHBuilt 1961 · S/N 17248427 N7934XBellmann Carl W · Bryan, OHBuilt 1961 · S/N 17248434 N7939XCox Richard H III · Kapolei, HIBuilt 1961 · S/N 17248439 N7941XDixie Aerial Surveillance & Photography LLC · Heflin, LABuilt 1961 · S/N 17248441 N7956XNesbit Stephen M · Chino Hills, CABuilt 1961 · S/N 17248456 N7957XRoderick Ashley T Jr · Hixton, WIBuilt 1961 · S/N 17248457 N7961XCarruth Sam · Ripon, CABuilt 1961 · S/N 17248461 N7963XHairetown LLC · Johnson City, TNBuilt 1961 · S/N 17248463 N7964XEdwards Jerry T · Palo Pinto, TXBuilt 1961 · S/N 17248464 N7967XSchneider David L · Saginaw, MIBuilt 1961 · S/N 17248467 N7969XBurnham Bros · Winner, SDBuilt 1961 · S/N 17248469 N7974XKalamazoo Flight Instruction LLC · Kalamazoo, MIBuilt 1961 · S/N 17248474 N7975XGessinger Gregory S · Nappanee, INBuilt 1961 · S/N 17248475 N7979XKnutson Wayne R · Thompson, NDS/N 17248479 N7983XLine Ricky L · Liberty Hill, TXBuilt 1961 · S/N 17248483 N7985XDoughty Phillip T Jr · West Monroe, LABuilt 1961 · S/N 17248485 N7994XRegistered aircraftBuilt 1961 · S/N 17248494 N7996XBuchhorn Larry R · Fredericksburg, TXBuilt 1961 · S/N 17248496 N7998XAirborne One LLC · Kalispell, MTBuilt 1961 · S/N 17248498 N8000XRush Adelaide K · Anchorage, AKBuilt 1961 · S/N 17248500 N8003XSwenson Donald C · Stanchfield, MNBuilt 1961 · S/N 17248503 N8004XSchriever Rebecca M · Lees Summit, MOS/N 17248504 N8012XSingh Joga · Auburn, WABuilt 1961 · S/N 17248512 N8017XCaudill Jimmy L · Grove, OKBuilt 1961 · S/N 17248517 N8019XWarren Edwin W · East Dorset, VTBuilt 1961 · S/N 17248519 N8021XPatterson Roland O · Semmes, ALBuilt 1961 · S/N 17248521 N8024XRay Jonathan S · Richland, WABuilt 1961 · S/N 17248524 N8027XHall Rick L · Vancouver, WABuilt 1961 · S/N 17248527 N8030XKuykendall Kyle J · Austin, TXS/N 17248530 N8033XHenrey Keith · Jasper, GABuilt 1961 · S/N 17248533 N8035XHenke Shannon W · Bismarck, NDBuilt 1961 · S/N 17248535 N8040XMj Coop LLC · Sylva, NCBuilt 1961 · S/N 17248540 N8043XStrandberg Kevin L · Pennock, MNBuilt 1961 · S/N 17248543 N8047XFitzgerald Jeff D · Smithfield, UTBuilt 1961 · S/N 17248547 N8051XBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 17248551 N8052XLafayette Aero Club Inc · West Lafayette, INBuilt 1961 · S/N 17248552 N8056XKerekes John J · Tucson, AZBuilt 1961 · S/N 17248556 N8061XSteck Phillip G · Smartsville, CAS/N 17248561 N8062XHerring Fred A · Walnut Ridge, ARBuilt 1961 · S/N 17248562 N8065XCollege Of Missionary Aviation Inc · Keystone Heights, FLBuilt 1961 · S/N 17248565 N8067XCowan Norman · Tallapoosa, GABuilt 1961 · S/N 17248567 N8068XBurns Shawn P · Holly Ridge, NCBuilt 1961 · S/N 17248568 N8070XPreble Thomas A · Peyton, COBuilt 1961 · S/N 17248570 N8074XDockins Jamie L · Athol, IDS/N 17248574 N8080XWard B J · Hewitt, NJBuilt 1961 · S/N 17248580 N8082XNewman Joseph N · Springfield, MIBuilt 1961 · S/N 17248582 N8084XSnyder Paul G · Lincoln, NEBuilt 1961 · S/N 17248584 N8086XPaumen Kurt J · Ramsey, MNBuilt 1961 · S/N 17248586 N8087XMagers William L · Nampa, IDS/N 17248587 N8088XSky 66 Aero LLC · Talala, OKBuilt 1961 · S/N 17248588

Back to Cessna 172B