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.

N329DJBritt Matthew W · Trenton, SCBuilt 1976 · S/N 177RG0845 N33195Heathco Merle S · Scappoose, ORBuilt 1976 · S/N 177RG0918 N33212Burlingame Lloyd · Fort Atkinson, WIBuilt 1976 · S/N 177RG0920 N33220Advanced Analytical Inc · Newbury Park, CABuilt 1976 · S/N 177RG0925 N33230Alaska Air Service LLC · Brookings, ORBuilt 1976 · S/N 177RG0930 N33248Wilson Harvey Lee · Gadsden, ALBuilt 1976 · S/N 177RG0932 N33272Explorco LLC · Evergreen, COBuilt 1976 · S/N 177RG0938 N33273Dahl Neil A · Arlington, TXBuilt 1976 · S/N 177RG0939 N33274Cooker Brian M · Gold Hill, NCBuilt 1976 · S/N 177RG0940 N33291Skyways Aviation Inc · Wilmington, DEBuilt 1976 · S/N 177RG0944 N33296Mob Aviation USA LLC · Auburndale, FLBuilt 1976 · S/N 177RG0946 N33297Skinner Marvin L · Mansfield, TXBuilt 1976 · S/N 177RG0947 N33299Business Jet Services Inc · Apopka, FLBuilt 1976 · S/N 177RG0948 N333LAWilson Matthew · Weatherford, OKBuilt 1971 · S/N 177RG0092 N34014Rupp Gregory J · Deltona, FLBuilt 1976 · S/N 177RG0949 N34030Sommer Greg J · Maryville, ILBuilt 1976 · S/N 177RG0953 N34039Snedeker Andrew · Jackson, NJBuilt 1976 · S/N 177RG0954 N34058Dodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 177RG0956 N34063Sherman Stephen P · Prattville, ALBuilt 1976 · S/N 177RG0957 N34072Baden Aviation LLC · North Royalton, OHBuilt 1976 · S/N 177RG0960 N34077Registration Pending · Santa Monica, CARegistration pendingBuilt 1976 · S/N 177RG0961 N34080Rodell Justin A · Saint Paul, MNBuilt 1976 · S/N 177RG0963 N34081Danko James A · Norton, OHS/N 177RG0964 N34084Cardinal Aviation LLC · Eureka, MOBuilt 1976 · S/N 177RG0965 N34096Mirafuentes Akoni Jr · Surprise, AZBuilt 1976 · S/N 177RG0970 N34140Beacham Clinton S · Pleasanton, CABuilt 1976 · S/N 177RG0972 N34161Wood Robert A · Sarasota, FLBuilt 1976 · S/N 177RG0976 N34165Montenegro Aviation LLC · Kingwood, TXBuilt 1976 · S/N 177RG0977 N34170Marks Galen L · Lake Havasu City, AZBuilt 1976 · S/N 177RG0978 N34192Baird David S · Carson City, NVBuilt 1976 · S/N 177RG0979 N341RG341rg LLC · Little Rock, ARBuilt 1977 · S/N 177RG1155 N34205Dingman Douglas W · Albuquerque, NMBuilt 1976 · S/N 177RG0982 N34208Hokie Flying Club Inc · Christiansburg, VABuilt 1976 · S/N 177RG0983 N34221Baxter Jonathan · Centerville, MABuilt 1976 · S/N 177RG0985 N34226Blasjo Darrell W · Hesperia, CAS/N 177RG0986 N34300Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 177RG0988 N34426Cardinal 426 LLC · Jacksonville, FLBuilt 1976 · S/N 177RG0996 N34486Keys Cardinal Flyers LLC · Key West, FLBuilt 1976 · S/N 177RG1001 N34502Cardinal Primo LLC · Mesa, AZBuilt 1977 · S/N 177RG1296 N34565Moore Jason E Trustee · Port Orange, FLBuilt 1976 · S/N 177RG1006 N34569Coulter Daniel J · Mooresville, NCBuilt 1976 · S/N 177RG1007 N34674Image Components · Philadelphia, PABuilt 1976 · S/N 177RG1012 N34700Jenner Stephen R · Dunnellon, FLBuilt 1976 · S/N 177RG1013 N34807Wiese Marcus G · Shady Shores, TXBuilt 1976 · S/N 177RG1014 N34866Schroeder David C · Norfolk, NEBuilt 1976 · S/N 177RG1015 N34869Aviation Advantage LLC · Phoenix, AZBuilt 1976 · S/N 177RG1016 N34891White Robert A · Washington, NCBuilt 1976 · S/N 177RG1018 N348SRK & K Commercial Leasing LLC · Indiana, PABuilt 1972 · S/N 177RG0267 N34914Steele Craig S · Las Vegas, NVBuilt 1976 · S/N 177RG1020 N34924Manning Rolla G Jr · Las Vegas, NVBuilt 1976 · S/N 177RG1022

Back to Cessna 177RG