Skip to content

Registered aircraft · 1,025

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

N79009Birkholz Raymond J · Boulder, COBuilt 1968 · S/N 17257806 N79012Brewer Jeremiah L · Eagle River, AKBuilt 1968 · S/N 17257809 N79013Woods Michael F · Hamilton, NJBuilt 1968 · S/N 17257810 N79014Fcs Aviation LLC · Lewisport, KYBuilt 1968 · S/N 17257811 N79015Flying Weaners Inc · Jacksonville, FLBuilt 1968 · S/N 17257812 N79021Smith Timothy C Trustee · Riverton, WYS/N 17257816 N79024Jwp Flying Services LLC · Chatfield, MNBuilt 1968 · S/N 17257819 N79027Arrow North LLC · Missoula, MTBuilt 1968 · S/N 17257822 N79028Jdc Aviation LLC · Upland, CABuilt 1968 · S/N 17257823 N79031Smith Robert L II · Spencer, WVBuilt 1968 · S/N 17257826 N79036Buiqui Aerospace Corp · Kissimmee, FLS/N 17257831 N79040Higinbotham Larry L · Littleton, COBuilt 1968 · S/N 17257835 N79042N79042 LLC · Rock Hill, SCBuilt 1968 · S/N 17257837 N79048High Stakes Aviation LLC · Fresno, CABuilt 1968 · S/N 17257841 N79050Batto Jeannie L · Madison, INBuilt 1969 · S/N 17257843 N79052Rose Gary A · Brighton, TNBuilt 1968 · S/N 17257844 N79054N18228 Inc · Williamsburg, VABuilt 1969 · S/N 17257846 N79055Amies John W · Zimmerman, MNBuilt 1968 · S/N 17257847 N79057First Eclipse Limited · Richmond, VABuilt 1968 · S/N 17257849 N79060K&L Aviation LLC · Prosper, TXBuilt 1968 · S/N 17257851 N79062Pierce Brenden D · Eatonville, WAS/N 17257853 N79063Sprague Todd K · Placerville, CABuilt 1968 · S/N 17257854 N79065Kingston Thomas P · Carmel, INBuilt 1968 · S/N 17257856 N79066Doran Vincent J Jr · Wasilla, AKBuilt 1968 · S/N 17257857 N79068Padgett Leonard Dale · Hobart, OKBuilt 1968 · S/N 17257858 N79071Cottrell Mark C · Leitchfield, KYBuilt 1968 · S/N 17257860 N79072Registered aircraftBuilt 1968 · S/N 17257861 N79079Jones Farm Fresh LLC · Bartlett, TNBuilt 1968 · S/N 17257867 N79081James Ferrick · Mechanicville, NYBuilt 1968 · S/N 17257869 N79086Marshall County Flying Club Inc · Lacon, ILBuilt 1968 · S/N 17257870 N79087Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 17257871 N79089Ramaswamy Gautam · Clearwater, FLBuilt 1968 · S/N 17257872 N79090Caughman John R · Katy, TXBuilt 1968 · S/N 17257873 N79092Aero Quest LLC DBA · Olive Branch, MSBuilt 1968 · S/N 17257874 N79093Bray Austin M · Pontotoc, MSBuilt 1968 · S/N 17257875 N79095Hole In The Clouds Rentals LLC · Montgomery, ALBuilt 1969 · S/N 17257877 N79102Van Wert County Regional Airport Aurthoirty · Van Wert, OHBuilt 1969 · S/N 17257882 N79104Roman Nose Flying Club Inc · Newalla, OKBuilt 1969 · S/N 17257884 N79105Linn Nicholas D · Norfolk, NEBuilt 1969 · S/N 17257885 N79113Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17257889 N79118Osceola Aerosport LLC · Osceola, WIBuilt 1969 · S/N 17257893 N79119Carr Randal J · Chandler, OKBuilt 1969 · S/N 17257894 N79122Johnson John C · Squaw Valley, CABuilt 1969 · S/N 17257896 N79125Brekhus Palmer A · Tolley, NDBuilt 1969 · S/N 17257897 N79126Grounded Hangar Inc · Turlock, CABuilt 1969 · S/N 17257898 N79130M&M Shipshape LLC · Kalispell, MTBuilt 1969 · S/N 17257901 N79133Rotate LLC · Eden Prairie, MNBuilt 1969 · S/N 17257903 N79136Registered aircraftBuilt 1969 · S/N 17257906 N79137Marshall Jeffery K · Pleasanton, CABuilt 1969 · S/N 17257907 N79139Manifee Doris Darlene · Black Canyon City, AZBuilt 1969 · S/N 17257909

Back to Cessna 172K