Skip to content

Registered aircraft · 1,065

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

N8696SBartel Duane M · Ocean Shores, WAS/N 15061996 N8697GAeronautical Technical Service Inc · Collierville, TNS/N 15062797 N8698GPriddle Kody W · Norfolk, VABuilt 1966 · S/N 15062798 N8699GFayette Aviation Inc · Lemont Furnace, PABuilt 1966 · S/N 15062799 N8701SRoth David A · Milford, NEBuilt 1965 · S/N 15062001 N8702GHaney James H · Brooksville, FLBuilt 1966 · S/N 15062802 N8705GHammond Douglas C · Des Moines, IABuilt 1966 · S/N 15062805 N8706SN8706s LLC · Lake Orion, MIBuilt 1965 · S/N 15062006 N8708SHall Tyler D · Citrus Heights, CAS/N 15062008 N8710SKressin Ray H · Waunakee, WIBuilt 1965 · S/N 15062010 N8711GBonno Douglas L · Iron River, MIBuilt 1966 · S/N 15062811 N8712SMarys Airport Acres LLC · Neenah, WIBuilt 1965 · S/N 15062012 N8715SAllen Thomas Page · Comer, GABuilt 1965 · S/N 15062015 N8716SBores Scott J · Huron, OHS/N 15062016 N8719GRosso Anthony J · Wallace, NCS/N 15062819 N8721SPruden Larry J · Louise, MSBuilt 1965 · S/N 15062021 N8723GEastham Gregory L · Columbia, KYBuilt 1966 · S/N 15062823 N8723SCondor Aviation LLC · South Saint Paul, MNBuilt 1965 · S/N 15062023 N8725SKolis Joseph E II · Springfield, ILBuilt 1965 · S/N 15062025 N8726GJacks Benjamin Scott · Chanute, KSBuilt 1966 · S/N 15062826 N8727GJstream Lc · Sheridan, WYBuilt 1966 · S/N 15062827 N8727SMejia Jose Patricio · Meridian, IDBuilt 1965 · S/N 15062027 N8730SDederer Laura · Valencia, PAS/N 15062030 N8731GCard James D · Mc Cool, MSBuilt 1966 · S/N 15062831 N8731SLawrenz Richard A · Mcpherson, KSS/N 15062031 N8732GPerkins Robert A · New Richmond, WIBuilt 1966 · S/N 15062832 N8736GSantana Amaury · Winter Haven, FLBuilt 1966 · S/N 15062836 N8739GKlott William D · Morris, ILBuilt 1966 · S/N 15062839 N8740SBucks Flight Academy LLC · Cashion, OKS/N 15062040 N8741GDahlberg James C · Ogilvie, MNS/N 15062841 N8741SJohnson Zachary R · Burien, WABuilt 1965 · S/N 15062041 N8742GReeve Howard E · Minot, NDS/N 15062842 N8744SZiegler Jeffery A · Crescent Springs, KYBuilt 1965 · S/N 15062044 N8745GWildcat Aviation LLC · Schoolcraft, MIBuilt 1966 · S/N 15062845 N8747SEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 15062047 N8748SJones Joel K · Summer Shade, KYBuilt 1965 · S/N 15062048 N8749SHart Richard G · Stoneham, MABuilt 1965 · S/N 15062049 N8750GMoe Charles E · Rosebud, SDBuilt 1966 · S/N 15062850 N8750SStarcher Paul E · Las Vegas, NVBuilt 1965 · S/N 15062050 N8751GCrotts Joseph D · Mocksville, NCBuilt 1966 · S/N 15062851 N8751SMorris Jeffery S · Ukiah, CABuilt 1966 · S/N 15062051 N8757SManna Anthony G · Hanover, MABuilt 1965 · S/N 15062057 N8759SCrowell Jeremy M · Arlington, WABuilt 1965 · S/N 15062059 N8763GElliott Norman C · Stillwater, OKBuilt 1966 · S/N 15062863 N8763SClinton Richard C · Fair Oaks, CAS/N 15062063 N8764GStrait Media LLC · Anchorage, AKS/N 15062864 N8766GGascho Wendell M · Bridgewater, VABuilt 1966 · S/N 15062866 N8769GHeli Thrills LLC · Wills Point, TXBuilt 1966 · S/N 15062869 N8771SGillette Robin A · Scio, ORS/N 15062071 N8772SMccormick Joel S · Elmwood, ILBuilt 1965 · S/N 15062072

Back to Cessna 150F