Lycoming O-360-J2A
Registered aircraft · 254
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 ('42314')
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 ('42314')
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.
N254SRJets To Helis LLC DBA · Chandler, AZN257RTRoyal Company Sd Inc · Black Hawk, SDN25DNNorris Marvin D · Georgetown, TXN266SHDirty Bird Helicopters LLC · Boerne, TXN26GACrosswind Leasing LLC · Prescott, AZN271SHVeracity Aviation LLC · Seguin, TXN273SHSpitzer Helicopter LLC · Woodland Hills, CAN276SHSpitzer Helicopter LLC · Woodland Hills, CAN278FKKoelbl Aviation LLC · Whitesboro, TXN278SHSmith Kenneth S Jr · Uvalde, TXN27EKPrecision Aviation Training LLC · Newberg, ORN290SHParker Helicopter LLC · Watsonville, CAN292BAPic LLC · Catano, PRN29EHRotary Run LLC · Zoar, OHN3004XNovember Alpha LLC · Dover, DEN300JMEmerald City Aircraft Leasing LLC · Port Orchard, WAN3019SSmith Jason E · Calliham, TXN301RWRegistered aircraftN301SHSpitzer Helicopter LLC · Wilmington, DEN3035FUtah State University · Logan, UTN3040KLeading Edge Flight Academy LLC · Bend, ORN304QAAltus Aviation Managment · Las Vegas, NVNon-citizen corporation, flight hours not reportedN304RQSpitzer Helicopter LLC · Wilmington, DEN3055NAarow Aircraft Leasing LLC · Mcminnville, ORN305NKKamasano LLC · Highland, CAN3067LT&G Aviation Services LLC · Temple, TXN3068NAlpine Air Aviation LLC · West Haven, UTN3070SMat-Su Helicopter Training LLC · Wasilla, AKN307AKRotor Rascals LLC · Anchorage, AKN3082CJets To Helis LLC DBA · Chandler, AZN3086TAlba Aviation Services Inc · Scottsdale, AZN3092XSilverhawk Aviation Academy LLC · Caldwell, IDN30CHSale Reported · Maiden, NCSale reported, pending cancellationN30ZYLewis Charles A · Winterville, NCN3104UNelson Christopher · Crown Point, INN31192Silverhawk Aviation Academy LLC · Caldwell, IDN31485Unusual Attitudes LLC · Bates City, MON3155YBult Equipment LLC · Monee, ILN315JFFuller Jon A · Goliad, TXN3179AEsslinger Jamie · Valley Center, CAN3189ZSilverhawk Aviation Academy LLC · Caldwell, IDN322RHRobinson Helicopter Co · Torrance, CAN331JArndt Brent · Kodiak, AKN338CTAv8 Flight Assets LLC · Eden Prairie, MNN3458Johnston Donald Trustee · Pickford, MIN345UHUhi Inc · Provo, UTN354MHMission Helicopters LLC · San Diego, CAN357LZAv8 Flight Assets LLC · Eden Prairie, MNN365PARotor Leasing LLC · Indianapolis, INN366PAPureflight Aviation Training LLC · Newberg, OR
Back to Lycoming O-360-J2A