OpenAirDocs.org
State Of Louisiana

Registered aircraft · 18

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 = 'STATE OF LOUISIANA' OR list_contains(g.other_registrant_names, 'STATE OF LOUISIANA')
  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.

N101AFCessna 182T · S/N 18281181Built 2003 · Baton Rouge, LAN232AFCessna 182T · S/N 18281180Built 2003 · Baton Rouge, LAN241AFCessna 182T · S/N 18281182Built 2003 · Baton Rouge, LAN252AFCessna 182T · S/N 18281185Built 2003 · Baton Rouge, LAN261AFCessna 182T · S/N 18281186Built 2003 · Baton Rouge, LAN262AFCessna 182T · S/N 18281187Built 2003 · Baton Rouge, LAN269SPBell UH-1V · S/N 7422430Baton Rouge, LA · Co-owner with Department Of Public SafetyN281AFCessna 182T · S/N 18281189Built 2003 · Baton Rouge, LAN302AFCessna 182T · S/N 18281190Built 2003 · Baton Rouge, LAN382AFCessna 182T · S/N 18281192Built 2003 · Baton Rouge, LAN430MCessna 182R · S/N 18268250Baton Rouge, LAN522AFCessna 182T · S/N 18281195Built 2003 · Baton Rouge, LAN64034Cessna 172P · S/N 17275507Built 1981 · Baton Rouge, LAN670SPBell UH-1H · S/N 7422478First renewal noticeBaton Rouge, LA · Co-owner with Department Of Public SafetyN67183Bell 206B · S/N 5120Built 1993 · Baton Rouge, LAN811AFCessna 182T · S/N 18281196Built 2003 · Baton Rouge, LAN812AFCessna 182T · S/N 18281197Built 2003 · Baton Rouge, LAN904HBBeech C90A · S/N LJ-1256Built 1990 · Baton Rouge, LA
Back to State Of Louisiana