Skip to content

Warner SCARAB series

Registered aircraft · 71

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 ('64502')
  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 ('64502')
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.

N757FKLafayette Foundation · Fort Lupton, COBuilt 2010 · S/N 1972 N758VRopkey Fred N · Indianapolis, INBuilt 1930 · S/N 339 N771VSalak Terrance L · Geneva, ILBuilt 1930 · S/N 352 N8343C C Air Corporation · Lancaster, CABuilt 1980 · S/N DS-200 N854VWest Thomas L · Healdsburg, CAS/N 3269 N862VRegistered aircraftBuilt 1930 · S/N 3276 N863VSnyder Kenneth C · Lonsdale, MNBuilt 1930 · S/N 3278 N8640Plane Fun Inc Tr Trustee · Snellville, GABuilt 1929 · S/N 53 N86LLWingnut Inc · Wilmington, DEBuilt 1986 · S/N 62 N8782Nichols Charles F Trustee · Baldwin Park, CABuilt 1929 · S/N 167 N8793Bowe Walter C Trustee · Sonoma, CAS/N 178 N8796Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1929 · S/N 181 N900TPTsi Holdco Inc · Virginia Beach, VABuilt 2003 · S/N 001TP N9095Cook Charles Nicholas · Fort Worth, TXS/N 155 N9384Cournoyer John J · Ellsinore, MOBuilt 1933 · S/N 2514 N9396Glover William S · Mount Pleasant, TXBuilt 1933 · S/N 1606 N9397Currie Richard W · Woodland, CABuilt 1933 · S/N 2522 N9484Williams David Russell Jr · Bellevue, WABuilt 1934 · S/N 1607 N957VRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1934 · S/N 2525 N957WAdkisson Wanda M · Hammond, ILFirst renewal noticeBuilt 1930 · S/N 39 N970EJanus William W · Belchertown, MABuilt 1929 · S/N W-108

Back to Warner SCARAB series