Skip to content

Registered aircraft · 1,878

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

N7678ETerry Michael R Trustee · Bullhead City, AZBuilt 1946 · S/N 7AC-3393 N7756RRegistration Pending · Roundhill, KYRegistration pendingBuilt 1946 · S/N 7AC-5568 N799RGRegistration Pending · Dayton, OHRegistration pendingBuilt 1946 · S/N 7AC-3834 N79KRRedick Albert L II · Reno, NVBuilt 1946 · S/N 7AC-4515 N800PTContner Gary E · Huntsville, OHBuilt 1946 · S/N 7AC-5427 N8111NRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1946 · S/N 7AC-3712 N81401Sipes Jacob L · Sunbury, OHBuilt 1945 · S/N 7AC-19 N81403Early Patricia A · Palmyra, PAFirst renewal noticeBuilt 1945 · S/N 7AC-21 N81411Sale Reported · Warner Robins, GASale reportedBuilt 1945 · S/N 7AC-28 N81412Taylor William E Trustee · Waynesville, MOBuilt 1945 · S/N 7AC-5 N81414Monroe David M · Cary, ILBuilt 1945 · S/N 7AC-32 N81421Banker James · Geneseo, NYRegistration revokedBuilt 1945 · S/N 7AC-40 N81422Wadsworth Naomi W · Mount Morris, NYBuilt 1945 · S/N 7AC-43 N81426Perry Flying Svc · Bastrop, LARegistration revokedBuilt 1945 · S/N 7AC45 N81428Morris Dennie R · North Fort Myers, FLBuilt 1945 · S/N 7AC-46 N81429Smith Warren C · Halliday, NDBuilt 1945 · S/N 7AC-47 N81431Galer Charles J · Irvington, ALBuilt 1945 · S/N 7AC-49 N81443Mizer James D · Hailey, IDFirst renewal noticeS/N 7AC-61 N81445Coleman Marc C · Muldrow, OKBuilt 1945 · S/N 7AC-63 N81447Saratoga Soaring Association · Ballston Lake, NYS/N 7AC-65 N81451Vaughn Jared A · Fairfield, ILBuilt 1945 · S/N 7AC-70 N81455Holcombe Richard H Trustee · Florence, ORBuilt 1945 · S/N 7AC-73 N81456Gocha John H III · Greenfield Center, NYBuilt 1945 · S/N 7AC-77 N81457Providence Aerospace LLC · Choctaw, OKBuilt 1945 · S/N 7AC-75 N81466Kirkwood Eric J · Waterford, MIS/N 7AC-85 N81468Feydo Richard D · Andover, OHBuilt 1945 · S/N 7AC-69 N81472Hopkin Judith R · Perkasie, PABuilt 1945 · S/N 7AC-90 N81482Copaair Maintenance Services Inc · Indiantown, FLBuilt 1945 · S/N 7AC100 N81485Tripp Virginia C · Vanceboro, NCBuilt 1945 · S/N 7AC-103 N81488Registered aircraftBuilt 1945 · S/N 7AC-107 N81494Lkn Champ LLC · Sherrills Ford, NCBuilt 1945 · S/N 7AC-104 N81495Merrick Christopher D · Grass Valley, CABuilt 1945 · S/N 7AC-114 N81501Szabolscky Stephen L · Remington, VABuilt 1945 · S/N 7AC-118 N81505Cavallaro Jack C · Jordan, NYBuilt 1945 · S/N 7AC-123 N81507Kiroy Bradley R · Plattsburgh, NYBuilt 1945 · S/N 7AC-125 N81508Engler Aviation LLC · Bad Axe, MIBuilt 1945 · S/N 7AC-126 N81510Vihlen Steven C · Locust Grove, GABuilt 1945 · S/N 7AC-131 N81511Hinson John F · Jefferson Hills, PABuilt 1945 · S/N 7AC-132 N81513Macveigh Craig A · New Carlisle, OHBuilt 1945 · S/N 7AC-135 N81520Stormer Isaac E · Curtis, WABuilt 1945 · S/N 7AC-146 N81534Kjesbo Dean C · Norcross, MNBuilt 1945 · S/N 7AC-153 N81539Braun Kevin J · Aberdeen, SDBuilt 1945 · S/N 7AC-155 N81542Cottonwood Flying Club · Rockford, ILBuilt 1945 · S/N 7AC-161 N81545Harper David E · Stillwater, MNBuilt 1945 · S/N 7AC-164 N81551Gustafson Dale H · Kingwood, TXBuilt 1945 · S/N 7AC-170 N81554Kalat Norman W III · Pinedale, AZS/N 7AC-173 N81555Lightfoot Dale · Stillwater, OKBuilt 1945 · S/N 7AC-174 N81565Pearman Jake J · Alamogordo, NMS/N 7AC-184 N81566Whitmarsh Stephen C · Marysville, CABuilt 1945 · S/N 7AC-185 N81570Registration Pending · Murrieta, CARegistration pendingBuilt 1945 · S/N 7AC-189

Back to Aeronca 7AC