OpenAirDocs.org
Airmart Inc

Registered aircraft · 16

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 = 'AIRMART INC' OR list_contains(g.other_registrant_names, 'AIRMART INC')
  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.

N157BABeech A36 · S/N E-2339Built 1986 · Lexington, KYN161TFPiper PA-28-181 · S/N 2881549Built 2022 · Lexington, KYN204GRaytheon 58 · S/N TH-2042Lexington, KYN216AMPiper PA-28-181 · S/N 2881092Lexington, KYN232TFPiper PA-28-181 · S/N 2881550Built 2022 · Lexington, KYN357KFCessna 182S · S/N 18280189Built 1998 · Lexington, KYN36965Raytheon G36 · S/N E-3665Lexington, KYN424TFPiper PA-28-181 · S/N 2881552Built 2022 · Lexington, KYN429MBeechcraft G58 · S/N TH-2422Built 2014 · Lexington, KYN43711Piper PA-28-151 · S/N 28-7415562Built 1974 · Lexington, KYN450TFCessna LC41-550FG · S/N 411025Built 2008 · Lexington, KYN469TFPiper PA-28-181 · S/N 2881592Built 2022 · Lexington, KYN478MDPiper PA-32R-301T · S/N 3257376Built 2005 · Lexington, KYN613SPCessna 172S · S/N 172S8597Built 2000 · Lexington, KYN619AMPiper PA-28-181 · S/N 2881093Lexington, KYN7CMTextron G36 · S/N E-4091Built 2016 · Lexington, KY
Back to Airmart Inc