Skip to content

Registered aircraft · 1,120

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 ('2072821', '2070107')
  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 ('2072821', '2070107')
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.

N185JLPotomac Street Partners Llp · Centennial, COBuilt 1978 · S/N 18503612 N185JNNelson James M · Anchorage, AKBuilt 1980 · S/N 18504161 N185JRBarry John E · Eddington, MES/N 185-02963 N185JSN185js LLC · Fairbanks, AKBuilt 1976 · S/N 18503095 N185JTJb Aero Services LLC · Coeur D Alene, IDBuilt 1976 · S/N 18503145 N185JW5jw LLC · Sheridan, WYBuilt 1977 · S/N 18503183 N185JYRnc Flight Service LLC · Bedford, WYBuilt 1975 · S/N 18502669 N185KAFischer Greg M · Willow, AKBuilt 1979 · S/N 18503932 N185KBSutton Aircraft Salvage LLC · Palmer, AKBuilt 1979 · S/N 18503698 N185KDCenter Sea Plane Club Inc · Sauk Centre, MNBuilt 1981 · S/N 18504272 N185KFKinzie Hon Kagen · Anchorage, AKBuilt 1976 · S/N 18503102 N185KGClark John W · Anchorage, AKBuilt 1981 · S/N 18504331 N185KMMcgrath William F Jr · Nantucket, MABuilt 1974 · S/N 18502451 N185KQLeonard Investments Management LLC · Palm Beach, FLBuilt 1973 · S/N 18502113 N185KSSchneider Joel A · Cerrillos, NMBuilt 1974 · S/N 18502366 N185KTLone Peak Air LLC · Gillette, WYBuilt 1978 · S/N 18503595 N185KWWells Kris G · Barron, WIBuilt 1975 · S/N 18502747 N185LASale Reported · Mead, COSale reportedBuilt 1979 · S/N 18503843 N185LJGuth Martin H · Kasilof, AKBuilt 1977 · S/N 18503110 N185LLNorth River Air LLC · Kodiak, AKS/N 18503037 N185LMBailey James K · Eagle River, AKBuilt 1974 · S/N 18502368 N185LPOlsen Scott M · Forest Lake, MNBuilt 1977 · S/N 18503374 N185LSL Sheffels & Son · Wilbur, WABuilt 1973 · S/N 18502321 N185LTHewitt Chad R · Vernonia, ORBuilt 1974 · S/N 18502581 N185LYAwesome Classics LLC · Kalispell, MTBuilt 1973 · S/N 18502120 N185MG-4 Air LLC · Birmingham, ALBuilt 1978 · S/N 18503532 N185MBTs Aviation LLC · Sioux Falls, SDBuilt 1981 · S/N 18504341 N185MCCampillo Mark A · Red Bluff, CAS/N 18503347 N185MEStrength LLC · Brandon, MSBuilt 1974 · S/N 18502356 N185MFJb Of Tower LLC · Tower, MNBuilt 1977 · S/N 18503268 N185MGVillanueva Roberto · Seattle, WABuilt 1975 · S/N 18502902 N185MJMarsh Galen E · Minot, NDBuilt 1979 · S/N 18503789 N185MLPerkins Michael D Trustee · Bigfork, MTBuilt 1979 · S/N 18503779 N185MNKramer John E · Conroe, TXBuilt 1979 · S/N 18503803 N185MRAirport Farms Aviation · Tarkio, MOBuilt 1978 · S/N 18503653 N185MSDragon Wagon LLC · Clackamas, ORBuilt 1983 · S/N 18504415 N185MTMarsh Douglas C · Omak, WABuilt 1975 · S/N 18502672 N185MWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18503956 N185NCIsland City Seaplanes Inc · Cordova, AKBuilt 1974 · S/N 18502420 N185NDFolsom Rodney B · Greenville, MEBuilt 1982 · S/N 18504369 N185NJHanson Dennis A · Priest Lake, IDBuilt 1978 · S/N 18503663 N185NRRegistered aircraftBuilt 1973 · S/N 18502273 N185NTRegistered aircraftS/N 18503586 N185NYStoecklein Christine · Stanwood, WABuilt 1979 · S/N 18503787 N185PAerial Associates Ltd · Delano, MNS/N 18504218 N185PCMooney Michael P · Camas, WABuilt 1976 · S/N 18503003 N185PDDriscoll Patrick C · Ashland, MEBuilt 1979 · S/N 18503937 N185PFQuest Leasing LLC · Eagle River, AKBuilt 1973 · S/N 18502247 N185PGJanie Gee Aviation Inc · Hilbert, WIBuilt 1981 · S/N 18504199 N185PJHanson Garrett · Everett, WAS/N 18503676

Back to Cessna A185F