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.

N3177JDouble Rr Holdings LLC · Dallas, TXS/N 15065877 N3177XBandy Suzanne M · Newport, ORBuilt 1966 · S/N 15064577 N3178JBirmingham Pilot Academy LLC · Birmingham, ALS/N 15065878 N3179JTri-County Flyers LLC · Morgantown, PABuilt 1966 · S/N 15065879 N3181XHart George · Roseville, CABuilt 1966 · S/N 15064581 N3182XHerrera Lizann · Sumner, WABuilt 1966 · S/N 15064582 N3183JRank Brian Andrew · Oxford, MIBuilt 1966 · S/N 15065883 N3183XTrimble John Sr · Stone Mountain, GABuilt 1966 · S/N 15064583 N3184XSandlapper Aviation Of De · Bennington, VTBuilt 1966 · S/N 15064584 N3185XSanders John L · Sikeston, MOS/N 15064585 N3186JHowenstein John G · Roseville, CABuilt 1966 · S/N 15065886 N3186XPanus Mark V · Hinsdale, NYBuilt 1966 · S/N 15064586 N3187JBrar Amuldeep S · Austin, TXBuilt 1966 · S/N 15065887 N3188JFlight Time Builders Inc · Memphis, TNBuilt 1966 · S/N 15065888 N3190JSimon Mitchell B · Edison, NJBuilt 1966 · S/N 15065890 N3190XOso Air LLC · Missoula, MTBuilt 1966 · S/N 15064590 N3191JPhillips Nicholas H · Mikana, WIS/N 15065891 N3192JWestern Altitude LLC · Dayton, MTBuilt 1966 · S/N 15065892 N3193JWebs James H · Alexander, KSFirst renewal noticeBuilt 1966 · S/N 15065893 N3196XFroes Carlos Da Lapa · Avondale, AZS/N 15064596 N3197XLynn Christopher M · Hood River, ORBuilt 1966 · S/N 15064597 N3198JAlternate Air Inc · Seattle, WABuilt 1966 · S/N 15065898 N3199XClark Terry E · Dixon, MOBuilt 1966 · S/N 15064599 N3200JOdell Steven P · Perrysburg, OHBuilt 1966 · S/N 15065900 N3201XSale Reported · Glen Allen, VASale reportedBuilt 1966 · S/N 15064601 N3204JBecker Charles A · Rice Lake, WIBuilt 1966 · S/N 15065904 N3204XKulesza Roman · Noblesville, INBuilt 1967 · S/N 15064604 N3205XAvery Jackson R · Ontario, ORS/N 15064605 N3208JLandon Christopher L · Portland, ORBuilt 1966 · S/N 15065908 N3208XRhodenbaugh Mitchel D · Wyndmere, NDBuilt 1966 · S/N 15064608 N3211JGo Captain LLC · Lake Worth, FLBuilt 1966 · S/N 15065911 N3212JBrown Joseph E · Palmdale, CABuilt 1966 · S/N 15065912 N3213XAlrubaiie Ihssan R · Fort Worth, TXBuilt 1966 · S/N 15064613 N3215XVoltmer Benjamin P · Excelsior Springs, MOBuilt 1966 · S/N 15064615 N3217JMalinchak Louis Trustee · Bristow, OKBuilt 1966 · S/N 15065917 N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918 N3218KSteinhausen Darrell · Torrington, WYBuilt 1967 · S/N 15065356 N3223JPoulin Philip N · Washington, VTBuilt 1966 · S/N 15065923 N3227JCanepa Joseph H · Baraboo, WIS/N 15065927 N3230JEastside Aero Inc · Eatonville, WABuilt 1966 · S/N 15065930 N3232XBitikofer Brent E · Kansas City, KSBuilt 1966 · S/N 15064632 N3233XNollau Gregory P · Big Bear City, CABuilt 1966 · S/N 15064633 N3236JWoehler Keith A · Bardstown, KYBuilt 1966 · S/N 15065936 N3236XBentch James R · Lincoln, MOBuilt 1966 · S/N 15064636 N3237XRobinson Michael D · Folkston, GABuilt 1966 · S/N 15064637 N3238JHolladay Harold · Lamesa, TXS/N 15065938 N3238XHorsager Phillip C · Montevideo, MNBuilt 1966 · S/N 15064638 N3243XPowell Kenneth D · Benton, ARFirst renewal noticeBuilt 1966 · S/N 15064643 N3244XStecks Keith A · Vista, CABuilt 1966 · S/N 15064644 N3245JAll Sports Aviation LLC · Spokane, WABuilt 1966 · S/N 15065945

Back to Cessna 150G