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

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 = 'OJAI' ORDER BY g.n_number

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 = 'OJAI'
  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 = 'OJAI'
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.

N2083RCessna 182G · S/N 18255283Built 1964 · Schutze Eric D Trustee N24069Taylorcraft BC-65 · S/N 1604Built 1939 · Crawford Deborah Lys Martin Executrix N3060WBeech A36 · S/N E-488Registration pendingBuilt 1973 N321RHBellanca 17-30A · S/N 74-30657Torrey Daniel B N32759Piper J3C-65 · S/N 5594Icarus Copters LLC N33011Piper J3C-65 · S/N 5770Built 1940 · Schutze Eric D N3703JCessna 150G · S/N 15065003Silver And Associates LLC N441RADiamond Aircraft Ind DA 40 · S/N 40.916Built 2008 · Pacific Coast University LLC N463LBeech B-60 · S/N P-463Built 1978 · Silver Development & Associates Inc N494FLPiper PA-28-140 · S/N 28-7125309Built 1971 · Williams Mark J N517BRTextron T206H · S/N T20609605Built 2020 · J Bar Aviation LLC N5397ZPiper PA-22-108 · S/N 22-9167Built 1961 · Schutze Richard P N58079Mooney M20J · S/N 24-1638Byrne David P N62065Piper J3C-65 · S/N 13024Built 1944 · Schutze Eric D Trustee N6829NMooney M-20G · S/N 680110Williams Mark J N700PEAirbus Helicopters AS 350B3 · S/N 8406Built 2017 · Centaurus Flight LLC N720RKCessna 182S · S/N 18280055Long Philip Charles N73267Cessna 172M · S/N 17267344Built 1976 · Schutze Eric D N750DADoug A Dugger CH 750 CRUZER · S/N C75-10166Parkhill Lawrence N758MHCessna R172K · S/N R1723201Built 1979 · Fantasy Flyer LLC N82413Aeronca 7AC · S/N 7AC-1047Built 1946 · Schutze Karen L N8282RBellanca 17-30A · S/N 30468Built 1972 · Torrey Daniel B N85168Aeronca 7AC · S/N 7AC-3900Schutze Eric D Trustee N8731VBellanca 7ECA · S/N 1103-75Built 1975 · Schutze Eric D Trustee N88234Piper J3C-65 · S/N 15851Built 1946 · Dimaculangan Jose D N88ASLet BLANIK L-13 · S/N 026723Schutze Richard P Trustee N91841Schweizer SGU 2-22 · S/N 14Built 1946 · Schutze Richard P Trustee N98425Piper J3C-65 · S/N 18612Built 1946 · Byrne David P

Back to Ojai, CA