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.

N9660BHenry Lawrence D · Lohman, MOBuilt 1981 · S/N 172RG0952 N9671BJw-Hoff Rentals LLC · Mandan, NDS/N 172RG0958 N9683BTita Enterprises LLC · Apex, NCBuilt 1981 · S/N 172RG0966 N9692BAberdeen Flying Service · Aberdeen, SDBuilt 1981 · S/N 172RG0971 N9709BPeterson Air LLC · Chisago City, MNBuilt 1981 · S/N 172RG0982 N9710BWellnitz Patrick · Whitewater, WIS/N 172RG0983 N9717BCeruto Jorge · Auburndale, FLBuilt 1981 · S/N 172RG0987 N9734BPreston Aviation LLC · Henderson, KYBuilt 1981 · S/N 172RG0999 N9742BHarp Aviation LLC · Flemington, NJBuilt 1981 · S/N 172RG1005 N9743BVinson Paul E DBA · Gainesville, GABuilt 1981 · S/N 172RG1006 N9746BRegistration Pending · Middletown, DERegistration pendingBuilt 1981 · S/N 172RG1009 N9752BUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1981 · S/N 172RG1012 N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015 N9770BCastle Michael Bernard · Raleigh, NCS/N 172RG1024 N9773BChagres Flight Training LLC · Albuquerque, NMBuilt 1981 · S/N 172RG1027 N9774BWagner Michael D · Winter, WIBuilt 1981 · S/N 172RG1028 N9775BAequalis Photography Corp · Tacoma, WAFirst renewal noticeBuilt 1981 · S/N 172RG1029 N9779B79b Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG1031 N9784BRecycleworx LLC · Sun City, AZBuilt 1981 · S/N 172RG1034 N9785BWebber Thomas W · Placerville, CABuilt 1981 · S/N 172RG1035 N9786BTri State Airmotive LLC · Berryville, ARS/N 172RG1036 N9787BRiemer Thomas H · Winchester, VABuilt 1981 · S/N 172RG1037 N9791BHicks Keith · Sweetwater, TNS/N 172RG1039 N9795BSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1982 · S/N 172RG1042 N9812BPavco Inc · Gig Harbor, WABuilt 1982 · S/N 172RG1046 N9813BTsiper Evgueni · Eagan, MNBuilt 1982 · S/N 172RG1047 N9836BSoulek Paul A · Spearfish, SDBuilt 1982 · S/N 172RG1051 N9838BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1052 N9844BRegistration Pending · Mount Pleasant, UTRegistration pendingBuilt 1982 · S/N 172RG1054 N9863BMckee Brendan H · Hermosa Beach, CABuilt 1982 · S/N 172RG1059 N9864BN1705r Inc · Cobb, CABuilt 1982 · S/N 172RG1060 N9873BGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1982 · S/N 172RG1064 N9877BAndra Joshua Corey · Riverton, UTBuilt 1982 · S/N 172RG1066 N9915BTaro Investment LLC · Doral, FLBuilt 1982 · S/N 172RG1078 N9919BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 172RG1080 N9920BSchultz Robert G · Baker, FLBuilt 1982 · S/N 172RG1081 N9924BNatre Air II LLC · Tipton, INBuilt 1982 · S/N 172RG1082 N9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeBuilt 1982 · S/N 172RG1084 N9969BGreenwalt Bert · Jonesboro, ARBuilt 1982 · S/N 172RG1101 N9973BMajor Air LLC · Charleston, SCBuilt 1982 · S/N 172RG1103 N9974BAppalachian Aviation LLC · Harrisonburg, VABuilt 1982 · S/N 172RG1104 N9985BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1107 N9990BAurora-Flight LLC · Commerce Township, MIBuilt 1982 · S/N 172RG1109 N9991BTaft Leasing LLC · Bloomfield, NMBuilt 1982 · S/N 172RG1110 N99TCUltimate Resort Vacations Inc · Weston, FLBuilt 1980 · S/N 172RG0412

Back to Cessna 172RG