Registered aircraft · 21

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

N207RHBell 206L-3 · S/N 51495Built 1991 · Yuma, AZ N2254YDJI AGRAS T40 · S/N 64TBL5H00200GMYuma, AZ N2256QDJI AGRAS T40 · S/N 64TBL5800200Z8Yuma, AZ N2257FDJI AGRAS T40 · S/N 64TBL5A0020050Yuma, AZ N3095XAyres S2R-T34 · S/N T34-174Built 1991 · Yuma, AZ N374ZMDJI AGRAS T50 · S/N 64TBL9C0020045Yuma, AZ N3839PPiper PA-22-150 · S/N 22-3529Built 1955 · Yuma, AZ N396RLBell Helicopter Textron 206L-1 · S/N 45-396Built 1980 · Yuma, AZ N40110Ayres S2R-T34 · S/N 6022Built 1979 · Yuma, AZ N4012GAyres S2R-R3S · S/N R3S-001Yuma, AZ N40175Ayres S2R-T34 · S/N T34-004Built 1979 · Yuma, AZ N4687ACessna 180 · S/N 32284Yuma, AZ N4982MDJI AGRAS T50 · S/N 63YBLCF002000AYuma, AZ N5233MDJI AGRAS T50 · S/N 63YWN5E00226DKYuma, AZ N5451MDJI AGRAS T100 · S/N 1581F8ZL-C258P00259DYuma, AZ N5452MDJI AGRAS T100 · S/N 1581F8ZL-C258K002951NYuma, AZ N5687XAyres S-2R · S/N 2394RBuilt 1977 · Yuma, AZ N5696XRockwell International S-2R · S/N 2388RBuilt 1977 · Yuma, AZ N6121MStinson 108-3 · S/N 108-4121Yuma, AZ N8042YAir Tractor AT-802A · S/N 802A-0691Built 2017 · Yuma, AZ N8653YPiper PA-18-150 · S/N 18-7309024Yuma, AZ

Back to Morris Equipment LLC