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.

N2210DSample Richard F · Ellensburg, WAS/N 20362 N2211DKuhn Michael D · Knapp, WIBuilt 1952 · S/N 20363 N2219DRogers David R · Lake Jackson, TXBuilt 1952 · S/N 20371 N2221DChestnut Ridge Construction Inc · New Alexandria, PAS/N 20373 N2222DAsbury Charles E · Valley Center, KSBuilt 1952 · S/N 20374 N2224EReiss Dennis · Wilcox, NEBuilt 1952 · S/N 20354 N2229DN2229d LLC · Wilmington, OHBuilt 1952 · S/N 20381 N222WTLopes Jeremy B · Peoria, AZBuilt 1952 · S/N 20372 N2231DFisher Air LLC · Cardington, OHBuilt 1952 · S/N 20383 N2233DMerrill Christopher D · Albany Twp, MES/N 20385 N2235DHasner Mark A · Fairbanks, AKS/N 20387 N2238DFanoni Michael A · Colfax, CABuilt 1952 · S/N 20390 N2238HRhodes Mike A · Independence, ORBuilt 1953 · S/N 25644 N223NKWandering Vet LLC · Mccook, NEBuilt 1955 · S/N 26814 N2242DField Barry C · Leverett, MABuilt 1952 · S/N 20394 N2246DBiagioni Paul M · Anchorage, AKBuilt 1952 · S/N 20398 N2250DBruce Jason W · Stone Mountain, GABuilt 1952 · S/N 20402 N2255DWeaver Walter J · Concord, NCBuilt 1952 · S/N 20407 N2256DRegistered aircraftBuilt 1952 · S/N 20408 N2257DSmith Ryan M · Greensboro, NCBuilt 1952 · S/N 20409 N2264DKlein James M · Pinconning, MIBuilt 1952 · S/N 20416 N2265DPiispanen Norman C · Fairbanks, AKBuilt 1952 · S/N 20417 N2266DBeland Steven J Jr · Saint Ansgar, IABuilt 1952 · S/N 20418 N2273DHorkan Tracy J · Reedsburg, WIS/N 20425 N2274DHernandez Michael Nazario · Orange, CABuilt 1952 · S/N 20426 N2275DJordan Ken W · Frankfort, KYBuilt 1952 · S/N 20427 N2282DStandhart Gary S · Wickenburg, AZBuilt 1952 · S/N 20434 N2285DJet Cane Corp · Roseville, CABuilt 1952 · S/N 20437 N2290DVan Roy Gary J · Seven Bays, WABuilt 1952 · S/N 20442 N2291DKauffman Phillip L · Castleberry, ALBuilt 1952 · S/N 20443 N2294DPlunkett Carton C · Terry, MSBuilt 1952 · S/N 20446 N2298DAgaliotis Paul E · San Martin, CABuilt 1952 · S/N 20450 N2300DEmbry Aero Ltd · Greenville, ILBuilt 1952 · S/N 20452 N2303DDemar Aviation LLC · Spotsylvania, VABuilt 1952 · S/N 20455 N2305DKupchak Bruce · Bridgeville, DES/N 20457 N2307DSunderland Paul · Savannah, GAS/N 20459 N2311DTwombly Eric D · Halfway, ORBuilt 1952 · S/N 20463 N2315DFeher Eugene A · Greenwich, NYBuilt 1952 · S/N 20467 N2320DBeyer James C · Fayetteville, TNBuilt 1952 · S/N 20472 N2322DMacvey Troy R · Milan, INBuilt 1952 · S/N 20474 N2323D53u Aviation LLC · Bigfork, MTBuilt 1952 · S/N 20475 N2326DDepue Amanda N · Wasilla, AKBuilt 1952 · S/N 20478 N2329DSwint David A · Henderson, NVBuilt 1952 · S/N 20481 N2331DJensen William C · Brookshire, TXBuilt 1952 · S/N 20483 N2332DSandstrom David · Anchorage, AKBuilt 1952 · S/N 20484 N2333DTroutman Charles W · Prineville, ORBuilt 1952 · S/N 20485 N2334DCaruso Timothy E · Gainesville, VABuilt 1952 · S/N 20486 N2335DWinch Cary F · Necedah, WIS/N 20487 N2337DSurely You Cant Be An LLC · Albuquerque, NMBuilt 1952 · S/N 20489 N2339DWenrich Kevin P · Myerstown, PAS/N 20491

Back to Cessna 170B