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.

N23502Thompson Timothy L · St Croix Falls, WIBuilt 1968 · S/N 15068994 N23504N23504 LLC · Fort Pierce, FLBuilt 1968 · S/N 15068996 N23508Aviato Research LLC · Phoenix, AZBuilt 1968 · S/N 15068999 N2BFMs Aero Inc · Lakeville, OHBuilt 1968 · S/N 15068499 N305MJRegistration Pending · Phoenix, AZRegistration pendingBuilt 1967 · S/N 15067465 N321TXMartin James K · Kingsville, TXBuilt 1967 · S/N 15067252 N323LULetourneau University · Longview, TXBuilt 1968 · S/N 15068776 N324LULetourneau University · Longview, TXS/N 15067538 N342BCMouriz Javier · Leesburg, FLBuilt 1968 · S/N 15068493 N368ABStryker Kevin · Ben Wheeler, TXBuilt 1968 · S/N 15069023 N388SESunset Eagle Aviation LLC · Southport, FLBuilt 1968 · S/N 15068466 N3901CAero II Inc · Spartanburg, SCBuilt 1968 · S/N 15069096 N3902CRegistration Pending · Post Falls, IDRegistration pendingBuilt 1968 · S/N 15069101 N3905CWind Walker LLC · Tucson, AZBuilt 1968 · S/N 15069294 N412CDOppegard Nicholas D · Eagle River, AKBuilt 1967 · S/N 15067488 N419CALind William · Los Angeles, CAS/N 15069273 N41WPSale Reported · Copper Center, AKSale reported, pending cancellationS/N 15068019 N420WWFlying Colors Airparts Inc · Leesburg, FLS/N 15069243 N4265CHunt Delbert O · Dillon, MTBuilt 1968 · S/N 15068178 N436SAClark Vernon · Olalla, WABuilt 1967 · S/N 15067549 N444TR444 Tr Inc · Van Alstyne, TXBuilt 1967 · S/N 15067661 N49WXMason County Aero Club · Ludington, MIBuilt 1968 · S/N 15068744 N50004Nichols Jonathon L · Toney, ALBuilt 1968 · S/N 15069001 N50010Sawalha Malik · Arlington, TXBuilt 1968 · S/N 15069007 N50012Barnett Russell L · Ozark, MOBuilt 1968 · S/N 15069009 N50014Hertneck Robert W · Lumberton, NJBuilt 1968 · S/N 15069010 N50019Rozier Randall S · Fairbanks, AKBuilt 1968 · S/N 15069014 N50020Pickering Michael A · Walpole, NHS/N 15069015 N50025Chapman Kyle W · Orange Beach, ALBuilt 1968 · S/N 15069019 N50027Worthington Gary L · Swifton, ARBuilt 1968 · S/N 15069021 N50033Bulloch Scott W · Columbia Station, OHBuilt 1968 · S/N 15069024 N50035Jepsen James H · Flandreau, SDBuilt 1968 · S/N 15069026 N50037Registered aircraftBuilt 1968 · S/N 15069028 N50040Portco Aviation LLC · Bonham, TXBuilt 1968 · S/N 15069031 N50042Burcham Austin · Dallas, TXBuilt 1968 · S/N 15069033 N50044Huffine Kenneth A · Caswell Beach, NCBuilt 1968 · S/N 15069035 N50049Whitcher Todd D · Grayling, MIBuilt 1968 · S/N 15069039 N50053Zehnder Michael W · Elk Grove, CABuilt 1968 · S/N 15069041 N500591w1 Aero LLC · Issaquah, WAS/N 15069043 N50064Graves Charles L · Joplin, MOBuilt 1968 · S/N 15069046 N50079Schmitt Rudy · Brookshire, TXBuilt 1968 · S/N 15069051 N50090Schumacher Pamela J · Beach City, OHBuilt 1968 · S/N 15069057 N50097N50097 LLC · Tulsa, OKS/N 15069060 N50100Best Bobby R · Goldsboro, NCS/N 15069062 N50106Walker Charles B · Angleton, TXBuilt 1968 · S/N 15069065 N50108Gibbs Robert I · Ravenswood, WVBuilt 1968 · S/N 15069066 N50110Coger Charles E · Huntsville, ARBuilt 1968 · S/N 15069068 N50115Affordable Flight Time LLC · Eagle River, AKS/N 15069072 N50118Carver Alan H · Winder, GAS/N 15069074 N50131Kotval Matthew J · Milaca, MNS/N 15069079

Back to Cessna 150H