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.

N2715CHead Nyle C · Sisters, ORS/N 26259 N2715DEducation Connection LLC · Port Saint Lucie, FLBuilt 1952 · S/N 25257 N2716DDammann Willa B · Murrieta, CABuilt 1952 · S/N 25258 N2717CGibboney Scott H · Temecula, CABuilt 1954 · S/N 26261 N2717DGrimsley Steve K · Underhill, VTBuilt 1953 · S/N 25259 N2718DCongdons Aviation Service · Anchorage, AKBuilt 1952 · S/N 25260 N2719DRaber Michael R · Xenia, OHFirst renewal noticeBuilt 1952 · S/N 25261 N2720DHill Sheldon S · Minot, NDBuilt 1952 · S/N 25262 N2722CHavener Walter J · Lodge Grass, MTBuilt 1954 · S/N 26266 N2722DFly South Aviation LLC · Little Rock, ARS/N 26889 N2723DBarnes Jeffrey L · Odessa, TXBuilt 1952 · S/N 25265 N2724CN2724c LLC · Levering, MIBuilt 1954 · S/N 26268 N2724DRojas Conrad · Fairbanks, AKBuilt 1952 · S/N 25266 N2726DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 25268 N2727CWennersten Donald A · Ann Arbor, MIBuilt 1954 · S/N 26271 N2727DMcfarlane Scott J · Denair, CABuilt 1952 · S/N 25269 N2728CMeidl Jared · Crivitz, WIS/N 26272 N2731DVoegeli Nathan · Sacramento, CAS/N 25273 N2732DYounger Cody M · Shedd, ORBuilt 1952 · S/N 25274 N2733CYurechko Philip Jr · Jewett City, CTBuilt 1954 · S/N 26277 N2734CRegistered aircraftS/N 26278 N2735CBeach Michael C · Lebanon, ORBuilt 1954 · S/N 26279 N2735DMorpeth Thomas · Fortson, GABuilt 1952 · S/N 25277 N2737CBenard Matthew Scott · Lakeville, MABuilt 1954 · S/N 26281 N2740CKangas Michael C · Big Lake, AKS/N 26284 N2741CGifford Gary W · Lighthouse Point, FLBuilt 1954 · S/N 26285 N2741DGott Michael C · Fairbanks, AKBuilt 1952 · S/N 25283 N2742DLloyd Land Plane III LLC · Brighton, COBuilt 1952 · S/N 25284 N2743C43charlie LLC · Nicollet, MNBuilt 1954 · S/N 26287 N2743DBoies Ranch Inc · Wells, NVS/N 25285 N2744DTaylor Rock P · Wasilla, AKBuilt 1952 · S/N 25286 N2746DWheeler Evan L · North Pole, AKBuilt 1952 · S/N 25288 N2747CBirtic George J · Belgrade, MTS/N 26291 N2747DFrei Russell M · Grangeville, IDBuilt 1952 · S/N 25289 N2748CZaathof Aero LLC · Foristell, MOBuilt 1954 · S/N 26292 N2750CFoister Nathan · Anchorage, AKBuilt 1954 · S/N 26294 N2752DShapiro Sara · Olympia, WABuilt 1952 · S/N 25294 N2756DStewart James A · San Ramon, CABuilt 1952 · S/N 25298 N2759CHillegeist Tracy L · Beverly, KSBuilt 1954 · S/N 26303 N2760COwens Gary R · Talkeetna, AKBuilt 1954 · S/N 26304 N2761CLangvardt Rawley J · Elkton, MDBuilt 1954 · S/N 26305 N2763DHammerton David · Olive Branch, MSBuilt 1952 · S/N 25305 N2764DHansen Arland R · Warden, WABuilt 1952 · S/N 25306 N2766DFielding A M Randolph · Jackson, TNS/N 25308 N2767CRhodes Terry G · Snohomish, WABuilt 1954 · S/N 26311 N2768CRivas John M · Bellevue, WABuilt 1954 · S/N 26312 N2768DGarate Adrian M · Miami, FLS/N 25310 N2769AParish Theodore P · Anchorage, AKBuilt 1952 · S/N 25017 N2770CGuzik James V · Lindstrom, MNBuilt 1954 · S/N 26314 N2771CKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1954 · S/N 26315

Back to Cessna 170B