Skip to content

Registered aircraft · 224

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

N5496DYuhr Keith D · Miami, FLBuilt 1957 · S/N D-5263 N5500DSmoky Mountain Vertical Services LLC · Kodak, TNBuilt 1957 · S/N D-5037 N5503DDodge Michael T · Wausau, WIBuilt 1957 · S/N D-5029 N5505DMolloy Mark E · Waxahachie, TXBuilt 1957 · S/N D-5045 N5506DGarrison John P · Temple, TXBuilt 1957 · S/N D-5046 N5513DManross Marquardt Ltd Partnership · Mesa, AZBuilt 1957 · S/N D-5070 N5515DRichards Paul M · Chicago, ILBuilt 1957 · S/N D-5073 N5517DTillman Fred L · Lakeland, FLBuilt 1957 · S/N D-5044 N5522DBrewer Thomas A · Anderson, INBuilt 1957 · S/N D-5057 N5522FSchlaffer Sandor · Daytona Beach, FLBuilt 1957 · S/N D-5019 N5525DOlsen Gary E · Albuquerque, NMBuilt 1957 · S/N D-5061 N5527DCarns Ronald · Killeen, TXBuilt 1957 · S/N D-5063 N5532DSchaffert Warren E · Trenton, NES/N D-5082 N5533DKilo Aviation LLC · East Peoria, ILBuilt 1957 · S/N D-5083 N5536DLett Laura D · Dallas, TXBuilt 1957 · S/N D-5086 N5545DPartlow Lee · Granbury, TXBuilt 1957 · S/N D-5091 N5546DKennedy Kevin L · Moscow, IDBuilt 1957 · S/N D-5130 N5548DKirkpatrick Robert · Placerville, CABuilt 1957 · S/N D-5111 N5549DRobert T Parker Jr · Bigfork, MTS/N D-5109 N5552DZahl Oerjan · Maricopa, AZBuilt 1957 · S/N D-5179 N5556DMedic Choppers LLC · Springdale, ARBuilt 1957 · S/N D-5078 N5558DSchoenau Michael W · Tulare, CABuilt 1957 · S/N D-5080 N5562DZimwin Enterpises LLC · Austin, TXS/N D-5142 N5569DYniguez Rudy · Redding, CABuilt 1957 · S/N D-5123 N5570DFletcher Jerry W · Yuma, AZS/N D-5102 N5573DDeyoung Robert E · Napa, CABuilt 1957 · S/N D-5125 N5575DKirkwood Joe D · Amarillo, TXBuilt 1957 · S/N D-5280 N5577DJust Plane Vintage LLC · Mountain Home, ARBuilt 1957 · S/N D-5129 N5578DBurkholder Camilles M · Lake Arrowhead, CABuilt 1957 · S/N D-5119 N5583DHanks Dustin Maxwell · Milton, FLBuilt 1957 · S/N D-5158 N5584DBenson Robert W III · Wichita Falls, TXBuilt 1957 · S/N D-5110 N5588DCarson Air Service Inc · Jackson, MSS/N D5177 N5589DForrester Dale E · Scotland, PABuilt 1957 · S/N D-5166 N5591DHarrison John C · Northport, MIBuilt 1957 · S/N D-5152 N5593DOhaike Richard O · Mansfield, TXBuilt 1957 · S/N D-5165 N5596DBas Part Sales LLC · Greeley, COBuilt 1957 · S/N D-5124 N5597DReetz Bernard A · Discovery Bay, CABuilt 1957 · S/N D-5144 N5599DSale Reported · Merritt Island, FLSale reportedBuilt 1957 · S/N D-5131 N55VAHoward Alan L · Leeds, UTBuilt 1957 · S/N D-4996 N5642DMaag Dallas · Nampa, IDBuilt 1957 · S/N D-5222 N567UPDodson Robert B · Harvard, ILBuilt 1957 · S/N D-5010 N57EDWebster Chad E · Coronado, CABuilt 1957 · S/N D-5140 N57HBSkeeler William Tyler · Austin, TXBuilt 1957 · S/N D-5268 N5HKTrboyevich Jessica · Bridport, VTS/N D-4914 N611QLucky Star Farms LLC · Stuart, FLS/N D-5248 N616QMena Carlos T · Colorado Springs, COBuilt 1956 · S/N D-4900 N621QHazell Samuel P · Oceanside, CABuilt 1957 · S/N D-5255 N624QDuea James G Trustee · Oklahoma City, OKBuilt 1957 · S/N D-5258 N624TBozarth Rodney E · Henderson, KYBuilt 1957 · S/N D-5321 N643QGossett Harold D Jr · Granbury, TXBuilt 1957 · S/N D-5318

Back to Beech H35