OpenAirDocs.org
Xin Han Aviation LLC

Registered aircraft · 28

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 = 'XIN HAN AVIATION LLC' OR list_contains(g.other_registrant_names, 'XIN HAN AVIATION 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.

N114NPiper PA-44-180 · S/N 44-7995289Built 1979 · Atwater, CAN1632ECessna 172N · S/N 17271074Built 1978 · Atwater, CAN187TXPiper PA-44-180 · S/N 4496099Built 2001 · Atwater, CAN219TGPiper PA-34-200 · S/N 34-7250315Built 1972 · Atwater, CAN226JACessna 172M · S/N 17266688Built 1976 · Atwater, CAN25EFCessna 152 · S/N 15280552Built 1978 · Atwater, CAN2PWPiper PA-44-180 · S/N 44-7995087Built 1979 · Atwater, CAN355ABPiper PA-44-180 · S/N 4496093Built 2001 · Atwater, CAN3562DPiper PA-44-180 · S/N 44-8095014Built 1979 · Atwater, CAN369SPCessna 172M · S/N 17262809Helena, MTN4654BCessna 152 · S/N 15283564Built 1979 · Atwater, CAN49424Cessna 152 · S/N 15281255Built 1978 · Atwater, CAN4UNBellanca 7ECA · S/N 1324-79Built 1979 · Atwater, CAN51960Cessna 172P · S/N 17274384Built 1980 · Atwater, CAN5358DCessna 172N · S/N 17272543Built 1979 · Atwater, CAN539BCessna 152 · S/N 15283898Built 1979 · Atwater, CAN55134Piper PA-34-200 · S/N 34-7350177Built 1973 · Atwater, CAN5531HCessna 152 · S/N 15284118Built 1979 · Atwater, CAN62142Cessna 172P · S/N 17275218Built 1981 · Atwater, CAN6321PCessna 152 · S/N 15284999Built 1981 · Atwater, CAN6348BCessna 152 · S/N 15283924Built 1979 · Atwater, CAN6375DCessna 172N · S/N 17272761Built 1979 · Atwater, CAN64KABeech C90 · S/N LJ-606Built 1973 · Helena, MTN66ALPiper PA-44-180 · S/N 44-7995200Built 1978 · Atwater, CAN7600TCessna 172A · S/N 47200Built 1960 · Atwater, CAN93263Cessna 152 · S/N 15285451Built 1981 · Atwater, CAN978WCPiper PA-44-180 · S/N 4496041Built 2000 · Helena, MTN991ACPiper PA-44-180 · S/N 44-8095011Built 1979 · Randolph, MA
Back to Xin Han Aviation LLC