Registered aircraft · 25

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

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 = 'ID' AND g.registrant_city = 'GREENLEAF' 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 = 'ID' AND g.registrant_city = 'GREENLEAF'
  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 = 'ID' AND g.registrant_city = 'GREENLEAF'
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.

N1298ZBeech N35 · S/N D-6738Built 1961 · Shaw Aviation LLC N1385ZBeech B95A · S/N TD-486Built 1961 · Wilson Tommy V N13JHAmerican Champion 8GCBC · S/N 617-2021Built 2021 · L J H Consulting LLC N13MKBeech D55 · S/N TE-515Built 1968 · Ljh Consulting Services LLC N1701KJoseph Gallagher KITFOX 7SS · S/N KA18153371Built 2020 · Gallagher Joseph S N2300LBeech 23 · S/N M-112Built 1962 · Av8n Idaho LLC N267PDBeech 95-C55 · S/N TE-284Built 1967 · White Hat Repair LLC N2708RDJI AGRAS T30 · S/N 527BK8C00100ENHigher Views LLC N2947PPiper PA-22-150 · S/N 22-3219Built 1955 · White Hat Repair LLC N3142CCessna 180 · S/N 30941Built 1954 · Itm Electronics Inc N3281HErcoupe 415-D · S/N 3906Jardine Brian E N3622TBeech 58 · S/N TH-479Built 1974 · Shaw Aviation LLC N417BRosenkranz Herbert Bix SERIES 5-KITFOX · S/N S9404-0017Built 1999 · Rosenkranz Herbert B N506ALVans RV-12 · S/N 120521Built 2023 · Culver Edward A N53953Fairchild M-62A · S/N T41-1342Built 1942 · Wilson Tommy N5572BCessna 182 · S/N 33572Built 1956 · Orcutt David R N61GJMitsubishi MU-2B-40 · S/N 398SAArrow Air Services LLC N623WDEavision EA-J150 · S/N JMZKJ150UAV60259388Higher Views LLC N62AXSturgis Robert COMPAIR 7 · S/N 99-7224Arrow Air Services LLC N66KSFoxair KITFOX S7 SPEEDSTER · S/N KA21344528Built 2024 · Mcbean John N6761RCessna T210F · S/N T210-0161Built 1966 · Perini Mark J N70826Cessna 182M · S/N 18259380Built 1968 · Chabay Shawna P N93949Ercoupe 415-D · S/N 1272Built 1946 · Jardine Brian E N9497GDJI AGRAS T30 · S/N 3U4DKDR0011Q80Higher Views LLC N95246Taylorcraft BC12-D · S/N 9646Jardine Brian E

Back to Greenleaf, ID