Skip to content

Piper PA-18A 150

Registered aircraft · 382

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

N1017SKrl LLC · Longview, TXS/N 18-7038 N102VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5806 N128DVAerial Sign North · Lakewood, NJBuilt 1955 · S/N 18-4366 N1364CRush Christopher C · Anchorage, AKS/N 18-2613 N14313Morford Brian D · Brandon, SDBuilt 1958 · S/N 18-6357 N150EPGedney William · Lake George, NYBuilt 1959 · S/N 18-7087 N150TBStevann Farms Ltd · De Witt, IABuilt 1959 · S/N 18-4303 N157GWFoster Colt D · Eagle River, AKBuilt 1957 · S/N 18-6182 N157SCStone William E · Cusick, WABuilt 1957 · S/N 18-5997 N1672PAkchak Air LLC · Leeds, UTBuilt 1954 · S/N 18-3801 N1757MAdventurous LLC · Hayden, IDBuilt 1957 · S/N 18-6009 N1769PVollendorf William M · Anchorage, AKBuilt 1954 · S/N 18-4107 N184WFSitkiewicz James P · Anchorage, AKBuilt 1959 · S/N 18-6961 N1883PDavis Tom C · Belle Fourche, SDBuilt 1955 · S/N 18-4164 N1886PAlligood Allen K · Wasilla, AKBuilt 1955 · S/N 18-4169 N18UGSale Reported · Wasilla, AKSale reportedBuilt 1958 · S/N 186424 N1932XMarsan William B · Palmer, AKS/N 18-6756 N1937GGriffin Gerald D · Hunt, TXBuilt 1959 · S/N 18-7124 N1951PBeck Aviation LLC · Fort Myers, FLBuilt 1955 · S/N 18-4177 N1954PClark Shawn W · Anchorage, AKBuilt 1955 · S/N 18-4181 N1965PWedell Andrew R · Lumberton, NJBuilt 1955 · S/N 18-4196 N1966PSos David M · Klamath Falls, ORBuilt 1955 · S/N 18-4197 N1974PWarren Josiah E · Sterling, AKBuilt 1955 · S/N 18-4207 N1KZZiesmer Katherine · University Place, WAS/N 18-6440 N1ZAEisaguirre Joseph M · Anchorage, AKBuilt 1959 · S/N 18-7002 N2191JOefelein William A · Wasilla, AKBuilt 1960 · S/N 18-7185 N2356PJohnson Terry M · Wolfforth, TXS/N 18-4242 N2364PDesert Flyers Inc · Mc Neal, AZBuilt 1955 · S/N 18-4251 N2368PAerial Messages Leasing Co · Longwood, FLBuilt 1955 · S/N 18-4257 N237MLN237ml LLC · Glennallen, AKS/N 18-6787 N2414PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4289 N2415PGlahn Guy R · Surprise, AZBuilt 1955 · S/N 18-4290 N2497PWright William B Jr · Deeth, NVBuilt 1955 · S/N 18-4306 N2570PStaneli Lee A · Kiana, AKBuilt 1956 · S/N 18-4310 N2572PRegistration Pending · Roanoke, TXRegistration pendingS/N 18-4312 N2581PWick Melvin D · Palmer, AKBuilt 1955 · S/N 18-4323 N2583PHudzinski Thomas E · Wasilla, AKBuilt 1955 · S/N 18-4325 N2592PRogers Lee B · Anchorage, AKBuilt 1955 · S/N 18-4336 N2664AZmuda Bruce V · Eagle River, AKBuilt 1952 · S/N 18-2179 N2694PEllis Wendell K · Chugiak, AKS/N 18-4382 N2698PMajors Nathaniel Ray · Ball, LAS/N 18-4388 N2771PWeyrauch Paul H · Ray, NDBuilt 1955 · S/N 18-4399 N2773PZerbe Grant N · Frazer, MTBuilt 1955 · S/N 18-4402 N2774PRiver Solutions LLC · Cushing, OKS/N 18-4403 N2775PMccann John P III · Greenville, PABuilt 1955 · S/N 18-4406 N2779PLaabs Donald L · Anchorage, AKBuilt 1955 · S/N 18-4413 N2784PStogner Michael E · Cuber0, NMBuilt 1955 · S/N 18-4418 N280SEKennicott Wilderness Air LLC · Boonton, NJBuilt 1954 · S/N 18-3803 N2868PRedman Adam J · Anchorage, AKS/N 18-4457 N2871PZweifel Douglas L · Anchorage, AKBuilt 1955 · S/N 18-4461

Back to Piper PA-18A 150