Chino, CA
Registered aircraft · 178
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 = 'CHINO' 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 = 'CHINO' 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.
N101RRCessna 501 · S/N 5010241N10GNGrumman HU-16B · S/N 146427Registration pendingN12604Cessna 172M · S/N 17262106N12VSVan Santen Donald S RV7 · S/N 71542N13039Cessna 172M · S/N 17262456N130AMYakovlev YAK-3U · S/N 170101N138AMLockheed P-38J · S/N 44-23314N14144North American T-28D · S/N 51-7533N1503UCessna U206F · S/N U20602228N153WSCessna 170B · S/N 25355N15720Waco YKS-6 · S/N 4412N15HMCulver PQ-14B · S/N N-839N16682Fairchild 24 C8F · S/N 3107N18164Cessna 150L · S/N 15073836N186AMNorth American/Sharpe F86F · S/N 52-5012N188SJEADS Socata TBM 700 · S/N 69N190RFFocke Wulf Flugzeugbau FW 190A-9 · S/N 980 574N19GTFolland GNAT T 1 · S/N XP538N2050BLuscombe 8A · S/N 6477N2086AAeronca 7BCM · S/N 47-1258AN212AMHispano Aviacion HA-200 SAETA · S/N HA20-83N218PROrdini Paul R FLIGHTSTAR IISC · S/N 365N2210XPiper PA-28-161 · S/N 28-7916351N2211Diehl SYI-1 · S/N 1N221BBMooney M20C · S/N 690006N2231NCessna 140 · S/N 12467N225YYAtwood Leon A MODEL 1 · S/N T-6N235SRPiper PA-28-161 · S/N 2842182N23EDNagahisa Etsuro SMYTH SIDEWINDER · S/N 212445N23JCessna 310I · S/N 310I0108N240HHConvair 240-1 · S/N 47N2494ECessna 182R · S/N 18268207N25CHPitts Aerobatics S-2B · S/N 5106N276TCSikorsky S-76A · S/N 760061N28ZAZenair CH 2000 · S/N 200028N2946RCessna 310G · S/N 310G0146N2GPBeech 60 · S/N P-56N3025Grumman G-58A · S/N 739AN304SBPzl-Mielec SB-LIM2 (MIG 15 UTI) · S/N 1A03504N305TACessna 305A · S/N 22443N3119ACessna 170B · S/N 25763N3131GAichi Tokei D3A 99 · S/N 3179N313QGloster GLOSTER METEOR T7 · S/N 45/356460N31518Fighter Rebuilders GOODYEAR-REBUILDER · S/N 0020N3182Great Lakes 2T-1A-E · S/N 6621-G-312N3287VBalloon Works FIREFLY 8B-15 · S/N F8B-549N3360GBoeing P-12E · S/N 32-17N3363PPiper PA-23-160 · S/N 23-1320N3375GNorth American SNJ-5 · S/N 90790N3378GBoeing P26 · S/N 33123
Back to Chino, CA