Skip to content

Registered aircraft · 2,099

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 ('2075816')
  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 ('2075816')
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.

N6840MFlying R Aviation LLC · Trenton, MOBuilt 1975 · S/N 18263855 N6842MBognar John A · Belgrade, MTBuilt 1975 · S/N 18263856 N6844MBarker Edward J · Claremore, OKBuilt 1975 · S/N 18263857 N6848MFitts Wayne T · Independence, ORBuilt 1975 · S/N 18263859 N6856MWoodall Larry Douglas · Auburn, WABuilt 1975 · S/N 18263861 N6857MRegistration Pending · Lenoir City, TNRegistration pendingBuilt 1975 · S/N 18263862 N6859MRegistration Pending · Woodruff, SCRegistration pendingBuilt 1975 · S/N 18263863 N6861MEwing Aviation LLC · Ellisville, MSBuilt 1975 · S/N 18263865 N6862MCreacy Jason Thomas · Gatesville, TXBuilt 1975 · S/N 18263866 N6863MRvandco LLC · Missoula, MTBuilt 1975 · S/N 18263867 N6864MKnott Dustin Shane · Brentwood, CABuilt 1975 · S/N 18263868 N6872MShowalter Mark W · Richland, WABuilt 1975 · S/N 18263871 N6879MCohen Robert · Buda, TXBuilt 1975 · S/N 18263884 N6880MKing Dale C · Simi Valley, CABuilt 1975 · S/N 18263876 N6886MJohnson Bill J · Canton, GABuilt 1975 · S/N 18263879 N688KTGlore Reilly P · Olympia, WABuilt 1972 · S/N 18261187 N6895MMeyer Stacy W · Pocatello, IDBuilt 1975 · S/N 18263883 N6899MManneco Inc · Independence, MOBuilt 1975 · S/N 18263885 N6904MSommers William C · Temperance, MIBuilt 1975 · S/N 18263887 N6913MFlesher John · Wadsworth, ILBuilt 1975 · S/N 18263889 N6914MChristilles Darrell Wayne · New Braunfels, TXS/N 18263890 N691DMAir Transport Inc · Las Vegas, NVBuilt 1975 · S/N 18263984 N6920MHutchison William Bradley · Canton, OKBuilt 1975 · S/N 18263891 N6936MNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1975 · S/N 18263895 N6951MDavid Paul T · Santa Barbara, CABuilt 1975 · S/N 18263896 N6953MN6953m Kemt Aircraft LLC · Monrovia, CABuilt 1975 · S/N 18263898 N6962MAbramson Jerrold B Trustee · Simi Valley, CABuilt 1975 · S/N 18263901 N6963MHathaway Virgil F · Spokane, WABuilt 1975 · S/N 18263902 N6989MRp Wellons Aircraft LLC · Dunn, NCBuilt 1975 · S/N 18263910 N699JGJaymar Aviation LLC · Flagstaff, AZBuilt 1973 · S/N 18261883 N699JMSky West Aviation Inc Trustee · Albuquerque, NMS/N 18264142 N69CHTexarkana Flying Club Inc · Texarkana, TXBuilt 1975 · S/N 18263618 N69DREsi Aviation LLC · Lakewood, COBuilt 1973 · S/N 18261860 N69WESlate Kevin Dwayne · Bell Buckle, TNBuilt 1972 · S/N 182-61092 N6AWH & H Hanger LLC · El Campo, TXBuilt 1974 · S/N 18262961 N6CWRegistered aircraftBuilt 1973 · S/N 18262125 N6HRKornegay Stephanie L · Charlotte, NCBuilt 1974 · S/N 18263470 N6TPRiver Birch Landings LLC · Lewes, DES/N 18263148 N700RBM & J Flight LLC · Cheboygan, MIBuilt 1973 · S/N 182-62421 N7021QClasen David L · Big Bear Lake, CABuilt 1973 · S/N 18262016 N7028SSkylane LLC · Salt Lake City, UTS/N 18265049 N7039SHotel Sierra LLC · Madison, WIBuilt 1976 · S/N 18265051 N7040SPro Plus Holdings LLC · Gillette, WYBuilt 1976 · S/N 18265052 N7044SNorthern Virginia Flying Club Inc · Aldie, VABuilt 1976 · S/N 18265053 N7045QDavidson Parker · Redding, CABuilt 1973 · S/N 18262021 N7046QRicken Kent · Boone, COBuilt 1973 · S/N 18262022 N7073SWaterman Ronald L · Albuquerque, NMBuilt 1976 · S/N 18265059 N7085QJust Plane Fun Et LLC · East Troy, WIBuilt 1973 · S/N 18262025 N7088QTraviss Siegfried H · Athol, IDS/N 18262027 N710WGAger Brandon Reno · Craig, COBuilt 1975 · S/N 18263570

Back to Cessna 182P