Skip to content

Registered aircraft · 387

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

N5547ESissom Patrick · Hillsboro, TNBuilt 1958 · S/N 17047 N5548EPowell Nathan · Columbia Falls, MTS/N 17048 N5549EBacchus Tim · Tucson, AZBuilt 1958 · S/N 17049 N5558ESahagun Salvador · Bothell, WAS/N 17058 N5562ECurtis Heather · Fairbanks, AKBuilt 1958 · S/N 17062 N5566EMagnuson Gregory A · Tulsa, OKBuilt 1958 · S/N 17066 N5567ELang James G · Hampshire, ILS/N 17067 N5571EDehen Gregory J · Imperial, MOBuilt 1958 · S/N 17071 N5573EAlbertson James M · Westville, FLBuilt 1958 · S/N 17073 N5575ECopithorne Richard J · West Paris, MEBuilt 1958 · S/N 17075 N5576EKimmell Charles D · Warrenton, VABuilt 1958 · S/N 17076 N5578EGraham Aviation Inc · Galion, OHBuilt 1958 · S/N 17078 N5579EStafford Nicholas A · Mora, MNBuilt 1958 · S/N 17079 N5580ENothdurft Michael Shane · Augusta, GABuilt 1958 · S/N 17080 N5588EPari Aviation LLC · Marion, TXBuilt 1958 · S/N 17088 N5591EAnderson Michael F · Missoula, MTBuilt 1959 · S/N 17091 N5596EBrewer Patricia A · Crossville, TNS/N 17096 N5600ECompton Francis B Jr · Marfa, TXBuilt 1958 · S/N 17100 N5603EMullins Esten R · El Paso, TXBuilt 1958 · S/N 17103 N5604EHarris Stephanie L · Marion, MSBuilt 1958 · S/N 17104 N5608EMyers Alex B · Oshkosh, WIBuilt 1958 · S/N 17108 N5610EBenelli Matthew T · Sandwich, MAS/N 17110 N5613ESuter Laurance · Livermore, CABuilt 1958 · S/N 17113 N5615EWeaver John M · Senoia, GABuilt 1958 · S/N 17115 N5624ERound Engine Aero · Nashville, MIS/N 17124 N5629ECueva Arturo A · Los Angeles, CABuilt 1958 · S/N 17129 N5630EHolliday Mark E · Lake Elmo, MNBuilt 1959 · S/N 17130 N5636EHirt David M · Marblehead, OHBuilt 1959 · S/N 17136 N5638ENorthern Ventures II LLC · Missoula, MTBuilt 1959 · S/N 17138 N5645EHagen Edward E · New Auburn, WIBuilt 1959 · S/N 17145 N5648EHanna Charles M · Luthersville, GABuilt 1959 · S/N 17148 N5657ENobis Chase · Lyons, MIBuilt 1959 · S/N 17157 N5659EBrewer Randall K · Bloomington, INBuilt 1958 · S/N 17159 N5662EFriendly Frogs LLC · Winona, MNS/N 17162 N5663ETschirky Ted S · Pasco, WAS/N 17163 N5666EYakle Paul R · Lebanon, MOBuilt 1959 · S/N 17166 N5667EFolbre Frank S · Millsap, TXS/N 17167 N5668EGreene Daniel W · Yuma, AZBuilt 1959 · S/N 17168 N5673EFarwell William B · Benton, PABuilt 1959 · S/N 17173 N5678ESchutte Eric J · Newport, WAS/N 17178 N5680EBenway Peter S · North Salem, NYBuilt 1959 · S/N 17180 N5684ETucker Lawrence J · Emporia, KSS/N 17184 N5687EWitter Jaykob J · Greenville, MIBuilt 1959 · S/N 17187 N5688EWagner Bryson R Jr · Lewistown, PABuilt 1959 · S/N 17188 N5692EVine Clayton A · Wolf Point, MTS/N 17192 N5694EMoericke Eric A · Waupaca, WIBuilt 1959 · S/N 17194 N5695EHannemann Kurt R · Chicago, ILBuilt 1959 · S/N 17195 N5702EGee Ryan S · Luverne, MNBuilt 1959 · S/N 17202 N5709EMilton Paul R · Temple, TXBuilt 1959 · S/N 17209 N5711EHalbert Andrew D · Graham, WABuilt 1959 · S/N 17211

Back to Cessna 150