# Registered aircraft: Ideal Aerosmith TROUBLEMAKER

A list on [Ideal Aerosmith TROUBLEMAKER](https://openairdocs.org/model/ideal-aerosmith-troublemaker.md).

Aircraft of this model in the FAA registry, by N-number.

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

## The whole list in SQL

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

```sql
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 ('06102LU')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/ideal-aerosmith-troublemaker/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.