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.

N9239EMasephol Todd M · Athens, WIBuilt 1946 · S/N 11AC-873 N9242ERegistration Pending · Milton, FLRegistration pendingBuilt 1946 · S/N 11AC-876 N9243ERegistered aircraftAssigned, pending cancellationS/N 11AC-877 N9244EFrost Beverly J · Greenfield, INBuilt 1946 · S/N 11AC878 N9245EJensen Jeffrey S · Alliance, NEBuilt 1946 · S/N 11AC-879 N9246EPolhemus Christopher C · Carmichaels, PABuilt 1946 · S/N 11AC880 N9252EHartzler Richard B · Grandview, MOBuilt 1946 · S/N 11AC-886 N9255ERule Paul C · Wapato, WABuilt 1946 · S/N 11AC-889 N9260EStruck Larry G · Gardnerville, NVFirst renewal noticeBuilt 1946 · S/N 11AC-895 N9261EMcvay Frank A · Bonaire, GABuilt 1946 · S/N 11AC-896 N9262ESilvers Jason A · Chilhowee, MOBuilt 1946 · S/N 11AC-897 N9263EWojdac David E · Mosinee, WIS/N 11AC-898 N9264ENewcombe Emily S · Cascade, IDS/N 11AC-899 N9265EMikesell Clifford W · Rochester, INBuilt 1946 · S/N 11AC-900 N9267EErb Charles Allen · Holden, MEBuilt 1946 · S/N 11AC-902 N9268EPancake C William Jr · Keyser, WVS/N 11AC-871 N9271EHargrove Dwayne E · Shepherdsville, KYS/N 11AC906 N9276EGriebsch James J · Saranac Lake, NYBuilt 1946 · S/N 11AC-914 N9278EMurray Richard H · Celina, OHS/N 11AC-916 N9279EHood Paul A · Saint Johns, MIBuilt 1946 · S/N 11AC-917 N9283EErickson James R · State College, PABuilt 1946 · S/N 11AC-920 N9284EDexter Fred H · Live Oak, FLBuilt 1946 · S/N 11AC-921 N9287DWilson Robin W Trustee · Fairbanks, AKS/N 11AC-924 N9288EMurray Richard H · Celina, OHBuilt 1946 · S/N 11AC-925 N9290EMentgen William P · Greencastle, INBuilt 1946 · S/N 11AC-927 N9291ECadotte Anthony John · Minnetonka, MNS/N 11AC-928 N9293EMerrill Steven W · Proctor, MNBuilt 1946 · S/N 11AC-932 N9300ECoy Shane A · Nenana, AKBuilt 1946 · S/N 11AC-938 N9304ECarroll Charles · Ephrata, PABuilt 1946 · S/N 11AC-942 N9305EWittmeyer Jody M · Dandridge, TNS/N 11AC-943 N9307EChaudhary Rizvon · Louisville, KYS/N 11AC-944 N9308EReynolds Richard E · Trumansburg, NYBuilt 1946 · S/N 11AC-946 N9309EHenderson William R · Ohatchee, ALS/N 11AC-947 N9318EAirpower Museum Inc · Ottumwa, IABuilt 1946 · S/N 11AC-956 N9324EAnderson Timothy H · Janesville, WIBuilt 1946 · S/N 11AC-962 N9328ERichie James A · Pleasant View, TNBuilt 1946 · S/N 11AC-966 N9329EVan Winkle Randy M · Van Buren, MOS/N 11AC-967 N9331ECimprich Joseph P · Camden, OHBuilt 1946 · S/N 11AC-969 N9333EObrien Stephen F · Manley Hot Springs, AKBuilt 1946 · S/N 11AC-972 N9334ELisch Timothy F · Delavan, WIS/N 11AC-971 N9336EWagner Dean M · Bellevue, WABuilt 1946 · S/N 11AC-974 N9342EWilson Kenneth D · Warsaw, MOBuilt 1946 · S/N 11AC-992 N9344EDodd Jason R · Pittsboro, INBuilt 1946 · S/N 11AC-982 N9345EGundersen Paul M · Polson, MTBuilt 1946 · S/N 11AC-983 N9346EBarthule Jacob E · Roundup, MTS/N 11AC-984 N9349ELittle Colin J · Bidwell, OHS/N 11AC-986 N9351EBrown David L · Hicksville, OHBuilt 1946 · S/N 11AC-989 N9354EMilheim Charles J · Watsontown, PABuilt 1946 · S/N 11AC-991 N9357EWelling Charles E III · West Islip, NYBuilt 1946 · S/N 11AC-994 N9361ERodkey John R · Goleta, CABuilt 1946 · S/N 11AC-999

Back to Aeronca 11AC