Skip to content

Registered aircraft · 1,439

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

N66517Sugiond Yudi S · Redlands, CABuilt 1974 · S/N 15076095 N66526Latimer Mary M · Vernon, TXBuilt 1974 · S/N 15076101 N66536Ozark Management Inc · Jefferson City, MOBuilt 1974 · S/N 15076105 N66537Woody Oran R · Conroe, TXBuilt 1974 · S/N 15076106 N66539Vargas Serrano Marco Leandro · Roosevelt, UTS/N 15076108 N66541Hardison Samuel H Jr · Mountain View, ARBuilt 1974 · S/N 15076110 N66548Thompson Thurman B · Spencer, VAS/N 15076115 N66550Corcoran Timothy J · Aurora, ORBuilt 1974 · S/N 15076116 N66551Otto Robert E · Battle Ground, WABuilt 1974 · S/N 15076117 N66556Clausing Howard F · Grafton, WIBuilt 1974 · S/N 15076121 N66578Halley Dan R · Avery, TXS/N 15076133 N66589Northwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 15076138 N66591Bmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N 15076140 N66594Gasper Gage · Saint Edward, NEBuilt 1974 · S/N 15076143 N66595Fca Flight Center Inc · Fitchburg, MABuilt 1974 · S/N 15076144 N66596Odom Aviation Inc · Cabot, ARS/N 15076145 N66600Registered aircraftBuilt 1974 · S/N 15076149 N66611Yeager Jay J · Soldotna, AKBuilt 1974 · S/N 15076153 N66614Mann Jeffrey W · Merom, INBuilt 1974 · S/N 15076156 N66615Gardner Donald R · Woodbridge, VABuilt 1974 · S/N 15076157 N66616Lee Ryan · Soda Springs, CABuilt 1974 · S/N 15076158 N66623Milnor Aviation Inc · Milnor, NDBuilt 1974 · S/N 15076161 N66626Mulloy Erik W · Lakeway, TXS/N 15076164 N66628Wichmann Gregory Scott · Las Vegas, NVBuilt 1974 · S/N 15076166 N66635Blue River Aviation LLC · Palmer, AKBuilt 1974 · S/N 15076170 N66636November Sierra Aviation LLC · Oneill, NES/N 15076171 N66637Drake Aerial Enterprises LLC DBA · Genoa, OHFirst renewal noticeBuilt 1974 · S/N 15076172 N66639Central Ohio Soaring Assoc Inc · Marion, OHBuilt 1974 · S/N 15076174 N66649Miller Tobin D · Palmer, AKBuilt 1974 · S/N 15076182 N66652Johnston Craig E · Beach Haven, NJBuilt 1974 · S/N 15076184 N66654Integrated Workforce Solutions Inc · Sacramento, CAFirst renewal noticeBuilt 1974 · S/N 15076186 N66659Devries Douglas · Sparks, NVBuilt 1974 · S/N 15076190 N66683Gusler Gregory L · Halifax, PABuilt 1974 · S/N 15076206 N66687Ruhe Sales LLC · Leipsic, OHBuilt 1974 · S/N 15076210 N66695Moore Jack L · Belfast, MEBuilt 1974 · S/N 15076217 N66700Red Barn Aircraft LLC · Highland, WIBuilt 1974 · S/N 15076218 N66704Sale Reported · Le GosierSale reported, pending cancellationBuilt 1974 · S/N 15076221 N66707Tarr Sheryl Lynn · Spokane, WABuilt 1974 · S/N 15076224 N66708Liberty University Inc · Lynchburg, VABuilt 1974 · S/N 15076225 N66709Smith Micheline Diane · St George, UTBuilt 1974 · S/N 15076226 N66718Schmitt Rudy · Brookshire, TXBuilt 1974 · S/N 15076232 N66723Armstrong Paul D · Stillwater, OKS/N 15076233 N66728Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 15076237 N66730Glau John E · Centennial, COBuilt 1974 · S/N 15076239 N66736Klein Todd · Winston Salem, NCBuilt 1974 · S/N 15076241 N66738Irvin Bradley A · Lula, GABuilt 1974 · S/N 15076242 N66739Airgo Inc · Centralia, ILBuilt 1974 · S/N 15076243 N66745H T Productions Inc · Grayling, MIBuilt 1974 · S/N 15076246 N66748Skypark Inc · Wadsworth, OHBuilt 1974 · S/N 15076249 N66751Talmage Timothy A · Azle, TXBuilt 1974 · S/N 15076251

Back to Cessna 150M