Skip to content

Office Of Aviation Services

Registered aircraft · 37

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 = 'OFFICE OF AVIATION SERVICES' OR list_contains(g.other_registrant_names, 'OFFICE OF AVIATION SERVICES') 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 = 'OFFICE OF AVIATION SERVICES' OR list_contains(g.other_registrant_names, 'OFFICE OF AVIATION SERVICES')
  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 = 'OFFICE OF AVIATION SERVICES' OR list_contains(g.other_registrant_names, 'OFFICE OF AVIATION SERVICES')
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.

N109RSCessna TU206G · S/N U20606002Boise, ID · Co-owner with United States Department Of Interior N11PPBell 412EP · S/N 36316Built 2003 · Boise, ID · Co-owner with US Dept Of The Interior N132PSCessna 206H · S/N 20608278Boise, ID · Co-owner with U S Department Of The Interior N135LCub Crafters CC18-180 · S/N CC18-0079Built 2016 · Boise, ID · Co-owner with US Department Of The Interior N162GCBeech B200 · S/N BB-1238Built 1985 · Boise, ID · Co-owner with United States Department Of Interior N186LCub Crafters CC18-180 · S/N CC18-0086Built 2017 · Boise, ID · Co-owner with US Department Of The Interior N192CCCub Crafters CC18-180 · S/N CC18-0056Built 2012 · Boise, ID · Co-owner with U S Department Of The Interior N206RWBell 206B-III · S/N 4372Built 1995 · Boise, ID · Co-owner with United States Department Of Interior N206WBCessna U206F · S/N U20602058Built 1973 · Boise, ID N222GRHylio AG 230 · S/N 17906100361Boise, ID N22PPBell 412EP · S/N 36219Built 1998 · Boise, ID · Co-owner with Department Of Interior N232LCub Crafters CC18-180 · S/N CC18-0069Built 2014 · Boise, ID · Co-owner with US Department Of The Interior N232PSCub Crafters CC18-180 · S/N CC18-0076Built 2015 · Boise, ID · Co-owner with U S Department Of The Interior N242WBCessna T206H · S/N T20609037Built 2011 · Boise, ID · Co-owner with United States Department Of Interior N260UAFreefly Systems ALTA X · S/N AX946642Boise, ID · Co-owner with US Department Of The Interior N261UAE-Flite APPRENTICE S 15E · S/N 045477Boise, ID · Co-owner with U S Dept Of The Interior N278CCCub Crafters CC18-180 · S/N CC18-0057Built 2012 · Boise, ID · Co-owner with US Department Of The Interior N287LCub Crafters CC18-180 · S/N CC18-0071Built 2014 · Boise, ID · Co-owner with US Department Of The Interior N328CCCub Crafters CC18-180 · S/N CC18-0058Built 2012 · Boise, ID · Co-owner with US Dept Of The Interior N356MCub Crafters CC18-180 · S/N CC18-0072Built 2014 · Boise, ID · Co-owner with U S Department Of The Interior N375FCessna U206G · S/N U20605750Built 1980 · Boise, ID · Co-owner with Department Of The Interior N378HCessna T206H · S/N T20608242Boise, ID · Co-owner with Dept Of The Interior N437CCCub Crafters CC18-180 · S/N CC18-0059Built 2012 · Boise, ID · Co-owner with U S Department Of The Interior N473YCCessna 206H · S/N 20608348Built 2012 · Boise, ID · Co-owner with U S Department Of The Interior N49SJDehavilland DHC-6-300 · S/N 423Built 1974 · Boise, ID · Co-owner with United States Department Of Interior N51096Cessna T206H · S/N T20608389Boise, ID · Co-owner with Dept Of The Interior N514FWAirbus Helicopters AS350B3 · S/N 9339Built 2023 · Boise, ID N523MCub Crafters CC18-180 · S/N CC18-0070Built 2014 · Boise, ID · Co-owner with U S Department Of The Interior N527CCCub Crafters CC18-180 · S/N CC18-0063Built 2012 · Boise, ID · Co-owner with US Department Of The Interior N534LCub Crafters CC18-180 · S/N CC18-0075Built 2015 · Boise, ID · Co-owner with U.S. Department Of The Interior N545PSCessna TU206G · S/N U20606702Built 1983 · Boise, ID · Co-owner with United States Department Of The Interior N567LCub Crafters CC18-180 · S/N CC18-0080Built 2016 · Boise, ID · Co-owner with US Department Of The Interior N618CCCub Crafters CC18-180 · S/N CC18-0062Built 2013 · Boise, ID · Co-owner with U S Department Of Interior N721NRCessna U206G · S/N U20606902Built 1985 · Boise, ID · Co-owner with US Department Of The Interior N732KCessna A185F · S/N 18504103Built 1980 · Boise, ID · Co-owner with United States Department Of The Interior N774JCCub Crafters CC18-180 · S/N CC18-0066Built 2014 · Boise, ID · Co-owner with US Department Of The Interior N77554Cessna U206F · S/N U20603408Built 1976 · Boise, ID · Co-owner with U S Department Of The Interior

Back to Office Of Aviation Services