Skip to content

Registered aircraft · 1,121

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.

N550FK38884 LLC · Moorhead, MNBuilt 1977 · S/N 18503229 N5518ERomeo Charley LLC · Boulder, COBuilt 1979 · S/N 18503988 N5530ERovey Land & Cattle Co · Parker, AZBuilt 1979 · S/N 18503989 N555CDBoyd Robert T · Quakertown, PAFirst renewal noticeBuilt 1975 · S/N 18502656 N559MCBkjm LLC · Blanchard, OKBuilt 1978 · S/N 18503479 N56511Wired Flight LLC · Kent, WABuilt 1974 · S/N 18502525 N56581United States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502907 N567MVQuantum Investments Inc · Lincoln, MES/N 18504234 N5727NQualitair LLC · MicheistadtBuilt 1977 · S/N 18503320 N573JCCoffey John L · Iron River, WIS/N 18502396 N579JDForst Kenneth D DBA · Grand Rapids, MNBuilt 1980 · S/N 18503964 N57CABlue Sky Management LLC · Stevens Point, WIBuilt 1975 · S/N 18502698 N581CMUgashik Inc · King Salmon, AKS/N 18502805 N581CPRdc Leasing Lc · Johnston, IABuilt 1980 · S/N 18504090 N581CTFraley Stuart W · Indianapolis, INBuilt 1980 · S/N 18504181 N581JTMckenna John Jr Trustee · Bozeman, MTBuilt 1978 · S/N 18503662 N58316Labelle-Hamer Brendan T · Fairbanks, AKBuilt 1977 · S/N 18503284 N585CMMandes George J · Homer, AKS/N 18504099 N585PMN585pm LLC · Worthington, OHBuilt 1977 · S/N 18503451 N585ZDairy Air LLC · Van Nuys, CABuilt 1977 · S/N 18503266 N5947SStewart Edgar Alan · Glennallen, AKBuilt 1973 · S/N 18502169 N598ABBrynelsen Charles R · North Oaks, MNBuilt 1976 · S/N 18503136 N59AJBird Dog Aircraft LLC · Billings, MTBuilt 1981 · S/N 18504158 N59AKJaworski Roger W · Mesa, AZS/N 18503604 N6034NCircle Airtrails LLC · Anchorage, AKS/N 18504293 N6041NLj Camp LLC · Longview, TXS/N 18504297 N6044NB407 LLC · Seattle, WABuilt 1981 · S/N 18504298 N6046NPappas Joshua · Wilmette, ILBuilt 1981 · S/N 18504300 N605NRState Of Minnesota · Grand Rapids, MNBuilt 1985 · S/N 18504437 N606PBBoillat Pascal · Olympia, WABuilt 1984 · S/N 18504423 N60844Ayres Roger A · Henderson, NVS/N 18504062 N60871Young Greg W · Knoxville, TNBuilt 1980 · S/N 18504067 N60945Gray Rick L · Eagle River, AKBuilt 1980 · S/N 18504081 N60956Mcclellen Mark C · Mccall, IDBuilt 1980 · S/N 18504083 N6095ESmith Douglas Derek · Mebane, NCBuilt 1980 · S/N 18503996 N60969Northwest Aviation LLC · Whitefish, MTBuilt 1980 · S/N 18504085 N60AKSchmidt Jason A · Wasilla, AKBuilt 1980 · S/N 18504157 N60ECWright Zach · Spicewood, TXBuilt 1979 · S/N 18503913 N60VAFlying Rhino Aviation Ltd · Alliance, NEBuilt 1976 · S/N 18503141 N60XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18503908 N61025Registered aircraftBuilt 1980 · S/N 18504098 N61092Registration Pending · Cadillac, MIRegistration pendingBuilt 1980 · S/N 18504107 N61102R&G Leasing Llp · Waterford, WIS/N 18504108 N61119Small Aviation No 3 LLC · Villa Rica, GABuilt 1980 · S/N 18504110 N61155Smith Jacques F · Anchorage, AKS/N 18504114 N61158Robert N Shadduck Inc · Annandale, MNBuilt 1980 · S/N 18504115 N61164Brydon Robert J · Lago Vista, TXBuilt 1980 · S/N 18504117 N61298Arizona Game And Fish Department · Phoenix, AZBuilt 1980 · S/N 18504142 N61301Southern Seaplane Inc · Belle Chasse, LABuilt 1980 · S/N 18504144 N61323N61323 LLC · Portland, ORBuilt 1980 · S/N 18504147

Back to Cessna A185F