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.
N370PAMmm Equities LLC · Navasota, TXN371PABeta Fleet LLC · South Burlington, VTN382ASAero Leasing · Brookings, ORN400HG5sfcapital Holdings LLC · Newark, DEN401SHBeta Fleet LLC · South Burlington, VTN4023TSky Helicopters Inc · Desoto, TXN4037GN4037g LLC · Lecanto, FLN403LLTech Heli LLC · Fort Lauderdale, FLN403SHAustin Peay State University · Clarksville, TNN4047NSilverhawk Aviation Academy LLC · Caldwell, IDN4056BTesar Thomas J · Williamsport, TNN4058CHolt Tommy · Big Lake, TXN4059MTcwh Inc · Hachita, NMN408HCFarview Holdings LLC · San Francisco, CAN40YRHelicopter Services LLC · Cheyenne, WYN412TLDelta Leasing Inc DBA · Chandler, AZN41338Andrews Limited LLC · Flint, MIN4138GUtah State University · Logan, UTN41395Vera Aviation LLC · Mountain Home, IDN4148UFlightline Helicopters Inc · Cave Creek, AZFirst renewal noticeN416SHLa Calosa Ranch LLC · Falfurrias, TXN4170MMn Helicopters Inc · Minneapolis, MNN4171JAlyeska Helicopters LLC · Girdwood, AKN4174GCaldwell Farms Inc · Garnett, KSN417LSUniversity Of Maryland Eastern Shore · Princess Anne, MDN422MHHood Helicopters LLC · Wilmington, DEN424SFJets To Helis LLC DBA · Chandler, AZN432LELeading Edge Flight Academy LLC · Bend, ORN444CRUtah State University · Logan, UTN4468TSpitzer Helicopter LLC · Wilmington, DEN4471NSpitzer Helicopter LLC · Wilmington, DEN4472DSky Helicopters Inc · Desoto, TXN4476VDirty Bird Helicopters LLC · Boerne, TXN44UHAlba Leasing Services LLC · Scottsdale, AZN45329Marino Jack C Sr · Gause, TXN456PAH&H Helicopter LLC · Sauget, ILFirst renewal noticeN456UHAlba Leasing Services LLC · Scottsdale, AZN456ZRedpole2 LLC · Kalispell, MTN457PAIdeal Aviation Illinois LLC · Sauget, ILN460LELeading Edge Flight Academy LLC · Bend, ORN4684SVeracity Aviation LLC · Seguin, TXN472SHMelvin Robert J · Punta Gorda, FLN476ATAirmen Testing And Training Inc · Lantana, FLN476SHT2 Aeronautical Service LLC · Corpus Christi, TXN478SHAmigo Helicopter Services LLC · Falfurrias, TXN479SHParker Helicopter LLC · Watsonville, CAN47CDRs Aviation Services · Moorpark, CAN483NMCao Roger · Tomball, TXN484EPureflight Aviation Training LLC · Newberg, ORN484JLAustin Peay State University · Clarksville, TN
Back to Lycoming O-360-J2A