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.

N45246Carlsen Brent R · Rochester, MNBuilt 1975 · S/N 15076803 N45247Airgo Inc · Centralia, ILBuilt 1975 · S/N 15076804 N45256Albertson James M · Westville, FLBuilt 1975 · S/N 15076808 N45262Wyoming Aviation Association Inc · Cheyenne, WYBuilt 1975 · S/N 15076811 N45263Ruder Bonita E · Maple Park, ILBuilt 1975 · S/N 15076812 N45270Lessley Gavin W · Carrollton, MSBuilt 1975 · S/N 15076815 N45274Robinson Charles F · Portage, MIFirst renewal noticeBuilt 1975 · S/N 15076817 N45281Stewart Patrick D · Reading, MIBuilt 1975 · S/N 15076822 N45284Kelley Keith B · Forney, TXBuilt 1975 · S/N 15076823 N45285Bennett Aaron K · Pulaski, VAS/N 15076824 N45302Missinne Brett R · South Range, WIBuilt 1975 · S/N 15076832 N45308Berry Thomas F · Emmett, IDBuilt 1975 · S/N 15076833 N45327Cullen Richard J · Oshkosh, WIS/N 15076845 N45328N45328 LLC · Naples, FLS/N 15076846 N45335Keeney Daphne C · Fairbanks, AKBuilt 1975 · S/N 15076852 N45341Taylor Robert S · Satsuma, ALS/N 15076857 N45342Skybound Aviation LLC · Bixby, OKBuilt 1975 · S/N 15076858 N45350Kelley Konrad E · Grant Valkaria, FLS/N 15076863 N45351Dallas Permian LLC · Mckinney, TXBuilt 1975 · S/N 15076864 N45361Price Gregory D · Frankfort, ILBuilt 1975 · S/N 15076874 N45364Boren James Mason · Jasper, ALBuilt 1975 · S/N 15076876 N45375Eastern Slope Aviation Academy · North Conway, NHBuilt 1975 · S/N 15076885 N45376Jones Sharon J · Faulkton, SDFirst renewal noticeBuilt 1975 · S/N 15076886 N45393Currie Grant · Hermosa Beach, CABuilt 1975 · S/N 15076900 N45395Holmgren Michael G · Kulm, NDBuilt 1975 · S/N 15076902 N45398Tundra Wolf Inc · King Salmon, AKFirst renewal noticeS/N 15076905 N45407Westrup Gregory W · Greensburg, INBuilt 1975 · S/N 15076908 N45430Coffield Alan B · Canyon Lake, CABuilt 1975 · S/N 15076915 N45434Urban Aviation Services Inc · Paxton, MABuilt 1975 · S/N 15076917 N45446Coronel Juan M · Elk Grove, CAS/N 15076924 N45449Beckett Michael O · Roy, WAS/N 15076927 N45454Aero Flight One LLC · Peoria, AZBuilt 1975 · S/N 15076930 N45459Quirk Charles Leo · Lake Charles, LAS/N 15076934 N45467Airnolimits LLC · Palm Coast, FLBuilt 1975 · S/N 15076939 N45471Verhoeven Mathew M · Avondale, AZBuilt 1975 · S/N 15076941 N45473N2flyingaviation LLC · Foxworth, MSBuilt 1975 · S/N 15076942 N45478Unertl Robert C · Columbus, WIBuilt 1975 · S/N 15076946 N45491Birdwin LLC · Buras, LABuilt 1975 · S/N 15076951 N45496B&R Aircraft LLC · Wadsworth, OHS/N 15076952 N45510Hansen Albert C · Mojave, CABuilt 1975 · S/N 15076954 N45511Sb Aviation LLC · Gowanda, NYBuilt 1975 · S/N 15076955 N45512Caponio & Sons Inc · San Francisco, CABuilt 1975 · S/N 15076956 N45520Frazier John C · Oxford, NCBuilt 1975 · S/N 15076958 N45530Young Thomas E Jr · Alton, MOBuilt 1975 · S/N 15076962 N45541Zxtair LLC · Mankato, MNFirst renewal noticeBuilt 1975 · S/N 15076966 N45542Baldridge Steven J · Edmonds, WAS/N 15076967 N45560Johnson Adam · Denton, TXBuilt 1975 · S/N 15076971 N45563Tremer Jesse · Kathleen, GABuilt 1975 · S/N 15076972 N45566Watts Charles B IV · Pace, FLBuilt 1975 · S/N 15076973 N45570San Mateo Flying Club Inc · Palo Alto, CAS/N 15076974

Back to Cessna 150M