Tulare, CA
Registered aircraft · 42
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 = 'TULARE' 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 = 'TULARE' 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.
N110RTLeading Edge Aerial Tech PV40X · S/N 11362N1131TCaldwell Alexander Scott VANS ACFT RV3 · S/N 11222N1376SCessna 182P · S/N 18264938N14740Bellanca 17-30A · S/N 74-30642N1572FFreitas OFF RD MTR Sports CCX-2000 · S/N CCX-2000-0048N162MHiller UH-12A · S/N 238N169SAXag P100 PRO · S/N 8219352K12T8N170SAXag P100 PRO · S/N 82193523Y81YN1YDCessna 210J · S/N 21059105N2105WBeech C23 · S/N M-1433N26456Grumman American Avn. AA-5A · S/N AA5A0600N299VMBeech C90 · S/N LJ-1125N332RVConner Michael A RV-3 · S/N 332N33CJTextron 525C · S/N 525C0412N340USXag P100 PRO · S/N 82193472N49XN360AVIsrael Aircraft Industries GULFSTREAM G150 · S/N 240N360DFTextron B300 · S/N FL-1354N3888YCessna 210D · S/N 21058388N414MVMichael L Groah PIETENPOL · S/N 001N434SVXag P150 · S/N 186324P18223449T8C50N43921Texas Helicopter OH-13E/M74 · S/N 76-003N445HPBeech B36TC · S/N EA-445N49286Boeing A75N1(PT17) · S/N 75-329N4JXBeech V35B · S/N D-9642N5485PPiper PA-24-250 · S/N 24-546N54ACSchempp-Hirth NIMBUS 3/24.5 · S/N 58N55072Bellanca 7ECA · S/N 1269-78N5558DBeech H35 · S/N D-5080N5653RMaule MX-7-180 · S/N 11001CN5831KBeech S35 · S/N D-7840N5931TCessna 150D · S/N 15060631N6006EBeech K35 · S/N D-5909N68SAXag P100 PRO · S/N 8219352G8L74N846DCDJI AGRAS T50 · S/N 1581F6BUB245F001G15XN8594VBellanca 7GCBC · S/N 799-75N8697EPiper PA-28-151 · S/N 28-7615148N903BBell 47D1 · S/N 847N9152XWSK PZL Mielec PZL M18B · S/N 1Z026-30N92433Cessna 182N · S/N 18260203N924SDHawker Beechcraft B300 · S/N FL-693N96668Cessna 182Q · S/N 18266801N980FRCompagnie Daher TBM 700 · S/N 1642Registration pending
Back to Tulare, CA