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.

N3594CNichols Jamie · Naples, MEBuilt 1955 · S/N 26638 N3598CN3598c LLC · Ellisville, MOBuilt 1955 · S/N 26642 N365JBHentges Dave · Canby, MNBuilt 1952 · S/N 25419 N3743GMahler Richard Keith · Haines, AKS/N 26301 N37624Lowe David M · Sacramento, KYS/N 20668 N39781Van Buren Nathaniel O · Anchorage, AKS/N 25723 N39998Becker Kurt G · Dexter, NMBuilt 1953 · S/N 25958 N3JXDunbar Marc L Trustee · Rocklin, CABuilt 1952 · S/N 25248 N401FEasley Daniel W · Wasilla, AKBuilt 1953 · S/N 26115 N410DWWest Earl W · Canton, TXS/N 26872 N4170BOutman William D · Half Moon Bay, CABuilt 1953 · S/N 26137 N4185CRodgers Samuel D · Casper, WYBuilt 1952 · S/N 20597 N419AKeech Paul A · Fairbanks, AKBuilt 1953 · S/N 25702 N41TXHase Gary A · Fort Worth, TXBuilt 1954 · S/N 26396 N4234NHain Bruce P · Kennesaw, GAS/N 26263 N4262ARamaswamy Ashok · Clearwater Beach, FLS/N 27105 N4301BCff LLC · Kalispell, MTBuilt 1955 · S/N 26645 N4303BWetherbee Michael · Howell, MIBuilt 1955 · S/N 26647 N4308BLyons Milo J · Sequim, WABuilt 1955 · S/N 26652 N4310BMaly Burr J · Anchorage, AKBuilt 1955 · S/N 26654 N4311BPohl Jeffrey A · Milaca, MNBuilt 1955 · S/N 26655 N4315BMckamey Dave S · Sonora, CABuilt 1955 · S/N 26659 N4316BAnderson Gregory P · Meadow Vista, CABuilt 1955 · S/N 26660 N4319BClay Charles E · Alhambra, CABuilt 1955 · S/N 26663 N4325BWattum Joel W · Wasilla, AKBuilt 1955 · S/N 26669 N4326BRopp Doug · Albany, ORS/N 26670 N4336BAlthens Levi W · Wasilla, AKBuilt 1955 · S/N 26680 N433WKingdom Air Corps · Sutton, AKBuilt 1953 · S/N 25962 N4340BMuehl John M · Maryland, NYBuilt 1955 · S/N 26684 N4344BMckinnon Harvey T · Thompson Falls, MTBuilt 1955 · S/N 26688 N4349BLee Robert E · Medford, WIFirst renewal noticeBuilt 1955 · S/N 26693 N4357BBettis Frederick W · Crestview, FLBuilt 1955 · S/N 26701 N4358BVaughn Thomas N · Shallowater, TXBuilt 1955 · S/N 26702 N4359BAllen Bruce A · La Porte, INBuilt 1955 · S/N 26703 N4361BFitts James A Jr · North Pole, AKBuilt 1955 · S/N 26705 N4362BHernden Michael R · Rockford, ILBuilt 1955 · S/N 26706 N4365BMorris Steven Jacob · Wasilla, AKBuilt 1955 · S/N 26709 N4366BLittle Andrew P · Fairbanks, AKBuilt 1955 · S/N 26710 N4369BFlegel Brian E · Milton Freewater, ORBuilt 1955 · S/N 26713 N4373BZenishek Gary D Trustee · Jefferson City, MOBuilt 1955 · S/N 26717 N4377BNatural Resources LLC · Arcadia, FLBuilt 1955 · S/N 26721 N4379BNewell Kenneth L · Wichita, KSBuilt 1955 · S/N 26723 N4380BThorall Kenneth L · Chugiak, AKS/N 26724 N4381BBuck William A · Waianae, HIBuilt 1955 · S/N 26725 N4382BBoyd Delbert L · Oroville, CABuilt 1955 · S/N 26726 N4384BMead Aviation LLC · Missoula, MTBuilt 1955 · S/N 26728 N4385BDorris Michael R · Mccall, IDBuilt 1956 · S/N 26729 N4387BN4387b LLC · Sheridan, ARBuilt 1955 · S/N 26731 N4388BHanke Lowell E · Deerbrook, WIBuilt 1955 · S/N 26732 N4389BVogel Max R · Havre, MTBuilt 1955 · S/N 26733

Back to Cessna 170B