Skip to content

Registered aircraft · 36

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

N23565Bourland William F · Leakey, TXBuilt 1939 · S/N C5239 N26386Jenkins Robert W · Fredricktown, OHBuilt 1940 · S/N 1070T N27336Hofer Colleen J · Sawyer, NDBuilt 1940 · S/N F-1490T N27351Hawkins Richard · Tybee Island, GAS/N F1640T N27356Henderson William Gary · Lake Worth, TXS/N C1680T N27384Spivey Lana S · Guntersville, ALBuilt 1940 · S/N C1970T N29198Gull Industries LLC · Oneco, CTBuilt 1940 · S/N L2600T N29414Byker Robert L · Porterville, CABuilt 1940 · S/N C3060T N29416Martin Ronald P · Tehachapi, CABuilt 1940 · S/N 3080T N29452Parsons Walter E · Clinton, NCS/N 4240T N29456Boling Kenneth A · Greenbrier, ARBuilt 1940 · S/N L4280T N29473Barbee Max C · Wharton, TXBuilt 1940 · S/N 4450T N29477Johnson Scott J · Oshkosh, WIBuilt 1940 · S/N C4500T N310RJPayne John B · Denton, TXS/N L10241T N31308Carpenter Willard D · Borrego Springs, CAS/N L4750T N31355Ray Albert · Prosser, WABuilt 1940 · S/N C6030T N31378Hogan Frederick D · Hamilton, OHS/N L-8020-T N31410Bates Bi-Planes LLC · Faribault, MNBuilt 1940 · S/N 5200T N31432Englund Ronald E · Springfield, ORBuilt 1940 · S/N L-5290T N31491Aeronca Aircraft History Museum · Brighton, MIBuilt 1940 · S/N C10870 N31493Bentley Jeffrey W · Kenmore, WABuilt 1940 · S/N 5710T N31496Agaliotis Paul E · San Martin, CAS/N C5720T N31498Kearns Gary W · New Athens, ILBuilt 1940 · S/N 5760T N31499Agaliotis Paul E · San Martin, CABuilt 1940 · S/N 5770T N31713Ferris Thomas P · Bloomingdale, ILBuilt 1940 · S/N 5920 N31726Mcmanus Keith S · Carlisle, PAS/N F6110T N31751Sterling Aviation Services Inc · Wilmington, NCS/N L6300T N31776Buchanan Thomas K Jr · Morristown, TNS/N 6480T N31791Carr Dion P · Geneseo, ILS/N 6600T N31832Baggot John P · Shiocton, WIBuilt 1941 · S/N C9181T N31873Sabre Society Of North Carolina · Hickory, NCBuilt 1941 · S/N L9191T N33768Parsons Walter E · Clinton, NCS/N 9391T N33780Zollars Thomas B · Dallas, TXBuilt 1941 · S/N L9411T N33835Matheny Roger Paul · Shepherd, TXS/N C9651T N34414Parsons Walter E · Clinton, NCS/N 9871T N34424Cowley Byron Lamond · Henrietta, TXBuilt 1941 · S/N 9881T

Back to Aeronca 65-TC