Skip to content

Registered aircraft · 3,572

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

N172MLHampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17261580 N172MSAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1974 · S/N 17263928 N172PGAviation Career Enrichment Inc · Atlanta, GABuilt 1975 · S/N 17265821 N172PRPark Rapids Aviation Inc · Park Rapids, MNBuilt 1974 · S/N 17264084 N172RJRidgik George H · Jamestown, COBuilt 1974 · S/N 17263314 N172RRFly Lugu LLC · Southwick, MABuilt 1973 · S/N 17261788 N172SGLehner Raymond A Jr · North Fort Myers, FLBuilt 1973 · S/N 17261734 N172SZPowell Terry · Sheridan, WYBuilt 1975 · S/N 17265508 N172TCMeweber Consulting Inc · Atlanta, MIBuilt 1976 · S/N 17266662 N172THDairy Air Inc · Wyoming, PABuilt 1972 · S/N 17261033 N172TSVero Technical Support Inc · Pensacola, FLBuilt 1974 · S/N 17264582 N172VFVictor Foxtrot LLC · Scott City, KSBuilt 1975 · S/N 17265334 N172VTFly Vermont LLC · Swanton, VTS/N 17263231 N172WEEl Aero Services LLC · Elko, NVBuilt 1975 · S/N 17265192 N172WJBlue Skies Flight Training LLC · Gainesville, FLBuilt 1972 · S/N 17260906 N172WLLeveille Wade P · Douglas, MABuilt 1975 · S/N 17265300 N172WPAviair LLC · Wilmington, NCBuilt 1973 · S/N 17262635 N172WSWoodstock Air LLC · Cincinnati, OHBuilt 1973 · S/N 17261328 N172WTTison William A Jr · Boynton Beach, FLS/N 17266400 N172WWStraight And Level Seaplanes LLC · Grand Island, FLBuilt 1976 · S/N 17267445 N172YNewton Michael R · Creston, WABuilt 1974 · S/N 17263360 N172YYApr Aviation · Fresno, CABuilt 1974 · S/N 17263986 N1732VElk & Ram Aviation Group LLC · San Antonio, TXBuilt 1974 · S/N 17263729 N1737High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17265682 N1737VWatson Patrick D · Kenyon, MNBuilt 1974 · S/N 17263732 N173KADaigle Lawrence J · Cohasset, MNBuilt 1972 · S/N 17260939 N1742VGalion Air Inc · Galion, OHBuilt 1974 · S/N 17263735 N1743VRegistered aircraftBuilt 1974 · S/N 17263736 N1749VVance Nicholas D · Bluffton, OHS/N 17263737 N1754VAviation Specialist Inc · Apison, TNBuilt 1974 · S/N 17263739 N1758VKrickhahn Kermit O · Marion, TXBuilt 1974 · S/N 17263740 N1759VFelbaum Jill E · Tecumseh, MIS/N 17263741 N175KAAir Cruiser LLC · New York, NYBuilt 1973 · S/N 17262117 N1764VGross John F · Winthrop, MEBuilt 1974 · S/N 17263743 N1766VCode4 Ventures Inc DBA · Waynesboro, VABuilt 1974 · S/N 17263744 N1768VBrown Craig D · Fort Wayne, INBuilt 1974 · S/N 17263745 N1774VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263747 N178FVD R Tripp Enterprises LLC · Omaha, NEBuilt 1976 · S/N 17267284 N178RSDowns Austin J DBA · Liberal, KSBuilt 1974 · S/N 17262925 N1791VOmargows Ali · Columbus, OHBuilt 1974 · S/N 17263752 N1793VAviation Capital Management LLC · San Jose, CABuilt 1974 · S/N 17263753 N17HZLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 172-66345 N17UPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1974 · S/N 17263440 N1802VWard Robert L Jr · Cleburne, TXBuilt 1974 · S/N 17263756 N1814VBeyer Leasing Co · Paw Paw, MIS/N 17263759 N1820VAsp Kenneth · Thief River Falls, MNBuilt 1974 · S/N 17263762 N183RLJe Air LLC · Bayamon, PRBuilt 1973 · S/N 17261654 N1840VUnited States Air Force Owner · Apo, APBuilt 1974 · S/N 17263767 N1845VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263769 N1854VSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 17263771

Back to Cessna 172M