Skip to content

Bellanca 14-19-2

Registered aircraft · 49

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

N1313BSwanland Robert C · San Jose, CABuilt 1958 · S/N 4072 N131HPrentice Robert D · Ripon, WIBuilt 1957 · S/N 4041 N13235Registration Pending · Shreveport, LARegistration pendingBuilt 1958 · S/N 4050 N7600EEgmond Aircraft LLC · Lewes, DEBuilt 1958 · S/N 4102 N7601EKramer Shawn T · Middletown, INBuilt 1959 · S/N 4103 N7650BGoodman W Robert · Opelika, ALBuilt 1957 · S/N 4001 N7651BPolihierax LLC · Kalispell, MTBuilt 1957 · S/N 4002 N7652BWalker Brent L · Meridian, IDBuilt 1957 · S/N 4003 N7653BBair Craig A · Lake City, SDBuilt 1957 · S/N 4004 N7662BGibbs Keith L · Eaton Rapids, MIBuilt 1957 · S/N 4013 N7672BNoslen Enterprises LLC · Goodland, KSBuilt 1957 · S/N 4023 N7674BSky Monkey Tailwheels LLC · Richardson, TXBuilt 1957 · S/N 4025 N7676BBudahn Christopher W · Austin, MNBuilt 1957 · S/N 4027 N7679BSchmitz Kenneth G · Petersburg, NEBuilt 1957 · S/N 4030 N7682BBrantley Hugh L · Hazlehurst, GAS/N 4033 N7683BTorrey Daniel B · Santa Paula, CABuilt 1957 · S/N 4034 N7684BHergot Jay H · Los Angeles, CABuilt 1957 · S/N 4035 N7685BBoeger Cade · Montgomery, TXBuilt 1957 · S/N 4036 N7686BFishburn Michael T · Edgewood, NMBuilt 1957 · S/N 4037 N7687BRoberts James D Trustee · Tehachapi, CAFirst renewal noticeBuilt 1957 · S/N 4038 N7691BAcrovezda LLC · Williamsburg, VABuilt 1957 · S/N 4042 N7692BSnodgrass Randall W · Lake Tapps, WABuilt 1957 · S/N 4043 N7695BHake Glenn W · Tennessee Ridge, TNBuilt 1958 · S/N 4046 N7699BBarton Timothy E · Belvidere, ILBuilt 1958 · S/N 4051 N9800BEmery Scott Joseph · Seattle, WABuilt 1958 · S/N 4052 N9801BCullman Daniel H · Kent, WABuilt 1958 · S/N 4053 N9804BTaonick Aviation Investments Inc · Ormond Beach, FLBuilt 1958 · S/N 4056 N9806BLayton Brian E · Wolcott, INBuilt 1958 · S/N 4058 N9807BMertesdorf Daniel R · Woodland, CABuilt 1958 · S/N 4059 N9809BGuymon Stephen L · Mesa, AZFirst renewal noticeBuilt 1958 · S/N 4061 N9810BRegistered aircraftS/N 4062 N9811BTarver Kent H · Yuma, AZBuilt 1958 · S/N 4063 N9815BBarnes Donald E · Wagener, SCBuilt 1958 · S/N 4067 N9818BMiranda Ryan E · Las Vegas, NVBuilt 1958 · S/N 4070 N9819BEngesath David H · Duluth, MNBuilt 1958 · S/N 4071 N9822BAllen Ken · Shelby, NCBuilt 1958 · S/N 4074 N9823BOoi Lucy M · Catlett, VAS/N 4075 N9824BMckee Shane D · Fairbanks, AKS/N 4076 N9826BLaird Charles L · Adelanto, CABuilt 1958 · S/N 4078 N9831BOxford Sherman D · Flower Mound, TXBuilt 1958 · S/N 4083 N9832BMiller Darrell Y · Madras, ORBuilt 1958 · S/N 4084 N9833BIcarus Flights LLC · Rising Fawn, GAFirst renewal noticeBuilt 1958 · S/N 4085 N9839BCederquist Carl L · Hayden, IDBuilt 1958 · S/N 4091 N9841BHoge Aviation LLC · Pipersville, PABuilt 1958 · S/N 4093 N9842BRose Jeffrey C · Carmichael, CABuilt 1958 · S/N 4094 N9845BWalker Brent L · Meridian, IDBuilt 1958 · S/N 4095 N9846BFischer Bruce M · Sun Prairie, WIBuilt 1958 · S/N 4098 N9847BLucas Charles G · Elmore City, OKBuilt 1958 · S/N 4099 N9849BZatloukal Jan · Payette, IDBuilt 1958 · S/N 4101

Back to Bellanca 14-19-2