Skip to content

Registered aircraft · 1,805

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

N6061ADickman Edward A · Melba, IDBuilt 1956 · S/N 28661 N6065AMam Air LLC · Stone Creek, OHBuilt 1956 · S/N 28665 N6066AAndrews Peter F · Rangeley, MEBuilt 1956 · S/N 28666 N6068AWillerscheidt Thomas H · Mukwonago, WIBuilt 1956 · S/N 28668 N6070APolin Keith A · Belen, NMS/N 28670 N6071AJones Jane · Portland, ORBuilt 1956 · S/N 28671 N6076ABack Daryl · Stephenville, TXBuilt 1956 · S/N 28676 N6077AHall James E III · Lumber Bridge, NCBuilt 1956 · S/N 28677 N6078ASnell Jeffrey D · Inver Grove Hghts, MNBuilt 1956 · S/N 28678 N6079ARegistration Pending · Hartford, SDRegistration pendingBuilt 1956 · S/N 28679 N6081ABoykin Bobby · Brandon, MSS/N 28681 N6086AWatson Johnna A · Sonoma, CABuilt 1956 · S/N 28686 N6087AFlood Plain Farm And Mercantile LLC · Curlew, WABuilt 1956 · S/N 28687 N6088AStrickland Vernon G · Fort Worth, TXBuilt 1956 · S/N 28688 N6090ARegistered aircraftBuilt 1956 · S/N 28690 N6091ABarrientos Jeri · Collinsville, OKS/N 28691 N6093ARecker Nicholas P · Franklin, TNBuilt 1956 · S/N 28693 N6094AKtkv Flyers Inc · Tomahawk, WIBuilt 1956 · S/N 28694 N6099AAnderson Timothy D · Mountain Iron, MNBuilt 1956 · S/N 28699 N6101EScherer Dean W · Saint Joseph, MNS/N 46201 N6103ERadloff Adam E · Delaware, OHBuilt 1958 · S/N 46203 N6106EBaer Mack III · Marshall, VABuilt 1958 · S/N 46206 N6109ELucia Christoper J · West Brookfield, MABuilt 1958 · S/N 46209 N6112EMcintire John R · Haymarket, VABuilt 1958 · S/N 46212 N6113EPlane Old LLC · Bristol, VTBuilt 1958 · S/N 46213 N6119EBliss Richard F · Talladega, ALS/N 46219 N6120EFirestone Johnnie E · Portales, NMBuilt 1958 · S/N 46220 N6121ETevik Michael A · Provo, UTS/N 46221 N6122EHolko Mickal A · Ravensdale, WABuilt 1958 · S/N 46222 N6124EToay Thomas E · Waterloo, WIBuilt 1958 · S/N 46224 N6125EIvco Vne Consulting LLC · Wilmington, DEBuilt 1958 · S/N 46225 N6127ECardan Aircraft Services Inc · Redding, CABuilt 1958 · S/N 46227 N6128EWang Tekang · Ashburn, VABuilt 1959 · S/N 46228 N612RKMalcomson Kenneth L · Cresson, TXBuilt 1959 · S/N 46603 N6130ERounds Donald W DBA · Waller, TXS/N 46230 N6131EWilliams Rick J · Cooperstown, NYBuilt 1958 · S/N 46231 N6136ERotormate LLC · Royse City, TXS/N 46236 N6139EWarner Aviation LLC · Belding, MIBuilt 1958 · S/N 46239 N6140EIorio Jeffrey M · Tucson, AZBuilt 1958 · S/N 46240 N6141EAbpz LLC · Mc Veytown, PABuilt 1958 · S/N 46241 N6142EHabecker David A · Tecumseh, MIBuilt 1958 · S/N 46242 N6144EBlack Kenneth Cory · Chillicothe, OHBuilt 1958 · S/N 46244 N6145ESaylor Willa G · Newburg, PAS/N 46245 N6146EDahlberg James C · Ogilvie, MNBuilt 1958 · S/N 46246 N6148EPlant Robert L · Churubusco, INBuilt 1958 · S/N 46248 N6150ENeedham George T · Seattle, WABuilt 1958 · S/N 46250 N6152ESkyranch Knoxville Youth Inc · Knoxville, TNS/N 46252 N6156EPaynter John W · West Bath, MEBuilt 1958 · S/N 46256 N6157ERegistered aircraftBuilt 1958 · S/N 46257 N6158EHepler Paul C · Harrisburg, PABuilt 1958 · S/N 46258

Back to Cessna 172