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.

N4392BBrooks Todd A · Vacaville, CAFirst renewal noticeBuilt 1955 · S/N 26736 N4393BMiller Zachary · Anchorage, AKS/N 26737 N4396BRhett Martin C · Palmer, AKBuilt 1955 · S/N 26740 N4398BEckert Paul E · Palmer, AKS/N 26742 N4399BJohnston Dennis W · Temple, TXBuilt 1955 · S/N 26743 N43FWesterlund Karl D · Eagle River, AKBuilt 1954 · S/N 26221 N4401BJohnson Timothy A · Chisago City, MNBuilt 1955 · S/N 26745 N4402BBuffalo Hill Holdings LLC · Sheridan, WYBuilt 1955 · S/N 26746 N4403BWhitesell Timothy D · Bend, ORS/N 26747 N4405BWelton Doug L · Fairbanks, AKBuilt 1955 · S/N 26749 N4406BAndersen Gregory A · Kenai, AKBuilt 1955 · S/N 26750 N4408BBrookover Thomas E · Anchorage, AKBuilt 1955 · S/N 26752 N4409BDavis John A · Waller, TXS/N 26753 N4410BRhymes Dustin A · Upland, CABuilt 1955 · S/N 26754 N4411BFerguson James L · Junction City, KSBuilt 1955 · S/N 26755 N4412BGiraffe & Platypus Aviation Ltd · Fort Collins, COBuilt 1955 · S/N 26756 N4413BBynum Sonia · Portland, ORBuilt 1955 · S/N 26757 N4418BFulwiler Daniel R · Green Bay, WIBuilt 1955 · S/N 26762 N4419BStaubach Adam R · North Pole, AKBuilt 1955 · S/N 26763 N4423BMouser Cassandra J · Beaverton, ORBuilt 1955 · S/N 26767 N4424FPt Logistics LLC · Rye, NHBuilt 1955 · S/N 26768 N4427BRoderick Paul Edward · Talkeetna, AKBuilt 1955 · S/N 26771 N4433BAircraft Partner N4433b Dst · BerlinBuilt 1955 · S/N 26777 N4435BHarstad Calvin B · Viking, MNS/N 26779 N4437BCaudill Charles D · Fairbanks, AKBuilt 1955 · S/N 26781 N4445BFassett Barry J · Blaine, MNBuilt 1955 · S/N 26789 N4446BOz Aviation Inc · Wilmington, DEBuilt 1955 · S/N 26790 N4448BLadegard Ryan P · Wasilla, AKBuilt 1955 · S/N 26792 N4449BPatkotak Hugh Gareth Sr · Anchorage, AKBuilt 1955 · S/N 26793 N4450BRiverview Farm · Starbuck, MNBuilt 1955 · S/N 26794 N4453BBussolari Steven R · Evanston, ILBuilt 1955 · S/N 26797 N4454BHudson Kent O · Anchorage, AKBuilt 1955 · S/N 26798 N4457BCelestina Harold C · Ester, AKBuilt 1956 · S/N 26801 N4463BJacobson Jon · Medford, ORBuilt 1955 · S/N 26807 N4466BGray Allen J · Fairbanks, AKBuilt 1955 · S/N 26810 N4468BStopher Patrick K · Anchorage, AKBuilt 1955 · S/N 26812 N4472BEdwards Christopher V · Seattle, WABuilt 1955 · S/N 26816 N4473BBenedict Larry D · Dexter, NMBuilt 1955 · S/N 26817 N4476BRegistered aircraftBuilt 1955 · S/N 26820 N4478BMouse Jay F · Goldendale, WABuilt 1955 · S/N 26822 N4479BBig Wing LLC · Delavan, MNBuilt 1955 · S/N 26823 N4484BThames James W · Florence, ALBuilt 1955 · S/N 26828 N4489BHarris Ryan A · Valley Cottage, NYS/N 26833 N4490BDichter Alexander · Palm Harbor, FLS/N 26834 N4491BMessersmith David · Beaver Falls, PABuilt 1955 · S/N 26835 N4492BParzyk Jason D · Lake Stevens, WABuilt 1955 · S/N 26836 N4493BGridley Trevor M · Fairbanks, AKBuilt 1955 · S/N 26837 N4494BMiller Daniel G · Seattle, WABuilt 1955 · S/N 26838 N4497BCounsell Jon E · Snohomish, WABuilt 1955 · S/N 26841 N4498BMorris Charles W · Wasilla, AKBuilt 1955 · S/N 26842

Back to Cessna 170B