Registered aircraft · 23

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

Query with 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

duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N286KSSkydio SDR35V1 · S/N SKYDIO2P-5C3EAuburn, WA N287BSDJI PHANTOM 4 PRO · S/N 0AXCE4V0A30241Auburn, WA N365WGDJI AVATA 2 · S/N 1581F6W8B247S00202UYAuburn, WA N4454GDJI AVATA 2 · S/N 1581F6W8B249L00200MDAuburn, WA N585GRAutel Robotics X-STAR PREMIUM · S/N UXS916462166Auburn, WA N705GRDJI MAVIC 2 PRO · S/N 163DG1M001KCH7Auburn, WA N778DCE-Flite APPRENTICE S · S/N EFLR310013Auburn, WA N779AGFlyzone SENSEI FS · S/N 1507230826Auburn, WA N782HGDJI PHANTOM 2 · S/N PH645464577Auburn, WA N833MGDJI PHANTOM 4 PRO · S/N 0AXCE680B30110Auburn, WA N833NRDJI PHANTOM 4 PRO · S/N 0AXCE5T0B31217Auburn, WA N852QCDJI MAVIC PRO · S/N 08QCEAC0226YFVAuburn, WA N852RKDJI MAVIC AIR · S/N 0K1DF4F2BDW931Auburn, WA N852SDDJI SPARK · S/N 0ASDE9E1B1002NAuburn, WA N853UWDJI MAVIC PRO · S/N 08QCEBP022B03NAuburn, WA N8646GDJI MAVIC PRO · S/N 08Q2F8X00S0171Auburn, WA N865BKDJI MAVIC PRO · S/N 08Q22F8X00S0170Auburn, WA N896WGDJI MAVIC AIR 2 · S/N 3N3BH8601205ZCAuburn, WA N948SSSkydio SDR35V1 · S/N SKYDIO2P-FV6FAuburn, WA N948TSSkydio SDR35V1 · S/N SKYDIO2P-7846Auburn, WA N948USSkydio SDR35V1 · S/N SKYDIO2P-7FS8Auburn, WA N948VSSkydio SDR35V1 · S/N SKYDIO2P-AH9SAuburn, WA N997QGDJI FPV · S/N 37QBK5CBD100C4Auburn, WA

Back to Green River College