Skip to content

Commonwealth 185

Registered aircraft · 62

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 ('2370608')
  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 ('2370608')
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.

N31207Innes William J · Oroville, WABuilt 1946 · S/N 1810 N31209Hockenson Roy D · Auburn, WABuilt 1946 · S/N 1812 N33384Daniel Michael P · Arlington, TXBuilt 1945 · S/N 1605 N33390Doll Mindy L · Silverdale, WABuilt 1946 · S/N 1611 N33391Barlow Richard B · Stockbridge, GAS/N 1612 N33395Cohn David A · Port Townsend, WABuilt 1946 · S/N 1616 N34124Brown Lawrence W · Milo, MEBuilt 1946 · S/N 1860 N34128Verduin William D · Zeeland, MIS/N 1838 N34132Randall Kelly J · Independence, ORBuilt 1947 · S/N 1844 N34134Everts Air Service Inc · Schuylerville, NYS/N 1856 N34135Petro Jerry R · Williamsburg, VABuilt 1946 · S/N 1846 N67045Lorenz John C · Edgewood, NMS/N 1769 N67048Lovett Brett E · Liberty, MOBuilt 1946 · S/N 1772 N67059Taub John F · Sarasota, FLBuilt 1946 · S/N 1761 N73801Kisela Andrew J · Tecumseh, MIBuilt 1946 · S/N 1861 N73802Forsberg Edwin E · Elk Grove, CAS/N 1868 N73804Cocuzza James V · Hilton, NYBuilt 1946 · S/N 1870 N73811Mertesdorf Daniel R · Aguila, AZS/N 1816 N73820Stuart John R V · Taylorsville, KYBuilt 1946 · S/N 1825 N777QBBottomly Raymond V · Clarkston, WABuilt 1946 · S/N 1698 N90682Burton Robert E Jr · Vancouver, WABuilt 1946 · S/N 1807 N90683Lightwine Ashley · Mesa, AZS/N 1778 N90685Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1946 · S/N 1780 N90689Werner Paul W · Palm Coast, FLBuilt 1946 · S/N 1784 N90691Jewett Dixie Lee · Dayton, ORBuilt 1946 · S/N 1786 N90697Mccreary Daniel R · Bonney Lake, WABuilt 1946 · S/N 1791 N90698Thiel David W · Independence, ORS/N 1792 N92825Phillips Joshua D · Sylvania, GABuilt 1946 · S/N 1621 N92827Dexter Fred H · Live Oak, FLS/N 1623 N92830Deroos John T · Mammoth Spring, ARBuilt 1946 · S/N 1626 N92901Learn Build Fly Inc · Wausau, WIS/N 1632 N92904Ledbetter Tim A · Tahlequah, OKBuilt 1946 · S/N 1635 N92906Hornick Joel Richard · Corry, PABuilt 1946 · S/N 1637 N92907Scarola Michael · Danbury, CTBuilt 1946 · S/N 1638 N92915Brown Courd E · Warr Acres, OKS/N 1647 N92916Farmer Larry A Trustee · Salina, KSBuilt 1946 · S/N 1648 N92920Dexter Fred H · Live Oak, FLBuilt 1946 · S/N 1855 N92924Dreyer Elwain C · Cardington, OHS/N 1656 N92930Cornelius Jerry M · Addison, ALBuilt 1946 · S/N 1662 N92932Michael S Bailey · Sarasota, FLBuilt 1946 · S/N 1664 N92941Linkous James P · Ancho, NMBuilt 1946 · S/N 1673 N92953Sherman Randy S · Potsdam, NYBuilt 1946 · S/N 1686 N92954Brosseau Jon A · Pebble Beach, CABuilt 1946 · S/N 1687 N92960Hilgendorf Ross E · Welcome, MNBuilt 1946 · S/N 1693 N92962Yoder James J · Canby, ORS/N 1695 N92968Mallow David N · Rio, WVBuilt 1946 · S/N 1701 N92971Tostenrud Steven · Billings, MTBuilt 1946 · S/N 1704 N92982Gould William R · Eagle River, AKBuilt 1946 · S/N 1716 N92988Fraser William G · Berkley, MABuilt 1946 · S/N 1722 N92997Barger Albert L · Windsor, WIBuilt 1946 · S/N 1731

Back to Commonwealth 185