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.

N66248Jeffery Anne Kuba · Godley, TXBuilt 1975 · S/N 15075952 N66249Erickson Keith E · Anchorage, AKS/N 15075953 N66254Beachy Matthew F · Russellville, KYBuilt 1974 · S/N 15075957 N66260Schile James · Janesville, MNS/N 15075962 N66261Gregor John P · Allentown, NJBuilt 1974 · S/N 15075963 N66268Rahden Tiffany · Bellevue, WABuilt 1974 · S/N 15075967 N66271Registration Pending · Waverly, IARegistration pendingBuilt 1974 · S/N 15075969 N66273Delgadillo Jose M · League City, TXBuilt 1974 · S/N 15075970 N66277Mcclure Wayne R · Anchorage, AKBuilt 1974 · S/N 15075972 N66281Alaska Sky School LLC · Anchorage, AKBuilt 1974 · S/N 15075974 N66314Tan Cfi LLC · Plano, TXS/N 15075983 N66322Barker Michael S · Stanford, KYS/N 15075986 N66333Registration Pending · Cooksville, MDRegistration pendingBuilt 1974 · S/N 15075988 N66349Kecy Kevin · Owls Head, MEBuilt 1974 · S/N 15075990 N66376Backhaus John W · Hampton, NHBuilt 1974 · S/N 15076000 N66379Curry Zachary A · Loveland, COBuilt 1974 · S/N 15076003 N66380Logan Thomas H · Canfield, OHBuilt 1974 · S/N 15076004 N66383Tuskegee Airmen National Historical Museum · Detroit, MIS/N 15076007 N66384Anderson Rick L · Valley City, NDBuilt 1974 · S/N 15076008 N66386Registration Pending · Portage, MERegistration pendingBuilt 1974 · S/N 15076010 N66387Bredvold Daniel M · Mendota Heights, MNS/N 15076011 N66393Dash Roger A · Niles, MIBuilt 1974 · S/N 15076017 N66394Y&S Aviation LLC · Oceanside, CAS/N 15076018 N66395Murray Kevin D · Moneta, VABuilt 1974 · S/N 15076019 N66397Petersen Bradley L · Bellingham, WABuilt 1974 · S/N 15076021 N66402King Dwayne W · Sutton, AKBuilt 1974 · S/N 15076025 N66412Farris Chad M · Bronte, TXBuilt 1975 · S/N 15076032 N66420Ware Charles W Jr · Atmore, ALBuilt 1974 · S/N 15076035 N66422Zaleski-Johnson Laura · Mays Landing, NJBuilt 1974 · S/N 15076036 N66425Biornstad John A · Big Lake, AKBuilt 1974 · S/N 15076039 N66437Fluno John I · San Anselmo, CAS/N 15076049 N66439Mancini James N · Baltimore, MDBuilt 1974 · S/N 15076051 N66440Tenenboym Dennis Alexander · Pinellas Park, FLBuilt 1974 · S/N 15076052 N66452Bedard Michael J Trustee · Madison, ALBuilt 1974 · S/N 15076059 N66453Beaudry Phillip H · Newport, VTBuilt 1974 · S/N 15076060 N66455Soendergaard Carsten · Aguila, AZBuilt 1974 · S/N 15076061 N66459Amelia Reid Aviation LLC · San Jose, CABuilt 1974 · S/N 15076063 N66463Sikkema Romke P · Sebring, FLBuilt 1974 · S/N 15076065 N66467Joe Dory Aviation LLC · Star, IDS/N 15076068 N66469Pirtle Sandra Rinehart · Winnsboro, TXBuilt 1974 · S/N 15076070 N66472Bgmaviate LLC · Fairfax, VABuilt 1974 · S/N 15076072 N66478Mason John M · Gilbert, AZBuilt 1974 · S/N 15076074 N66479Gardner John F · Lyons, NYFirst renewal noticeS/N 15076075 N66494Graham Luke R · Rushville, NEBuilt 1974 · S/N 15076081 N66501Sanders Robert M · Youngsville, NCBuilt 1974 · S/N 15076084 N66502Dewey Holdings LLC · Florence, ALBuilt 1974 · S/N 15076085 N66506Scott John J · Arcadia, FLBuilt 1974 · S/N 15076086 N66507Gozdowski Matthew D · Sylvania, OHS/N 15076087 N66511Rawaero LLC · Warsaw, MOS/N 15076091 N66516Mangon Aircraft Inc · Petaluma, CABuilt 1974 · S/N 15076094

Back to Cessna 150M