Skip to content

Registered aircraft · 659

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

N51206King Aviation LLC · Altamont, MOBuilt 1968 · S/N 15069838 N51209Green Harvey D · Germantown, TNBuilt 1968 · S/N 15069840 N51219Szostak Edward M · San Diego, CABuilt 1968 · S/N 15069845 N51220Trevillyan Bart L · Hot Springs, SDS/N 15069853 N51223James Joseph E · Janesville, WIBuilt 1968 · S/N 15069848 N51224Rettenmeyer Ryan J · Buford, GABuilt 1968 · S/N 15069849 N51225Riccelli Zack Louis · Portland, ORBuilt 1968 · S/N 15069850 N51232Hawk Hangars Corporation LLC · Jenks, OKS/N 15069857 N51251Technical Education Services Inc DBA · Virginia Beach, VABuilt 1968 · S/N 15069872 N51256Miller Andy · Marana, AZBuilt 1968 · S/N 15069875 N51257Burnham Nathaniel · Eagle Mountain, UTBuilt 1968 · S/N 15069876 N51258Nelson Otis · Portage, MEBuilt 1968 · S/N 15069877 N51266Reiter Marc · Hooks, TXBuilt 1968 · S/N 15069881 N51275Hollow David C · Knoxville, TNBuilt 1968 · S/N 15069887 N51284Stallbaumer Roger P · Seneca, KSBuilt 1968 · S/N 15069894 N51285Bk Aviation Inc · Grand Prairie, TXBuilt 1968 · S/N 15069895 N51287Personal Air LLC · Wilmington, DES/N 15069897 N51288Cantley Richard W · Bluff City, TNS/N 15069898 N51292Herbert William N · Anchorage, AKBuilt 1968 · S/N 15069901 N51304Stewart Roy L · Roy, UTS/N 15069909 N51306Durand Gregory M · Marquette, MIBuilt 1968 · S/N 15069911 N51314Scott John J · Arcadia, FLBuilt 1968 · S/N 15069916 N51316Devault Clayton D · Larkspur, COS/N 15069918 N51317Spitzer Terry E · Kalona, IAS/N 15069919 N51323Rathnayake Eric · Collegeville, PABuilt 1968 · S/N 15069924 N51326Lapoint Paul E · Drummond Island, MIBuilt 1968 · S/N 15069926 N51327Bowles Alan B · Georgetown, TXBuilt 1968 · S/N 15069927 N51328Butterfield Charles D · Eskridge, KSBuilt 1968 · S/N 15069928 N51333Blazey John Stanley · Palmyra, NYBuilt 1968 · S/N 15069930 N51334Cragg Noel J · Millbrae, CABuilt 1968 · S/N 15069931 N51337Garner Charlotte Trustee · Sun Lakes, AZS/N 15069933 N51343Tucker John D II · Fayetteville, GABuilt 1968 · S/N 15069939 N51345Arizona Aircraft Leasing LLC · Mesa, AZS/N 15069941 N51347Bernhardt Michael J · North Branch, MNS/N 15069942 N51355Miller Judith A · Homer, AKS/N 15069946 N51365Cavu Pilot LLC · Powell, TNBuilt 1968 · S/N 15069953 N51367Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 15069954 N51369Thorn Blake A · Coupeville, WAS/N 15069956 N51373Roberts Aviation LLC · Shreveport, LAS/N 15069959 N51374Siekmann David G · Scottsdale, AZBuilt 1968 · S/N 15069960 N51376Reaves Ronald E · Olive Branch, MSBuilt 1968 · S/N 15069962 N51385Taylor William E · Waynesville, MOBuilt 1968 · S/N 15069967 N51389Knudson Tamara M · Deer Park, WABuilt 1968 · S/N 15069970 N51393K&P Flyers LLC · Douglasville, GAS/N 15069974 N51398Twitchell Robert · Jefferson City, MOBuilt 1968 · S/N 15069979 N51400Clark Paul W · Alexandria, MNBuilt 1968 · S/N 15069981 N51401Dowling Connor · Edmonds, WABuilt 1968 · S/N 15069982 N51406Mh Aviation LLC · Le Mars, IABuilt 1968 · S/N 15069987 N51410Good Paul H · Long Island, VABuilt 1968 · S/N 15069990 N51411Lambourne Robert · Pensacola, FLBuilt 1968 · S/N 15069991

Back to Cessna 150J