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.

N4833CRossi A F · Belmont, CABuilt 1974 · S/N 18502601 N4834CIverson Paul · Lima, MTBuilt 1975 · S/N 18502602 N4836CSearfus Kirsten L · Durango, COBuilt 1974 · S/N 18502604 N4836QMcinelly Leon · Fairbanks, AKBuilt 1978 · S/N 18503561 N4841CTreftz Kurt B · Anacortes, WAS/N 18502609 N4843CPayne Thomas E · Old Forge, NYBuilt 1975 · S/N 18502611 N4845EEllis Jeffrey · Davis, ILBuilt 1979 · S/N 18503887 N4852ESproul David Douglas Jr · Heath, TXBuilt 1979 · S/N 18503888 N4855CFoss James K · Anchorage, AKBuilt 1975 · S/N 18502623 N4859CHanni Walter G · Anchorage, AKBuilt 1974 · S/N 18502627 N4867CWeishaar Traig Tl · Odessa, WAS/N 18502635 N4869CBerry Matthew G · Creedmoor, NCBuilt 1975 · S/N 18502637 N4870CHoffman Bertha M · Bethel, AKS/N 18502638 N4874QSutton Aircraft Salvage LLC · Palmer, AKBuilt 1978 · S/N 18503567 N4878QRichter Patrick A · Edna Bay, AKBuilt 1978 · S/N 18503570 N4896CFlying Paws LLC · Arvada, COBuilt 1975 · S/N 18502647 N4896EMcgrail Stephen M · South Dennis, MABuilt 1979 · S/N 18503899 N48JGWulvik Frederik M · Wasilla, AKBuilt 1974 · S/N 18502391 N491Acadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1978 · S/N 18503597 N4911CGianni David C · Fairbanks, AKBuilt 1975 · S/N 18502653 N4911ESchumacher Gregory Luther · Anchorage, AKBuilt 1979 · S/N 18503904 N4915CLang Carl R · Harper, TXBuilt 1975 · S/N 18502657 N4918QNauta Larry D · Soldotna, AKBuilt 1978 · S/N 18503575 N4923CSmith Justin K · Wasilla, AKBuilt 1975 · S/N 18502659 N4924ENorthstar E & C LLC · Anchorage, AKBuilt 1979 · S/N 18503909 N4925CRichardson Richard E II · Windham, MEBuilt 1975 · S/N 18502660 N4931CEinstein Inc · Price, UTBuilt 1975 · S/N 18502662 N4934EHeineman Steven · Chicago, ILBuilt 1979 · S/N 18503912 N4935QHaygar Berlin Inc · Shorewood, MNBuilt 1978 · S/N 18503578 N4943EPettit Robert · Carnegie, OKS/N 18503914 N4946ESallmon Helga R · Sandpoint, IDFirst renewal noticeBuilt 1979 · S/N 18503916 N4948CRobillard Ross · Eveleth, MNBuilt 1975 · S/N 18502664 N4948QWhite Ronald A · Anchorage, AKBuilt 1978 · S/N 18503583 N4949ETrans Crafts LLC · Big Lake, AKBuilt 1979 · S/N 18503917 N4952EHess Michael D · Wasilla, AKBuilt 1979 · S/N 18503918 N4953EInland Fisheries And Wildlife · Augusta, MEBuilt 1979 · S/N 18503919 N4961ELafferty David W · Harrisburg, ORBuilt 1979 · S/N 18503922 N4972QAdams David G · Knoxville, TNBuilt 1978 · S/N 18503591 N4999TAndy Aviation Inc · Live Oak, FLBuilt 1975 · S/N 18502729 N4AAAsi Jet Ag LLC · Hutchinson, MNBuilt 1977 · S/N 18503393 N4XCMinnehan Land & Cattle Co · Joplin, MTBuilt 1975 · S/N 18502876 N5001RLe Conte LLC · Anchorage, AKBuilt 1976 · S/N 18502974 N5014RCooper Flying Inc · Lamesa, TXBuilt 1976 · S/N 18502978 N5028RSmith Ray C Jr · Sault Sainte Marie, MIBuilt 1976 · S/N 18502981 N5038RKnecht Ken L · Eagle River, AKBuilt 1976 · S/N 18502985 N5046RSandpoint Aviation LLC · Sandpoint, IDS/N 18502988 N504JCFrequent Flyer LLC · Manasquan, NJBuilt 1973 · S/N 18502155 N5060RBristow Brent L · Anchorage, AKFirst renewal noticeBuilt 1976 · S/N 18502992 N5073RMckenna Brothers Aircraft LLC · Anchorage, AKBuilt 1976 · S/N 18502997 N5077RHawkins Transportation LLC · Anchorage, AKBuilt 1976 · S/N 18503000

Back to Cessna A185F