Registered aircraft · 26

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 = 'PARMA' 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 = 'PARMA'
  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 = 'PARMA'
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.

N1132BSilvaire LUSCOMBE 8A · S/N 5759Built 1947 · Hager Bill E N158QCoates Ray Dean QUICKIE · S/N 158BHager Bill N20TZDusseau Richard F KITFOX SER 5 SAFARI · S/N S96080188Jantzi Katrina N342THBeech T-34C-1 · S/N GM-87Built 1981 · Hill Thomas D N3619CCessna 180 · S/N 31117Built 1954 · Hamby Michael R N3734VCessna 150M · S/N 15076606Burrell Dennis E N3932DDressen Donald L ESCAPE LS · S/N 01Built 2012 · Nelson Christopher H N4017YCessna 185 · S/N 185-0217Built 1961 · 17y LLC N429STJim L Tracy RV-8 · S/N 83064Built 2015 · Tracy Jim L N47TLCessna A185F · S/N 18503185Built 1976 · Obendorf Phillip G N52367Ray E Roberts KITFOX V VIXEN · S/N V9404-0008Jantzi Reuben B N53709Taylorcraft DCO-65 · S/N L-5941Built 1944 · Hill Thomas D N6433ECessna 172 · S/N 46533Built 1959 · Morgan Peter F N675MAPiper PA46-500TP · S/N 4697367Built 2008 · Owyhee Produce LLC N73197Cessna 172M · S/N 17267324Built 1976 · Seward Kent N74JFFreeburg John D SMITH MINIPLANE · S/N 007Built 2020 · Hager Bill E N79589Cessna 182P · S/N 18261838Built 1973 · Aqua Irrigation Technologies LLC N817STColumbia Aircraft Mfg LC41-550FG · S/N 41724Built 2007 · Taberna John P N8279ACessna 170B · S/N 25131Built 1952 · Hadley Harold C N837THTop Hatz HATZ CB-1 · S/N 873Built 2007 · Hager Bill N854NPTyhurst Christian E SONEX · S/N 001Built 2007 · Tyhurst Christian E N8605DPiper PA-22-160 · S/N 22-5803Built 1957 · Troxel Robert G N882THThomas D Hill RV-8 · S/N 83123Hill Thomas D N9405CCessna 180 · S/N 31803Built 1955 · Ramsower Charles M N99577Engineering & Research ERCOUPE 415-C · S/N 2200Built 1946 · Alfred E Mcmillin N999RPPeck Robert A SONERAI II · S/N 151Jantzi Isaac J

Back to Parma, ID