Skip to content

Registered aircraft · 445

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

N6425VRegistered aircraftBuilt 1980 · S/N 172RG0686 N6426VGlobal Aviators Academy Inc · Claremont, CAS/N 172RG0687 N6428VDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 172RG0689 N6429VScott Dean A · Winchester, VABuilt 1980 · S/N 172RG0690 N642RSRomeo Sierra Aviation LLC · Sparks, NVBuilt 1980 · S/N 172RG0472 N6432VShortridge Randall R · Mesa, AZBuilt 1980 · S/N 172RG0693 N6435VKirk James B · Lancaster, SCBuilt 1980 · S/N 172RG0696 N6436VJones Gregory D · Pueblo, COS/N 172RG0697 N6444VPowell William G Jr · Greenville, NCBuilt 1980 · S/N 172RG0705 N6455VCrown Flying Club Inc · Olathe, KSBuilt 1981 · S/N 172RG0711 N6456VRosing David · Sunland, CAS/N 172RG0712 N6458VWilson David P · Lumberton, TXBuilt 1980 · S/N 172RG0714 N6461VRegistered aircraftBuilt 1980 · S/N 172RG0716 N6462VVanbergen Shaun S · Ashland City, TNBuilt 1980 · S/N 172RG0717 N6464RChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N 172RG0184 N6488VThree Mayhoods LLC · Bonita Springs, FLS/N 172RG0725 N64TSLippincott George T · Thermopolis, WYBuilt 1981 · S/N 172RG0959 N6503VSt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 172RG0736 N6504VYoung Charles Wade · Rogers, ARBuilt 1980 · S/N 172RG0737 N6511VSc Skywalker Aviation LLC · West Sacramento, CABuilt 1980 · S/N 172RG0741 N6522RKnot Ventures LLC · Kalispell, MTBuilt 1979 · S/N 172RG0191 N6523VReal Jonathan D · Kamuela, HIBuilt 1980 · S/N 172RG0749 N6526VGoodrow Anthony F · Creede, COBuilt 1980 · S/N 172RG0752 N6527RAmerican Aviation LLC · Yuma, AZBuilt 1979 · S/N 172RG0196 N6528VFischer Heather A · Merrimack, NHBuilt 1980 · S/N 172RG0754 N6529VAhlhorn Travis Wayn · New Braunfels, TXBuilt 1980 · S/N 172RG0755 N6530RByers Travis M · Villa Rica, GABuilt 1979 · S/N 172RG0199 N6531RBruno Gennaro S · Lewes, DEBuilt 1979 · S/N 172RG0200 N6535VEllenberg Sholom · Weston, CTBuilt 1981 · S/N 172RG0731 N6536VTran Dai A · Rancho Cucamonga, CABuilt 1980 · S/N 172RG0760 N6538VSommer Timothy T · Combined Locks, WIBuilt 1980 · S/N 172RG0762 N6542VHarris Dakota · Goose Creek, SCBuilt 1980 · S/N 172RG0765 N6543VChupito Sabrocito LLC · Paso Robles, CABuilt 1980 · S/N 172RG0766 N6548VMaxwell Frank R · Fairbanks, AKBuilt 1980 · S/N 172RG0771 N6562VAero-Sphere Inc · Longmont, COBuilt 1980 · S/N 172RG0775 N6565VHodges Marshall E · Orange, TXBuilt 1980 · S/N 172RG0776 N6568RJofredo Corp · Zephyrhills, FLBuilt 1979 · S/N 172RG0202 N6577RAir Echo Alpha 51 LLC · Erie, COBuilt 1979 · S/N 172RG0203 N6581VSimmons Claude E · Ocracoke, NCBuilt 1980 · S/N 172RG0777 N6600RDoyles Welding Lc · Phillipsburg, KSBuilt 1979 · S/N 172RG0206 N6601RHolmes Donald R · Carlsbad, CABuilt 1979 · S/N 172RG0207 N6608RBogovich Robert E · Clifton, TXBuilt 1979 · S/N 172RG0210 N6612RCourtney David P · Reedsport, ORBuilt 1979 · S/N 172RG0214 N6612VEverman Terry Jay · Vassar, MIBuilt 1980 · S/N 172RG0781 N6614VThomas Anna D · Kiana, AKS/N 172RG0782 N6618VLang Gerald K · Baker, MTBuilt 1980 · S/N 172RG0783 N6620RWhite Richard C · Tracy, CABuilt 1979 · S/N 172RG0217 N6620VHall Steven R · Cambridge, MABuilt 1980 · S/N 172RG0784 N6623ZMage Aircraft Leasing LLC · San Antonio, TXBuilt 1980 · S/N 172RG0240 N700AGMash Kity J LLC · Grand Rapids, MIBuilt 1981 · S/N 172RG0670

Back to Cessna 172RG