# Registered aircraft: AD 2019-03-21

A list on [AD 2019-03-21](https://openairdocs.org/ad/2019-03-21.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.

- [N1073P](https://openairdocs.org/aircraft/N1073P.md): Tvpx Ars Inc Trustee · North Salt Lake, UT · S/N 19000107
- [N108MP](https://openairdocs.org/aircraft/N108MP.md): Aircraft Propeller Service LLC · Lake Zurich, IL · S/N 19000108
- [N111NH](https://openairdocs.org/aircraft/N111NH.md): E190 Msn111 LLC · Dover, DE · Built 2007 · S/N 19000111
- [N112BZ](https://openairdocs.org/aircraft/N112BZ.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2007 · S/N 19000077
- [N114BZ](https://openairdocs.org/aircraft/N114BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2007 · S/N 19000092
- [N115BZ](https://openairdocs.org/aircraft/N115BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · S/N 19000096
- [N116BZ](https://openairdocs.org/aircraft/N116BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · S/N 19000101
- [N120BZ](https://openairdocs.org/aircraft/N120BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2007 · S/N 19000115
- [N126BZ](https://openairdocs.org/aircraft/N126BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2007 · S/N 19000124
- [N128BZ](https://openairdocs.org/aircraft/N128BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2007 · S/N 19000132
- [N133AB](https://openairdocs.org/aircraft/N133AB.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 19000469
- [N143BZ](https://openairdocs.org/aircraft/N143BZ.md): Petrus Regional One Msn 19000276 LLC · Dallas, TX · S/N 19000276
- [N184JB](https://openairdocs.org/aircraft/N184JB.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2005 · S/N 19000008
- [N190JB](https://openairdocs.org/aircraft/N190JB.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2005 · S/N 19000011
- [N190MB](https://openairdocs.org/aircraft/N190MB.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 19000524
- [N192JB](https://openairdocs.org/aircraft/N192JB.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2005 · S/N 19000014
- [N193JB](https://openairdocs.org/aircraft/N193JB.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2005 · S/N 19000017
- [N195AR](https://openairdocs.org/aircraft/N195AR.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 19000154
- [N260NA](https://openairdocs.org/aircraft/N260NA.md): Aircraft Propeller Service LLC · Lake Zurich, IL · S/N 19000260
- [N266JB](https://openairdocs.org/aircraft/N266JB.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2007 · S/N 19000054
- [N267JB](https://openairdocs.org/aircraft/N267JB.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2007 · S/N 19000065
- [N273JB](https://openairdocs.org/aircraft/N273JB.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2007 · S/N 19000073
- [N279JB](https://openairdocs.org/aircraft/N279JB.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2007 · S/N 19000090
- [N281JB](https://openairdocs.org/aircraft/N281JB.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2007 · S/N 19000103
- [N283JB](https://openairdocs.org/aircraft/N283JB.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2007 · S/N 19000125
- [N284JB](https://openairdocs.org/aircraft/N284JB.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2008 · S/N 19000144
- [N306JB](https://openairdocs.org/aircraft/N306JB.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2009 · S/N 19000272
- [N309JB](https://openairdocs.org/aircraft/N309JB.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2009 · S/N 19000289
- [N317JB](https://openairdocs.org/aircraft/N317JB.md): Wilmington Trust Company Trustee · Wilmington, DE · Built 2010 · S/N 19000363
- [N318JB](https://openairdocs.org/aircraft/N318JB.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2010 · S/N 19000364
- [N328JB](https://openairdocs.org/aircraft/N328JB.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2011 · S/N 19000422
- [N329JB](https://openairdocs.org/aircraft/N329JB.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2011 · S/N 19000433
- [N337JB](https://openairdocs.org/aircraft/N337JB.md): Advanced Air LLC · Statesville, NC · Built 2011 · S/N 19000473
- [N339JB](https://openairdocs.org/aircraft/N339JB.md): Advanced Air LLC · Statesville, NC · Built 2011 · S/N 19000490
- [N397NC](https://openairdocs.org/aircraft/N397NC.md): Wilmington Trust Company Trustee · Wilmington, DE · Built 2008 · S/N 19000151
- [N402L](https://openairdocs.org/aircraft/N402L.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 19000585
- [N529HG](https://openairdocs.org/aircraft/N529HG.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 19000529
- [N556EL](https://openairdocs.org/aircraft/N556EL.md): Registered aircraft · N-number assigned (import), not yet registered · S/N 19000556
- [N709AJ](https://openairdocs.org/aircraft/N709AJ.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 19000313
- [N825AC](https://openairdocs.org/aircraft/N825AC.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 19000575
- [N827AC](https://openairdocs.org/aircraft/N827AC.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 19000588
- [N937TA](https://openairdocs.org/aircraft/N937TA.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2008 · S/N 19000221
- [N956UW](https://openairdocs.org/aircraft/N956UW.md): Aerovision Aircraft Services LLC · Muskegon, MI · Built 2008 · S/N 19000156
- [N957UW](https://openairdocs.org/aircraft/N957UW.md): Aerovision Aircraft Services LLC · Muskegon, MI · Built 2008 · S/N 19000161
- [N958UW](https://openairdocs.org/aircraft/N958UW.md): Aerovision Aircraft Services LLC · Muskegon, MI · Built 2008 · S/N 19000164

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

This list as a web page: https://openairdocs.org/ad/2019-03-21/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.
