OpenAirDocs.org
Hirtle Alan L

Registered aircraft · 24

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
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 = 'HIRTLE ALAN L' OR list_contains(g.other_registrant_names, 'HIRTLE ALAN L')
  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.

N1056Ryan M-2 · S/N 18Oro Valley, AZN1058Ryan M-2 · S/N 19Oro Valley, AZN17480Aeronca LC · S/N 2059Oro Valley, AZN262HNew Standard D-25 · S/N 136Oro Valley, AZN284NAmerican Eagle E-430 · S/N 904Oro Valley, AZN313HNew Standard D-25 · S/N 130Oro Valley, AZN314AHRearwin 2000-CO · S/N 104Oro Valley, AZN427AEAlexander COMBINATION EAGLEROC · S/N 467Oro Valley, AZN4426WWaco PBF · S/N 3649Oro Valley, AZN505MRyan B-5 · S/N 228Oro Valley, AZN535HNew Standard D-25 · S/N 137Oro Valley, AZN625NWaco ASO · S/N B-3145Oro Valley, AZN699KWaco ASO · S/N 70Oro Valley, AZN703KWaco BSO · S/N A-163Oro Valley, AZN704KWaco BSO · S/N A-164Oro Valley, AZN7214Ryan B1 · S/N 39Oro Valley, AZN751KWaco BSO · S/N A-157Oro Valley, AZN823NEmsco B-3 · S/N 6Oro Valley, AZN8369Waco ASO · S/N A-73Oro Valley, AZN8540Waco ASO · S/N A-67Oro Valley, AZN9103New Standard D-25 · S/N 120Oro Valley, AZN9534Waco ASO · S/N A-29Oro Valley, AZN958HWaco BSO · S/N A-150Oro Valley, AZN959HWaco BSO · S/N A-149Oro Valley, AZ
Back to Hirtle Alan L