August Aero LLC
Registered aircraft · 36
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
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_name = 'AUGUST AERO LLC' OR list_contains(g.other_registrant_names, 'AUGUST AERO LLC') 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_name = 'AUGUST AERO LLC' OR list_contains(g.other_registrant_names, 'AUGUST AERO LLC') 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.
N114VVWinfield Orville R VARIVIGGEN · S/N 114N133SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1285N14BGGarrett PITTS S1C · S/N 1N1582ZBeech P35 · S/N D-6880N191CGGruby-Charles SPEZIO DAL-1 · S/N 191N230RSSieck Ronald E HATZ CLASSIC · S/N 023N256GDDeneal Daniel W VANS RV6A · S/N 23639N29ESSchweizer SGS 1-26C · S/N 318N3892Starduster SA-300 · S/N 365N38972Piper PA-28-161 · S/N 28-7716304N3938WPiper PA-32-260 · S/N 32-887N40TLDooley Joseph D G MEYERS LITTLE TOOT · S/N D-2N440RRRyan Aeronautical ST3KR · S/N 2058N458KBeech 58 · S/N TH-452N49086Ryan Aeronautical PT-22 · S/N 1541N55ATRoutt SEMINOLE RS-1 · S/N 001N57015Ryan Aeronautical ST3KR · S/N 2042N57662Bellanca 7GCBC · S/N 625-74N62103Carlson Rolland Boyd SOPWITH CAMEL F-1 · S/N 001N634RSWallace Hale KNIGHT TWISTER · S/N 001N6351Coughlin P Richard SE-5 · S/N 002N6388NChampion 7GCAA · S/N 165N6588RBeech B24R · S/N MC-251N680PJSenior Aero Sport D-260 · S/N 10N72826Cessna 140 · S/N 10012N748JSSmith Donald Joe JR SMITH SPECIAL SKYBOL · S/N DJS001N75939Boeing B75N1 · S/N 75-1266N780SRRyan Aeronautical ST3KR · S/N 2007N79MLCarter J Everice BUSHBY MUSTANG II · S/N 212-79N7XDDrzymala Peter S RV-4 · S/N 2026PDN82DCCox-Donald STEEN SKYBOLT · S/N 001N84RMMashburn Ron RV-4 · S/N 115N8648GCessna 150G · S/N 15066728N9129SChampion 7GCB · S/N 7GCB-36N9659ABoessenkool-Helmich BAKENG DUCE · S/N 1006N9911Experimental NEYS D260 · S/N 522
Back to August Aero LLC