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.

N714HPTic Aerospace Inc · Miami, FLBuilt 1982 · S/N 172RG1123 N715GHodge Cle'Jae J · St Thomas, VIBuilt 1980 · S/N 172RG0653 N7258International Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 172RG-0508 N732WDBig Picture Aviation Inc · Wheaton, ILBuilt 1980 · S/N 172RG0264 N751DWGaskins Frank E · Ashland, VABuilt 1981 · S/N 172RG1002 N80138Candace A Larned Enterprises Inc · Long Beach, CABuilt 1980 · S/N 172RG0507 N81JDBarbour Grays Inc DBA · Buckhannon, WVFirst renewal noticeBuilt 1985 · S/N 172RG1184 N833TWDesert Wind Wings LLC · Mesa, AZS/N 172RG0193 N84ATJ Squared Enterprises Corp · Hendersonville, TNBuilt 1980 · S/N 172RG0791 N8642DAmerican Aviation Inc · Tracy, CABuilt 1979 · S/N 172RG0061 N864PAMorris David · Fort Mill, SCBuilt 1982 · S/N 172RG1063 N880THAviation Peter Corp Of New York · New York, NYBuilt 1980 · S/N 172RG0522 N9084FIsland Bound LLC · Dunedin, FLBuilt 1980 · S/N 172RG0352 N918PMMathews Roy · Bay Shore, NYBuilt 1980 · S/N 172RG0602 N91LVWoodfield Terry J · Pearland, TXBuilt 1980 · S/N 172RG0281 N920GBales Don · Oakhurst, CABuilt 1981 · S/N 172RG0901 N9301BGimli Son LLC · Fort Lauderdale, FLBuilt 1980 · S/N 172RG0786 N9307DAviatzone LLC · Fort Lauderdale, FLBuilt 1982 · S/N 172RG1114 N9310DRegistered aircraftBuilt 1982 · S/N 172RG1116 N9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 172RG0788 N9313DSteneker Siardus L · Vashon, WABuilt 1983 · S/N 172RG1117 N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118 N9318BAnderson Daniel R · Venus, TXS/N 172RG0790 N9320DDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 172RG1119 N9326DAll Seasons Aviation LLC · Laredo, TXBuilt 1982 · S/N 172RG1122 N9338BTopp Jason · Grace City, NDBuilt 1981 · S/N 172RG0799 N9343DAva Aviation LLC · Tappan, NYBuilt 1982 · S/N 172RG1128 N9346DHolloway James H · Merritt Island, FLBuilt 1982 · S/N 172RG1129 N9351DJennings David M · Huffman, TXBuilt 1982 · S/N 172RG1130 N9353DRegistration Pending · Simi Valley, CARegistration pending, canceledBuilt 1982 · S/N 172RG1131 N9367DMccreery Aviation Co Inc · Mcallen, TXBuilt 1983 · S/N 172RG1139 N9378DAndden Aviation LLC · Santa Monica, CABuilt 1983 · S/N 172RG1143 N937ASGc Aviation Services-1 LLC · Miamisburg, OHS/N 172RG1178 N9382DN9382d LLC · Wake Forest, NCBuilt 1983 · S/N 172RG1145 N9387DPrecise Flight LLC · Waukesha, WIBuilt 1984 · S/N 172RG1148 N9390BUnited States Air Force · Elmendorf Afb, AKBuilt 1981 · S/N 172RG0810 N9393BCameron Joseph J · Tucson, AZBuilt 1981 · S/N 172RG0811 N9394DRed Baron LLC · Middletown, DEBuilt 1984 · S/N 172RG1150 N9395BChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0812 N9412BWilliams Francis · Chester, CTBuilt 1981 · S/N 172RG0815 N9415BDulles Aviation Inc · Bristow, VABuilt 1981 · S/N 172RG0816 N941SMSchmidt Aaron B · Auburn, ALS/N 172RG0278 N9421DJeff Air Pilot Services LLC · Shelbyville, INBuilt 1984 · S/N 172RG1154 N9432DRegistered aircraftBuilt 1984 · S/N 172RG1160 N9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeBuilt 1981 · S/N 172RG0821 N9437DRichmor Aviation Inc · Scotia, NYBuilt 1984 · S/N 172RG1161 N9439BAv Dak Inc · Crystal, NDBuilt 1981 · S/N 172RG0822 N9445DTriple Fes LLC · San Antonio, TXBuilt 1984 · S/N 172RG1165 N9450DSharabi Avinoam · Las Vegas, NVS/N 172RG1166 N9456DMajka Marc · San Carlos, CABuilt 1984 · S/N 172RG1171

Back to Cessna 172RG