# Registered aircraft: Green River College

A list on [Green River College](https://openairdocs.org/faa-owner/GREEN%20RIVER%20COLLEGE.md).

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

- [N286KS](https://openairdocs.org/aircraft/N286KS.md): Skydio SDR35V1 · S/N SKYDIO2P-5C3E · Auburn, WA
- [N287BS](https://openairdocs.org/aircraft/N287BS.md): DJI PHANTOM 4 PRO · S/N 0AXCE4V0A30241 · Auburn, WA
- [N365WG](https://openairdocs.org/aircraft/N365WG.md): DJI AVATA 2 · S/N 1581F6W8B247S00202UY · Auburn, WA
- [N4454G](https://openairdocs.org/aircraft/N4454G.md): DJI AVATA 2 · S/N 1581F6W8B249L00200MD · Auburn, WA
- [N585GR](https://openairdocs.org/aircraft/N585GR.md): Autel Robotics X-STAR PREMIUM · S/N UXS916462166 · Auburn, WA
- [N705GR](https://openairdocs.org/aircraft/N705GR.md): DJI MAVIC 2 PRO · S/N 163DG1M001KCH7 · Auburn, WA
- [N778DC](https://openairdocs.org/aircraft/N778DC.md): E-Flite APPRENTICE S · S/N EFLR310013 · Auburn, WA
- [N779AG](https://openairdocs.org/aircraft/N779AG.md): Flyzone SENSEI FS · S/N 1507230826 · Auburn, WA
- [N782HG](https://openairdocs.org/aircraft/N782HG.md): DJI PHANTOM 2 · S/N PH645464577 · Auburn, WA
- [N833MG](https://openairdocs.org/aircraft/N833MG.md): DJI PHANTOM 4 PRO · S/N 0AXCE680B30110 · Auburn, WA
- [N833NR](https://openairdocs.org/aircraft/N833NR.md): DJI PHANTOM 4 PRO · S/N 0AXCE5T0B31217 · Auburn, WA
- [N852QC](https://openairdocs.org/aircraft/N852QC.md): DJI MAVIC PRO · S/N 08QCEAC0226YFV · Auburn, WA
- [N852RK](https://openairdocs.org/aircraft/N852RK.md): DJI MAVIC AIR · S/N 0K1DF4F2BDW931 · Auburn, WA
- [N852SD](https://openairdocs.org/aircraft/N852SD.md): DJI SPARK · S/N 0ASDE9E1B1002N · Auburn, WA
- [N853UW](https://openairdocs.org/aircraft/N853UW.md): DJI MAVIC PRO · S/N 08QCEBP022B03N · Auburn, WA
- [N8646G](https://openairdocs.org/aircraft/N8646G.md): DJI MAVIC PRO · S/N 08Q2F8X00S0171 · Auburn, WA
- [N865BK](https://openairdocs.org/aircraft/N865BK.md): DJI MAVIC PRO · S/N 08Q22F8X00S0170 · Auburn, WA
- [N896WG](https://openairdocs.org/aircraft/N896WG.md): DJI MAVIC AIR 2 · S/N 3N3BH8601205ZC · Auburn, WA
- [N948SS](https://openairdocs.org/aircraft/N948SS.md): Skydio SDR35V1 · S/N SKYDIO2P-FV6F · Auburn, WA
- [N948TS](https://openairdocs.org/aircraft/N948TS.md): Skydio SDR35V1 · S/N SKYDIO2P-7846 · Auburn, WA
- [N948US](https://openairdocs.org/aircraft/N948US.md): Skydio SDR35V1 · S/N SKYDIO2P-7FS8 · Auburn, WA
- [N948VS](https://openairdocs.org/aircraft/N948VS.md): Skydio SDR35V1 · S/N SKYDIO2P-AH9S · Auburn, WA
- [N997QG](https://openairdocs.org/aircraft/N997QG.md): DJI FPV · S/N 37QBK5CBD100C4 · Auburn, WA

## 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 = 'GREEN RIVER COLLEGE' OR list_contains(g.other_registrant_names, 'GREEN RIVER COLLEGE')
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-owner/GREEN%20RIVER%20COLLEGE/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.