Skip to content

Registered aircraft · 718

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

N8191UAnderson Amy J · Manistique, MIBuilt 1964 · S/N 17252091 N8192UMichael Isiah · Jersey City, NJBuilt 1964 · S/N 17252092 N8194UHutson Clayton · Elgin, OKBuilt 1964 · S/N 17252094 N8198UTower Christopher M · Piedmont, OKBuilt 1964 · S/N 17252098 N8199UReeder James T · Ottawa, KSS/N 17252099 N8201ULerma Homero G · Mcallen, TXBuilt 1964 · S/N 17252101 N8202UBudget Flyers · Shreveport, LABuilt 1964 · S/N 17252102 N8204USchenck Paul · Glendale, CAS/N 17252104 N8205UDby Flights LLC · Pennock, MNBuilt 1964 · S/N 17252105 N8206UShortridge Gary F · Dover, TNBuilt 1964 · S/N 17252106 N8213UJohnson Matthew K · Paducah, KYBuilt 1964 · S/N 17252113 N8214UN8214u LLC · Sheridan, ARBuilt 1964 · S/N 17252114 N8216UClinch Jerome J · Lincoln, NEBuilt 1964 · S/N 17252116 N8218USalley Ronald C · Satellite Beach, FLBuilt 1964 · S/N 17252118 N8219UShaffer Kenneth H · Trout Lake, WABuilt 1964 · S/N 17252119 N8222UCramer Bill · Oxnard, CABuilt 1964 · S/N 17252122 N8223UChapter 36 Flying Club Inc · Hagerstown, MDBuilt 1964 · S/N 17252123 N8224UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1964 · S/N 17252124 N8227UGeiger Russell K · Hilliard, FLBuilt 1964 · S/N 17252127 N8228Cross John · Canton, OHBuilt 1965 · S/N 17252520 N8229UBurmeister James · Roseville, CABuilt 1964 · S/N 17252129 N8234URegistered aircraftBuilt 1964 · S/N 17252134 N8235ULind Gerald Wayne · Oakley, IDS/N 17252135 N8237UNo Money For Plane LLC · Grand Rapids, MIBuilt 1964 · S/N 17252137 N8238UPowers Robert · Iowa City, IABuilt 1964 · S/N 17252138 N8241URegistration Pending · Casa Grande, AZRegistration pendingBuilt 1964 · S/N 17252141 N8247UComeau Paul D · Walden, NYBuilt 1964 · S/N 17252147 N8248URobison Wm Lee · Smithville, MOBuilt 1964 · S/N 17252148 N8249UDracka Charles L · Port Clinton, OHS/N 17252149 N8250UCalderon Daniel · Orlando, FLS/N 17252150 N8254UWolf Nathan · Wishek, NDBuilt 1964 · S/N 17252154 N8256URegistered aircraftBuilt 1964 · S/N 17252156 N8260USteier William Charles · Inver Grove, MNBuilt 1964 · S/N 17252160 N8265UHickey Kenneth E · Crossville, TNS/N 17252165 N8272UCraig Harry L II · Buckhannon, WVBuilt 1964 · S/N 17252172 N8273UWings Of Grace Ministries Inc · Melbourne, FLBuilt 1964 · S/N 17252173 N8277UEdgewood Farms LLC · Groveland, NYBuilt 1964 · S/N 17252177 N8278UMattison Alan B · Petaluma, CABuilt 1964 · S/N 17252178 N8281UHersch Richard E · Arlington, WAS/N 17252181 N8283UThede Dondi I · Marshall, WIBuilt 1964 · S/N 17252183 N8285UDel Martin Lp · Spring, TXBuilt 1964 · S/N 17252185 N8289UPrice William B · Lamar, SCBuilt 1964 · S/N 17252189 N8291UBarnett William M · Rolla, MOBuilt 1964 · S/N 17252191 N8292URettkowski Brady A · Hermiston, ORBuilt 1964 · S/N 17252192 N8295UCrawfish Co LLC · Starkville, MSBuilt 1964 · S/N 17252195 N8297UMcburney Richard O · Hudson, NCBuilt 1964 · S/N 17252197 N8300UFrisby Richard V · Fredericksburg, VABuilt 1964 · S/N 17252200 N8301UN8301u LLC · White Springs, FLBuilt 1964 · S/N 17252201 N8305USkyhawk Leasing LLC · Port Huron, MIBuilt 1964 · S/N 17252205 N8310UUnderwood Michael D II · Piney Flats, TNS/N 17252210

Back to Cessna 172F