Skip to content

Bellanca 17-31A

Registered aircraft · 71

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 ('1220435', '1250031')
  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 ('1220435', '1250031')
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.

N10DEDragoo Robert E · Raleigh, NCS/N 73-32-108 N123ALLambert Danny J · Plainview, TXBuilt 1973 · S/N 73-32-104 N123BSLackie Stuart W · Swanton, VTBuilt 1970 · S/N 32-34 N1275RHatter Dan D · Dumas, TXBuilt 1971 · S/N 32-53 N145BCassels James M · Checotah, OKBuilt 1973 · S/N 74-32-133 N14702Cartel Oil Records LLC · Kansas City, MOBuilt 1973 · S/N 74-32-136 N14718Slys Aircraft Service · Platte, SDBuilt 1974 · S/N 74-32-142 N14734Thorman Bryan R · Grand Junction, COBuilt 1974 · S/N 75-32-154 N14746Kashiwa Charles · Glens Falls, NYS/N 75-32-156 N14758Jim Franklin Aviation Service Inc · Ruidoso, NMBuilt 1974 · S/N 74-32-141 N14SFArnold Kiefer · East Prairie, MOBuilt 1973 · S/N 74-32-131 N318SPace Glen M · Columbia, MSS/N 76-32-164 N39811Ozarks Auto Show Inc · Hollister, MOS/N 73-32-98 N39829Buse Darek · Kensington, MNBuilt 1972 · S/N 73-32-101 N39851Kuhns Bart D · Sedalia, MOBuilt 1972 · S/N 73-32-100 N39895Catalanotto Victor · Mansfield, TXBuilt 1973 · S/N 73-32-112 N39909Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 73-32-113 N4033BHawkins Nathan C · Pueblo, COS/N 75-32-153 N4055BViking Aviation LLC · York, NEBuilt 1974 · S/N 75-32-151 N4080BIbrahim Phillip · Whitinsville, MABuilt 1974 · S/N 75-32-150 N4081BCooley George · Cedar Rapids, IABuilt 1975 · S/N 75-32-161 N4113BRishell Charles G · Columbia, MDBuilt 1974 · S/N 74-32-145 N4141BWright Eric K Sr · Wills Point, TXBuilt 1975 · S/N 75-32-160 N4151BCraig Scott W · Sorento, ILBuilt 1974 · S/N 75-32-152 N4205BStasson Robert K · Sikes, LABuilt 1974 · S/N 75-32-146 N429FSSimmons Frederick G · Lake Hiawatha, NJBuilt 1971 · S/N 32-54 N6556VGiannola Peter S · San Diego, CAS/N 32-15 N6575VGreeson Albert O · Moscow, KSBuilt 1970 · S/N 32-22 N6580VStassen Andrew R · Concord, CABuilt 1969 · S/N 32-16 N6583VLedger William V Jr · Shreveport, LABuilt 1969 · S/N 32-20 N6591VEpic Air Power LLC · Newark, DES/N 32-29 N6597VGold Air LLC · Woodland Hills, CABuilt 1970 · S/N 32-24 N6636VMoss Herman D · Centreville, VABuilt 1970 · S/N 32-32 N73DNMurdoc Aviation LLC · Destin, FLBuilt 1973 · S/N 73-32-110 N73KPRuiz Teresa M · Lakewood Ranch, FLBuilt 1973 · S/N 73-32-115 N746RRSolis Inc LLC · Alton, NHBuilt 1974 · S/N 75-32-147 N77973Rentme LLC · Muskegon, MIBuilt 1973 · S/N 73 32122 N77EWBellanca Aviation Of Blairstown LLC · Andover, NJBuilt 1974 · S/N 74-32-137 N8236RBellanca LLC · Galena, KSS/N 32-67 N824KLN824kl LLC · Lakewood, CABuilt 1973 · S/N 73-32-123 N8254RKrejci Ryan J · Sandstone, MNBuilt 1972 · S/N 32-88 N8255RTwo River Airspray LLC · Cavalier, NDBuilt 1972 · S/N 32-72 N8258RNewo Aviation LLC · Garden City, KSS/N 32-66 N8265RMirrorstriker Aviation LLC · Tomball, TXBuilt 1972 · S/N 32-73 N8275RRensberger Scott C · Lake Jackson, TXBuilt 1972 · S/N 32-84 N8278RSutton Barry W · Longview, TXBuilt 1972 · S/N 32-82 N8287RHuhnke John · Newburgh, INBuilt 1972 · S/N 32-81 N872JWWheeler Jeffrey A · Elyria, OHBuilt 1972 · S/N 32-90 N8820VDiversified Dialysis Services Inc · Lithonia, GABuilt 1971 · S/N 32-35 N8828VStebner William R · Crossville, TNBuilt 1971 · S/N 32-40

Back to Bellanca 17-31A