Skip to content

Registered aircraft · 321

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 ('1151544', '1151542')
  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 ('1151544', '1151542')
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.

N6201VUnangst John F · Fort Worth, TXBuilt 1967 · S/N D-8609 N6218VWrather Christopher C · Los Alamos, CABuilt 1967 · S/N D-8651 N6240VRegistered aircraftBuilt 1967 · S/N D-8628 N6247VNichols Mark W · St Pete Beach, FLBuilt 1967 · S/N D-8614 N624NPHackett Stevan S · Jacksonville, ILBuilt 1969 · S/N D-9010 N6276VHilsenroth Robert · Fernandina Beach, FLBuilt 1967 · S/N D-8603 N6277VBlue Jay Aviation · Lake Placid, FLS/N D-8601 N6278VMontana Excursions LLC · Modesto, CABuilt 1968 · S/N D-8602 N6284VBradsher Harold Michael · Troy, MOBuilt 1967 · S/N D-8605 N6287VGilbert Gavin J · Granbury, TXBuilt 1967 · S/N D-8607 N6296VFollis Chad · Hartford, IABuilt 1967 · S/N D-8621 N6298VRegistered aircraftBuilt 1967 · S/N D-8611 N630SUWinchester Jerry L · Nichols Hills, OKS/N D-9022 N635PPBodor Geza S · Denver, COBuilt 1967 · S/N D-8637 N6552VSatellite Airways Ltd · Pella, IABuilt 1967 · S/N D-8623 N6553V44hw LLC · Shreveport, LABuilt 1967 · S/N D-8625 N6554VXwgnfc LLC · Horsham, PABuilt 1967 · S/N D-8624 N660R660 Romeo LLC · Tulsa, OKBuilt 1968 · S/N D-8826 N664DMStar Air Group LLC · Anchorage, AKBuilt 1968 · S/N D-8721 N666MSSandy Bayou Planting Co · Osceola, ARBuilt 1969 · S/N D-9004 N674TTumbling Mirth Mt LLC · Cody, WYBuilt 1969 · S/N D-9007 N68APAbecca Corporation · Jackson, MIBuilt 1968 · S/N D-8899 N68SMSimms Richard J · Shady Shores, TXBuilt 1968 · S/N D-8779 N691RBPali Inc · Nashville, TNBuilt 1967 · S/N D-8639 N6SVFaivre Anthony L · Hampshire, ILBuilt 1969 · S/N D-8917 N7002NBfr Racing Inc · Monticello, ARBuilt 1967 · S/N D-8613 N7016NN7016n LLC · Columbia, MOBuilt 1967 · S/N D-8649 N7018NLawless Van N Jr · Mooresville, NCBuilt 1967 · S/N D-8618 N7021NRobertson Eric A · Knoxville, TNBuilt 1967 · S/N D-8620 N7023NSteria Kermit J · Monahans, TXBuilt 1967 · S/N D-8627 N7045NIndy Air Sales LLC · Anderson, INBuilt 1967 · S/N D-8633 N7046NMoore John Robert III · Lusby, MDBuilt 1967 · S/N D-8634 N7048NBonanza Enterprises LLC · Mill Valley, CABuilt 1967 · S/N D-8636 N7049NJ M Williams LLC · Stockton, CABuilt 1967 · S/N D-8638 N7050NGuy Darrell G · Marietta, GABuilt 1967 · S/N D-8645 N7053NNames Loch K · Eugene, ORBuilt 1967 · S/N D-8646 N7058NAeroplanes2 LLC · Indianola, IABuilt 1967 · S/N D-8640 N7069NLindley Robert F · Williamson, GABuilt 1967 · S/N D-8658 N7072NDesrosiers Stefan · Scotch Plains, NJBuilt 1967 · S/N D-8648 N7073NOlson Steven E · Lakeville, MNBuilt 1967 · S/N D-8650 N7075NSign Zeppelin LLC · Orlando, FLBuilt 1968 · S/N D-8733 N707LHoon David M · Wolf Creek, MTBuilt 1968 · S/N D-8731 N7082NJasmin Grant Frederick Jr · East Palo Alto, CABuilt 1967 · S/N D-8661 N7083NCollins John D · Charlotte, NCBuilt 1967 · S/N D-8663 N7096NBoylan Scott J · BerlinBuilt 1967 · S/N D-8662 N7102NDefelice David E · Ponte Vedra Beach, FLBuilt 1967 · S/N D-8667 N7104NGober Kerwin D · Farmington, NMBuilt 1967 · S/N D-8666 N7114NPrairie Air Inc · Elbow Lake, MNBuilt 1967 · S/N D-8668 N7116NMook Joshua Tyler · Cincinnati, OHBuilt 1967 · S/N D-8670 N711RBMorris John C III · Rochester, MNBuilt 1969 · S/N D-9015

Back to Beech V35A