Skip to content

Registered aircraft · 40

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

N31436Strausz Michael P · Moundridge, KSBuilt 1940 · S/N 5320T N31454Knies Eugene W · Lebanon, TNBuilt 1940 · S/N 5480T N36622Jenkins Lawrence P · Deming, NMS/N C1091TA N36681American Airpower Heritage Flying Museum · Dallas, TXBuilt 1941 · S/N C1121TA N36687Aberle Jerry L · Mohave Valley, AZBuilt 1941 · S/N L1441TA N36812Allen Walter D · Parsons, KSS/N C1571TA N36818Pitcher Jack W Trustee · Windsor, COBuilt 1941 · S/N F1581TA N36833R & S Stuart Co Inc · Wilmington, DEBuilt 1941 · S/N C1691TA N36834B & S Aviation LLC · Sylvania, OHBuilt 1941 · S/N C1681TA N36843Peters Daniel J · Longmont, COBuilt 1941 · S/N F1741TA N36899Macveigh Craig A · New Carlisle, OHS/N C2051TA N36952Humphryes James K · Mc Calla, ALBuilt 1941 · S/N C2691TA N36954Bonilla Ismael L · Palm Coast, FLBuilt 1941 · S/N C2681TA N36959Saxton Jarrod R · Victoria, VABuilt 1941 · S/N C2781TA N36967Rhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1941 · S/N C2711TA N36980Calhoun Edward J · Whitney, NEBuilt 1942 · S/N C-3122TA N36981Agaliotis Paul Edwin Otha · San Martin, CABuilt 1942 · S/N C-3132TA N36996Barclay Barry A · Fayette, MES/N L3062TA N39306Goodman Bert D · Canaan, MEBuilt 1942 · S/N C4082TA N39309Wright Thomas L · Clyde, OHBuilt 1942 · S/N C3072TA N39317Defender Aviation Llp · Middletown, OHBuilt 1941 · S/N C2801TA N39342Patrick Michael J · Chico, CABuilt 1942 · S/N C4332TA N39374Park William G · Canby, ORBuilt 1942 · S/N L4482TA N39395Jackson Johnny E · Jackson, GABuilt 1942 · S/N C4682TA N39397Bucher Gregory A · Rancho Cordova, CABuilt 1942 · S/N C4692TA N39515Waco West Inc · Dover, DEBuilt 1942 · S/N L4802TA N39528Eide Larry D · Minot, NDBuilt 1942 · S/N C4952TA N39563Mid Atlantic Air Museum · Reading, PABuilt 1944 · S/N F5664TA N39565Elswick Lawrence B · Uhrichsville, OHS/N C5674TA N39596Learmont Douglas I · Grand Rapids, MNBuilt 1943 · S/N C5603TA N39599Barney John A · Brookings, SDBuilt 1943 · S/N C5643TA N4209KHollon Audie L · Milan, MOBuilt 1942 · S/N 42-14773 N4309FEubank Jesse D · Fountain Run, KYS/N C4422TA N46105Nelson Kenneth D · Norwood, NCBuilt 1942 · S/N C4252-TA N46124Quirk Charles L · Lake Charles, LABuilt 1942 · S/N C-3982TA N47085Bida Dan F · Palo Pinto, TXBuilt 1941 · S/N C-1321-TA N50563Wheels Floats Skids And Skis LLC · Brooklyn, MIBuilt 1942 · S/N C-5372TA N50584Baker James W · Wildwood, MOBuilt 1942 · S/N C4702TA N77503Tranby Todd D · Minot, NDS/N C1811TA N84AHFletcher Spencer S · Labelle, FLBuilt 1942 · S/N C3472TA

Back to Aeronca 65-TAC