Mckinleyville, CA

Registered aircraft · 28

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'CA' AND g.registrant_city = 'MCKINLEYVILLE'
  ORDER BY g.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.

N158JZNorth American T-6G · S/N 49-3158Built 1949 · Acv Group LLCN171ESCessna 182P · S/N 18260964Built 1972 · Fenton Richard R TrusteeN1837JPiper PA-28-140 · S/N 28-24272Built 1968 · Tolley Derek EvanN18JZPiper PA-18 · S/N 18223Acv Group LLCN21RDRobert Darling KITFOX III · S/N 1059Built 1991 · Lesher Caleb JN25JZNorth American TB-25J · S/N 44-86797Acv Group LLCN274JZPiper/Cub Crafters PA-18-150 · S/N 9921CCBuilt 2001 · Acv Group LLCN281DSCirrus Design SR22 · S/N 2534Built 2007 · Boughton KyleN2833SPiper PA-28-161 · S/N 28-7916458Johanson Lawrence Gco TrusteeN2869DNorth American/Aero Classics P-51D · S/N 44-84390Built 1944 · Acv Group LLCN319JZRyan Aeronautical ST3KR · S/N 1823Built 1942 · Acv Group LLCN414JZCessna 414A · S/N 414A0266Acv Group LLCN48772Ryan Aeronautical ST3KR · S/N 2089Acv Group LLCN53190Ryan Aeronautical ST3KR · S/N 1477Built 1942 · Acv Group LLCN542LCMoore Thomas C VANS RV-7A · S/N 70287Built 2004 · Lesher Caleb JN578JZPilatus PC-12/45 · S/N 578Built 2004 · Acv Group LLCN58JZBeech 58 · S/N TH-710Built 1976 · Acv Group LLCN6059TCessna 150D · S/N 15060759Built 1964 · Sible AndrewN611RSBeech A36 · S/N E-982Built 1976 · Wickman William SN7154FCessna 150F · S/N 15063754Built 1966 · Fenton Richard TrusteeN735BQCessna 182Q · S/N 18265298Built 1976 · Sayre Daniel EN75JZBoeing A75 · S/N 75-038Built 1938 · Acv Group LLCN80496Cessna 172M · S/N 17266620Built 1976 · Bickel Gregory AN85YMMichael Speers SLING TSI · S/N 600SKBuilt 2025 · Speers Michael CN86JZNorth American F-86F · S/N 52-4959Built 1952 · Acv Group LLCN88JZGrumman TBM-3 · S/N 85794Built 1945 · Acv Group LLCN8964GCessna 182N · S/N 18260504Built 1970 · Sandige David JN933GCCanadair T-33 · S/N 306Built 1954 · Acv Group LLC
Back to Mckinleyville, CA