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.

N107RCHat Creek Construction & Development Inc · Glennville, GABuilt 1981 · S/N 172RG0807 N107TSSmith Terry G · Liberty Twp, OHBuilt 1982 · S/N 172RG0907 N108EAArellano Erick C · Brownsville, TXS/N 172RG0674 N111HPFlying Aces Aero-Fleet Inc · Guyton, GABuilt 1984 · S/N 172RG1153 N117PBLadue Scott B · Fate, TXBuilt 1981 · S/N 172RG0897 N117RCMaresh Jeremiah · Redding, CAS/N 172RG0034 N131VUMalisa Michael D · Goodyear, AZBuilt 1985 · S/N 172RG1191 N151VUVincennes University · Indianapolis, INBuilt 1980 · S/N 172RG0667 N15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 172RG0115 N169ECFirst Eclipse Limited · Richmond, VABuilt 1980 · S/N 172RG0515 N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189 N172BDMurawski Rene · Clarkston, MIBuilt 1981 · S/N 172RG0960 N172CESan Diego Community College District · San Diego, CAS/N 172RG0529 N172DPSuperior Aviation Gateway LLC · Tampa, FLBuilt 1980 · S/N 172RG0465 N172KAVenture North Aviation LLC · Cloquet, MNS/N 172RG0854 N172MMEwing & Coryell LLC · Nixa, MOS/N 172RG0286 N172PESale Reported · Kenmore, WASale reportedBuilt 1979 · S/N 172RG0042 N172RGMaxwell Don P II · Longview, TXBuilt 1979 · S/N 172RG0083 N172SFTichy Joseph R · Napa, CABuilt 1984 · S/N 172RG1149 N172ZGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 828 N173RGBuchert Christine W · SchweinfurtBuilt 1980 · S/N 172RG0218 N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074 N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323 N212BGRegistered aircraftBuilt 1980 · S/N 172RG0195 N216JARuble Howard L Jr · Spartanburg, SCBuilt 1980 · S/N 172RG0467 N22JNRegistered aircraftBuilt 1979 · S/N 172RG0215 N2452UPuryear Rodney K · Pampa, TXBuilt 1982 · S/N 172RG1049 N247LWHailey & Harmony Enterprises LLC · Las Vegas, NVS/N 172RG0314 N251HPKoch & Koch Inc · Grass Valley, CABuilt 1982 · S/N 172RG1124 N274GTSkogen Joseph S · Coeur D Alene, IDBuilt 1983 · S/N 172RG1141 N2775RMiller David · Tyler, TXBuilt 1980 · S/N 172RG0624 N28RJMisch Keith · Bayonne, NJS/N 172RG0869 N2SKRegistered aircraftBuilt 1980 · S/N 172RG0666 N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291 N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019 N345CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 172RG0726 N369ERTower Aviation Management LLC · Decatur, TXS/N 172RG0062 N369NEPeter Travis E · Evansville, WYBuilt 1979 · S/N 172RG0233 N406PTMurray John J · Kalispell, MTBuilt 1981 · S/N 172RG0801 N413EBG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0113 N4252FLunn James · Winchester, CAS/N 172RG0644 N425DLTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1979 · S/N 172RG0143 N426DLHawk30 Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0827 N42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172RG0703 N4593VFranklin Eric J · Anchorage, AKBuilt 1980 · S/N 172RG0330 N4601RMiddle Tennessee State University · Murfreesboro, TNS/N 172RG0003 N4601VDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 172RG0336 N4604VRogers Ann M · Traverse City, MIS/N 172RG0337 N4614RAltair Aircraft LLC · Gainesville, FLBuilt 1979 · S/N 172RG0004 N4624VFisher Gregory S · Franklin, WIS/N 172RG0342

Back to Cessna 172RG