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.

N4500CLynch Dana L · Fairbanks, AKBuilt 1953 · S/N 25443 N4502CMcfarland Keith A · Oklahoma City, OKBuilt 1952 · S/N 25445 N4502NSchoonover Traci L · Weyerhaeuser, WIS/N 26500 N4504CHickle William H · Inyokern, CABuilt 1952 · S/N 25448 N4509CReams Thomas M · Panacea, FLBuilt 1952 · S/N 25453 N4510CAyres Vance · Harrison, ARBuilt 1952 · S/N 25454 N4513CSlowpoke Air LLC · Palm Harbor, FLS/N 25457 N4516CStahlman Michael J · Portland, ORBuilt 1952 · S/N 25460 N4517CHainline Thomas D · Sumter, SCBuilt 1952 · S/N 25461 N4518CLongden Earl W · Spirit Lake, IDBuilt 1954 · S/N 25462 N4522CEvans Michael R · Nome, AKS/N 25466 N4523CShelton Agri Services Inc · Hereford, TXBuilt 1953 · S/N 25467 N4524CMcateer Kristina · East Greenwich, RIS/N 25468 N4526CWhitson Ryan L · Audubon, NJS/N 25470 N4528CMcgough N C · Ferris, TXBuilt 1953 · S/N 25472 N4529CVandenbelt Kenneth J · Leslie, MIBuilt 1953 · S/N 25473 N4530CO Connor Mary B · Anchorage, AKBuilt 1953 · S/N 25474 N4531CGear N The Well LLC · Melbourne, FLBuilt 1953 · S/N 25475 N4532CHopkins Daniel E · Chandler, AZBuilt 1953 · S/N 25476 N4533CBerwick Robert G · Sonoma, CABuilt 1953 · S/N 25477 N4538CSelby Gerald A · Sand Springs, OKBuilt 1952 · S/N 25482 N4541CPolsley Christopher · Galion, OHBuilt 1953 · S/N 25485 N4542CThomas Scott A · Groveland, CABuilt 1954 · S/N 25486 N4543CSkog Ken · Riverside, CABuilt 1952 · S/N 25487 N4546CHoffman Gregory E · Fairbanks, AKBuilt 1953 · S/N 25490 N4549CWatsons James W · Fairbanks, AKBuilt 1953 · S/N 25493 N4550CBrown Larry A · Mesa, AZBuilt 1953 · S/N 25494 N4552CMckinney Lodging Management LLC · Trout Lake, WABuilt 1952 · S/N 25496 N4555CVan Roo Jon D · Hartland, WIBuilt 1953 · S/N 25499 N4558CFarrell Raymond E · Monument, COBuilt 1953 · S/N 25502 N4563CBrown Peter D · Anchorage, AKBuilt 1953 · S/N 25507 N4564CMountain Todd Lee · Byron, MIBuilt 1953 · S/N 25508 N4569CReese Brandon A · Bend, ORS/N 25423 N4570CFairbanks Investor LLC · Fairbanks, AKBuilt 1956 · S/N 25514 N4576CFrench David C · Mc Alpin, FLBuilt 1953 · S/N 25520 N4577CKoinzan Seed And Flying Service Inc · Elgin, NEBuilt 1953 · S/N 25521 N4581CGerardy Harlan D · Gruver, TXBuilt 1953 · S/N 25525 N4582CBontrager Brian S · Wasilla, AKBuilt 1953 · S/N 25526 N4583CWood L Paul · Bridgeport, TXS/N 25527 N4584CEco Resources Inc · Millersport, OHBuilt 1953 · S/N 25528 N4585CTempero Clair R · Worden, MTBuilt 1953 · S/N 25529 N4587CJackson Marshall L II · Rock Hill, SCBuilt 1953 · S/N 25531 N4589CNelson David W · Marengo, ILBuilt 1953 · S/N 25533 N4592CKelley Stephen Mark · Kamiah, IDBuilt 1953 · S/N 25536 N4595CYoussefzadeh Salim · Pls Vrds Est, CABuilt 1953 · S/N 25539 N4597CSutton Aircraft Salvage LLC · Palmer, AKS/N 25541 N4599CNovne Aviation Inc · Harrisburg, SDBuilt 1953 · S/N 25543 N4600COneill Kenneth W · Villa Park, CABuilt 1953 · S/N 25544 N4603CMeyerhofer Richard A · Wasilla, AKBuilt 1953 · S/N 25547 N4604CRacoon Aviation LLC · San Antonio, TXBuilt 1953 · S/N 25548

Back to Cessna 170B