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.

N185DJJoy Solutions LLC · Wilmington, DEBuilt 1977 · S/N 18503453 N185DMMock David J · Mesa, AZS/N 18502143 N185DPPriebe Orthodontics Pc · Anchorage, AKBuilt 1977 · S/N 18503312 N185DRFisher Darryl Eugene Trustee · Carson City, NVBuilt 1977 · S/N 18503340 N185DSSkeen Andrew · Bellevue, WAS/N 18503827 N185DTN185dt LLC · Wasilla, AKS/N 18502863 N185DVDiamond V Aircraft Interests LLC · Mountain Home, TXBuilt 1976 · S/N 18502933 N185DXFixed Wing Aviation LLC · Woods Cross, UTBuilt 1982 · S/N 18504361 N185DYYankee Ventures LLC · Wilmington, DEBuilt 1977 · S/N 18503361 N185EBeebe William S · Boise, IDBuilt 1979 · S/N 18503867 N185EAParish Robert M · Knoxville, TNBuilt 1981 · S/N 18504294 N185EBGhilarducci Frank W · Sedalia, COBuilt 1976 · S/N 18502995 N185ECSudik Matthew W · Virginia Beach, VABuilt 1978 · S/N 18503726 N185EJRegistered aircraftBuilt 1980 · S/N 18504005 N185ETTaliaferro Aviation LLC · Ardmore, OKBuilt 1980 · S/N 18504055 N185FASchubert Keith A · Butler, PABuilt 1974 · S/N 18502616 N185FBBurchardi Michael Edward · Santa Ynez, CABuilt 1975 · S/N 18502580 N185FDDesert Dog Aviation LLC · Salt Lake City, UTBuilt 1976 · S/N 18503251 N185FFSchmitz Arlan · Portales, NMBuilt 1978 · S/N 18503665 N185FKTalkeetna Air Taxi Inc · Talkeetna, AKBuilt 1974 · S/N 18502513 N185FMSteninger Kim G · Spring Creek, NVBuilt 1976 · S/N 18503126 N185FPSkywagon Leasing Service LLC · Wasilla, AKBuilt 1974 · S/N 18502346 N185FSChristopherson Jack M · Salem, ORBuilt 1974 · S/N 18502354 N185FTSpence Bryan · Aledo, TXBuilt 1977 · S/N 18503329 N185FWNortheast Skywagon LLC · Pittsfield, MEBuilt 1981 · S/N 18504183 N185GBMaurice Robert P · Mcminnville, ORBuilt 1975 · S/N 18502631 N185GECannon Christopher Trustee · Moorpark, CABuilt 1976 · S/N 18503045 N185GGAnchor Aviation LLC · Johnstown, COBuilt 1975 · S/N 18502787 N185GHHalverson Gary M · Richmond, TXBuilt 1981 · S/N 18504353 N185GNNorris Gary L · Augusta, MES/N 18504131 N185GSPromotive LLC · Glade Springs, VABuilt 1978 · S/N 18503646 N185GWAir Resources Helicopters Inc · Salt Lake City, UTS/N 18503549 N185HN185h LLC · Hamilton, MTBuilt 1981 · S/N 18504313 N185HAKyllo Jeffrey · Larimore, NDBuilt 1978 · S/N 185-03536 N185HBPaden Brian D · Wasilla, AKBuilt 1975 · S/N 18502841 N185HCCalden Harvey · Jay, MES/N 18502193 N185HEEd Air Inc · Oaktown, INBuilt 1980 · S/N 18504053 N185HJKrasovich Steven L · Golden, COBuilt 1976 · S/N 18503034 N185HKMro Aviation Enterprises LLC · Kalispell, MTBuilt 1977 · S/N 18503318 N185HLFore Henry R · Hope, IDBuilt 1978 · S/N 18503708 N185HMMorgan Philip H · Anchorage, AKBuilt 1985 · S/N 18502408 N185HRAir Sprayers Inc · Two Buttes, COS/N 18502815 N185HSMerriner Scott · Anchorage, AKBuilt 1981 · S/N 18504291 N185HWRegistered aircraftBuilt 1974 · S/N 18502504 N185JBBasile Joseph · Joseph, ORS/N 18503800 N185JCAdirondack Aviation LLC · Walpole, NHS/N 18502429 N185JDPadden Geary L · Duluth, MNBuilt 1982 · S/N 18504336 N185JEEckert John E · Salt Lake City, UTBuilt 1981 · S/N 18504286 N185JHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1986 · S/N 185-02131 N185JKKunkle Christopher · Santa Ynez, CABuilt 1978 · S/N 18503677

Back to Cessna A185F