# Registered aircraft: AD 2004-19-02

A list on [AD 2004-19-02](https://openairdocs.org/ad/2004-19-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
- [N179CJ](https://openairdocs.org/aircraft/N179CJ.md): Ial Corp · Lewes, DE · S/N 176
- [N184WW](https://openairdocs.org/aircraft/N184WW.md): Royal Air Freight Inc · Waterford, MI · Built 1976 · S/N 352
- [N189RB](https://openairdocs.org/aircraft/N189RB.md): Dodson International Parts Inc · Rantoul, KS · Built 1972 · S/N 262
- [N200CP](https://openairdocs.org/aircraft/N200CP.md): Skyview LLC · Wilmington, DE · Built 1972 · S/N 275
- [N200FJ](https://openairdocs.org/aircraft/N200FJ.md): Alliance Air Parts Acquisitions Corp · Oklahoma City, OK · Built 1980 · S/N 408
- [N200WK](https://openairdocs.org/aircraft/N200WK.md): Skyview LLC · Wilmington, DE · Built 1976 · S/N 261
- [N201BR](https://openairdocs.org/aircraft/N201BR.md): Sky Bus Inc · North Miami Beach, FL · Built 1968 · S/N 166
- [N204TW](https://openairdocs.org/aircraft/N204TW.md): Sierra American Corp · Wilmington, DE · Built 1969 · S/N 204
- [N205DJ](https://openairdocs.org/aircraft/N205DJ.md): Dodson International Parts Inc · Rantoul, KS · Built 1979 · S/N 399
- [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
- [N239CD](https://openairdocs.org/aircraft/N239CD.md): Royal Air Freight Inc · Waterford, MI · Built 1975 · S/N 339
- [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
- [N380CJ](https://openairdocs.org/aircraft/N380CJ.md): Skyview LLC · Wilmington, DE · S/N 380
- [N404DH](https://openairdocs.org/aircraft/N404DH.md): Dodson International Parts Inc · Rantoul, KS · Built 1977 · S/N 366
- [N404HR](https://openairdocs.org/aircraft/N404HR.md): Budget Jet LLC · Delray Beach, FL · Built 1985 · S/N 455
- [N438SJ](https://openairdocs.org/aircraft/N438SJ.md): Kalitta Charters LLC · Ypsilanti, MI · Built 1981 · S/N 438
- [N481FL](https://openairdocs.org/aircraft/N481FL.md): Ifl Group Inc · Waterford, MI · Built 1966 · S/N 27
- [N511FL](https://openairdocs.org/aircraft/N511FL.md): Ifl Group Inc · Waterford, MI · Built 1967 · S/N 122
- [N520AW](https://openairdocs.org/aircraft/N520AW.md): Gg Flight LLC · Findlay, OH · Built 1981 · S/N 453
- [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
- [N531FL](https://openairdocs.org/aircraft/N531FL.md): Ifl Group Inc · Waterford, MI · Built 1967 · S/N 113
- [N600CD](https://openairdocs.org/aircraft/N600CD.md): Kalitta Charters LLC · Ypsilanti, MI · Built 1978 · S/N 377
- [N600RA](https://openairdocs.org/aircraft/N600RA.md): Royal Air Freight Inc · Waterford, MI · Built 1984 · S/N 296
- [N604PT](https://openairdocs.org/aircraft/N604PT.md): R3hd Air LLC · Marietta, GA · Built 1969 · S/N 202
- [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:2004-19-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:2004-19-02')
ORDER BY n_number
```

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