# Registered aircraft: AD 67-28-01

A list on [AD 67-28-01](https://openairdocs.org/ad/67-28-01.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.

- [N1187D](https://openairdocs.org/aircraft/N1187D.md): Cordero Miguel · Hollywood, FL · S/N 680-626-252
- [N138K](https://openairdocs.org/aircraft/N138K.md): South Bay Aviation Inc · Torrance, CA · S/N 720-621-2
- [N2755L](https://openairdocs.org/aircraft/N2755L.md): Merxbauer Terry E · La Pine, OR · Built 1955 · S/N 680-255
- [N2782B](https://openairdocs.org/aircraft/N2782B.md): Abbing Frits G H · Crescent City, FL · Built 1957 · S/N 559
- [N2788B](https://openairdocs.org/aircraft/N2788B.md): K&L Agri Farms Inc · Adams, NE · Built 1957 · S/N 560
- [N3341](https://openairdocs.org/aircraft/N3341.md): Sale Reported · La Plata, NM · Sale reported, pending cancellation · Built 1956 · S/N 680-456-126
- [N3846C](https://openairdocs.org/aircraft/N3846C.md): Crowder Eston W · Dade City, FL · S/N 709
- [N4278S](https://openairdocs.org/aircraft/N4278S.md): Chagnot Catherine J · Athens, OH · Built 1959 · S/N 680E-813-60
- [N4618E](https://openairdocs.org/aircraft/N4618E.md): Sale Reported · El Paso, TX · Sale reported · Built 1959 · S/N 737
- [N561KE](https://openairdocs.org/aircraft/N561KE.md): Maglaughlin Ronald D · Udall, KS · S/N 680-322-16
- [N58G](https://openairdocs.org/aircraft/N58G.md): Szarek Evelyn Personal Representative · Fairbanks, AK · Built 1957 · S/N 680-519-189
- [N6217D](https://openairdocs.org/aircraft/N6217D.md): Smithey Larry M · Wake Forest, NC · S/N 680-485-155
- [N6222D](https://openairdocs.org/aircraft/N6222D.md): Robertson C A · Phoenix, AZ · S/N 680-490-160
- [N623FS](https://openairdocs.org/aircraft/N623FS.md): Morse Edward K Jr · Wasilla, AK · S/N 578
- [N6278D](https://openairdocs.org/aircraft/N6278D.md): Sale Reported · Oklahoma City, OK · Sale reported · Built 1957 · S/N 548216
- [N677JR](https://openairdocs.org/aircraft/N677JR.md): Roach James M · West Bountiful, UT · Built 1958 · S/N 680-647-254
- [N68113](https://openairdocs.org/aircraft/N68113.md): Gogoplex LLC · Wilmington, DE · Built 1956 · S/N 680-316-11
- [N6819Q](https://openairdocs.org/aircraft/N6819Q.md): Walker Gilbert R · Brentwood, TN · Built 1957 · S/N 680-488-158
- [N6883S](https://openairdocs.org/aircraft/N6883S.md): Webb Ronald G · Dickson, TN · Built 1956 · S/N 680-407-83
- [N8445C](https://openairdocs.org/aircraft/N8445C.md): Maddox Jody S · Paterson, WA · Built 1959 · S/N 680E-777-49
- [N8468C](https://openairdocs.org/aircraft/N8468C.md): Intravaia Anthony J · Mountain View, CA · Built 1959 · S/N 680E-802-57
- [N9680E](https://openairdocs.org/aircraft/N9680E.md): Mulkey Howard Daniel · Spanaway, WA · S/N 699-18

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

This list as a web page: https://openairdocs.org/ad/67-28-01/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.