Skip to content

Registered aircraft · 52

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

N11277Morozowsky Anthony M II · Zanesville, OHBuilt 1945 · S/N A-107 N11291Macveigh Craig A · New Carlisle, OHS/N A-123 N11293Bowe Walter C Trustee · Sonoma, CAS/N A-125 N11422Newhouse Flying Service Inc · Fredericksburg, TXS/N A-156 N12405Petro Jerry R · Williamsburg, VABuilt 1931 · S/N A-171 N12407Hammond James F · Yellow Springs, OHBuilt 1932 · S/N A-173 N12423Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N A189 N12784Groff Russell D · Winchester, TNS/N A-204 N13000Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1932 · S/N A-215 N13002Leigh Michael C · Tullahoma, TNBuilt 1932 · S/N A217 N13021Hammond James F · Yellow Springs, OHBuilt 1932 · S/N A-236 N13024Morozowsky Anthony M · Zanesville, OHBuilt 1932 · S/N A-238 N13554Registered aircraftBuilt 1933 · S/N A-288 N13556Karner Joseph G · Oswego, ILBuilt 1934 · S/N A-290 N13583Tranby Wayne A · Fargo, NDBuilt 1933 · S/N A-277 N14096George Mike · Springfield, ILBuilt 1934 · S/N A-403 N14098Batson Ceward W · Manhattan, ILBuilt 1934 · S/N A-405 N14532Jones Donald T Jr · Barrigada, GUBuilt 1935 · S/N A-441 N14535Fers Mitchell A · Stafford Springs, CTBuilt 1934 · S/N A-430 N1453HTrost David · Yorktown Heights, NYS/N A-503 N14550Petro Jerry R · Williamsburg, VAS/N A-504 N14555Morozowsky John · Zanesville, OHBuilt 1935 · S/N A507 N14556Flying L Aircraft Inc · Fort Denaud, FLBuilt 1964 · S/N A-508 N14632Dexter Fred H · Live Oak, FLBuilt 1935 · S/N A-518 N14640Shannon Air Museum LLC · Fredericksburg, VAS/N 526 N14646Gehrlein Rodney L · Waterford, PABuilt 1935 · S/N A-532 N14650Brewer Stephen F · Hamilton, OHS/N A-536 N15252Mid Atlantic Air Museum · Reading, PABuilt 1935 · S/N A-572 N15257Lovley Vaughn · Webster, MNS/N A-576 N15258Botsford Lawrence B · Sanger, TXBuilt 1935 · S/N A-577 N15286Pearlman Aircraft Co · Orlando, FLBuilt 1935 · S/N A-617 N15287Nichols Charles F Trustee · Baldwin Park, CAS/N A-614 N15288Macveigh Craig A · New Carlisle, OHS/N A-618 N15295Cook Charles N · Fort Worth, TXBuilt 1936 · S/N 623 N15729Rare Aircraft Ltd · Faribault, MNBuilt 1936 · S/N 741 N15733Yonge Robert R · Ocala, FLBuilt 1936 · S/N A-633 N16268Cloud 9 Aero LLC · Southampton, NYBuilt 1936 · S/N A-654 N16286Rambo Gene · Falls Church, VAS/N A-662 N16291Eaa Aviation Foundation Inc · Oshkosh, WIBuilt 1945 · S/N A-668 N16529Port Townsend Aero Museum · Port Townsend, WABuilt 1959 · S/N A-673 N16533Piercy Ronald S · Moses Lake, WAS/N A675 N16549Mcknight Thomas N · Fredericksburg, TXS/N 690 N16562White Mark E · Cold Spring, NYBuilt 1946 · S/N A-700 N16570Freeman Heritage Collection LLC · Kingsbury, TXBuilt 1936 · S/N A706 N17404Golden Age Air Museum · Bethel, PABuilt 1936 · S/N A-717 N17412Kulle William T · Springfield, MABuilt 1936 · S/N A723 N17419Registration Pending · Oklahoma City, OKRegistration pendingBuilt 1936 · S/N A-730 N17434Abel Brandon R · Henderson, NVBuilt 1936 · S/N A-742 N17439Jones Donald T Jr · Barrigada, GUBuilt 1936 · S/N A746 N17446Serrino Sam K · Boardman, OHS/N A-751

Back to Aeronca C-3