Skip to content

Registered aircraft · 788

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 ('2073709', '2073710')
  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 ('2073709', '2073710')
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.

N34936Danielson Wade W · Burbank, CABuilt 1976 · S/N 177RG1025 N349445 Dimension Ltd · Bradenton, FLBuilt 1976 · S/N 177RG1027 N34947Nelson Kirk M · Kenosha, WIBuilt 1976 · S/N 177RG1028 N34949Ktech Enterprises Inc · St George, UTBuilt 1976 · S/N 177RG1030 N34969Lagrone Rex F · Filer, IDBuilt 1976 · S/N 177RG1033 N34RGWestern State Flyers LLC · Irvine, CABuilt 1975 · S/N 177RG0729 N35003Aarestad James T · Buffalo, MNS/N 177RG1035 N35007Aviation Plus LLC · Lewes, DEBuilt 1976 · S/N 177RG1036 N35049Crass David B · Aledo, TXBuilt 1976 · S/N 177RG1037 N35051Soldo Joseph P · Chattanooga, TNBuilt 1976 · S/N 177RG1038 N35060Anderson Brian G · Thief River Falls, MNBuilt 1976 · S/N 177RG1039 N35182Beachy Michael H · Dundee, OHBuilt 1976 · S/N 177RG1045 N35205Riley John Roland · Ouray, COBuilt 1976 · S/N 177RG1046 N35216Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 177RG1047 N35231Dressler David S · Bend, ORBuilt 1976 · S/N 177RG1048 N352GBDavis David N · Broken Arrow, OKBuilt 1976 · S/N 177RG1075 N35373Registered aircraftBuilt 1976 · S/N 177RG1049 N35495Whitfill Charles Carlton · Blum, TXBuilt 1976 · S/N 177RG1050 N35504Air America LLC · Sioux Falls, SDBuilt 1976 · S/N 177RG1051 N35568Advance Development Inc · Muskogee, OKBuilt 1976 · S/N 177RG1053 N35821Coachair Inc · Groveland, CABuilt 1976 · S/N 177RG1056 N35833Williams David Wayne · Ivins, UTBuilt 1976 · S/N 177RG1057 N35849Gilliam Robert L · Islamorada, FLBuilt 1976 · S/N 177RG1060 N35850Willke Ronald S · Edgewood, TXBuilt 1976 · S/N 177RG1061 N35852Taylor Bruce D · Cedar Rapids, IAFirst renewal noticeS/N 177RG1062 N35858Watkins Rickar D · Roseburg, ORBuilt 1976 · S/N 177RG1063 N35866Terry Kayla · Moulton, ALBuilt 1976 · S/N 177RG1065 N35869Cardinal Flyers LLC · Moriches, NYBuilt 1976 · S/N 177RG1067 N35872Kurtz David Lee · Cordele, GABuilt 1976 · S/N 177RG1068 N35879Aldrich Brad · Driftwood, TXBuilt 1976 · S/N 177RG1069 N35884Dake Tech Consulting Inc · San Dimas, CAS/N 177RG1070 N35905Morgan George Scott · Litchfield Park, AZBuilt 1976 · S/N 177RG1074 N35913Allen John A · Hollister, MOBuilt 1976 · S/N 177RG1076 N35914Dunn Meghan Elizabeth · Mckinney, TXBuilt 1976 · S/N 177RG1077 N35936Doncar LLC · Baden, PABuilt 1976 · S/N 177RG1081 N35939Aarons Daniel A · Berkeley, CABuilt 1976 · S/N 177RG1082 N35942Schlichting Mark A · Newborn, GABuilt 1976 · S/N 177RG1083 N35976Shoemaker Calvin D · Los Angeles, CAFirst renewal noticeBuilt 1976 · S/N 177RG1087 N377BAHolliday Richard A · Fort Worth, TXBuilt 1977 · S/N 177RG1245 N380XBourgeois Olivier F · North Andover, MABuilt 1975 · S/N 177RG0751 N399JPL&M Aircraft Inc · Rome, GABuilt 1977 · S/N 177RG1111 N3MKRedwing Aviation LLC · San Antonio, TXBuilt 1977 · S/N 177RG1217 N409SPTzerefos Lambros P · Mathews, VAS/N 177RG0493 N40RBKmg Aviation Holdings LLC · Hartville, OHBuilt 1976 · S/N 177RG1071 N417DKVitrella Steven E · Melbourne, FLBuilt 1974 · S/N 177RG0563 N41EMBretscher Mark · Hinsdale, ILBuilt 1976 · S/N 177RG0923 N42118Walsh Air LLC · Live Oak, FLBuilt 1976 · S/N 177RG1088 N427BPBest Kenneth M · Sullivan, ILBuilt 1973 · S/N 177RG0434 N444APSmith Robert S · Orlando, FLBuilt 1975 · S/N 177RG0787 N45060Stone Eric · Cedarpines Park, CABuilt 1976 · S/N 177RG1091

Back to Cessna 177RG