Skip to content

Universal GLOBE GC-1A

Registered aircraft · 9

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "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 aircraft_model_code IN ('9230110')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('9230110')
ORDER BY 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.

N62928Zahler Mitchell J · Stillwater, MNS/N 153 N80540Mckinlay Jason S · Wareham, MAS/N 43 N80570Hoffman Richard A · Scottsdale, AZBuilt 1946 · S/N 73 N80743Kirkpatrick Adam T · Walworth, WIBuilt 1946 · S/N 146 N80779Stein William R · Aptos, CABuilt 1946 · S/N 182 N80782Zahler Mitchell J · Stillwater, MNBuilt 1946 · S/N 185 N80818Zahler Mitchell J · Stillwater, MNBuilt 1946 · S/N 221 N80824Streamline Aviation LLC · Battlefield, MOS/N 227 N90340Holliday Mark E · Lake Elmo, MNBuilt 1946 · S/N 354

Back to Universal GLOBE GC-1A