Skip to content

Registered aircraft · 19

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

N27343Becker James · Oconomowoc, WIS/N L1550T N27397Bauer Hank · Windsor, ILBuilt 1940 · S/N 2100T N29153Murray Richard H · Celina, OHS/N 2150T N29178Jackson Jerry L · San Antonio, TXBuilt 1940 · S/N 2400T N29405Schmitz Tim · Grantsburg, WIBuilt 1940 · S/N 2970T N29487Russell Deloyd H · Rural Retreat, VABuilt 1940 · S/N L4610T N31373Matheny Roger Paul · Humble, TXBuilt 1940 · S/N 7070T N31382Davis Ted E · Brodhead, WIBuilt 1940 · S/N L8060T N31433Nelson David R · Sealy, TXBuilt 1940 · S/N L-5390-T N31710Rogers Joe E · Manvel, TXBuilt 1940 · S/N L5890T N31730Jackson David W Trustee · Peoria, ILBuilt 1940 · S/N L6150T N31789Brewer Stephen F · Hamilton, OHBuilt 1940 · S/N 6580T N31819Henry Ronald E · Sullivan, OHBuilt 1941 · S/N 6771T N31837Decker Scot O · Peoria, ILBuilt 1941 · S/N L6791T N33782Hammond James F · Yellow Springs, OHBuilt 1941 · S/N L9341T N33882Matheny Roger Paul · Shepherd, TXBuilt 1941 · S/N L9821T N34468Command Aire LLC · Sitka, AKBuilt 1941 · S/N L-10071T N34520Thomas Robert B · Bristol, CTBuilt 1940 · S/N 4070T N34541Carnegie Scott W · Saint Charles, MOBuilt 1941 · S/N F10151T

Back to Aeronca 65-TL