Skip to content

Registered aircraft · 603

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

N3668EAnderson Richard A · Sycamore, ILBuilt 1947 · S/N 11AC-1844 N3677EBaker Terry L · New Lexington, OHS/N 11AC-1846 N3685EManor Jay G · Broomfield, COBuilt 1947 · S/N 11AC-1848 N3700EZero Zero Echo LLC · Lonoke, ARS/N 11AC-1853 N3703EThompson Barrett R · Smyrna, TNBuilt 1947 · S/N 11AC-1855 N3706EEvans Robert F · Lafayette, INBuilt 1951 · S/N 11AC-1856 N3709EPippenger James W · Churubusco, INBuilt 1947 · S/N 11AC-1857 N3718EBasso Michele · Millbrook, ALBuilt 1947 · S/N 11AC-1860 N3720EMaynard Jerry M · Dudley, NCBuilt 1947 · S/N 11AC-1862 N3729EAerocraft Holding Company LLC · Waxhaw, NCBuilt 1947 · S/N 11AC-S15 N3751EBahmann Frank · Dade City, FLBuilt 1947 · S/N 11AC-S2 N3756ENortheast Cubs LLC · Wilmington, DEBuilt 1947 · S/N 11AC-S-3 N3758EFenger Paul · Cottonwood, MNBuilt 1947 · S/N 11AC-S-4 N3763EFlywithgeorge Inc · Madison, SDS/N 11AC-S-6 N3769EMather Tiffany S · Huron, OHBuilt 1947 · S/N 11AC-S-7 N3777EMccrary Donald R · Greensburg, INBuilt 1947 · S/N 11AC-S-10 N3784EAnderson Timothy H · Janesville, WIBuilt 1947 · S/N 11AC-S-12 N3790EFicklin Robert L · Fairbury, ILBuilt 1947 · S/N 11AC-S-14 N3793EAllen Scott L · Ogallala, NEBuilt 1947 · S/N 11AC-S-16 N3799EGoebel Jacob R · Rhome, TXBuilt 1947 · S/N 11AC-S-18 N3800EMorris Delbert A · Cashmere, WAS/N 11AC-S19 N3811ESale Reported · Watsonville, CASale reported, canceledBuilt 1947 · S/N 11AC-S30 N3813EMitchell John J · Whitewater, WIBuilt 1947 · S/N 11AC-S-31 N3814EAllen Anwaar Saeed · Pueblo, COBuilt 1947 · S/N 11AC-S32 N3817EEccles Vickie L · Beaver, OKBuilt 1947 · S/N 11AC-S-33 N3818ETomanio Richard E · Saint Augustine, FLBuilt 1947 · S/N 11AC-S-34 N3834ESchmitz Patrick A · Wynot, NEBuilt 1947 · S/N 11AC-S-47 N3835EAviation Covers Inc · Arlington, WABuilt 1947 · S/N 11AC-S-49 N3843EJoyce Chantz · Cottonwood, CABuilt 1947 · S/N 11AC-S-51 N3865EChecky Allen O Jr · Merrimac, WIS/N 11AC-S-66 N3867EKrogsrud Stephen · Pasco, WABuilt 1947 · S/N 11AC-S-67 N3868EShaw Timothy · Columbus, INS/N 11AC-S-68 N3876EMurphy Terrence W III · Belmont, NHBuilt 1947 · S/N 11AC-S-74 N3882ES&D Aero LLC · Elmira, ORS/N 11AC-S-77 N3884ENiemyjski Trevor G · Union Grove, WIBuilt 1947 · S/N 11AC-S-78 N3885ECalgaard Gary · Clear Lake, IABuilt 1947 · S/N 11AC-S-79 N3906ESale Reported · Port Saint Lucie, FLSale reportedBuilt 1947 · S/N 11AC-S-92 N3909ESutton Aircraft Salvage LLC · Palmer, AKS/N 11ACS98 N3913EGirten Patrick J · Evansville, INBuilt 1947 · S/N 11AC-S100 N3933EWatrud Joel C · Waskish, MNBuilt 1947 · S/N 11BC-15 N3949EJestice Cyrus A · Viola, ARBuilt 1947 · S/N 11BC30 N39634National Machinery & Conveyor Inc · Marion, INBuilt 1945 · S/N 11AC-2 N3966EVick Karl A · Elko, MNBuilt 1947 · S/N 11BC-51 N4033ECongdon Carl J · Manley, AKBuilt 1947 · S/N 11BC-121 N4070EDelaney Patrick J · Marion, TXS/N 11BC-158 N4118VSchaff Cole M · Mandan, NDBuilt 1946 · S/N 1389 N4132ELuggar Will A · Solway, MNBuilt 1947 · S/N 11CC-41 N4270EGrahl Adam D · Eden, WIBuilt 1947 · S/N 11CC-149 N4453PHousel LLC DBA · Palm Harbor, FLS/N 11AC318 N458ELennox Steve R · Elkhart, INBuilt 1946 · S/N 11AC-1092

Back to Aeronca 11AC