Skip to content

Bellanca 17-30A

Registered aircraft · 399

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

N110CBBos Bernard D · Astoria, ORBuilt 1974 · S/N 74-30678 N114PGRegional Medical · Stephentown, NYBuilt 1971 · S/N 30370 N115CCPlane Guys LLC · Saint Onge, SDBuilt 1979 · S/N 7930931 N121EDLarry K Brown · Round Rock, TXBuilt 1979 · S/N 80-30969 N122RHPadussis Gary Theodore · Cape May, NJBuilt 1993 · S/N 93-301017 N1261RHuff Joshua A · Larned, KSBuilt 1973 · S/N 73-30535 N1266RObowa James K · Lino Lakes, MNBuilt 1972 · S/N 30431 N1267RMurrell James F Sr · Douglas, AZBuilt 1971 · S/N 30403 N1274RPolyspray Corporation · Asheboro, NCBuilt 1972 · S/N 30432 N1279RSedona Aviation LLC · Sedona, AZS/N 30402 N1289RLeblanc Rick M · Deerwood, MNBuilt 1972 · S/N 30417 N1298RSouthern Utah University · Cedar City, UTBuilt 1972 · S/N 30479 N1333SMclaughlin Sam J · Lubbock, TXBuilt 1973 · S/N 73-30601 N14680Hendricks Aric W · Floydada, TXS/N 74-30643 N14687Dalessio Enterprises Inc · Smithville, TNS/N 74-30671 N14690Davis Scott · Morse, TXBuilt 1973 · S/N 74-30637 N14691Weakley Robert Kayce · Pleasant View, TNS/N 74-30682 N14695Johnson Charles E · Vernon, TXBuilt 1974 · S/N 74-30688 N14705Bernath Robert J · Saint Johns, FLBuilt 1974 · S/N 74-30668 N14706Carter Delton W · Sumner, TXS/N 74-30716 N14709Godfrey Lawrence J · Leucadia, CABuilt 1973 · S/N 74-30650 N14721Mcdonald Trading Post Inc · Plainview, TXBuilt 1973 · S/N 74-30647 N14729Heard Terrell · Amarillo, TXBuilt 1974 · S/N 74-30707 N14732Robson Thomas A · Mcdonough, GABuilt 1974 · S/N 75-30756 N14736Stern Gerald W · Ft Worth, TXBuilt 1974 · S/N 74-30703 N14738Stern Gerald W · Fort Worth, TXBuilt 1974 · S/N 74-30694 N14740Coleman Edward H · Tulare, CABuilt 1973 · S/N 74-30642 N14744Trimble Anthony W · Weatherford, TXS/N 74-30630 N14745Rockwell Donnal E · Ozona, TXBuilt 1973 · S/N 74-30656 N14751Maiorka Kevin D · Lockhart, TXBuilt 1974 · S/N 74-30666 N14754Registration Pending · Clarkston, MIRegistration pendingBuilt 1975 · S/N 75-30765 N1476251 Adventures LLC · East Montpelier, VTS/N 74-30649 N14764Bl14764 LLC · Homer, LABuilt 1974 · S/N 74-30701 N14771Shiner Aviation LLC · Georgetown, TXBuilt 1974 · S/N 75-30732 N14772Koehn Loren M · Galva, KSBuilt 1974 · S/N 74-30691 N14782Roberts James B · Piedmont, OKS/N 74-30629 N14783Braddock Zachary J · Ladson, SCBuilt 1973 · S/N 74-30640 N14786Registered aircraftBuilt 1973 · S/N 74-30651 N14792Ripley James Jefferson III · Frederick, OKS/N 74-30645 N14793Clinton M Ward Pc · Vinita, OKBuilt 1974 · S/N 74-30708 N14798Ingle Stephen D · Bainbridge, OHBuilt 1974 · S/N 74-30675 N147PHSale Reported · Dallas, TXSale reported, canceledBuilt 1974 · S/N 74-30679 N147TBSullivan David L · Santa Fe, TXBuilt 1985 · S/N 85-30994 N14908Reiter Scott D · Leesburg, VABuilt 1974 · S/N 74-30662 N14909Johnson Bruce M · Schertz, TXBuilt 1973 · S/N 74-30626 N15DQPrivette Hugh T Trustee · Colorado Springs, COBuilt 1975 · S/N 75-30773 N16AWFreas Joseph R · Simi Valley, CABuilt 1973 · S/N 74-30634 N1730ATapley Brian K · Dothan, ALBuilt 1988 · S/N 89-301004 N179TWBlue Sky Aviation Investments LLC · Coconut Creek, FLBuilt 1979 · S/N 79-30957 N192CRIvas Edward P · Great Barrington, MABuilt 1992 · S/N 92-301016

Back to Bellanca 17-30A