# Registered aircraft: AD 2015-06-02 R1

A list on [AD 2015-06-02 R1](https://openairdocs.org/ad/2015-06-02-R1.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.

- [N137HP](https://openairdocs.org/aircraft/N137HP.md): California Highway Patrol · Sacramento, CA · Built 2015 · S/N GA8-TC 320-15-218
- [N139HP](https://openairdocs.org/aircraft/N139HP.md): California Highway Patrol · Sacramento, CA · Built 2015 · S/N GA8-TC-320-15-224
- [N140HP](https://openairdocs.org/aircraft/N140HP.md): California Highway Patrol · Sacramento, CA · Built 2013 · S/N GA8-TC-320-13-198
- [N148HP](https://openairdocs.org/aircraft/N148HP.md): Alternative Travel LLC · Loveland, CO · Built 2016 · S/N GA8-TC-320-16-229
- [N153HP](https://openairdocs.org/aircraft/N153HP.md): California Highway Patrol · Sacramento, CA · Built 2016 · S/N GA8-TC-320-16-232
- [N156HP](https://openairdocs.org/aircraft/N156HP.md): California Highway Patrol · Sacramento, CA · Built 2016 · S/N GA8-TC-320-16-234
- [N159HP](https://openairdocs.org/aircraft/N159HP.md): California Highway Patrol · Sacramento, CA · Built 2018 · S/N GA8-TC-320-18-246
- [N165PW](https://openairdocs.org/aircraft/N165PW.md): County Of San Bernardino · San Bernardino, CA · Built 2014 · S/N GA8-TC 320-14-205
- [N1753S](https://openairdocs.org/aircraft/N1753S.md): Fsa Aviation Inc · Wilmington, DE · Built 2012 · S/N GA8-TC 320-12-175
- [N209PD](https://openairdocs.org/aircraft/N209PD.md): Modesto Police Department · Modesto, CA · Built 2012 · S/N GA8-TC 320-12-186
- [N225AV](https://openairdocs.org/aircraft/N225AV.md): Y-O Cattle Co LLC · Laredo, TX · S/N GA8-TC 320-13-192
- [N244CJ](https://openairdocs.org/aircraft/N244CJ.md): Paula Stewart LLC · Saipan, MP · Built 2017 · S/N GA8-TC-320-17-239
- [N255AV](https://openairdocs.org/aircraft/N255AV.md): Paula Stewart LLC · Saipan, MP · Built 2015 · S/N GA8-TC-320-15-215
- [N265PW](https://openairdocs.org/aircraft/N265PW.md): San Bernardino County Sheriff'S Department · San Bernardino, CA · Built 2018 · S/N GA8-TC 320-18-250
- [N267MA](https://openairdocs.org/aircraft/N267MA.md): Lease Air LLC · Moab, UT · S/N GA8-TC 320-11-167
- [N495KB](https://openairdocs.org/aircraft/N495KB.md): Wipaire Inc · South Saint Paul, MN · Built 2011 · S/N GA8-TC 320-11-168
- [N65HP](https://openairdocs.org/aircraft/N65HP.md): Ohio Department Of Public Safety · Columbus, OH · Built 2018 · S/N GA8-TC-320-18-247
- [N68GA](https://openairdocs.org/aircraft/N68GA.md): Sky Combat Blue LLC · Brookhaven, GA · Built 2012 · S/N GA8-TC 320-12-187
- [N752SE](https://openairdocs.org/aircraft/N752SE.md): Atkins Alvin R Trustee · Barnstead, NH · Built 2012 · S/N GA8-TC 320-12-183
- [N754SE](https://openairdocs.org/aircraft/N754SE.md): International Air Services Inc Trustee · Carson City, NV · Built 2012 · S/N GA8-TC 320-12-174
- [N80TP](https://openairdocs.org/aircraft/N80TP.md): Global Aerials Inc · Pembroke Pines, FL · Built 2012 · S/N GA8-TC 320-12-181
- [N894SC](https://openairdocs.org/aircraft/N894SC.md): Lease Air LLC · Moab, UT · Built 2010 · S/N GA8-TC 320-10-156
- [N910MB](https://openairdocs.org/aircraft/N910MB.md): Langersmith Michael · Loveland, CO · Built 2010 · S/N GA8-TC 320-10-159
- [N960RN](https://openairdocs.org/aircraft/N960RN.md): Orange County Sheriffs Department Rnsp · Santa Ana, CA · Built 2018 · S/N GA8-TC-320-18-249
- [N99GA](https://openairdocs.org/aircraft/N99GA.md): Rustair Inc · Anchorage, AK · Built 2012 · S/N GA-8-TC320-12-173

## 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:2015-06-02-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-06-02-R1')
ORDER BY n_number
```

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