Ep Aviation LLC
Earlier aircraft under this name · 39
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'EP AVIATION LLC' OR list_contains(d.other_registrant_names, 'EP AVIATION LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'EP AVIATION LLC' OR list_contains(d.other_registrant_names, 'EP AVIATION LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N1269JCASA CN235 · S/N 012N603AREADS CASA C-212-CC-15 AVIOCAR · S/N 162N3540RBell 214ST · S/N 28110N870ALSikorsky S-76C · S/N 760606N634ARDehavilland DHC-8-103 · S/N 003N330KWS N I A S SA330J · S/N 1418N635ARDehavilland DHC-8-103 · S/N 047N823LBSikorsky S-76C+ · S/N 760481N830CASikorsky S-76C · S/N 760545N261FSikorsky S-61N · S/N 61771N408HHSikorsky S-61N · S/N 61716N830DZSikorsky S-76C · S/N 760591N103WFSikorsky S-61N · S/N 61766N612RMSikorsky S-61N · S/N 61744N802ARSikorsky S-61N · S/N 61757N636ARBoeing / Dehavilland DHC-8-103 · S/N 086N963BWConstrucciones Aeronauticas C-212-CC · S/N 320N2258FBell 412 · S/N 33073N21498Bell 412 · S/N 36003N107XBell 412 · S/N 33113N810ARSikorsky S-61N · S/N 61740N956BWFairchild SA227-DC · S/N DC864BN955BWFairchild SA227-DC (C26B) · S/N DC821BN805ARSikorsky S-61N · S/N 61717N3893LBell 412 · S/N 33006N8045TBell 214ST · S/N 28101N10241Aerospatiale SA330J · S/N 1472N982BWCASA CN-235-10 · S/N C010N380SAAerospatiale SA330J · S/N 1422N5748MBell 214ST · S/N 28102N126PABell 412 · S/N 33168N22608Bell 412 · S/N 33075N2261DBell 412 · S/N 33076N108XBell 412 · S/N 33115N1202TBell 412 · S/N 33112N3893NBell 412 · S/N 33010N33008Bell 412 · S/N 36004N2149SBell 412 · S/N 36002N7128RBell 412 · S/N 36007
Back to Ep Aviation LLC