Lycoming O-320-B2B
Registered aircraft · 92
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 ('42138')
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 ('42138')
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.
N57TPSheradin Daniel R · Roxboro, NCN59WDHorner Michael W · Manakin Sabot, VAN5FNM J S Corp · Howe, INN618DVVance Donn D · Monterey, TNN62BRRudolph Robert E · Martinez, CAN6535HAerial Sign North Inc · Lakewood, NJN689MAN28179 Inc · West Gilgo Beach, NYN7067DBlack C Dianne · Wayne, NJN7139KCool Tail Draggers LLC · Red Oak, IAN717YCNess Richard Scott · Escanaba, MIN71GKMetsger J Grant · Granbury, TXN71ZZPlum South Aircraft LLC · Abbeville, SCN7426ZKeystone Aviation LLC · Anchorage, AKN743RKiskaddon Luke M · Anchorage, AKN74NANelson Kenneth · Caledonia, WIN757USPeasley Robert E · Lonsdale, MNN769ATTarragon Aircraft USA LLC · Pekin, ILN778AKStaudinger Garret J · Eagle River, AKN7847Light John William · Anchorage, AKN798AKHunter David S · Wasilla, AKN814TJMaiorana Anthony J · Clarkston, WAN81PCNimbus Aviation LLC · Ponte Vedra Beach, FLN824KJJohnson Kelly L · San Jose, CAN82980Grier Timothy R · Anchorage, AKN82990Lavigne Bruce G · Ranier, MNN831LBWedekemper Steven E · Brighton, MIN8561VParatus Air Inc · Auburn, INN8568CCavanaugh Darrel N · Wasilla, AKN877DGDaigle Sean · North Pole, AKN878MAAgri Med LLC · Belgrade, MTN8792DAndresen Elouise H · Anchorage, AKN87XPSutherland Brian · Nolensville, TNN88497Airspace Aerial Media LLC · Saint Louis, MON8921DPetterson Jason G · Albert Lea, MNN8965LWeber Daniel M · Oconomowoc, WIN907FVGuthrie Richard A · Anchorage, AKN907HHarding Jason I · Wasilla, AKN907SCCrowe Talmadge Layne Jr · Anchorage, AKN956RHHuston Ben E · Sanger, TXN9575DLaird Cristina R · Fairbanks, AKN9696XCurrier Dustan A L · Fairbanks, AKN9908DJb Aviation · Red Bluff, CA
Back to Lycoming O-320-B2B