Skip to content

Registered aircraft · 132

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

N1178KLittle Darlin Air Corps LLC · Madison, ALBuilt 1947 · S/N 058B-2472 N1265VBerry Darrel · Camden, TNBuilt 1943 · S/N 11253 N1282AVecoli Jeremy J · Richfield, MNS/N 058B1282 N1336JPhillips James H · Houston, TXBuilt 1947 · S/N 058B13644 N25098Long Island Early Fliers Club · Holbrook, NYBuilt 1942 · S/N 058B9413 N333CUAlamo Liaison Group · San Antonio, TXS/N 058B-2082 N35BBAlkire Richard P · Dayton, OHBuilt 1944 · S/N 0-58B-9383 N46004Thissell David W · Plymouth, MABuilt 1943 · S/N 058B5572 N46010Booe Matthew R · Centerpoint, INBuilt 1943 · S/N 058B11733 N46014Macpherson David Ross · Cantonment, FLBuilt 1943 · S/N 058B12153 N46026Vintage Flying Machines Inc · Huntington, INBuilt 1943 · S/N 058B13394 N46040Iddings Wayne C · Binghamton, NYBuilt 1944 · S/N 058B13153 N46058Brewer Stephen F · Hamilton, OHBuilt 1944 · S/N 058B13514 N46064Mount Glenn W · Modesto, CABuilt 1943 · S/N 058B12203 N46082Gapstur Bruce Martin · Belle Plaine, IABuilt 1942 · S/N 058B6212 N46114Thomas Robert B · Bristol, CTBuilt 1943 · S/N 12133 N46181Tollett Thomas V · Sunrise Beach, TXBuilt 1944 · S/N 5822 N46183Thissell David W · Plymouth, MABuilt 1947 · S/N 058B10483 N46185Tollett Thomas Vernon · Sunrise Beach, TXBuilt 1942 · S/N 058B-11413 N46186Sokol Daniel · Goodyear, AZBuilt 1943 · S/N 12103 N46248Widewings LLC · Alexandria, VABuilt 1942 · S/N 058B-1122 N4641VThomas Peter N · Greenwood, FLS/N 2042 N46480Alfred & Lois Kelch Aviation Museum · Brodhead, WIS/N 058B-8793 N46515Quirk Charles L · Lake Charles, LAS/N C-3872TA N46538Johnson James C · Marion, KYBuilt 1943 · S/N 058B-8573 N46589Brewer David N · Putney, VTBuilt 1942 · S/N 6962 N46608Klink John A · Farmington, PABuilt 1942 · S/N 058B-1172 N46609Registration Pending · Terra Bella, CARegistration pendingBuilt 1941 · S/N C3712TA N46634Potts Charles E · Ellwood City, PABuilt 1943 · S/N 058B-12883 N46768Wicker Jeremy · Glen Saint Mary, FLBuilt 1943 · S/N 058B8422 N46857Thomas Robert B · Bristol, CTBuilt 1943 · S/N 058B8493 N46896Foley Sumner R · Spring Hill, FLBuilt 1942 · S/N 058B-2872 N46899Furlong Kelly L · Athens, ALBuilt 1942 · S/N 058B-4502 N46924Dwelle Kenneth H · Auburn, CABuilt 1945 · S/N 058B8443 N46930Harrison William S · Hernando, MSBuilt 1944 · S/N 13864 N47002Schmitz Timothy W · Grantsburg, WIBuilt 1943 · S/N 058B-9263 N47051Registration Pending · Charlevoix, MIRegistration pendingBuilt 1943 · S/N 058B-11363 N47175Mayhall Douglas A · Mokena, ILBuilt 1943 · S/N 9163 N47181Birsa Keith A Trustee · Cherry Valley, ILBuilt 1943 · S/N 12088 N47182Guthrie Joe F · Jasper, ALBuilt 1947 · S/N 13284 N47185Assend Dragon Aviation LLC · San Antonio, TXBuilt 1943 · S/N 058B-11123 N47187Burton Leslie L Jr · Mt Juliet, TNBuilt 1943 · S/N 11473 N47237Savage Timothy S · Huntington, INBuilt 1945 · S/N 0-58B-9783 N47252Westergaard Dennis L · Craig, NEBuilt 1944 · S/N 058B-9843 N47262Rumsey Todd A · Sturgis, MIBuilt 1944 · S/N 058B-13213 N47265Phillips John D Executor · Montgomery, TXBuilt 1944 · S/N 058B-13504 N47287Buraas Aleta K · Oklahoma City, OKS/N 058B8993 N47299Catalano James J · Wilmington, NYBuilt 1943 · S/N 058B-13614 N47336Ferris Thomas P · Bloomingdale, ILBuilt 1943 · S/N 10323 N47371Currie Mark H · Justin, TXBuilt 1943 · S/N 058B9083

Back to Aeronca 0-58B