Skip to content

Cameron Balloons US V-77

Registered aircraft · 49

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

N1608WWood Michael J · Edmonds, WABuilt 1994 · S/N 5940 N1990KHerbst John H · Lexington, KYBuilt 1987 · S/N 5267 N1991GEakin Sean T · Placitas, NMS/N 5272 N1991TRoss David H · Kansasville, WIBuilt 1987 · S/N 5278 N20408Clark Joseph L · Ravenna, OHS/N 5395 N2043WSchendel Robert T · Overland Park, KSBuilt 1988 · S/N 5399 N2968YNead Mark · Las Vegas, NVBuilt 1986 · S/N 5170 N2977XConrad Kenneth J · Albuquerque, NMBuilt 1986 · S/N 5167 N2990WIbbotson Mark D · Grand Prairie, TXBuilt 1986 · S/N 5214 N2992LBalloon Adventures New Bedford Inc · South Dartmouth, MABuilt 1986 · S/N 5223 N3030RKiehle Erik A · Meridian, MSS/N 6039 N3982LBalloon Quest Inc · Fenton, MIBuilt 1991 · S/N 5664 N3987BBildner James L · Manchester By Sea, MABuilt 1991 · S/N 5674 N4005AAll American Enterprises Inc · Albuquerque, NMBuilt 2006 · S/N 6465 N41034Konstanzer Janine S · Aurora, MOBuilt 1997 · S/N 6106 N4123BRistenbatt Philip A · Ann Arbor, MIS/N 6067 N41269Gerwig Garrett W · Ashland, OHBuilt 1991 · S/N 5732 N4145QBlair Frank L · Fenton, MOBuilt 1991 · S/N 5743 N4150QLaughlin Chad R · Clyde, OHBuilt 1991 · S/N 5747 N4457WTheriot Tyler S · Prairieville, LABuilt 2000 · S/N 6242 N4458BHendricks Ryan · Albuquerque, NMBuilt 1998 · S/N 6200 N45109Keller Clifford G · Santa Cruz, NMBuilt 1994 · S/N 5882 N45251White Bernard C · Jackson, MIBuilt 1994 · S/N 5893 N45441Wildtiger Aerosports LLC · Topeka, KSS/N 5904 N45590Mains Andrew C · Bondurant, IABuilt 1994 · S/N 5894 N5817XSmith Gregory A · Lewistown, MTS/N 5026 N6028LTowle Bruce A · Troy, MEBuilt 1989 · S/N 5477 N6028WStandefer Wayne B · Italy, TXBuilt 1988 · S/N 5478 N60324Knepper Candy S · Alcoa, TNS/N 5479 N60438Glen William S · Maricopa, AZBuilt 1988 · S/N 5494 N6052MLester-Ross Kathleen A · Kansasville, WIBuilt 1989 · S/N 5499 N60700Bubbles On Ash LLC · Tempe, AZS/N 5509 N6079GCarter-Osborne Sandra K · Phoenix, AZBuilt 1989 · S/N 5512 N6081TPiles Dianna Davis · Nogales, AZBuilt 1989 · S/N 5514 N6093NOhare Thomas J · Southington, CTS/N 5519 N6093QGallegos Frank L · Los Lunas, NMBuilt 1989 · S/N 5520 N61007Skach Bruce · Wichita, KSBuilt 1989 · S/N 5522 N6117UKeller Clifford G · Santa Cruz, NMBuilt 1989 · S/N 5541 N74008Sale Reported · Broomfield, COSale reportedS/N 5104 N75065Carrasco Gregory A · Santa Fe, NMBuilt 1992 · S/N 5806 N7506HAz Air Ventures LLC · Safford, AZBuilt 1992 · S/N 5798 N75245Henton Val W · Dodge City, KSBuilt 1993 · S/N 5837 N79SJLangjahr Jenet A · Lancaster, CAS/N 6587 N80398Campbell Doug · Pahrump, NVS/N 6295 N906CBMountain Butterfly LLC · Stevensville, MTS/N 942 N9502ZSidlinger Computer Corp · Flagstaff, AZS/N 5655 N9520TNakamura Judith K · Placitas, NMBuilt 1989 · S/N 5604 N9541UMueller James J · Washington, DCBuilt 1990 · S/N 5566 N9547GMorning Star Visions Inc · Smoketown, PABuilt 1990 · S/N 5577

Back to Cameron Balloons US V-77