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.

N727GLRheney John W III · Cameron, SCBuilt 1976 · S/N 18264939 N727PBRegistration Pending · Farson, WYRegistration pendingBuilt 1973 · S/N 18262260 N7284NMcbride Kelly · Show Low, AZBuilt 1974 · S/N 18263071 N7285NSale Reported · Fish Haven, IDSale reported, canceledBuilt 1974 · S/N 18263072 N7285QEight Five Quebec Assoc LLC · Tucson, AZBuilt 1973 · S/N 18262056 N7289NCandle Lane LLC · Sherman, CTBuilt 1974 · S/N 18263076 N7289QStenstrom Steven M · Scottsdale, AZBuilt 1973 · S/N 18262057 N7291NGrandkids Ranch LLC · Lewis, COBuilt 1974 · S/N 18263078 N7291QCryder Michael J · Billings, MTBuilt 1973 · S/N 18262059 N7293QKiely Richard · Encampment, WYBuilt 1973 · S/N 18262060 N7294SRapid Nursing Staff Inc · Farmington, NMS/N 18265092 N7298NMoore James Jeffrey · Midlothian, TXFirst renewal noticeBuilt 1974 · S/N 18263085 N7299NGonin Henri Louis · Elko, NVBuilt 1974 · S/N 18263086 N72JGN72jg LLC · Belgrade, MTBuilt 1976 · S/N 18264870 N72RXTayloreel Plastics South Corp · Gainesville, GAS/N 18261397 N72TRRcrhb LLC · Wells, TXBuilt 1972 · S/N 18261325 N72VHThomason Terry C · Hot Springs, ARBuilt 1972 · S/N 18261033 N7300QClark Perry W · Pine River, MNBuilt 1971 · S/N 18260940 N7301QMorgan John C · Seattle, WABuilt 1971 · S/N 18260941 N7301SJohn Air LLC · Aurora, UTBuilt 1976 · S/N 18265094 N7302NClark Frank C · Pinckney, MIBuilt 1974 · S/N 18263088 N7302QDuckworth Bill J · Epps, LAS/N 18260942 N7305QWolding Mylo D · New Town, NDBuilt 1971 · S/N 18260945 N7305SJones Keith J · Tucson, AZBuilt 1976 · S/N 18265098 N7306QOllee Air LLC · Smithfield, UTBuilt 1971 · S/N 18260946 N7306SBennett Aviation LLC · New York, NYBuilt 1976 · S/N 18265099 N7307NLow Michael E · Hurricane, UTBuilt 1974 · S/N 18263093 N7307SDunlap Michael L · Haymarket, VABuilt 1976 · S/N 18265100 N7309NMartyn Michael L · Inyokern, CAFirst renewal noticeBuilt 1974 · S/N 18263095 N7309QWayne Kenneth B · Sonoma, CABuilt 1972 · S/N 18260949 N7309SRegistration Pending · Tahoe City, CARegistration pendingBuilt 1976 · S/N 18265101 N730BLast Approach LLC · Fort Myers, FLS/N 18264937 N7310QDye Development LLC · Salem, OHBuilt 1972 · S/N 18260950 N73118Hudson Donald L Jr · Sellersburg, INBuilt 1975 · S/N 18264122 N7312NOber John · Candor, NYS/N 18263097 N7312QRegistration Pending · Wilmington, DERegistration pendingBuilt 1972 · S/N 18260952 N7312SCuneo Timothy Angelo · Twin Falls, IDBuilt 1976 · S/N 18265104 N7313QWoodall Dan · Raleigh, NCFirst renewal noticeBuilt 1972 · S/N 18260953 N7313SRogers Matthew H · South Berwick, MEBuilt 1976 · S/N 18265105 N7315QNotman Steven J · Maunaloa, HIBuilt 1972 · S/N 18260955 N7316NHayes Charles David · North Pole, AKBuilt 1974 · S/N 18263100 N7316QAirborne LLC · Wilmington, DEBuilt 1972 · S/N 18260956 N7317SGoodman Jack A · Memphis, TNBuilt 1976 · S/N 18265109 N7318SStahl K Joseph · Gainesville, TXBuilt 1976 · S/N 18265110 N7319QBassett Robert C · Gypsum, COBuilt 1972 · S/N 18260959 N7321NMalad Aviation LLC · Bliss, IDS/N 18263105 N7321SRauber James S · Lincoln, MTBuilt 1976 · S/N 18265113 N7322SSueson Flying Inc · Wilmington, DEBuilt 1976 · S/N 18265114 N7323QYelderman Neil O · Guy, TXBuilt 1972 · S/N 18260963 N7324NLeonhardt Bonnie · Riverton, WYBuilt 1974 · S/N 18263108

Back to Cessna 182P