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.

N2606DMoran Craig L · Krotz Springs, LABuilt 1952 · S/N 20758 N2607DMachen Matthew W · Lander, WYBuilt 1952 · S/N 20759 N2610DKomer Thomas B Jr · Moorpark, CABuilt 1952 · S/N 20762 N2611DAmsdell David A · Morgantown, WVS/N 20763 N2613DBentley Chase · Dry Ridge, KYBuilt 1952 · S/N 20765 N2617DFulton Gordon D · Mackay, IDBuilt 1952 · S/N 20769 N2619DInman Steve · Billings, MTBuilt 1952 · S/N 20771 N2623DCc Motors LLC · Redding, CAS/N 20775 N2626DKilponen Jeffrey G · Irving, TXBuilt 1952 · S/N 20778 N2628DN2628d LLC · Cheyenne, WYBuilt 1956 · S/N 20780 N2629DFoss James K · Anchorage, AKS/N 20781 N2631DHumphreys Grant R · Anchorage, AKBuilt 1952 · S/N 20783 N2632DRech Timothy J · Camano Island, WAS/N 20784 N2638DWallace Donald F · Palmer, AKBuilt 1952 · S/N 20790 N2639DHanson Scott · Anchorage, AKBuilt 1952 · S/N 20791 N2650DBrekke Aviation Inc · Edmore, NDBuilt 1952 · S/N 20802 N2652DScheidler Jerome P · Greensburg, INBuilt 1952 · S/N 20804 N2655DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 20807 N2657DBouvrie Lukas J · Boulder, COBuilt 1952 · S/N 20809 N2661DWhite Theodore F · Willow, AKBuilt 1952 · S/N 20813 N2662DReakoff Jack L · Wiseman, AKBuilt 1952 · S/N 20814 N2663DGuy Gary L · Fairbanks, AKBuilt 1952 · S/N 20815 N2664DGee Ryan S · Luverne, MNS/N 20816 N2670DBoggess William C · Placerville, CABuilt 1952 · S/N 20822 N2674DKnefley Michael · Ulysses, PABuilt 1952 · S/N 20826 N2675DPaige Barry Wayne · Wasilla, AKBuilt 1952 · S/N 20827 N2676DLamott Brenda I · Boise, IDBuilt 1952 · S/N 20828 N2679DHoppe Air LLC · Beaman, IABuilt 1952 · S/N 20831 N2683DRasmussen Merlin P · Enumclaw, WABuilt 1952 · S/N 20835 N2684DSaltsgaver Robert E III · Maryville, TNS/N 20836 N2690DN6112t LLC · Caldwell, IDBuilt 1952 · S/N 20842 N2692DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1952 · S/N 20844 N2693DBarron Dillon L · Perry, MOS/N 20845 N2694DDagenhart Jason F · Anchor Point, AKBuilt 1952 · S/N 20846 N2695DRoss David · Chestertown, MDS/N 20847 N2696DWotring Samuel Daniel II · Mount Pleasant, TXBuilt 1952 · S/N 20848 N2697DSalinas Julius T · Esko, MNBuilt 1952 · S/N 20849 N2698DGumley Andrew · Wasilla, AKBuilt 1952 · S/N 20850 N2700CMckeever Jesse · Indio, CABuilt 1954 · S/N 26244 N2702CThreadgill Stephen W · Lexington, TNBuilt 1954 · S/N 26246 N2704CNeary Russ P · Plympton, MABuilt 1954 · S/N 26248 N2707CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1955 · S/N 26251 N2709CKyzer David D · Anchorage, AKS/N 26253 N2710CFrazier James C · Hinesburg, VTBuilt 1954 · S/N 26254 N2711CHolly Shawn L · Soldotna, AKBuilt 1954 · S/N 26255 N2711DSpinner James C · Belleville, ILBuilt 1952 · S/N 25253 N2712CDunn Richard B · Otis, MEBuilt 1954 · S/N 26256 N2712DBlackwood R John Trustee · Salinas, CABuilt 1952 · S/N 25254 N2713DBlack Mountain Flying Service Ltd · Boulder City, NVBuilt 1952 · S/N 25255 N2714DDeane Gregory H · Anacortes, WABuilt 1953 · S/N 25256

Back to Cessna 170B