Skip to content

Registered aircraft · 718

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 ('2072414')
  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 ('2072414')
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.

N8517UNortheast Cubs LLC · Wilmington, DEBuilt 1964 · S/N 17252417 N8522UHebbronville Machine Shop Llp · Hebbronville, TXBuilt 1964 · S/N 17252422 N8523UEllis Clifford E · Emmitsburg, MDFirst renewal noticeS/N 17252423 N8524ULewis Steven · Anchorage, AKBuilt 1964 · S/N 17252424 N8532UMethe James L · Omaha, NEBuilt 1964 · S/N 17252432 N8533USustarich Stephen M · Ketchikan, AKBuilt 1964 · S/N 17252433 N8534ULusson Adam R · Cameron, WIBuilt 1964 · S/N 17252434 N8535UGibbons Patrick C · Sunrise Beach, TXBuilt 1964 · S/N 17252435 N8537UHarrington Richard E · Bly, ORS/N 17252437 N8538UMullaly George J · Rockville Centre, NYBuilt 1964 · S/N 17252438 N8541UHegg Kevin S · Ann Arbor, MIBuilt 1965 · S/N 17252441 N8544UKeeley Edward D · Konawa, OKBuilt 1965 · S/N 17252444 N8546UShouling & Philip Enterprise · Lancaster, CABuilt 1964 · S/N 17252446 N8549UFauver Russell · Hartsville, SCS/N 17252449 N8551UFishman Randall · Napanoch, NYBuilt 1964 · S/N 17252451 N8553UFinley Todd R · Carmel, INBuilt 1965 · S/N 17252453 N8554UWorkman David A · Putnam, ILBuilt 1965 · S/N 17252454 N8555ULeaf Sport LLC · Henning, MNBuilt 1965 · S/N 17252455 N8557UOconnor Jonathan D · East Aurora, NYS/N 17252457 N8558UNelson David R · Stanwood, WABuilt 1965 · S/N 17252458 N8561USmith Michael V · Fort Myers, FLBuilt 1964 · S/N 17252461 N8562UMall Craig S · Dingmans Ferry, PABuilt 1965 · S/N 17252462 N8563UCanupp Joseph J · Clinton, SCBuilt 1964 · S/N 17252463 N8567UPfeiffer Rebecca M · Independence, MNBuilt 1964 · S/N 17252467 N8571UBell Charles M DBA · Warsaw, NYBuilt 1965 · S/N 17252471 N8575UVermillion County Flying Club · Danville, ILBuilt 1965 · S/N 17252475 N8579UStueckradt Steve · Ankeny, IABuilt 1965 · S/N 17252479 N8580UBaker Shane A · Marshall, WIBuilt 1965 · S/N 17252480 N8581ULarkin John · Cambridge, IDBuilt 1965 · S/N 17252481 N8582UMartin Livestock LLC · Ione, CABuilt 1965 · S/N 17252482 N8583UVon Burg Jon B · Hull, ILS/N 17252483 N8584VIdk Ventures LLC · Olympia, WABuilt 1965 · S/N 17252484 N8585UTreats Aviation Inc · Enumclaw, WABuilt 1965 · S/N 17252485 N8587U172 Blue Wings LLC · Berwyn, PABuilt 1965 · S/N 17252487 N8588UNachio Aviation Services LLC · Tucson, AZS/N 17252488 N8592UJls Construction & Mining Inc · Flagstaff, AZS/N 17252492 N8595UMoore James F Jr · Alexandria, KYS/N 17252495 N8596UAtlanta Air Academy LLC · Kennesaw, GABuilt 1965 · S/N 17252496 N8597UMrd Aero LLC · Manheim, PABuilt 1965 · S/N 17252497 N8598UMcclay Andrew · Baker City, ORBuilt 1965 · S/N 17252498 N8601UKing Stephen M · Trout Lake, WABuilt 1965 · S/N 17252501 N8602UAllegood Jerry C · Moultrie, GABuilt 1965 · S/N 17252502 N8604UMurray Stephen A · Worthington, OHBuilt 1965 · S/N 17252504 N8605UTurner Scott K · Wichita Falls, TXBuilt 1965 · S/N 17252505 N8606UJones Roderick W Trustee · Thomas, OKBuilt 1965 · S/N 17252506 N8607UAero Dynamics Flying Club Inc · Beavercreek, ORBuilt 1965 · S/N 17252507 N8614UOverton Wilbur C · Roanoke Rapids, NCBuilt 1965 · S/N 17252515 N8615UEmpire Air Of North Florida LLC · Waldo, FLBuilt 1965 · S/N 17252516 N8616UKeltner Peter David · Traverse City, MIBuilt 1965 · S/N 17252517 N8617UDrozen Dale W · Clovis, CABuilt 1965 · S/N 17252518

Back to Cessna 172F