Republic Airways Inc

Registered aircraft · 170

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

N101HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000156Built 2007 · Carmel, INN102HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000157Built 2007 · Carmel, INN103HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000159Built 2007 · Carmel, INN104HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000160Built 2007 · Carmel, INN105HQEmbraer ERJ 170-200 LR · S/N 17000163Built 2007 · Carmel, INN106HQEmbraer ERJ 170-200 LR · S/N 17000164Built 2007 · Carmel, INN107HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000165Built 2007 · Carmel, INN108HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000166Built 2007 · Carmel, INN109HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000168Built 2007 · Carmel, INN110HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000172Built 2007 · Carmel, INN111HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000173Built 2007 · Carmel, INN112HQEmbraer ERJ 170-200 LR · S/N 17000174Built 2007 · Carmel, INN113HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000177Built 2007 · Carmel, INN114HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000179Built 2007 · Carmel, INN115HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000182Built 2007 · Carmel, INN116HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000183Built 2007 · Carmel, INN117HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000184Built 2007 · Carmel, INN118HQEmbraer ERJ 170-200 LR · S/N 17000189Built 2007 · Carmel, INN119HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000190Built 2007 · Carmel, INN120HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000193Built 2007 · Carmel, INN121HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000194Built 2007 · Carmel, INN122HQEmbraer ERJ 170-200 LR · S/N 17000196Built 2007 · Carmel, INN123HQEmbraer ERJ 170-200 LR · S/N 17000199Built 2007 · Carmel, INN124HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000200Built 2007 · Carmel, INN125HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000202Built 2007 · Carmel, INN126HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000204Built 2008 · Carmel, INN127HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000206Built 2008 · Carmel, INN128HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000208Built 2008 · Carmel, INN129HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000211Built 2008 · Carmel, INN130HQEmbraer ERJ 170-200 LR · S/N 17000212Built 2008 · Carmel, INN131HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000215Built 2008 · Carmel, INN132HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000216Built 2008 · Carmel, INN133HQEmbraer ERJ 170-200 LR · S/N 17000217Built 2008 · Carmel, INN134HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000220Built 2008 · Carmel, INN135HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000224Built 2008 · Carmel, INN136HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000228Built 2008 · Carmel, INN137HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000231Built 2008 · Carmel, INN138HQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000234Built 2008 · Carmel, INN201JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000235Built 2008 · Carmel, INN202JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000240Built 2008 · Carmel, INN203JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000242Built 2008 · Carmel, INN204JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000243Built 2008 · Carmel, INN205JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000248Built 2008 · Carmel, INN206JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000249Built 2008 · Carmel, INN207JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000254Built 2008 · Carmel, INN208JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000257Built 2008 · Carmel, INN209JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000258Built 2008 · Carmel, INN210JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000260Built 2008 · Carmel, INN211JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000261Built 2008 · Carmel, INN212JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000264Built 2008 · Carmel, IN
Back to Republic Airways Inc