Skip to content

Registered aircraft · 43

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 ('30168')
  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 ('30168')
ORDER BY n_number

Run 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.

N112HCHail Helicopter Holdings-Unit 3 LLC · Tulsa, OKBuilt 1979 · S/N 77-22728 N116ACarson Helicopters Inc · Perkasie, PABuilt 1979 · S/N 79-23293 N125FHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 79-23307 N13FHBrainerd Helicopters Inc · Leesburg, FLBuilt 1981 · S/N 79-23353 N160AQCormorant Venture LLC · Irvine, CABuilt 1982 · S/N 81-23588 N160CDUc Helitanker 1 LLC · Arcadia, CABuilt 1980 · S/N 80-23507 N160EQPolar Star Corp · Kalispell, MTBuilt 1978 · S/N 78-23004 N166DFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1983 · S/N 83-23877 N17FHBrainerd Helicopters Inc · Leesburg, FLBuilt 1981 · S/N 80-23469 N233AJPatriot Aviation Inc · Greenville, DEBuilt 1982 · S/N 82-23685 N260NWNorthwest Helicopters LLC · Olympia, WABuilt 1984 · S/N 84-24025 N290THTimberline Helicopters Inc · Sandpoint, IDBuilt 1979 · S/N 79-23290 N371SHSkydance Blackhawk Operations LLC · Minden, NVBuilt 1979 · S/N 79-23284 N381SHSkydance Blackhawk Operations LLC · Minden, NVBuilt 1979 · S/N 79-23329 N391SHSkydance Blackhawk Operations LLC · Minden, NVBuilt 1979 · S/N 79-23273 N434THTimberline Helicopters Inc · Sandpoint, IDBuilt 1981 · S/N 80-23434 N464NWNorthwest Helicopters LLC · Olympia, WABuilt 1979 · S/N 79-23338 N563DJTimberline Helicopters Inc · Sandpoint, IDBuilt 1982 · S/N 81-23563 N600PVSikorsky Aircraft Corp · Stratford, CTBuilt 1980 · S/N 79-23298 N605PGPacific Gas And Electric Co · Vacaville, CABuilt 1980 · S/N 80-23492 N606PGPacific Gas And Electric Co · Vacaville, CABuilt 1981 · S/N 81-23561 N60CUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 80-23499 N60XPBrown Helicopter Inc · Pensacola, FLBuilt 1987 · S/N 87-24610 N61AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N 87-24661 N620TJTimberline Helicopters Inc · Sandpoint, IDBuilt 1982 · S/N 81-23620 N62CUCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1980 · S/N 80-23479 N672MPMp Aviation LLC · Post Falls, IDBuilt 1987 · S/N 87-24674 N683DNRogerson Kratos · Pasadena, CABuilt 1982 · S/N 8223683 N684DNRogerson-Kratos · Pasadena, CABuilt 1981 · S/N 80-23472 N685DNRogerson Kratos · Pasadena, CABuilt 1980 · S/N 80-23430 N705THTimberline Helicopters Inc · Sandpoint, IDBuilt 1983 · S/N 82-23705 N70KFlorida State Guard · Tallahassee, FLBuilt 1983 · S/N 83-23873 N763TWHawkeye Helicopter LLC · Lyndon, KSBuilt 1981 · S/N 80-23459 N781QBBrown Helicopter Inc · Pensacola, FLBuilt 1980 · S/N 80-23489 N802PJPj Helicopters Inc · Red Bluff, CABuilt 1980 · S/N 79-23278 N803PJPj Helicopters Inc · Red Bluff, CABuilt 1978 · S/N 78-23007 N804PJPj Helicopters Inc · Red Bluff, CABuilt 1978 · S/N 78-22998 N805PJPj Helicopters Inc · Red Bluff, CABuilt 1978 · S/N 82-23704 N80BHJambb LLC · La Verne, CABuilt 1987 · S/N 87-24660 N8286High Performance Helicopters Corp · Crestline, CABuilt 1979 · S/N 79-23286 N83BHJambb LLC · La Verne, CABuilt 1987 · S/N 87-24668 N963NWNorthwest Helicopters LLC · Olympia, WABuilt 1981 · S/N 80-23421 N9FHBrainerd Helicopters Inc · Leesburg, FLBuilt 1981 · S/N 80-23461

Back to GE T700-GE-700