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.
N28027Cae Aviation Academy Phoenix LLC · Mesa, AZN28029Cae Aviation Academy Phoenix LLC · Mesa, AZN28030Cae Aviation Academy Phoenix LLC · Mesa, AZN28034Cae Aviation Academy Phoenix LLC · Mesa, AZN28043Cae Aviation Academy Phoenix LLC · Mesa, AZN28045Cae Aviation Academy Phoenix LLC · Mesa, AZN28051Cae Aviation Academy Phoenix LLC · Mesa, AZN28053Cae Aviation Academy Phoenix LLC · Mesa, AZN28065Cae Aviation Academy Phoenix LLC · Mesa, AZN28069Cae Aviation Academy Phoenix LLC · Mesa, AZN28086Cae Aviation Academy Phoenix LLC · Mesa, AZN28088Cae Aviation Academy Phoenix LLC · Mesa, AZN2809Piper Aircraft Inc · Vero Beach, FLN28090Cae Aviation Academy Phoenix LLC · Mesa, AZN28095Cae Oxford Aviation Academy Phoenix Inc · Mesa, AZN28096Cae Aviation Academy Phoenix LLC · Mesa, AZN28098Cae Aviation Academy Phoenix LLC · Mesa, AZN2813Piper Aircraft Inc · Vero Beach, FLN281BLWingsleasing LLC · Wichita, KSN282BLBlue Line Aviation LLC · Winter Haven, FLN283BLWingsleasing LLC · Wichita, KSN283ZAlpha Tango Aircraft LLC · Wilmington, DEN284BOpen Roads Complete Rv Service LLC · Acworth, GAN284BLBlue Line Aviation LLC · Smithfield, NCN284CHorizon Instruction LLC · Addison, TXN284FCapitan Hair LLC · Lubbock, TXN284HFour Hotel LLC · Olathe, KSN284LMullys Equipment Leasing LLC · Keizer, ORN284RMesa Aviation LLC · Mesa, AZN284SVpf Aircraft LLC · Cave Creek, AZN284UWest Texas Flyers Inc · Fredericksburg, TXN284VThree Daughters Aviation LLC · Fort Worth, TXN284WFAims Community College · Greeley, CON285BLWingsleasing LLC · Wichita, KSN285ZAlpha Tango Aircraft LLC · Wilmington, DEN287BLBlue Line Aviation LLC · Smithfield, NCN288BLBlue Line Aviation LLC · Smithfield, NCN288CBCalifornia Baptist University · Riverside, CAN28978Cae Aviation Academy Phoenix LLC · Mesa, AZN28979Cae Aviation Academy Phoenix LLC · Mesa, AZN289BLBlue Line Aviation LLC · Smithfield, NCN289STSml Aviation LLC · Parker, CON28KUIal Corp · Lewes, DEN28PPPiper Aircraft Inc · Vero Beach, FLN28STParagon Airplane Leasing Co · Fort Myers, FLN291CBCalifornia Baptist University · Riverside, CAN291LAPiper 3 LLC · Chestnut Ridge, NYN291LHChristiansen Aviation LLC · Wilmington, DEN291WCColorado Mesa University · Grand Junction, CON292JEEquinoxx Flight Systems LLC · Duluth, GA
Back to Lycoming IO-360-B4A