Lycoming IO-360-B4A
Registered aircraft · 1,000
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 ('41867')
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 ('41867')
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.
N249CBCalifornia Baptist University · Riverside, CAN249JAEagle Aviation LLC · Indianapolis, INN249MGGeorgia Aviation Authority · Eastman, GAN250FMParagon Airplane Leasng Co · Fort Myers, FLN251TCTexas State Technical College · Waco, TXN253JAYale Companies LLC DBA · Indianapolis, INN254AGSkywest Leasing Inc · St George, UTN254JAAlpha Aviation LLC · Indianapolis, INN255CBZions Credit Corp · Salt Lake City, UTN255SKParagon Airplane Leasing Co · Fort Myers, FLN256FAFly Gateway Aviation Institute · New Castle, DEN256ZAlpha Tango Aircraft LLC · Wilmington, DEN257FAFly Gateway Aviation Institute · New Castle, DEN257TFAir Fleet Holdings LLC · Missoula, MTN257ZAlpha Tango Aircraft LLC · Wilmington, DEN258CACoast Flight Training And Management Inc · San Diego, CAN259CBCalifornia Baptist University · Riverside, CAN25EVPiper Aircraft Inc · Vero Beach, FLN25LCParagon Airplane Leasing Co · Fort Myers, FLN260FAStratus Rr LLC · New Castle, DEN260UBoard Of Regents Of The University Of Oklahoma · Norman, OKN261BWPiper Aircraft Inc · Vero Beach, FLN261FAStratus Rr LLC · New Castle, DEN262CBCalifornia Baptist University · Riverside, CAN264AAFf22 LLC · Scottsdale, AZN264FAStratus Rr LLC · New Castle, DEN265FAStratus Rr LLC · New Castle, DEN265TWYale Companies LLC DBA · Indianapolis, INN266AAFf22 LLC · Scottsdale, AZN266FAStratus Rr LLC · New Castle, DEN269KMParagon Airplane Leasing Co · Fort Myers, FLN270SMAims Community College · Greeley, CON271AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN271HWHot Wings Aviation LLC · Fishers, INN272CBCalifornia Baptist University · Riverside, CAN272HWHot Wings Aviation LLC · Fishers, INN274MAHot Wings Aviation LLC · Fishers, INN274ZAlpha Tango Aircraft LLC · Wilmington, DEN275AMAerodynamic LLC · Aurora, ORN275CBCalifornia Baptist University · Riverside, CAN275FAFly Gateway Aviation Institute · New Castle, DEN276AGSkywest Leasing Inc · St George, UTN276JAYale Companies LLC DBA · Fishers, INN276ZAlpha Tango Aircraft LLC · Wilmington, DEN277LGAb Prop Plane I LLC · Metairie, LAN27TUConard John C · Minnetonka, MNN28011Cae Aviation Academy Phoenix LLC · Mesa, AZN28015Cae Aviation Academy Phoenix LLC · Mesa, AZN28017Cae Aviation Academy Phoenix LLC · Mesa, AZN28020Cae Aviation Academy Phoenix LLC · Mesa, AZ
Back to Lycoming IO-360-B4A