Registered aircraft · 19

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'IN' AND g.registrant_city = 'PENDLETON' ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'IN' AND g.registrant_city = 'PENDLETON'
  ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'IN' AND g.registrant_city = 'PENDLETON'
ORDER BY g.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.

N10ERRichter Emil William JUNIOR ACE E · S/N EWR1Built 1980 · Stephenson David A N16059Wright Hanna ACE · S/N 1962Built 2000 · Hanna Mark W II N170JCessna 170 · S/N 18471Built 1948 · Givens Steve W N201AJMooney M20J · S/N 24-0384Built 1977 · Indy Aero Group LLC N24859Moore Jeffrey B HTZ BI-PL LB-1 · S/N 248Built 2000 · Moore Jeffrey B N3063QAero Commander S2R · S/N 1560RBuilt 1971 · Precision Ag Air LLC N371KMDJI AGRAS T40 · S/N 1581F574B234U00100QQModern Ag Solutions LLC N371NADJI AGRAS T40 · S/N 1581F574B235B001034BModern Ag Solutions LLC N3969KPiper PA-28-140 · S/N 28-23853Grollimund David J N3GVVan Ortwick SUPER ACRO SPORT · S/N 823Built 1980 · Long Michael L N401TCCastellano Anthony J RV-6 · S/N 20279Precision Ag Air LLC N4020NStarbuck James E CH 701 · S/N 1Built 2001 · Blake Michael W N4971XRockwell International S-2R · S/N 5016RBuilt 1976 · Precision Ag Air LLC N510SSAero Commander S2R · S/N 1635RBuilt 1972 · Precision Ag Air LLC N5449Grumman Acft ENG Cor-Schweizer G-164A · S/N 1159Built 1973 · Precision Ag Air LLC N7605FCessna 172N · S/N 17273263Built 1979 · Promise Road Aviation Inc N899PPavliga Frank M HATZ CB-1 · S/N 313Built 1989 · Givens Steve N89SCMitsubishi MU-2B-60 · S/N 1516 S.A.Built 1981 · Kcb Air LLC N9278ACessna 170A · S/N 19371Built 1950 · Hanna Mark W II

Back to Pendleton, IN