Skip to content

Registered aircraft · 976

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

N3245XSchneider Alex · Tempe, AZS/N 15064645 N3246XRouns Daniel L · Brady, MTBuilt 1966 · S/N 15064646 N3250JHigh Mesa Aviation LLC · Naturita, COBuilt 1966 · S/N 15065950 N3254JCarreiro Myriah L · Candia, NHBuilt 1966 · S/N 15065954 N3256JMyers Benny R · Wasilla, AKBuilt 1966 · S/N 15065956 N3259JPreflight Aviation Inc · Oregon, WIBuilt 1966 · S/N 15065959 N3262JBlock Oliver L · Nashville, TNS/N 15065962 N3264JB&K Used Auto & Equipment Llp · Fountain Run, KYBuilt 1966 · S/N 15065964 N3265JFord-Umfuhrer Austin Donavan · Carrollton, GAS/N 15065965 N3268JMiller Robert F · Locust Grove, GAS/N 15065968 N3274JOgrady John Thomas · West Chicago, ILBuilt 1966 · S/N 15065974 N3277JBranson William E · Stokesdale, NCBuilt 1966 · S/N 15065977 N3278JSarrafi Frank H · Tarzana, CABuilt 1966 · S/N 15065978 N3281JRegistration Pending · Oakland, ORRegistration pendingBuilt 1966 · S/N 15065981 N3286JJohnson David W · Biwabik, MNS/N 15065986 N3288JSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15065988 N32897Mach Point Nine LLC · Phoenix, AZS/N 15065989 N3290JFitzgerald Jacob J · Pullman, WABuilt 1966 · S/N 15065990 N3295JClonts Kim E · Knox City, TXS/N 15065995 N3299JEdwards Wallace · Commerce, MIS/N 15065999 N3300JIngram Jay Wallis · El Paso, TXBuilt 1966 · S/N 15066000 N3302JWignot Andrew R · Oceanside, CABuilt 1966 · S/N 15066002 N3303JWilliams Charles S · Pearland, TXBuilt 1967 · S/N 15066003 N3306JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15066006 N3309JMomentum Foundation · Tullahoma, TNS/N 15066009 N3312JAlternate Air Inc · Seattle, WABuilt 1966 · S/N 15066012 N3313JEsckelson Eric S · Cass City, MIS/N 15066013 N3315JFlying Shiba Inus LLC · Dallas, TXS/N 15066015 N3316JChipollini Jorge · Springdale, ARBuilt 1966 · S/N 15066016 N331JCCsp Aviation Holdings LLC · Dallas, TXBuilt 1966 · S/N 15064821 N3320JPollman Justin A · Sherwood, NDS/N 15066020 N3321JFulton Ricky L · Alex, OKBuilt 1966 · S/N 15066021 N3323JRichards Amy L · Union City, INBuilt 1966 · S/N 15066023 N3333JUrban Aviation Services Inc · Paxton, MABuilt 1966 · S/N 15066033 N333WGWilliams Samantha L · Kendallville, INS/N 15065465 N3340JSteiner William Mark · Newport Beach, CABuilt 1966 · S/N 15066040 N3343JAndresen Paul S · Chandler, AZS/N 15066043 N3344JSaitto Jeffrey M · Media, PAS/N 15066044 N3357JHagghult Christer · Bonney Lake, WABuilt 1967 · S/N 15066057 N3358JBlue Chip Enterprises Inc · Clayton, NCBuilt 1967 · S/N 15066058 N3359JGaler Charles J · Irvington, ALBuilt 1967 · S/N 15066059 N3360JStewart Roger · Lenexa, KSBuilt 1967 · S/N 15066060 N3362JLivingston Rod W · Tuttle, NDBuilt 1967 · S/N 15066062 N3364JSlawski Michael E · Tucson, AZBuilt 1967 · S/N 15066064 N3377JGriffith Scott · Hewitt, TXBuilt 1967 · S/N 15066077 N3380JEsparza Edel · Chula Vista, CABuilt 1967 · S/N 15066080 N3385JGonzales Mark S · Dothan, ALS/N 15066085 N3387JMy Piper Pacer LLC · Everett, WAS/N 15066087 N3390JVandyke Dennis C · Rose Hill, VABuilt 1967 · S/N 15066090 N3395JFly N Style · Parkland, FLBuilt 1967 · S/N 15066095

Back to Cessna 150G