Epic Aviation Inc
Registered aircraft · 65
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 = 'EPIC AVIATION INC' OR list_contains(g.other_registrant_names, 'EPIC AVIATION 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.
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 = 'EPIC AVIATION INC' OR list_contains(g.other_registrant_names, 'EPIC AVIATION INC') 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.
N128BMCostruzioni Aeronautiche Tecna P2006T · S/N 356/USN2004UTextron 172S · S/N 172S13449N20067Textron 172S · S/N 172S13448N2007XTextron 172S · S/N 172S13447N2012FTextron 172S · S/N 172S13452N2013WTextron 172S · S/N 172S13451N2016FTextron 172S · S/N 172S13450N20EPTextron 172S · S/N 172S12513N217EPTextron 172S · S/N 172S12006N219EPPiper PA-44-180 · S/N 4496458N221EPTextron 172S · S/N 172S12621N226EPTextron 172S · S/N 172S13513N230EPTextron 172S · S/N 172S13092N231EPTextron 172S · S/N 172S13093N232EPTextron 172S · S/N 172S13095N233EPTextron 172S · S/N 172S13096N234EPTextron 172S · S/N 172S13098N235EPTextron 172S · S/N 172S13099N241EPTextron 172S · S/N 172S13238N242EPTextron 172S · S/N 172S13243N243EPTextron 172S · S/N 172S13281N244EPTextron 172S · S/N 172S13283N245EPTextron 172S · S/N 172S13284N251EPTextron 172S · S/N 172S13285N252EPTextron 172S · S/N 172S13286N253EPTextron 172S · S/N 172S13310N254EPTextron 172S · S/N 172S13315N255EPTextron 172S · S/N 172S13316N256EPTextron 172S · S/N 172S13317N257EPTextron 172S · S/N 172S13332N258EPTextron 172S · S/N 172S13334N259EPTextron 172S · S/N 172S13335N261EPTextron 172S · S/N 172S13501N263EPTextron 172S · S/N 172S13503N264EPTextron 172S · S/N 172S13504N268EPTextron 172S · S/N 172S13506N269EPTextron 172S · S/N 172S13509N278AGPiper PA-44-180 · S/N 4496506N319EPTextron 172S · S/N 172S12277N321EPTextron 172S · S/N 172S12622N322EPTextron 172S · S/N 172S12782N326EPTextron 172S · S/N 172S13515N386EPTextron 172S · S/N 172S12912N417EPPiper PA-44-180 · S/N 4496403N419EPTextron 172S · S/N 172S12278N4590JPiper PA-28R-180 · S/N 28R-30463N5012APiper PA-44-180 · S/N 4496044N521EPTextron 172S · S/N 172S12623N526EPTextron 172S · S/N 172S13524N618EPTextron 172S · S/N 172S12164
Back to Epic Aviation Inc