Aerosim Academy Inc
Registered aircraft · 45
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 = 'AEROSIM ACADEMY INC' OR list_contains(g.other_registrant_names, 'AEROSIM ACADEMY INC') 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 = 'AEROSIM ACADEMY INC' OR list_contains(g.other_registrant_names, 'AEROSIM ACADEMY INC') 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.
N1154WCessna 172S · S/N 172S10608N1688CCessna 172S · S/N 172S10612N1735XCessna 172S · S/N 172S10648N470DACirrus Design SR20 · S/N 1786N471DACirrus Design SR20 · S/N 1787N473DACirrus Design SR20 · S/N 1798N474DACirrus Design SR20 · S/N 1799N475DACirrus Design SR20 · S/N 1800N476DACirrus Design SR20 · S/N 1818N477DACirrus Design SR20 · S/N 1819N478DACirrus Design SR20 · S/N 1820N479DACirrus Design SR20 · S/N 1821N480DACirrus Design SR20 · S/N 1822N481DACirrus Design SR20 · S/N 1823N487DACirrus Design SR20 · S/N 1832N488DACirrus Design SR20 · S/N 1833N489DACirrus Design SR20 · S/N 1835N490DACirrus Design SR20 · S/N 1836N491DACirrus Design SR20 · S/N 1837N492DACirrus Design SR20 · S/N 1838N494DACirrus Design SR20 · S/N 1840N496DACirrus Design SR20 · S/N 1842N513NDCessna 172S · S/N 172S10764N514NDCessna 172S · S/N 172S10765N525NDCessna 172S · S/N 172S10817N528NDCessna 172S · S/N 172S10825N530NDCessna 172S · S/N 172S10829N538NDCessna 172S · S/N 172S10832N539NDCessna 172S · S/N 172S10850N540NDCessna 172S · S/N 172S10984N548NDCessna 172S · S/N 172S11050N55285Cessna 172S · S/N 172S11511N55292Cessna 172S · S/N 172S11515N5529ZCessna 172S · S/N 172S11514N557NDCessna 172S · S/N 172S10983N563NDCessna 172S · S/N 172S10788N565NDCessna 172S · S/N 172S10797N568NDCessna 172S · S/N 172S10806N570NDCessna 172S · S/N 172S10847N572NDCessna 172S · S/N 172S10940N576NDCessna 172S · S/N 172S10962N609DACirrus Design SR20 · S/N 1844N611DACirrus Design SR20 · S/N 1848N613DACirrus Design SR20 · S/N 1851N62690Cessna 172P · S/N 17275326
Back to Aerosim Academy Inc