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.

N9260UFlying L Aircraft Inc · Fort Denaud, FLBuilt 1976 · S/N 15078210 N9261UOconnor Sean P · Pompano Beach, FLBuilt 1976 · S/N 15078211 N9262UNichols Curtis E · Gloucester, VABuilt 1976 · S/N 15078212 N9265UEtchell Bruce R · Healdsburg, CABuilt 1976 · S/N 15078215 N9266UEgge Danny C · Pelican Rapids, MNBuilt 1976 · S/N 15078216 N9267UDavis Andrew P · Leominster, MABuilt 1976 · S/N 15078217 N9268UIbrahim Motaz · Goodyear, AZBuilt 1976 · S/N 15078218 N9270UYoung Orvel W · Maineville, OHBuilt 1976 · S/N 15078220 N9271UWallis Bruce W · Kingwood, TXBuilt 1976 · S/N 15078221 N9277UPeters Airway LLC · Pratt, KSBuilt 1976 · S/N 15078227 N9281UOtters Heinrich · Fredericksburg, TXBuilt 1976 · S/N 15078231 N9282USchur David · Lavernia, TXBuilt 1976 · S/N 15078232 N9297UNorthwest Wings LLC · Hillsboro, ORBuilt 1976 · S/N 15078247 N9303UWestover Scott A · Anchorage, AKBuilt 1976 · S/N 15078253 N930JSDolphin Air LLC · Fairbanks, AKBuilt 1975 · S/N 15076752 N9315UGilbreath Brent · Arlington, TXBuilt 1976 · S/N 15078265 N9316URoadrunner Bus LLC · Weston, NEBuilt 1976 · S/N 15078266 N9318UWhite David A · Omaha, ARS/N 15078268 N9319UJohnson Douglas G · Mason City, IABuilt 1976 · S/N 15078269 N9328UFlymoore Ventures LLC · Saint George, UTBuilt 1976 · S/N 15078277 N9330USt Pierre George III · Palm Bay, FLBuilt 1976 · S/N 15078279 N9333URoe Russell M · Martinez, CABuilt 1976 · S/N 15078282 N9340UJohnson Cory D · Rugby, NDBuilt 1976 · S/N 15078289 N9343ULazor Ronald E · Middlefield, CTBuilt 1976 · S/N 15078292 N9344UNewman Thomas E · Saint Ignatius, MTBuilt 1976 · S/N 15078293 N9347UAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078296 N9351UHolt James D · Greensboro, NCBuilt 1976 · S/N 15078300 N9357UBaldwin James S · Sylvania, OHBuilt 1976 · S/N 15078306 N9358USaddedine Nouredine · Frisco, TXBuilt 1976 · S/N 15078307 N9360UVeenker Frank C · Tygh Valley, ORBuilt 1976 · S/N 15078309 N9374UWest Harold · Ozark, ALBuilt 1976 · S/N 15078323 N9377UDepue Amanda N · Wasilla, AKBuilt 1976 · S/N 15078326 N9378ULrh Equipment LLC · Pendleton, ORBuilt 1976 · S/N 15078327 N9380UForsberg Johnny L · Meridian, IDBuilt 1976 · S/N 15078329 N9383UEmmons Russell S · Waterbury, CTS/N 15078332 N9386UOdrobina Frank A · North Canton, OHBuilt 1976 · S/N 15078335 N9389UCorrigan Michael D · Hondo, TXBuilt 1976 · S/N 15078337 N9391UKnight Services And Consulting LLC · Dardanelle, ARS/N 15078339 N9392USale Reported · Wheeling, ILSale reportedBuilt 1976 · S/N 15078340 N9394UYu Hermon Lemuel C · Mays Landing, NJBuilt 1976 · S/N 15078342 N9396AFortune Michael W · East Dublin, GABuilt 1976 · S/N 150-78550 N9396UMullen Randy R · Pasco, WAS/N 15078344 N9397UWelch Kerry D · Alpine, UTS/N 15078345 N9398UShouling & Philip Enterprise · Lancaster, CABuilt 1976 · S/N 15078346 N9402UMayrant Dawson Z · College Station, TXS/N 15078350 N9403UPaschal Engineering Inc · Houston, TXFirst renewal noticeBuilt 1976 · S/N 15078351 N9404UWhitcomb James F · West Ossipee, NHBuilt 1976 · S/N 15078352 N9405UBishop Michael E · Clarkston, WAS/N 15078353 N9406UMontgomery Paul Richard · Fredericksburg, VABuilt 1976 · S/N 15078354 N9408UTenhoff Lee L · Homer, AKBuilt 1976 · S/N 15078356

Back to Cessna 150M