Registered aircraft · 32

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 = 'NS AIR LEASING LLC' OR list_contains(g.other_registrant_names, 'NS AIR LEASING 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 = 'NS AIR LEASING LLC' OR list_contains(g.other_registrant_names, 'NS AIR LEASING 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 = 'NS AIR LEASING LLC' OR list_contains(g.other_registrant_names, 'NS AIR LEASING 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.

N100RMSikorsky UH-60A · S/N 84-23935Wilmington, DE N1144CSikorsky UH-60A · S/N 84-23977Built 1984 · Wilmington, DE N114NSAirbus Helicopters AS 350B3 · S/N 7866Wilmington, DE N1308TAirbus Helicopters EC 130 T2 · S/N 8193Built 2016 · Wilmington, DE N1309TAirbus Helicopters EC 130 T2 · S/N 8215Built 2016 · Wilmington, DE N1314TAirbus Helicopters EC 130 T2 · S/N 8217Built 2016 · Wilmington, DE N139JHAirbus Helicopters EC 130 T2 · S/N 8596Built 2018 · Wilmington, DE N16NSEurocopter AS 350 B3 · S/N 7383Wilmington, DE N202SCAerospatiale AS355F TWINSTAR · S/N 5204Built 1982 · Wilmington, DE N2171CEurocopter AS 350 B3 · S/N 3427Built 2001 · Wilmington, DE N217HPEurocopter AS 350 B3 · S/N 3628Built 2002 · Wilmington, DE N22SEEurocopter AS350BB · S/N 2986Wilmington, DE N26HXEurocopter AS 350 B3 · S/N 4385Built 2007 · Wilmington, DE N318MGAmerican Eurocopter AS350B3 · S/N 7473Built 2012 · Wilmington, DE N320PAEurocopter AS 350 B2 · S/N 2143Built 1988 · Wilmington, DE N337ACAirbus Helicopters AS 350B3 · S/N 8180Built 2016 · Wilmington, DE N350HQEurocopter AS 350 B3 · S/N 3404Built 2001 · Wilmington, DE N352REurocopter AS 350 B3 · S/N 3664Built 2002 · Wilmington, DE N353FBEurocopter AS 350 B3 · S/N 3926Built 2005 · Wilmington, DE N355NSAirbus Helicopters AS355N · S/N 5682Wilmington, DE N359PAEurocopter France AS 350 B3 · S/N 3329Built 2000 · Wilmington, DE N568AEAmerican Eurocopter AS350B3 · S/N 7647Built 2013 · Wilmington, DE N57954Aerospatiale AS350BA · S/N 1127Built 1979 · Wilmington, DE N596MSAerospatiale AS350BA · S/N 1884Built 1988 · Wilmington, DE N62MSEurocopter AS350BB · S/N 3022Wilmington, DE N708HPEurocopter AS 350 B3 · S/N 3244Built 1999 · Wilmington, DE N806MPAmerican Eurocopter AS350B3 · S/N 4504Built 2008 · Wilmington, DE N82769American Eurocopter AS350B3 · S/N 7718Built 2013 · Wilmington, DE N830PAAirbus Helicopters AS 350B3 · S/N 8029Built 2014 · Wilmington, DE N855PAEurocopter AS 350 B3 · S/N 3304Built 2000 · Wilmington, DE N91NSEurocopter AS 350 B3 · S/N 7035Built 2010 · Wilmington, DE N99523Eurocopter AS 350 B3 · S/N 3461Built 2001 · Wilmington, DE

Back to Ns Air Leasing LLC