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.

N1582QWhite William Wayne · Corona, CABuilt 1977 · S/N 18503485 N158RXMurkowski Francis M · Anchorage, AKBuilt 1979 · S/N 18503784 N1598HCarey Philip J Trustee · Wasilla, AKBuilt 1977 · S/N 18503314 N1624HSynergy Aviation LLC · Forest Lake, MNBuilt 1977 · S/N 18503317 N165DBCloud 916 LLC · Dover, DEBuilt 1978 · S/N 18503624 N1662RGray Jerry B · Valdez, AKBuilt 1974 · S/N 18502385 N1663RSmith Dan V · Anchorage, AKBuilt 1974 · S/N 18502386 N1671RDavis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18502394 N1677RYarger Denim B · Laurel, MTBuilt 1974 · S/N 185-02400 N1678RPureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 18502401 N1690RFederal Aerial Applicators LLC · Wilmington, DEBuilt 1974 · S/N 18502413 N1694RCrow Rock LLC · Stillwater, MNBuilt 1974 · S/N 18502417 N1701RM R Planes LLC · Redmond, WABuilt 1974 · S/N 18502423 N1708RHall Alan D Trustee · Big Bear Lake, CABuilt 1974 · S/N 18502430 N1718RStripe Joseph · Olympia, WABuilt 1974 · S/N 18502439 N1726RPetumenos Timothy J · Anchorage, AKBuilt 1974 · S/N 18502447 N1728RIcenogle Roger A · Inver Grove, MNBuilt 1974 · S/N 18502449 N1743RChronicle Aerospace Inc · Wilmington, DEBuilt 1974 · S/N 18502463 N1745RFiske James K · North Andover, MAFirst renewal noticeBuilt 1974 · S/N 18502465 N174LSN174ls LLC · Middlebury, CTBuilt 1976 · S/N 18503086 N1750RShort James B · Anchorage, AKBuilt 1974 · S/N 18502470 N1756RMontana Rose 185 LLC · Cornwall, VTBuilt 1974 · S/N 18502476 N1767RHamel David A · Klamath Falls, ORBuilt 1974 · S/N 18502487 N1769RCt Aviation LLC · Waverly, NEBuilt 1974 · S/N 18502489 N176TCRedtail Cirrus LLC · Boise, IDBuilt 1979 · S/N 18503814 N1770RRegistered aircraftBuilt 1974 · S/N 18502490 N1775RAnderson Lenny R · King Salmon, AKBuilt 1974 · S/N 18502494 N1780RDoellefeld Jason T · Langsville, OHBuilt 1974 · S/N 18502498 N1789Hill Sheldon S · Minot, NDFirst renewal noticeBuilt 1974 · S/N 18502342 N1790RBlack Dog Holding Inc · Pleasant Valley, NYS/N 18502506 N1792REcho Matrix LLC · Bentonville, ARBuilt 1974 · S/N 18502508 N1795RBroussard Kenneth John · Lafayette, LABuilt 1974 · S/N 18502511 N1798RSedwick Jack D III · Anchorage, AKBuilt 1974 · S/N 18502514 N1799RAir Support 1 Inc · Middletown, DEBuilt 1974 · S/N 18502515 N17SRNcsb LLC · Anchorage, AKBuilt 1974 · S/N 18502424 N1802RMontaska Management Inc · Anchorage, AKBuilt 1974 · S/N 18502518 N18118Bokman Charles J III · Athol, IDBuilt 1977 · S/N 18503328 N1812RDriskell James P · Anchorage, AKBuilt 1974 · S/N 18502527 N1815ROsprey Island Lodge Inc · Eagle River, AKBuilt 1974 · S/N 18502530 N1816RArizona Game & Fish Dept · Phoenix, AZBuilt 1974 · S/N 18502531 N1820RBarkhimer James C · Iraan, TXBuilt 1974 · S/N 18502535 N1821RHoward Todd R · Minneapolis, MNBuilt 1974 · S/N 18502536 N1822ROney Tony K · Anchorage, AKBuilt 1974 · S/N 18502537 N1823RJones Alfred J · Friendsville, PABuilt 1974 · S/N 18502538 N1825QCree William H III · Long Beach, CABuilt 1977 · S/N 18503492 N1825RKincaid James B · Wasilla, AKBuilt 1974 · S/N 18502540 N1831RC & D Aviation LLC · Brentwood, CABuilt 1974 · S/N 18502546 N1836RBc Properties LLC · Anchorage, AKS/N 18502551 N1839RBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 18502554 N1841RPatton Ronald V II · Keizer, ORBuilt 1974 · S/N 18502556

Back to Cessna A185F