Aom Aircraft LLC
Registered aircraft · 20
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 = 'AOM AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'AOM AIRCRAFT 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 = 'AOM AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'AOM AIRCRAFT 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.
N1108FCessna 172G · S/N 17254703N1180BCessna 180 · S/N 30115N1180UCessna 172M · S/N 17266881N133BTConsolidated Vultee/Gunderson BT-13A · S/N 9683N26035Beech H-18 · S/N BA-754N320PCCessna 402B · S/N 402B0621N36LKConsolidated Aeronautics LAKE LA-4-200 · S/N 1041N3PSConsolidated Aeronautics LAKE LA-4-200 · S/N 870N4802KNavion NAVION A · S/N NAV4-1802N4994ZPiper PA-22-108 · S/N 22-8604N5315KRyan NAVION B · S/N NAV-4-2215-BN5415CCessna 170A · S/N 19449N5597CCessna 170A · S/N 19651N5659BCessna 182 · S/N 33659N64161Cessna 172M · S/N 17265055N660SRCessna 177 · S/N 17701151N747CBConsolidated Aeronautics LAKE LA-4-200 · S/N 754N8253HPiper PA-34-200T · S/N 34-8070335N9437UCessna 150M · S/N 15078385N9503UStol UC-1 · S/N 008
Back to Aom Aircraft LLC