# Registered aircraft: GE J47 series

A list on [GE J47 series](https://openairdocs.org/engine/ge-j47-series.md).

Aircraft with this engine in the FAA registry, by N-number.

- [N186AM](https://openairdocs.org/aircraft/N186AM.md): Planes Of Fame Air Museum · Chino, CA · Built 1952 · S/N 52-5012
- [N188RL](https://openairdocs.org/aircraft/N188RL.md): Jasper Dane · Casper, WY · Built 1952 · S/N 524986CW
- [N286CF](https://openairdocs.org/aircraft/N286CF.md): F-86 Sabrejet Inc · Wellington, FL · Built 1952 · S/N 52-5116
- [N48178](https://openairdocs.org/aircraft/N48178.md): Heritage Air LLC · Grove, OK · Built 1948 · S/N 48178
- [N860AG](https://openairdocs.org/aircraft/N860AG.md): Comanche Fighters LLC · Houston, TX · Built 1952 · S/N 52-4666
- [N86F](https://openairdocs.org/aircraft/N86F.md): Registered aircraft · Built 1952 · S/N 52-5139A
- [N86JZ](https://openairdocs.org/aircraft/N86JZ.md): Acv Group LLC · Mckinleyville, CA · Built 1952 · S/N 52-4959
- [N86NA](https://openairdocs.org/aircraft/N86NA.md): Texas Air Command Museum Inc · Grand Prairie, TX · Built 1952 · S/N 524731

## 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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('30009')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/engine/ge-j47-series/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.