# Registered aircraft: AD 2018-11-02

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

- [N142CS](https://openairdocs.org/aircraft/N142CS.md): US Customs & Border Protection · Corpus Christi, TX · S/N LC5248
- [N143CS](https://openairdocs.org/aircraft/N143CS.md): US Customs & Border Protection · Corpus Christi, TX · S/N LC5243
- [N144CS](https://openairdocs.org/aircraft/N144CS.md): US Customs & Border Protection · Jacksonville, FL · S/N 153446
- [N146CS](https://openairdocs.org/aircraft/N146CS.md): United States Customs And Border Protection · Jacksonville, FL · S/N 5286
- [N147CS](https://openairdocs.org/aircraft/N147CS.md): United States Customs And Border Protection · Corpus Christi, TX · S/N LC-5162
- [N148CS](https://openairdocs.org/aircraft/N148CS.md): United States Customs And Border Protection · Corpus Christi, TX · S/N LC-5256
- [N149CS](https://openairdocs.org/aircraft/N149CS.md): US Customs & Border Protection · Jacksonville, FL · S/N 154581
- [N282F](https://openairdocs.org/aircraft/N282F.md): Rockland Aerospace Inc · Crofton, MD · Built 1959 · S/N 1084
- [N286F](https://openairdocs.org/aircraft/N286F.md): Rockland Aerospace Inc · Crofton, MD · Built 1960 · S/N 1146
- [N340HA](https://openairdocs.org/aircraft/N340HA.md): Rockland Aerospace Inc · Crofton, MD · Built 1959 · S/N 1109
- [N346HA](https://openairdocs.org/aircraft/N346HA.md): Rockland Aerospace Inc · Crofton, MD · S/N 188A-1043
- [N403SK](https://openairdocs.org/aircraft/N403SK.md): United States Customs And Border Protection · Jacksonville, FL · S/N 154603
- [N423SK](https://openairdocs.org/aircraft/N423SK.md): United States Customs And Border Protection · Corpus Christi, TX · S/N LC-5220
- [N426NA](https://openairdocs.org/aircraft/N426NA.md): National Aeronautics And Space Administration · Wallops Island, VA · S/N 152735
- [N431SK](https://openairdocs.org/aircraft/N431SK.md): United States Customs And Border Protection · Corpus Christie, TX · S/N LC-5288
- [N480SK](https://openairdocs.org/aircraft/N480SK.md): U S Customs & Border Protection · Jacksonville, FL · S/N 154580
- [N741SK](https://openairdocs.org/aircraft/N741SK.md): United States Customs And Border Protection · Jacksonville, FL · S/N 152741
- [N769SK](https://openairdocs.org/aircraft/N769SK.md): US Customs & Border Protection · Corpus Christi, TX · S/N 152729
- [N900AU](https://openairdocs.org/aircraft/N900AU.md): United Aeronautical Corp · North Hollywood, CA · Built 2010 · S/N 151391
- [N920AU](https://openairdocs.org/aircraft/N920AU.md): United Aeronautical Corp · North Hollywood, CA · Built 1963 · S/N 150513
- [N922AU](https://openairdocs.org/aircraft/N922AU.md): Buffalo Airways USA Inc · Hawthorne, FL · Built 1964 · S/N 151387
- [N923AU](https://openairdocs.org/aircraft/N923AU.md): United Aeronautical Corp · North Hollywood, CA · S/N 151372
- [N925AU](https://openairdocs.org/aircraft/N925AU.md): Mhd Rockland Services Inc · Starke, FL · Built 1964 · S/N 151361
- [N927AU](https://openairdocs.org/aircraft/N927AU.md): Mhd Rockland Services Inc · Starke, FL · Built 2010 · S/N 151369

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

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