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.

N7049GLouisville Aircraft Leasing LLC · Louisville, KYS/N 17258749 N7050GAircraft Management Group Inc · Honolulu, HIBuilt 1969 · S/N 17258750 N7051GWein Greggory J · Convoy, OHBuilt 1969 · S/N 17258751 N7052GG&H Aviation · Louisville, KYBuilt 1969 · S/N 17258752 N7053GSpare Change Enterprises LLC · Atlantic, IABuilt 1969 · S/N 17258753 N70541Cl Finney Aviation LLC · Benton, KSBuilt 1969 · S/N 17258757 N7058GDc Aerial Photos Inc · Fredericksburg, VABuilt 1969 · S/N 17258758 N7059GFrank Todd E · Corsicana, TXBuilt 1969 · S/N 17258759 N7062GNorthwoods Aviation LLC · Eagle River, WIS/N 17258762 N7063GL A H Eickhoff Farms Inc · Falls City, NEBuilt 1969 · S/N 17258763 N7065GAden David L · Keenesburg, COBuilt 1969 · S/N 17258765 N7066GSwindle Don K · Collinsville, TXBuilt 1969 · S/N 17258766 N7067GAngelle Kelli R · New Roads, LABuilt 1969 · S/N 17258767 N7069GAjf Enterprises LLC · Des Moines, IABuilt 1969 · S/N 17258769 N7070GGade Christopher P · Williston, VTFirst renewal noticeBuilt 1969 · S/N 17258770 N7071GWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258771 N7072GMears Benjamin W III · Eastville, VABuilt 1969 · S/N 17258772 N7073GSky Warriors LLC · Hayward, CAS/N 17258773 N7075GDraper Floyd L · El Paso, TXBuilt 1969 · S/N 17258775 N7082GBbt Inc · Wilmington, DEBuilt 1969 · S/N 17258782 N7083GMassie Robert G · Whitewater, WIBuilt 1969 · S/N 17258783 N7085GRegistered aircraftBuilt 1969 · S/N 17258785 N7086GSniffen Wesley H · Sycamore, OHBuilt 1969 · S/N 17258786 N7087GRavindran Manoj · Clarksville, TNBuilt 1970 · S/N 17258787 N7088GSardeis LLC · River Hills, WIS/N 17258788 N7091GSkylark Flight Training LLC · Wilmington, DEBuilt 1969 · S/N 17258791 N7092GAmick Thomas C · Newberry, SCBuilt 1969 · S/N 17258792 N7093GAero Performance LLC · Scooba, MSBuilt 1969 · S/N 17258793 N7094GJohnson And Assoc · Davenport, IABuilt 1969 · S/N 17258794 N7095GHunter John Bockett · Riverton, NJBuilt 1969 · S/N 17258795 N7097GMurdy David C · Round Rock, TXBuilt 1969 · S/N 17258797 N7099GHunt Howard E · Martinsville, ILBuilt 1969 · S/N 17258799 N70KPPrichard Kevin L · Enterprise, KSBuilt 1969 · S/N 17257954 N7100GBoyd John J · Wasilla, AKBuilt 1969 · S/N 17258800 N7101GBowhawk LLC · Ocala, FLBuilt 1969 · S/N 17258801 N7102GBarbosa Manuel · Apple Valley, MNBuilt 1969 · S/N 17258802 N7103GMountain Flyers Inc · Hendersonville, NCBuilt 1969 · S/N 17258803 N7104GAir Carriage LLC · Chico, CABuilt 1969 · S/N 17258804 N7108GLakes Area Aviation LLC · Little Falls, MNS/N 17258808 N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812 N7117GBaker Brady B · South Hero, VTBuilt 1969 · S/N 17258817 N711GTRadcliff Charles · Las Vegas, NVBuilt 1969 · S/N 17258811 N7120GSky Hook Inc · Red Wing, MNBuilt 1969 · S/N 17258820 N7122GBirmingham Flight Center LLC · Birmingham, ALBuilt 1969 · S/N 17258822 N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823 N7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825 N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828 N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829 N7139GSkysg LLC · Eugene, ORBuilt 1969 · S/N 17258839 N7141GDyke Paul A · Hartford, SDBuilt 1969 · S/N 17258841

Back to Cessna 172K