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.

N704WWLay Lawrence W · Douglass, KSBuilt 1976 · S/N 15078941 N704XBSivert Leslie A · Richmond, VABuilt 1976 · S/N 15078946 N704XGByrne Matthew · West Allis, WIBuilt 1976 · S/N 15078951 N704XLWelch Donald E · Crown Point, INBuilt 1976 · S/N 15078955 N704XNStiefer Charlie C · Durant, OKS/N 15078957 N704XSBrian Edward L · La Vergne, TNS/N 15078961 N704XVButzer Jeffrey D · Warrens, WIBuilt 1976 · S/N 15078964 N704XXSaumer Steven E · Pine City, MNBuilt 1976 · S/N 15078966 N704XYWalter Bryce D · Macomb, ILS/N 15078967 N704YASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 15078969 N704YEMarshall J B · Talbott, TNBuilt 1976 · S/N 15078972 N704YLCraig Jason · Upland, CABuilt 1976 · S/N 15078978 N704YPFoss Kayla R · Anchorage, AKBuilt 1976 · S/N 15078981 N704YRB2w Corporation · Winona, MNBuilt 1976 · S/N 15078983 N704YSRepke Robert · Gainesville, GABuilt 1976 · S/N 15078984 N704YVHallmark University Inc · San Antonio, TXS/N 15078987 N704YWKummer Michael J · Floyds Knobs, INBuilt 1976 · S/N 15078988 N704YXMock Joseph R · Huntsville, TXBuilt 1976 · S/N 15078989 N704ZDHayward Stephen L · Amarillo, TXBuilt 1976 · S/N 15078995 N704ZEPlane Junkies LLC · Dover, DEBuilt 1976 · S/N 15078996 N704ZHHouse Robert E Jr · Sanford, NCBuilt 1976 · S/N 15078999 N704ZPErickson Elisabeth R · Port Townsend, WABuilt 1976 · S/N 15079005 N704ZRLikens Michael K · Labelle, FLBuilt 1976 · S/N 15079007 N704ZUWood Donald R · Cottondale, ALBuilt 1976 · S/N 15079010 N704ZWOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N 15079012 N70RQHarbin Elbert W Jr · Dora, ALBuilt 1974 · S/N 15076276 N714ABHawke Ag Aviation Inc · Oakdale, CABuilt 1976 · S/N 15079017 N714ADRedding Courtland J · Gowen, MIBuilt 1976 · S/N 15079019 N714AEWackman Howard P · Elk Grove, CABuilt 1976 · S/N 15077874 N714AFStoberski John J · Henderson, NVBuilt 1976 · S/N 15079021 N714AGGreenwing Aviation & Welding Co · Lacon, ILBuilt 1976 · S/N 15079022 N714AJMarra Michael A · Carlisle, PABuilt 1976 · S/N 15079024 N714AMRadovanovic Dimitri · Newport Beach, CABuilt 1976 · S/N 15079027 N714APGhiselli William A III Trustee · Woodruff, WIBuilt 1976 · S/N 15079029 N714AQSale Kelly L · Priest River, IDS/N 15079030 N714AZMarsh Gary W · Hopkinsville, KYBuilt 1976 · S/N 15079039 N714BBHunter Jack D · Prattville, ALFirst renewal noticeBuilt 1976 · S/N 15079041 N714BERegistration Pending · Campbell Hall, NYRegistration pendingBuilt 1976 · S/N 15079044 N714BJChandler Scott G · Fortuna, CAFirst renewal noticeBuilt 1976 · S/N 15079047 N714BKZehner Mike W · Boise, IDS/N 15079048 N714BLPeery Harold R · Madill, OKBuilt 1976 · S/N 15079049 N714BNFly Low Aviation LLC · Smithville, MSS/N 15079051 N714BTZielke Michael M · Chuluota, FLBuilt 1976 · S/N 15079056 N714CABlue Steele LLC · Barnegat, NJBuilt 1976 · S/N 15079063 N714CCMckeon Kevin A · Center Moriches, NYS/N 15079065 N714CDVan Ooijen Herman J · Utica, NYBuilt 1976 · S/N 15079066 N714CEWade Bryan · Westfield, INBuilt 1977 · S/N 15079398 N714CFMuir Stephen G · Woodbridge, CABuilt 1976 · S/N 15079068 N714CHGo Leasing Co · Phillipsburg, KSFirst renewal noticeBuilt 1976 · S/N 15079070 N714CJSideline Services LLC · Pearland, TXS/N 15079071

Back to Cessna 150M