Skip to content

Piper PA-18-135

Registered aircraft · 220

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

N1012ASimmons Michael T · Carolina Beach, NCBuilt 1950 · S/N 18-588 N10404Powers Phillp K · Tallulah, LAS/N 18-3561 N1043KShadowens Jackie R · Sapulpa, OKBuilt 1954 · S/N 18-3919 N1047VPoulter Thomas R · Chelsea, MIBuilt 1954 · S/N 18-3911 N1078AHall Alan R · Enumclaw, WABuilt 1957 · S/N 18-662 N1113CBrown Daniel A · Gettysburg, PABuilt 1953 · S/N 18-2199 N1117CWommack Leland E · Lone Star, TXBuilt 1953 · S/N 18-2204 N111DBRaven Aviation LLC · Lewistown, MTBuilt 1953 · S/N 18-3682 N1124Bollinger Karen S · Fairbanks, AKBuilt 1955 · S/N 18-3985 N1129Houghton John D · Palmer, AKBuilt 1954 · S/N 18-4022 N1130Kennedy William · Sheffield, TXBuilt 1954 · S/N 18-3510 N1133Cub N1133 LLC · Logan, UTBuilt 1954 · S/N 18-3558 N1136Ekstrom Eric S · Eagle River, AKS/N 18-4041 N1161ALindemann Robin · Anchorage, AKS/N 18-2691 N1181YMeehleis Mark G · Anchorage, AKBuilt 1952 · S/N 18-2144 N1184CGanim Rose · Haydenville, MABuilt 1953 · S/N 18-2467 N118SMMars Samuel C · Madison, MSS/N 18-2175 N1197CHitch Dixon S · Malta, MTBuilt 1953 · S/N 18-2480 N1198Davis Barry E · Carrollton, GABuilt 1953 · S/N 18-3334 N120KHPackard Randall C · Anchorage, AKS/N 18-3511 N1246Lablanc Michael T · Intl Falls, MNBuilt 1954 · S/N 18-3347 N1258CSmith Samuel Richard · Seward, AKBuilt 1953 · S/N 18-2497 N1354CAklested William T · Palmer, AKS/N 18-2518 N135KSBunde Konstantine E · Goldendale, WABuilt 1956 · S/N 18-4061 N135WMTownsend Richard A · Wasilla, AKBuilt 1954 · S/N 18-3599 N1365CSchultz Kenneth W · Ekalaka, MTBuilt 1953 · S/N 18-2536 N1366CKuzina Ronald E · Wasilla, AKBuilt 1953 · S/N 18-2616 N1367CFerguson Bruce W · Fort Peck, MTBuilt 1953 · S/N 18-2626 N1387GList Martinus R · Wasilla, AKS/N 18-3521 N1394RRoss Bill · Meridian, MSBuilt 1952 · S/N 18-1983 N1394YOjendyk Mark R · Newcastle, WABuilt 1953 · S/N 18-3357 N1458CKohlhase Kent E · Anchorage, AKBuilt 1953 · S/N 18-2657 N145CSchmitt Mark R · Rockford, MIBuilt 1954 · S/N 18-3335 N1466CBent James L Jr DBA · Palatine Bridge, NYS/N 18-2668 N1467CWeflen Arvid W · Fairbanks, AKBuilt 1953 · S/N 18-2682 N1476CAsher Debra L · Wasilla, AKBuilt 1953 · S/N 18-2681 N1554PPerkins Michael D Trustee · Bigfork, MTBuilt 1954 · S/N 18-3709 N15558Nighthawk Air Systems Inc · Marion, TXS/N 18-3876 N1557PVlasic Steven Robert · Homer, AKBuilt 1954 · S/N 18-3711 N1559PSnatchaday LLC · Carabaset Vly, MEBuilt 1954 · S/N 18-3716 N1565PPott David F · Fairbanks, AKBuilt 1954 · S/N 18-3726 N1580PBltyhe Anne T · Paso Robles, CAS/N 183743 N1590PForgey Carl · Petersburg, AKBuilt 1954 · S/N 18-3755 N1592PFerguson Robert C · Cornelia, GABuilt 1954 · S/N 18-3757 N1596PPassmore Aviation LLC · Claremore, OKS/N 18-3761 N1597PStokes Letta J · Chugiak, AKBuilt 1954 · S/N 18-3762 N1651PCaron Ty · Redmond, ORBuilt 1954 · S/N 18-3766 N1857PJanvrin Jerry M · Buffalo, SDBuilt 1955 · S/N 18-4124 N18SNSmiley Stephen P · Canandaigua, NYBuilt 1955 · S/N 18-3966 N18YHBaker Property Management · Indian Valley, IDS/N 7585

Back to Piper PA-18-135