Skip to content

Registered aircraft · 303

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 ('2071812')
  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 ('2071812')
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.

N3528JRipplinger Daniel D · Sarona, WIS/N 15061228 N3531JAudi Salim M · Farmers Branch, TXBuilt 1965 · S/N 15061231 N3535JRegistered aircraftBuilt 1965 · S/N 15061235 N3538JConnect With Aviation LLC · Everett, WABuilt 1965 · S/N 15061238 N3539JSainer George F · Fort Worth, TXBuilt 1965 · S/N 15061239 N3543JRegistration Pending · Bridgeport, PARegistration pending, pending cancellationBuilt 1965 · S/N 15061243 N3546JFerguson David G · Candler, NCBuilt 1965 · S/N 15061246 N3550JHanson Parry B · Eagle Creek, ORS/N 15061250 N3551JCox Capital LLC · Rushville, MOS/N 15061251 N3553JLade Burton G · Bemidji, MNBuilt 1965 · S/N 15061253 N3554JEsposito Jason C · Melbourne, FLS/N 15061254 N3555JMason Wiley B · Woodbury, TNFirst renewal noticeBuilt 1965 · S/N 15061255 N3557JHannah Lonnie · Williamson, WVS/N 15061257 N3558JMenke Scot R · Stephenson, MIBuilt 1965 · S/N 15061258 N3561JApostolic Bible Institute Inc · Saint Paul, MNBuilt 1965 · S/N 15061261 N3567JMilne Pamela · Beaverton, ORS/N 15061267 N3568JArmstrong Kevin L · Corvallis, ORBuilt 1965 · S/N 15061268 N3572JUpchurch Air And Sea LLC · Fort Lauderdale, FLBuilt 1965 · S/N 15061272 N3575JSv Aviation LLC · Gilbert, AZBuilt 1965 · S/N 15061275 N3577JArvo Aviation LLC · Newport Beach, CABuilt 1965 · S/N 15061277 N3578JCaswell David B · Owosso, MIBuilt 1965 · S/N 15061278 N3580JJamieson Robert F · Friday Harbor, WABuilt 1965 · S/N 15061280 N3582JMorris Jon · Thatcher, AZBuilt 1965 · S/N 15061282 N3583JVali Air Service LLC · Livingston, MTBuilt 1965 · S/N 15061283 N3587JJacobson Austin G · Los Alamos, NMBuilt 1965 · S/N 15061287 N3590JLutes Robert Trustee · New Paris, INBuilt 1965 · S/N 15061290 N3595JSchroeder Glenda P · Evansville, INBuilt 1965 · S/N 15061295 N3596JOld Trail Inc · Baker City, ORS/N 15061296 N3598JMclaughlin George F · Kennesaw, GABuilt 1965 · S/N 15061298 N3900UHeston Jeffrey W · Warren, OHBuilt 1965 · S/N 15061300 N3904UKunkel Keith R · Bay City, MIS/N 15061304 N3906UBrighton Flying Club LLC · Brighton, MIBuilt 1965 · S/N 15061306 N3907UDenton Brian H · Poughquag, NYBuilt 1965 · S/N 15061307 N3909UGator Aircraft Industries Inc · Winter Springs, FLS/N 15061309 N3911UGolon Anthony S · Rush City, MNBuilt 1965 · S/N 15061311 N3915UPullum Linda A · Goddard, KSBuilt 1965 · S/N 15061315 N3916UGanvini Christian Adrian Roman · Frederick, MDBuilt 1965 · S/N 15061316 N3918USutton Gary K · Rexburg, IDS/N 15061318 N3920UKilmer Robert L · Valentine, NEBuilt 1965 · S/N 15061320 N3924UZepeda Mario · Pomona, CABuilt 1965 · S/N 15061324 N3925USutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 15061325 N3935UNaucler Scott N · Independence, ORBuilt 1965 · S/N 15061335 N3936UChurch Business Ministries · Greer, SCBuilt 1965 · S/N 15061336 N3938UNg Charlie K · Oakley, CABuilt 1965 · S/N 15061338 N3940UPage Jeffrey D · Kansas City, MOBuilt 1965 · S/N 15061340 N3948UHolloway Earnie G · Bonner Springs, KSBuilt 1965 · S/N 15061348 N3954UQuon Nicholas · Fayetteville, GABuilt 1965 · S/N 15061354 N3960UDrebes Jeffrey G · Newalla, OKFirst renewal noticeBuilt 1965 · S/N 15061360 N3961UVisionary Holdings LLC · Missoula, MTBuilt 1965 · S/N 15061361 N3966UFirst Rate Services LLC · Soldotna, AKS/N 15061366

Back to Cessna 150E