# Registered aircraft: AD 67-07-02

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

- [N100AS](https://openairdocs.org/aircraft/N100AS.md): Kalitta Charters LLC · Ypsilanti, MI · Built 1969 · S/N 274
- [N123RA](https://openairdocs.org/aircraft/N123RA.md): Royal Air Freight Inc · Waterford, MI · Built 1966 · S/N 30
- [N148TW](https://openairdocs.org/aircraft/N148TW.md): Sierra American Corp · Wilmington, DE · Built 1968 · S/N 148
- [N158TW](https://openairdocs.org/aircraft/N158TW.md): Sierra American Corp · Wilmington, DE · Built 1968 · S/N 158
- [N200CP](https://openairdocs.org/aircraft/N200CP.md): Skyview LLC · Wilmington, DE · Built 1972 · S/N 275
- [N204TW](https://openairdocs.org/aircraft/N204TW.md): Sierra American Corp · Wilmington, DE · Built 1969 · S/N 204
- [N209CA](https://openairdocs.org/aircraft/N209CA.md): Aloft Aviation LLC · Hampton, GA · S/N 71
- [N20FJ](https://openairdocs.org/aircraft/N20FJ.md): Dodson International Parts Inc · Rantoul, KS · S/N 119
- [N20WK](https://openairdocs.org/aircraft/N20WK.md): Royal Air Freight Inc · Waterford, MI · Built 1974 · S/N 310
- [N221TW](https://openairdocs.org/aircraft/N221TW.md): Sierra American Corp · Wilmington, DE · Built 1969 · S/N 221
- [N227CK](https://openairdocs.org/aircraft/N227CK.md): Kalitta Charters LLC · Ypsilanti, MI · Built 1970 · S/N 227
- [N240CK](https://openairdocs.org/aircraft/N240CK.md): Kalitta Charters LLC · Ypsilanti, MI · Built 1966 · S/N 24
- [N244CK](https://openairdocs.org/aircraft/N244CK.md): Kalitta Air LLC · Ypsilanti, MI · Built 1977 · S/N 369
- [N283SA](https://openairdocs.org/aircraft/N283SA.md): Dodson International Parts Inc · Rantoul, KS · S/N 83
- [N404DH](https://openairdocs.org/aircraft/N404DH.md): Dodson International Parts Inc · Rantoul, KS · Built 1977 · S/N 366
- [N481FL](https://openairdocs.org/aircraft/N481FL.md): Ifl Group Inc · Waterford, MI · Built 1966 · S/N 27
- [N520TC](https://openairdocs.org/aircraft/N520TC.md): Dodson International Parts Inc · Rantoul, KS · S/N 319
- [N521FL](https://openairdocs.org/aircraft/N521FL.md): Ifl Group Inc · Waterford, MI · Built 1967 · S/N 68
- [N68UP](https://openairdocs.org/aircraft/N68UP.md): Royal Air Freight Inc · Waterford, MI · Built 1971 · S/N 258
- [N770FG](https://openairdocs.org/aircraft/N770FG.md): Hangar LLC · Las Vegas, NV · Built 1967 · S/N 116
- [N808CK](https://openairdocs.org/aircraft/N808CK.md): Kalitta Charters LLC · Ypsilanti, MI · Built 1967 · S/N 108
- [N820CK](https://openairdocs.org/aircraft/N820CK.md): Kalitta Charters LLC · Ypsilanti, MI · Built 1967 · S/N 120
- [N900RA](https://openairdocs.org/aircraft/N900RA.md): Royal Air Freight Inc · Waterford, MI · Built 1967 · S/N 59
- [N921ML](https://openairdocs.org/aircraft/N921ML.md): Dodson International Parts Inc · Rantoul, KS · S/N 99

## 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-07-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:67-07-02')
ORDER BY n_number
```

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