Skip to content

Registered aircraft · 141

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

N36580Lasswell Toliver J · Bunker Hill, ILS/N C16831 N36581Blaisdell Leo F · Kalkaska, MIBuilt 1941 · S/N C16841 N36584Mummey Gary E · Stockport, OHS/N CA-16821 N36587White Jared · Grass Valley, CAS/N C16511 N36592Timblin Galen L · Appleton, WIBuilt 1941 · S/N CA-16871 N36600Johnson Anthony L · Columbia, ILBuilt 1941 · S/N C-16991 N36604Hensley Anthony D · Selma, INBuilt 1941 · S/N C-17001 N36606Keller Aviation & Restoration LLC · Breinigsville, PABuilt 1941 · S/N CA17011 N36647Green Benjamin · Canandaigua, NYBuilt 1941 · S/N C17361 N36649Kelley Keith B · Forney, TXS/N C17241 N36650Giandomenico Jamie · Ocean City, MDS/N C17271 N36651Atkinson Marlyn R · Excelsior Springs, MOFirst renewal noticeBuilt 1941 · S/N CA-17261 N36652Sarsfield Michael P · Buford, GABuilt 1941 · S/N CA-17281 N36654Pace Danny W · River Falls, WIBuilt 1941 · S/N C17311 N36656Timoszy James S · Wayne, MIBuilt 1941 · S/N C17301 N36658Ricci Moretti Luigi U · Swarthmore, PABuilt 1941 · S/N C-17321 N36661Rankin Kevin J · Maryville, MOBuilt 1941 · S/N C-17351 N36698Embree Walter G · Harrisonburg, VABuilt 1941 · S/N 17571 N36810Wade Mark C · Bonham, TXBuilt 1941 · S/N C17661 N36837Bowden Donald · Sapulpa, OKBuilt 1941 · S/N C-17731 N36844Henrikson Peter R · Fort Worth, TXS/N C-17791 N36852Young William T Jr · Alton, MOBuilt 1941 · S/N C-17781 N36853Ortiz Ryan T · Suffern, NYBuilt 1941 · S/N CA-17851 N36865Layne Elbert L · Salem, ARBuilt 1941 · S/N CA-17811 N36867Elliott George M · Hathaway Pines, CABuilt 1941 · S/N C-17891 N36889York Stanley A · Leetonia, OHBuilt 1941 · S/N C17931 N36917Campbell Jeffrey W · Millinocket, MEBuilt 1942 · S/N CA18102 N36935Prillwitz Nolan D · Appleton, WIBuilt 1942 · S/N CA-18452 N36960Ercegovac Charles J · Merrill, WIBuilt 1942 · S/N CA-18132 N39327Matheny Roger P · Humble, TXS/N C18252 N39549Murray Richard H · Celina, OHBuilt 1944 · S/N C18574 N39552Clear Prop LLC · Muskogee, OKBuilt 1944 · S/N C18564 N39573Martin Ronald P · Tehachapi, CAS/N CA18472 N39574Jones Gary L · Kerrville, TXBuilt 1942 · S/N C18462 N39575Gill Tyler L · Allensville, KYBuilt 1942 · S/N C-18502 N39580Ranger Aviation Inc · Burlington, COBuilt 1956 · S/N CA18492 N47385Gehrlein Jay L · Waterford, PABuilt 1941 · S/N 16781 N47937Moreland Daniel J · Fircrest, WABuilt 1942 · S/N C-18342 N59170Wolcott Jim N · Grandview, TXBuilt 1941 · S/N CA14451 N64LPVawter Willie H · Holly Lake Ranch, TXBuilt 1942 · S/N C18482 N741ADalton Bobbie C · Yadkinville, NCBuilt 1941 · S/N CA17411

Back to Aeronca 65-CA