OpenAirDocs.org
Corsair Two LLC

Registered aircraft · 36

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

N116AACessna 525B · S/N 525B-0194Built 2007 · Hillsboro, ORN117AACanadair CL-600-2B16 · S/N 5060Built 1990 · Hillsboro, ORN149WWCessna 525B · S/N 525B0175Built 2007 · Hillsboro, ORN171AACessna 510 · S/N 510-0412Built 2012 · Hillsboro, ORN174AACessna 525B · S/N 525B0196Built 2007 · Hillsboro, ORN175AACessna 525B · S/N 525B0068Built 2006 · Hillsboro, ORN233TJTextron 525B · S/N 525B0525Built 2017 · Hillsboro, ORN253ALLearjet 45 · S/N 361Built 2008 · Hillsboro, ORN254ALLearjet 45 · S/N 283Built 2005 · Hillsboro, ORN291EAMcdonnell Douglas DC-9-87 · S/N 53039Built 1991 · Hillsboro, ORN292EAMcdonnell Douglas DC-9-87 · S/N 53208Built 1991 · Hillsboro, ORN293EAMcdonnell Douglas DC-9-87 (MD-87) · S/N 53209Built 1991 · Hillsboro, ORN294EAMcdonnell Douglas DC-9-87 · S/N 53210Built 1991 · Hillsboro, ORN295EAMcdonnell Douglas DC-9-87 · S/N 53211Built 1991 · Hillsboro, ORN296EAMcdonnell Douglas DC-9-87 · S/N 53212Built 1991 · Hillsboro, ORN297EAMcdonnell Douglas DC-9-87 · S/N 53213Built 1991 · Hillsboro, ORN394CMCessna 510 · S/N 510-0394Built 2012 · Hillsboro, ORN401USDouglas DC-7 · S/N 45145Built 1957 · Hillsboro, ORN530LMRaytheon B200 · S/N BB1678Built 1999 · Hillsboro, ORN531LMRaytheon B200 · S/N BB1852First renewal noticeHillsboro, ORN532LMHawker Beechcraft B200 · S/N BB-1996Built 2007 · Hillsboro, ORN541LMRaytheon B200 · S/N BB-1899Built 2005 · Hillsboro, ORN544LMGates Learjet 35A · S/N 500Built 1983 · Hillsboro, ORN557LMLearjet 45 · S/N 379Built 2008 · Hillsboro, ORN558LMLearjet 45 · S/N 312Built 2006 · Hillsboro, ORN559LMLearjet 45 · S/N 286Built 2005 · Hillsboro, ORN560LMLearjet 45 · S/N 288Built 2005 · Hillsboro, ORN61HHCessna 510 · S/N 510-0393Built 2011 · Hillsboro, ORN6353CDouglas DC-7 · S/N 45486Built 1958 · Hillsboro, ORN741MMCessna 525C · S/N 525C0039Built 2011 · Hillsboro, ORN838DDouglas DC-7B · S/N 45347Built 1958 · Hillsboro, ORN910GFCessna 510 · S/N 510-0425Built 2012 · Hillsboro, ORN913DEMcdonnell Douglas MD-88 · S/N 49956Built 1993 · Hillsboro, ORN93LEGates Learjet 35A · S/N 592Hillsboro, ORN950NSMcdonnell Douglas DC-9-83(MD-83) · S/N 53023Built 1991 · Hillsboro, ORN990DLMcdonnell Douglas MD-88 · S/N 53342Built 1991 · Hillsboro, OR
Back to Corsair Two LLC