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.

N22AGMavridoglou Theo A · Brandon, MSBuilt 1973 · S/N D-9499 N22VHSchiltz David A · Ankeny, IABuilt 1973 · S/N D-9458 N233RPlane Jane Aviation LLC · Sylvania, GABuilt 1975 · S/N D9811 N233SCMattoso Ricardo Q · Spicewood, TXBuilt 1974 · S/N D-9599 N23542Mrj Aviation LLC · Attica, NYBuilt 1977 · S/N D-10085 N23583Ingersoll David K · Trinity, ALBuilt 1978 · S/N D-10087 N235RDGrady Fun Flying LLC · Grady, OKBuilt 1973 · S/N D-9446 N23607Green P Stephen · Steamboat Springs, COBuilt 1977 · S/N D-10088 N23609Wiebelhaus John J · Strasburg, COBuilt 1978 · S/N D-10089 N23674Siebenhaar Harold J · Los Altos, CAS/N D-10146 N23685Clements Dennis · Chapel Hill, NCBuilt 1978 · S/N D-10099 N23723Kleck Wil · Victoria, TXBuilt 1978 · S/N D-10100 N23AGParker Robert B · Trussville, ALBuilt 1975 · S/N D-9834 N240MBail Air LLC · Port Saint Lucie, FLBuilt 1970 · S/N D-9211 N24131Hicks Chad A · Dalhart, TXBuilt 1978 · S/N D-10117 N24161Diamond Scenery LLC · Red Oak, TXBuilt 1978 · S/N D-10103 N24183Smither Tom M · Marietta, GABuilt 1978 · S/N D-10107 N24195Barrett Group LLC · Farwell, TXBuilt 1978 · S/N D-10110 N242FFThomas Leslie R · Kosse, TXBuilt 1971 · S/N D-9220 N242SFCurtin Christopher C · Ashburn, VABuilt 1977 · S/N D-10064 N249BB42m Aviation LLC · Shady Shores, TXBuilt 1979 · S/N D-10318 N24AGAegis Air LLC · Columbia City, INBuilt 1979 · S/N D-10293 N24JVVan Blarcom John C II · Highland, CABuilt 1972 · S/N D-9337 N25632Struck Larry G · Gardnerville, NVS/N D-9435 N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438 N25662Atcnavion LLC · Hinckley, OHBuilt 1973 · S/N D-9522 N25717Vaadi LLC · Babson Park, FLBuilt 1973 · S/N D-9542 N25719Brunner Robert L · Jefferson, ORBuilt 1973 · S/N D-9540 N259JHall James A · Bozeman, MTBuilt 1973 · S/N D-9430 N25BTFernandez Sergio R · Port Saint Lucie, FLBuilt 1981 · S/N D-10373 N25VBOtto Aircraft Sales Inc · Sarasota, FLBuilt 1976 · S/N D-9841 N2740AMcdaniel Joseph Stewart II · Henderson, TXS/N D-10113 N274HSWebb Alan J · Medford, ORBuilt 1976 · S/N D-9922 N275BBrunsvold Gene R · Selma, ORBuilt 1970 · S/N D-9206 N2773WStokes Robert A · Golden, COBuilt 1975 · S/N D-9720 N277WLLozier Wesley · Farmington, ILBuilt 1977 · S/N D-10029 N27DHMcavoy Sean M · Greenbrier, TNBuilt 1970 · S/N D-9149 N2842WHeisey Ronald B · Friendswood, TXBuilt 1973 · S/N D-9491 N2843WJ & L Equipment Sales & Rental LLC · Andersonville, TNBuilt 1973 · S/N D-9496 N2846WJohnson Daniel P · Williamsburg, IABuilt 1973 · S/N D-9497 N2848WBlack Brian K · Gillette, WYBuilt 1973 · S/N D-9492 N284JWOrdway Jepson · Freeville, NYBuilt 1973 · S/N D-9495 N2862WBonanza 62w LLC · Richmond, INBuilt 1973 · S/N D-9504 N2870WRobinson John D · Peachtree City, GABuilt 1973 · S/N D-9501 N2875WTreadway Ag Delaware LLC · Lewes, DES/N D-9508 N2886WBushong Chistopher L · Gulf Shores, ALS/N D-9512 N2890WAlbatross Aviation LLC · Lakeville, OHBuilt 1973 · S/N D-9510 N2894WDavenport Skyler R · Granbury, TXBuilt 1973 · S/N D-9514 N28CPArk Investments Inc · Ridgeland, MSBuilt 1971 · S/N D-9213 N28DBEdson Franz R · Waterford, CTBuilt 1970 · S/N D-9139

Back to Beech V35B