Skip to content

Registered aircraft · 756

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

N50132Dunaire LLC · Mechanicsburg, PABuilt 1968 · S/N 15069080 N50133Pilot Legal Funding Inc · Fresh Meadows, NYBuilt 1968 · S/N 15069081 N50138Kalb Brian A · Mechanicsburg, OHBuilt 1968 · S/N 15069083 N50140Air Devices Company LLC · Alpena, MIS/N 15069084 N50146Aero Sceince International LLC · Martinez, GABuilt 1968 · S/N 15069089 N50150Above All Aviation Inc · Santa Barbara, CABuilt 1968 · S/N 15069092 N50151Thums April M · Murfreesboro, TNBuilt 1968 · S/N 15069093 N50155Haupricht Andy C · Sanford, NCBuilt 1968 · S/N 15069097 N50156Humanic Thomas J · Columbus, OHBuilt 1968 · S/N 15069098 N50160Morales-Escareno Rogelio · San Diego, CAS/N 15069102 N50170Moroney Aviation LLC · Chugiak, AKBuilt 1968 · S/N 15069106 N50171Evans Mark E · Heber Springs, ARS/N 15069107 N50177Dudley Lee B · Passadumkeag, MEBuilt 1968 · S/N 15069110 N50180Robbins Richard T · Ketchikan, AKS/N 15069112 N50181Debelius Enemark Peter C · Crawfordville, FLBuilt 1968 · S/N 15069113 N50184Wietecha Jack · Millington, ILBuilt 1968 · S/N 15069115 N50188Ryburn Michael D · Basehor, KSBuilt 1968 · S/N 15069119 N50194Brouillette Jakob D · Daleville, ALS/N 15069124 N50201Ahrens Brian T · Hainesport, NJBuilt 1968 · S/N 15069131 N50202Velasquez Jorge · Brawley, CABuilt 1968 · S/N 15069132 N50205Spruce Moose LLC · Salt Lake City, UTS/N 15069135 N50209N Maple LLC · Kalispell, MTBuilt 1968 · S/N 15069139 N50213Canarr Randall J · Anchorage, AKS/N 15069141 N50219Sftb LLC · Miami, FLBuilt 1968 · S/N 15069145 N50221Smith Wayne A · Uxbridge, MABuilt 1968 · S/N 15069146 N50222Baldwin Kevin R · San Tan Valley, AZBuilt 1968 · S/N 15069147 N50224Reshetar Ryan D · Evansville, INBuilt 1968 · S/N 15069149 N50231Aaronflight LLC · Hillsboro, ORBuilt 1968 · S/N 15069153 N50232Firby John E · Diamond, OHBuilt 1968 · S/N 15069154 N50234Lloyd Barry C · Sacramento, CABuilt 1968 · S/N 15069156 N50245Christian Martha J · Ham Lake, MNBuilt 1968 · S/N 15069163 N50251Krol Patrick · Chicago, ILBuilt 1968 · S/N 15069167 N50252Price Benjamin A · Hattiesburg, MSBuilt 1968 · S/N 15069168 N50255Andrews Michael E · Huron, OHBuilt 1968 · S/N 15069170 N50258Willis Walter W · Kamiah, IDS/N 15069172 N50261Copeland Joey A · Douglas, GABuilt 1968 · S/N 15069174 N50262Garrison Vincent Gray · Yadkinville, NCBuilt 1968 · S/N 15069175 N50263Registered aircraftBuilt 1968 · S/N 15069176 N50266Plentl Steve R · Shepherd, TXBuilt 1968 · S/N 15069179 N50267Buckner Natasha · Locust Grove, VABuilt 1968 · S/N 15069180 N50268Mach Steven William · Chicago, ILBuilt 1968 · S/N 15069181 N50269Joerger Dannie L · Greensburg, INBuilt 1968 · S/N 15069182 N50270Flanagan Elizabeth M · Coronado, CABuilt 1968 · S/N 15069183 N50274Currie William O · Lumberton, NCBuilt 1968 · S/N 15069186 N50276Pense Richard L · Katy, TXBuilt 1968 · S/N 15069188 N50283Sanchez Oscar A Blanco · Portsmouth, VAS/N 15069194 N50284Dunaire LLC · Mechanicsburg, PABuilt 1968 · S/N 15069195 N50286Baue Michael G · Foristell, MOBuilt 1968 · S/N 15069197 N50292Wheeler Richard Edmond III · Norfolk, VABuilt 1968 · S/N 15069201 N50297Eddleston Ryan · Winter Haven, FLBuilt 1968 · S/N 15069206

Back to Cessna 150H