Lycoming IO-540-EXP
Registered aircraft · 70
Aircraft with this engine in the FAA registry, by N-number.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('42167')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('42167')
ORDER BY n_numberRun 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.
N781SSullivan Steven · Diboll, TXN784WBDawkins Stephen D · Dallas, TXN7877MReed Mike · Caldwell, IDN787RVLooloian James W · Glen Mills, PAN79775Clark John Travis · Elbert, CON822MGRueger Jodi · Redondo Beach, CAN827MMSmooth Air LLC · Camas, WAN82CHN82ch LLC · Evergreen, CON845WWallace Air Holdings LLC · Anchorage, AKN8925Jankowski Richard S · Shenandoah, TXN896JMPhillips James · Belgrade, MTN8XGFilarsky Bruce · Winters, CAN902ECRegistered aircraftN918JKStone James R · Port Orange, FLN91DRRonneberg Dave · Santa Monica, CAN921ACRegistration Pending · Santa Cruz, CARegistration pendingN923FBViperbear LLC · Livingston, TXN929EHSoaring LLC · Auburn, CAN953KMMorris J Kenneth · Mckinney, TXN991RVFrosty Acres LLC · Hailey, ID
Back to Lycoming IO-540-EXP