# Registered aircraft: Coulson Aviation (USA) Inc

A list on [Coulson Aviation (USA) Inc](https://openairdocs.org/faa-owner/COULSON%20AVIATION%20(USA)%20INC.md).

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

- [N1200N](https://openairdocs.org/aircraft/N1200N.md): Cessna 550 · S/N 550-0681 · Built 1992 · Portland, OR
- [N399WN](https://openairdocs.org/aircraft/N399WN.md): Boeing 737-3H4 · S/N 27693 · Built 1995 · Portland, OR
- [N4053L](https://openairdocs.org/aircraft/N4053L.md): Lockheed Martin C-130H · S/N 382-4053 · Portland, OR
- [N4054](https://openairdocs.org/aircraft/N4054.md): Lockheed Martin C-130H · S/N 382-4054 · Portland, OR
- [N4312L](https://openairdocs.org/aircraft/N4312L.md): Lockheed Martin C-130H · S/N 382-4312 · Portland, OR
- [N4313L](https://openairdocs.org/aircraft/N4313L.md): Lockheed Martin C-130H · S/N 382-4313 · Portland, OR
- [N470CG](https://openairdocs.org/aircraft/N470CG.md): Boeing CH47-414 · S/N M4026 · Portland, OR
- [N471CG](https://openairdocs.org/aircraft/N471CG.md): Boeing CH47-414 · S/N M4031 · Portland, OR
- [N509HH](https://openairdocs.org/aircraft/N509HH.md): Sikorsky S-76B · S/N 760312 · Portland, OR
- [N544CG](https://openairdocs.org/aircraft/N544CG.md): Cessna 550 · S/N 550-0701 · Built 1992 · Portland, OR
- [N547CG](https://openairdocs.org/aircraft/N547CG.md): Cessna 550 · S/N 550-0687 · Built 1991 · Portland, OR
- [N548CG](https://openairdocs.org/aircraft/N548CG.md): Cessna 550 · S/N 550-0700 · Built 1992 · Portland, OR
- [N549CG](https://openairdocs.org/aircraft/N549CG.md): Cessna 550 · S/N 5500699 · Built 1992 · Portland, OR
- [N554CG](https://openairdocs.org/aircraft/N554CG.md): Cessna 550 · S/N 550-0680 · Built 1992 · Portland, OR
- [N561CG](https://openairdocs.org/aircraft/N561CG.md): Cessna 560 · S/N 560-0099 · Built 1991 · Portland, OR
- [N604CG](https://openairdocs.org/aircraft/N604CG.md): Canadair CL-600 CHALLENGER · S/N 1048 · Built 1982 · Portland, OR
- [N737CG](https://openairdocs.org/aircraft/N737CG.md): Boeing 737-3H4 · S/N 27954 · Built 1995 · Portland, OR
- [N761CG](https://openairdocs.org/aircraft/N761CG.md): Sikorsky S-76B · S/N 760410 · Built 1994 · Portland, OR
- [N780J](https://openairdocs.org/aircraft/N780J.md): Sikorsky S-76B · S/N 760352 · Portland, OR
- [N7CG](https://openairdocs.org/aircraft/N7CG.md): Bombardier BD-700-1A10 · S/N 9075 · Built 2000 · Portland, OR

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'COULSON AVIATION (USA) INC' OR list_contains(g.other_registrant_names, 'COULSON AVIATION (USA) INC')
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-owner/COULSON%20AVIATION%20(USA)%20INC/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
