Skip to content

Registered aircraft · 1,300

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 ('2072306', '2072307')
  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 ('2072306', '2072307')
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.

N4605CMinder Gary L · Lincoln, ILBuilt 1953 · S/N 25549 N4610CShepard Brandon H · Tyler, TXBuilt 1953 · S/N 25554 N4614CLinfield William K · South Lyon, MIBuilt 1953 · S/N 25558 N461GCEngebretson Eric T · Medford, ORS/N 25563 N4620CWatkins Robert G · Palm City, FLBuilt 1953 · S/N 25564 N4621CHilliard J Scott · Girdwood, AKBuilt 1953 · S/N 25628 N4623CTaylor Hugh C · Madera, CABuilt 1953 · S/N 25567 N4625CSublette Gary L · Westlake, TXBuilt 1953 · S/N 25569 N4628CMallette Kennith R · Lucedale, MSBuilt 1953 · S/N 25572 N4632CBaldwin Dale A · Troy, MOBuilt 1953 · S/N 25576 N4634CHall Thomas J · White Lake, MIBuilt 1953 · S/N 25578 N4635CEckart Douglas L · Columbus, INBuilt 1953 · S/N 25579 N4636CClifford Karl N · Lubbock, TXBuilt 1953 · S/N 25580 N4637CRebr Holdings LLC · Hernando, FLBuilt 1953 · S/N 25581 N4639CHansman Robert J · Cambridge, MABuilt 1953 · S/N 25583 N4641CKirchoff Kevin B · Rosemark, TNBuilt 1953 · S/N 25585 N4645CEasom William J · Thousand Oaks, CAS/N 25589 N4647CConcolor LLC · Shoreview, MNBuilt 1953 · S/N 25591 N4650CLittle Jon R · Anchorage, AKBuilt 1953 · S/N 25594 N4654CSafer Jeff S · Eagle River, WIBuilt 1953 · S/N 25598 N4656CHavener Hunter W · Chittenango, NYS/N 25600 N4657CHayden Dale G · Wisconsin Rapids, WIBuilt 1953 · S/N 25601 N4659CBeesley Cattle Company LLC · Port Gibson, MSBuilt 1953 · S/N 25603 N4662CPhillips Greg C · Kelseyville, CABuilt 1953 · S/N 25606 N4666CRegistered aircraftBuilt 1953 · S/N 25610 N4668CMeierotto Jeffrey T · Two Rivers, AKBuilt 1953 · S/N 25612 N4669CGranger William W Sr · Soldotna, AKBuilt 1952 · S/N 25613 N4671CPleasant Valley Cattle Co Inc · Sturgis, SDBuilt 1953 · S/N 25615 N4672CHoover Rodney Allen · Wasilla, AKBuilt 1953 · S/N 25616 N4674CN&C Enterprises LLC · Vine Grove, KYBuilt 1953 · S/N 25618 N4677CRegistered aircraftBuilt 1953 · S/N 25621 N4679CDahl Dan P · Wasilla, AKBuilt 1953 · S/N 25623 N4687CBendixen Ralph R · Palmer, AKBuilt 1953 · S/N 25631 N4692CTaylor James L · Lowell, ARBuilt 1953 · S/N 25636 N4694CChristensen Tyler R · Red Bluff, CABuilt 1953 · S/N 25638 N4695CBall Scott G · Goleta, CABuilt 1953 · S/N 25639 N4696CWormwood Colton Daniel · Trout Creek, MTBuilt 1953 · S/N 25640 N485FBrook Trout Air LLC · Cle Elum, WAS/N 27096 N4902VZweifel John M · Beresford, SDBuilt 1952 · S/N 25334 N4999VMulhern Jeanette Y · Santa Rosa, CABuilt 1959 · S/N 25609 N49CPShenandoah Aviation LLC · Middletown, VABuilt 1953 · S/N 25782 N508WLCampbell Robert · Kingman, AZBuilt 1953 · S/N 25897 N5112JDenslow Carl W · Barto, PABuilt 1952 · S/N 20356 N52LERovey Byron G · La Grande, ORBuilt 1952 · S/N 20458 N52TDClear Sky 2020 LLC · Warner Robins, GABuilt 1952 · S/N 20379 N52WJGordon Donald G · Woodburn, INS/N 20795 N53170Price Brian · Page, AZS/N 25861 N53BWheaton James · Rutherfordton, NCBuilt 1953 · S/N 25995 N53LDEnglish William · Fairfax, VAS/N 25599 N541RMontano Roman · Great Barrington, MABuilt 1952 · S/N 25067

Back to Cessna 170B