# Registered aircraft: AD 2017-04-15

A list on [AD 2017-04-15](https://openairdocs.org/ad/2017-04-15.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.

- [N116MA](https://openairdocs.org/aircraft/N116MA.md): Fsa Aerospace Inc Trustee · Wilmington, DE · Built 1977 · S/N 029
- [N132LJ](https://openairdocs.org/aircraft/N132LJ.md): Aery Aviation LLC · Wilmington, DE · Built 1977 · S/N 032
- [N136DH](https://openairdocs.org/aircraft/N136DH.md): Csc Delaware Trust Co Trustee · Wilmington, DE · Built 1977 · S/N 036
- [N160GC](https://openairdocs.org/aircraft/N160GC.md): C2d LLC · Cartersville, GA · S/N 36A-030
- [N16FN](https://openairdocs.org/aircraft/N16FN.md): Gh Equipment LLC · Dover, DE · Built 1976 · S/N 027
- [N17A](https://openairdocs.org/aircraft/N17A.md): Valiair Limited Co Trustee · Casper, WY · Built 1980 · S/N 046
- [N18FN](https://openairdocs.org/aircraft/N18FN.md): Gh Equipment LLC · Dover, DE · Built 1974 · S/N 037
- [N20GJ](https://openairdocs.org/aircraft/N20GJ.md): Global Jetcare Inc · Brooksville, FL · S/N 026
- [N302EW](https://openairdocs.org/aircraft/N302EW.md): Aery Aviation LLC · Wilmington, DE · Built 1976 · S/N 024
- [N31GJ](https://openairdocs.org/aircraft/N31GJ.md): Global Jetcare Inc · Brooksville, FL · Built 1976 · S/N 022
- [N32PA](https://openairdocs.org/aircraft/N32PA.md): Phoenix Air Group Inc · Cartersville, GA · Built 1976 · S/N 025
- [N363PJ](https://openairdocs.org/aircraft/N363PJ.md): Premier Jets Inc · Hillsboro, OR · Built 1977 · S/N 038
- [N41GJ](https://openairdocs.org/aircraft/N41GJ.md): Global Jetcare Inc · Brooksville, FL · Built 1984 · S/N 055
- [N51GJ](https://openairdocs.org/aircraft/N51GJ.md): Global Jetcare Inc · Brooksville, FL · Built 1976 · S/N 018
- [N527PA](https://openairdocs.org/aircraft/N527PA.md): Phoenix Air Group Inc · Cartersville, GA · Built 1976 · S/N 019
- [N545PA](https://openairdocs.org/aircraft/N545PA.md): Phoenix Air Group Inc · Cartersville, GA · S/N 36A-028
- [N56PA](https://openairdocs.org/aircraft/N56PA.md): Phoenix Air Group Inc · Cartesville, GA · Built 1976 · S/N 023
- [N62PG](https://openairdocs.org/aircraft/N62PG.md): Phoenix Air Group Inc · Cartersville, GA · Built 1977 · S/N 031
- [N71CK](https://openairdocs.org/aircraft/N71CK.md): Kalitta Charters LLC · Ypsilanti, MI · Built 1977 · S/N 035
- [N81GJ](https://openairdocs.org/aircraft/N81GJ.md): Global Jetcare Inc · Brooksville, FL · Built 1981 · S/N 047
- [N99RS](https://openairdocs.org/aircraft/N99RS.md): Casmos LLC · Wilmington, DE · S/N 039

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

This list as a web page: https://openairdocs.org/ad/2017-04-15/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.