Skip to content

Registered aircraft · 913

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

N28LDDancing Bear LLC · Polson, MTBuilt 1970 · S/N D-9205 N291ABSerafini Louis · Ringwood, NJBuilt 1970 · S/N D-9119 N2980AWest David R · Newalla, OKBuilt 1978 · S/N D-10154 N29VRegistered aircraftBuilt 1972 · S/N D-9340 N2CBBoxman LLC · Wilmington, DEBuilt 1977 · S/N D-10090 N2CSBolton Geoffrey M · Groveland, CABuilt 1973 · S/N D-9463 N2DNHaines Matthew E · Lake Dallas, TXBuilt 1973 · S/N D-9426 N2DURegistered aircraftBuilt 1977 · S/N D-10030 N3017WKirk Michael E · Alvin, TXBuilt 1973 · S/N D9520 N3023WBoughen James R · Camas, WABuilt 1973 · S/N D-9517 N3032WDebrouwer Isabelle Mc · Alpine, TXBuilt 1973 · S/N D-9525 N3041CVangundy Timothy S · Camby, INBuilt 1976 · S/N D9946 N3057WBaskins Robert H · Huntington Beach, CABuilt 1973 · S/N D-9557 N3064WDavid And Shirley Houchin LLC · Crescent City, FLBuilt 1973 · S/N D-9553 N3092WPrimm Daniel D Jr · Lexington, KYBuilt 1973 · S/N D-9556 N3099WSavage Curtis Mac · Johnstown, OHBuilt 1973 · S/N D-9561 N309DCRother Michael V · Granbury, TXBuilt 1979 · S/N D-10309 N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076 N30VTPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1973 · S/N D-9439 N3102WBonanza Leasing LLC · Versailles, KYBuilt 1973 · S/N D-9558 N311BGBluffton Flying Service Ltd · Bluffton, OHBuilt 1971 · S/N D9276 N3128WSterling Anthony K · Wilson, NCBuilt 1973 · S/N D-9564 N3135WFlycarolina LLC · Concord, NCBuilt 1973 · S/N D-9538 N3138WN3138w Bonanza V35b LLC · Jeffersonville, INBuilt 1973 · S/N D-9566 N313DBHelm Walter · Sacramento, CABuilt 1977 · S/N D-10014 N313WWilliams Thomas James · Clovis, CABuilt 1981 · S/N D-10363 N3147WTadesco Rothchild LLC · Wilmington, DEBuilt 1973 · S/N D-9569 N315ABColabianchi Bob J · Fountain Hills, AZBuilt 1975 · S/N D-9740 N3161WPritchard Casey M · Bells, TXBuilt 1973 · S/N D-9572 N3163WSkye Peak Corp · Greenfield, MABuilt 1973 · S/N D-9573 N317CHCrestair Air LLC · Dover, DEBuilt 1973 · S/N D-9543 N3180WPepe Charles · Morrisville, VTBuilt 1974 · S/N D-9574 N3181WNormark Jordan C · Granbury, TXBuilt 1974 · S/N D-9575 N319RFFairfax Ronald E · Hailey, IDBuilt 1974 · S/N D-9663 N31FSStrickland Corp · Onida, SDBuilt 1974 · S/N D-9586 N3206LAlpha Tango LLC · Omaha, NEBuilt 1976 · S/N D-9951 N3211LPrevost Bryan · Lambert, MTBuilt 1976 · S/N D-9914 N322HSReed Systems Ltd · Ellenville, NYBuilt 1974 · S/N D-9709 N325MGLock N Climb LLC · Independence, KSBuilt 1977 · S/N D-9990 N32631Grewell Dean R · Waukee, IABuilt 1979 · S/N D-10301 N328HRShuster David · Fredericksburg, VABuilt 1979 · S/N D-10269 N329RTRegistered aircraftBuilt 1972 · S/N D-9343 N32BHBechtold Brahm Hellman · Parker, COBuilt 1977 · S/N D-10046 N32DERatcliff Daniel Trustee · Austin, TXBuilt 1977 · S/N D-9965 N333RJAddco Aviation Services Inc · Newcastle, OKBuilt 1978 · S/N D10188 N334CHLittle River Aviation LLC · Tifton, GABuilt 1977 · S/N D9962 N335VHolden Donald T · Cherokee, IABuilt 1980 · S/N D-10338 N33FSBvd Inc · Yates Center, KSBuilt 1974 · S/N D-9658 N33FXDougfly Inc · Malibu, CAS/N D-10105 N33VBVb313 LLC · Fort Myers, FLBuilt 1976 · S/N D-9899

Back to Beech V35B