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.

N8858SDenney Andrew I IV · Las Cruces, NMFirst renewal noticeBuilt 1965 · S/N 15062158 N8859GBaker Jacob J · Nags Head, NCBuilt 1966 · S/N 15062959 N8860GBlack Spruce Aviation LLC · Hermon, MEBuilt 1966 · S/N 15062960 N8861GMiller Andy D · Marana, AZS/N 15062961 N8861SJump Brian · Watsonville, CAS/N 15062161 N8862SBarber Theodore C Trustee · Spanish Fork, UTS/N 15062162 N8865GChiquiza Gomez Juan Camilo · Fort Pierce, FLS/N 15062965 N8866SZimmer Linda S · Hillsboro, ILBuilt 1965 · S/N 15062166 N8867GDavis Robert M · Liberal, KSBuilt 1966 · S/N 15062967 N8867SCooper-White Michael L · Orrtanna, PABuilt 1965 · S/N 15062167 N8868SMeriwether John N · Prairie Village, KSBuilt 1965 · S/N 15062168 N8871GHukill Warren J · Oakland, CABuilt 1966 · S/N 15062971 N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972 N8872SAeronautical Technical Service Inc · Collierville, TNS/N 15062172 N8873GHarris David J · Aguila, AZBuilt 1966 · S/N 15062973 N8874GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062974 N8882GSchauer Tad J · Lake Park, MNS/N 15062982 N8882SHudson Willis · Hendersonville, NCBuilt 1965 · S/N 15062182 N8883GPalacios David J · Yucca Valley, CABuilt 1966 · S/N 15062983 N8884SMechin Jean-Michel S · Gardiner, NYBuilt 1965 · S/N 15062184 N8885GGurley George R · Caledonia, MSBuilt 1966 · S/N 15062985 N8890SPower Gale W · Girdwood, AKBuilt 1965 · S/N 15062190 N8891GShort James B · Crown Point, INBuilt 1966 · S/N 15062991 N8891SDahlen James T · Chester, MTS/N 15062191 N8892GMcnamee Paul J · Roseville, MNS/N 15062992 N8893GTurner Timothy D · Bonneau, SCBuilt 1966 · S/N 15062993 N8894SArmstrong Richard R · Port Crane, NYBuilt 1965 · S/N 15062194 N8895SSyverson Kylie E · Prescott, WIBuilt 1966 · S/N 15062195 N8896SWombles Earnest · Knoxville, TNBuilt 1965 · S/N 15062196 N8897GShore Gerry · Inez, TXBuilt 1966 · S/N 15062997 N8897STutak Peter B · Indianapolis, INFirst renewal noticeS/N 15062197 N8906SHoskins Brent E · Caldwell, IDBuilt 1965 · S/N 15062206 N8911SPriglmeier Mark L · Deerwood, MNBuilt 1965 · S/N 15062211 N8914SCarroll Louis · Perris, CABuilt 1965 · S/N 15062214 N8920SWefald Richard I · Jordan, MNBuilt 1965 · S/N 15062220 N8923SHuang Chen · Chino Hills, CABuilt 1965 · S/N 15062223 N8926SRichardson Gordon P · Polson, MTBuilt 1965 · S/N 15062226 N8928SFaith Flight LLC · Hopkinsville, KYBuilt 1965 · S/N 15062228 N8933SHempy David B · Lexington, KYBuilt 1965 · S/N 15062233 N8935SRegistration Pending · Mesa, AZRegistration pendingS/N 15062235 N8936SWings Over Texas Holdings LLC · Denton, TXBuilt 1965 · S/N 15062236 N8938SBallou Skies Aviation Inc · Bucyrus, OHBuilt 1965 · S/N 15062238 N8947SMatyas Aviation Inc · Sugarloaf, PABuilt 1965 · S/N 15062247 N8955SHewett Donnie · Little River, SCS/N 15062255 N8957SMiller Andy · Marana, AZBuilt 1965 · S/N 15062257 N8958SLeo Richard E · Malibu, CABuilt 1965 · S/N 15062258 N8961SJoham James R · Kurten, TXBuilt 1965 · S/N 15062261 N8965SKaufman Jayson R · Moundridge, KSBuilt 1965 · S/N 15062265 N8967SDemontgomery Peter J · Fyffe, ALBuilt 1965 · S/N 15062267 N8970SMiller Curtis D · Malabar, FLBuilt 1965 · S/N 15062270

Back to Cessna 150F