Skip to content

Registered aircraft · 413

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

N7538XSpratt John G · Watkinsville, GABuilt 1960 · S/N 17248038 N7539XWalnut Valley Aviation LLC · Wilmington, DEBuilt 1960 · S/N 17248039 N7541XRegistered aircraftBuilt 1960 · S/N 17248041 N7544XRobert S Williams Dds Ps · Grandview, WABuilt 1960 · S/N 17248044 N7547XArmitage Donald · New Derry, PABuilt 1960 · S/N 17248047 N7548XKruger Daniel G · Stateline, NVBuilt 1960 · S/N 17248048 N7549XNagy Alec S · Cherry Hill, NJBuilt 1960 · S/N 17248049 N7551XDraughon Robert W · Forney, TXS/N 17248051 N7560XCrew Gerald · Edna Bay, AKBuilt 1960 · S/N 17248060 N7563XLogan Zachary R · Stamford, TXBuilt 1960 · S/N 17248063 N7564XSodah One LLC · San Ramon, CAS/N 17248064 N7566XKeenan Drew P · Chico, CABuilt 1960 · S/N 17248066 N7568XKrassovsky Viatcheslav · Berkeley, CABuilt 1960 · S/N 17248068 N7570XJones Frank E · Merritt Island, FLBuilt 1960 · S/N 17248070 N7571XBrown Bomber Aviation LLC · Little Rock, ARS/N 17248071 N7574XParker Air LLC · Corinth, MSBuilt 1960 · S/N 17248074 N7577XBlusky Aviation LLC · Palmyra, INBuilt 1960 · S/N 17248077 N7578XHamilton Randel L · Quitaque, TXBuilt 1960 · S/N 17248078 N7580XSorgen Michael A · Corning, NYBuilt 1960 · S/N 17248080 N7582XSemchenko Norval K · Max, NDBuilt 1960 · S/N 17248082 N7583XGreene Bryan V · Turlock, CABuilt 1960 · S/N 17248083 N7587XBrown Bomber LLC · Missoula, MTS/N 17248087 N7593XMills Laura L · Canton, OHBuilt 1960 · S/N 17248093 N7595XDelgado Mario Jr · Baldwin Park, CAS/N 17248095 N7596XBurklund Joel · Minneapolis, MNBuilt 1960 · S/N 17248096 N7599XDmac Aircraft LLC · Savannah, GABuilt 1960 · S/N 17248099 N7600XDemurat Bryan F · Casselberry, FLBuilt 1960 · S/N 17248100 N7602XBurkett Anthony E · Rock Hill, SCS/N 17248102 N7605XCastleberry Robert F · Sanford, NCS/N 17248105 N7606XRegistered aircraftS/N 17248106 N7607XHall Douglas F · Pembine, WIBuilt 1960 · S/N 17248107 N7608XStanton Todd D · Plains, KSBuilt 1960 · S/N 17248108 N7615XEagle Flight Inc. · Fremont, NEBuilt 1960 · S/N 17248115 N7619XWeitzel Claus P · Newington, GABuilt 1960 · S/N 17248119 N7620XRegistered aircraftBuilt 1960 · S/N 17248120 N7622XReale R Robert · Marblemount, WABuilt 1961 · S/N 17248122 N7623XDorman David L · Garfield, MNBuilt 1960 · S/N 17248123 N7627XFindley Michael A · Moreland, GAS/N 17248127 N7628XZintz Michael S · Centerville, IABuilt 1960 · S/N 17248128 N7629XNeu Aviation LLC · Benton, LABuilt 1960 · S/N 17248129 N7631XCiccosanti John P · Kingston, NYBuilt 1960 · S/N 17248131 N7632XTrompeter Mark S · Intl Falls, MNBuilt 1960 · S/N 17248132 N7633XHillis Robert Duane · Utopia, TXBuilt 1960 · S/N 17248133 N7637XReddy Investments LLC · Contoocook, NHS/N 17248137 N7638XBreaux Matthew J · Grosse Tete, LAS/N 17248138 N7640XNotre Amour LLC · Cypress, TXBuilt 1960 · S/N 17248140 N7641XEngelhardt David J · Williamsburg, OHBuilt 1960 · S/N 17248141 N7642XGrey Eagle Aviation LLC · Walker, MNBuilt 1960 · S/N 17248142 N7643XBrackman Aviation LLC · Twin Falls, IDBuilt 1960 · S/N 17248143 N7646XGeorge James D · Aurora, INS/N 17248146

Back to Cessna 172B