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.

N48MHSeventh North Hangar LLC · Bolton, MAS/N D-9184 N4984MBas Part Sales LLC · Greeley, COBuilt 1978 · S/N D-10137 N4989MRistevski Bill · Vacaville, CABuilt 1978 · S/N D-10140 N49TRVincent T Remcho Phd LLC · Corvallis, ORBuilt 1974 · S/N D-9628 N4FHWall Jacob · Grapevine, TXBuilt 1976 · S/N D-9973 N4JXCosta James J · Tulare, CABuilt 1974 · S/N D-9642 N4XPPazdziora Ronald G · St Charles, ILBuilt 1982 · S/N D-10401 N506HPPedden Patrick M · Fort Wayne, INBuilt 1969 · S/N D-9073 N5092NMill-Run LLC · Lewes, DES/N D-9893 N509JMRegistered aircraftBuilt 1980 · S/N D10352 N50JMMinter Michael D Jr Trustee · Rock Port, MOBuilt 1978 · S/N D-10141 N510CHTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9999 N512BDTurbo Aviation LLC · Chesterfield, SCS/N D-9398 N516WClearwater Holding LLC · Parkersburg, WVBuilt 1975 · S/N D9744 N517KGRegistration Pending · Pittsburg, TXRegistration pendingBuilt 1980 · S/N D10350 N518MMull Jason E · Chester, NYBuilt 1970 · S/N D-9111 N523ZARegistration Pending · Perryton, TXRegistration pendingBuilt 1974 · S/N D-9596 N525BHWalker Craig · Pleasant View, TNBuilt 1982 · S/N D-10400 N529DDSchwertfeger Dean · Woodruff, WIBuilt 1970 · S/N D-9151 N530CContinental Title Trust LLC Trustee · Wichita, KSBuilt 1976 · S/N D-9927 N531BFLouis F Olberding Dds Pc · Lincoln, NEBuilt 1973 · S/N D-9541 N535BEValiair Lc Trustee · Casper, WYBuilt 1970 · S/N D-9170 N535VBSchellenger Jonathan H · Port Saint Lucie, FLBuilt 1975 · S/N D-9742 N545GMInternational Air Services Inc Trustee · Carson City, NVBuilt 1972 · S/N D-9318 N550CVGoodwin-Huber-Wilhelm Linda Lee · Santa Fe, NMBuilt 1973 · S/N D-9505 N550X550x LLC · Tucson, AZS/N D-9255 N551TN551t LLC · Hesston, KSBuilt 1977 · S/N D-10013 N555LFMadden Todd A · Houston, TXBuilt 1979 · S/N D-10270 N555PZLada Aviation LLC · Alpine, UTBuilt 1975 · S/N D-9782 N555TXBoujo Yoni · Valley Village, CABuilt 1976 · S/N D-9890 N55KCBloch Jeremy · San Francisco, CABuilt 1976 · S/N D-9930 N55KPJm Waypoint LLC · Fresno, CABuilt 1970 · S/N D-9173 N562ELMirman Charles B · Pinehurst, NCBuilt 1970 · S/N D-9174 N56JLSea Air Inc · Wilmington, DEBuilt 1977 · S/N D-10094 N574JPThompson Phillip · Lakeway, TXBuilt 1977 · S/N D-10054 N578UHawley Elizabeth · Wichita Falls, TXBuilt 1978 · S/N D-10206 N57CFTurbett Theodore T · Houston, TXBuilt 1972 · S/N D-9358 N583MGZazworsky John D Jr · Mechanicsburg, PABuilt 1978 · S/N D-10177 N592SMStewart Robert D · Strasburg, COBuilt 1973 · S/N D-9563 N5CKPhlyx Aviation · Edgewater, MDS/N D-9693 N5GKPacific Air Investments LLC · Paso Robles, CABuilt 1975 · S/N D-9831 N5HCPut A Lid On It Palm Beach Inc · Jupiter, FLBuilt 1972 · S/N D-9347 N5QBPayne Thomas H · Tulsa, OKBuilt 1979 · S/N D-10246 N5VLLange Vladimir · Santa Ana, CABuilt 1979 · S/N D-10223 N5XLLove John R · Sutton, MABuilt 1972 · S/N D-9334 N6024AAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N D-10210 N6025TVtales LLC · Urbana, ILBuilt 1979 · S/N D-10213 N60264Buttram John Randal · Panama City, FLBuilt 1979 · S/N D-10219 N6026UJohnsson Johan C · Monterey, CABuilt 1979 · S/N D-10218 N6027GBell William F · Hartwell, GABuilt 1979 · S/N D-10220

Back to Beech V35B