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.

N108TSHesser Dale W · Cardington, OHBuilt 1952 · S/N 20328 N111LKnuth Dale G · Hartford, SDBuilt 1952 · S/N 20642 N112QBFloyd Austin · Searcy, ARBuilt 1955 · S/N 26952 N117GSSimdorn William N · Scappoose, ORBuilt 1956 · S/N 27157 N118FRemington William J · Decorah, IABuilt 1952 · S/N 25329 N1209RRowley Timothy · Roopville, GABuilt 1954 · S/N 26152 N1224VCarter John T · Huntington Beach, CABuilt 1952 · S/N 20358 N135HMid Continent Aircraft Corp · Hayti, MOBuilt 1952 · S/N 20829 N135JBMajane John A · Bethesda, MDBuilt 1955 · S/N 26850 N138WWCutler Christopher P · Whitewright, TXBuilt 1954 · S/N 26189 N139ARSky West Aviation Inc Trustee · Albuquerque, NMS/N 25557 N14055Top Hand Inc · Laurel, MTBuilt 1952 · S/N 20937 N146YSHorn George A · Spicewood, TXBuilt 1952 · S/N 25713 N152MNauleau Paul Elie · San Francisco, CABuilt 1952 · S/N 25006 N153WSZeissner Douglas K · Chino, CABuilt 1952 · S/N 25355 N155VWolcott Guy R II · Gresham, ORBuilt 1952 · S/N 20949 N1625DHatcher Aviation LLC · Little Rock, ARBuilt 1951 · S/N 20267 N1629DEbenezer Richard C · Soldotna, AKBuilt 1952 · S/N 20271 N1634DBlackhawk Aviation LLC · Medicine Park, OKBuilt 1952 · S/N 20276 N1636DDeruiter Don DBA · Lake City, MIBuilt 1952 · S/N 20278 N1639DVoigt Don M · Palmer, AKBuilt 1952 · S/N 20281 N163WDavis Paul J Jr · Springdale, ARBuilt 1956 · S/N 27094 N1640DRoessler Larry J · Groveland, CABuilt 1952 · S/N 20282 N1643DMaselko Jacek · Juneau, AKBuilt 1952 · S/N 20285 N1646DDraggin Tail Pilots · Prospect, PAS/N 20288 N1647DExpress Aviation Management LLC · Dover, DES/N 20289 N1651DWeber Donald B · Chugiak, AKBuilt 1952 · S/N 20293 N1652DFischer Andrew G · Hopkins, MNBuilt 1952 · S/N 20294 N1655DAcosta Antonio A · Campbell Hall, NYBuilt 1952 · S/N 20297 N1657DFlying Aces LLC · Scappoose, ORBuilt 1952 · S/N 20299 N1658DClement Aircraft LLC · Anchorage, AKBuilt 1952 · S/N 20300 N1660DFoster Mike · Alameda, CABuilt 1952 · S/N 20302 N1664DScud Air Solutions LLC · South Weber, UTS/N 20306 N1665DDinstel Delbert F · Park City, MTBuilt 1952 · S/N 20307 N1675DRatcliff Whitcomb T · Carnation, WABuilt 1952 · S/N 20317 N1676DJohnston Brent A · Galena, OHBuilt 1952 · S/N 20318 N1680DTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1952 · S/N 20322 N1681DKaiserauer Brian · Longmont, COBuilt 1952 · S/N 20323 N1685DAngrisani Robert J · Sacramento, CABuilt 1952 · S/N 20327 N1688DIsburgh Andrew N · Conyers, GABuilt 1952 · S/N 20330 N1689DHumphreys Richard P · Sequim, WAS/N 20331 N1691DSchaak James D · Billings, MTS/N 20333 N1698DFandler Ron · Gresham, WIBuilt 1952 · S/N 20340 N170Schaffer Grant B · Springfield, ORBuilt 1952 · S/N 25122 N17053Rough Joseph W · Priest Lake, IDBuilt 1953 · S/N 25678 N170AKPerry John E · Kenai, AKBuilt 1953 · S/N 25431 N170ARSmith Edward T · Bradenton, FLBuilt 1952 · S/N 20604 N170AWAir Alaska Properties · Wasilla, AKBuilt 1955 · S/N 26805 N170BRegistered aircraftBuilt 1952 · S/N 20944 N170BBSmothers Joey D · Dwight, ILS/N 26297

Back to Cessna 170B