# Registered aircraft: Ideal Aerosmith Inc

A list on [Ideal Aerosmith Inc](https://openairdocs.org/faa-owner/IDEAL%20AEROSMITH%20INC.md).

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

- [N292TM](https://openairdocs.org/aircraft/N292TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A30F0F4C6FE · Grand Forks, ND
- [N293TM](https://openairdocs.org/aircraft/N293TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A30C108E083 · Grand Forks, ND
- [N294TM](https://openairdocs.org/aircraft/N294TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A30B671A223 · Grand Forks, ND
- [N295TM](https://openairdocs.org/aircraft/N295TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A308D26C6B3 · Grand Forks, ND
- [N296TM](https://openairdocs.org/aircraft/N296TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A305CFAF857 · Grand Forks, ND
- [N297TM](https://openairdocs.org/aircraft/N297TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A3087BD9CCE · Grand Forks, ND
- [N298TM](https://openairdocs.org/aircraft/N298TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A30D5A1182A · Grand Forks, ND
- [N630TM](https://openairdocs.org/aircraft/N630TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A3079A7785F · Grand Forks, ND
- [N631TM](https://openairdocs.org/aircraft/N631TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A30E1D57062 · Grand Forks, ND
- [N632TM](https://openairdocs.org/aircraft/N632TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A3030B4BD4B · Grand Forks, ND
- [N633TM](https://openairdocs.org/aircraft/N633TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A30EA6197A5 · Grand Forks, ND
- [N634TM](https://openairdocs.org/aircraft/N634TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A300FA1082C · Grand Forks, ND
- [N635TM](https://openairdocs.org/aircraft/N635TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A3049C47753 · Grand Forks, ND
- [N636TM](https://openairdocs.org/aircraft/N636TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A300BC9659C · Grand Forks, ND
- [N637TM](https://openairdocs.org/aircraft/N637TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A30EFE048A7 · Grand Forks, ND
- [N638TM](https://openairdocs.org/aircraft/N638TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A3051433987 · Grand Forks, ND
- [N639TM](https://openairdocs.org/aircraft/N639TM.md): Ideal Aerosmith TROUBLEMAKER · S/N 1596A30F49AA4D5 · Grand Forks, ND

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 'IDEAL AEROSMITH INC' OR list_contains(g.other_registrant_names, 'IDEAL AEROSMITH INC')
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-owner/IDEAL%20AEROSMITH%20INC/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.