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.

N8107SChalmers Ashley · Manalapan, NJBuilt 1965 · S/N 15061707 N8108FSale Reported · Greenback, TNSale reportedBuilt 1966 · S/N 15064208 N8108SGray Ronald W · Hooker, OKBuilt 1965 · S/N 15061708 N8109SWillis Quinton Blair · Murfreesboro, TNBuilt 1965 · S/N 15061709 N810KTDavis John M · Fairhope, ALBuilt 1966 · S/N 15063745 N8110SV B Aviation LLC · Peachtree City, GABuilt 1965 · S/N 15061710 N8111SDavis Ronald K · Havelock, NCBuilt 1965 · S/N 15061711 N8113FBrundige Kevin J · Bennington, VTBuilt 1966 · S/N 15064213 N8114SSutton Richard C · West Lafayette, INBuilt 1965 · S/N 15061714 N8115SRoberts Earl C · Mobile, ALBuilt 1965 · S/N 15061715 N8116FOmlid Robert L · Watford City, NDBuilt 1966 · S/N 15064216 N8117FHhd Aviation LLC · Hamilton, OHS/N 15064217 N8118FMiller Christa L · Rhodesdale, MDBuilt 1966 · S/N 15064218 N8122FGreat Lakes Charity Air LLC · Brown City, MIBuilt 1966 · S/N 15064222 N8122SAnderson Donald A · Kiel, WIBuilt 1965 · S/N 15061722 N8123FTilley Christian M · Shelby, MTBuilt 1966 · S/N 15064223 N8124FMurray Mark J · Georgetown, GABuilt 1966 · S/N 15064224 N8125STucker William F · Booneville, ARS/N 15061725 N8126FWhite Guy B · Waxahachie, TXS/N 15064226 N8126SSun Valley Aviation Inc · Harlingen, TXBuilt 1965 · S/N 15061726 N8128FShowers Gregory S · Williamstown, PABuilt 1966 · S/N 15064228 N8128SLawrence Jason C · Tecumseh, MIBuilt 1965 · S/N 15061728 N8129FHigh Exposure Inc · Wilmington, DEBuilt 1966 · S/N 15064229 N8132SHarris Gregory A · Aurora, COBuilt 1965 · S/N 15061732 N8133FMagarian Mitchell · Jacksonville, FLBuilt 1966 · S/N 15064233 N8134FHammond Steven R · Trenton, MOBuilt 1966 · S/N 15064234 N8135SMcjunkin John Michael · Portland, ORRegistration revokedBuilt 1965 · S/N 15061735 N8136FRawson Aviation LLC · Ardmore, OKBuilt 1966 · S/N 15064236 N8136SPockrus Pat B · Mineral Wells, TXS/N 15061736 N8141SRegistration Pending · La Porte, TXRegistration pendingBuilt 1965 · S/N 15061741 N8142SRebich Jason F · Overton, NVBuilt 1965 · S/N 15061742 N8143SElite Aeronautics LLC · Carolina, PRBuilt 1965 · S/N 15061743 N8144SRegistered aircraftBuilt 1965 · S/N 15061744 N8145SBissat Rishid H · Visalia, CABuilt 1965 · S/N 15061745 N8147SHoehn Ronald T · Perryville, MOS/N 15061747 N8151FMitchell John F · Shannon, ILBuilt 1966 · S/N 15064251 N8153SBelli Tony G · Huron, OHBuilt 1965 · S/N 15061753 N8154FWilson Gary L · Levant, MES/N 15064254 N8155FJapundza Bob · Kokomo, INBuilt 1966 · S/N 15064255 N8155SSale Reported · Cherry Valley, CASale reportedS/N 15061755 N8156FKindlon Aviation Inc · Glenmont, NYBuilt 1966 · S/N 15064256 N8156SPyanov Mark · Clinton, MSS/N 15061756 N8157SAntal Frank Jr · Delta, COBuilt 1965 · S/N 15061757 N8160FRydell Leonard A · Newberg, ORBuilt 1966 · S/N 15064260 N8162FWeishuhn Charlie D · La Grange, TXBuilt 1966 · S/N 15064262 N8165FMoat William A · Braselton, GAS/N 15064265 N8165SDickey Jenni M · Willow, AKBuilt 1965 · S/N 15061765 N8166FHassan Nabil Ibrahim · Victorville, CABuilt 1966 · S/N 15064266 N8167SReid Bryce · Oklahoma City, OKBuilt 1965 · S/N 15061767 N8169FRegistration Pending · Parker, KSRegistration pendingBuilt 1966 · S/N 15064269

Back to Cessna 150F