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.

N2947DMelin Clinton C Trustee · Big Lake, AKS/N 26890 N2949DJackson Carl · Martin, SDBuilt 1955 · S/N 26892 N2950DKnight Todd · Grimes, IABuilt 1955 · S/N 26893 N2954DRosales Mariano L III · Naperville, ILBuilt 1955 · S/N 26897 N2955DWalsh David E · North Platte, NEBuilt 1955 · S/N 26898 N2959DWatson Frank H · Central Point, ORBuilt 1955 · S/N 26902 N2961DWilliwaw Ventures LLC · Anchorage, AKBuilt 1955 · S/N 26904 N2962DBlanchard Stephanie T · Seldovia, AKS/N 26905 N2966DTruman Michael · Warner Robins, GABuilt 1955 · S/N 26909 N2970DOldfield Alan Scott · Mize, KYS/N 26913 N2973DHarkins Theresa Marie · Wentzville, MOBuilt 1955 · S/N 26916 N2974DGarnett William Allan · Pleasanton, CABuilt 1955 · S/N 26917 N2976DLux David J · Cosmos, MNBuilt 1955 · S/N 26919 N2979DParker Benjamin E · Wasilla, AKS/N 26922 N2981DYoungblood Allyson M · Anchorage, AKS/N 26924 N2983DIngalsbe David L · Flowery Branch, GABuilt 1955 · S/N 26926 N2987DScheda Mark R · Brockport, NYBuilt 1955 · S/N 26930 N2988DBrown Hector M · Glenwood Springs, COBuilt 1955 · S/N 26931 N2992DArnold Scott M · Peachtree City, GAS/N 26935 N2993DBcw Aviation LLC · Sigourney, IABuilt 1955 · S/N 26936 N2994DAncam Lc · West Burlington, IABuilt 1955 · S/N 26937 N2995DPapoulias Michael A · Jackson, MIBuilt 1955 · S/N 26938 N2996DParker Stephen H · Montgomery, TXBuilt 1955 · S/N 26939 N2998DElite Aircraft Sales LLC · Searcy, ARFirst renewal noticeS/N 26941 N2999DRegistered aircraftBuilt 1955 · S/N 26942 N3004ABaan Richard J · Live Oak, FLBuilt 1953 · S/N 25648 N3005AMarquiss Merritt L · Gillette, WYBuilt 1953 · S/N 25649 N3006ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1953 · S/N 25650 N3007AFly8ma LLC · Big Lake, AKBuilt 1953 · S/N 25651 N3009ARoberts Stephen · Camas, WABuilt 1953 · S/N 25653 N3011ACooper Remel R Jr Trustee · Green Cove Springs, FLBuilt 1953 · S/N 25655 N3013ADyer Dennis P · Otis, MES/N 25657 N3016APerry Aeronautical Services LLC · Albuquerque, NMBuilt 1953 · S/N 25660 N3017AService Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1953 · S/N 25661 N3019AWassenaar John W · Venice, FLS/N 25663 N301WBBreum Sean M · Stanwood, WAS/N 25343 N3022AReese Brandon A · Bend, ORBuilt 1953 · S/N 25666 N3023APhillips Danny W · Jefferson, TXBuilt 1953 · S/N 25667 N3026APowell Alvin L · Caldwell, IDS/N 25670 N3046AKoelsch Anthony W · Anchorage, AKBuilt 1953 · S/N 25690 N3048ADorr Eric J · Piseco, NYBuilt 1953 · S/N 25692 N3050ABlock Harlan T · Carthage, MOBuilt 1953 · S/N 25694 N3055ABohl Howard M · Temecula, CABuilt 1953 · S/N 25699 N3056ARegistered aircraftBuilt 1953 · S/N 25700 N3063AHartung Andrew K · Wasilla, AKBuilt 1953 · S/N 25707 N3064AToribio LLC · San Antonio, TXBuilt 1953 · S/N 25708 N3065ASouza Clifford A · Pattersonville, NYBuilt 1953 · S/N 25709 N3066APrice Brian · Page, AZS/N 25710 N3067AHanson Lavon T · Huson, MTS/N 25711 N3068ACyrus Ely G · Kiana, AKS/N 25712

Back to Cessna 170B