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.

N10057Triple Tree Aerodrome Inc · Woodruff, SCBuilt 1929 · S/N 810 N101YSnj Component Holdings LLC · Kalispell, MTBuilt 1930 · S/N 3272 N110SPHolliday Mark E · Lake Elmo, MNBuilt 1931 · S/N 6W13 N11221Gray Eagle Farms LLC · Southampton, NJBuilt 1938 · S/N 3415 N11223Hoover Michael B · Ridgeland, WIS/N 3416 N11254Daniel Sharon L · Southampton, NJBuilt 1931 · S/N 3457 N113YSparrowhawk Aviation LLC · Moraine, OHS/N 3297 N11715Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 12W-2040 N12344Lyons James P · Lake Suzy, FLS/N 6W-38 N12350Binkley David P Trustee · Sedona, AZBuilt 1932 · S/N 6W39 N124YHaley Billie Jo · San Martin, CABuilt 1930 · S/N 3303 N127YDeno Gerald G · Battle Creek, MIBuilt 1930 · S/N 3287 N1290Weeks Kermit · Polk City, FLBuilt 1971 · S/N LCNC 1967 N130YRichards T D · Saint Jo, TXBuilt 1930 · S/N 3310 N140YDream Wacos LLC · Oklahoma City, OKS/N 3317 N143YWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 3417 N15641Hurdle Jack M II · Senoia, GABuilt 1935 · S/N 1000 N1649Rhinebeck Aerodrome Museum · Red Hook, NYS/N 1649 N18629Bowe Walter C Trustee · Sonoma, CAS/N 6W00 N18642Historic Aircraft Restoration Museum · Saint Louis, MOBuilt 1933 · S/N 6W53 N2009VWeeks Kermit · Polk City, FLBuilt 2003 · S/N 065 N204KBradley Gary C · Orchard Park, NYBuilt 1929 · S/N 30 N2203Windward Aviation Inc · Tukwila, WABuilt 1972 · S/N 535/17 N252NPioneer Flight Museum · Kingsbury, TXS/N W-512 N255MSHodges Mcneill Jr · Andersonville, GABuilt 2004 · S/N 1 N258NWingnut Inc · Wilmington, DEBuilt 1930 · S/N W-518 N26473Jasper Ralph Lane · Biloxi, MSBuilt 1940 · S/N 26 N265NFlying Plane LLC · Bartow, FLBuilt 1930 · S/N W-514 N278HWestern Antique Aeroplane And Automobile Museum · Hood River, ORS/N 20 N2890Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1933 · S/N 2509 N289HSilver Ranch Airpark Inc · Jaffrey, NHBuilt 1929 · S/N 5 N324NAerotrack Inc · Hemet, CABuilt 1931 · S/N 3003 N34304Sheeree Corp · Wilmington, DES/N 49 N412WAlfred And Lois Kelch Aviation Museum Inc · Brodhead, WIBuilt 1990 · S/N 2013-1990 N425EDDoyle Mary · Hampton, IABuilt 1975 · S/N 425 N443WWagner Paul D · Argyle, WIS/N 12Q2009 N4725Jenkins George Merritt · Wayne, PABuilt 1928 · S/N 120 N510YFlying Plane LLC · Bartow, FLS/N R-409 N533WCowell Norman B · Lomita, CABuilt 1930 · S/N 5W70 N561MRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1929 · S/N 801 N607MDream Waco LLC · Oklahoma City, OKS/N 183 N6204Neely James B · Kane, PABuilt 2023 · S/N 001 N62103August Aero LLC · Kalispell, MTBuilt 1993 · S/N 001 N632YKhalid Rauf J · Indianapolis, INBuilt 1930 · S/N 3343 N638MWestern North Carolina Air Museum · Hendersonville, NCBuilt 1930 · S/N 213 N65DSBrowett Donald A · Independence, MOBuilt 1966 · S/N 2 N663YSnyder Kenneth C · Lonsdale, MNBuilt 1930 · S/N 3356 N713SWood John M · Hernando, FLBuilt 1968 · S/N 11 N72517Smith James E Trustee · Kalispell, MTBuilt 1980 · S/N H-1 N729VClark Kenneth · Claremore, OKBuilt 1930 · S/N 295

Back to Warner SCARAB series