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.

N3588LVandegrift David H · St Paul, MNBuilt 1965 · S/N 15062388 N3589LSale Reported · Bloomburg, TXSale reportedBuilt 1965 · S/N 15062389 N3598LBryan Aviation LLC · Peoria, AZBuilt 1965 · S/N 15062398 N35RJEarles Kenneth D · Crowley, LABuilt 1966 · S/N 15062932 N3652SBennett Quinn S · Sterling, AKS/N 15062745 N3711SWittco Aero LLC · Vancouver, WAS/N 15062988 N373KVCrystalinas Johnathan · Rancho Cordova, CABuilt 1966 · S/N 15064401 N378VUDennis Ryan B · Delphi, INS/N 15063713 N37MMLeitch Mark W · Naples, FLBuilt 1966 · S/N 15062913 N4103A501st Flight Solutions LLC · Kaysville, UTBuilt 1966 · S/N 15063859 N426XARound Engine Aero · Nashville, MIS/N 15063198 N4411Mh Aviation LLC · Dublin, CABuilt 1965 · S/N 15062560 N488EMBishop Patrick M · Reading, MABuilt 1965 · S/N 15062018 N48FACavu Pilot LLC · Powell, TNBuilt 1965 · S/N 15061895 N519Malaska Jacob L · Orefield, PABuilt 1966 · S/N 15064303 N522DRIbrahim Tarek M · Lawrenceville, VABuilt 1966 · S/N 15063327 N525SHMcn Systems LLC · Mount Airy, MDBuilt 1965 · S/N 15062549 N5517Hendricks William · Redondo Beach, CABuilt 1965 · S/N 15062568 N571VHVan Hoy Jeffrey D · Knightstown, INBuilt 1965 · S/N 15062392 N61286Houseman Jeffery D · Millersville, MOBuilt 1966 · S/N 15063430 N6234RFly Big Sky LLC · Missoula, MTS/N 15061534 N6237RBorden Jonathan Wilfred · Londonderry, NHS/N 15061537 N6238RRegistration Pending · Preston, IDRegistration pendingBuilt 1965 · S/N 15061538 N6239RBala Engineering Pllc · Hawkins, TXBuilt 1965 · S/N 15061539 N6241RHayhurst Shane R · Winfield, PABuilt 1965 · S/N 15061541 N6244RWright Skye R · Quitman, ARBuilt 1965 · S/N 15061544 N6246RLovelace Nicolas J · Panama City, FLS/N 15061546 N6249RChambers Steve · Elk City, OKBuilt 1965 · S/N 15061549 N6250RJennings Frederick T · Friona, TXBuilt 1965 · S/N 15061550 N6258RCache River Flyers LLC · Greeley, COS/N 15061558 N6260RNichols Rylan A · Frazer, MTBuilt 1965 · S/N 15061560 N6264RCencal Flyers LLC · Turlock, CABuilt 1965 · S/N 15061564 N6283RAkchak Air LLC · Leeds, UTBuilt 1965 · S/N 15061583 N6297RBejna Robert C · Addison, ILBuilt 1965 · S/N 15061597 N62983Studer Rodney J · Shelby, MIS/N 15063618 N6299RNorwood Dan L · Chippewa Falls, WIBuilt 1965 · S/N 15061599 N631EHHuddleston Edward L · Oaktown, INBuilt 1966 · S/N 15063361 N6400FAirplanes Unlimited LLC · Jackson, TNBuilt 1966 · S/N 15063000 N6401FPfd Aviation LLC · Sheridan, WYBuilt 1966 · S/N 15063001 N6402FMaier Andrew J · Barnesville, MNBuilt 1965 · S/N 15063002 N6403FFertile Flying Club Inc · Fertile, MNBuilt 1966 · S/N 15063003 N6409FStatusair LLC · Mount Arlington, NJBuilt 1966 · S/N 15063009 N6413FRouse Jeffrey S · Cumming, GABuilt 1966 · S/N 15063013 N6414FMessing Jeffrey B · Ruth, MIBuilt 1966 · S/N 15063014 N6417FAdkins Ian B · Dahlonega, GABuilt 1966 · S/N 15063017 N6420FWilson Christopher Derrick · Ovilla, TXBuilt 1966 · S/N 15063020 N6421FBixby Paul A · Vale, ORBuilt 1966 · S/N 15063021 N6422FClark James H · Pittsfield, MABuilt 1966 · S/N 15063022 N6437FWilliams Michael A · Hartsville, INBuilt 1966 · S/N 15063037 N6445FWalk Mason · Maryville, MOBuilt 1966 · S/N 15063045

Back to Cessna 150F