Skip to content

Bellanca 14-19-3

Registered aircraft · 57

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 ('3080106', '1250012')
  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 ('3080106', '1250012')
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.

N1252RRunnin Rabbit LLC · Kalispell, MTBuilt 1968 · S/N 4342 N1254RGunter Bradley M · Canon City, COBuilt 1966 · S/N 4314 N1257RWells Carolyn B · Whitefish, MTBuilt 1966 · S/N 4325 N1258RUnderland Evageline D · Willmar, MNS/N 4329 N1270RDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1966 · S/N 4327 N1282RHoover Brian A · Warsaw, INS/N 4335 N1283RKeyser Dakota R · Ralls, TXBuilt 1966 · S/N 4330 N1290RJones William Frank · Brea, CAFirst renewal noticeBuilt 1966 · S/N 4316 N1292RHudson Mitchell C · Erie, COBuilt 1966 · S/N 4324 N1313XM & S Airsupply DBA · Hawthorne, CAS/N 4223 N165TVSwanland Robert C · Grants Pass, ORBuilt 1960 · S/N 4189 N16LSBonomo Thomas · Colorado Springs, COBuilt 1959 · S/N 4150 N18MTBaker John Bennett · Tahoka, TXS/N 4237 N199KLWebb Phillip D · Diamondhead, MSFirst renewal noticeBuilt 1966 · S/N 4321 N55812Heaton Timothy J · Apopka, FLS/N 4109 N6853DKeith Fred D · Norco, CABuilt 1960 · S/N 4176 N7262TLittle John · Hamilton, TXS/N 4155 N7604EEngle Vicki L · Columbus, NMBuilt 1959 · S/N 4106 N7606EWright Thomas · Clyde, OHS/N 4108 N7608EColvin Buster · Big Cabin, OKBuilt 1959 · S/N 4110 N7612EGallegos Arthur A · Las Vegas, NVS/N 4114 N7613EGross J Peter DBA · Kalispell, MTBuilt 1959 · S/N 4115 N7623ERedpath Mike P · Washington, OKS/N 4186 N7628EWelsh Christopher · Oxford, NCBuilt 1959 · S/N 4130 N7630EMelton Allie J · Goldsboro, NCBuilt 1959 · S/N 4132 N7632EBedrock Aero Ltd · Urbana, OHBuilt 1959 · S/N 4134 N7639ERosario Ted · Salome, AZBuilt 1959 · S/N 4141 N8205RRazo Beltran Josefina · Carlton, ORBuilt 1965 · S/N 4264 N8506RJones Stephen C · Wadsworth, ILBuilt 1965 · S/N 4268 N8508RClark Douglas E · Petal, MSS/N 4270 N8511RBrenner John M · Spring Creek, PABuilt 1965 · S/N 4273 N8524RRieger Chris L · Sacramento, CABuilt 1966 · S/N 4286 N8531RWise Jonathan K · Eden, NCS/N 4293 N8533RGelinas Peter L · Burien, WABuilt 1966 · S/N 4313 N8534RA F K Corp · Ripon, WIBuilt 1966 · S/N 4296 N8535REastep Bryan N · Hutchinson, MNS/N 4297 N8536RRegistration Pending · South Boston, VARegistration pendingS/N 4298 N8541RKnapper Jack · Hibbing, MNBuilt 1966 · S/N 4303 N8543RJ&Ks Spruce Specimens LLC · Alexandria, MNBuilt 1966 · S/N 4305 N8544RHunter James E · Quebeck, TNBuilt 1966 · S/N 4306 N8545RJohnson Bruce M · Schertz, TXBuilt 1966 · S/N 4307 N8547RPeterson Amy L · Boulder City, NVBuilt 1966 · S/N 4309 N8548RTri State Air Motive LLC · Berryville, ARBuilt 1966 · S/N 4310 N8804RGouldsmith Marlene S · Rose Hill, KSBuilt 1959 · S/N 4156 N8805REvans James · Tuolumne, CABuilt 1959 · S/N 4157 N8808RSloan David J · Anchorage, AKBuilt 1960 · S/N 4204 N8809RBon Aero LLC · Bonaire, GAS/N 4161 N8811RBloch Christopher P · Grand Rapids, MIBuilt 1959 · S/N 4163 N8833RFox Craig · Carnelian Bay, CABuilt 1960 · S/N 4187 N8846RReynolds Robert B · Amarillo, TXS/N 4200

Back to Bellanca 14-19-3