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.

N170BESmith Michael E · Willits, CAS/N 25752 N170BGFinley Rory P · Loon Lake, WABuilt 1952 · S/N 25392 N170BHAero-Mobil Inc · Wilmington, DEBuilt 1956 · S/N 27107 N170BKDugan Robert J · Boulder City, NVBuilt 1952 · S/N 20839 N170BSMcintyre James C · Bethlehem, PABuilt 1954 · S/N 26214 N170BTSparks Richard M · Wasilla, AKBuilt 1954 · S/N 26162 N170CFAbes Erika · El Paso, TXBuilt 1953 · S/N 25904 N170CLHickle William H · Inyokern, CABuilt 1952 · S/N 20699 N170CPLawrence Wyatt · White House, TNBuilt 1955 · S/N 26986 N170CWHohmann Courtney P · Jacksonville, FLBuilt 1952 · S/N 20411 N170DGBush Horizon Inc Trustee · Wilmington, DEBuilt 1954 · S/N 26539 N170DMBarnstorm/T-34 LLC · Jacksonville, FLBuilt 1952 · S/N 20803 N170DPLeingang Mark J · Olympia, WABuilt 1955 · S/N 26716 N170ECMueller Brent · Saint Maries, IDBuilt 1952 · S/N 20800 N170FGs Aviation Inc · Stilwell, KSBuilt 1952 · S/N 25149 N170FMMain Freddie L II · Trophy Club, TXBuilt 1957 · S/N 25246 N170FSShe-Rat Aviation Inc · Wilmington, DEBuilt 1956 · S/N 27126 N170GKipp Robert C · Woodinville, WABuilt 1952 · S/N 20456 N170HTJon Gibson Co · Cameron Park, CAS/N 20347 N170JACrosby Kenneth R · Trapper Creek, AKBuilt 1952 · S/N 25251 N170JBEmmons Carl E · Nome, AKBuilt 1955 · S/N 26651 N170JEBarrett John E · St Charles, ILBuilt 1953 · S/N 25501 N170JGErbey Donald L · Wasilla, AKBuilt 1954 · S/N 26239 N170JKSchreier James J · Fort Dodge, IABuilt 1955 · S/N 26948 N170JLGodes Terry J · Soldotna, AKBuilt 1953 · S/N 25560 N170JRRing John A · La Conner, WABuilt 1952 · S/N 20750 N170JTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1953 · S/N 25827 N170JWStark David M · Merkel, TXS/N 25973 N170KBBecker Kurt G · Dexter, NMBuilt 1956 · S/N 27103 N170KHFossa Joseph S · Essex, MABuilt 1952 · S/N 25030 N170KTHughes Michael D · Erie, COBuilt 1955 · S/N 26758 N170KWCrews Cobert · Shady Shores, TXBuilt 1955 · S/N 26712 N170LSchaible Peter J · Springfield, VABuilt 1954 · S/N 26252 N170LCMacy Richard M · Lebanon, NEBuilt 1955 · S/N 26928 N170MSMidstate Aviation Inc · Ellensburg, WAFirst renewal noticeBuilt 1953 · S/N 26085 N170MWN88tg LLC · Fairbanks, AKBuilt 1952 · S/N 25411 N170NDau Jason E · Fairbanks, AKBuilt 1955 · S/N 26899 N170PPBarry Stephen J · Beaverton, ORBuilt 1955 · S/N 26695 N170PRHicks Arch A · Oxford, NCBuilt 1953 · S/N 25686 N170REBerbig Daniel J · Anchorage, AKBuilt 1953 · S/N 25922 N170RKBelphegor LLC · Madison, WIBuilt 1953 · S/N 26053 N170RPDejesus Kennet J · Troy, OHBuilt 1953 · S/N 25865 N170SBMacbean Stanley F Trustee · Orem, UTBuilt 1952 · S/N 25140 N170TDHoyt Nicholas J · Port Orchard, WABuilt 1954 · S/N 26488 N170UJohnson Thomas C · Roseau, MNBuilt 1953 · S/N 25858 N170VPocock Milne David · Cal Nev Ari, NVBuilt 1952 · S/N 20656 N170VWPratz Chris · Ellensburg, WABuilt 1952 · S/N 20592 N170WRFinkel Charles M · Taylorsville, NCBuilt 1954 · S/N 26450 N170WYLarsen Michael S · Cody, WYBuilt 1954 · S/N 26592 N170YPocock Milne D · Cal Nev Ari, NVBuilt 1953 · S/N 25882

Back to Cessna 170B