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.

N9457DN1705r Inc · Cobb, CAS/N 172RG1172 N9461DDurghinescu Cris Nicolae · Rancho Mirage, CABuilt 1984 · S/N 172RG1174 N9463DHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1984 · S/N 172RG1175 N9465DMehrer Fritz J · Oceanside, CAS/N 172RG1176 N9468DKelly Henry Searles · Ossining, NYBuilt 1984 · S/N 172RG1177 N9474BDiehl Greg · Angola, INBuilt 1981 · S/N 172RG0833 N9480DKent State University · Stow, OHBuilt 1985 · S/N 172RG1180 N9481DBoemig Madison K · Dalton, NHBuilt 1985 · S/N 172RG1181 N9486BMccoy Robert P · Fairbanks, AKBuilt 1981 · S/N 172RG0837 N948SMScenic Concepts LLC · La Crosse, WIBuilt 1982 · S/N 172RG1057 N9490DMehrer Fritz J · El Cajon, CAS/N 172RG1185 N9495DEichholz Kenneth D · Cordova, TNBuilt 1985 · S/N 172RG1187 N949SMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 172RG0713 N9502BGraceffa Salvatore · Atascadero, CABuilt 1981 · S/N 172RG0839 N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842 N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844 N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846 N951HCUsweixin · Sheridan, WYBuilt 1980 · S/N 172RG0282 N9526BWildenberg Ronald · Beloit, WIBuilt 1981 · S/N 172RG0855 N9530BSierra Alpha Aeronautical LLC · San Antonio, TXBuilt 1981 · S/N 172RG0858 N9539BThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1981 · S/N 172RG0865 N953SMBogen Alfred T · Brandon, MSBuilt 1980 · S/N 172RG0772 N9540BFly8ma LLC · Big Lake, AKBuilt 1981 · S/N 172RG0866 N9542BSoileau Kenneth B · Lancaster, SCBuilt 1981 · S/N 172RG0867 N9545BSunrise Aero Inc · Ocala, FLBuilt 1981 · S/N 172RG0870 N9550BMccall Freddie W · Brewton, ALBuilt 1981 · S/N 172RG0872 N9551BLopes Gaston A · Dallas, TXS/N 172RG0873 N9557BGibson Robert B · Los Alamos, NMBuilt 1981 · S/N 172RG0879 N9562BCharleston Flying Club LLC · Charleston, SCBuilt 1981 · S/N 172RG0882 N9566BQualitair LLC · MichelstadtBuilt 1981 · S/N 172RG0885 N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890 N9574BHinds Community College · Bolton, MSBuilt 1981 · S/N 172RG0891 N9577BRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1981 · S/N 172RG0894 N9578BHalseth Harald E · El Paso, TXBuilt 1981 · S/N 172RG0895 N9583BBurke Larry Ryan · Pembroke, GABuilt 1981 · S/N 172RG0898 N9584B360 Marine · Bristol, RIBuilt 1981 · S/N 172RG0899 N9591BSmith Justin T · Marshfield, WIBuilt 1981 · S/N 172RG0904 N9593BBehnke Christopher H · SiegburgBuilt 1981 · S/N 172RG0906 N9598BIpsen Michael · Kenosha, WIBuilt 1981 · S/N 172RG0909 N95JALane Christopher C · Dallas, TXBuilt 1979 · S/N 172RG0015 N9602BLaguna Verde Leasing Inc · Wilmington, DES/N 172RG0912 N9619BEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 172RG0924 N9626BAirgo Inc · Centralia, ILBuilt 1981 · S/N 172RG0927 N9631BPercy Flyers LLC · Dexter, MIBuilt 1981 · S/N 172RG0930 N9635BFisher Frank L · San Diego, CABuilt 1981 · S/N 172RG0933 N9646BN9646b LLC · Wilmington, DEBuilt 1981 · S/N 172RG0942 N9647BLakewood Investments LLC · Victorville, CAS/N 172RG0943 N9649BGoebel Christian E · Luray, VABuilt 1981 · S/N 172RG0945 N9653BSd Office Supplies & Furniture Rentals LLC · Chula Vista, CABuilt 1981 · S/N 172RG0946 N9654BDonohue Andrew · Tulsa, OKBuilt 1981 · S/N 172RG0947

Back to Cessna 172RG