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.

N66063Taylor Jonathon K · Carlsbad, CABuilt 1974 · S/N 15075808 N66064Radford Lawrence · Scottsdale, AZBuilt 1974 · S/N 15075809 N66069Vintage Wings Aircraft LLC · Centerpoint, INBuilt 1974 · S/N 15075812 N66073Jenkins Jerome D · Gays Mills, WIS/N 15075815 N66075Malachi Israel · Superior, WIBuilt 1974 · S/N 15075816 N66077Johnson Jerry L · Lewiston, IDBuilt 1974 · S/N 15075817 N66079Dacy Patrick J · Huntley, ILS/N 15075819 N66086Barbosa Manuel Moreira · Apple Valley, MNBuilt 1974 · S/N 15075823 N66088James M Carrigan LLC · Sanibel, FLBuilt 1974 · S/N 15075825 N66089Powell Brett · Bennett, COBuilt 1974 · S/N 15075826 N66092Grinberg Dmitry · Austin, TXBuilt 1974 · S/N 15075827 N66093Ponderosa Land Surveys LLC · Lead, SDBuilt 1974 · S/N 15075828 N66094Nelson Harry L · Towner, NDBuilt 1974 · S/N 15075829 N66099Maddock Jay A · Sugar Grove, ILBuilt 1974 · S/N 15075832 N66105Everett Stanley J · Cumming, GABuilt 1974 · S/N 15075838 N66110Krikorian Philip · Fresno, CABuilt 1974 · S/N 15075843 N66115Hayes Orris E · Betsy Layne, KYBuilt 1974 · S/N 15075846 N66118Segarra Jo Ann · Ponce, PRFirst renewal noticeBuilt 1974 · S/N 15075849 N66119Northwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 15075850 N66120Osten Albert M · Poughkeepsie, NYBuilt 1974 · S/N 15075851 N66127Gulley Cameron L · Eastland, TXBuilt 1974 · S/N 15075856 N66134Jacobs Inc · Huntsville, ALBuilt 1974 · S/N 15075862 N66137Calvert John · Tybee Island, GABuilt 1975 · S/N 15075864 N66140Whitehead Patrick D · Cross Junction, VABuilt 1974 · S/N 15075866 N66147Leckman Richard · Sequim, WABuilt 1974 · S/N 15075870 N66148Hooie Jon Paul D · N Fort Myers, FLBuilt 1974 · S/N 15075871 N66152Aeromarine Airways Inc · Miami, FLBuilt 1974 · S/N 15075875 N66154Registration Pending · Bandon, ORRegistration pendingBuilt 1974 · S/N 15075877 N66157Respess Malvin R · Pantego, NCBuilt 1974 · S/N 15075880 N66158Sublett Timothy M · Raleigh, NCBuilt 1974 · S/N 15075881 N66159Ard Terry D · Mount Vernon, IABuilt 1974 · S/N 15075882 N66164Best Myra J · Sullivan, OHBuilt 1974 · S/N 15075886 N66173Crawford Derrell D · Hot Springs, ARBuilt 1974 · S/N 15075894 N66178Allison Christopher D · Pensacola, FLBuilt 1974 · S/N 15075898 N66181Adr Aircraft Service Inc · Burbank, CABuilt 1974 · S/N 15075900 N66188Mcghie John · Concord, NHBuilt 1974 · S/N 15075906 N66192Roberts John G · Brandon, MSBuilt 1974 · S/N 15075909 N66194Holmes Community College · Goodman, MSBuilt 1974 · S/N 15075910 N66195Sockey Investments LLC · Poteau, OKBuilt 1974 · S/N 15075911 N66197Williams Freddy L Jr · Apo, AEBuilt 1974 · S/N 15075912 N66199Cunningham Chris S · Hiram, GABuilt 1974 · S/N 15075914 N66221Anderson Michael · Newbury, MABuilt 1974 · S/N 15075929 N66229Biggs Craig C · Severna Park, MDBuilt 1974 · S/N 15075936 N66231Taylor Daniel L · Shakopee, MNBuilt 1974 · S/N 15075937 N66238Boggs William · Gurnee, ILFirst renewal noticeBuilt 1974 · S/N 15075942 N66239Star Air Group LLC · Anchorage, AKBuilt 1974 · S/N 15075943 N66243Wainfan Barnaby S · Independence, ORBuilt 1974 · S/N 15075947 N66244Gray Robert B · Amherst, MABuilt 1974 · S/N 15075948 N66245Rio Concho Aviation Inc · Aledo, TXBuilt 1974 · S/N 15075949 N66247Nunley Joe · Holt, FLS/N 15075951

Back to Cessna 150M