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.

N22385Knutson Wayne R · Thompson, NDBuilt 1968 · S/N 15068248 N22401Knotek Larry A · Reno, NVS/N 15068256 N22409Tanner David A · Onalaska, TXBuilt 1968 · S/N 15068262 N22415Viking Wings LLC · Kindred, NDBuilt 1968 · S/N 15068266 N22435Pearson Charles C · Covington, LABuilt 1968 · S/N 15068279 N22436Pecht Scott A · Reedsville, PABuilt 1968 · S/N 15068280 N22439Birginia Aviation LLC · Forest, VAS/N 15068283 N22448Eddy Lisa M · Benton, KSBuilt 1968 · S/N 15068291 N22452Waddy Bertha L · Villa Ridge, ILBuilt 1968 · S/N 15068292 N22462Organ Daniel W · Vernonia, ORBuilt 1968 · S/N 15068298 N22475Ace Aeromotive Inc · Miami, FLBuilt 1968 · S/N 15068306 N22477Ray Erin N · Manor, TXFirst renewal noticeBuilt 1968 · S/N 15068307 N22484Tinoco Joseph I · Shoreline, WABuilt 1968 · S/N 15068310 N22487Skyguard Instruction LLC · Ann Arbor, MIBuilt 1968 · S/N 15068312 N22488Oneal Sean M · Santa Cruz, CABuilt 1968 · S/N 15068313 N22489Sky Walker Flight School LLC · Adrian, MIBuilt 1968 · S/N 15068314 N22491Yasumiishi Joy Marie Trustee · Juneau, AKS/N 15068316 N22498Evans Thomas G · Dawson, ALS/N 15068318 N22499Johnson Dale B · Steele, NDBuilt 1968 · S/N 15068319 N22501Smith Dylan Lane · Oklahoma City, OKBuilt 1968 · S/N 15068321 N22515Wheeler Bret · La Grande, ORBuilt 1968 · S/N 15068329 N22523Beene Donald L · Westfield, INBuilt 1968 · S/N 15068334 N22526Staloff Jason A · Greenfield, MABuilt 1968 · S/N 15068337 N22528Hhd Aviation LLC · Hamilton, OHBuilt 1968 · S/N 15068339 N22529Rhodes Stephen D · Hendersonville, NCS/N 15068340 N22533Regner Mark W · Danbury, CTBuilt 1968 · S/N 15068343 N22536Reep Jennifer B · Stone Mountain, GABuilt 1968 · S/N 15068345 N22537Ernst Albert S III · Buda, TXS/N 15068346 N22540Mcgovern Thomas F · Blue Springs, MOBuilt 1968 · S/N 15068347 N22542Apgyn And Associates Inc · Coral Springs, FLBuilt 1968 · S/N 15068349 N22544N1705r Inc · Cobb, CAS/N 15068351 N22556Rawareo LLC · Warsaw, MOS/N 15068359 N22558Lilik Dennis A · Lewes, DEBuilt 1968 · S/N 15068360 N22561Buckley Holli R · Columbia, MSBuilt 1968 · S/N 15068362 N22563Davis Michael A Jr · Fairbanks, AKBuilt 1968 · S/N 15068364 N22564Darnell Stephen L · Bargersville, INBuilt 1968 · S/N 15068365 N22568Pina Gabriel B · Pasadena, CABuilt 1968 · S/N 15068368 N22570Nebbia Valter Della · Archer City, TXBuilt 1968 · S/N 15068369 N22582Lee Scott M · Noble, OKBuilt 1968 · S/N 15068376 N22583Christensen Marc G · Bountiful, UTBuilt 1968 · S/N 15068377 N22584Manning Christopher S · Dawson, GABuilt 1968 · S/N 15068378 N22585Obregon Aviation LLC · San Francisco, CABuilt 1968 · S/N 15068379 N22586Weyker William J · Rhinelander, WIBuilt 1968 · S/N 15068380 N22589Robles Lazaro R · Golden Valley, MNBuilt 1968 · S/N 15068383 N22590Sorensen Dale · Wellsville, UTS/N 15068384 N22594Morton Eric C · Anchorage, AKBuilt 1968 · S/N 15068388 N22595Johnson Leif M · Midlothian, TXFirst renewal noticeBuilt 1968 · S/N 15068389 N22596Anderson Bradley P · Rapid City, SDBuilt 1968 · S/N 15068390 N22597Mcmanus Charles D · Cottageville, SCBuilt 1968 · S/N 15068391 N22602Williamson Mark T · Crescent City, CAS/N 15068396

Back to Cessna 150H