OpenAirDocs.org
Yr-Aircraft Leasing LLC

Registered aircraft · 20

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 = 'YR-AIRCRAFT LEASING LLC' OR list_contains(g.other_registrant_names, 'YR-AIRCRAFT LEASING LLC')
  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.

N18NTDehavilland DHC-2 MK. I(L20A) · S/N 222Built 1952 · Bethel, AKN23CFCessna 207 · S/N 20700276Built 1974 · Bethel, AKN327CTCessna 207A · S/N 20700535Built 1979 · Bethel, AKN4112DPiper PA-31-350 · S/N 31-8353004Bethel, AKN4112EPiper PA-31-350 · S/N 31-8353005Built 1982 · Bethel, AKN41189Piper PA-31-350 · S/N 31-8553002Built 1984 · Bethel, AKN4118GPiper PA-31-350 · S/N 31-8453001Built 1984 · Bethel, AKN5277JCessna 207A · S/N 20700772Built 1984 · Bethel, AKN6207HCessna 207A · S/N 20700551Built 1979 · Bethel, AKN7320UCessna 207A · S/N 20700397Built 1977 · Bethel, AKN7340UCessna 207A · S/N 20700407Built 1977 · Bethel, AKN73454Cessna 172M · S/N 17267472Built 1976 · Soldotna, AKN7373UCessna 207A · S/N 20700423Built 1977 · Bethel, AKN7389UCessna 207A · S/N 20700432Built 1978 · Bethel, AKN747SQCessna 207A · S/N 20700387Built 1977 · Bethel, AKN91002Cessna 207 · S/N 20700003Built 1969 · Bethel, AKN916ACCessna 207 · S/N 20700061Built 1979 · Bethel, AKN9794MCessna 207A · S/N 20700730Built 1981 · Bethel, AKN9869MCessna 207A · S/N 20700744Built 1981 · Bethel, AKN9996MCessna 207A · S/N 20700779Built 1984 · Bethel, AK
Back to Yr-Aircraft Leasing LLC