Skip to content

Registered aircraft · 756

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

N22863Roberson Henry B · Chico, CABuilt 1968 · S/N 15068571 N22865Turner Tina L · Ford, WABuilt 1968 · S/N 15068573 N22867Jacobs Lydia A · North Pole, AKBuilt 1968 · S/N 15068575 N22876Rhoads Eric Scott · Costa Mesa, CABuilt 1968 · S/N 15068582 N22879Jones Dennis P · Nacogdoches, TXBuilt 1968 · S/N 15068584 N22882Vasiliou Adamos C · Burtonsville, MDBuilt 1968 · S/N 15068586 N22886Sky High Adventures LLC · Wilmington, DEBuilt 1968 · S/N 15068589 N22892Miller Frank L · Ninilchik, AKBuilt 1968 · S/N 15068593 N22893Hoffer Patrick N · Orr, MNBuilt 1968 · S/N 15068594 N22897Donn Rex · Washington, UTS/N 15068598 N22900Swanton Jed M · Shawnee, KSBuilt 1968 · S/N 15068601 N22902Easterling William R · Pikeville, NCBuilt 1968 · S/N 15068603 N22903Walther Newell A · Wasilla, AKBuilt 1968 · S/N 15068604 N22915Sprankle Gerard · Fairbanks, AKS/N 15068613 N22919Brozzo Ralph · St Johns, FLBuilt 1968 · S/N 15068614 N22920Jackson Kenneth R · Stephenville, TXS/N 15068615 N22921Sakry Robert J · Saint Joseph, MNBuilt 1968 · S/N 15068616 N22924Hirkala Ronald R · Weirton, WVBuilt 1968 · S/N 15068618 N22926Gossett Rita M · Granbury, TXBuilt 1968 · S/N 15068619 N22927Hamilton Gregory J · Avon Lake, OHBuilt 1968 · S/N 15068620 N22935Tift Aviation LLC · Tifton, GABuilt 1968 · S/N 15068627 N22956Thyfault Raymond E · Mattawan, MIS/N 15068643 N22963Swift John S · Santa Barbara, CAS/N 15068646 N22970Kingdom Air Corps · Sutton, AKBuilt 1968 · S/N 15068651 N22980Salt City Aviation LLC · Hutchinson, KSBuilt 1968 · S/N 15068656 N22988Runyon James R · Entiat, WABuilt 1968 · S/N 15068664 N22990Peterson Curtis L · Smith Center, KSBuilt 1968 · S/N 15068665 N22991Dan Munson Consulting Pllc · Seneca, SCBuilt 1968 · S/N 15068666 N22998N22998 LLC · Middletown, DES/N 15068670 N22BZ8k Investments LLC Series Cessna 150 · Perryton, TXBuilt 1968 · S/N 15068198 N23001Henshaw Edward C · Vian, OKBuilt 1968 · S/N 15068672 N23009Hopkins Francis · Wilmington, DEBuilt 1968 · S/N 15068675 N23012De La Fuente Carlo H · Lompoc, CAS/N 15068676 N23015Schalk Rudolph A · Morgan Hill, CABuilt 1968 · S/N 15068678 N23017Kopacz Keith P · Saint Thomas, VIS/N 15068680 N23018Andrews University · Berrien Springs, MIBuilt 1968 · S/N 15068681 N23025John R Roberts Jr · Homestead, FLBuilt 1968 · S/N 15068686 N23027Stapleton Jerry L · Jacksonville, FLBuilt 1968 · S/N 15068687 N23046Thomas Jaclyn L · Carrollton, OHBuilt 1968 · S/N 15068697 N23051Gradle Roger Thomas · Fairhope, ALS/N 15068700 N23056Veltman Ine · Mayodan, NCBuilt 1968 · S/N 15068703 N23059Smoketown 150 Club LLC · New Holland, PABuilt 1968 · S/N 15068705 N23064Cherry Creek School District No #5 · Greenwood Village, COBuilt 1968 · S/N 15068707 N23068Pike Mark D · Victorville, CABuilt 1968 · S/N 15068709 N23070Building Busters Demolition & Excavation Corp · Saint Louis, MOBuilt 1968 · S/N 15068711 N23076Alvarado Victor A · Douglas, AZBuilt 1968 · S/N 15068714 N23083Gilstrap Stanley C · Inola, OKBuilt 1968 · S/N 15068717 N23085Flightwave 77 LLC · Dearborn Heights, MIBuilt 1968 · S/N 15068719 N23096Pilot Pros Inc · Miami, FLBuilt 1968 · S/N 15068722 N23098Saddler Darrell L · Elk City, OKS/N 15068723

Back to Cessna 150H