Registered aircraft · 26

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 = 'LRH EQUIPMENT LLC' OR list_contains(g.other_registrant_names, 'LRH EQUIPMENT LLC') 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 = 'LRH EQUIPMENT LLC' OR list_contains(g.other_registrant_names, 'LRH EQUIPMENT 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.

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 = 'LRH EQUIPMENT LLC' OR list_contains(g.other_registrant_names, 'LRH EQUIPMENT LLC')
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.

N1219TPiper PA-34-200 · S/N 34-7250265Built 1972 · Pendleton, OR N121PTBell UH-1H · S/N 64-13711Built 1964 · Pendleton, OR N171HHEnstrom F-28F · S/N 758Built 1988 · Pendleton, OR N2019HEnstrom 280FX · S/N 2019Pendleton, OR N280MWEnstrom F-28F · S/N 743Pendleton, OR N3463LCessna TU206B · S/N U206-0763Built 1966 · Pendleton, OR N41109Bell UH-1H · S/N 11968Pendleton, OR N41909Bell UH-1H · S/N 7321809Pendleton, OR N4210Enstrom F-28C · S/N 421Pendleton, OR N43498Taylorcraft BC12-D · S/N 7157Pendleton, OR N51770Enstrom F-28C · S/N 445Pendleton, OR N544HEnstrom F-28C · S/N 335Pendleton, OR N5698EEnstrom F-28F · S/N 506-2Pendleton, OR N5699UEnstrom F-28F · S/N 511Pendleton, OR N6093FCessna 182P · S/N 18264108Built 1975 · Pendleton, OR N666MDEnstrom F-28C · S/N 338Pendleton, OR N703NPBell UH-1H · S/N 69-15602Built 1969 · Pendleton, OR N730HEnstrom F-28F · S/N 730Pendleton, OR N7545BChampion 7FC · S/N 7FC-48Built 1957 · Pendleton, OR N762AEnstrom F-28F · S/N 762Built 1989 · Pendleton, OR N7865DPiper PA-18-150 · S/N 18-6014Built 1957 · Pendleton, OR N8620CEnstrom F-28F · S/N 706Pendleton, OR N86239Enstrom 280FX · S/N 2008Pendleton, OR N8623BEnstrom F-28F · S/N 728Built 1982 · Pendleton, OR N9077Enstrom F-28A · S/N 186Built 1974 · Pendleton, OR N9378UCessna 150M · S/N 15078327Built 1976 · Pendleton, OR

Back to Lrh Equipment LLC