OpenAirDocs.org
Melba, ID

Registered aircraft · 52

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

Query with SQL
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 = 'MELBA'
  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.

N108MHHarmel Michael B AVID MAGNUM · S/N 108MBuilt 1999 · Harmel Michael BN11YCPiper PA-18-150 · S/N 18-7988Built 1963 · Dompe Thomas WN1215PPiper PA-23 · S/N 23-234Built 1955 · Tucker Robert BN160TDPowrachute PC 2000 · S/N A-167POWBuilt 2001 · Driscoll TomN1625PPiper PA-22-150 · S/N 22-2439Built 1954 · Gauthier Robert JonesN178BCAmerican Champion 8GCBC · S/N 474-2005Built 2005 · Allen Lisa MN2095RCessna 182G · S/N 18255295Tyson John HN211RAHatfield Rollin A GLASTAR GS1 · S/N 5292Built 1999 · Tucker Robert BN221MHVans Acft/Harmel Michael B RV6-A · S/N 60595Built 2004 · Harmel Michael BN225TDRockwell International 690C · S/N 11635Built 1980 · Cat Air LLCN231PMAmerican Champion 8GCBC · S/N 541-2011Bernard Raymond CN256DPiper PA-12 · S/N 12-2903Built 1947 · Nau Howard AN3118DCessna 180 · S/N 31916Built 1955 · Nau Howard AN384UCDJI AGRAS T50 · S/N 1581F6BUB248U001J1QCChristensen MattN4086MPiper PA-12 · S/N 12-2969Built 1947 · Budak MarkN41714Piper PA-28-151 · S/N 28-7415316Nunn Ethan EdwinN4184YBellanca 7KCAB · S/N 600-77Moncrief Rick LN424KCMooney M20E · S/N 498Built 1964 · Coontz James KN4253EAeronca 11CC · S/N 11CC-136Built 1947 · Price James AN426WDWhitson Donald RIDGE RUNNER III · S/N 0206020004111Built 2012 · Budak Mark EN455VHamilton Gary E RANS S-21 · S/N 09210250Hamilton Gary EN460BDDriscoll Thomas RV-14A · S/N 141048Built 2025 · Driscoll ThomasN4642TPiper PA-11 · S/N 11-1438Built 1947 · Dickman Edward AN4869KRyan NAVION · S/N NAV-4-1869Built 1949 · Tucker Robert BN4YZCessna U206G · S/N U20603702Built 1977 · Lackerdas HarryN51473Maule M-5-210C · S/N 6011CBuilt 1974 · Miley Gregg EN5615BKolb FIRESTAR · S/N 254Built 1996 · Jones-Gauthier RobertN563DEECK Richard L RV7A · S/N 72326Built 2011 · Gordon DonN57JPPrice James Albert LONG EZ · S/N 1023Built 1994 · Price James AN583C2ND Story Flying Club THORP T-18 · S/N 583Built 1983 · Huber James MN59TDDavison Terry W RV-7A · S/N 72688Built 2010 · Davison Terry WN6061ACessna 172 · S/N 28661Built 1956 · Dickman Edward AN643PMAllmann Gregory C GLASTAR · S/N 5333Built 2002 · Burkett Steven IN7112VMary Elizabeth Slevin GLASAIR SPORTSMAN 2+ · S/N 7415Built 2020 · Miley Gregg EN7244QCessna 172L · S/N 17260544Buckley Gregory LN7419RPiper PA-28-140 · S/N 28-21944Built 1966 · Diorio Christopher JN7461XCessna 172B · S/N 17247961Built 1960 · Isert BrianN750CVJames Huber STOL CH750 · S/N 75-10342Built 2024 · Huber James MN7538UCessna 150M · S/N 15077734Built 1975 · Hooper Lawrence SN788JBBrian L Isert VANS AIRCRAFT RV-10 · S/N 40335Built 2018 · Isert Brian LN823SWWhite Steven G VANS ACFT RV6A · S/N 24000Built 2000 · Miley Gregg EN828APiper PA-22 · S/N 22-130Built 1951 · Yoder StephenN834AMAviat A-1B · S/N 2434Built 2007 · Nicholson ScottN8502NPiper PA-32-300 · S/N 32-7140052Built 1971 · Dickman Edward AN85634Aeronca 7BCM · S/N 7AC-4378Built 1946 · Wynia Steven PN87TJHall Kenneth J KITFOX 532 · S/N 158Built 1988 · Gordon Donald WN8843JPiper PA-28-180 · S/N 28-2801Diorio Christopher JN8MXCessna T210M · S/N 21062687Moncrief Rick LN931RGGladish Richard O RV-6A · S/N 21002Built 1995 · Scates Gregory BN97781Stinson 108-1 · S/N 108-781Built 1946 · Brinker Michael W
Back to Melba, ID