Life Flight Network LLC
Registered aircraft · 53
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 = 'LIFE FLIGHT NETWORK LLC' OR list_contains(g.other_registrant_names, 'LIFE FLIGHT NETWORK 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 = 'LIFE FLIGHT NETWORK LLC' OR list_contains(g.other_registrant_names, 'LIFE FLIGHT NETWORK 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.
N110DJBell Textron Canada 407 · S/N 56371N126TSPilatus PC-12/47E · S/N 1111N164SPilatus PC-12/47E · S/N 1164N214NXPilatus PC-12/47E · S/N 1214N401LFBell Helicopter Textron Canada 407 · S/N 54865N402LFBell Helicopter Textron Canada 407 · S/N 54867N403LFBell Textron Canada 407 · S/N 54886N405LFBell Textron Canada 407 · S/N 54905N406LFBell Textron Canada 407 · S/N 54977N408LFBell Textron Canada 407 · S/N 54978N409LFBell Textron Canada 407 · S/N 56331N410LFBell Textron Canada 407 · S/N 56332N411LFBell Textron Canada 407 · S/N 56333N412LFBell Textron Canada 407 · S/N 56342N414LFBell Textron Canada 407 · S/N 56343N424LFBell Textron Canada 407 · S/N 56383N429LFBell Textron Canada 429 · S/N 57386N430LFBell Textron Canada 429 · S/N 57392N431LFBell Textron Canada 429 · S/N 57399N432LFBell Textron Canada 429 · S/N 57406N433LFBell Textron Canada 429 · S/N 57484N435LFAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21232N441LFBell Textron Canada 407 · S/N 56344N443LFBell Textron Canada 407 · S/N 56354N445LFBell Textron Canada 407 · S/N 56355N448LFBell Textron Canada 407 · S/N 56359N449LFBell Textron Canada 407 · S/N 56360N450LFBell Textron Canada 407 · S/N 56352N451LFBell Textron Canada 407 · S/N 56384N452LFBell Textron Canada 407 · S/N 56380N453LFBell Textron Canada 407 · S/N 56382N455LFBell Textron Canada 407 · S/N 56418N456LFBell Textron Canada 407 · S/N 56416N457LFBell Helicopter Textron Canada 407 · S/N 54592N458LFBell Textron Canada 407 · S/N 56468N462LFBell Textron Canada 407 · S/N 56460N463LFBell Textron Canada 407 · S/N 56464N617BGPilatus PC-12/47E · S/N 1253N660LFPilatus PC-12/47E · S/N 1347N661LFPilatus PC-12/47E · S/N 1505N662LFPilatus PC-12/47E · S/N 1587N664LFPilatus PC-12/47E · S/N 1655N667LFPilatus PC-12/47E · S/N 1796N668LFPilatus PC-12/47E · S/N 1893N670LFPilatus PC-12/47E · S/N 1695N840LFAirbus Helicopters Deutschland EC135 P2+ · S/N 1114N843LFAirbus Helicopters Deutschland MBB-BK 117 D-2 · S/N 20219N844LFAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21229N847LFEurocopter Deutschland EC 135 P2+ · S/N 0534N850LFAirbus Helicopters EC135 P3 · S/N 2358
Back to Life Flight Network LLC