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.
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
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.
N158JZNorth American T-6G · S/N 49-3158N171ESCessna 182P · S/N 18260964N1837JPiper PA-28-140 · S/N 28-24272N18JZPiper PA-18 · S/N 18223N21RDRobert Darling KITFOX III · S/N 1059N25JZNorth American TB-25J · S/N 44-86797N274JZPiper/Cub Crafters PA-18-150 · S/N 9921CCN281DSCirrus Design SR22 · S/N 2534N2833SPiper PA-28-161 · S/N 28-7916458N2869DNorth American/Aero Classics P-51D · S/N 44-84390N319JZRyan Aeronautical ST3KR · S/N 1823N414JZCessna 414A · S/N 414A0266N48772Ryan Aeronautical ST3KR · S/N 2089N53190Ryan Aeronautical ST3KR · S/N 1477N542LCMoore Thomas C VANS RV-7A · S/N 70287N578JZPilatus PC-12/45 · S/N 578N58JZBeech 58 · S/N TH-710N6059TCessna 150D · S/N 15060759N611RSBeech A36 · S/N E-982N7154FCessna 150F · S/N 15063754N735BQCessna 182Q · S/N 18265298N75JZBoeing A75 · S/N 75-038N80496Cessna 172M · S/N 17266620N85YMMichael Speers SLING TSI · S/N 600SKN86JZNorth American F-86F · S/N 52-4959N88JZGrumman TBM-3 · S/N 85794N8964GCessna 182N · S/N 18260504N933GCCanadair T-33 · S/N 306
Back to Mckinleyville, CA