Skip to content

Registered aircraft · 98

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

N9803XPatrick Samuel Garrett · Durango, COBuilt 1961 · S/N 1850003 N9806XWelliver Charles Kimmel Jr · Staunton, VABuilt 1961 · S/N 185-0006 N9808XKeller Matthew Charles · Wasilla, AKBuilt 1961 · S/N 185-0008 N9812XSmith James M · Fitchburg, WIBuilt 1961 · S/N 1850012 N9818XPlath James F · Davenport, NDBuilt 1961 · S/N 1850018 N9822XHultquist Daniel D · Anchorage, AKBuilt 1961 · S/N 185-0022 N9823XTop Hand Inc · Laurel, MTBuilt 1961 · S/N 185-0023 N9828XPathfinder Aero Services LLC · Sheridan, WYS/N 1850028 N9830XWard Todd · Corona, CAS/N 185-0030 N9832XAlbert Bryan W · Palmer, AKBuilt 1961 · S/N 1850032 N9834XPemberton Ryan A · Valleyford, WABuilt 1961 · S/N 185-0034 N9845XBirney John A · Arlington, WABuilt 1961 · S/N 1850045 N9851XWheeler Andrew C · Orting, WABuilt 1961 · S/N 185-0051 N9854XOverly Terrence L · Tok, AKBuilt 1961 · S/N 185-0054 N9855XMcgee Jacob Quinton · King Salmon, AKBuilt 1961 · S/N 1850055 N9865XIrwin Flight LLC · Bellingham, WABuilt 1961 · S/N 185-0065 N9867XMulligan Kevin S · Port Alexander, AKS/N 185-0067 N9868XBaysinger Harold · Fairbanks, AKBuilt 1961 · S/N 185-0068 N9873XMckenna Brothers Aircraft LLC · Anchorage, AKBuilt 1961 · S/N 185-0073 N9875XCropper Ryan D · Anchorage, AKBuilt 1961 · S/N 185-0075 N9879XRegistered aircraftBuilt 1961 · S/N 1850079 N9890XSelman Jett · Anchorage, AKBuilt 1961 · S/N 1850090 N9896XKing Kevin J · Angle Inlet, MNBuilt 1961 · S/N 1850096 N9909XMameli Tyler L · Williamson, GABuilt 1961 · S/N 185-0109 N9910XHower Loyal L · Moscow, IDBuilt 1961 · S/N 185-0110 N9911XDesolation Aviation LLC · Fort Worth, TXBuilt 1961 · S/N 185-0111 N9920XPayne Ronald J II · Wasilla, AKBuilt 1961 · S/N 185-0120 N9921XWinslow William G Jr · Show Low, AZBuilt 1961 · S/N 1850121 N9922XDooleys LLC · Glendale, AZBuilt 1961 · S/N 185-0122 N9926XMuth Franklin R · Missoula, MTBuilt 1961 · S/N 1850126 N9930XPeterson Tony · Humboldt, IABuilt 1961 · S/N 1850130 N9939XGrant Matthew D · Alvord, TXS/N 1850139 N9943XN63e LLC · Fallon, NVS/N 185-0143 N9944XChristian Dana J · Bozeman, MTBuilt 1961 · S/N 185-0144 N9946XBarber Edward G Jr · Anchorage, AKBuilt 1961 · S/N 185-0146 N9950XHedlund Mark · Kasilof, AKBuilt 1961 · S/N 185-0150 N9951XBrown Rosalee Jo · Minnetrista, MNBuilt 1961 · S/N 185-0151 N9955XMurphy Niccolai A · Poway, CABuilt 1961 · S/N 185-0155 N9957XHutchison Robert T · Big Lake, AKBuilt 1961 · S/N 185-0157 N9959XMiller Keith D · Pittsburgh, PAS/N 1850159 N9965XNistler Matt J · Three Forks, MTBuilt 1961 · S/N 185-0165 N9966XFickus Timothy R · North Pole, AKBuilt 1961 · S/N 185-0166 N9968XEagley Ronald A · Anchorage, AKBuilt 1961 · S/N 185-0168 N9978XLyons Jeffery E · Carrollton, GABuilt 1961 · S/N 185-0178 N9979XGeorge Anthony L · Billings, MTBuilt 1961 · S/N 185-0179 N9988XBenavides Antonio · Anchorage, AKBuilt 1961 · S/N 1850188 N9998XSells James O · Peachtree City, GABuilt 1961 · S/N 185-0198 N9999XBogart Sean A · Anchorage, AKBuilt 1961 · S/N 185-0199

Back to Cessna 185