# Registered aircraft: AD 2023-22-06

A list on [AD 2023-22-06](https://openairdocs.org/ad/2023-22-06.md).

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

- [N117TG](https://openairdocs.org/aircraft/N117TG.md): International Air Response Inc · Coolidge, AZ · Built 1954 · S/N 54-1631
- [N118TG](https://openairdocs.org/aircraft/N118TG.md): International Air Response Inc · Coolidge, AZ · Built 1957 · S/N 57-0512
- [N120TG](https://openairdocs.org/aircraft/N120TG.md): International Air Response Inc · Coolidge, AZ · Built 1955 · S/N 3035
- [N121TG](https://openairdocs.org/aircraft/N121TG.md): International Air Response · Coolidge, AZ · Built 1956 · S/N 56-0511
- [N130CG](https://openairdocs.org/aircraft/N130CG.md): Coulson Aviation USA Inc · Portland, OR · Built 1969 · S/N 382-4339
- [N131EC](https://openairdocs.org/aircraft/N131EC.md): Pacific Aircraft Services LLC · Saint Helens, OR · S/N 3212
- [N132CG](https://openairdocs.org/aircraft/N132CG.md): Csc Delaware Trust Co Trustee · Wilmington, DE · Built 1968 · S/N 382-4338
- [N133FF](https://openairdocs.org/aircraft/N133FF.md): B&G Industries LLC · Greybull, WY · S/N 56-535
- [N136CG](https://openairdocs.org/aircraft/N136CG.md): Csc Delaware Trust Co Trustee · Wilmington, DE · Built 1969 · S/N 382-4334
- [N140CG](https://openairdocs.org/aircraft/N140CG.md): Csc Delaware Trust Co Trustee · Wilmington, DE · Built 1969 · S/N 382-4337
- [N234HG](https://openairdocs.org/aircraft/N234HG.md): Aviation & Defense Inc · Calabasas, CA · S/N 382-4211
- [N382CG](https://openairdocs.org/aircraft/N382CG.md): Csc Delaware Trust Co Trustee · Wilmington, DE · Built 1969 · S/N 382-4336
- [N382HT](https://openairdocs.org/aircraft/N382HT.md): Cardinal Services Corp · Kalispell, MT · S/N 5032
- [N404LC](https://openairdocs.org/aircraft/N404LC.md): Airplane Sales International Corp · Sherman Oaks, CA · Built 1977 · S/N 4763
- [N4053L](https://openairdocs.org/aircraft/N4053L.md): Coulson Aviation (USA) Inc · Portland, OR · S/N 382-4053
- [N4054](https://openairdocs.org/aircraft/N4054.md): Coulson Aviation (USA) Inc · Portland, OR · S/N 382-4054
- [N405LC](https://openairdocs.org/aircraft/N405LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1985 · S/N 5025
- [N407LC](https://openairdocs.org/aircraft/N407LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1991 · S/N 5225
- [N408LC](https://openairdocs.org/aircraft/N408LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1975 · S/N 4600
- [N4312L](https://openairdocs.org/aircraft/N4312L.md): Coulson Aviation (USA) Inc · Portland, OR · S/N 382-4312
- [N4313L](https://openairdocs.org/aircraft/N4313L.md): Coulson Aviation (USA) Inc · Portland, OR · S/N 382-4313
- [N460DF](https://openairdocs.org/aircraft/N460DF.md): California Dept Of Forestry And Fire Protection · Mcclellan, CA · S/N 4996
- [N462DF](https://openairdocs.org/aircraft/N462DF.md): California Dept Of Forestry And Fire Protection · Mcclellan, CA · S/N 5034
- [N464DF](https://openairdocs.org/aircraft/N464DF.md): California Dept Of Forestry And Fire Protection · Mcclellan, CA · S/N 5002
- [N465DF](https://openairdocs.org/aircraft/N465DF.md): California Dept Of Forestry And Fire Protection · Mcclellan, CA · S/N 5035
- [N466TM](https://openairdocs.org/aircraft/N466TM.md): T B M Inc · Atwater, CA · Built 1957 · S/N 57-466
- [N468DF](https://openairdocs.org/aircraft/N468DF.md): California Dept Of Forestry And Fire Protection · Mcclellan, CA · S/N 5107
- [N479TM](https://openairdocs.org/aircraft/N479TM.md): Tbm Inc · Atwater, CA · S/N 57-0479
- [N531TB](https://openairdocs.org/aircraft/N531TB.md): Tbm · Atwater, CA · S/N 56-0531
- [N567DF](https://openairdocs.org/aircraft/N567DF.md): California Dept Of Forestry And Fire Protection · Mcclellan, CA · S/N 5005

## 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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2023-22-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2023-22-06')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/ad/2023-22-06/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.