Morgan Hill, CA
Registered aircraft · 50
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 = 'MORGAN HILL' 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 = 'MORGAN HILL' 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.
N1179BLuscombe 8A · S/N 5806N1222KKruger Randal L LANCAIR 320 · S/N 358-320-116N1225MCessna 337F · S/N 33701425N12479Cessna 172M · S/N 17262007N16YBBeech 95-B55 (T42A) · S/N TC-1688N17234Piper J-2 · S/N 1014N18794Cessna C-38 · S/N 401N1931SCarden Richard Otis GLASTAR · S/N 5392N201EMooney M20J · S/N 24-0912N2053RRogers Tim SA300 · S/N 1511N21542Cessna 182P · S/N 18261703N222SMBeech V35B · S/N D-9958N23015Cessna 150H · S/N 15068678N262SRSamuel Taylor Ray RV-8 · S/N 80262N2669NCessna 340A · S/N 340A0735N2789JCessna A150M · S/N A1500601N2828KCessna 180K · S/N 18053091N2956APiper PA-28-236 · S/N 28-7911269N3141RCessna 182L · S/N 18258541N3330HEngineering & Research 415-CD · S/N 3955N3382WPiper PA-32-260 · S/N 32-237N380BWCirrus Design SR22T · S/N 2157N4364HPiper PA-15 · S/N 15-149N46737Cessna 172K · S/N 17257461N488EAPiper PA46R-350T · S/N 4692016N526BCSchempp-Hirth DISCUS B · S/N 244N5322DPiper PA46-500TP · S/N 4697074N5500GCessna 172L · S/N 17260300N5899JBeech S35 · S/N D-7880N615ABBeech 95-B55 (T42A) · S/N TC-815N6168YClement James WITTMAN TAILWIND W10 · S/N JC5N6244JPiper PA-28-151 · S/N 28-7615343N654CMCanadair CL-600-2B16 · S/N 5009N693MMMooney M20C · S/N 690078N707FBSocata TBM 700 · S/N 177N71504Luscombe 8A · S/N 2931N717AFCirrus Design SR22T · S/N 8841N721KKCirrus Design SR22T · S/N 0193N7668MCessna 175 · S/N 55968N7754KPiper PA-20 · S/N 20582N7791WPiper PA-28-180 · S/N 28-1801N788SRCirrus Design SR22 · S/N 2887N791MMPiper PA-46-701TP · S/N 46020008N82FBCessna 182P · S/N 18263094N8377RPiper PA-28-140 · S/N 28-22254N8717YPiper PA-30 · S/N 30-1868N8994SCessna 150F · S/N 15062294N900EWSocata TBM 700 · S/N 1096N927WCMiller C/Miller W PIETENPOL/MILLER · S/N 001N942CPBeech 58TCA · S/N TK-61
Back to Morgan Hill, CA