OpenAirDocs.org
Meridian Aircraft LLC

Registered aircraft · 35

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

N104AAPiper PA-28-181 · S/N 2881573Built 2022 · Wilmington, DEN219APiper PA-28-181 · S/N 2843788Built 2014 · Wilmington, DEN220CEPiper PA-28-181 · S/N 2881530Built 2022 · Wilmington, DEN220WXPiper PA-28-181 · S/N 2881540Built 2022 · Wilmington, DEN221EFPiper PA-28-181 · S/N 2881541Built 2022 · Wilmington, DEN221TUPiper PA-28-181 · S/N 2881531Built 2022 · Wilmington, DEN222MNPiper PA-28-181 · S/N 2881532Built 2022 · Wilmington, DEN223GHPiper PA-28-181 · S/N 2881542Wilmington, DEN223YZPiper PA-28-181 · S/N 2881536Built 2022 · Wilmington, DEN224VWPiper PA-28-181 · S/N 2881533Built 2022 · Wilmington, DEN225FGPiper PA-28-181 · S/N 2881569Built 2022 · Wilmington, DEN225KLPiper PA-28-181 · S/N 2881534Built 2022 · Wilmington, DEN225RSPiper PA-28-181 · S/N 2881543Built 2022 · Wilmington, DEN226DFPiper PA-28-181 · S/N 2881535Built 2022 · Wilmington, DEN226STPiper PA-28-181 · S/N 2881570Built 2022 · Wilmington, DEN227JKPiper PA-28-181 · S/N 2881537Built 2022 · Wilmington, DEN227PQPiper PA-28-181 · S/N 2881544Built 2022 · Wilmington, DEN227XYPiper PA-28-181 · S/N 2881571Built 2022 · Wilmington, DEN228QRPiper PA-28-181 · S/N 2881538Built 2022 · Wilmington, DEN228UVPiper PA-28-181 · S/N 2881568Built 2022 · Wilmington, DEN229ABPiper PA-28-181 · S/N 2881539Built 2022 · Wilmington, DEN229LMPiper PA-28-181 · S/N 2881572Built 2022 · Wilmington, DEN261APiper PA-28-181 · S/N 2843789Built 2014 · Wilmington, DEN326CCPiper PA-28-181 · S/N 2881575Built 2022 · Wilmington, DEN472DDPiper PA-28-181 · S/N 2881576Built 2022 · Wilmington, DEN514EEPiper PA-28-181 · S/N 2881577Built 2022 · Wilmington, DEN551BBPiper PA-28-181 · S/N 2881574Built 2022 · Wilmington, DEN724APiper PA-28-181 · S/N 2843790Built 2014 · Wilmington, DEN728APiper PA-28-181 · S/N 2843791Built 2014 · Wilmington, DEN730APiper PA-28-181 · S/N 2843792Built 2014 · Wilmington, DEN768APiper PA-28-181 · S/N 2843793Built 2014 · Wilmington, DEN769APiper PA-28-181 · S/N 2843794Built 2014 · Wilmington, DEN792APiper PA-28-181 · S/N 2843795Built 2014 · Wilmington, DEN793APiper PA-28-181 · S/N 2843796Built 2014 · Wilmington, DEN794APiper PA-28-181 · S/N 2843797Built 2014 · Wilmington, DE
Back to Meridian Aircraft LLC